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-08T11:24:56.686926+00:00","dedupe_key":"signal_enriched:news_delta:9a4e0be5e47fbfb9","evidence_event_ids":["evt_6018d2e00046"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxOUUUzaW5QM1dmR0dsZWd5VGgxT0pLRExzLWdyQURSMEI0dHlZOFdmODFNc2h1R0xJVHk4UWJRVEl0ZG1USjk1aHVjVjFBcngtY3o5QnVQYUdJdWQ1WTUwdnlxLUFiRm5KMU1BdXBTQ0tOZWQ3Qm1SZVFsbFNuWmZidXF0czgxQ2ZxeDBLQVNwWHhrREdNTjF4eGlYV2N0YWZERzJERzgySlMyWFFJZ3hnemRuRFo1RlJ5?oc=5","as_of":"2026-04-08T11:24:56.686926+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/CBMiuAFBVV95cUxOUUUzaW5QM1dmR0dsZWd5VGgxT0pLRExzLWdyQURSMEI0dHlZOFdmODFNc2h1R0xJVHk4UWJRVEl0ZG1USjk1aHVjVjFBcngtY3o5QnVQYUdJdWQ1WTUwdnlxLUFiRm5KMU1BdXBTQ0tOZWQ3Qm1SZVFsbFNuWmZidXF0czgxQ2ZxeDBLQVNwWHhrREdNTjF4eGlYV2N0YWZERzJERzgySlMyWFFJZ3hnemRuRFo1RlJ5?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a27b71d2dccf8103","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-08T11:25:38.342955+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxOUUUzaW5QM1dmR0dsZWd5VGgxT0pLRExzLWdyQURSMEI0dHlZOFdmODFNc2h1R0xJVHk4UWJRVEl0ZG1USjk1aHVjVjFBcngtY3o5QnVQYUdJdWQ1WTUwdnlxLUFiRm5KMU1BdXBTQ0tOZWQ3Qm1SZVFsbFNuWmZidXF0czgxQ2ZxeDBLQVNwWHhrREdNTjF4eGlYV2N0YWZERzJERzgySlMyWFFJZ3hnemRuRFo1RlJ5?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nbcnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxOUUUzaW5QM1dmR0dsZWd5VGgxT0pLRExzLWdyQURSMEI0dHlZOFdmODFNc2h1R0xJVHk4UWJRVEl0ZG1USjk1aHVjVjFBcngtY3o5QnVQYUdJdWQ1WTUwdnlxLUFiRm5KMU1BdXBTQ0tOZWQ3Qm1SZVFsbFNuWmZidXF0czgxQ2ZxeDBLQVNwWHhrREdNTjF4eGlYV2N0YWZERzJERzgySlMyWFFJZ3hnemRuRFo1RlJ5?oc=5","source_event_id":"evt_6018d2e00046","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f41a39b2f033b4f0","published_at":"2026-04-08T10:00:00+00:00","publisher_domain":"nbcnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"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":"case"},{"asset_class":"other","name":"NBC News","relevance":"source","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["Exact court date/time is not included in the provided cleaned text (headline suggests it is imminent, but the specific date is not captured here).","The jurisdiction/court name is not provided in the extracted content.","Whether the plea is confirmed (as opposed to expected) is not explicitly verified in the provided text."],"key_facts":["The suspect (Rex Heuermann) is expected to plead guilty.","The expected guilty plea is tied to the death of the eighth victim.","Heuermann is scheduled to head to court for this expected plea (timing implied as near-term, but exact date/time not present in the provided text)."],"numeric_claims":[{"label":"victim_count_mentioned","value":"8"}],"primary_claim":"Rex Heuermann is heading to court for an expected guilty plea in the Gilgo Beach serial killings case involving the death of the eighth victim.","relevance_score":0.78,"sentiment":"neutral","source_quality":"high","summary":"NBC News reports that Gilgo Beach serial killings suspect Rex Heuermann is scheduled to appear in court for an expected guilty plea related to the eighth victim.","topics":["criminal justice","guilty plea","Gilgo Beach serial killings","court appearance"]},"source":"NBC News","source_domain":"nbcnews.com","source_url":"https://www.nbcnews.com","summary":"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 Gilgo Beach serial killings suspect expected to plead guilty to eighth victim BBC Exclusive video shows moment officer hit by car in Williamsburg; police release images of person wanted News12 | Brooklyn Gilgo Beach suspected serial killer Rex Heuermann expected to plead guilty in death of 8th woman in court ABC7 New York","title":"Gilgo Beach serial killings suspect heads to court for expected guilty plea - NBC 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 6161 in events