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-08T00:41:56.447664+00:00","dedupe_key":"signal_enriched:news_delta:cb512631d1830c1c","evidence_event_ids":["evt_0120a7f52032"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxNYXNzR2UwZWFSbE5fMVg3X2p3blc3a3dIRWhRRzU4N0cwVE0xTER6TkdfZVE3NEI5WHBTLXJBb01xa2lGQWRNSERFWnRZeHJtYkpiem5YeDAtQW9GU1lJSFVycVh5TlJEenVZTVpwOHBYU2Z1NS1hOFlOU3ItLTBJWnREbXhGenJaX0E?oc=5","as_of":"2026-04-08T00:41:56.447664+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/CBMiigFBVV95cUxNYXNzR2UwZWFSbE5fMVg3X2p3blc3a3dIRWhRRzU4N0cwVE0xTER6TkdfZVE3NEI5WHBTLXJBb01xa2lGQWRNSERFWnRZeHJtYkpiem5YeDAtQW9GU1lJSFVycVh5TlJEenVZTVpwOHBYU2Z1NS1hOFlOU3ItLTBJWnREbXhGenJaX0E?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_43968f37a723aeb7","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-08T00:43:43.790811+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxNYXNzR2UwZWFSbE5fMVg3X2p3blc3a3dIRWhRRzU4N0cwVE0xTER6TkdfZVE3NEI5WHBTLXJBb01xa2lGQWRNSERFWnRZeHJtYkpiem5YeDAtQW9GU1lJSFVycVh5TlJEenVZTVpwOHBYU2Z1NS1hOFlOU3ItLTBJWnREbXhGenJaX0E?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/CBMiigFBVV95cUxNYXNzR2UwZWFSbE5fMVg3X2p3blc3a3dIRWhRRzU4N0cwVE0xTER6TkdfZVE3NEI5WHBTLXJBb01xa2lGQWRNSERFWnRZeHJtYkpiem5YeDAtQW9GU1lJSFVycVh5TlJEenVZTVpwOHBYU2Z1NS1hOFlOU3ItLTBJWnREbXhGenJaX0E?oc=5","source_event_id":"evt_0120a7f52032","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0f634a9816d96980","published_at":"2026-04-07T23:34:28+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Pete Hegseth","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"The Washington Post","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"U.S. officials (unnamed)","relevance":"medium","symbol":"","type":"group"}],"event_type":"geopolitical_risk","information_gaps":["What specific statements Hegseth made about the Iran war are disputed.","Which officials made the statements and what evidence they cited.","When the events/claims occurred (timeline) and whether they relate to a particular operation or period.","Whether the dispute has any policy or operational consequences near-term."],"key_facts":["The Washington Post headline states that officials say Hegseth\u2019s boastful claims about the Iran war contradict reality.","The provided text includes only the headline and a partial source summary; no specific claim details, dates, or evidence are included in the supplied content."],"numeric_claims":[],"primary_claim":"Officials told The Washington Post that Pete Hegseth\u2019s boastful claims about the Iran war contradict reality.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The Washington Post reports that officials say Pete Hegseth\u2019s public claims about U.S. actions in the Iran war are exaggerated or inconsistent with reality. The signal does not provide specific details of the disputed claims or the officials\u2019 evidence.","topics":["U.S. defense/politics","Iran war claims","official rebuttal","credibility/dispute"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Hegseth\u2019s boastful claims about Iran war contradict reality, officials say The Washington Post Hegseth Likens Easter Rescue of U.S. Airman to Resurrection of Jesus Christ The New York Times The HH-60W helped rescue a pilot in Iran. Here\u2019s why the Air Force might not buy more. breakingdefense.com DR MARC SIEGEL: Bleeding, alone and hunted -- a downed colonel\u2019s miracle survival Fox News The U.S. fighter jet was downed in Iran by a shoulder-fired missile NBC News","title":"Hegseth\u2019s boastful claims about Iran war contradict reality, officials say - 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 2500 in events