SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T20:43:08.696251+00:00","dedupe_key":"signal_enriched:news_delta:eca2215bc9a3b388","evidence_event_ids":["evt_384e27777733"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 8383 in events