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/CBMiigFBVV95cUxNb1N1N0VucTI5ZW1IaThrOFJXYWFnX1VsajQ3OHBVaXVPbmg0UF9SQ2FGU2ZSbGFpMm1MQUJvNXFra2s1X1dISkw2cG5jejRxR2ZocGF2THVBckxmWFZQWFdtWFVaaFZSZm1adDJCTjZKLXZ2REFDdzZBaFIxNDQzLUxVazh2M3FlSWc?oc=5","as_of":"2026-04-07T05:08:56.500896+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxNb1N1N0VucTI5ZW1IaThrOFJXYWFnX1VsajQ3OHBVaXVPbmg0UF9SQ2FGU2ZSbGFpMm1MQUJvNXFra2s1X1dISkw2cG5jejRxR2ZocGF2THVBckxmWFZQWFdtWFVaaFZSZm1adDJCTjZKLXZ2REFDdzZBaFIxNDQzLUxVazh2M3FlSWc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cf70bae0a82dbb37","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T18:47:52.322202+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxNb1N1N0VucTI5ZW1IaThrOFJXYWFnX1VsajQ3OHBVaXVPbmg0UF9SQ2FGU2ZSbGFpMm1MQUJvNXFra2s1X1dISkw2cG5jejRxR2ZocGF2THVBckxmWFZQWFdtWFVaaFZSZm1adDJCTjZKLXZ2REFDdzZBaFIxNDQzLUxVazh2M3FlSWc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxNb1N1N0VucTI5ZW1IaThrOFJXYWFnX1VsajQ3OHBVaXVPbmg0UF9SQ2FGU2ZSbGFpMm1MQUJvNXFra2s1X1dISkw2cG5jejRxR2ZocGF2THVBckxmWFZQWFdtWFVaaFZSZm1adDJCTjZKLXZ2REFDdzZBaFIxNDQzLUxVazh2M3FlSWc?oc=5","source_event_id":"evt_94d81c98c828","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"36494605df48588a","published_at":"2026-04-07T02:32:24+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"politics","name":"Donald Trump","relevance":"high","symbol":"N/A","type":"person"},{"asset_class":"politics","name":"Iran","relevance":"high","symbol":"N/A","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["Details on the specific content of Iran's proposal are not provided.","The exact nature of the attacks mentioned is unclear."],"key_facts":["Trump described Iran's proposal as 'significant' but 'not good enough'.","The proposal aims to end attacks and sanctions.","Tensions are escalating as a ceasefire deadline approaches."],"numeric_claims":[],"primary_claim":"Trump believes Iran's proposal does not adequately address security concerns regarding attacks on bridges and power plants.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"Trump has stated that Iran's ceasefire proposal is insufficient to prevent attacks on critical infrastructure, indicating ongoing tensions.","topics":["Iran","Trump","geopolitical tensions","ceasefire proposals"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Trump Says Iran Proposal Isn\u2019t Enough to Stop Attacks on Bridges and Power Plants The New York Times Iran\u2019s 10-Point Proposal Demands an End to Attacks and Sanctions The New York Times Iran defiant on eve of Trump's ceasefire deadline Reuters Trump says Iran ceasefire proposal 'significant' but 'not good enough' as Hormuz Strait deadline nears CNBC Iran mediators make last-ditch push for 45-day ceasefire Axios","title":"Trump Says Iran Proposal Isn\u2019t Enough to Stop Attacks on Bridges and Power Plants - The New York Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_da26ca0db5dd in signals