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-08T04:03:42.325558+00:00","dedupe_key":"signal_enriched:news_delta:e950c750725e1cba","evidence_event_ids":["evt_5b498591e863"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxQOXFabXVxbHNCVEZJcGxBdFZHR2lCajE3a0diSHhvdHQ1OFFYeE00ZWJkWkRSS1ViQmlfc1kzWnY2MmFNYUFrQ3pwbzBtM3FkcXNHZGduN29ZWlZDS1Y0TE81Tl9menpSOEQ3VjVzendKZTBYajNlaVd5LXlsYWhPU0VNRQ?oc=5","as_of":"2026-04-08T04:03:42.325558+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/CBMigwFBVV95cUxQOXFabXVxbHNCVEZJcGxBdFZHR2lCajE3a0diSHhvdHQ1OFFYeE00ZWJkWkRSS1ViQmlfc1kzWnY2MmFNYUFrQ3pwbzBtM3FkcXNHZGduN29ZWlZDS1Y0TE81Tl9menpSOEQ3VjVzendKZTBYajNlaVd5LXlsYWhPU0VNRQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_81510cf361893074","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-08T04:04:12.821275+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxQOXFabXVxbHNCVEZJcGxBdFZHR2lCajE3a0diSHhvdHQ1OFFYeE00ZWJkWkRSS1ViQmlfc1kzWnY2MmFNYUFrQ3pwbzBtM3FkcXNHZGduN29ZWlZDS1Y0TE81Tl9menpSOEQ3VjVzendKZTBYajNlaVd5LXlsYWhPU0VNRQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"sfgate.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxQOXFabXVxbHNCVEZJcGxBdFZHR2lCajE3a0diSHhvdHQ1OFFYeE00ZWJkWkRSS1ViQmlfc1kzWnY2MmFNYUFrQ3pwbzBtM3FkcXNHZGduN29ZWlZDS1Y0TE81Tl9menpSOEQ3VjVzendKZTBYajNlaVd5LXlsYWhPU0VNRQ?oc=5","source_event_id":"evt_5b498591e863","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1678ae65ce67e6cd","published_at":"2026-04-07T20:42:50+00:00","publisher_domain":"sfgate.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"ICE (U.S. Immigration and Customs Enforcement) agents","relevance":"primary","symbol":"","type":"organization"},{"asset_class":"","name":"Man in the car (tied to a homicide case)","relevance":"primary","symbol":"","type":"person"},{"asset_class":"transportation","name":"Interstate 5 (I-5)","relevance":"primary","symbol":"","type":"infrastructure"},{"asset_class":"","name":"FBI","relevance":"secondary","symbol":"","type":"organization"},{"asset_class":"","name":"Patterson, California","relevance":"secondary","symbol":"","type":"location"},{"asset_class":"","name":"Northern California","relevance":"secondary","symbol":"","type":"location"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided appears to be mostly unrelated HTML/CSS and does not contain the actual narrative details; extraction is therefore based on the headline and the provided source summary only.","The exact date/time of the incident and the specific I-5 segment affected are not stated in the provided text.","The man\u2019s identity, the nature of the homicide case, and whether there were injuries beyond the shooting are not specified in the provided content.","Whether I-5 delays were due to a full closure vs. slowed traffic is not specified."],"key_facts":["SFGATE headline states there were major delays on Interstate 5 after ICE agents shot a man tied to a homicide case.","The incident is described as occurring in Northern California.","Other referenced coverage in the provided source summary indicates the shooting involved ICE and that the FBI was on scene in Patterson, California.","The provided source summary also includes an attorney statement (Modesto Bee) that the man shot by ICE in Patterson is alive and 'stable'."],"numeric_claims":[],"primary_claim":"ICE agents shot a man tied to a homicide case, leading to major delays on Interstate 5 in Northern California.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"SFGATE reports major traffic delays on Interstate 5 following a shooting involving ICE agents and a man reportedly tied to a homicide case in Northern California. The incident prompted an FBI/other law-enforcement response and caused disruption on I-5.","topics":["ICE shooting","law enforcement incident","traffic disruption","Interstate 5 delays","homicide case connection","Northern California"]},"source":"SFGATE","source_domain":"sfgate.com","source_url":"https://www.sfgate.com","summary":"Major delays on Interstate 5 after ICE agents shoot at man tied to homicide case SFGATE ICE agents shoot man in car in northern California The Guardian ICE involved in shooting in Northern California NBC News Attorney for family of man shot by ICE in Patterson says he\u2019s alive and \u2018stable\u2019 Modesto Bee FBI on scene of ICE-involved shooting in Patterson, California ABC News","title":"Major delays on Interstate 5 after ICE agents shoot at man tied to homicide case - SFGATE","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 4479 in events