SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-21T00:02:03.659921+00:00","dedupe_key":"signal_enriched:news_delta:cdafb323380d5c73","evidence_event_ids":["evt_c610b01be2f8"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxOemxiRi04Q1VEQVItUFNvTGg0b0J1RkRKckNUOHM0aWtlLW04RzNWcHpHVDI3N0JiUHdMek5zOElLMDFOWjhaTGlGWmlRRTVSNHZPNjB0N1UxUGFtTWQ1ZGtZQ2VvX1Q5Tjd1TmY4OWlPX2hOZi0xemFlMnRTSUJFd0pwNG5OUmtYZ0VyRVEzdUFhWUpKbGc?oc=5","as_of":"2026-04-21T00:02:03.659921+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2ORIMICXrbudO7aLun3cEYLx6oJDg/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxOemxiRi04Q1VEQVItUFNvTGg0b0J1RkRKckNUOHM0aWtlLW04RzNWcHpHVDI3N0JiUHdMek5zOElLMDFOWjhaTGlGWmlRRTVSNHZPNjB0N1UxUGFtTWQ1ZGtZQ2VvX1Q5Tjd1TmY4OWlPX2hOZi0xemFlMnRTSUJFd0pwNG5OUmtYZ0VyRVEzdUFhWUpKbGc?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_ec16645bb03fd959","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2ORIMICXrbudO7aLun3cEYLx6oJDg/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T13:29:15.458393+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxOemxiRi04Q1VEQVItUFNvTGg0b0J1RkRKckNUOHM0aWtlLW04RzNWcHpHVDI3N0JiUHdMek5zOElLMDFOWjhaTGlGWmlRRTVSNHZPNjB0N1UxUGFtTWQ1ZGtZQ2VvX1Q5Tjd1TmY4OWlPX2hOZi0xemFlMnRTSUJFd0pwNG5OUmtYZ0VyRVEzdUFhWUpKbGc?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/CBMilgFBVV95cUxOemxiRi04Q1VEQVItUFNvTGg0b0J1RkRKckNUOHM0aWtlLW04RzNWcHpHVDI3N0JiUHdMek5zOElLMDFOWjhaTGlGWmlRRTVSNHZPNjB0N1UxUGFtTWQ1ZGtZQ2VvX1Q5Tjd1TmY4OWlPX2hOZi0xemFlMnRTSUJFd0pwNG5OUmtYZ0VyRVEzdUFhWUpKbGc?oc=5","source_event_id":"evt_c610b01be2f8","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"807402cf088b8e54","published_at":"2026-04-20T22:33:08+00:00","publisher_domain":"nytimes.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: Canadian Tourist Is Shot Dead in Shooting at Mexico\u2019s Pyramids - The New York Times","Source summary: Canadian Tourist Is Shot Dead in Shooting at Mexico\u2019s Pyramids The New York Times Deadly shooting at historic tourist site leaves one dead, several injured as motive unclear Fox News Canadian woman killed in shooting at Mexico's ancient pyramids BBC Shooting at pyramids north of Mexico City leaves 1 Canadian tourist dead, injures 6 people AP News At least one killed in shooting at \u200bMexico\u2019s Teotihuacan \u200bpyramids, say"],"numeric_claims":[],"primary_claim":"Canadian Tourist Is Shot Dead in Shooting at Mexico\u2019s Pyramids - The New York Times","relevance_score":0.46,"sentiment":"neutral","source_quality":"unknown","summary":"Canadian Tourist Is Shot Dead in Shooting at Mexico\u2019s Pyramids The New York Times Deadly shooting at historic tourist site leaves one dead, several injured as motive unclear Fox News Canadian woman killed in shooting at Mexico's ancient pyramids BBC Shooting at pyramids north of Mexico City leaves 1 Canadian tourist dead, injures 6 people AP News At least one killed in shooting at \u200bMexico\u2019s Teotih","topics":["news headline"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Canadian Tourist Is Shot Dead in Shooting at Mexico\u2019s Pyramids The New York Times Deadly shooting at historic tourist site leaves one dead, several injured as motive unclear Fox News Canadian woman killed in shooting at Mexico's ancient pyramids BBC Shooting at pyramids north of Mexico City leaves 1 Canadian tourist dead, injures 6 people AP News At least one killed in shooting at \u200bMexico\u2019s Teotihuacan \u200bpyramids, says security cabinet CNN","title":"Canadian Tourist Is Shot Dead in Shooting at Mexico\u2019s Pyramids - The New York Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.66Y3bu-8kXQ.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2ORIMICXrbudO7aLun3cEYLx6oJDg/m=syndicationarticleview,_b,_tp"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 471147 in events