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/CBMihAFBVV95cUxQaUNWVU5JN1hnckZMellvSXhETWZTYlBuRFB4TnJUUG5KU3NBUDA5b3VKRnpKdDFQZDFnRjlJdVBnVFFpb3VIX2I5S3ppN2xLWlBkVzBUeGJLcG93V1JPOTcyV2IyeEFtLTBQQ1NVZ3BmVTUwaHlqeC1SaTc0bm9JLUxwM1M?oc=5","as_of":"2026-04-10T07:49:15.222215+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/CBMihAFBVV95cUxQaUNWVU5JN1hnckZMellvSXhETWZTYlBuRFB4TnJUUG5KU3NBUDA5b3VKRnpKdDFQZDFnRjlJdVBnVFFpb3VIX2I5S3ppN2xLWlBkVzBUeGJLcG93V1JPOTcyV2IyeEFtLTBQQ1NVZ3BmVTUwaHlqeC1SaTc0bm9JLUxwM1M?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_404be3fcf18ac83b","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-10T07:49:45.129202+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQaUNWVU5JN1hnckZMellvSXhETWZTYlBuRFB4TnJUUG5KU3NBUDA5b3VKRnpKdDFQZDFnRjlJdVBnVFFpb3VIX2I5S3ppN2xLWlBkVzBUeGJLcG93V1JPOTcyV2IyeEFtLTBQQ1NVZ3BmVTUwaHlqeC1SaTc0bm9JLUxwM1M?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"ft.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQaUNWVU5JN1hnckZMellvSXhETWZTYlBuRFB4TnJUUG5KU3NBUDA5b3VKRnpKdDFQZDFnRjlJdVBnVFFpb3VIX2I5S3ppN2xLWlBkVzBUeGJLcG93V1JPOTcyV2IyeEFtLTBQQ1NVZ3BmVTUwaHlqeC1SaTc0bm9JLUxwM1M?oc=5","source_event_id":"evt_6bea6a43f3e2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c3a283e71c6e4196","published_at":"2026-04-10T04:01:13+00:00","publisher_domain":"ft.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["within days (per Reuters summary in provided context; exact date not specified)"],"entities":[{"asset_class":"","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"","name":"United States (Trump)","relevance":"high","symbol":"","type":"country/political actor"},{"asset_class":"infrastructure","name":"European NATO allies / European bases","relevance":"medium","symbol":"","type":"region/asset location"},{"asset_class":"","name":"Iran war","relevance":"high","symbol":"","type":"geopolitical conflict"},{"asset_class":"","name":"Strait of Hormuz","relevance":"medium","symbol":"","type":"geographic chokepoint"},{"asset_class":"","name":"Rutte","relevance":"medium","symbol":"","type":"political actor"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains only CSS/HTML boilerplate and does not include the actual FT article content; therefore, details of the dispute (which countries, what terms, what bases) are not verifiable from the supplied text.","No specific timeline for the FT-reported NATO split is given beyond the general 'amid' framing.","The signal includes multiple other headlines/summaries (NYT/Politico/Reuters/WSJ), but only the FT headline is explicitly tied to the 'NATO split' claim; cross-source specifics cannot be confirmed as part of the FT story from the provided text."],"key_facts":["Financial Times headline indicates NATO is split over US access to European bases in the context of the Iran war.","The provided source summary references US pressure/threats involving NATO and Iran-war-related commitments.","The provided source summary also references diplomats saying NATO is being pushed for Hormuz-related pledges within days (timing referenced in the summary, not in the FT headline itself)."],"numeric_claims":[],"primary_claim":"NATO is divided over US access to European bases amid the Iran war, according to the Financial Times.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"Financial Times reports a split within NATO over whether the US will gain access to European bases in the context of the Iran war. The dispute is framed around US pressure and threats, creating near-term uncertainty about NATO cohesion and operational commitments related to Iran and the Strait of Hormuz.","topics":["NATO internal politics","US demands/conditionality","European basing access","Iran war posture","Strait of Hormuz","alliance cohesion"]},"source":"Financial Times","source_domain":"ft.com","source_url":"https://www.ft.com","summary":"Nato split over US access to European bases in Iran war Financial Times Amid Trump\u2019s Threats, NATO Labors to Survive the Iran War The New York Times What Trump\u2019s blowup with Rutte was really about Politico NATO's Rutte tells allies Trump wants Hormuz pledges within days, diplomats say Reuters Exclusive | Trump Team Explores Punishment for NATO Countries That Didn\u2019t Support Iran War WSJ","title":"Nato split over US access to European bases in Iran war - Financial 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_153ba1c5af30 in signals