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-03T10:50:10.040970+00:00","dedupe_key":"signal_enriched:news_delta:31ebe5a686785069","evidence_event_ids":["evt_c716e7db432f"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxPODJsd09WTFJDcUtsMldGSnJzeW1iaEE0ZGtzZkVCdHljUVl6REhLdk1fTkpUMjVoUk1SRFZxUzVVZWdEYndvSGpnSzFVVmxzNFZYdlRCcjdkN2pTY2pEX1VEWjBaN1NIWlJxMUNVZk51akUyNTZfREEwa09tSXdiQlJVNGg0eTE2NjRscmtYSGRSeVFFS1E5Nl9YYjLSAaIBQVVfeXFMTmVQMnp0eTJvdjNCc3ZzZ29UdW1ucDNZVWdVQXZPY1JrbkdFb3pqRU9sQl9LY0ljQV9zS1lKZWVNR0NSanN5TmR4RDlINGtSVmpSZjM3ZTFCQzZJWUpGZ3JzSmlRdG9pWXRGSlNiSE5lNkQyTnl5UDd5ZXpFVGJtcjJOc1RJQ1JtQk5ram9VOUF4RUliOVNaS3B2VElLVE0tQTF3?oc=5","as_of":"2026-04-03T10:50:10.040970+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAIFAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2MNBf6_swFs4DmRttHTFlSXqjvXTw/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxPODJsd09WTFJDcUtsMldGSnJzeW1iaEE0ZGtzZkVCdHljUVl6REhLdk1fTkpUMjVoUk1SRFZxUzVVZWdEYndvSGpnSzFVVmxzNFZYdlRCcjdkN2pTY2pEX1VEWjBaN1NIWlJxMUNVZk51akUyNTZfREEwa09tSXdiQlJVNGg0eTE2NjRscmtYSGRSeVFFS1E5Nl9YYjLSAaIBQVVfeXFMTmVQMnp0eTJvdjNCc3ZzZ29UdW1ucDNZVWdVQXZPY1JrbkdFb3pqRU9sQl9LY0ljQV9zS1lKZWVNR0NSanN5TmR4RDlINGtSVmpSZjM3ZTFCQzZJWUpGZ3JzSmlRdG9pWXRGSlNiSE5lNkQyTnl5UDd5ZXpFVGJtcjJOc1RJQ1JtQk5ram9VOUF4RUliOVNaS3B2VElLVE0tQTF3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6e22f3fb2dc1d6be","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAIFAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2MNBf6_swFs4DmRttHTFlSXqjvXTw/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-03T22:13:35.374783+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxPODJsd09WTFJDcUtsMldGSnJzeW1iaEE0ZGtzZkVCdHljUVl6REhLdk1fTkpUMjVoUk1SRFZxUzVVZWdEYndvSGpnSzFVVmxzNFZYdlRCcjdkN2pTY2pEX1VEWjBaN1NIWlJxMUNVZk51akUyNTZfREEwa09tSXdiQlJVNGg0eTE2NjRscmtYSGRSeVFFS1E5Nl9YYjLSAaIBQVVfeXFMTmVQMnp0eTJvdjNCc3ZzZ29UdW1ucDNZVWdVQXZPY1JrbkdFb3pqRU9sQl9LY0ljQV9zS1lKZWVNR0NSanN5TmR4RDlINGtSVmpSZjM3ZTFCQzZJWUpGZ3JzSmlRdG9pWXRGSlNiSE5lNkQyTnl5UDd5ZXpFVGJtcjJOc1RJQ1JtQk5ram9VOUF4RUliOVNaS3B2VElLVE0tQTF3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"abcnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxPODJsd09WTFJDcUtsMldGSnJzeW1iaEE0ZGtzZkVCdHljUVl6REhLdk1fTkpUMjVoUk1SRFZxUzVVZWdEYndvSGpnSzFVVmxzNFZYdlRCcjdkN2pTY2pEX1VEWjBaN1NIWlJxMUNVZk51akUyNTZfREEwa09tSXdiQlJVNGg0eTE2NjRscmtYSGRSeVFFS1E5Nl9YYjLSAaIBQVVfeXFMTmVQMnp0eTJvdjNCc3ZzZ29UdW1ucDNZVWdVQXZPY1JrbkdFb3pqRU9sQl9LY0ljQV9zS1lKZWVNR0NSanN5TmR4RDlINGtSVmpSZjM3ZTFCQzZJWUpGZ3JzSmlRdG9pWXRGSlNiSE5lNkQyTnl5UDd5ZXpFVGJtcjJOc1RJQ1JtQk5ram9VOUF4RUliOVNaS3B2VElLVE0tQTF3?oc=5","source_event_id":"evt_c716e7db432f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"db91c36fc59f0e5c","published_at":"2026-04-02T23:59:11+00:00","publisher_domain":"abcnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Hawaii doctor","relevance":"accused","symbol":"","type":"individual"},{"asset_class":"","name":"wife","relevance":"victim","symbol":"","type":"individual"}],"event_type":"conflict","information_gaps":["Details of the incident are not fully disclosed.","The outcome of the trial is yet to be determined."],"key_facts":["The doctor is on trial for attempted murder.","He claims self-defense during the incident on a hiking trail."],"numeric_claims":[],"primary_claim":"The doctor testified that he was defending himself against his wife during the alleged attempted murder incident.","relevance_score":0.8,"sentiment":"mixed","source_quality":"high","summary":"A Hawaii doctor accused of attempting to murder his wife claims he was acting in self-defense during his testimony.","topics":["legal","self-defense","crime"]},"source":"ABC News","source_domain":"abcnews.com","source_url":"https://abcnews.com","summary":"Hawaii doctor accused of trying to kill wife on hiking trail testifies he was defending himself ABC News LIVE: Maui Doctor Trial Hawaii News Now Maui doctor accused of trying to murder wife takes stand, claims self-defense cbsnews.com Maui doctor addresses claims he tracked wife\u2019s messages in Pali hike attempted murder trial KITV Hawaii Doctor's Son Reveals What He Saw on FaceTime Call After Dad Allegedly Admitted He 'Tried to Kill' Stepmom Yahoo! Singapore","title":"Hawaii doctor accused of trying to kill wife on hiking trail testifies he was defending himself - ABC News","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAIFAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2MNBf6_swFs4DmRttHTFlSXqjvXTw/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 6020 in events