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/CBMiWkFVX3lxTE9zcHFaNTBkYlZwY3NtWG5uRE1GR1lmX2FoeDRvTmlyZ1hXRklkVUF1MzN0NXRyRGU0d3JRRk52XzAwNS1lbUJpWDZKck9QYUphLTJBdjQ1eHA4dw?oc=5","as_of":"2026-04-08T01:43:33.384665+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/CBMiWkFVX3lxTE9zcHFaNTBkYlZwY3NtWG5uRE1GR1lmX2FoeDRvTmlyZ1hXRklkVUF1MzN0NXRyRGU0d3JRRk52XzAwNS1lbUJpWDZKck9QYUphLTJBdjQ1eHA4dw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_fdbf31b5fdc04798","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-08T01:44:02.470998+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE9zcHFaNTBkYlZwY3NtWG5uRE1GR1lmX2FoeDRvTmlyZ1hXRklkVUF1MzN0NXRyRGU0d3JRRk52XzAwNS1lbUJpWDZKck9QYUphLTJBdjQ1eHA4dw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE9zcHFaNTBkYlZwY3NtWG5uRE1GR1lmX2FoeDRvTmlyZ1hXRklkVUF1MzN0NXRyRGU0d3JRRk52XzAwNS1lbUJpWDZKck9QYUphLTJBdjQ1eHA4dw?oc=5","source_event_id":"evt_aa70cb52138d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c50b4b02ee13b0a2","published_at":"2026-04-07T22:29:28+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"ICE (U.S. Immigration and Customs Enforcement)","relevance":"primary actor","symbol":"","type":"government_agency"},{"asset_class":"person","name":"Newlywed wife of a US soldier (name not present in provided text)","relevance":"detained and released party","symbol":"","type":"individual"},{"asset_class":"person","name":"US soldier (name not present in provided text)","relevance":"spouse of detained/released party","symbol":"","type":"individual"},{"asset_class":"location","name":"Military base (location not present in provided text)","relevance":"detention site","symbol":"","type":"location"}],"event_type":"regulation","information_gaps":["The wife\u2019s name, the soldier\u2019s name, and the specific military base/location are not included in the provided cleaned text.","The timeline (date of detention and date/time of release) is not provided in the supplied content.","The legal basis for detention and the reason for release are not included in the supplied content.","Whether any charges, court proceedings, or appeals occurred is not stated in the provided content."],"key_facts":["ICE agents detained the newlywed wife of a US soldier at a military base (per BBC headline).","The wife was released after being held in federal immigration detention (per BBC headline)."],"numeric_claims":[],"primary_claim":"The newlywed wife of a US soldier was freed by ICE after being detained at a military base and held in federal immigration detention.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"ICE detained the newlywed wife of a US soldier at a military base, but she was later released from federal immigration detention, per BBC reporting. The event highlights an immigration enforcement action involving a military family and suggests near-term resolution rather than escalation.","topics":["immigration enforcement","ICE detention","military families","federal immigration detention","release from custody"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Newlywed wife of US soldier freed by ICE after detention at military base BBC US soldier\u2019s wife released after arrest by ICE agents at military base The Guardian Wife of American soldier is released from federal immigration detention Anchorage Daily News ICE Agents Detain Newlywed Spouse of Soldier Training to Deploy The New York Times Opinion | The ICE detention of Annie Ramos marks another low The Washington Post","title":"Newlywed wife of US soldier freed by ICE after detention at military base - BBC","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_b6424319fee1 in signals