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/CBMikwFBVV95cUxQZ0ttekgtUjk2a1k1OTRZX0FSODQ1WHZJcWRwbTJaTmN6VmVGcHlmVHlxaXRLd0paNlpKTlB2WU5FTjZ2Vk53YTY3VGJuMDk2SHVzZ2dHSXVqTHRlOGdhY05TNzlicXRtVzZ5dWgyeGJYZlU5ajBuNVNjTFE2MjRYbkQzbXROZF9zaFAwV0JYdDlDRms?oc=5","as_of":"2026-04-08T01:12:26.179133+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/CBMikwFBVV95cUxQZ0ttekgtUjk2a1k1OTRZX0FSODQ1WHZJcWRwbTJaTmN6VmVGcHlmVHlxaXRLd0paNlpKTlB2WU5FTjZ2Vk53YTY3VGJuMDk2SHVzZ2dHSXVqTHRlOGdhY05TNzlicXRtVzZ5dWgyeGJYZlU5ajBuNVNjTFE2MjRYbkQzbXROZF9zaFAwV0JYdDlDRms?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_907b50ee5e006bc8","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-08T01:14:42.211887+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxQZ0ttekgtUjk2a1k1OTRZX0FSODQ1WHZJcWRwbTJaTmN6VmVGcHlmVHlxaXRLd0paNlpKTlB2WU5FTjZ2Vk53YTY3VGJuMDk2SHVzZ2dHSXVqTHRlOGdhY05TNzlicXRtVzZ5dWgyeGJYZlU5ajBuNVNjTFE2MjRYbkQzbXROZF9zaFAwV0JYdDlDRms?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxQZ0ttekgtUjk2a1k1OTRZX0FSODQ1WHZJcWRwbTJaTmN6VmVGcHlmVHlxaXRLd0paNlpKTlB2WU5FTjZ2Vk53YTY3VGJuMDk2SHVzZ2dHSXVqTHRlOGdhY05TNzlicXRtVzZ5dWgyeGJYZlU5ajBuNVNjTFE2MjRYbkQzbXROZF9zaFAwV0JYdDlDRms?oc=5","source_event_id":"evt_ad6de08d2591","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b51069a201559cd4","published_at":"2026-04-07T22:13:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"ICE (U.S. Immigration and Customs Enforcement)","relevance":"detained the individual","symbol":"","type":"government_agency"},{"asset_class":"media","name":"AP News","relevance":"source of the report","symbol":"","type":"news_outlet"},{"asset_class":"person","name":"Wife of a US soldier","relevance":"person detained and then released","symbol":"","type":"individual"},{"asset_class":"person","name":"US soldier (spouse)","relevance":"spouse of the detained/released person","symbol":"","type":"individual"},{"asset_class":"location","name":"Military base (unspecified)","relevance":"site of ICE detention","symbol":"","type":"location"}],"event_type":"regulation","information_gaps":["The article text provided is not actually present (only page styling/HTML), so details such as the detainee\u2019s name, location (base/city/state), detention date, and legal basis for release are not available in the supplied content.","The timeline (how long she was detained) and whether any charges/case status were resolved are not specified in the provided excerpt.","No information is provided here on whether the release was due to court order, administrative decision, or other process."],"key_facts":["The report states the soldier\u2019s wife was released from federal immigration detention.","The detention occurred at a military base.","ICE is described as the detaining authority in the provided source summary.","The headline frames the event as a release from detention (not a new detention)."],"numeric_claims":[],"primary_claim":"The wife of a US soldier was released from federal immigration detention following detention by ICE at a military base.","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"AP reports that the wife of a US soldier was released from federal immigration detention after being detained by ICE at a military base. The release is the near-term development highlighted by the headline.","topics":["immigration detention","ICE actions","release from detention","US military family","federal immigration enforcement"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Wife of US soldier released from federal immigration detention AP News Newlywed wife of US soldier freed by ICE after detention at military base BBC Wife of American soldier is released from federal immigration detention Anchorage Daily News US soldier\u2019s wife released after arrest by ICE agents at military base The Guardian ICE Agents Detain Newlywed Spouse of Soldier Training to Deploy The New York Times","title":"Wife of US soldier released from federal immigration detention - AP News","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_2463d7206f0a in signals