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/CBMikgFBVV95cUxQZG9fSGRpVG8tQjB5MF9Yd0toRTZ4Z2g1Vks1ZjBOTWRpZnd0cGRjZ00xVzgtWHdWSmJQMVRub0U4dlpOdG44WmxYZncxTGJqYWxDSVc2ejdCWEZTMGpWQ3JuUDJuQlVKRjZHQkNFNmtaOTBjZloweE5BYm9LT04taXk4b2pRT29qcFQ4QzVwcENQQQ?oc=5","as_of":"2026-04-08T02:13:53.708105+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/CBMikgFBVV95cUxQZG9fSGRpVG8tQjB5MF9Yd0toRTZ4Z2g1Vks1ZjBOTWRpZnd0cGRjZ00xVzgtWHdWSmJQMVRub0U4dlpOdG44WmxYZncxTGJqYWxDSVc2ejdCWEZTMGpWQ3JuUDJuQlVKRjZHQkNFNmtaOTBjZloweE5BYm9LT04taXk4b2pRT29qcFQ4QzVwcENQQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_49f5a6466055ab83","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-08T02:14:45.550415+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxQZG9fSGRpVG8tQjB5MF9Yd0toRTZ4Z2g1Vks1ZjBOTWRpZnd0cGRjZ00xVzgtWHdWSmJQMVRub0U4dlpOdG44WmxYZncxTGJqYWxDSVc2ejdCWEZTMGpWQ3JuUDJuQlVKRjZHQkNFNmtaOTBjZloweE5BYm9LT04taXk4b2pRT29qcFQ4QzVwcENQQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxQZG9fSGRpVG8tQjB5MF9Yd0toRTZ4Z2g1Vks1ZjBOTWRpZnd0cGRjZ00xVzgtWHdWSmJQMVRub0U4dlpOdG44WmxYZncxTGJqYWxDSVc2ejdCWEZTMGpWQ3JuUDJuQlVKRjZHQkNFNmtaOTBjZloweE5BYm9LT04taXk4b2pRT29qcFQ4QzVwcENQQQ?oc=5","source_event_id":"evt_487eb4d37573","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"634e7e235283f6d9","published_at":"2026-04-08T00:02:13+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"U.S. Immigration and Customs Enforcement (ICE)","relevance":"primary_actor","symbol":"","type":"government_agency"},{"asset_class":"government","name":"U.S. Department of Homeland Security (DHS)","relevance":"source_of_allegation","symbol":"","type":"government_agency"},{"asset_class":"media","name":"The Washington Post","relevance":"publisher","symbol":"","type":"news_outlet"}],"event_type":"conflict","information_gaps":["Exact location in California (city/county) is not provided in the supplied text.","Timing/date of the incident is not provided.","Whether the shooting occurred after a traffic stop vs. another type of encounter is not confirmed in the provided Washington Post excerpt.","Injury details (number of shots, severity specifics beyond \u201ccritical condition\u201d) are not provided.","Status/identity of the suspect and whether charges/arrest details exist are not provided.","Whether there were any injuries to ICE agents or bystanders is not provided."],"key_facts":["A shooting incident involved ICE agents in California.","The injured man is reported to be in critical condition.","DHS (as cited in the provided source summary) alleges the man \u201cweaponized\u201d a vehicle."],"numeric_claims":[],"primary_claim":"A man is in critical condition following an ICE shooting incident in California, after DHS said he \u201cweaponized\u201d a vehicle.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"The Washington Post reports that a man is in critical condition after an ICE shooting incident in California. DHS says ICE agents shot the man after he allegedly \u201cweaponized\u201d a vehicle during the encounter.","topics":["ICE","shooting incident","California","DHS statement","vehicle attack allegation","law enforcement use of force"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Man in critical condition after ICE shooting incident in California The Washington Post ICE agents shoot man in California after he 'weaponized' vehicle, DHS says CNBC ICE agents shoot man in car in northern California The Guardian ICE involved in shooting in Northern California NBC News ICE agents shoot suspect following traffic stop in Central Califonia CNN","title":"Man in critical condition after ICE shooting incident in California - The Washington Post","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_78b2c5d2f78e in signals