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/CBMioAFBVV95cUxOVDFlaFQ2dDF2UUo4ZFpDems5ZEF6VlF6dVZUSjdsWldrRU1qMDUtdWNLRk5lOVJXbFlkeWRhWU1ZVnBzd2diWWgwZWdFQXRMbHVwZk1tVHVlQjVxel9hdUQ2WmVFb1U5MmlIQjdLWWlLSFpWRmVHZEY1bW5sa25heGgwdWFVSkhFazhnWWpPY2VmSjRnYlhaMGhJOUtVeE9Z?oc=5","as_of":"2026-04-08T10:39:13.861007+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxOVDFlaFQ2dDF2UUo4ZFpDems5ZEF6VlF6dVZUSjdsWldrRU1qMDUtdWNLRk5lOVJXbFlkeWRhWU1ZVnBzd2diWWgwZWdFQXRMbHVwZk1tVHVlQjVxel9hdUQ2WmVFb1U5MmlIQjdLWWlLSFpWRmVHZEY1bW5sa25heGgwdWFVSkhFazhnWWpPY2VmSjRnYlhaMGhJOUtVeE9Z?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cbac0f472652ce6b","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T10:39:58.115871+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxOVDFlaFQ2dDF2UUo4ZFpDems5ZEF6VlF6dVZUSjdsWldrRU1qMDUtdWNLRk5lOVJXbFlkeWRhWU1ZVnBzd2diWWgwZWdFQXRMbHVwZk1tVHVlQjVxel9hdUQ2WmVFb1U5MmlIQjdLWWlLSFpWRmVHZEY1bW5sa25heGgwdWFVSkhFazhnWWpPY2VmSjRnYlhaMGhJOUtVeE9Z?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxOVDFlaFQ2dDF2UUo4ZFpDems5ZEF6VlF6dVZUSjdsWldrRU1qMDUtdWNLRk5lOVJXbFlkeWRhWU1ZVnBzd2diWWgwZWdFQXRMbHVwZk1tVHVlQjVxel9hdUQ2WmVFb1U5MmlIQjdLWWlLSFpWRmVHZEY1bW5sa25heGgwdWFVSkhFazhnWWpPY2VmSjRnYlhaMGhJOUtVeE9Z?oc=5","source_event_id":"evt_2376b48f8345","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"933f1f15979b0550","published_at":"2026-04-08T04:04:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":["Wednesday (per provided source summary; exact date not specified in extracted text)"],"entities":[{"asset_class":"other","name":"Rex Heuermann","relevance":"primary","symbol":"","type":"person"},{"asset_class":"other","name":"Gilgo Beach killings","relevance":"primary","symbol":"","type":"event"},{"asset_class":"other","name":"Gilgo Beach","relevance":"secondary","symbol":"","type":"location"}],"event_type":"conflict","information_gaps":["The cleaned article text provided appears to be non-content HTML/CSS, so specific details (charges, sentencing terms, exact date/time) are not verifiable from the supplied body.","The \u201ceighth victim\u201d detail is only present in the user-provided source summary and is not confirmed in the AP headline text itself.","No information is provided here about sentencing timing, plea terms, or whether the plea is already entered vs. only expected."],"key_facts":["Rex Heuermann is expected to plead guilty in connection with the Gilgo Beach killings.","The expected guilty plea is described as ending a long search for a serial killer.","Multiple outlets referenced in the provided source summary indicate the plea is expected to occur in court on a near-term date (e.g., \u201cWednesday\u201d)."],"numeric_claims":[{"label":"victims referenced","value":"eighth victim (per provided source summary; not confirmed in extracted AP text)"}],"primary_claim":"Rex Heuermann is set/expected to plead guilty in the Gilgo Beach killings, ending the long search for a serial killer.","relevance_score":0.86,"sentiment":"neutral","source_quality":"high","summary":"Rex Heuermann, accused in the Gilgo Beach killings, is expected to plead guilty, which would end the long-running search for a serial killer. The plea is described as imminent, with court proceedings expected on a near-term date.","topics":["criminal justice","plea agreement","serial killings","court proceedings","Gilgo Beach"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Rex Heuermann set to plead guilty in the Gilgo Beach killings, ending long search for a serial killer AP News Gilgo Beach serial killings suspect expected to plead guilty to eighth victim BBC Gilgo Beach serial killings suspect heads to court for expected guilty plea NBC News Defendant in Gilgo Beach Murders May Plead Guilty on Wednesday The New York Times Exclusive video shows moment officer hit by car in Williamsburg; police release images of person wanted News12 | Brooklyn","title":"Rex Heuermann set to plead guilty in the Gilgo Beach killings, ending long search for a serial killer - AP News","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_18290e249efd in signals