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/CBMipAFBVV95cUxPS3NnanNUUlFSVlg1UmdWcjBvc1dlSDFMamxFWFVLSEtGLVR6cC02Qm56SEpvdFd5d1laUkcwbVFsWjQteThWVjhONFpFZGJib3FxSHZhRDdtdU95NzMwcVJhVWFCRVB6QkZYdzBqeHg1Wjc3QVN2ZC12MTNXakFmRDNPN1AwT1B1MXF0SUdEVDN3bVlEVWYzUGVzekpkUlppbHNVbA?oc=5","as_of":"2026-04-06T23:19:11.906148+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/CBMipAFBVV95cUxPS3NnanNUUlFSVlg1UmdWcjBvc1dlSDFMamxFWFVLSEtGLVR6cC02Qm56SEpvdFd5d1laUkcwbVFsWjQteThWVjhONFpFZGJib3FxSHZhRDdtdU95NzMwcVJhVWFCRVB6QkZYdzBqeHg1Wjc3QVN2ZC12MTNXakFmRDNPN1AwT1B1MXF0SUdEVDN3bVlEVWYzUGVzekpkUlppbHNVbA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5fd09129a5616607","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-07T14:02:06.601882+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxPS3NnanNUUlFSVlg1UmdWcjBvc1dlSDFMamxFWFVLSEtGLVR6cC02Qm56SEpvdFd5d1laUkcwbVFsWjQteThWVjhONFpFZGJib3FxSHZhRDdtdU95NzMwcVJhVWFCRVB6QkZYdzBqeHg1Wjc3QVN2ZC12MTNXakFmRDNPN1AwT1B1MXF0SUdEVDN3bVlEVWYzUGVzekpkUlppbHNVbA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxPS3NnanNUUlFSVlg1UmdWcjBvc1dlSDFMamxFWFVLSEtGLVR6cC02Qm56SEpvdFd5d1laUkcwbVFsWjQteThWVjhONFpFZGJib3FxSHZhRDdtdU95NzMwcVJhVWFCRVB6QkZYdzBqeHg1Wjc3QVN2ZC12MTNXakFmRDNPN1AwT1B1MXF0SUdEVDN3bVlEVWYzUGVzekpkUlppbHNVbA?oc=5","source_event_id":"evt_f678aaf4dbde","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e4fe3e311617c43b","published_at":"2026-04-06T20:46:00+00:00","publisher_domain":"yahoo.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"N/A","name":"Savannah Guthrie","relevance":"high","symbol":"N/A","type":"person"},{"asset_class":"N/A","name":"Nancy Guthrie","relevance":"high","symbol":"N/A","type":"person"}],"event_type":"other","information_gaps":["The authenticity of the ransom note is uncertain.","Details about the alleged sighting in Mexico are not confirmed."],"key_facts":["New ransom note claims to have seen Savannah Guthrie's mother alive in Mexico.","TMZ received the ransom note and believes it to be legitimate despite FBI not pursuing it."],"numeric_claims":[],"primary_claim":"A ransom note claims Savannah Guthrie's missing mother was seen alive in Mexico.","relevance_score":0.8,"sentiment":"mixed","source_quality":"high","summary":"A new ransom note claims to have seen Savannah Guthrie's missing mother alive in Mexico, raising concerns about her whereabouts.","topics":["missing persons","ransom note","media coverage"]},"source":"Yahoo","source_domain":"yahoo.com","source_url":"https://www.yahoo.com","summary":"Nancy Guthrie Update: New Ransom Note Claims to Have Seen Savannah Guthrie\u2019s Missing Mom Alive in Mexico Yahoo Nancy Guthrie Cold Case Letter Claims She Was with Kidnappers in Mexico TMZ TMZ\u2019s Harvey Levin Believes New Nancy Guthrie Ransom Note Is Legit, Despite FBI Not Pursuing | Video Yahoo News Singapore New Nancy Guthrie ransom notes sent to TMZ claim to know her location as Savannah makes \u2018Today\u2019 show return New York Post TMZ receives new ransom note in Nancy Guthrie case NewsNation","title":"Nancy Guthrie Update: New Ransom Note Claims to Have Seen Savannah Guthrie\u2019s Missing Mom Alive in Mexico - Yahoo","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_44a3e16efc7e in signals