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-08T19:34:52.577506+00:00","dedupe_key":"signal_enriched:news_delta:7b56527a71fb766d","evidence_event_ids":["evt_a929f2e15b6b"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxPQUptSUlOX0ZQN3ZMUVE0OTItYmZ6LVMxV0VtX3hzWElQNVB4QTNJeU82UE9qVml0VlN4SHdIeVRiYjFUbUNVTXJSejdkUzYtZjRBRXJhQTRLNWhYS3BtbWVNdHdIVm1TRU1nVzFQNXZXZm9uRjNFcXhURnVVYlFQSmV1OUs3QmFlMjVRUGE0aW5fVnM?oc=5","as_of":"2026-04-08T19:34:52.577506+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/CBMikwFBVV95cUxPQUptSUlOX0ZQN3ZMUVE0OTItYmZ6LVMxV0VtX3hzWElQNVB4QTNJeU82UE9qVml0VlN4SHdIeVRiYjFUbUNVTXJSejdkUzYtZjRBRXJhQTRLNWhYS3BtbWVNdHdIVm1TRU1nVzFQNXZXZm9uRjNFcXhURnVVYlFQSmV1OUs3QmFlMjVRUGE0aW5fVnM?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5004ef0e3ecc23cd","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:09:29.993306+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxPQUptSUlOX0ZQN3ZMUVE0OTItYmZ6LVMxV0VtX3hzWElQNVB4QTNJeU82UE9qVml0VlN4SHdIeVRiYjFUbUNVTXJSejdkUzYtZjRBRXJhQTRLNWhYS3BtbWVNdHdIVm1TRU1nVzFQNXZXZm9uRjNFcXhURnVVYlFQSmV1OUs3QmFlMjVRUGE0aW5fVnM?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikwFBVV95cUxPQUptSUlOX0ZQN3ZMUVE0OTItYmZ6LVMxV0VtX3hzWElQNVB4QTNJeU82UE9qVml0VlN4SHdIeVRiYjFUbUNVTXJSejdkUzYtZjRBRXJhQTRLNWhYS3BtbWVNdHdIVm1TRU1nVzFQNXZXZm9uRjNFcXhURnVVYlFQSmV1OUs3QmFlMjVRUGE0aW5fVnM?oc=5","source_event_id":"evt_a929f2e15b6b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ea6537439e5dc1a2","published_at":"2026-04-08T09:02:00+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"The New York Times","relevance":"primary source","symbol":"","type":"publisher"},{"asset_class":"","name":"G.O.P.","relevance":"audience/target of warnings","symbol":"","type":"political_party"},{"asset_class":"","name":"Democrats","relevance":"party performing well in cited races","symbol":"","type":"political_party"},{"asset_class":"political_region","name":"Georgia","relevance":"state with narrow margins mentioned","symbol":"","type":"location"},{"asset_class":"political_region","name":"Wisconsin","relevance":"state where Democrats won a Supreme Court race","symbol":"","type":"location"}],"event_type":"other","information_gaps":["The cleaned article text appears to be mostly HTML/CSS and does not include the actual article content, so specific details (vote shares, margins, dates, and the exact three takeaways) are not verifiable from the provided text.","The signal provides only a headline and a multi-outlet source summary; it is unclear which specific races in Georgia are referenced and what the exact \u201cnarrow margins\u201d were.","No near-term catalyst timing (e.g., next election date or policy/market-relevant deadline) is specified in the provided content."],"key_facts":["The headline is from The New York Times and presents \u201c3 takeaways\u201d framed as warnings for the GOP from elections in Georgia and Wisconsin.","The provided source summary states Democrats won the Wisconsin Supreme Court race (\u201cDemocrats romp in Wisconsin Supreme Court race\u201d).","The provided source summary states Georgia results were close (\u201cnarrow margins in Georgia\u201d).","The provided source summary includes additional commentary that Democrats had \u201cone of their best election nights in recent memory,\u201d despite losing in Marjorie Taylor Greene\u2019s old district (as referenced in the summary)."],"numeric_claims":[],"primary_claim":"Recent election results in Georgia and Wisconsin provide \u201cwarnings\u201d to the GOP, with Democrats performing strongly in Wisconsin and seeing narrow margins in Georgia.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"The New York Times argues that recent elections in Georgia and Wisconsin contain warning signs for the GOP, highlighting Democratic performance in Wisconsin and mixed results in Georgia. The piece frames these outcomes as reasons Republicans may need to adjust strategy ahead of future contests.","topics":["US elections","state-level elections","Georgia election results","Wisconsin Supreme Court race","Republican strategy","Democratic performance"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Warnings for the G.O.P.: 3 Takeaways From the Elections in Georgia and Wisconsin The New York Times Democrats romp in Wisconsin Supreme Court race, narrow margins in Georgia CNBC \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 lost in Marjorie Taylor Greene\u2019s old district. They still had one of their best election nights in recent memory CNN","title":"Warnings for the G.O.P.: 3 Takeaways From the Elections in Georgia and Wisconsin - The New York Times","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 8327 in events