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-08T13:34:56.895817+00:00","dedupe_key":"signal_enriched:news_delta:c08920429943f6de","evidence_event_ids":["evt_02d1a971c85c"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxNNjVRR0FOTTJVUE14eDJ4eG1xZTB3R2x4RC02V0JZX25EUTczeWRaT0FSb3ZPVk4yejRjMFJGVFMyREl2LW0xZFVsZGpqdHg2OHFIR19wV2pqV3dndENrQ1N3UWdIazk1dXV0Z3VNUEhmNlRRejc2eDQ5LXYtM0tRTDlTX0lYWnl5MVJGeFM5cTZHeHlWQTIzVk1wZkFXUENNTTYwcVZ4akxhRGVWUWI4Umo3NFA?oc=5","as_of":"2026-04-08T13:34:56.895817+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/CBMitAFBVV95cUxNNjVRR0FOTTJVUE14eDJ4eG1xZTB3R2x4RC02V0JZX25EUTczeWRaT0FSb3ZPVk4yejRjMFJGVFMyREl2LW0xZFVsZGpqdHg2OHFIR19wV2pqV3dndENrQ1N3UWdIazk1dXV0Z3VNUEhmNlRRejc2eDQ5LXYtM0tRTDlTX0lYWnl5MVJGeFM5cTZHeHlWQTIzVk1wZkFXUENNTTYwcVZ4akxhRGVWUWI4Umo3NFA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_676702a905bada8d","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-08T15:40:36.610361+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxNNjVRR0FOTTJVUE14eDJ4eG1xZTB3R2x4RC02V0JZX25EUTczeWRaT0FSb3ZPVk4yejRjMFJGVFMyREl2LW0xZFVsZGpqdHg2OHFIR19wV2pqV3dndENrQ1N3UWdIazk1dXV0Z3VNUEhmNlRRejc2eDQ5LXYtM0tRTDlTX0lYWnl5MVJGeFM5cTZHeHlWQTIzVk1wZkFXUENNTTYwcVZ4akxhRGVWUWI4Umo3NFA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbsnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxNNjVRR0FOTTJVUE14eDJ4eG1xZTB3R2x4RC02V0JZX25EUTczeWRaT0FSb3ZPVk4yejRjMFJGVFMyREl2LW0xZFVsZGpqdHg2OHFIR19wV2pqV3dndENrQ1N3UWdIazk1dXV0Z3VNUEhmNlRRejc2eDQ5LXYtM0tRTDlTX0lYWnl5MVJGeFM5cTZHeHlWQTIzVk1wZkFXUENNTTYwcVZ4akxhRGVWUWI4Umo3NFA?oc=5","source_event_id":"evt_02d1a971c85c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"eb3f2a3e7dc62737","published_at":"2026-04-08T12:56:00+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":["today"],"entities":[{"asset_class":"other","name":"Rex Heuermann","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"other","name":"Gilgo Beach serial killings","relevance":"case context","symbol":"","type":"event"},{"asset_class":"other","name":"CBS News","relevance":"source","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains no substantive content beyond page styling, so details of the plea (e.g., which charges/victims are covered) are not verifiable from the provided text.","The exact court date/time and jurisdiction are not included in the provided material.","Whether the plea is confirmed or only expected (and what happens if it does not occur) is not specified beyond the expectation language."],"key_facts":["Rex Heuermann is the suspect in the Gilgo Beach serial killings case.","He is expected to plead guilty in court on the day the report was published (\"today\")."],"numeric_claims":[],"primary_claim":"Rex Heuermann, the Gilgo Beach serial killings suspect, is expected to plead guilty in court today.","relevance_score":0.78,"sentiment":"neutral","source_quality":"high","summary":"CBS News reports that Gilgo Beach serial killings suspect Rex Heuermann is expected to plead guilty in court on the day of the report. The development suggests an imminent procedural shift toward sentencing rather than continued trial proceedings.","topics":["criminal justice","plea agreement","serial killings","court proceedings","guilty plea","sentencing outlook"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"Gilgo Beach serial killer suspect Rex Heuermann expected to plead guilty CBS News Suspect in Gilgo Beach serial killings expected to plead guilty in court today CNN Gilgo Beach murders suspect in court, 'major development' expected USA Today Defendant in Gilgo Beach Murders May Plead Guilty on Wednesday The New York Times Gilgo Beach serial killings suspect expected to plead guilty in death of eighth victim BBC","title":"Gilgo Beach serial killer suspect Rex Heuermann expected to plead guilty - CBS 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 7016 in events