SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-09T02:28:00.933915+00:00","dedupe_key":"signal_enriched:news_delta:ea233ccba464cdb1","evidence_event_ids":["evt_9fb267d6686a"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 8721 in events