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/CBMioAFBVV95cUxOOTZKWGIwcUdXdXJVRWpRWHJta3ZfLUMxQkl2bVNTT2VyZVRBb2p1ZUtyeUJiLWJ2Rk1ubmhxRjZGYVNjbTFhdTR3aWMtTWoyT3dMSFF0VXQ5VVIxWlJKemJnaHB0TUVFanQ1OFE1andUNFdvdlhQcDM2RkdGLXlLSHg0cV9mbG1EUkRQREd5bEVoaVFrUEtwVEFFTlN3R090?oc=5","as_of":"2026-04-07T02:56:08.034979+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/CBMioAFBVV95cUxOOTZKWGIwcUdXdXJVRWpRWHJta3ZfLUMxQkl2bVNTT2VyZVRBb2p1ZUtyeUJiLWJ2Rk1ubmhxRjZGYVNjbTFhdTR3aWMtTWoyT3dMSFF0VXQ5VVIxWlJKemJnaHB0TUVFanQ1OFE1andUNFdvdlhQcDM2RkdGLXlLSHg0cV9mbG1EUkRQREd5bEVoaVFrUEtwVEFFTlN3R090?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2f0fb176d5da68e0","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-07T17:00:58.800979+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxOOTZKWGIwcUdXdXJVRWpRWHJta3ZfLUMxQkl2bVNTT2VyZVRBb2p1ZUtyeUJiLWJ2Rk1ubmhxRjZGYVNjbTFhdTR3aWMtTWoyT3dMSFF0VXQ5VVIxWlJKemJnaHB0TUVFanQ1OFE1andUNFdvdlhQcDM2RkdGLXlLSHg0cV9mbG1EUkRQREd5bEVoaVFrUEtwVEFFTlN3R090?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxOOTZKWGIwcUdXdXJVRWpRWHJta3ZfLUMxQkl2bVNTT2VyZVRBb2p1ZUtyeUJiLWJ2Rk1ubmhxRjZGYVNjbTFhdTR3aWMtTWoyT3dMSFF0VXQ5VVIxWlJKemJnaHB0TUVFanQ1OFE1andUNFdvdlhQcDM2RkdGLXlLSHg0cV9mbG1EUkRQREd5bEVoaVFrUEtwVEFFTlN3R090?oc=5","source_event_id":"evt_e877d4c652ba","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c3295be8c5c0ac77","published_at":"2026-04-06T19:46:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":[],"entities":[{"asset_class":"political","name":"Ron Gibson","relevance":"primary","symbol":"","type":"person"},{"asset_class":"political","name":"Indianapolis City Council","relevance":"secondary","symbol":"","type":"government"}],"event_type":"conflict","information_gaps":["Details on the shooter or motive beyond the anti-data center message are unclear.","No immediate response from law enforcement or community leaders is mentioned."],"key_facts":["Ron Gibson's home was shot at 13 times.","A 'No Data Centers' sign was left at the scene.","The incident is linked to Gibson's support for data centers."],"numeric_claims":[{"label":"number of shots fired","value":"13"}],"primary_claim":"Ron Gibson's home was shot at 13 times after he supported data centers, with an anti-data center message left behind.","relevance_score":0.9,"sentiment":"negative","source_quality":"high","summary":"The home of Indianapolis city councilor Ron Gibson was shot at 13 times following his support for data centers, with a 'No Data Centers' sign left behind, indicating a targeted attack against his political stance.","topics":["gun violence","political conflict","data centers"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Home of Indianapolis city councilor shot at over his support of datacenters The Guardian Targeted shooting at home of Indy city-county councilor includes anti-data center message WFYI 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-County Councilor Ron Gibson stands by data center after shooting axios.com","title":"Home of Indianapolis city councilor shot at over his support of datacenters - The Guardian","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_b32a3bc22952 in signals