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/CBMimAFBVV95cUxNVjRlaU81S2JyM2l5anhwaU1SS0dpN1J0ZmxqSHRBbTVVaFNnZmhOTDFLQkhkQ183WnF0bGE2V1BnelV5OGFpOUdEXzA2Y0pyTG16YmQxUllYNHdzcDFKYnY5MmRHY2hNeWluT2s5ZTNkVWtEOUhFM1k0ZHdFaW9VT0dxWGlmaGRQX0pnZFFJbE9zdTBHTXBfNA?oc=5","as_of":"2026-04-10T18:45:20.675093+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/CBMimAFBVV95cUxNVjRlaU81S2JyM2l5anhwaU1SS0dpN1J0ZmxqSHRBbTVVaFNnZmhOTDFLQkhkQ183WnF0bGE2V1BnelV5OGFpOUdEXzA2Y0pyTG16YmQxUllYNHdzcDFKYnY5MmRHY2hNeWluT2s5ZTNkVWtEOUhFM1k0ZHdFaW9VT0dxWGlmaGRQX0pnZFFJbE9zdTBHTXBfNA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7c3b6b6b9d69f70e","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-10T18:47:21.146145+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxNVjRlaU81S2JyM2l5anhwaU1SS0dpN1J0ZmxqSHRBbTVVaFNnZmhOTDFLQkhkQ183WnF0bGE2V1BnelV5OGFpOUdEXzA2Y0pyTG16YmQxUllYNHdzcDFKYnY5MmRHY2hNeWluT2s5ZTNkVWtEOUhFM1k0ZHdFaW9VT0dxWGlmaGRQX0pnZFFJbE9zdTBHTXBfNA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"tmz.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxNVjRlaU81S2JyM2l5anhwaU1SS0dpN1J0ZmxqSHRBbTVVaFNnZmhOTDFLQkhkQ183WnF0bGE2V1BnelV5OGFpOUdEXzA2Y0pyTG16YmQxUllYNHdzcDFKYnY5MmRHY2hNeWluT2s5ZTNkVWtEOUhFM1k0ZHdFaW9VT0dxWGlmaGRQX0pnZFFJbE9zdTBHTXBfNA?oc=5","source_event_id":"evt_1397abc3c6a8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b637f78218be25f9","published_at":"2026-04-10T18:06:02+00:00","publisher_domain":"tmz.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"","name":"\u201cKetamine Queen\u201d","relevance":"high","symbol":"","type":"defendant"},{"asset_class":"","name":"Matthew Perry","relevance":"high","symbol":"","type":"victim"},{"asset_class":"","name":"Keith Morrison","relevance":"medium","symbol":"","type":"speaker"},{"asset_class":"","name":"TMZ","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"","name":"NBC Los Angeles","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"Al Jazeera","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"E! News","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"","name":"The New York Times","relevance":"low","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The exact sentencing date and jurisdiction are not provided in the supplied text.","The defendant\u2019s legal name and specific charges are not provided.","The source text does not specify whether TMZ\u2019s \u201cbegged for forgiveness\u201d refers to a courtroom statement, allocution, or another moment.","The provided content includes only partial/cleaned HTML and a multi-outlet summary; detailed factual context (e.g., evidence, timeline of drug sales) is not included."],"key_facts":["TMZ headline states the \u201cKetamine Queen\u201d begged for forgiveness before Matthew Perry case sentencing.","Provided source summary from multiple outlets states the \u201cKetamine Queen\u201d was sentenced to 15 years in prison.","Provided source summary states the sentence was for selling/supplying drugs (ketamine) linked to Matthew Perry\u2019s overdose death."],"numeric_claims":[{"label":"prison sentence length (years)","value":"15"}],"primary_claim":"The \u201cKetamine Queen\u201d begged for forgiveness before being sentenced in the Matthew Perry overdose case, and she received a 15-year prison sentence for supplying drugs linked to his death.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"TMZ reports that the person nicknamed the \u201cKetamine Queen\u201d begged for forgiveness before sentencing in the Matthew Perry overdose case. Multiple outlets cited in the provided source summary indicate she was sentenced to 15 years in prison for supplying ketamine linked to Perry\u2019s death.","topics":["criminal sentencing","drug supply","ketamine","Matthew Perry overdose case","court proceedings"]},"source":"TMZ","source_domain":"tmz.com","source_url":"https://www.tmz.com","summary":"'Ketamine Queen' Begged for Forgiveness Before Matthew Perry Case Sentencing TMZ \u2018Ketamine Queen\u2019 Sentenced to 15 Years in Matthew Perry\u2019s Overdose Death The New York Times What Matthew Perry\u2019s Stepdad Keith Morrison Said to the \"Ketamine Queen\u201d At Her Sentencing E! News \u2018Ketamine Queen' gets 15 years in prison for selling Matthew Perry the drugs that killed him NBC Los Angeles Woman given 15 years for role supplying drugs linked to Matthew Perry death Al Jazeera","title":"'Ketamine Queen' Begged for Forgiveness Before Matthew Perry Case Sentencing - TMZ","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_22d20117dd36 in signals