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/CBMikwFBVV95cUxOTXZobTVSQVB6a3pvVEEyd0ktMjBUWlEtYjhrb3JfRmh1Um1zNEhZLUo0eGhLREZQLWZPbnM0S2NOMzNxQ3ZqUi04RzRFS2lfYUZ6bUNoSDhlbkxub3JMT2E2YzJ0TmJwcTNhZVBEcElyczJqcEl1VTNKbEd1VThMN21sUnBnTkhPdmZjV3JzZ01yQU0?oc=5","as_of":"2026-04-06T21:50:13.340078+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/CBMikwFBVV95cUxOTXZobTVSQVB6a3pvVEEyd0ktMjBUWlEtYjhrb3JfRmh1Um1zNEhZLUo0eGhLREZQLWZPbnM0S2NOMzNxQ3ZqUi04RzRFS2lfYUZ6bUNoSDhlbkxub3JMT2E2YzJ0TmJwcTNhZVBEcElyczJqcEl1VTNKbEd1VThMN21sUnBnTkhPdmZjV3JzZ01yQU0?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4bdbec971890c6e7","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-07T11:21:05.811001+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxOTXZobTVSQVB6a3pvVEEyd0ktMjBUWlEtYjhrb3JfRmh1Um1zNEhZLUo0eGhLREZQLWZPbnM0S2NOMzNxQ3ZqUi04RzRFS2lfYUZ6bUNoSDhlbkxub3JMT2E2YzJ0TmJwcTNhZVBEcElyczJqcEl1VTNKbEd1VThMN21sUnBnTkhPdmZjV3JzZ01yQU0?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"axios.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxOTXZobTVSQVB6a3pvVEEyd0ktMjBUWlEtYjhrb3JfRmh1Um1zNEhZLUo0eGhLREZQLWZPbnM0S2NOMzNxQ3ZqUi04RzRFS2lfYUZ6bUNoSDhlbkxub3JMT2E2YzJ0TmJwcTNhZVBEcElyczJqcEl1VTNKbEd1VThMN21sUnBnTkhPdmZjV3JzZ01yQU0?oc=5","source_event_id":"evt_c68e599a8f68","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ebf0e2dee9265d89","published_at":"2026-04-06T19:15:07+00:00","publisher_domain":"axios.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"ICE","relevance":"directly involved in the incident","symbol":"ICE","type":"government agency"},{"asset_class":"geographic","name":"North Minneapolis","relevance":"site of the incident","symbol":"","type":"location"}],"event_type":"conflict","information_gaps":["Details on the content of the video footage are not provided.","The specific implications for ICE's operations or policies are unclear."],"key_facts":["New video footage contradicts ICE's self-defense claims.","The shooting incident was non-fatal.","The video raises questions about the agency's credibility."],"numeric_claims":[],"primary_claim":"New video footage undermines ICE's account of a shooting incident in North Minneapolis, indicating potential misrepresentation by the agency.","relevance_score":0.85,"sentiment":"negative","source_quality":"high","summary":"Newly released video footage contradicts the claims made by ICE regarding a shooting incident in North Minneapolis, suggesting that the agency may have misrepresented the events.","topics":["law enforcement","video evidence","public trust","accountability"]},"source":"Axios","source_domain":"axios.com","source_url":"https://www.axios.com","summary":"New video contradicts ICE's original story about North Minneapolis shooting Axios Newly Obtained Video of Minneapolis Shooting Undermines ICE Account nytimes.com New footage of nonfatal ICE shooting in Minneapolis contradicts agency\u2019s self-defense claims Star Tribune New surveillance footage released in north Minneapolis ICE shooting agents lied about under oath CBS News Newly released video shows non-fatal shooting by federal agent in Minneapolis 5 EYEWITNESS NEWS","title":"New video contradicts ICE's original story about North Minneapolis shooting - Axios","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_b70bb5f9c323 in signals