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-09T05:26:02.848646+00:00","dedupe_key":"signal_enriched:news_delta:8ea3b8e9e9306f04","evidence_event_ids":["evt_e57406f3009f"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxQX0x1QnlsckliNTY3ejFyNUV3b0Q2Tm1LT1JDN0NRNVMxMFlpbll5N0xsZV93bGxSQThLY1I5bnc3N3FEY2pLSkdEcmdIXy1Zb09yMnFLd0k0Y2dJSHdfWjZUTlpxZEdJMy01YTdMQlpQSjdUdkpxWmZ5a1BybmNORUU1UkVpamVvS05MY0s3UXZ6NjNBdEpkcVNYd1JEM3oxUkNrdzhn?oc=5","as_of":"2026-04-09T05:26:02.848646+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/CBMipgFBVV95cUxQX0x1QnlsckliNTY3ejFyNUV3b0Q2Tm1LT1JDN0NRNVMxMFlpbll5N0xsZV93bGxSQThLY1I5bnc3N3FEY2pLSkdEcmdIXy1Zb09yMnFLd0k0Y2dJSHdfWjZUTlpxZEdJMy01YTdMQlpQSjdUdkpxWmZ5a1BybmNORUU1UkVpamVvS05MY0s3UXZ6NjNBdEpkcVNYd1JEM3oxUkNrdzhn?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d6d635ef4dd2e223","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:41:34.711173+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxQX0x1QnlsckliNTY3ejFyNUV3b0Q2Tm1LT1JDN0NRNVMxMFlpbll5N0xsZV93bGxSQThLY1I5bnc3N3FEY2pLSkdEcmdIXy1Zb09yMnFLd0k0Y2dJSHdfWjZUTlpxZEdJMy01YTdMQlpQSjdUdkpxWmZ5a1BybmNORUU1UkVpamVvS05MY0s3UXZ6NjNBdEpkcVNYd1JEM3oxUkNrdzhn?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxQX0x1QnlsckliNTY3ejFyNUV3b0Q2Tm1LT1JDN0NRNVMxMFlpbll5N0xsZV93bGxSQThLY1I5bnc3N3FEY2pLSkdEcmdIXy1Zb09yMnFLd0k0Y2dJSHdfWjZUTlpxZEdJMy01YTdMQlpQSjdUdkpxWmZ5a1BybmNORUU1UkVpamVvS05MY0s3UXZ6NjNBdEpkcVNYd1JEM3oxUkNrdzhn?oc=5","source_event_id":"evt_e57406f3009f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b2316287d9385745","published_at":"2026-04-09T02:13:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Hawaii doctor (name not provided in provided text)","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Wife of the accused doctor","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Prosecutors","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"The Guardian","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"Fox News","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"NBC News","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"The New York Times","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"CNN","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The accused doctor\u2019s name, age, and specific court/jurisdiction are not included in the provided text.","The exact date of the verdict and sentencing outcome (if any) are not provided.","The precise legal reasoning for the attempted manslaughter conviction (vs. other charges) is not included.","Injury severity, weapon/method used, and whether the wife survived are not specified in the provided text.","The full article content is not available in the provided 'cleaned' text (it appears to be page styling/boilerplate), so details beyond the summaries cannot be verified here."],"key_facts":["A Hawaii doctor accused of trying to kill his wife was found guilty of attempted manslaughter.","The alleged attack occurred during a cliffside hike (location described as cliffside hike).","Prosecutors stated jealousy drove the doctor to attack his wife.","One outlet summary indicates the doctor confessed in a FaceTime call that he tried to kill his wife (details not fully provided in the supplied text).","The provided signal is based on headline/summary text from multiple publishers rather than the full article body (the cleaned article text appears to be non-content HTML/CSS)."],"numeric_claims":[],"primary_claim":"The Hawaii doctor was found guilty of attempted manslaughter for an attack on his wife during a hike.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"A Hawaii doctor accused of trying to kill his wife was found guilty of attempted manslaughter, according to multiple outlets. The case centers on an attack during a cliffside hike, with prosecutors citing jealousy as a motive.","topics":["criminal justice","attempted manslaughter","domestic violence","court verdict","Hawaii","hike attack","motive (jealousy)","confession (FaceTime)"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Hawaii doctor accused of trying to kill his wife found guilty of attempted manslaughter The Guardian Hawaii doctor learns fate after prosecutors say jealousy drove him to attack wife on cliffside hike Fox News Maui doctor accused of trying to kill wife on hike is found guilty of attempted manslaughter NBC News Hawaii Doctor Convicted of Attempted Manslaughter in Attack on Wife The New York Times Hawaii doctor confessed in FaceTime call he tried to kill his wife, son testifies CNN","title":"Hawaii doctor accused of trying to kill his wife found guilty of attempted manslaughter - The Guardian","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 9046 in events