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/CBMibEFVX3lxTE10X0hFLTZRNE1RUkNhN1p0cU9SWFdxbWJtX0RPVjU5OFVNY2FncVpHTFBKX1JLaFN4dm0yMU1Rc25FTlhLVWFfSFA4M0tIVnFMR2pJMFhnWC0xdnhWbS1TTFlCcDdDcGt2eFJmcdIBckFVX3lxTE5ULUp3RHo5ZXhwVlBwRmJUOElOeFhmZVdBNHhTLWIxUENLQmh6MTNtc252dy1OeFNSS2ZKVGhrbnM4MC1yakZ5c0lGVFFqT0JSWUlBZ2FmejNaS1U3SmNURnBPS0d6N1duWEdCYmFOYXB6UQ?oc=5","as_of":"2026-04-07T23:23:38.767180+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/CBMibEFVX3lxTE10X0hFLTZRNE1RUkNhN1p0cU9SWFdxbWJtX0RPVjU5OFVNY2FncVpHTFBKX1JLaFN4dm0yMU1Rc25FTlhLVWFfSFA4M0tIVnFMR2pJMFhnWC0xdnhWbS1TTFlCcDdDcGt2eFJmcdIBckFVX3lxTE5ULUp3RHo5ZXhwVlBwRmJUOElOeFhmZVdBNHhTLWIxUENLQmh6MTNtc252dy1OeFNSS2ZKVGhrbnM4MC1yakZ5c0lGVFFqT0JSWUlBZ2FmejNaS1U3SmNURnBPS0d6N1duWEdCYmFOYXB6UQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c1206cc5e1cec394","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-08T00:34:44.396300+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMibEFVX3lxTE10X0hFLTZRNE1RUkNhN1p0cU9SWFdxbWJtX0RPVjU5OFVNY2FncVpHTFBKX1JLaFN4dm0yMU1Rc25FTlhLVWFfSFA4M0tIVnFMR2pJMFhnWC0xdnhWbS1TTFlCcDdDcGt2eFJmcdIBckFVX3lxTE5ULUp3RHo5ZXhwVlBwRmJUOElOeFhmZVdBNHhTLWIxUENLQmh6MTNtc252dy1OeFNSS2ZKVGhrbnM4MC1yakZ5c0lGVFFqT0JSWUlBZ2FmejNaS1U3SmNURnBPS0d6N1duWEdCYmFOYXB6UQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMibEFVX3lxTE10X0hFLTZRNE1RUkNhN1p0cU9SWFdxbWJtX0RPVjU5OFVNY2FncVpHTFBKX1JLaFN4dm0yMU1Rc25FTlhLVWFfSFA4M0tIVnFMR2pJMFhnWC0xdnhWbS1TTFlCcDdDcGt2eFJmcdIBckFVX3lxTE5ULUp3RHo5ZXhwVlBwRmJUOElOeFhmZVdBNHhTLWIxUENLQmh6MTNtc252dy1OeFNSS2ZKVGhrbnM4MC1yakZ5c0lGVFFqT0JSWUlBZ2FmejNaS1U3SmNURnBPS0d6N1duWEdCYmFOYXB6UQ?oc=5","source_event_id":"evt_bae1d7ed1bd9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e0e242e248619b1d","published_at":"2026-04-07T18:46:03+00:00","publisher_domain":"cnbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"ICE (U.S. Immigration and Customs Enforcement) agents","relevance":"primary_actor","symbol":"","type":"government_agency"},{"asset_class":"government","name":"DHS (U.S. Department of Homeland Security)","relevance":"source_of_claim","symbol":"","type":"government_agency"},{"asset_class":"person","name":"Man shot","relevance":"injured_subject","symbol":"","type":"person"},{"asset_class":"region","name":"California","relevance":"incident_location","symbol":"","type":"location"},{"asset_class":"infrastructure","name":"Interstate 5 (I-5)","relevance":"reported_impact","symbol":"","type":"infrastructure"}],"event_type":"conflict","information_gaps":["The cleaned article text provided is largely HTML/CSS and does not contain the substantive reporting details; extraction is therefore based on the headline and the provided source summary snippet.","Exact date/time of the incident is not provided in the supplied text.","The man\u2019s identity, age, and immigration status are not provided.","Whether the shooting occurred in Patterson, CA or another California location is not fully disambiguated from the provided snippet.","Injury severity and number of people injured are not specified beyond \u201c1 hospitalized.\u201d","Details of the alleged homicide case linkage are not included in the supplied text."],"key_facts":["ICE agents shot a man in California, according to CNBC.","DHS is cited as saying the man had \u201cweaponized\u201d a vehicle.","The incident involved a traffic stop/vehicle-related confrontation (per the provided source summary context).","At least one person was hospitalized after the shooting (per the provided source summary context).","The incident caused major delays on Interstate 5 (per the provided source summary context)."],"numeric_claims":[],"primary_claim":"DHS says ICE agents shot a man in California after he \u201cweaponized\u201d a vehicle.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"CNBC reports that ICE agents shot a man in California after the DHS said he \u201cweaponized\u201d a vehicle during an incident tied to immigration enforcement. The shooting resulted in at least one hospitalization and caused traffic disruption in the area.","topics":["ICE","DHS statement","police/military shooting","vehicle weaponization","California traffic disruption","immigration enforcement"]},"source":"CNBC","source_domain":"cnbc.com","source_url":"https://www.cnbc.com","summary":"ICE agents shoot man in California after he 'weaponized' vehicle, DHS says CNBC 1 hospitalized after shooting involving ICE agents in Central California traffic stop CNN FBI on scene of ICE-involved shooting in Patterson, California ABC News Major delays on Interstate 5 after ICE agents shoot at man tied to homicide case SFGATE Live updates: ICE involved in shooting in Northern California nbcnews.com","title":"ICE agents shoot man in California after he 'weaponized' vehicle, DHS says - CNBC","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_e8239fd5c764 in signals