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-07T17:16:55.790467+00:00","dedupe_key":"signal_enriched:news_delta:b0fbc93c7c92a692","evidence_event_ids":["evt_a3ae1355e7a2"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE8wQkwyTS03d3YtSHI2NWt1YTVtLVhFV0tMMkFLMURFbGRvTl9YTEY4ME9PanJkMEo0RlF3NlBxV19pWnZuNVVOSGxVQW0ycmlaWVduRHREUl8wV1g0SURvM1FLNWR6LWR1MDBjWW1nYng3WlAydldZQVpyQXpiQQ?oc=5","as_of":"2026-04-07T17:16:55.790467+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/CBMifkFVX3lxTE8wQkwyTS03d3YtSHI2NWt1YTVtLVhFV0tMMkFLMURFbGRvTl9YTEY4ME9PanJkMEo0RlF3NlBxV19pWnZuNVVOSGxVQW0ycmlaWVduRHREUl8wV1g0SURvM1FLNWR6LWR1MDBjWW1nYng3WlAydldZQVpyQXpiQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_82318ffeae4c039b","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-07T20:34:48.275357+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE8wQkwyTS03d3YtSHI2NWt1YTVtLVhFV0tMMkFLMURFbGRvTl9YTEY4ME9PanJkMEo0RlF3NlBxV19pWnZuNVVOSGxVQW0ycmlaWVduRHREUl8wV1g0SURvM1FLNWR6LWR1MDBjWW1nYng3WlAydldZQVpyQXpiQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMifkFVX3lxTE8wQkwyTS03d3YtSHI2NWt1YTVtLVhFV0tMMkFLMURFbGRvTl9YTEY4ME9PanJkMEo0RlF3NlBxV19pWnZuNVVOSGxVQW0ycmlaWVduRHREUl8wV1g0SURvM1FLNWR6LWR1MDBjWW1nYng3WlAydldZQVpyQXpiQQ?oc=5","source_event_id":"evt_a3ae1355e7a2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5fa58bfcb4c1d34b","published_at":"2026-04-07T16:38:01+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"United States","relevance":"directly involved","symbol":"USA","type":"country"},{"asset_class":"political","name":"Iran","relevance":"directly affected","symbol":"IRN","type":"country"}],"event_type":"conflict","information_gaps":["Details on the extent of damage from the strikes are unclear.","The specific military targets hit have not been disclosed."],"key_facts":["U.S. strikes occurred on Kharg Island, Iran.","Trump warned of catastrophic consequences, stating 'a whole civilization will die tonight.'"],"numeric_claims":[],"primary_claim":"The U.S. has struck Iranian military targets on Kharg Island.","relevance_score":0.9,"sentiment":"negative","source_quality":"high","summary":"The U.S. has conducted military strikes on Iran's Kharg Island, targeting Iranian military assets, amidst escalating tensions and warnings from Trump about severe consequences.","topics":["military conflict","U.S.-Iran relations","geopolitical tensions"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"U.S. strikes Iran\u2019s Kharg Island as Trump warns \u2018a whole civilization will die tonight\u2019 The Washington Post Live Updates: US-Israeli strikes hit Iran\u2019s oil, rail and bridges ahead of Trump deadline AP News US has struck Iranian military targets on Kharg Island. Here\u2019s what we know about it CNN US hits military targets on Iran's Kharg Island, Vance says no change to strategy Reuters Trump Floats Seizing Iran Oil as He Weighs Chinese Leverage Play bloomberg.com","title":"U.S. strikes Iran\u2019s Kharg Island as Trump warns \u2018a whole civilization will die tonight\u2019 - The Washington Post","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 41583 in events