SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxQTEE4dDh5N3hUZUdsY3V4MHdBc09DSjdQVnVoRWxwMVFoaHJOY0JFOUtnQlhnaTJjNXkyN1Z1U2ZhV0Q2dUYzVW1zWGlOdHRjdWIxQ2s0TGd3ajB0ZmlvbWc2WHVxQzhaU1ZyMWZjblFDYUF1V1FtdW82OGVWb2lZTU05S2xDQXltaGYxQXhNazJqRXJxNUZYRGZHYUhxRm1rbExhd1ZrLWFZVVJYQkE?oc=5","as_of":"2026-04-08T20:43:09.117251+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/CBMirgFBVV95cUxQTEE4dDh5N3hUZUdsY3V4MHdBc09DSjdQVnVoRWxwMVFoaHJOY0JFOUtnQlhnaTJjNXkyN1Z1U2ZhV0Q2dUYzVW1zWGlOdHRjdWIxQ2s0TGd3ajB0ZmlvbWc2WHVxQzhaU1ZyMWZjblFDYUF1V1FtdW82OGVWb2lZTU05S2xDQXltaGYxQXhNazJqRXJxNUZYRGZHYUhxRm1rbExhd1ZrLWFZVVJYQkE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c9a0d06fc57c9723","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:12:19.990753+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxQTEE4dDh5N3hUZUdsY3V4MHdBc09DSjdQVnVoRWxwMVFoaHJOY0JFOUtnQlhnaTJjNXkyN1Z1U2ZhV0Q2dUYzVW1zWGlOdHRjdWIxQ2s0TGd3ajB0ZmlvbWc2WHVxQzhaU1ZyMWZjblFDYUF1V1FtdW82OGVWb2lZTU05S2xDQXltaGYxQXhNazJqRXJxNUZYRGZHYUhxRm1rbExhd1ZrLWFZVVJYQkE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxQTEE4dDh5N3hUZUdsY3V4MHdBc09DSjdQVnVoRWxwMVFoaHJOY0JFOUtnQlhnaTJjNXkyN1Z1U2ZhV0Q2dUYzVW1zWGlOdHRjdWIxQ2s0TGd3ajB0ZmlvbWc2WHVxQzhaU1ZyMWZjblFDYUF1V1FtdW82OGVWb2lZTU05S2xDQXltaGYxQXhNazJqRXJxNUZYRGZHYUhxRm1rbExhd1ZrLWFZVVJYQkE?oc=5","source_event_id":"evt_1ca1b681ec5a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c2ae650c26c0eab2","published_at":"2026-04-08T16:28:29+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"political_party","name":"Democrats","relevance":"high","symbol":"","type":"political_party"},{"asset_class":"political_party","name":"Republicans","relevance":"medium","symbol":"","type":"political_party"},{"asset_class":"politician","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"media","name":"NPR","relevance":"high","symbol":"","type":"media_outlet"},{"asset_class":"state","name":"Georgia","relevance":"medium","symbol":"","type":"location"},{"asset_class":"state","name":"Wisconsin","relevance":"medium","symbol":"","type":"location"}],"event_type":"other","information_gaps":["The cleaned article text appears to be mostly HTML/CSS and does not contain the substantive content needed to verify specific vote margins, dates, or the exact election cycles referenced.","The signal provides only a headline and a multi-outlet source summary; it does not specify which exact elections (off-year vs. special vs. primary) are being compared.","No quantitative metrics (seat changes, vote share, polling numbers) are included in the provided text, so the magnitude of the \u201cdoing better\u201d claim is not measurable here."],"key_facts":["NPR headline states Democrats have been doing better in elections since Trump returned to office.","The provided source summary references election results in Georgia and Wisconsin showing Democrats performing strongly (e.g., Wisconsin Supreme Court race and Georgia margins).","The provided source summary also indicates Republicans may be facing increased concern based on latest election results."],"numeric_claims":[],"primary_claim":"Democrats have been doing better in elections since Trump returned to office, according to NPR.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"NPR reports that Democrats have been performing better in elections since Donald Trump returned to office, citing recent state-level results. The headline implies a near-term political tailwind for Democrats and a potential setback for Republican candidates.","topics":["US elections","partisan performance","state elections","Georgia","Wisconsin","political polling/sentiment"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"Democrats keep doing better in elections since Trump returned to office NPR Georgia, Wisconsin Elections Show Declining Appetite for Republican Candidates 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":"Democrats keep doing better in elections since Trump returned to office - NPR","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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_e0f0022b7ea0 in signals