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/CBMimwFBVV95cUxOV3JjWGtKMkU2a3FDNWFIZklhQzZDQ3FrSEF3a3FQMnBsYnNlU3FMNUpWaDNCeXhwZnMyQXBxcEY1aUcwTnNGLUkzZzRLQVNKdTFqMnlaenV1VkxLT1BiZGpJNzh5VG1VVFFoS0hfR0htRkJDRUFxaHp2d0IwN3gyX3ZjMVlNOWN2bkRVMGo4T2paWDlCTmx3aFFBOA?oc=5","as_of":"2026-04-09T01:37:46.871329+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/CBMimwFBVV95cUxOV3JjWGtKMkU2a3FDNWFIZklhQzZDQ3FrSEF3a3FQMnBsYnNlU3FMNUpWaDNCeXhwZnMyQXBxcEY1aUcwTnNGLUkzZzRLQVNKdTFqMnlaenV1VkxLT1BiZGpJNzh5VG1VVFFoS0hfR0htRkJDRUFxaHp2d0IwN3gyX3ZjMVlNOWN2bkRVMGo4T2paWDlCTmx3aFFBOA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_494ada0645b1da3a","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:22:39.593586+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxOV3JjWGtKMkU2a3FDNWFIZklhQzZDQ3FrSEF3a3FQMnBsYnNlU3FMNUpWaDNCeXhwZnMyQXBxcEY1aUcwTnNGLUkzZzRLQVNKdTFqMnlaenV1VkxLT1BiZGpJNzh5VG1VVFFoS0hfR0htRkJDRUFxaHp2d0IwN3gyX3ZjMVlNOWN2bkRVMGo4T2paWDlCTmx3aFFBOA?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/CBMimwFBVV95cUxOV3JjWGtKMkU2a3FDNWFIZklhQzZDQ3FrSEF3a3FQMnBsYnNlU3FMNUpWaDNCeXhwZnMyQXBxcEY1aUcwTnNGLUkzZzRLQVNKdTFqMnlaenV1VkxLT1BiZGpJNzh5VG1VVFFoS0hfR0htRkJDRUFxaHp2d0IwN3gyX3ZjMVlNOWN2bkRVMGo4T2paWDlCTmx3aFFBOA?oc=5","source_event_id":"evt_16a08d31f1d3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2a31b13fe66f5b19","published_at":"2026-04-09T00:34:00+00:00","publisher_domain":"nbcnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Maui doctor (defendant)","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Wife (victim)","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Maui, Hawaii","relevance":"high","symbol":"","type":"location"},{"asset_class":"other","name":"NBC News","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The specific verdict outcome (e.g., convicted vs acquitted, and on which counts) is not fully stated in the provided headline text; only that a verdict was reached.","The defendant\u2019s name and the exact court/jurisdiction are not included in the provided text.","The timing of the verdict (date/time) and sentencing details are not provided.","No details are included about the evidence presented or the defense\u2019s arguments beyond the prosecutors\u2019 jealousy motive theory."],"key_facts":["The trial took place in Maui, Hawaii (per headline context).","The defendant is described as a doctor accused of trying to kill his wife during a birthday hike.","The alleged incident occurred during a cliffside hike (per source summary snippets).","Prosecutors\u2019 motive theory included jealousy (per source summary snippets).","A verdict has been reached (headline)."],"numeric_claims":[],"primary_claim":"A verdict was reached in the trial of a Maui doctor accused of trying to kill his wife during a birthday hike.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"A verdict has been reached in the trial of a Maui doctor accused of trying to kill his wife during a birthday hike. The reporting indicates the case involved an alleged attack on a cliffside hike and that prosecutors attributed motive to jealousy.","topics":["criminal trial","attempted manslaughter","domestic violence","Hawaii","court verdict"]},"source":"NBC News","source_domain":"nbcnews.com","source_url":"https://www.nbcnews.com","summary":"Verdict reached in trial of Maui doctor accused of trying to kill wife during birthday hike NBC News Hawaii doctor learns fate after prosecutors say jealousy drove him to attack wife on cliffside hike Fox News Gerhardt Konig: Hawaii doctor accused of trying to kill his wife convicted of attempted manslaughter CNN LIVE: Maui Doctor Trial Verdict Hawaii News Now Doctor accused of trying to kill his wife during cliffside hike in Hawaii found guilty CBS News","title":"Verdict reached in trial of Maui doctor accused of trying to kill wife during birthday hike - 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_99e824561916 in signals