SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_bc58690a90b7 in signals