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-08T04:03:42.113738+00:00","dedupe_key":"signal_enriched:news_delta:16547d3dcee3d083","evidence_event_ids":["evt_d7270d29bdb3"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiywFBVV95cUxNMHV6WXllSGRpNVc2UVppUmdCZlVEMnBqUGl0R0c1YnlySktpOU9FSzNHMEg5RGZTNF96bDVCRUFoVnhsYmQxclpIUXVzb3hqRHZKWVBxWmV2SHgwMC1wT0ZZS3pqTjBOVlIwZXFFd0ZrOFRTNEkwQlZJR3BpMld5QXBiaDJnWXJvaFJVZXZ6YXp2RHFmblZxTGFidE1QZ0JtR3l4TjA5Y1RfVlpPTVV6V0FwN0llb2tITEpHME1kOTROS05yalloMGRmNA?oc=5","as_of":"2026-04-08T04:03:42.113738+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiywFBVV95cUxNMHV6WXllSGRpNVc2UVppUmdCZlVEMnBqUGl0R0c1YnlySktpOU9FSzNHMEg5RGZTNF96bDVCRUFoVnhsYmQxclpIUXVzb3hqRHZKWVBxWmV2SHgwMC1wT0ZZS3pqTjBOVlIwZXFFd0ZrOFRTNEkwQlZJR3BpMld5QXBiaDJnWXJvaFJVZXZ6YXp2RHFmblZxTGFidE1QZ0JtR3l4TjA5Y1RfVlpPTVV6V0FwN0llb2tITEpHME1kOTROS05yalloMGRmNA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ada257d9f29f0736","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T04:04:01.890229+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiywFBVV95cUxNMHV6WXllSGRpNVc2UVppUmdCZlVEMnBqUGl0R0c1YnlySktpOU9FSzNHMEg5RGZTNF96bDVCRUFoVnhsYmQxclpIUXVzb3hqRHZKWVBxWmV2SHgwMC1wT0ZZS3pqTjBOVlIwZXFFd0ZrOFRTNEkwQlZJR3BpMld5QXBiaDJnWXJvaFJVZXZ6YXp2RHFmblZxTGFidE1QZ0JtR3l4TjA5Y1RfVlpPTVV6V0FwN0llb2tITEpHME1kOTROS05yalloMGRmNA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiywFBVV95cUxNMHV6WXllSGRpNVc2UVppUmdCZlVEMnBqUGl0R0c1YnlySktpOU9FSzNHMEg5RGZTNF96bDVCRUFoVnhsYmQxclpIUXVzb3hqRHZKWVBxWmV2SHgwMC1wT0ZZS3pqTjBOVlIwZXFFd0ZrOFRTNEkwQlZJR3BpMld5QXBiaDJnWXJvaFJVZXZ6YXp2RHFmblZxTGFidE1QZ0JtR3l4TjA5Y1RfVlpPTVV6V0FwN0llb2tITEpHME1kOTROS05yalloMGRmNA?oc=5","source_event_id":"evt_d7270d29bdb3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"25682681a5a5b0f0","published_at":"2026-04-08T03:10:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Israel","relevance":"directly stated as the source of the ceasefire scope claim","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"party to the ceasefire referenced; also linked to rocket fire in Israel\u2019s Negev","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Lebanon","relevance":"explicitly excluded from the ceasefire scope per Israel","symbol":"","type":"country"},{"asset_class":"sovereign","name":"United States","relevance":"referenced as part of the US-Iran ceasefire context","symbol":"","type":"country"},{"asset_class":"person","name":"Benjamin Netanyahu","relevance":"named as saying Lebanon is not included","symbol":"","type":"person"},{"asset_class":"person","name":"Donald Trump","relevance":"named as commenting that uranium will be \u201ctaken care of\u201d","symbol":"","type":"person"},{"asset_class":"region","name":"Negev","relevance":"reported location of rocket fire impact on children","symbol":"","type":"region"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is largely HTML/CSS and does not include the substantive paragraphs; extraction relies on the provided headline and source summary snippets.","Exact ceasefire mechanism, start/end timing, and who is enforcing/agreeing to the terms are not specified in the provided text.","Trump\u2019s uranium comment lacks context (what action, by whom, and whether it refers to negotiations, sanctions, or military action).","The claim that Israel aims for a longer war in Iran is attributed to Politico in the summary, but the specific evidence/quote is not included in the provided text."],"key_facts":["Israel (via Netanyahu, per Israeli media cited) says a US-Iran ceasefire does not include Lebanon.","Trump says Iran\u2019s uranium will be \u201ctaken care of.\u201d","MDA reports three children were lightly injured in the Negev following Iranian rocket fire.","The live coverage characterizes Israel as aiming for a longer war in Iran while Trump demands a deal (attribution to Politico/coverage; exact wording not provided in the cleaned text)."],"numeric_claims":[{"label":"injured_children","value":"3"}],"primary_claim":"Israel says the US-Iran ceasefire does not include Lebanon.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"Israel says a US-Iran ceasefire would not include Lebanon, while Trump says Iran\u2019s uranium issue will be handled. The live coverage also reports Israeli rocket/air activity impacts in Israel\u2019s Negev and ongoing political positioning around the ceasefire terms.","topics":["Middle East crisis","Iran-Israel tensions","ceasefire terms","Lebanon exclusion","rocket fire","uranium","US-Iran negotiations"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Middle East crisis live: Iran war ceasefire doesn\u2019t include Lebanon, says Israel; Trump says uranium will be \u2018taken care of\u2019 The Guardian Netanyahu says US-Iran ceasefire \u2018does not include Lebanon\u2019 Al Jazeera Israel aims for longer war in Iran, as Trump demands a deal Politico MDA: Three children lightly injured in Negev following Iranian rocket fire Haaretz Netanyahu backs Iran ceasefire, says Lebanon not included, Israeli media says Reuters","title":"Middle East crisis live: Iran war ceasefire doesn\u2019t include Lebanon, says Israel; Trump says uranium will be \u2018taken care of\u2019 - The Guardian","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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 4473 in events