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-09T07:33:13.626552+00:00","dedupe_key":"signal_enriched:news_delta:f10f2e1d02347fa5","evidence_event_ids":["evt_2a3e52335bad"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE9obEpWellUYzFZWjN4TDI0eWh5Nm5VVERfSVk1Y1dLZG53bnA1NmxDV0VGX2U4c0Z1a1pZLTloVXJDYnBSMEMwa0d4MzlDdVBUbElMUVdQX1cyQQ?oc=5","as_of":"2026-04-09T07:33:13.626552+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/CBMiWkFVX3lxTE9obEpWellUYzFZWjN4TDI0eWh5Nm5VVERfSVk1Y1dLZG53bnA1NmxDV0VGX2U4c0Z1a1pZLTloVXJDYnBSMEMwa0d4MzlDdVBUbElMUVdQX1cyQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ff41c7f8156cbe81","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-09T22:51:25.629370+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE9obEpWellUYzFZWjN4TDI0eWh5Nm5VVERfSVk1Y1dLZG53bnA1NmxDV0VGX2U4c0Z1a1pZLTloVXJDYnBSMEMwa0d4MzlDdVBUbElMUVdQX1cyQQ?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/CBMiWkFVX3lxTE9obEpWellUYzFZWjN4TDI0eWh5Nm5VVERfSVk1Y1dLZG53bnA1NmxDV0VGX2U4c0Z1a1pZLTloVXJDYnBSMEMwa0d4MzlDdVBUbElMUVdQX1cyQQ?oc=5","source_event_id":"evt_2a3e52335bad","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ccd61ff0bccea39f","published_at":"2026-04-09T02:07:58+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"US man (name not provided in provided text)","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Lynette Hooker","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Michigan woman (unnamed in provided text)","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"Bahamas","relevance":"high","symbol":"","type":"location"},{"asset_class":"other","name":"U.S. Coast Guard","relevance":"high","symbol":"","type":"organization"}],"event_type":"conflict","information_gaps":["The man\u2019s name, age, and specific charges are not included in the provided text.","The exact date/time of the disappearance and arrest are not provided.","The woman\u2019s full identity is inconsistently referenced (Michigan woman vs. Lynette Hooker); the provided text does not confirm they are the same person.","Details of the evidence or alleged circumstances leading to the arrest are not included.","The current status/outcome of the recovery mission (e.g., found/not found) is not provided in the extracted content."],"key_facts":["BBC headline reports a US man was arrested in connection with a Michigan woman\u2019s disappearance in the Bahamas.","The disappearance involves a reported overboard incident in the Bahamas (woman reportedly went overboard).","A criminal investigation was opened by authorities (U.S. Coast Guard referenced in the provided source summary).","A recovery mission/recovery effort is underway or was described in the provided source summary."],"numeric_claims":[],"primary_claim":"A US man was arrested in connection with the case of a Michigan woman\u2019s disappearance in the Bahamas after she reportedly went overboard.","relevance_score":0.72,"sentiment":"neutral","source_quality":"high","summary":"A US man has been arrested in connection with the disappearance of a Michigan woman in the Bahamas, where she reportedly went overboard. Authorities opened a criminal investigation and are conducting a recovery effort.","topics":["arrest","missing person","Bahamas","criminal investigation","recovery mission","overboard incident"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"US man arrested in case of Michigan woman's disappearance in Bahamas BBC Criminal investigation opened on woman missing, going overboard in Bahamas: Sources Yahoo What we know about the recovery mission for American woman who reportedly fell overboard in the Bahamas WVTM American woman missing at sea after going overboard on dinghy in the Bahamas: Police ABC News U.S. Coast Guard Launches Criminal Investigation Into Disappearance of Lynette Hooker in the Bahamas People.com","title":"US man arrested in case of Michigan woman's disappearance in Bahamas - 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

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 9304 in events