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-14T02:27:43.528800+00:00","dedupe_key":"signal_enriched:news_delta:8a6398197d7210f2","evidence_event_ids":["evt_b23219a2e147"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxObU9UYm5Kb3VVVlprMVNsYzBRS3FVekJCR1BNTlZZWTkxUmI5U3VLdnBabnBzLXc4YWVCUUlJdTFpNV9icEREQWhtbmhpOVRLTi01OUtDb0ZWWkZvRGIzVl9tNE0tTzdtMTY3Rk41aWppVzBGazBSWk5PekUzRWRINkx3MXNQeExOeE5QY3p2czNUbzdCN0hKRnY3dzBfT25fTUoyR0g1QjIzZGZ5NjJ1b3d3?oc=5","as_of":"2026-04-14T02:27:43.528800+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxObU9UYm5Kb3VVVlprMVNsYzBRS3FVekJCR1BNTlZZWTkxUmI5U3VLdnBabnBzLXc4YWVCUUlJdTFpNV9icEREQWhtbmhpOVRLTi01OUtDb0ZWWkZvRGIzVl9tNE0tTzdtMTY3Rk41aWppVzBGazBSWk5PekUzRWRINkx3MXNQeExOeE5QY3p2czNUbzdCN0hKRnY3dzBfT25fTUoyR0g1QjIzZGZ5NjJ1b3d3?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_80487a160b6ce7a1","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T02:41:19.725846+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxObU9UYm5Kb3VVVlprMVNsYzBRS3FVekJCR1BNTlZZWTkxUmI5U3VLdnBabnBzLXc4YWVCUUlJdTFpNV9icEREQWhtbmhpOVRLTi01OUtDb0ZWWkZvRGIzVl9tNE0tTzdtMTY3Rk41aWppVzBGazBSWk5PekUzRWRINkx3MXNQeExOeE5QY3p2czNUbzdCN0hKRnY3dzBfT25fTUoyR0g1QjIzZGZ5NjJ1b3d3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxObU9UYm5Kb3VVVlprMVNsYzBRS3FVekJCR1BNTlZZWTkxUmI5U3VLdnBabnBzLXc4YWVCUUlJdTFpNV9icEREQWhtbmhpOVRLTi01OUtDb0ZWWkZvRGIzVl9tNE0tTzdtMTY3Rk41aWppVzBGazBSWk5PekUzRWRINkx3MXNQeExOeE5QY3p2czNUbzdCN0hKRnY3dzBfT25fTUoyR0g1QjIzZGZ5NjJ1b3d3?oc=5","source_event_id":"evt_b23219a2e147","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"c0d18638db8459c8","published_at":"2026-04-13T23:56:19+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Eric Swalwell","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"","name":"US Congress","relevance":"affected institution","symbol":"","type":"institution"}],"event_type":"conflict","information_gaps":["No article text is provided, so the timing (exact resignation date) and the specific allegations/claims are not detailed.","No information is provided on whether an expulsion vote is scheduled, its date, or the likelihood/outcome.","No asset/market entities are mentioned in the provided text, so no direct tradable-asset impact can be grounded."],"key_facts":["Reuters reports that US Representative Swalwell will quit Congress following sexual misconduct allegations.","The provided source summary states Swalwell says he plans to resign from Congress amid sexual misconduct allegations.","The Washington Post summary mentions exits from Congress ahead of possible expulsion votes."],"numeric_claims":[],"primary_claim":"Eric Swalwell intends to quit/resign from Congress amid sexual misconduct allegations.","relevance_score":0.72,"sentiment":"negative","source_quality":"unknown","summary":"US Representative Eric Swalwell plans to resign from Congress following sexual misconduct allegations, as reported by Reuters and echoed by other outlets in the provided summary.","topics":["political resignation","sexual misconduct allegations","US Congress","possible expulsion votes"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"US Representative Swalwell to quit Congress following sexual misconduct allegations Reuters Swalwell says he plans to resign from Congress amid sexual misconduct allegations CNN What Happens in California Governor\u2019s Race After Eric Swalwell Stepped Down? The New York Times Reps. Swalwell, Gonzales signal exits from Congress ahead of possible expulsion votes The Washington Post The whisper network that caught up to Eric Swalwell Politico","title":"US Representative Swalwell to quit Congress following sexual misconduct allegations - Reuters","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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 39829 in events