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-08T23:28:56.419110+00:00","dedupe_key":"signal_enriched:news_delta:10e8c5c7536da1bf","evidence_event_ids":["evt_ffa51e775d99"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMioAFBVV95cUxOVDFlaFQ2dDF2UUo4ZFpDems5ZEF6VlF6dVZUSjdsWldrRU1qMDUtdWNLRk5lOVJXbFlkeWRhWU1ZVnBzd2diWWgwZWdFQXRMbHVwZk1tVHVlQjVxel9hdUQ2WmVFb1U5MmlIQjdLWWlLSFpWRmVHZEY1bW5sa25heGgwdWFVSkhFazhnWWpPY2VmSjRnYlhaMGhJOUtVeE9Z?oc=5","as_of":"2026-04-08T23:28:56.419110+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/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=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T22:18:15.357614+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_ffa51e775d99","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"933f1f15979b0550","published_at":"2026-04-08T20:44:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"person","name":"Rex Heuermann","relevance":"primary","symbol":"","type":"person"},{"asset_class":"legal_case","name":"Gilgo Beach case","relevance":"primary","symbol":"","type":"case"},{"asset_class":"news_outlet","name":"AP News","relevance":"supporting","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The specific court date, jurisdiction, and sentencing details are not present in the provided text.","The exact wording/terms of the plea (e.g., whether it is to all counts or specific counts) are not included.","Whether the admission is consistent with prior charges/evidence is not stated in the provided content.","Near-term catalyst timing (e.g., sentencing date) is not provided in the supplied material."],"key_facts":["Rex Heuermann pleaded guilty to murder charges (AP News).","Heuermann admitted killing eight women in the Gilgo Beach case (AP News)."],"numeric_claims":[{"label":"number_of_victims_admitted","value":"8"}],"primary_claim":"Rex Heuermann pleaded guilty to murder charges and admitted he killed eight women in the Gilgo Beach case.","relevance_score":0.92,"sentiment":"negative","source_quality":"high","summary":"Rex Heuermann, accused in the Gilgo Beach serial killings, has pleaded guilty to murder charges and admitted killing eight women, according to AP News. The development is a major procedural and evidentiary turning point in the case.","topics":["criminal justice","plea agreement","murder charges","serial killings","Gilgo Beach","confession"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Rex Heuermann pleads guilty to murder charges and admits he killed 8 women in the Gilgo Beach case AP News Rex Heuermann: Accused Gilgo Beach serial killer admits to strangling 8 women CNN Rex Heuermann admits killing 8 women in the Gilgo Beach serial slayings NBC News A timeline of the investigation of the Gilgo Beach killings NBC New York Long Island architect pleads guilty to Gilgo Beach murders Yahoo","title":"Rex Heuermann pleads guilty to murder charges and admits he killed 8 women in the Gilgo Beach case - AP News","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

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