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/CBMikwFBVV95cUxORHBkXzdaWkw3RHhqU0thRTZKSUsxUWtIbjdPVjh3RlJfSU9NR0FwLUdzOHJKM1NVMkpMSjl1dGE1Smphc2JrRXZLLUVBRm4wQ0FqUVAxUXZwWVE0QUlRZzY2Qk9vNkk5WTBIUVJRTlIxdE1Zb2xqTnpfZ3lGdjhqU09xenZfd3JnNWJ6ZTRJOS1IWjg?oc=5","as_of":"2026-04-09T02:28:00.854012+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/CBMikwFBVV95cUxORHBkXzdaWkw3RHhqU0thRTZKSUsxUWtIbjdPVjh3RlJfSU9NR0FwLUdzOHJKM1NVMkpMSjl1dGE1Smphc2JrRXZLLUVBRm4wQ0FqUVAxUXZwWVE0QUlRZzY2Qk9vNkk5WTBIUVJRTlIxdE1Zb2xqTnpfZ3lGdjhqU09xenZfd3JnNWJ6ZTRJOS1IWjg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8a8a0ff83baf07fa","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:25:23.228983+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxORHBkXzdaWkw3RHhqU0thRTZKSUsxUWtIbjdPVjh3RlJfSU9NR0FwLUdzOHJKM1NVMkpMSjl1dGE1Smphc2JrRXZLLUVBRm4wQ0FqUVAxUXZwWVE0QUlRZzY2Qk9vNkk5WTBIUVJRTlIxdE1Zb2xqTnpfZ3lGdjhqU09xenZfd3JnNWJ6ZTRJOS1IWjg?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxORHBkXzdaWkw3RHhqU0thRTZKSUsxUWtIbjdPVjh3RlJfSU9NR0FwLUdzOHJKM1NVMkpMSjl1dGE1Smphc2JrRXZLLUVBRm4wQ0FqUVAxUXZwWVE0QUlRZzY2Qk9vNkk5WTBIUVJRTlIxdE1Zb2xqTnpfZ3lGdjhqU09xenZfd3JnNWJ6ZTRJOS1IWjg?oc=5","source_event_id":"evt_087a28192d9c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5355a47c54eac01e","published_at":"2026-04-09T00:58:15+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Rex Heuermann","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Gilgo Beach serial killings","relevance":"high","symbol":"","type":"case"},{"asset_class":"other","name":"The New York Times","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["What the \u201cunusual\u201d deal specifically is (e.g., plea terms, cooperation scope) is not present in the supplied cleaned article content.","Which \u201cother murders\u201d are referenced and whether any specific cases are named is not available from the provided text.","Timing details (when investigators expect to act on leads) are not present in the supplied content.","Whether the deal has been formally accepted/entered in court is not confirmable from the provided text."],"key_facts":["The headline states that the Gilgo Beach Killer\u2019s \u201cunusual\u201d deal could help solve other murders.","The subject of the deal is Rex Heuermann (accused Gilgo Beach serial killer).","The provided article text is not available in the cleaned content (only page styling/boilerplate), so details of the deal are not extractable from the supplied text."],"numeric_claims":[],"primary_claim":"Rex Heuermann\u2019s \u201cunusual\u201d deal in the Gilgo Beach case could help solve other murders.","relevance_score":0.72,"sentiment":"neutral","source_quality":"high","summary":"The New York Times reports that Rex Heuermann, accused in the Gilgo Beach serial killings, entered an \u201cunusual\u201d deal that could help investigators solve other murders. The near-term catalyst is the information-sharing/forensic leads expected to emerge from that plea/deal process.","topics":["criminal justice","plea deal","investigation leads","serial killings","Gilgo Beach"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Gilgo Beach Killer\u2019s \u2018Unusual\u2019 Deal Could Help Solve Other Murders The New York Times 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 Gilgo Beach serial killer suspect Rex Heuermann pleads guilty The Guardian A timeline of the investigation of the Gilgo Beach killings NBC New York","title":"Gilgo Beach Killer\u2019s \u2018Unusual\u2019 Deal Could Help Solve Other Murders - The New York Times","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_4ca4023b9c7b in signals