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-08T01:43:33.465596+00:00","dedupe_key":"signal_enriched:news_delta:4b794ca9b3dacd70","evidence_event_ids":["evt_6c1018a4f138"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMibEFVX3lxTE1HVHBsN1JtUlRIX054UHBhRlA3QXliV0hod0RHb1U3VG4tT21RTnpSOTVjd09hUFdLMU1tZ0NYaFFYRkxHTjdKeHRGQlhtS2pmWkhFMFNsOFl2LUpkVk9yVUxrSGJrWkIzcUpmUA?oc=5","as_of":"2026-04-08T01:43:33.465596+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/CBMibEFVX3lxTE1HVHBsN1JtUlRIX054UHBhRlA3QXliV0hod0RHb1U3VG4tT21RTnpSOTVjd09hUFdLMU1tZ0NYaFFYRkxHTjdKeHRGQlhtS2pmWkhFMFNsOFl2LUpkVk9yVUxrSGJrWkIzcUpmUA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_70721238f7dbf2f7","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-08T01:44:18.116860+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMibEFVX3lxTE1HVHBsN1JtUlRIX054UHBhRlA3QXliV0hod0RHb1U3VG4tT21RTnpSOTVjd09hUFdLMU1tZ0NYaFFYRkxHTjdKeHRGQlhtS2pmWkhFMFNsOFl2LUpkVk9yVUxrSGJrWkIzcUpmUA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnn.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMibEFVX3lxTE1HVHBsN1JtUlRIX054UHBhRlA3QXliV0hod0RHb1U3VG4tT21RTnpSOTVjd09hUFdLMU1tZ0NYaFFYRkxHTjdKeHRGQlhtS2pmWkhFMFNsOFl2LUpkVk9yVUxrSGJrWkIzcUpmUA?oc=5","source_event_id":"evt_6c1018a4f138","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"afc23ecd5b977df0","published_at":"2026-04-07T19:38:53+00:00","publisher_domain":"cnn.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"government_agency","name":"U.S. Immigration and Customs Enforcement (ICE) agents","relevance":"primary actors","symbol":"","type":"law_enforcement"},{"asset_class":"individual","name":"Suspect (man in car)","relevance":"injured party","symbol":"","type":"individual"},{"asset_class":"geography","name":"Central California (traffic stop location)","relevance":"incident location","symbol":"","type":"location"},{"asset_class":"geography","name":"Northern California (related reports)","relevance":"context/possible same or related incident","symbol":"","type":"location"},{"asset_class":"geography","name":"Patterson, California","relevance":"location mentioned in source summary (other outlet)","symbol":"","type":"location"},{"asset_class":"geography","name":"Stanislaus County / along I-5","relevance":"location mentioned in source summary (other outlet)","symbol":"","type":"location"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains only page styling/boilerplate, not the actual CNN article content; therefore details beyond the headline and the provided source summary cannot be verified here.","It is unclear whether the Central California traffic-stop shooting (CNN) is the same incident as the Northern California/Patterson/I-5/Stanislaus County incidents referenced in the source summary; the signal does not explicitly confirm they are identical.","No information is provided here about the suspect\u2019s identity, the circumstances leading to the shooting, number of shots, or whether ICE or local agencies have released official statements.","No confirmed timeline (date/time) of the incident is included in the provided text."],"key_facts":["CNN headline states ICE agents shot a suspect following a traffic stop in Central California.","Source summary from multiple outlets indicates an ICE-involved shooting in Northern California.","ABC News (per source summary) says an FBI presence was reported on scene of an ICE-involved shooting in Patterson, California.","KCRA (per source summary) reports a man was in critical condition after a shooting involving ICE agents along I-5 in Stanislaus County."],"numeric_claims":[],"primary_claim":"ICE agents shot a suspect following a traffic stop in Central California, according to CNN.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"CNN reports that ICE agents shot a suspect after a traffic stop in Central California. The incident is part of a broader set of reports describing an ICE-involved shooting in California with the suspect reported as critically injured.","topics":["ICE","traffic stop","police shooting","use of force","California","I-5","Stanislaus County","Patterson"]},"source":"CNN","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"ICE agents shoot suspect following traffic stop in Central Califonia CNN ICE involved in shooting in Northern California NBC News ICE agents shoot man in car in northern California The Guardian FBI on scene of ICE-involved shooting in Patterson, California ABC News Man in critical condition after shooting involving ICE agents along I-5 in Stanislaus County KCRA","title":"ICE agents shoot suspect following traffic stop in Central Califonia - CNN","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 3315 in events