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-08T21:48:34.554726+00:00","dedupe_key":"signal_enriched:news_delta:90b7dcf4467c59f1","evidence_event_ids":["evt_0d75e823c006"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxPVWg2dVAzX0xzckVUUWd2dlNhZzFDRlRtcmVfb0haT3FTN1RrVHVZU3EyMUhiNXhYRWVqSE9GOVJ3V3RZN2RZS2NudEsyYmZQbFd1d29jdGV0a3Fzak1zV01MejBtUVk2LThTY3phd3pCakc3ekxkSFVSN2hmM1dlNE8xRXhYcVo3aDhfN0NNX2FPeHA4YUNnbnh1T3RRZVNkcXdJTUE4MXJfWDdUbzhqa0hmOA?oc=5","as_of":"2026-04-08T21:48:34.554726+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/CBMiswFBVV95cUxPVWg2dVAzX0xzckVUUWd2dlNhZzFDRlRtcmVfb0haT3FTN1RrVHVZU3EyMUhiNXhYRWVqSE9GOVJ3V3RZN2RZS2NudEsyYmZQbFd1d29jdGV0a3Fzak1zV01MejBtUVk2LThTY3phd3pCakc3ekxkSFVSN2hmM1dlNE8xRXhYcVo3aDhfN0NNX2FPeHA4YUNnbnh1T3RRZVNkcXdJTUE4MXJfWDdUbzhqa0hmOA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_35d24f46b01cd7b8","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:15:04.257827+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxPVWg2dVAzX0xzckVUUWd2dlNhZzFDRlRtcmVfb0haT3FTN1RrVHVZU3EyMUhiNXhYRWVqSE9GOVJ3V3RZN2RZS2NudEsyYmZQbFd1d29jdGV0a3Fzak1zV01MejBtUVk2LThTY3phd3pCakc3ekxkSFVSN2hmM1dlNE8xRXhYcVo3aDhfN0NNX2FPeHA4YUNnbnh1T3RRZVNkcXdJTUE4MXJfWDdUbzhqa0hmOA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"centerforpolitics.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiswFBVV95cUxPVWg2dVAzX0xzckVUUWd2dlNhZzFDRlRtcmVfb0haT3FTN1RrVHVZU3EyMUhiNXhYRWVqSE9GOVJ3V3RZN2RZS2NudEsyYmZQbFd1d29jdGV0a3Fzak1zV01MejBtUVk2LThTY3phd3pCakc3ekxkSFVSN2hmM1dlNE8xRXhYcVo3aDhfN0NNX2FPeHA4YUNnbnh1T3RRZVNkcXdJTUE4MXJfWDdUbzhqa0hmOA?oc=5","source_event_id":"evt_0d75e823c006","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9cedce82c7eb284c","published_at":"2026-04-08T18:16:58+00:00","publisher_domain":"centerforpolitics.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["Tuesday"],"entities":[{"asset_class":"political","name":"Democrats","relevance":"high","symbol":"","type":"political_party"},{"asset_class":"political","name":"Republicans (G.O.P.)","relevance":"high","symbol":"","type":"political_party"},{"asset_class":"political_region","name":"Wisconsin","relevance":"high","symbol":"","type":"location"},{"asset_class":"political_region","name":"Georgia","relevance":"high","symbol":"","type":"location"},{"asset_class":"media","name":"Sabato's Crystal Ball (UVA Center for Politics)","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The New York Times","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"Politico","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"CNBC","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"ms.now","relevance":"low","symbol":"","type":"media_outlet"}],"event_type":"price_action","information_gaps":["The provided 'Article Text' appears to be unrelated page styling/HTML and does not contain the actual election results details (e.g., vote shares, margins, office names).","Exact election types (which Wisconsin/Georgia races), candidate names, and numerical margins are not present in the provided content.","The signal does not specify the near-term catalyst timing beyond 'Tuesday' and does not quantify market/political impact beyond qualitative framing."],"key_facts":["The headline and source summary state that Democrats had another big night based on Tuesday\u2019s results in Wisconsin and Georgia.","The source summary includes framing that Republicans received warnings/takeaways from the Georgia and Wisconsin elections.","One referenced item (CNBC) characterizes Democrats as winning a Wisconsin Supreme Court race with narrow margins in Georgia (exact margins not provided in the provided text)."],"numeric_claims":[],"primary_claim":"Tuesday\u2019s Wisconsin and Georgia election results were a major win for Democrats, with Republicans warned by the outcomes.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"The signal highlights a favorable set of election results for Democrats in Wisconsin and Georgia on Tuesday, framed as a warning sign for Republicans. It points to Democrats\u2019 momentum and suggests Republicans may face heightened political pressure in response.","topics":["US elections","Democrats vs Republicans","Wisconsin election results","Georgia election results","political momentum","election analysis"]},"source":"The Center for Politics at UVA","source_domain":"centerforpolitics.org","source_url":"https://centerforpolitics.org","summary":"Another Big Night for Democrats: Tuesday\u2019s Wisconsin and Georgia Results - Sabato's Crystal Ball The Center for Politics at UVA Warnings for the G.O.P.: 3 Takeaways From the Elections in Georgia and Wisconsin The New York Times \u2018A wow moment\u2019: Democrats\u2019 election hot streak goes scorching Politico Latest election results give Republicans new reasons to reach for the panic button ms.now Democrats romp in Wisconsin Supreme Court race, narrow margins in Georgia CNBC","title":"Another Big Night for Democrats: Tuesday\u2019s Wisconsin and Georgia Results - Sabato's Crystal Ball - The Center for Politics at UVA","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 8469 in events