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/CBMiswFBVV95cUxPSFZuU2ZXMnFLN1FPNUN6OXVEQmFPdUpFaWpHcHBydzFhTDlsWUFrQ3RlS2o5eW5YT1BpT1JQVW9BUi0zZFVtYVFTSjN2Z1Z2ZnBWLWU0c0VDYmdhczc4bDhLZjktTmlJQ0t6TkdLdWJRbUtnNnVRZkVTb3ZoanRjS3ZHbWkxMGdQTUtranRvSVZ4MlhQMGRKQ2FNQ0x0Uk5pakNwY2tabFRDQ3c4LUhSd0ttTQ?oc=5","as_of":"2026-04-08T23:28:56.332278+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/CBMiswFBVV95cUxPSFZuU2ZXMnFLN1FPNUN6OXVEQmFPdUpFaWpHcHBydzFhTDlsWUFrQ3RlS2o5eW5YT1BpT1JQVW9BUi0zZFVtYVFTSjN2Z1Z2ZnBWLWU0c0VDYmdhczc4bDhLZjktTmlJQ0t6TkdLdWJRbUtnNnVRZkVTb3ZoanRjS3ZHbWkxMGdQTUtranRvSVZ4MlhQMGRKQ2FNQ0x0Uk5pakNwY2tabFRDQ3c4LUhSd0ttTQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7c56f886782ddf18","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:18:11.518656+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxPSFZuU2ZXMnFLN1FPNUN6OXVEQmFPdUpFaWpHcHBydzFhTDlsWUFrQ3RlS2o5eW5YT1BpT1JQVW9BUi0zZFVtYVFTSjN2Z1Z2ZnBWLWU0c0VDYmdhczc4bDhLZjktTmlJQ0t6TkdLdWJRbUtnNnVRZkVTb3ZoanRjS3ZHbWkxMGdQTUtranRvSVZ4MlhQMGRKQ2FNQ0x0Uk5pakNwY2tabFRDQ3c4LUhSd0ttTQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxPSFZuU2ZXMnFLN1FPNUN6OXVEQmFPdUpFaWpHcHBydzFhTDlsWUFrQ3RlS2o5eW5YT1BpT1JQVW9BUi0zZFVtYVFTSjN2Z1Z2ZnBWLWU0c0VDYmdhczc4bDhLZjktTmlJQ0t6TkdLdWJRbUtnNnVRZkVTb3ZoanRjS3ZHbWkxMGdQTUtranRvSVZ4MlhQMGRKQ2FNQ0x0Uk5pakNwY2tabFRDQ3c4LUhSd0ttTQ?oc=5","source_event_id":"evt_09d9c8338904","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7e7b9871528aa140","published_at":"2026-04-08T21:05:05+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Jasveen Sangha","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Matthew Perry","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Reuters","relevance":"medium","symbol":"","type":"organization"}],"event_type":"conflict","information_gaps":["The article text provided is not actually present (only page styling HTML), so details such as sentencing date, jurisdiction, and specific conduct are not verifiable from the supplied content.","No information is provided here about co-defendants, plea terms, or the exact causal findings beyond the headline/summary framing.","Near-term market or policy impacts are not specified in the provided signal; any directional impact beyond the legal case cannot be grounded."],"key_facts":["Jasveen Sangha is described as the \u201cKetamine Queen.\u201d","She was sentenced to 15 years in prison.","The sentence is tied to her role supplying ketamine/drugs linked to Matthew Perry\u2019s death.","The report is attributed to Reuters."],"numeric_claims":[{"label":"prison sentence (years)","value":"15"}],"primary_claim":"Jasveen Sangha was sentenced to 15 years in prison for her role supplying drugs (ketamine) connected to Matthew Perry\u2019s death.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"Reuters reports that Jasveen Sangha, described as the \u201cKetamine Queen,\u201d was sentenced to 15 years in prison for her role supplying ketamine linked to the death of actor Matthew Perry. The sentencing is presented as a major accountability development in the Perry drug-death case.","topics":["criminal sentencing","ketamine","drug trafficking","Matthew Perry death","accountability for drug dealers"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"'Ketamine Queen' sentenced to 15 years in death of 'Friends' star Matthew Perry Reuters \u2018Ketamine Queen\u2019 sentenced in Matthew Perry case, highlighting a new era of accountability for drug dealers CNN Woman given 15 years for role supplying drugs linked to Matthew Perry death Al Jazeera 'Ketamine Queen' sentenced to 15 years in Matthew Perry overdose death Yahoo 'Ketamine Queen' Jasveen Sangha sentenced to 15 years in prison for role in Matthew Perry's death Fox News","title":"'Ketamine Queen' sentenced to 15 years in death of 'Friends' star Matthew Perry - Reuters","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_882591cbb96f in signals