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/CBMiyAFBVV95cUxNU0RFUG5Tc2pmaWJjS0lRNHdPM2pCbEhYcW0ycW1OaDJlMmVRWDBUcEI4UmZFRnBNQW5pX0Q5azQwOXlWNl9kZWlZMFhNdkhJd25DY0ozXzh0MVVuVTZwbnAxWGNYNDN3S1BESDBRZk90R2NXYVdMRlk0ODZyWVRReEdlY3VzLXhZeEJZS3pIRTMtYzJkRVVJYlJTTDdTaUkxVmVhUHdlLVdZWU1GWGVrTzZrb3JwSWpnTXNBak0xUE9iUHk3ZkdVaQ?oc=5","as_of":"2026-04-07T02:56:07.915760+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/CBMiyAFBVV95cUxNU0RFUG5Tc2pmaWJjS0lRNHdPM2pCbEhYcW0ycW1OaDJlMmVRWDBUcEI4UmZFRnBNQW5pX0Q5azQwOXlWNl9kZWlZMFhNdkhJd25DY0ozXzh0MVVuVTZwbnAxWGNYNDN3S1BESDBRZk90R2NXYVdMRlk0ODZyWVRReEdlY3VzLXhZeEJZS3pIRTMtYzJkRVVJYlJTTDdTaUkxVmVhUHdlLVdZWU1GWGVrTzZrb3JwSWpnTXNBak0xUE9iUHk3ZkdVaQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9ed443a46bd9bde8","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-07T15:51:58.762194+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiyAFBVV95cUxNU0RFUG5Tc2pmaWJjS0lRNHdPM2pCbEhYcW0ycW1OaDJlMmVRWDBUcEI4UmZFRnBNQW5pX0Q5azQwOXlWNl9kZWlZMFhNdkhJd25DY0ozXzh0MVVuVTZwbnAxWGNYNDN3S1BESDBRZk90R2NXYVdMRlk0ODZyWVRReEdlY3VzLXhZeEJZS3pIRTMtYzJkRVVJYlJTTDdTaUkxVmVhUHdlLVdZWU1GWGVrTzZrb3JwSWpnTXNBak0xUE9iUHk3ZkdVaQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"mprnews.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiyAFBVV95cUxNU0RFUG5Tc2pmaWJjS0lRNHdPM2pCbEhYcW0ycW1OaDJlMmVRWDBUcEI4UmZFRnBNQW5pX0Q5azQwOXlWNl9kZWlZMFhNdkhJd25DY0ozXzh0MVVuVTZwbnAxWGNYNDN3S1BESDBRZk90R2NXYVdMRlk0ODZyWVRReEdlY3VzLXhZeEJZS3pIRTMtYzJkRVVJYlJTTDdTaUkxVmVhUHdlLVdZWU1GWGVrTzZrb3JwSWpnTXNBak0xUE9iUHk3ZkdVaQ?oc=5","source_event_id":"evt_abbb21b55d5e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"99a5af16ee573f97","published_at":"2026-04-06T22:00:00+00:00","publisher_domain":"mprnews.org","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"ICE","relevance":"high","symbol":"ICE","type":"government agency"},{"asset_class":"geopolitical","name":"Minneapolis","relevance":"high","symbol":"MN","type":"city"}],"event_type":"conflict","information_gaps":["Details on the content of the video are not provided.","The implications of the video on ICE's operations or public perception are unclear."],"key_facts":["The video shows events leading up to the shooting that contradict ICE's claims.","Charges against two men involved in the incident have collapsed."],"numeric_claims":[],"primary_claim":"The video undermines ICE's account of a non-fatal shooting by a federal agent in Minneapolis.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"A newly released video contradicts claims made by ICE regarding a non-fatal shooting incident in Minneapolis, raising questions about the agency's narrative.","topics":["law enforcement","video evidence","public scrutiny"]},"source":"MPR News","source_domain":"mprnews.org","source_url":"https://www.mprnews.org","summary":"Minneapolis releases video that undermines ICE claims about non-fatal shooting MPR News ICE\u2019s story of a Minneapolis shooting fell apart. New video shows what happened before an agent fired CNN Newly Obtained Video of Minneapolis Shooting Undermines ICE Account The New York Times Video brings new scrutiny to an ICE shooting in Minneapolis after charges against 2 men collapsed AP News Newly released video shows non-fatal shooting by federal agent in Minneapolis 5 EYEWITNESS NEWS","title":"Minneapolis releases video that undermines ICE claims about non-fatal shooting - MPR News","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_9516cef73e29 in signals