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/CBMihgFBVV95cUxQMFRuYjZtZTg1N3Rpc0w0cVRMbXhYTTlnWDJfdEt6OWxoNHpmNE4wWmxydHlOalRXcndiVzh4TkpGak1nRThlcDBlZTZFREhLNmxYbXlOeWtadzd2bERYZXZXTnN4YXJBTXlXeXc1UTdhYjFvd3dCak5DeHZXQmJIbDZMZGFPZw?oc=5","as_of":"2026-04-18T05:44:29.959892+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMihgFBVV95cUxQMFRuYjZtZTg1N3Rpc0w0cVRMbXhYTTlnWDJfdEt6OWxoNHpmNE4wWmxydHlOalRXcndiVzh4TkpGak1nRThlcDBlZTZFREhLNmxYbXlOeWtadzd2bERYZXZXTnN4YXJBTXlXeXc1UTdhYjFvd3dCak5DeHZXQmJIbDZMZGFPZw?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_fed43f7e2aa5ca58","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T05:44:41.507031+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihgFBVV95cUxQMFRuYjZtZTg1N3Rpc0w0cVRMbXhYTTlnWDJfdEt6OWxoNHpmNE4wWmxydHlOalRXcndiVzh4TkpGak1nRThlcDBlZTZFREhLNmxYbXlOeWtadzd2bERYZXZXTnN4YXJBTXlXeXc1UTdhYjFvd3dCak5DeHZXQmJIbDZMZGFPZw?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/CBMihgFBVV95cUxQMFRuYjZtZTg1N3Rpc0w0cVRMbXhYTTlnWDJfdEt6OWxoNHpmNE4wWmxydHlOalRXcndiVzh4TkpGak1nRThlcDBlZTZFREhLNmxYbXlOeWtadzd2bERYZXZXTnN4YXJBTXlXeXc1UTdhYjFvd3dCak5DeHZXQmJIbDZMZGFPZw?oc=5","source_event_id":"evt_f4f6c12ebedf","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"7f49ea8c9507607f","published_at":"2026-04-18T03:31:00+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.42,"dates_mentioned":[],"entities":[],"event_type":"other","information_gaps":["article_text_unavailable"],"key_facts":["Headline: Trump came to Arizona to rally young voters. An older crowd greeted him. - The Washington Post","Source summary: Trump came to Arizona to rally young voters. An older crowd greeted him. The Washington Post As Phoenix Suns try to get into playoffs, watch for road closures The Arizona Republic President Trump visits in Phoenix for first Arizona trip of 2026 AZ Family In Phoenix, Trump Eyes Lower Gas Prices and Frets About the Midterms The New York Times Trump delivers remarks at Turning Point rally in Arizona NBC News"],"numeric_claims":[],"primary_claim":"Trump came to Arizona to rally young voters. An older crowd greeted him. - The Washington Post","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Trump came to Arizona to rally young voters. An older crowd greeted him. The Washington Post As Phoenix Suns try to get into playoffs, watch for road closures The Arizona Republic President Trump visits in Phoenix for first Arizona trip of 2026 AZ Family In Phoenix, Trump Eyes Lower Gas Prices and Frets About the Midterms The New York Times Trump delivers remarks at Turning Point rally in Arizona ","topics":["news headline"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Trump came to Arizona to rally young voters. An older crowd greeted him. The Washington Post As Phoenix Suns try to get into playoffs, watch for road closures The Arizona Republic President Trump visits in Phoenix for first Arizona trip of 2026 AZ Family In Phoenix, Trump Eyes Lower Gas Prices and Frets About the Midterms The New York Times Trump delivers remarks at Turning Point rally in Arizona NBC News","title":"Trump came to Arizona to rally young voters. An older crowd greeted him. - The Washington Post","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_4a499d46113b in signals