SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-09T13:30:32.979070+00:00","dedupe_key":"signal_enriched:news_delta:73fd63de7f8ab651","evidence_event_ids":["evt_e1dd6f89e207"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxNaGRLX1NHUHRwZm4xaV9mZDlCajBWSGpVQzdrb2RWZklmSHc3ZGNaMFRFNDdfYmdicXoxWUMwakZGVEh2d21kMVZHZnQ0NzNUMTV0TjJ6Uy1oTlZ3NG1MaExwcG1fQjVFenAwVVlDS1BDWXFWMnhmazlvd3doMF9lMA?oc=5","as_of":"2026-04-09T13:30:32.979070+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/CBMigAFBVV95cUxNaGRLX1NHUHRwZm4xaV9mZDlCajBWSGpVQzdrb2RWZklmSHc3ZGNaMFRFNDdfYmdicXoxWUMwakZGVEh2d21kMVZHZnQ0NzNUMTV0TjJ6Uy1oTlZ3NG1MaExwcG1fQjVFenAwVVlDS1BDWXFWMnhmazlvd3doMF9lMA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6b10cf097c7c8bfc","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-09T23:30:45.132375+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxNaGRLX1NHUHRwZm4xaV9mZDlCajBWSGpVQzdrb2RWZklmSHc3ZGNaMFRFNDdfYmdicXoxWUMwakZGVEh2d21kMVZHZnQ0NzNUMTV0TjJ6Uy1oTlZ3NG1MaExwcG1fQjVFenAwVVlDS1BDWXFWMnhmazlvd3doMF9lMA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnn.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxNaGRLX1NHUHRwZm4xaV9mZDlCajBWSGpVQzdrb2RWZklmSHc3ZGNaMFRFNDdfYmdicXoxWUMwakZGVEh2d21kMVZHZnQ0NzNUMTV0TjJ6Uy1oTlZ3NG1MaExwcG1fQjVFenAwVVlDS1BDWXFWMnhmazlvd3doMF9lMA?oc=5","source_event_id":"evt_e1dd6f89e207","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2d15c58f5dc009a4","published_at":"2026-04-09T09:18:05+00:00","publisher_domain":"cnn.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"news_media","name":"CNN","relevance":"source of headline","symbol":"","type":"publisher"},{"asset_class":"person","name":"Husband (unnamed in provided text)","relevance":"central subject; arrested","symbol":"","type":"person"},{"asset_class":"person","name":"American woman (unnamed in provided text)","relevance":"missing/disappearance case subject","symbol":"","type":"person"},{"asset_class":"location","name":"Lenawee County woman (implied missing American woman)","relevance":"identifies the missing woman\u2019s origin","symbol":"","type":"location_descriptor"},{"asset_class":"country","name":"Bahamas","relevance":"jurisdiction/location of disappearance and arrest","symbol":"","type":"location"}],"event_type":"conflict","information_gaps":["The husband\u2019s name, the woman\u2019s name, and the specific charges are not present in the provided text.","The article body content is not available (the provided 'Article Text' appears to be unrelated page styling), so details of the arrest circumstances and investigative findings are unknown.","No timeline (exact arrest date/time relative to disappearance) is included in the provided material.","The nature of the \u201caccount\u201d being scrutinized (what he said, what evidence conflicts) is not specified in the provided text."],"key_facts":["A husband connected to the disappearance of an American woman in the Bahamas has been arrested (per CNN headline).","CNN states that the arrest puts the husband\u2019s account under scrutiny.","The missing-person incident involves an American woman who disappeared at sea in the Bahamas (context from the provided source summary snippets)."],"numeric_claims":[],"primary_claim":"The husband of an American woman missing in the Bahamas was arrested, and his account is now under scrutiny.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"CNN reports that the husband of an American woman missing in the Bahamas has been arrested, leading to increased scrutiny of his account of the disappearance. The arrest is presented as a near-term development in an ongoing missing-person case.","topics":["missing person","arrest","Bahamas","investigation","husband account scrutiny","American citizen"]},"source":"CNN","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"Husband\u2019s arrest in disappearance of American woman in the Bahamas puts his account under scrutiny CNN Husband of Lenawee County woman who was aboard boat and vanished arrested ClickOnDetroit | WDIV Local 4 Man Is Arrested in Bahamas Days After Michigan Woman Goes Missing The New York Times American woman missing at sea after going overboard on dinghy in the Bahamas: Police ABC News Missing US mom Lynette Hooker made ominous joke about her husband days before she vanished in Bahamas New York Post","title":"Husband\u2019s arrest in disappearance of American woman in the Bahamas puts his account under scrutiny - CNN","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 10119 in events