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/CBMiiwFBVV95cUxQMVBFVUhaUjNtbGZzY0swWTJDa1g1ckZnUTZxVGI3Y3ZGN3ZtbXVvbkQyNTVHOVJCTXBoNEd6cVBsSlBiaUpNZHNwVWtNV3VZV1BYUURUVFFlWUtNVGdSVERGQVlwUjd6MmM4clZSNWxpRVZQVDEtRUphS3hsS05OT0FIams5ZGEzMUdJ?oc=5","as_of":"2026-04-10T15:03:23.423858+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/CBMiiwFBVV95cUxQMVBFVUhaUjNtbGZzY0swWTJDa1g1ckZnUTZxVGI3Y3ZGN3ZtbXVvbkQyNTVHOVJCTXBoNEd6cVBsSlBiaUpNZHNwVWtNV3VZV1BYUURUVFFlWUtNVGdSVERGQVlwUjd6MmM4clZSNWxpRVZQVDEtRUphS3hsS05OT0FIams5ZGEzMUdJ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_239c62568e5e2fab","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-10T15:05:31.886137+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxQMVBFVUhaUjNtbGZzY0swWTJDa1g1ckZnUTZxVGI3Y3ZGN3ZtbXVvbkQyNTVHOVJCTXBoNEd6cVBsSlBiaUpNZHNwVWtNV3VZV1BYUURUVFFlWUtNVGdSVERGQVlwUjd6MmM4clZSNWxpRVZQVDEtRUphS3hsS05OT0FIams5ZGEzMUdJ?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/CBMiiwFBVV95cUxQMVBFVUhaUjNtbGZzY0swWTJDa1g1ckZnUTZxVGI3Y3ZGN3ZtbXVvbkQyNTVHOVJCTXBoNEd6cVBsSlBiaUpNZHNwVWtNV3VZV1BYUURUVFFlWUtNVGdSVERGQVlwUjd6MmM4clZSNWxpRVZQVDEtRUphS3hsS05OT0FIams5ZGEzMUdJ?oc=5","source_event_id":"evt_6cde4a802b64","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"de838042f4f947f1","published_at":"2026-04-10T12:06:15+00:00","publisher_domain":"cnn.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"CNN","relevance":"primary source for the headline delta","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Daughter of the missing American woman","relevance":"key claimant in the CNN headline","symbol":"","type":"person"},{"asset_class":"","name":"American woman missing in the Bahamas","relevance":"missing subject of the story","symbol":"","type":"person"},{"asset_class":"","name":"Couple (husband and missing wife)","relevance":"relationship focus of the headline","symbol":"","type":"group"},{"asset_class":"","name":"Brian Hooker","relevance":"named in the signal\u2019s referenced related coverage","symbol":"","type":"person"},{"asset_class":"other","name":"Bahamas dinghy","relevance":"referenced as ill-equipped for conditions in related coverage","symbol":"","type":"vessel"}],"event_type":"other","information_gaps":["The provided article text is not actually the CNN article content (it appears to be page styling/HTML), so the specific details of what the daughter said are not available here.","No dates, locations within the Bahamas, or procedural status (search status, charges, court dates) are included in the provided text.","The signal includes multiple related claims from other outlets, but the exact wording and attribution for each claim are not fully verifiable from the provided content.","Unclear whether the CNN piece confirms or only contextualizes the marriage-related information (the nature of the \u2018new light\u2019 is not specified in the provided text)."],"key_facts":["CNN headline states that the daughter of an American woman missing in the Bahamas has shed new light on the couple\u2019s marriage.","The signal\u2019s source summary references other outlets reporting: the couple\u2019s Bahamas dinghy was ill-equipped for conditions on the night of the wife\u2019s disappearance (Fox News).","The signal\u2019s source summary references other outlets reporting: the husband fell overboard the night of his arrest, according to a lawyer (NBC News).","The signal\u2019s source summary references other outlets reporting: messages from Brian Hooker to a friend included that the wind blew him away (CBS News).","The signal\u2019s source summary references other outlets reporting: the husband told a friend the wind \u2018blew\u2019 his dinghy away from his missing wife after she \u2018fell overboard\u2019 (Yahoo)."],"numeric_claims":[],"primary_claim":"The missing woman\u2019s daughter says new information sheds light on the couple\u2019s marriage in the case of an American woman missing in the Bahamas (CNN).","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"CNN reports that the daughter of an American woman missing in the Bahamas says new information sheds light on the couple\u2019s marriage. The broader coverage referenced in the signal also includes claims about the husband\u2019s arrest and the couple\u2019s dinghy being ill-equipped for conditions.","topics":["missing person","marriage/relationship allegations","Bahamas","arrest/overboard incident","maritime conditions"]},"source":"CNN","source_domain":"cnn.com","source_url":"https://www.cnn.com","summary":"Daughter of American woman missing in the Bahamas sheds new light on couple\u2019s marriage CNN American couple's Bahamas dinghy was ill-equipped for conditions night of wife's disappearance: friend Fox News Husband of woman missing in Bahamas also fell overboard the night of his arrest, lawyer says NBC News See the messages Brian Hooker sent his friend after wife's disappearance in the Bahamas: \"The wind blew me away\" CBS News Arrested Husband Tells Friend Wind \u2018Blew\u2019 His Dinghy Away from His Missing Wife After She 'Fell Overboard' in the Bahamas Yahoo","title":"Daughter of American woman missing in the Bahamas sheds new light on couple\u2019s marriage - 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

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