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/CBMikwFBVV95cUxNcGt2cnREN05sanY2dlFYX3Q4RFF5VjdOdUZPMWxmM2FJaTVJQ0NRQ0lQeHVFYjVuOExlaXRjbkJpVElsRDZXMmFGZ1lVZmk5STk4bERsUW5EQWRmVDJHZ0dydnFwNEhNbHozU1owNFpfZ0lRVVl3Z2hfZnBlQmZEbGF2M0JfUGkyZlEtQUhCdXV6YUk?oc=5","as_of":"2026-04-08T21:48:34.386848+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/CBMikwFBVV95cUxNcGt2cnREN05sanY2dlFYX3Q4RFF5VjdOdUZPMWxmM2FJaTVJQ0NRQ0lQeHVFYjVuOExlaXRjbkJpVElsRDZXMmFGZ1lVZmk5STk4bERsUW5EQWRmVDJHZ0dydnFwNEhNbHozU1owNFpfZ0lRVVl3Z2hfZnBlQmZEbGF2M0JfUGkyZlEtQUhCdXV6YUk?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_961ef5f4afec6159","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:13:46.624361+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxNcGt2cnREN05sanY2dlFYX3Q4RFF5VjdOdUZPMWxmM2FJaTVJQ0NRQ0lQeHVFYjVuOExlaXRjbkJpVElsRDZXMmFGZ1lVZmk5STk4bERsUW5EQWRmVDJHZ0dydnFwNEhNbHozU1owNFpfZ0lRVVl3Z2hfZnBlQmZEbGF2M0JfUGkyZlEtQUhCdXV6YUk?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxNcGt2cnREN05sanY2dlFYX3Q4RFF5VjdOdUZPMWxmM2FJaTVJQ0NRQ0lQeHVFYjVuOExlaXRjbkJpVElsRDZXMmFGZ1lVZmk5STk4bERsUW5EQWRmVDJHZ0dydnFwNEhNbHozU1owNFpfZ0lRVVl3Z2hfZnBlQmZEbGF2M0JfUGkyZlEtQUhCdXV6YUk?oc=5","source_event_id":"evt_c57900b74588","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"eb3caf92fa721ea1","published_at":"2026-04-08T21:04:12+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Pete Hegseth","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Caine","relevance":"high","symbol":"","type":"person"},{"asset_class":"sovereign","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"infrastructure","name":"Strait of Hormuz","relevance":"high","symbol":"","type":"geographic_feature"},{"asset_class":"","name":"Pentagon","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"","name":"Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"","name":"Washington Post","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"The New York Times","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"The Hill","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"newsnationnow.com","relevance":"low","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains only CSS/HTML boilerplate and does not include the actual article content; extraction is therefore based on the provided headline and source summary only.","\u201cCaine\u201d is not fully identified (e.g., first name/role) in the provided text.","The timing and specifics of the cease-fire expiration and any proposed resumption of combat are not detailed in the provided material.","The Strait of Hormuz closure is attributed to \u201cIran media\u201d in the summary; confirmation by other sources is not provided here."],"key_facts":["The Washington Post headline states that Pete Hegseth proclaims victory in an Iran war while Caine takes a cautious tone.","The New York Times coverage referenced in the source summary says resuming combat in Iran would be risky for Trump even if a cease-fire expires.","Iran media (as cited in the source summary) says the Strait of Hormuz is closed.","The Hill headline referenced in the source summary says critics within the Pentagon add to Pete Hegseth\u2019s troubles and that a Democratic senator says Hegseth is \u201cblowing smoke\u201d with claims about the Iran war."],"numeric_claims":[],"primary_claim":"Senator Caine is taking a cautious tone in response to Pete Hegseth\u2019s claims about victory in an Iran war.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"The Washington Post reports that Pete Hegseth is proclaiming victory in an Iran war narrative, while Senator Caine is taking a more cautious tone. Other referenced coverage suggests renewed U.S. combat in Iran would be risky even if a cease-fire expires, and that Iran media claims the Strait of Hormuz has been closed.","topics":["U.S.-Iran conflict","cease-fire risk","Pentagon internal criticism","maritime chokepoint disruption","political messaging"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"As Hegseth proclaims victory in Iran war, Caine takes cautious tone The Washington Post For Trump, Resuming Combat in Iran Would Be Risky, Even if Cease-Fire Expires The New York Times Live updates: Iran media says Strait of Hormuz closed newsnationnow.com Critics within the Pentagon add to Pete Hegseth\u2019s many troubles ms.now Democratic senator: Hegseth \u2018blowing smoke\u2019 with claims about Iran war The Hill","title":"As Hegseth proclaims victory in Iran war, Caine takes cautious tone - The Washington Post","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_280d8402b21d in signals