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/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

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_30b0c9f7a2d1 in signals