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/CBMidEFVX3lxTE1NOVk2eEtRZWFzNFpueG1qU1l5MmxfQzl1dGhnVkplTjdCYnROdHgtYXZaRTAtNUpWQjdwdnNHUUt6VV9UMzhPblI4MmhISVp4a3R4WHFuSHhMaFJjR3BBei1wdFlFM1JLTmxjTUxEY0w4QTVK?oc=5","as_of":"2026-04-08T00:26:38.253170+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/CBMidEFVX3lxTE1NOVk2eEtRZWFzNFpueG1qU1l5MmxfQzl1dGhnVkplTjdCYnROdHgtYXZaRTAtNUpWQjdwdnNHUUt6VV9UMzhPblI4MmhISVp4a3R4WHFuSHhMaFJjR3BBei1wdFlFM1JLTmxjTUxEY0w4QTVK?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b6727e11d563d2ef","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:42:30.639541+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMidEFVX3lxTE1NOVk2eEtRZWFzNFpueG1qU1l5MmxfQzl1dGhnVkplTjdCYnROdHgtYXZaRTAtNUpWQjdwdnNHUUt6VV9UMzhPblI4MmhISVp4a3R4WHFuSHhMaFJjR3BBei1wdFlFM1JLTmxjTUxEY0w4QTVK?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMidEFVX3lxTE1NOVk2eEtRZWFzNFpueG1qU1l5MmxfQzl1dGhnVkplTjdCYnROdHgtYXZaRTAtNUpWQjdwdnNHUUt6VV9UMzhPblI4MmhISVp4a3R4WHFuSHhMaFJjR3BBei1wdFlFM1JLTmxjTUxEY0w4QTVK?oc=5","source_event_id":"evt_7941705e2776","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8280466920590280","published_at":"2026-04-08T00:09:29+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"U.S. Immigration and Customs Enforcement (ICE) agents","relevance":"primary actor","symbol":"","type":"organization"},{"asset_class":"other","name":"Suspect (unnamed)","relevance":"injured party","symbol":"","type":"person"},{"asset_class":"other","name":"Northern California (traffic stop location)","relevance":"incident location","symbol":"","type":"location"},{"asset_class":"other","name":"Patterson, CA","relevance":"specific location mentioned in source summary","symbol":"","type":"location"},{"asset_class":"other","name":"Interstate 5 (I-5)","relevance":"reported disruption/catalyst for near-term impact","symbol":"","type":"infrastructure"},{"asset_class":"other","name":"Modesto Bee","relevance":"source mentioning ICE claim","symbol":"","type":"publisher"},{"asset_class":"other","name":"SFGATE","relevance":"source mentioning I-5 delays","symbol":"","type":"publisher"},{"asset_class":"other","name":"CNN","relevance":"source mentioning hospitalization/traffic stop","symbol":"","type":"publisher"},{"asset_class":"other","name":"NBC News","relevance":"source mentioning ICE shooting claim","symbol":"","type":"publisher"},{"asset_class":"other","name":"The New York Times","relevance":"headline source","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The cleaned article text provided is not usable for extracting specific details (it appears to contain unrelated page styling/HTML).","Exact date/time of the incident is not present in the provided content.","The suspect\u2019s identity, age, and condition (severity) are not specified in the provided text.","Whether the suspect was shot by ICE agents or other circumstances are not fully detailed beyond the headline/summary.","No information is provided on charges, investigation status, or official findings beyond ICE\u2019s stated rationale."],"key_facts":["ICE agents shot into a car during an incident described as a traffic stop in Northern California.","A suspect was injured and hospitalized (reported in the provided source summary).","ICE stated it shot a gang member in Patterson, CA, who allegedly tried to \u201cweaponize\u201d a vehicle (reported in the provided source summary).","Major delays on Interstate 5 were reported following the shooting (reported in the provided source summary).","The suspect is described as being tied to a homicide case (reported in the provided source summary)."],"numeric_claims":[],"primary_claim":"ICE agents shot into a car during a traffic stop in Northern California, injuring a suspect who was hospitalized.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"ICE agents shot into a car during a traffic stop in Northern/Central California, injuring a suspect who was hospitalized. The incident caused major delays on Interstate 5 and is tied to an ICE claim that the suspect attempted to use the vehicle as a weapon.","topics":["ICE","shooting incident","traffic stop","law enforcement","injury/hospitalization","vehicle as weapon","Northern California","Patterson CA","Interstate 5 delays","homicide/gang-related allegation"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"ICE Agents Shoot Into a Car, Injuring a Suspect in Northern California The New York Times 1 hospitalized after shooting involving ICE agents in Central California traffic stop CNN ICE involved in shooting in Northern California NBC News ICE says it shot gang member in Patterson, CA, who tried to \u2018weaponize\u2019 vehicle Modesto Bee Major delays on Interstate 5 after ICE agents shoot at man tied to homicide case SFGATE","title":"ICE Agents Shoot Into a Car, Injuring a Suspect in Northern California - The New York Times","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_34070b256547 in signals