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/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

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_9f6599fd1701 in signals