SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T19:34:52.559856+00:00","dedupe_key":"signal_enriched:news_delta:aeb4d3a7a51531a1","evidence_event_ids":["evt_5a94b08746ce"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiyAFBVV95cUxPcWRqSzRGczJoQVVrVlhWU3kyUTNSeW90V0RKWjJCREt2MjlWdGxiQTdfTUNGOV8wNWJ5TXdQM3ZjOXBDVGxWYTVHa3NKS0UtMlk3WExWbUdnM0xtcUczZHlQVUVPMW4yYW5PQlFpWlE4M2Y5YjZITmZaZENTZU02MGxyLVBOZ1o1WkRtT1pkdTZCc2haRF9BenlOSGhObXFGRGtINUFQeEg3Y0VtQjlwSHdoNEc5aEctLVhVZUtsOUVKTnhrWGNKZQ?oc=5","as_of":"2026-04-08T19:34:52.559856+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/CBMiyAFBVV95cUxPcWRqSzRGczJoQVVrVlhWU3kyUTNSeW90V0RKWjJCREt2MjlWdGxiQTdfTUNGOV8wNWJ5TXdQM3ZjOXBDVGxWYTVHa3NKS0UtMlk3WExWbUdnM0xtcUczZHlQVUVPMW4yYW5PQlFpWlE4M2Y5YjZITmZaZENTZU02MGxyLVBOZ1o1WkRtT1pkdTZCc2haRF9BenlOSGhObXFGRGtINUFQeEg3Y0VtQjlwSHdoNEc5aEctLVhVZUtsOUVKTnhrWGNKZQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_fa22ef4650e99354","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-09T22:09:08.374310+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiyAFBVV95cUxPcWRqSzRGczJoQVVrVlhWU3kyUTNSeW90V0RKWjJCREt2MjlWdGxiQTdfTUNGOV8wNWJ5TXdQM3ZjOXBDVGxWYTVHa3NKS0UtMlk3WExWbUdnM0xtcUczZHlQVUVPMW4yYW5PQlFpWlE4M2Y5YjZITmZaZENTZU02MGxyLVBOZ1o1WkRtT1pkdTZCc2haRF9BenlOSGhObXFGRGtINUFQeEg3Y0VtQjlwSHdoNEc5aEctLVhVZUtsOUVKTnhrWGNKZQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"investors.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiyAFBVV95cUxPcWRqSzRGczJoQVVrVlhWU3kyUTNSeW90V0RKWjJCREt2MjlWdGxiQTdfTUNGOV8wNWJ5TXdQM3ZjOXBDVGxWYTVHa3NKS0UtMlk3WExWbUdnM0xtcUczZHlQVUVPMW4yYW5PQlFpWlE4M2Y5YjZITmZaZENTZU02MGxyLVBOZ1o1WkRtT1pkdTZCc2haRF9BenlOSGhObXFGRGtINUFQeEg3Y0VtQjlwSHdoNEc5aEctLVhVZUtsOUVKTnhrWGNKZQ?oc=5","source_event_id":"evt_5a94b08746ce","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2977542c4658bd59","published_at":"2026-04-08T12:00:00+00:00","publisher_domain":"investors.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equities","name":"Dow Jones futures","relevance":"high","symbol":"DJIA futures (implied)","type":"market_index_futures"},{"asset_class":"commodities","name":"Oil prices","relevance":"high","symbol":"Oil (unspecified benchmark)","type":"commodity"},{"asset_class":"other","name":"Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"Iran","relevance":"medium","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["No details on the exact oil benchmark (e.g., WTI vs Brent) or the magnitude/percentage of the oil move.","No timing context for when the ceasefire was announced or when the market reaction occurred.","No confirmation of the ceasefire terms or whether it is official vs reported.","The cleaned article text contains only styling/HTML fragments; no additional factual content beyond the headline/summary is available to extract."],"key_facts":["Headline states Dow Jones futures spike 1,300 points.","Headline states oil prices dive.","Headline links both moves to a Trump\u2013Iran ceasefire.","Article is presented as a \u201cWhat To Do Now\u201d investors piece (implies investment guidance, but details are not provided in the cleaned text)."],"numeric_claims":[{"label":"Dow Jones futures move","value":"+1,300 points"}],"primary_claim":"Dow Jones futures are spiking by 1,300 points and oil prices are diving on a Trump\u2013Iran ceasefire, per investors.com.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Investors.com reports a sharp move in U.S. equity index futures and oil prices tied to a Trump\u2013Iran ceasefire development. The headline indicates Dow Jones futures are up while oil prices are down.","topics":["market futures","Dow Jones","oil prices","Trump-Iran ceasefire","risk sentiment"]},"source":"investors.com","source_domain":"investors.com","source_url":"https://www.investors.com","summary":"Dow Jones Futures Spike 1,300 Points, Oil Prices Dive On Trump-Iran Ceasefire; What To Do Now investors.com","title":"Dow Jones Futures Spike 1,300 Points, Oil Prices Dive On Trump-Iran Ceasefire; What To Do Now - investors.com","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 8319 in events