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/CBMihAFBVV95cUxQTlB2UTdhbEs2MlVTeHdjYnVpNldDSTRUY05XT3BBcFJvcFVhMERyY25NVUtweGNERm8xTXo1SXJkbHUySVZQcXFLZkxLQUlTTm10WVJEZlhWMlo4a2R0NENZVWk5STNzUm90WnJYWkV6bzUwOG9LTXR0THlFSlNxQ1BLbEw?oc=5","as_of":"2026-04-08T03:15:56.548575+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQTlB2UTdhbEs2MlVTeHdjYnVpNldDSTRUY05XT3BBcFJvcFVhMERyY25NVUtweGNERm8xTXo1SXJkbHUySVZQcXFLZkxLQUlTTm10WVJEZlhWMlo4a2R0NENZVWk5STNzUm90WnJYWkV6bzUwOG9LTXR0THlFSlNxQ1BLbEw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0e074c79539c8ecc","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T03:48:06.856308+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQTlB2UTdhbEs2MlVTeHdjYnVpNldDSTRUY05XT3BBcFJvcFVhMERyY25NVUtweGNERm8xTXo1SXJkbHUySVZQcXFLZkxLQUlTTm10WVJEZlhWMlo4a2R0NENZVWk5STNzUm90WnJYWkV6bzUwOG9LTXR0THlFSlNxQ1BLbEw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxQTlB2UTdhbEs2MlVTeHdjYnVpNldDSTRUY05XT3BBcFJvcFVhMERyY25NVUtweGNERm8xTXo1SXJkbHUySVZQcXFLZkxLQUlTTm10WVJEZlhWMlo4a2R0NENZVWk5STNzUm90WnJYWkV6bzUwOG9LTXR0THlFSlNxQ1BLbEw?oc=5","source_event_id":"evt_9da4c29a35c7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7e5ba2eb6641c59d","published_at":"2026-04-08T01:17:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"ICE (U.S. Immigration and Customs Enforcement) agents","relevance":"primary actor","symbol":"","type":"organization"},{"asset_class":"other","name":"Man/suspect in the car","relevance":"injured/targeted party","symbol":"","type":"person"},{"asset_class":"other","name":"Northern California (location)","relevance":"incident location","symbol":"","type":"location"},{"asset_class":"other","name":"Patterson, California","relevance":"specific referenced location (ICE says shooting occurred there)","symbol":"","type":"location"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the Guardian\u2019s actual narrative details; therefore, only the headline and the provided source summary can be grounded.","The signal does not specify the date/time of the incident, the suspect\u2019s identity, or the outcome/injuries (fatal vs. non-fatal).","It is unclear whether the northern California incident and the Patterson, CA incident are the same event or separate events referenced by different outlets.","No details are provided about the specific traffic stop circumstances (e.g., alleged offense, vehicle description, number of shots).","The claim that the suspect attempted to \u201cweaponize\u201d the vehicle is attributed to ICE in the source summary, but the underlying evidence is not included in the provided text."],"key_facts":["The Guardian headline reports that ICE agents shot a man in a car in northern California.","The signal\u2019s source summary indicates ICE was involved in a shooting following a traffic stop in Central California (per NBC News reference).","The signal\u2019s source summary indicates ICE said it shot a gang member in Patterson, CA, who tried to \u201cweaponize\u201d a vehicle (per Modesto Bee reference).","The signal\u2019s source summary indicates FBI personnel were on scene of an ICE-involved shooting in Patterson, California (per abcnews.com reference)."],"numeric_claims":[],"primary_claim":"ICE agents shot a suspect in a car in northern California after a traffic stop.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"ICE agents shot a man in a car in northern California following a traffic stop, according to multiple outlets referenced in the signal. The incident is tied to an ICE claim that the suspect attempted to use the vehicle as a weapon.","topics":["ICE","shooting","traffic stop","law enforcement","immigration enforcement","public safety"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"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 California CNN ICE says it shot gang member in Patterson, CA, who tried to \u2018weaponize\u2019 vehicle Modesto Bee FBI on scene of ICE-involved shooting in Patterson, California abcnews.com","title":"ICE agents shoot man in car in northern California - The Guardian","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_452f2af3c7b2 in signals