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-08T22:21:15.507341+00:00","dedupe_key":"signal_enriched:news_delta:5991de6bfdfdb113","evidence_event_ids":["evt_82bffd91fb23"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMivwFBVV95cUxQanI0SzVzOGp2R0o1UjRlSzNHWjBNcXFrOTJLOFE3T283RVkyUHBONkFpdWg3emV1Z1dxRzBhSlVTcjRhX2dVWWI5QURkVkNsYWVOMXZSN0RtMFBMYmpIaTdHLWs2OEdKV0pUaGZEWlB4WWpqaWxxWlhEZjZEczdORlg4UWE2UkdVQ1dLM05MSWxLbmxKR1RjUXVQenJ3dnp5bXVBTTBOVjZlUFVSUWV1T0loQW5McTFmV2tJYTlNWQ?oc=5","as_of":"2026-04-08T22:21:15.507341+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/CBMivwFBVV95cUxQanI0SzVzOGp2R0o1UjRlSzNHWjBNcXFrOTJLOFE3T283RVkyUHBONkFpdWg3emV1Z1dxRzBhSlVTcjRhX2dVWWI5QURkVkNsYWVOMXZSN0RtMFBMYmpIaTdHLWs2OEdKV0pUaGZEWlB4WWpqaWxxWlhEZjZEczdORlg4UWE2UkdVQ1dLM05MSWxLbmxKR1RjUXVQenJ3dnp5bXVBTTBOVjZlUFVSUWV1T0loQW5McTFmV2tJYTlNWQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2db2b813726bc0ff","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:16:18.713524+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMivwFBVV95cUxQanI0SzVzOGp2R0o1UjRlSzNHWjBNcXFrOTJLOFE3T283RVkyUHBONkFpdWg3emV1Z1dxRzBhSlVTcjRhX2dVWWI5QURkVkNsYWVOMXZSN0RtMFBMYmpIaTdHLWs2OEdKV0pUaGZEWlB4WWpqaWxxWlhEZjZEczdORlg4UWE2UkdVQ1dLM05MSWxLbmxKR1RjUXVQenJ3dnp5bXVBTTBOVjZlUFVSUWV1T0loQW5McTFmV2tJYTlNWQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"economist.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMivwFBVV95cUxQanI0SzVzOGp2R0o1UjRlSzNHWjBNcXFrOTJLOFE3T283RVkyUHBONkFpdWg3emV1Z1dxRzBhSlVTcjRhX2dVWWI5QURkVkNsYWVOMXZSN0RtMFBMYmpIaTdHLWs2OEdKV0pUaGZEWlB4WWpqaWxxWlhEZjZEczdORlg4UWE2UkdVQ1dLM05MSWxLbmxKR1RjUXVQenJ3dnp5bXVBTTBOVjZlUFVSUWV1T0loQW5McTFmV2tJYTlNWQ?oc=5","source_event_id":"evt_82bffd91fb23","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"17ceae403c0a58ca","published_at":"2026-04-08T21:55:04+00:00","publisher_domain":"economist.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"The Economist","relevance":"source of claim","symbol":"","type":"publisher"},{"asset_class":"commodity/energy","name":"Energy markets","relevance":"affected market category","symbol":"","type":"market"}],"event_type":"geopolitical_risk","information_gaps":["No details are provided on which countries/actors are involved in the \u201cthird Gulf war.\u201d","No specific mechanisms are stated (e.g., supply disruption, shipping risk, sanctions) for how energy markets would be scarred.","No time horizon or magnitude (duration in months/years, price impact) is specified beyond \u201cfor a long time yet.\u201d","No specific energy commodities or tradable instruments are named."],"key_facts":["The Economist headline states that the \u201cthird Gulf war\u201d will \u201cscar energy markets for a long time yet.\u201d"],"numeric_claims":[],"primary_claim":"The third Gulf war will scar energy markets for a long time yet.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"The Economist argues that a \u201cthird Gulf war\u201d would have long-lasting damage effects on energy markets.","topics":["Gulf war","geopolitical risk","energy markets","market disruption","long-lasting impact"]},"source":"The Economist","source_domain":"economist.com","source_url":"https://www.economist.com","summary":"The third Gulf war will scar energy markets for a long time yet The Economist","title":"The third Gulf war will scar energy markets for a long time yet - The Economist","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 8503 in events