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-09T00:58:19.761509+00:00","dedupe_key":"signal_enriched:news_delta:201f1d67521b5bdc","evidence_event_ids":["evt_ae8ab5cba950"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxNV29ranFnYXVqRjViMUYyMEFOYVptREdKeTQtbjlCaFdNQXlWeGJjUnltemxSdEF3ZGUzTkxzbENDNmdzZVBjWnpmekJhQWtibzQ2eGVQXzl5cTV2ZXlPdDNOMmlvejlJRUdMYnc1ZWlxVFJKNWVFLUFfVXA1UHo1LS1XYWhYWGQ1eEFJ?oc=5","as_of":"2026-04-09T00:58:19.761509+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/CBMiiwFBVV95cUxNV29ranFnYXVqRjViMUYyMEFOYVptREdKeTQtbjlCaFdNQXlWeGJjUnltemxSdEF3ZGUzTkxzbENDNmdzZVBjWnpmekJhQWtibzQ2eGVQXzl5cTV2ZXlPdDNOMmlvejlJRUdMYnc1ZWlxVFJKNWVFLUFfVXA1UHo1LS1XYWhYWGQ1eEFJ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2df9ea82bcb3ed3d","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:21:13.452827+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxNV29ranFnYXVqRjViMUYyMEFOYVptREdKeTQtbjlCaFdNQXlWeGJjUnltemxSdEF3ZGUzTkxzbENDNmdzZVBjWnpmekJhQWtibzQ2eGVQXzl5cTV2ZXlPdDNOMmlvejlJRUdMYnc1ZWlxVFJKNWVFLUFfVXA1UHo1LS1XYWhYWGQ1eEFJ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiwFBVV95cUxNV29ranFnYXVqRjViMUYyMEFOYVptREdKeTQtbjlCaFdNQXlWeGJjUnltemxSdEF3ZGUzTkxzbENDNmdzZVBjWnpmekJhQWtibzQ2eGVQXzl5cTV2ZXlPdDNOMmlvejlJRUdMYnc1ZWlxVFJKNWVFLUFfVXA1UHo1LS1XYWhYWGQ1eEFJ?oc=5","source_event_id":"evt_ae8ab5cba950","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f84731c454742f34","published_at":"2026-04-08T22:57:02+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Rex Heuermann","relevance":"primary","symbol":"","type":"person"},{"asset_class":"other","name":"Gilgo Beach suspect","relevance":"context","symbol":"","type":"group"},{"asset_class":"other","name":"The Washington Post","relevance":"source","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The provided text does not include the specific court, date of the plea, or sentencing terms.","The excerpt does not confirm whether the plea covers all charges or only certain counts.","No details are provided here about any cooperation terms (e.g., whether the plea could lead to other case resolutions).","The excerpt does not specify the jurisdiction (e.g., county/state) or the exact legal charges admitted to."],"key_facts":["The Washington Post headline states that the Gilgo Beach suspect pleads guilty.","The headline states the suspect admits killing eight women.","The headline characterizes the killings as occurring over roughly three decades."],"numeric_claims":[{"label":"number_of_victims_admitted","value":"8"},{"label":"time_span_years_approx","value":"3 decades"}],"primary_claim":"Rex Heuermann pleaded guilty and admitted killing eight women in the Gilgo Beach case over a period of about three decades.","relevance_score":0.86,"sentiment":"negative","source_quality":"high","summary":"Rex Heuermann, the Gilgo Beach serial-killing suspect, has pleaded guilty and admitted killing eight women over roughly three decades, according to The Washington Post. The plea is a major procedural development that may affect related investigations and case resolution timelines.","topics":["criminal justice","plea agreement","serial killings","Gilgo Beach case","admissions of guilt"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Gilgo Beach suspect pleads guilty, admits killing 8 women over 3 decades The Washington Post Rex Heuermann: Accused Gilgo Beach serial killer admits to strangling 8 women CNN Gilgo Beach Killer\u2019s \u2018Unusual\u2019 Deal Could Help Solve Other Murders The New York Times Rex Heuermann pleads guilty to murder charges and admits he killed 8 women in the Gilgo Beach case AP News Gilgo Beach serial killer suspect Rex Heuermann pleads guilty The Guardian","title":"Gilgo Beach suspect pleads guilty, admits killing 8 women over 3 decades - The Washington Post","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 8641 in events