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/CBMiigFBVV95cUxPYl9RWU11aDcwd0lHSzJIMzIxYlJRejhPdmsxYlVjNm9uOVlxVnlJZjhkMVgwN01qZ0lrZ0R0VTNNSWtrazd4ZE1uTnNGWUIwUnZHSnZ2Vmd4Uk5jdDN5RENpX253YXJOOWFOQ0NFQVFqNlRVM0NSWDZOWXZVM3ZHNUhFaFhsdDFWRmc?oc=5","as_of":"2026-04-10T18:06:51.959211+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/CBMiigFBVV95cUxPYl9RWU11aDcwd0lHSzJIMzIxYlJRejhPdmsxYlVjNm9uOVlxVnlJZjhkMVgwN01qZ0lrZ0R0VTNNSWtrazd4ZE1uTnNGWUIwUnZHSnZ2Vmd4Uk5jdDN5RENpX253YXJOOWFOQ0NFQVFqNlRVM0NSWDZOWXZVM3ZHNUhFaFhsdDFWRmc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_55afc6e3bdd1821a","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-10T18:45:51.605904+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxPYl9RWU11aDcwd0lHSzJIMzIxYlJRejhPdmsxYlVjNm9uOVlxVnlJZjhkMVgwN01qZ0lrZ0R0VTNNSWtrazd4ZE1uTnNGWUIwUnZHSnZ2Vmd4Uk5jdDN5RENpX253YXJOOWFOQ0NFQVFqNlRVM0NSWDZOWXZVM3ZHNUhFaFhsdDFWRmc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxPYl9RWU11aDcwd0lHSzJIMzIxYlJRejhPdmsxYlVjNm9uOVlxVnlJZjhkMVgwN01qZ0lrZ0R0VTNNSWtrazd4ZE1uTnNGWUIwUnZHSnZ2Vmd4Uk5jdDN5RENpX253YXJOOWFOQ0NFQVFqNlRVM0NSWDZOWXZVM3ZHNUhFaFhsdDFWRmc?oc=5","source_event_id":"evt_ac1e2bb7da65","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"055f990baee6cb51","published_at":"2026-04-10T16:32:02+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"sovereign_government","name":"Keir Starmer","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"sovereign_government","name":"Donald Trump","relevance":"source of frustration","symbol":"","type":"person"},{"asset_class":"sovereign_government","name":"United Kingdom","relevance":"affected jurisdiction","symbol":"","type":"country"},{"asset_class":"region","name":"Europe","relevance":"described as splintering","symbol":"","type":"region"},{"asset_class":"sovereign_government","name":"Iran","relevance":"center of the conflict referenced","symbol":"","type":"country"},{"asset_class":"media","name":"The New York Times","relevance":"source of headline","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only page styling/HTML/CSS and does not include the actual article content, so details beyond the headline and the provided source summary cannot be verified.","It is unclear whether \u201cPutin affecting UK energy costs\u201d is part of the NYT article or only from other included snippets in the user\u2019s source summary.","No specific policy actions, dates, or named \u201cother allies\u201d are stated in the provided headline/summaries beyond general alliance language."],"key_facts":["The New York Times headline states: \u201cI\u2019m Fed Up.\u201d Frustrated With Trump, Starmer Embraces Other Allies.","The headline framing indicates Europe is \u201csplinter[ing] from U.S.\u201d over the Iran war.","The provided source summary includes the quote attribution that Starmer says he is \u201cfed up\u201d with Trump and Putin affecting UK energy costs (unclear if included in the NYT article or only in the broader provided summaries)."],"numeric_claims":[],"primary_claim":"Keir Starmer said he is \u201cfed up\u201d with Trump and is embracing other allies as Europe splinters from the U.S. over the Iran war.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"UK Prime Minister Keir Starmer is portrayed as \u201cfed up\u201d with President Trump and is seeking closer alignment with other allies as Europe fractures over the Iran war. The near-term catalyst is the ongoing Iran conflict and its spillover into UK/European policy and costs.","topics":["UK politics","U.S.-UK relations","Europe-U.S. alignment","Iran war","diplomacy/alliance strategy","energy costs (implied)"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"\u2018I\u2019m Fed Up.\u2019 Frustrated With Trump, Starmer Embraces Other Allies. The New York Times Starmer Says He's 'Fed Up' With Trump as Europe Splinters From U.S. Over Iran War Time Magazine Iran conflict will define us for a generation, says PM BBC The Iran war is a warning: Britain must build resilience \u2013 at home and with our allies in Europe | Keir Starmer The Guardian Keir Starmer: 'I'm fed up' with Trump and Putin affecting UK energy costs CNBC","title":"\u2018I\u2019m Fed Up.\u2019 Frustrated With Trump, Starmer Embraces Other Allies. - The New York Times","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_3e4ba4b80cfe in signals