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/CBMilwFBVV95cUxOeEpxY0hEQ2lfaWNMZHc5YlVnNVBmcWgyVmlCampKU3N6WEdUTGxWN2dtc1ZvTVhrcHIzVG9JdEVZc2xUYWtZZmpnV1lHNVl0c3pJYkRPdnk1NWRNMW0yVjBYNzhOeGZNd3gzVHY2WkVzUmNrb2dkTlBRaTlxSEkzQUZ6VEV1akhvQWhhN0l5bVBvREk0d3FR?oc=5","as_of":"2026-04-08T21:48:34.483991+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/CBMilwFBVV95cUxOeEpxY0hEQ2lfaWNMZHc5YlVnNVBmcWgyVmlCampKU3N6WEdUTGxWN2dtc1ZvTVhrcHIzVG9JdEVZc2xUYWtZZmpnV1lHNVl0c3pJYkRPdnk1NWRNMW0yVjBYNzhOeGZNd3gzVHY2WkVzUmNrb2dkTlBRaTlxSEkzQUZ6VEV1akhvQWhhN0l5bVBvREk0d3FR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c7920fdd5d7827cc","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:14:35.545372+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxOeEpxY0hEQ2lfaWNMZHc5YlVnNVBmcWgyVmlCampKU3N6WEdUTGxWN2dtc1ZvTVhrcHIzVG9JdEVZc2xUYWtZZmpnV1lHNVl0c3pJYkRPdnk1NWRNMW0yVjBYNzhOeGZNd3gzVHY2WkVzUmNrb2dkTlBRaTlxSEkzQUZ6VEV1akhvQWhhN0l5bVBvREk0d3FR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"latimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxOeEpxY0hEQ2lfaWNMZHc5YlVnNVBmcWgyVmlCampKU3N6WEdUTGxWN2dtc1ZvTVhrcHIzVG9JdEVZc2xUYWtZZmpnV1lHNVl0c3pJYkRPdnk1NWRNMW0yVjBYNzhOeGZNd3gzVHY2WkVzUmNrb2dkTlBRaTlxSEkzQUZ6VEV1akhvQWhhN0l5bVBvREk0d3FR?oc=5","source_event_id":"evt_85d81789db42","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"02a61c123f4e4406","published_at":"2026-04-08T20:07:00+00:00","publisher_domain":"latimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"n/a","name":"\u201cKetamine queen\u201d","relevance":"high","symbol":"","type":"person"},{"asset_class":"n/a","name":"Matthew Perry","relevance":"high","symbol":"","type":"person"},{"asset_class":"n/a","name":"Los Angeles Times","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The exact sentence length (e.g., number of years) is not stated in the provided LA Times headline text.","The defendant\u2019s legal name, jurisdiction, and sentencing date are not provided in the supplied content.","Causation details (e.g., how the drug was linked to the death) are not included beyond the headline framing.","Whether this is the final sentence or part of an appeal/other procedural posture is not specified."],"key_facts":["A lengthy prison sentence was imposed on the \u201cketamine queen.\u201d","The sentence is tied to selling ketamine/drugs that killed Matthew Perry."],"numeric_claims":[{"label":"prison sentence length","value":"lengthy (exact term not present in provided LA Times headline text)"}],"primary_claim":"The \u201cketamine queen\u201d was sentenced to a lengthy prison term for selling drugs connected to Matthew Perry\u2019s death.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"The Los Angeles Times reports that a person nicknamed the \u201cketamine queen\u201d received a lengthy prison sentence for selling ketamine that was linked to the overdose death of actor Matthew Perry.","topics":["criminal sentencing","drug trafficking","ketamine","overdose death","accountability"]},"source":"Los Angeles Times","source_domain":"latimes.com","source_url":"https://www.latimes.com","summary":"\u2018Ketamine queen\u2019 gets lengthy prison sentence for selling drug that killed Matthew Perry Los Angeles Times \u2018Ketamine Queen\u2019 sentenced in Matthew Perry case, highlighting a new era of accountability for drug dealers CNN \u2018Ketamine Queen\u2019 Sentenced to 15 Years in Matthew Perry\u2019s Overdose Death The New York Times \u2018Ketamine Queen\u2019 sentenced to 15-year prison term for role in Matthew Perry\u2019s death The Guardian 'Ketamine Queen' Learns Fate for Providing Drugs that Killed Matthew Perry People.com","title":"\u2018Ketamine queen\u2019 gets lengthy prison sentence for selling drug that killed Matthew Perry - Los Angeles 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_92d7710804a1 in signals