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/CBMipgFBVV95cUxOVlo2VWFBd2JFTWMzWklQalJRZkd1cU5lajEzOUhaYXM4RklpRFpQUmZ0SUFiR0YzUmFkTDlGQTBHdWdSSlNDdVJ0aC1pNEdNSHFXV2luVWZBZEZUZGFzRWltaE04S2FvWTl4X09WeUNJUmtCSUVMaTdCZzZ5dWQxRjY1SmJ5MEhGMzZqUlJ1NDN5QjJUWVpqbFFZYXFnMFZUWEJOX2930gGrAUFVX3lxTE1sX3NuNW43dWZDRHR1TGI2MmlITHZ3d0otOTdLUG43Rm1vMFBRTURyQVF1d1RjMzlGQkRpcG9yQXBLTUVMSzhsM3lGeVVuVFZiMXhqZEIzQWZpQktUTE1NejlQaHRZVUdSZ2Vsd1BlYy1qVktKR3UwM3Npb3U0NXVSUFFLVFluWUstak9CUmdabWw1Y3FSajVXZUdJX2Eya2dsbFBJYnlaUWVmYw?oc=5","as_of":"2026-04-08T19:34:52.388907+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/CBMipgFBVV95cUxOVlo2VWFBd2JFTWMzWklQalJRZkd1cU5lajEzOUhaYXM4RklpRFpQUmZ0SUFiR0YzUmFkTDlGQTBHdWdSSlNDdVJ0aC1pNEdNSHFXV2luVWZBZEZUZGFzRWltaE04S2FvWTl4X09WeUNJUmtCSUVMaTdCZzZ5dWQxRjY1SmJ5MEhGMzZqUlJ1NDN5QjJUWVpqbFFZYXFnMFZUWEJOX2930gGrAUFVX3lxTE1sX3NuNW43dWZDRHR1TGI2MmlITHZ3d0otOTdLUG43Rm1vMFBRTURyQVF1d1RjMzlGQkRpcG9yQXBLTUVMSzhsM3lGeVVuVFZiMXhqZEIzQWZpQktUTE1NejlQaHRZVUdSZ2Vsd1BlYy1qVktKR3UwM3Npb3U0NXVSUFFLVFluWUstak9CUmdabWw1Y3FSajVXZUdJX2Eya2dsbFBJYnlaUWVmYw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c9f45489199887b3","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:06:07.691148+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxOVlo2VWFBd2JFTWMzWklQalJRZkd1cU5lajEzOUhaYXM4RklpRFpQUmZ0SUFiR0YzUmFkTDlGQTBHdWdSSlNDdVJ0aC1pNEdNSHFXV2luVWZBZEZUZGFzRWltaE04S2FvWTl4X09WeUNJUmtCSUVMaTdCZzZ5dWQxRjY1SmJ5MEhGMzZqUlJ1NDN5QjJUWVpqbFFZYXFnMFZUWEJOX2930gGrAUFVX3lxTE1sX3NuNW43dWZDRHR1TGI2MmlITHZ3d0otOTdLUG43Rm1vMFBRTURyQVF1d1RjMzlGQkRpcG9yQXBLTUVMSzhsM3lGeVVuVFZiMXhqZEIzQWZpQktUTE1NejlQaHRZVUdSZ2Vsd1BlYy1qVktKR3UwM3Npb3U0NXVSUFFLVFluWUstak9CUmdabWw1Y3FSajVXZUdJX2Eya2dsbFBJYnlaUWVmYw?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/CBMipgFBVV95cUxOVlo2VWFBd2JFTWMzWklQalJRZkd1cU5lajEzOUhaYXM4RklpRFpQUmZ0SUFiR0YzUmFkTDlGQTBHdWdSSlNDdVJ0aC1pNEdNSHFXV2luVWZBZEZUZGFzRWltaE04S2FvWTl4X09WeUNJUmtCSUVMaTdCZzZ5dWQxRjY1SmJ5MEhGMzZqUlJ1NDN5QjJUWVpqbFFZYXFnMFZUWEJOX2930gGrAUFVX3lxTE1sX3NuNW43dWZDRHR1TGI2MmlITHZ3d0otOTdLUG43Rm1vMFBRTURyQVF1d1RjMzlGQkRpcG9yQXBLTUVMSzhsM3lGeVVuVFZiMXhqZEIzQWZpQktUTE1NejlQaHRZVUdSZ2Vsd1BlYy1qVktKR3UwM3Npb3U0NXVSUFFLVFluWUstak9CUmdabWw1Y3FSajVXZUdJX2Eya2dsbFBJYnlaUWVmYw?oc=5","source_event_id":"evt_d4fa0714eec1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c05c89f65ca2ef72","published_at":"2026-04-08T16:24:00+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":["13 years ago","2013"],"entities":[{"asset_class":"news_media","name":"CBS News","relevance":"high","symbol":"","type":"publisher"},{"asset_class":"person","name":"Molly Miller","relevance":"high","symbol":"","type":"person"},{"asset_class":"organization","name":"Chickasaw Nation","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"event","name":"Oklahoma car chase (2013 police chase)","relevance":"high","symbol":"","type":"event"}],"event_type":"other","information_gaps":["The cleaned article text provided contains only CSS/boilerplate and does not include the actual narrative details needed to confirm names of both individuals in the pair.","The specific location of the chase, the names of the other person besides Molly Miller, and the method/date of identification are not present in the provided text.","No information is provided here about whether any arrests/charges followed the chase or whether the identification changes an active investigation."],"key_facts":["Human remains were identified as belonging to a pair who vanished after an Oklahoma car chase 13 years ago (per CBS News headline).","The case is described as involving a 2013 police chase in Oklahoma (per provided source summary snippets).","A related snippet indicates the remains are of missing Chickasaw citizen Molly Miller (per provided source summary snippets).","A related snippet indicates Molly Miller\u2019s family expressed relief and sadness and gratitude for Chickasaw Nation\u2019s help (per provided source summary snippets)."],"numeric_claims":[{"label":"years since disappearance","value":"13"},{"label":"year of chase","value":"2013"}],"primary_claim":"Human remains have been identified as those of a couple who vanished after an Oklahoma car chase 13 years ago.","relevance_score":0.78,"sentiment":"mixed","source_quality":"high","summary":"CBS News reports that human remains have been identified as belonging to a pair who disappeared after an Oklahoma car chase 13 years ago. The identification is a long-delayed development in a long-running missing-person case.","topics":["missing persons","human remains identification","Oklahoma police chase","cold case","forensic identification","family statement"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"Human remains identified as pair who vanished after Oklahoma car chase 13 years ago CBS News 2 Sets of Human Remains Identified as Couple Who Vanished Following Car Chase Over a Decade Ago People.com Human remains identified as pair who disappeared following 2013 police chase in Oklahoma KOSU Remains of Missing Chickasaw Citizen Molly Miller Identified After 13 Years nativenewsonline.net \u2018We\u2019re relieved and sad\u2019: Molly Miller\u2019s family says they\u2019re grateful for Chickasaw Nation\u2019s help KXII","title":"Human remains identified as pair who vanished after Oklahoma car chase 13 years ago - CBS 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_68f811d22d01 in signals