SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE9JVTFlSkV6R0JyQS1qTVNTU3VVRnQ2Z1hMa2Jma1M0c2lQa21Yd2hzdUladkNUeWh6Umo2RWp1dVJ2R0JrVjlOcWVBRUswbWx3ekIyQ2duZlIydw?oc=5","as_of":"2026-04-10T04:47:24.714800+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/CBMiWkFVX3lxTE9JVTFlSkV6R0JyQS1qTVNTU3VVRnQ2Z1hMa2Jma1M0c2lQa21Yd2hzdUladkNUeWh6Umo2RWp1dVJ2R0JrVjlOcWVBRUswbWx3ekIyQ2duZlIydw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_48ba4e7e81cb1bfb","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-10T04:47:59.605858+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE9JVTFlSkV6R0JyQS1qTVNTU3VVRnQ2Z1hMa2Jma1M0c2lQa21Yd2hzdUladkNUeWh6Umo2RWp1dVJ2R0JrVjlOcWVBRUswbWx3ekIyQ2duZlIydw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE9JVTFlSkV6R0JyQS1qTVNTU3VVRnQ2Z1hMa2Jma1M0c2lQa21Yd2hzdUladkNUeWh6Umo2RWp1dVJ2R0JrVjlOcWVBRUswbWx3ekIyQ2duZlIydw?oc=5","source_event_id":"evt_104ddad13109","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0dbc0c8fce0b38f2","published_at":"2026-04-09T22:51:51+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Keir Starmer","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign","name":"United Kingdom","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"","name":"Putin","relevance":"medium","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"medium","symbol":"","type":"country"},{"asset_class":"","name":"Europe (allies in Europe)","relevance":"medium","symbol":"","type":"region"},{"asset_class":"","name":"BBC","relevance":"low","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The provided article text is not actually present (only CSS/HTML boilerplate), so details beyond the headline and the supplied source summary cannot be verified.","No specific policy measures, timelines, or quantitative estimates for energy-cost impacts are included in the provided material.","The exact mechanism by which Trump/Putin affect UK energy costs is not specified in the provided excerpt."],"key_facts":["BBC headline quotes Keir Starmer: \u201cWe should not be at the mercy of events abroad.\u201d","Starmer said he is \u201cfed up\u201d with Trump and Putin affecting UK energy costs (as reflected in the provided source summary).","The Iran conflict is described as a warning that Britain must build resilience at home and with allies in Europe (as reflected in the provided source summary)."],"numeric_claims":[],"primary_claim":"Keir Starmer argued the UK should not be dependent on foreign events, pointing to Trump/Putin-driven effects on UK energy costs and using the Iran conflict as a warning to build resilience.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"UK Prime Minister Keir Starmer said Britain should not be \u201cat the mercy of events abroad,\u201d citing impacts from Trump and Putin on UK energy costs. He framed the Iran conflict as a warning that the UK must build resilience at home and with European allies.","topics":["UK politics","energy costs","US-Russia tensions","Iran conflict","resilience policy","foreign policy rhetoric"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"'We should not be at the mercy of events abroad' - Starmer BBC Keir Starmer: 'I'm fed up' with Trump and Putin affecting UK energy costs CNBC UK's Starmer says Iran conflict shows Britain must take a new path Reuters The Iran war is a warning: Britain must build resilience \u2013 at home and with our allies in Europe | Keir Starmer The Guardian Starmer Says Trump\u2019s Iran Rhetoric Is Contrary to UK Values Bloomberg.com","title":"'We should not be at the mercy of events abroad' - Starmer - BBC","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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_6bc6fc42a536 in signals