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-07T00:26:15.757543+00:00","dedupe_key":"signal_enriched:news_delta:cf02652e11b74c68","evidence_event_ids":["evt_83e5dbb478e7"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxQNVM2OF9mZ0hoTndCaUd6TDMwZHc0ODNQQjlRZ1BuMU5TV004ekZrZlJnRWR0S0M4cXhVNnFyVndaMW5VVmkwSkFRX0dzRWJ5c18zdXBFR0hfS2h2Tkg1LWhMblAtUTVEdXlZekxpdVZWSjczWGsxT3JMYndOME1ZcVln?oc=5","as_of":"2026-04-07T00:26:15.757543+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/CBMiggFBVV95cUxQNVM2OF9mZ0hoTndCaUd6TDMwZHc0ODNQQjlRZ1BuMU5TV004ekZrZlJnRWR0S0M4cXhVNnFyVndaMW5VVmkwSkFRX0dzRWJ5c18zdXBFR0hfS2h2Tkg1LWhMblAtUTVEdXlZekxpdVZWSjczWGsxT3JMYndOME1ZcVln?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_af64c3dbd4353b85","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-07T14:21:14.885860+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxQNVM2OF9mZ0hoTndCaUd6TDMwZHc0ODNQQjlRZ1BuMU5TV004ekZrZlJnRWR0S0M4cXhVNnFyVndaMW5VVmkwSkFRX0dzRWJ5c18zdXBFR0hfS2h2Tkg1LWhMblAtUTVEdXlZekxpdVZWSjczWGsxT3JMYndOME1ZcVln?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/CBMiggFBVV95cUxQNVM2OF9mZ0hoTndCaUd6TDMwZHc0ODNQQjlRZ1BuMU5TV004ekZrZlJnRWR0S0M4cXhVNnFyVndaMW5VVmkwSkFRX0dzRWJ5c18zdXBFR0hfS2h2Tkg1LWhMblAtUTVEdXlZekxpdVZWSjczWGsxT3JMYndOME1ZcVln?oc=5","source_event_id":"evt_83e5dbb478e7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"88f2cd89331b3030","published_at":"2026-04-06T19:40:12+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":[],"entities":[{"asset_class":"N/A","name":"Indianapolis City Council","relevance":"directly involved in the decision","symbol":"N/A","type":"government"},{"asset_class":"N/A","name":"Data Center","relevance":"subject of the councilman's vote","symbol":"N/A","type":"infrastructure"}],"event_type":"conflict","information_gaps":["Details on the identity of the shooter","Context on community opposition to data centers","Potential legal implications for the councilman"],"key_facts":["13 shots fired into the councilman's home","A 'No Data Centers' note was left behind","The incident occurred after a vote supporting a data center"],"numeric_claims":[{"label":"Number of shots fired","value":"13"}],"primary_claim":"Shots were fired at the home of an Indianapolis city councilman after he supported a data center project.","relevance_score":0.9,"sentiment":"negative","source_quality":"high","summary":"An Indianapolis city councilman reported that his home was shot at 13 times following his vote in favor of a data center, with a 'No Data Centers' note left behind, indicating potential backlash against the decision.","topics":["local governance","community conflict","data centers"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Shots Fired at Indianapolis Councilman\u2019s Home, After Vote Backing Data Center The New York Times Indianapolis city councilor says his home was shot at 13 times, \"No Data Centers\" sign left behind CBS News City councilor who supported data center says his home was shot at indystar.com Home of Indianapolis city councilor shot at over his support of datacenters The Guardian Indianapolis City-County councilor says 13 shots fired into his home, \u2018No data centers\u2019 note left on doormat Fox 59","title":"Shots Fired at Indianapolis Councilman\u2019s Home, After Vote Backing Data Center - The New York 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

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 38017 in events