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/CBMiqgFBVV95cUxQeUxmY3pDLXFnMFVWLU52SzV1VWJYYWIzMlZ0dGxnRldSeUdZUTh6MkFNYUFrcGd5T3FsbGxhbjVzT01VbzdZakV2MXdmLXZRbktXeUNWNnN4WDA2RWFLb2pQWmE1OTRsQWgtMmQ1SXZGRktSa1dWZEVKNXlHZXZOZXN5a3pOS2J2emNqWU9aMDE2ZXFjS1d1cTdUc1V2VXk1LVpUazdhclROUQ?oc=5","as_of":"2026-04-09T09:54:21.962650+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/CBMiqgFBVV95cUxQeUxmY3pDLXFnMFVWLU52SzV1VWJYYWIzMlZ0dGxnRldSeUdZUTh6MkFNYUFrcGd5T3FsbGxhbjVzT01VbzdZakV2MXdmLXZRbktXeUNWNnN4WDA2RWFLb2pQWmE1OTRsQWgtMmQ1SXZGRktSa1dWZEVKNXlHZXZOZXN5a3pOS2J2emNqWU9aMDE2ZXFjS1d1cTdUc1V2VXk1LVpUazdhclROUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3cd5838c0eec5733","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-09T23:04:19.403655+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxQeUxmY3pDLXFnMFVWLU52SzV1VWJYYWIzMlZ0dGxnRldSeUdZUTh6MkFNYUFrcGd5T3FsbGxhbjVzT01VbzdZakV2MXdmLXZRbktXeUNWNnN4WDA2RWFLb2pQWmE1OTRsQWgtMmQ1SXZGRktSa1dWZEVKNXlHZXZOZXN5a3pOS2J2emNqWU9aMDE2ZXFjS1d1cTdUc1V2VXk1LVpUazdhclROUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqgFBVV95cUxQeUxmY3pDLXFnMFVWLU52SzV1VWJYYWIzMlZ0dGxnRldSeUdZUTh6MkFNYUFrcGd5T3FsbGxhbjVzT01VbzdZakV2MXdmLXZRbktXeUNWNnN4WDA2RWFLb2pQWmE1OTRsQWgtMmQ1SXZGRktSa1dWZEVKNXlHZXZOZXN5a3pOS2J2emNqWU9aMDE2ZXFjS1d1cTdUc1V2VXk1LVpUazdhclROUQ?oc=5","source_event_id":"evt_156c9e5d8cce","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"abc405b21997142c","published_at":"2026-04-08T22:54:00+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"NATO chief","relevance":"high","symbol":"","type":"organization_role"},{"asset_class":"political_alliance","name":"NATO","relevance":"high","symbol":"","type":"organization"},{"asset_class":"sovereign_states","name":"European allies (unspecified)","relevance":"high","symbol":"","type":"group"},{"asset_class":"geopolitical_risk","name":"Iran war (unspecified conflict)","relevance":"high","symbol":"","type":"conflict"}],"event_type":"conflict","information_gaps":["Which NATO chief (name/title) is not specified in the provided excerpt.","Which European allies/countries were referenced is not specified.","What \u201ctested\u201d means (military readiness, operational performance, support level, etc.) is not specified.","No details are provided on when the Iran war scenario occurred or what specific events constituted the \u201cfailure.\u201d","No direct market/financial implications are stated in the provided text."],"key_facts":["Reuters headline states NATO\u2019s chief said some European allies were \u201ctested and failed\u201d in the Iran war.","The specific European countries and the nature of the \u201ctest\u201d are not provided in the provided text.","The provided text does not specify timing, outcomes, or any policy actions resulting from the statement."],"numeric_claims":[],"primary_claim":"NATO\u2019s chief said some European allies were tested and failed in the Iran war.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Reuters reports NATO\u2019s chief said some European allies were \u201ctested and failed\u201d during an Iran war scenario. The statement implies strain and potential scrutiny within NATO regarding members\u2019 readiness and support during the Iran-related conflict.","topics":["NATO","Iran war","European allies","alliance readiness","transatlantic relations","geopolitical risk"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"NATO chief says some European allies were tested and failed in Iran war Reuters 'Poorly run, piece of ice': Trump targets Greenland again as Iran war deepens NATO rift CNBC Trump Again Hits Out at NATO Over Iran War The New York Times Trump, Rubio face NATO chief as US moves to 'reexamine' alliance after Iran clash Fox News Exclusive | Trump Team Explores Punishment for NATO Countries That Didn\u2019t Support Iran War WSJ","title":"NATO chief says some European allies were tested and failed in Iran war - Reuters","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_f7c3a4c76dff in signals