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-08T10:39:13.861007+00:00","dedupe_key":"signal_enriched:news_delta:10e8c5c7536da1bf","evidence_event_ids":["evt_2376b48f8345"],"signal_type":"news_headline_delta","source":"news_rss","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

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 5989 in events