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-07T23:23:38.767180+00:00","dedupe_key":"signal_enriched:news_delta:9e9f9cb9b9f18744","evidence_event_ids":["evt_bae1d7ed1bd9"],"signal_type":"news_headline_delta","source":"news_rss","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

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