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/CBMiigFBVV95cUxPV0hRVEZIZXpiaWl2ZHpWQ3JnbXJTa0g3WlJ2MmNUMnhCTFFzSmYyUm5LZ25UTGxNVEprOGNXdk5oSUZqamlJY0NENGF4U1daRWJ1cHEyUjRFT2ZqNldMSUpjc1dwN1ZkUFBSaF9qZzVKdFZhSGdEbG03TnA5LVIxWHhlbjFCVmxCUkE?oc=5","as_of":"2026-04-08T20:43:08.696251+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/CBMiigFBVV95cUxPV0hRVEZIZXpiaWl2ZHpWQ3JnbXJTa0g3WlJ2MmNUMnhCTFFzSmYyUm5LZ25UTGxNVEprOGNXdk5oSUZqamlJY0NENGF4U1daRWJ1cHEyUjRFT2ZqNldMSUpjc1dwN1ZkUFBSaF9qZzVKdFZhSGdEbG03TnA5LVIxWHhlbjFCVmxCUkE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4444c9afded63d9d","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:11:38.414454+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxPV0hRVEZIZXpiaWl2ZHpWQ3JnbXJTa0g3WlJ2MmNUMnhCTFFzSmYyUm5LZ25UTGxNVEprOGNXdk5oSUZqamlJY0NENGF4U1daRWJ1cHEyUjRFT2ZqNldMSUpjc1dwN1ZkUFBSaF9qZzVKdFZhSGdEbG03TnA5LVIxWHhlbjFCVmxCUkE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxPV0hRVEZIZXpiaWl2ZHpWQ3JnbXJTa0g3WlJ2MmNUMnhCTFFzSmYyUm5LZ25UTGxNVEprOGNXdk5oSUZqamlJY0NENGF4U1daRWJ1cHEyUjRFT2ZqNldMSUpjc1dwN1ZkUFBSaF9qZzVKdFZhSGdEbG03TnA5LVIxWHhlbjFCVmxCUkE?oc=5","source_event_id":"evt_384e27777733","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"caa7eb0ce43a9734","published_at":"2026-04-08T18:29:55+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"\u201cKetamine Queen\u201d","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Matthew Perry","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"The New York Times","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The provided text does not specify the court, sentencing date, jurisdiction, or the defendant\u2019s legal name.","The provided text does not include the exact charges, plea details, or whether the sentence is final or subject to appeal.","No details are provided on the timeline of the ketamine sale or the specific role attributed to the defendant beyond selling ketamine."],"key_facts":["A court sentenced the \u201cKetamine Queen\u201d to 15 years in connection with Matthew Perry\u2019s overdose death.","The case involves ketamine that was sold to Matthew Perry (as described in the provided source summary/headline context)."],"numeric_claims":[{"label":"prison_sentence_years","value":"15"}],"primary_claim":"The \u201cKetamine Queen\u201d was sentenced to 15 years in the Matthew Perry ketamine overdose death case.","relevance_score":0.72,"sentiment":"neutral","source_quality":"high","summary":"The New York Times reports that the person nicknamed the \u201cKetamine Queen,\u201d who sold ketamine to Matthew Perry, was sentenced to 15 years in connection with Perry\u2019s overdose death.","topics":["criminal sentencing","ketamine","overdose death","accountability","Matthew Perry case"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"\u2018Ketamine Queen\u2019 Sentenced to 15 Years in Matthew Perry\u2019s Overdose Death The New York Times \u2018Ketamine Queen\u2019 sentenced in Matthew Perry case, highlighting a new era of accountability for drug dealers CNN Woman who sold Matthew Perry the ketamine that killed him receives prison sentence Syracuse.com 'Ketamine Queen' sentenced to 15 years in death of 'Friends' star Matthew Perry Yahoo \u2018Ketamine queen\u2019 gets lengthy prison sentence for selling drug that killed Matthew Perry Los Angeles Times","title":"\u2018Ketamine Queen\u2019 Sentenced to 15 Years in Matthew Perry\u2019s Overdose Death - The New York Times","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_0fe0b76929c2 in signals