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/CBMijwFBVV95cUxNaGZJRVZSTDlrbDR2cWtLWDNRTHNBcGoyOHRFa1U1amxtNl8taGtzdDJmY2FGOEZURlFoRkg2dUZkMll5bnlPbjlqRmZWbHJ6cFVuVWdNUUpjQ3poMWVlYl92WEdiUVdkby1wWGw5R3lRRUQ2MS16VU9Cck9vaGxpMURCaDN1YlBHOTFrQWZyUdIBlAFBVV95cUxQUzZWRDYxWG9NeUhxNE9xckVPTGtGVlRLUUx1bEVVanprZ1lWcUNpYllUcDhqa0VLbzd2dmM4dllwc3NucWxfSFhNRlJUQlc3c18tZFl2YTVIdzFCNTdkVy1GbEdCSUJqcldsWDdFV3otUTlRU2gxUXhZN3hNdTBxeUNEWTNhMWs3ckJhWHRuY1Vlb2Mt?oc=5","as_of":"2026-04-09T22:47:28.559423+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/CBMijwFBVV95cUxNaGZJRVZSTDlrbDR2cWtLWDNRTHNBcGoyOHRFa1U1amxtNl8taGtzdDJmY2FGOEZURlFoRkg2dUZkMll5bnlPbjlqRmZWbHJ6cFVuVWdNUUpjQ3poMWVlYl92WEdiUVdkby1wWGw5R3lRRUQ2MS16VU9Cck9vaGxpMURCaDN1YlBHOTFrQWZyUdIBlAFBVV95cUxQUzZWRDYxWG9NeUhxNE9xckVPTGtGVlRLUUx1bEVVanprZ1lWcUNpYllUcDhqa0VLbzd2dmM4dllwc3NucWxfSFhNRlJUQlc3c18tZFl2YTVIdzFCNTdkVy1GbEdCSUJqcldsWDdFV3otUTlRU2gxUXhZN3hNdTBxeUNEWTNhMWs3ckJhWHRuY1Vlb2Mt?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ea99c3d0bbccb3bb","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-10T00:46:43.559415+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxNaGZJRVZSTDlrbDR2cWtLWDNRTHNBcGoyOHRFa1U1amxtNl8taGtzdDJmY2FGOEZURlFoRkg2dUZkMll5bnlPbjlqRmZWbHJ6cFVuVWdNUUpjQ3poMWVlYl92WEdiUVdkby1wWGw5R3lRRUQ2MS16VU9Cck9vaGxpMURCaDN1YlBHOTFrQWZyUdIBlAFBVV95cUxQUzZWRDYxWG9NeUhxNE9xckVPTGtGVlRLUUx1bEVVanprZ1lWcUNpYllUcDhqa0VLbzd2dmM4dllwc3NucWxfSFhNRlJUQlc3c18tZFl2YTVIdzFCNTdkVy1GbEdCSUJqcldsWDdFV3otUTlRU2gxUXhZN3hNdTBxeUNEWTNhMWs3ckJhWHRuY1Vlb2Mt?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbsnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijwFBVV95cUxNaGZJRVZSTDlrbDR2cWtLWDNRTHNBcGoyOHRFa1U1amxtNl8taGtzdDJmY2FGOEZURlFoRkg2dUZkMll5bnlPbjlqRmZWbHJ6cFVuVWdNUUpjQ3poMWVlYl92WEdiUVdkby1wWGw5R3lRRUQ2MS16VU9Cck9vaGxpMURCaDN1YlBHOTFrQWZyUdIBlAFBVV95cUxQUzZWRDYxWG9NeUhxNE9xckVPTGtGVlRLUUx1bEVVanprZ1lWcUNpYllUcDhqa0VLbzd2dmM4dllwc3NucWxfSFhNRlJUQlc3c18tZFl2YTVIdzFCNTdkVy1GbEdCSUJqcldsWDdFV3otUTlRU2gxUXhZN3hNdTBxeUNEWTNhMWs3ckJhWHRuY1Vlb2Mt?oc=5","source_event_id":"evt_79b6dca91e91","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9624ea4cbf3ed9db","published_at":"2026-04-09T21:31:24+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Brian Hooker","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"CBS News","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"CNN","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"The New York Times","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Fox News","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"ClickOnDetroit | WDIV Local 4","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Lenawee County mother (Hooker\u2019s wife)","relevance":"high","symbol":"","type":"person"}],"event_type":"conflict","information_gaps":["The cleaned article text provided appears to be unrelated page markup (CSS) and does not contain the substantive narrative details; extraction is therefore based on the headline and the provided source summary only.","The wife\u2019s name, the exact date/time of disappearance, and the date/time of the messages are not included in the provided text.","The specific legal charges and arrest details are not stated in the provided content.","The context of the quote \u201cThe wind blew me away\u201d (what it was responding to) is not provided."],"key_facts":["CBS News headline states Brian Hooker sent messages to a friend after his wife\u2019s disappearance in the Bahamas.","The CBS News headline includes the quoted phrase: \u201cThe wind blew me away.\u201d","The provided source summary states Hooker\u2019s arrest in connection with the disappearance puts his account under scrutiny.","The source summary indicates multiple outlets (CNN, New York Times, Fox News, ClickOnDetroit/WDIV) covered the arrest and/or related statements."],"numeric_claims":[],"primary_claim":"Brian Hooker sent a friend messages after his wife\u2019s disappearance in the Bahamas, including \u201cThe wind blew me away,\u201d and his arrest in the case has led to scrutiny of his account.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"CBS News reports that Brian Hooker sent messages to a friend after his wife\u2019s disappearance in the Bahamas, including the quote \u201cThe wind blew me away.\u201d Multiple outlets also report that Hooker has been arrested in connection with the disappearance, putting his account under scrutiny.","topics":["missing person","arrest","Bahamas","text messages","investigation scrutiny"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"See the messages Brian Hooker sent his friend after wife's disappearance in the Bahamas: \"The wind blew me away\" CBS News Husband\u2019s arrest in disappearance of American woman in the Bahamas puts his account under scrutiny CNN Michigan Man Is Arrested in Disappearance of Wife in Bahamas The New York Times Husband arrested in connection with disappearance of American woman in the Bahamas Fox News Daughter speaks out as Lenawee County mother goes missing in the Bahamas, father arrested ClickOnDetroit | WDIV Local 4","title":"See the messages Brian Hooker sent his friend after wife's disappearance in the Bahamas: \"The wind blew me away\" - CBS News","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_c072bb02cca9 in signals