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/CBMic0FVX3lxTE9VMWFySkZCMTc4M3BBWWpqdXR1TXZKQ05DWFgwMkNkQWJST0NWdXZxcThIU25MR3ZmbWVnWW03N3QyRkd6SEVxMkFRNkJYLVZCZnBCQ0YxMEFoSmZJQXRLdUk0S1BvQ0VHQzlhRnBYN0ozQjQ?oc=5","as_of":"2026-04-21T06:10:19.281964+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAwAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2NinRH8J8B8OxYiGSKPU80ZhIQ6Ng/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMic0FVX3lxTE9VMWFySkZCMTc4M3BBWWpqdXR1TXZKQ05DWFgwMkNkQWJST0NWdXZxcThIU25MR3ZmbWVnWW03N3QyRkd6SEVxMkFRNkJYLVZCZnBCQ0YxMEFoSmZJQXRLdUk0S1BvQ0VHQzlhRnBYN0ozQjQ?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_7b432ae4a626f01d","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAwAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2NinRH8J8B8OxYiGSKPU80ZhIQ6Ng/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T18:14:40.038917+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMic0FVX3lxTE9VMWFySkZCMTc4M3BBWWpqdXR1TXZKQ05DWFgwMkNkQWJST0NWdXZxcThIU25MR3ZmbWVnWW03N3QyRkd6SEVxMkFRNkJYLVZCZnBCQ0YxMEFoSmZJQXRLdUk0S1BvQ0VHQzlhRnBYN0ozQjQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMic0FVX3lxTE9VMWFySkZCMTc4M3BBWWpqdXR1TXZKQ05DWFgwMkNkQWJST0NWdXZxcThIU25MR3ZmbWVnWW03N3QyRkd6SEVxMkFRNkJYLVZCZnBCQ0YxMEFoSmZJQXRLdUk0S1BvQ0VHQzlhRnBYN0ozQjQ?oc=5","source_event_id":"evt_ab1a05f844d9","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"a932170e72b2719c","published_at":"2026-04-21T05:18:53+00:00","publisher_domain":"npr.org","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: Gunman shoots several tourists at historic pyramids in Mexico - NPR","Source summary: Gunman shoots several tourists at historic pyramids in Mexico NPR Canadian killed in shooting at Mexico's ancient Teotihuac\u00e1n pyramids BBC Gunman opens fire at Mexico\u2019s Teotihuacan pyramids, killing Canadian and injuring others, government says CNN Deadly shooting at historic tourist site leaves one dead, several injured as motive unclear Fox News Canadian Tourist Is Killed in Shooting at Mexico\u2019s Pyramids The New Yo"],"numeric_claims":[],"primary_claim":"Gunman shoots several tourists at historic pyramids in Mexico - NPR","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Gunman shoots several tourists at historic pyramids in Mexico NPR Canadian killed in shooting at Mexico's ancient Teotihuac\u00e1n pyramids BBC Gunman opens fire at Mexico\u2019s Teotihuacan pyramids, killing Canadian and injuring others, government says CNN Deadly shooting at historic tourist site leaves one dead, several injured as motive unclear Fox News Canadian Tourist Is Killed in Shooting at Mexico\u2019s","topics":["news headline"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"Gunman shoots several tourists at historic pyramids in Mexico NPR Canadian killed in shooting at Mexico's ancient Teotihuac\u00e1n pyramids BBC Gunman opens fire at Mexico\u2019s Teotihuacan pyramids, killing Canadian and injuring others, government says CNN Deadly shooting at historic tourist site leaves one dead, several injured as motive unclear Fox News Canadian Tourist Is Killed in Shooting at Mexico\u2019s Pyramids The New York Times","title":"Gunman shoots several tourists at historic pyramids in Mexico - NPR","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.ZC4SwnwBFEo.L.X.O/am=GAIFAwAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2NinRH8J8B8OxYiGSKPU80ZhIQ6Ng/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_ca0d4470398e in signals