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:10:40.630083+00:00","dedupe_key":"signal_enriched:news_delta:63590114c9986c68","evidence_event_ids":["evt_54c1d7a550bd"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTFBtYUxneVBlRUFsR1huWDdhNnZwejctZFZkMUFvc2VJc2VlY0pJTDZUakczSFNrTnZtU0JoWjdQMzdydnVxMG00aHhjeHhKMjMwaWVuYjFxbXZPZXhiV1k4NTFtaTliSXpOcTFTZllRcXZxVG82T29sbkZSQdIBgAFBVV95cUxQQVI1aFhKN1NZVjVlV0FiVXdYSWlfZk5YS1EwZEtwU1A1Y0h2MnU3YmpGR0RSaS1OWkFKZV9COUdlb1d4N0t4QnNMWUMxUi0xRGxiT1Izc2lHazE2SGp5SW53dVQ1bV9oM1dZREVKV0I0WHlIZ3BvdDJPVURXZFJRVg?oc=5","as_of":"2026-04-08T00:10:40.630083+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/CBMie0FVX3lxTFBtYUxneVBlRUFsR1huWDdhNnZwejctZFZkMUFvc2VJc2VlY0pJTDZUakczSFNrTnZtU0JoWjdQMzdydnVxMG00aHhjeHhKMjMwaWVuYjFxbXZPZXhiV1k4NTFtaTliSXpOcTFTZllRcXZxVG82T29sbkZSQdIBgAFBVV95cUxQQVI1aFhKN1NZVjVlV0FiVXdYSWlfZk5YS1EwZEtwU1A1Y0h2MnU3YmpGR0RSaS1OWkFKZV9COUdlb1d4N0t4QnNMWUMxUi0xRGxiT1Izc2lHazE2SGp5SW53dVQ1bV9oM1dZREVKV0I0WHlIZ3BvdDJPVURXZFJRVg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f11446895b805cea","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:41:43.103126+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTFBtYUxneVBlRUFsR1huWDdhNnZwejctZFZkMUFvc2VJc2VlY0pJTDZUakczSFNrTnZtU0JoWjdQMzdydnVxMG00aHhjeHhKMjMwaWVuYjFxbXZPZXhiV1k4NTFtaTliSXpOcTFTZllRcXZxVG82T29sbkZSQdIBgAFBVV95cUxQQVI1aFhKN1NZVjVlV0FiVXdYSWlfZk5YS1EwZEtwU1A1Y0h2MnU3YmpGR0RSaS1OWkFKZV9COUdlb1d4N0t4QnNMWUMxUi0xRGxiT1Izc2lHazE2SGp5SW53dVQ1bV9oM1dZREVKV0I0WHlIZ3BvdDJPVURXZFJRVg?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTFBtYUxneVBlRUFsR1huWDdhNnZwejctZFZkMUFvc2VJc2VlY0pJTDZUakczSFNrTnZtU0JoWjdQMzdydnVxMG00aHhjeHhKMjMwaWVuYjFxbXZPZXhiV1k4NTFtaTliSXpOcTFTZllRcXZxVG82T29sbkZSQdIBgAFBVV95cUxQQVI1aFhKN1NZVjVlV0FiVXdYSWlfZk5YS1EwZEtwU1A1Y0h2MnU3YmpGR0RSaS1OWkFKZV9COUdlb1d4N0t4QnNMWUMxUi0xRGxiT1Izc2lHazE2SGp5SW53dVQ1bV9oM1dZREVKV0I0WHlIZ3BvdDJPVURXZFJRVg?oc=5","source_event_id":"evt_54c1d7a550bd","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9d088b8bc96cfa7a","published_at":"2026-04-07T22:38:26+00:00","publisher_domain":"cnbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Donald Trump","relevance":"primary decision-maker","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"counterparty to the suspended attack/ceasefire","symbol":"","type":"country"},{"asset_class":"geography","name":"Hormuz Strait","relevance":"condition tied to the suspension/ceasefire","symbol":"","type":"geographic_feature"},{"asset_class":"commodity","name":"U.S. oil price","relevance":"reported market reaction to the ceasefire/suspension","symbol":"","type":"market_indicator"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML and does not include the actual CNBC headline/body content; extraction is therefore grounded only in the provided headline and source summary snippets.","Exact wording of the Hormuz Strait condition (e.g., who determines \u201copening,\u201d what operational criteria) is not specified in the provided text.","Whether the \u201cattack\u201d suspension is the same as the \u201ctwo-week ceasefire\u201d referenced in other snippets is not explicitly confirmed within the provided CNBC-only content.","No specific start/end timestamps for the two-week period are included in the provided material."],"key_facts":["Trump suspended an Iran attack for two weeks (CNBC).","The suspension is subject to the Hormuz Strait opening (CNBC).","Multiple referenced live updates indicate a two-week ceasefire agreement between the U.S. and Iran (per the provided source summary snippets).","U.S. oil price reportedly fell sharply (CNBC snippet: down 14% to below $100) following the two-week ceasefire agreement (CNBC)."],"numeric_claims":[{"label":"Oil price move","value":"-14% (to below $100)"}],"primary_claim":"Trump suspended an Iran attack for two weeks, subject to the Hormuz Strait opening, according to CNBC.","relevance_score":0.86,"sentiment":"mixed","source_quality":"high","summary":"CNBC reports that Trump suspended an Iran attack for two weeks, contingent on conditions related to the opening of the Hormuz Strait. The development is linked to a near-term reduction in immediate conflict risk and coincides with a sharp drop in U.S. oil prices.","topics":["Iran-U.S. conflict","ceasefire","Hormuz Strait","oil prices","market reaction"]},"source":"CNBC","source_domain":"cnbc.com","source_url":"https://www.cnbc.com","summary":"Trump suspends Iran attack for two weeks, subject to Hormuz Strait opening CNBC Live updates: US, Iran say they have agreed to a two-week ceasefire AP News Trump suspends Iran attack for two weeks following dire threats Al Jazeera Iran war live: Trump announces two-week ceasefire as Iran says talks to begin Reuters U.S. oil price plunges 14% to below $100 after Trump agrees to two-week ceasefire in Iran war CNBC","title":"Trump suspends Iran attack for two weeks, subject to Hormuz Strait opening - CNBC","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 2444 in events