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/CBMihAFBVV95cUxPdzdNd1NOV1dkOUpEWWxpc0t0bFRfLS16R216bzhkNGNWdDROSWVNeHZPVFp0VDlQNFpEWkRFZVlGdEE5MXc1SUJ4bnM5d0RaTjduSGFiZmJZdHV1UGpCX0kxb01ya2dOWVF0X0NqT1BacXUxMjJiU3V1d2ZCSWd5Y0ExUE8?oc=5","as_of":"2026-04-07T02:56:07.891616+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/CBMihAFBVV95cUxPdzdNd1NOV1dkOUpEWWxpc0t0bFRfLS16R216bzhkNGNWdDROSWVNeHZPVFp0VDlQNFpEWkRFZVlGdEE5MXc1SUJ4bnM5d0RaTjduSGFiZmJZdHV1UGpCX0kxb01ya2dOWVF0X0NqT1BacXUxMjJiU3V1d2ZCSWd5Y0ExUE8?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_bbd57803864b45ef","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-07T15:51:45.362629+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPdzdNd1NOV1dkOUpEWWxpc0t0bFRfLS16R216bzhkNGNWdDROSWVNeHZPVFp0VDlQNFpEWkRFZVlGdEE5MXc1SUJ4bnM5d0RaTjduSGFiZmJZdHV1UGpCX0kxb01ya2dOWVF0X0NqT1BacXUxMjJiU3V1d2ZCSWd5Y0ExUE8?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/CBMihAFBVV95cUxPdzdNd1NOV1dkOUpEWWxpc0t0bFRfLS16R216bzhkNGNWdDROSWVNeHZPVFp0VDlQNFpEWkRFZVlGdEE5MXc1SUJ4bnM5d0RaTjduSGFiZmJZdHV1UGpCX0kxb01ya2dOWVF0X0NqT1BacXUxMjJiU3V1d2ZCSWd5Y0ExUE8?oc=5","source_event_id":"evt_8f9e47183369","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ede0dc22488c78c8","published_at":"2026-04-06T22:30:58+00:00","publisher_domain":"ft.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":"political","name":"Iran","relevance":"high","symbol":"N/A","type":"country"},{"asset_class":"geopolitical","name":"Strait of Hormuz","relevance":"high","symbol":"N/A","type":"location"}],"event_type":"geopolitical_risk","information_gaps":["Uncertainty about the immediate implications of Trump's statement on U.S.-Iran relations.","Lack of details on the context of the demand regarding the Strait of Hormuz."],"key_facts":["Trump's statement indicates a high level of military readiness and potential aggression towards Iran.","The Strait of Hormuz is a critical shipping route for oil, making its opening significant for global trade."],"numeric_claims":[],"primary_claim":"Trump asserts the U.S. could destroy Iran in one night and demands the opening of the Strait of Hormuz.","relevance_score":0.85,"sentiment":"negative","source_quality":"high","summary":"Donald Trump has made a provocative statement regarding Iran, claiming the U.S. could destroy the country in one night, while also demanding the opening of the Strait of Hormuz amidst ongoing tensions.","topics":["U.S.-Iran relations","geopolitical tensions","military threats"]},"source":"Financial Times","source_domain":"ft.com","source_url":"https://www.ft.com","summary":"Donald Trump says US could destroy Iran \u2018in one night\u2019 as he demands opening of Strait of Hormuz Financial Times Trump Says Iran Cease-Fire Proposal Is \u2018Not Good Enough\u2019 as Deadline Approaches The New York Times Trump says Iran ceasefire proposal 'significant' but 'not good enough' as Hormuz Strait deadline nears CNBC Trump warns Hormuz deadline \u2018final\u2019 as Iran pushes proposal to end war Al Jazeera Iran mediators make last-ditch push for 45-day ceasefire axios.com","title":"Donald Trump says US could destroy Iran \u2018in one night\u2019 as he demands opening of Strait of Hormuz - 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_22f7829d62a8 in signals