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/CBMilAFBVV95cUxOaU9mU25zVWZGeEQyQlA1WEtVOExHTzYtMTRNU0dXT3lscmszUHB4RnRrT01OQWFPRVI4RVBIdVo4X2FRdy1RdHFyR0JZRlBGTDVnYVRkMUR4Q0tiYzlXZVNkcElpQWhVY0lPeFU1Q2pKd1p0OXBaWmZjQWxMQVZ5LWNaRHJja3JvNC1QUXktYWxnR3lr?oc=5","as_of":"2026-04-10T04:47:24.800918+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/CBMilAFBVV95cUxOaU9mU25zVWZGeEQyQlA1WEtVOExHTzYtMTRNU0dXT3lscmszUHB4RnRrT01OQWFPRVI4RVBIdVo4X2FRdy1RdHFyR0JZRlBGTDVnYVRkMUR4Q0tiYzlXZVNkcElpQWhVY0lPeFU1Q2pKd1p0OXBaWmZjQWxMQVZ5LWNaRHJja3JvNC1QUXktYWxnR3lr?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_90dd0365d23a2e64","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-10T04:48:11.505917+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxOaU9mU25zVWZGeEQyQlA1WEtVOExHTzYtMTRNU0dXT3lscmszUHB4RnRrT01OQWFPRVI4RVBIdVo4X2FRdy1RdHFyR0JZRlBGTDVnYVRkMUR4Q0tiYzlXZVNkcElpQWhVY0lPeFU1Q2pKd1p0OXBaWmZjQWxMQVZ5LWNaRHJja3JvNC1QUXktYWxnR3lr?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"thecut.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxOaU9mU25zVWZGeEQyQlA1WEtVOExHTzYtMTRNU0dXT3lscmszUHB4RnRrT01OQWFPRVI4RVBIdVo4X2FRdy1RdHFyR0JZRlBGTDVnYVRkMUR4Q0tiYzlXZVNkcElpQWhVY0lPeFU1Q2pKd1p0OXBaWmZjQWxMQVZ5LWNaRHJja3JvNC1QUXktYWxnR3lr?oc=5","source_event_id":"evt_115b82b3a3b6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"10b79127154dde14","published_at":"2026-04-09T18:32:39+00:00","publisher_domain":"thecut.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Lynette Hooker","relevance":"primary_missing_person","symbol":"","type":"person"},{"asset_class":"","name":"Brian Hooker","relevance":"primary_suspect_or_husband","symbol":"","type":"person"},{"asset_class":"","name":"The Cut","relevance":"source","symbol":"","type":"publisher"},{"asset_class":"","name":"CNN","relevance":"supporting_source_mentioned","symbol":"","type":"publisher"},{"asset_class":"","name":"The New York Post","relevance":"supporting_source_mentioned","symbol":"","type":"publisher"},{"asset_class":"","name":"The New York Times","relevance":"supporting_source_mentioned","symbol":"","type":"publisher"},{"asset_class":"","name":"CBS News","relevance":"supporting_source_mentioned","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains no substantive narrative content beyond page styling; extracted facts rely on the provided Source Summary/snippet rather than the full article body.","No specific date/time of the disappearance, arrest, or overboard incident is included in the provided signal.","The signal does not specify the legal charges or the exact evidence supporting the arrest.","Unclear whether \u201cThe wind blew me away\u201d refers to the overboard incident or another event; the snippet links it to messages after the disappearance but does not fully contextualize it."],"key_facts":["Lynette Hooker disappeared in the Bahamas (as described by the signal headline/article topic).","Her husband, Brian Hooker, was arrested in connection with her disappearance (per the provided source summary).","The husband\u2019s account is under scrutiny following his arrest (per the provided source summary).","Brian Hooker fell overboard while in police custody (per the provided source summary).","Messages Brian Hooker sent to a friend after his wife\u2019s disappearance included the quote: \u201cThe wind blew me away\u201d (per the provided source summary)."],"numeric_claims":[],"primary_claim":"Lynette Hooker\u2019s disappearance in the Bahamas is being investigated amid scrutiny of her husband\u2019s account after his arrest, including an incident where he fell overboard while in police custody.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"The Cut reports on what is known about the disappearance of Lynette Hooker in the Bahamas, highlighting that her husband was arrested and that his account is under scrutiny. The coverage also notes that he fell overboard while in police custody and that messages he sent to a friend included \u201cThe wind blew me away.\u201d","topics":["missing person","criminal investigation","arrest","police custody incident","Bahamas","media coverage"]},"source":"The Cut","source_domain":"thecut.com","source_url":"https://www.thecut.com","summary":"What We Know About the Disappearance of Lynette Hooker The Cut Husband\u2019s arrest in disappearance of American woman in the Bahamas puts his account under scrutiny CNN Husband of US woman Lynette Hooker who went missing from Bahamas boat falls overboard himself while in police custody New York Post Michigan Man Is Arrested in Disappearance of Wife in Bahamas The New York Times See the messages Brian Hooker sent his friend after wife's disappearance in the Bahamas: \"The wind blew me away\" CBS News","title":"What We Know About the Disappearance of Lynette Hooker - The Cut","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_9cc141634702 in signals