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/CBMijwFBVV95cUxOZTNLUlE0RzZTaXRaamZJMGU5ajNKUGhhMTdIbmpjQ1RmMmRUcGx6Slk1M1lWUkp3dXFHUC14WkVPUk5oa25UbmZPSXFhQklBMjIwY3RxUkJtbW9fREgzUWtkd25JWkQ0SFlkR2hiSjFMR19qLW4yNHI1MnNjN0dHOUxHa21hQkhzUXdOYkRvaw?oc=5","as_of":"2026-04-06T19:27:27.856332+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/CBMijwFBVV95cUxOZTNLUlE0RzZTaXRaamZJMGU5ajNKUGhhMTdIbmpjQ1RmMmRUcGx6Slk1M1lWUkp3dXFHUC14WkVPUk5oa25UbmZPSXFhQklBMjIwY3RxUkJtbW9fREgzUWtkd25JWkQ0SFlkR2hiSjFMR19qLW4yNHI1MnNjN0dHOUxHa21hQkhzUXdOYkRvaw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_175b4ce1d53d55be","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-06T20:21:06.896858+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxOZTNLUlE0RzZTaXRaamZJMGU5ajNKUGhhMTdIbmpjQ1RmMmRUcGx6Slk1M1lWUkp3dXFHUC14WkVPUk5oa25UbmZPSXFhQklBMjIwY3RxUkJtbW9fREgzUWtkd25JWkQ0SFlkR2hiSjFMR19qLW4yNHI1MnNjN0dHOUxHa21hQkhzUXdOYkRvaw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxOZTNLUlE0RzZTaXRaamZJMGU5ajNKUGhhMTdIbmpjQ1RmMmRUcGx6Slk1M1lWUkp3dXFHUC14WkVPUk5oa25UbmZPSXFhQklBMjIwY3RxUkJtbW9fREgzUWtkd25JWkQ0SFlkR2hiSjFMR19qLW4yNHI1MnNjN0dHOUxHa21hQkhzUXdOYkRvaw?oc=5","source_event_id":"evt_1c6348e04397","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e93e8f04ab9ce272","published_at":"2026-04-06T18:46:13+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Donald Trump","relevance":"high","symbol":"N/A","type":"person"},{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"N/A","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["Details on the specific journalist involved are not provided.","The potential legal implications of Trump's threat are unclear."],"key_facts":["Trump's threat is aimed at a journalist reporting on Iran.","The situation may escalate tensions between the U.S. and Iran."],"numeric_claims":[],"primary_claim":"Trump threatens to jail a journalist over source disclosure related to an Iran rescue story.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"Trump has threatened to jail a journalist who reported on a crew's rescue in Iran if they do not disclose their source, escalating tensions surrounding the Iran situation.","topics":["journalism","freedom of press","Iran","politics"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Trump threatens to jail journalist who reported on crew\u2019s rescue in Iran if they don\u2019t reveal source Politico Trump threatens to jail journalists in hunt to find leaker of Iran fighter jet story NBC News WATCH LIVE: Trump holds news conference after unleashing latest threat against Iran PBS Middle East crisis live: Iran warns of \u2018devastating\u2019 retaliation after Trump\u2019s expletive-laden threats over strait of Hormuz The Guardian Trump says Iran could be 'taken out' Tuesday night but cites efforts to negotiate Reuters","title":"Trump threatens to jail journalist who reported on crew\u2019s rescue in Iran if they don\u2019t reveal source - Politico","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_4679f9813cb3 in signals