SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxONTdnZHZEbVJSZXlBamZEbVhYWVI1RDh6czZieUtaMWpiQldvbmF1aHBFblFybVluWFBSNXVrUXZScUdINUZ2TFRNbThvejFfZmI3WEFwSHJ5c3UzT3VmS0Z4TUd3OWJiMHdER3dVQkZNeEZQQ1ZrSHZmandtZUhoU0ZwWGZWbGk2Vnp2aGZvbVBfeUh2WFE?oc=5","as_of":"2026-04-12T12:39:09.528445+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxONTdnZHZEbVJSZXlBamZEbVhYWVI1RDh6czZieUtaMWpiQldvbmF1aHBFblFybVluWFBSNXVrUXZScUdINUZ2TFRNbThvejFfZmI3WEFwSHJ5c3UzT3VmS0Z4TUd3OWJiMHdER3dVQkZNeEZQQ1ZrSHZmandtZUhoU0ZwWGZWbGk2Vnp2aGZvbVBfeUh2WFE?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_cd655d608bf824d7","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-12T12:40:49.434418+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxONTdnZHZEbVJSZXlBamZEbVhYWVI1RDh6czZieUtaMWpiQldvbmF1aHBFblFybVluWFBSNXVrUXZScUdINUZ2TFRNbThvejFfZmI3WEFwSHJ5c3UzT3VmS0Z4TUd3OWJiMHdER3dVQkZNeEZQQ1ZrSHZmandtZUhoU0ZwWGZWbGk2Vnp2aGZvbVBfeUh2WFE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxONTdnZHZEbVJSZXlBamZEbVhYWVI1RDh6czZieUtaMWpiQldvbmF1aHBFblFybVluWFBSNXVrUXZScUdINUZ2TFRNbThvejFfZmI3WEFwSHJ5c3UzT3VmS0Z4TUd3OWJiMHdER3dVQkZNeEZQQ1ZrSHZmandtZUhoU0ZwWGZWbGk2Vnp2aGZvbVBfeUh2WFE?oc=5","source_event_id":"evt_b5c3592aba0a","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"9f545999867b79f3","published_at":"2026-04-12T02:51:00+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Palantir","relevance":"Included in the 'do not like' AI stocks list per headline","symbol":"","type":"company"}],"event_type":"other","information_gaps":["The other two stocks (the second 'I Don't Like' stock and the 'I Love' stock) are not named in the provided text.","No article details, reasons, ratings, price targets, or timing catalysts are included in the signal.","No ticker symbols are provided for any of the stocks.","The author/analyst identity and whether this reflects a specific recommendation change are not provided."],"key_facts":["Headline mentions '2 AI Stocks I Don't Like (Including Palantir) and 1 I Love'.","Palantir is explicitly referenced as part of the 'I Don't Like' group."],"numeric_claims":[],"primary_claim":"The Yahoo Finance headline states that Palantir is among two AI stocks the author does not like, and there is one AI stock the author loves.","relevance_score":0.35,"sentiment":"mixed","source_quality":"unknown","summary":"The Yahoo Finance item is a list-style headline discussing three AI-related stocks: two the author says they do not like (including Palantir) and one they say they love. No further details are provided in the signal.","topics":["AI stocks","stock picks","Yahoo Finance"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"2 AI Stocks I Don't Like (Including Palantir) and 1 I Love Yahoo Finance","title":"2 AI Stocks I Don't Like (Including Palantir) and 1 I Love - Yahoo Finance","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_f15e94186ab4 in signals