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/CBMiogFBVV95cUxOMDVsQ1VjMVJmQVU3RFJ3aGdUblhkWVVLQVVzb3BqVU03bXQ1ZTNSSGYzZ2V3OHRqSGU3OTBxLWRfSHNCNHNSa2JENFNZWVpjd25zSmtjMEk0cDJhZjkyd1NkU3JybUxIYnVFaXJvR2NOVG5Obm5pZTREdTViMFZ2M1E1WklDYXhpT3V4OVVPTlBLN3FBcVc1Ylo4Y0pmajVNa3fSAacBQVVfeXFMUHBnNUgzS0RGODI3V1hwdDlMMlVhMGlRY2FLcW1PUXZETWN1T29xZnBRVlVtaHhELVQ2VHptelZ5b01UTGp0d0w0eUpXLXBrSWdKcG95TXlDU2xvS21ZRHh5MUZHRlQ5SjRCYlVMTk9OZE1YQ2VXRWVHSkltUE5ZQW53cVpxajFuQmEyZWoxOVZmaWtVZHo1VEhEYXZ5bVpEdUpmdjcyUzA?oc=5","as_of":"2026-04-09T02:28:00.933915+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/CBMiogFBVV95cUxOMDVsQ1VjMVJmQVU3RFJ3aGdUblhkWVVLQVVzb3BqVU03bXQ1ZTNSSGYzZ2V3OHRqSGU3OTBxLWRfSHNCNHNSa2JENFNZWVpjd25zSmtjMEk0cDJhZjkyd1NkU3JybUxIYnVFaXJvR2NOVG5Obm5pZTREdTViMFZ2M1E1WklDYXhpT3V4OVVPTlBLN3FBcVc1Ylo4Y0pmajVNa3fSAacBQVVfeXFMUHBnNUgzS0RGODI3V1hwdDlMMlVhMGlRY2FLcW1PUXZETWN1T29xZnBRVlVtaHhELVQ2VHptelZ5b01UTGp0d0w0eUpXLXBrSWdKcG95TXlDU2xvS21ZRHh5MUZHRlQ5SjRCYlVMTk9OZE1YQ2VXRWVHSkltUE5ZQW53cVpxajFuQmEyZWoxOVZmaWtVZHo1VEhEYXZ5bVpEdUpmdjcyUzA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5e932860bcb820f9","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:55.144885+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxOMDVsQ1VjMVJmQVU3RFJ3aGdUblhkWVVLQVVzb3BqVU03bXQ1ZTNSSGYzZ2V3OHRqSGU3OTBxLWRfSHNCNHNSa2JENFNZWVpjd25zSmtjMEk0cDJhZjkyd1NkU3JybUxIYnVFaXJvR2NOVG5Obm5pZTREdTViMFZ2M1E1WklDYXhpT3V4OVVPTlBLN3FBcVc1Ylo4Y0pmajVNa3fSAacBQVVfeXFMUHBnNUgzS0RGODI3V1hwdDlMMlVhMGlRY2FLcW1PUXZETWN1T29xZnBRVlVtaHhELVQ2VHptelZ5b01UTGp0d0w0eUpXLXBrSWdKcG95TXlDU2xvS21ZRHh5MUZHRlQ5SjRCYlVMTk9OZE1YQ2VXRWVHSkltUE5ZQW53cVpxajFuQmEyZWoxOVZmaWtVZHo1VEhEYXZ5bVpEdUpmdjcyUzA?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/CBMiogFBVV95cUxOMDVsQ1VjMVJmQVU3RFJ3aGdUblhkWVVLQVVzb3BqVU03bXQ1ZTNSSGYzZ2V3OHRqSGU3OTBxLWRfSHNCNHNSa2JENFNZWVpjd25zSmtjMEk0cDJhZjkyd1NkU3JybUxIYnVFaXJvR2NOVG5Obm5pZTREdTViMFZ2M1E1WklDYXhpT3V4OVVPTlBLN3FBcVc1Ylo4Y0pmajVNa3fSAacBQVVfeXFMUHBnNUgzS0RGODI3V1hwdDlMMlVhMGlRY2FLcW1PUXZETWN1T29xZnBRVlVtaHhELVQ2VHptelZ5b01UTGp0d0w0eUpXLXBrSWdKcG95TXlDU2xvS21ZRHh5MUZHRlQ5SjRCYlVMTk9OZE1YQ2VXRWVHSkltUE5ZQW53cVpxajFuQmEyZWoxOVZmaWtVZHo1VEhEYXZ5bVpEdUpmdjcyUzA?oc=5","source_event_id":"evt_9fb267d6686a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7a02a8c2528c9029","published_at":"2026-04-09T00:57:00+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"n/a","name":"Doctor (name not provided in provided text)","relevance":"high","symbol":"","type":"person"},{"asset_class":"n/a","name":"Wife (victim) (name not provided in provided text)","relevance":"high","symbol":"","type":"person"},{"asset_class":"n/a","name":"Hawaii","relevance":"high","symbol":"","type":"location"},{"asset_class":"n/a","name":"Maui","relevance":"medium","symbol":"","type":"location"},{"asset_class":"n/a","name":"CBS News","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The doctor\u2019s name, age, and specific court date are not included in the provided text.","The exact charge wording (e.g., attempted manslaughter vs. attempted murder) and sentencing outcome are not provided.","Details of the incident (injuries, weapon/method, timeline of the hike) are not included.","Whether the verdict is final or subject to appeal is not stated in the provided text."],"key_facts":["A doctor in Hawaii was found guilty of attempted manslaughter related to an attack on his wife during a cliffside hike.","The incident occurred during a cliffside hike in Hawaii (with additional sources indicating Maui).","Prosecutors alleged jealousy drove the doctor to attack his wife."],"numeric_claims":[],"primary_claim":"The doctor was found guilty of attempted manslaughter for trying to kill his wife during a cliffside hike in Hawaii.","relevance_score":0.42,"sentiment":"negative","source_quality":"high","summary":"A Hawaii doctor was found guilty of attempted manslaughter for an attack on his wife during a cliffside hike. Prosecutors alleged jealousy motivated the assault.","topics":["criminal conviction","attempted manslaughter","domestic violence","Hawaii","court verdict"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"Doctor found guilty of trying to kill his wife during cliffside hike in Hawaii CBS News Hawaii doctor learns fate after prosecutors say jealousy drove him to attack wife on cliffside hike Fox News Hawaii doctor accused of trying to kill his wife found guilty of attempted manslaughter The Guardian Maui doctor accused of trying to kill wife on hike is found guilty of attempted manslaughter NBC News Jury finds Maui doctor guilty of attempted manslaughter Honolulu Star-Advertiser","title":"Doctor found guilty of trying to kill his wife during cliffside hike in Hawaii - 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_35e5d249f041 in signals