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/CBMiowFBVV95cUxPVjVTd3JPRmhXN21DNXZjR2JlU0o2Vk1NeVdrbERLUTlBRldjY290SnRNUVpwVjNZamdjcEExWFFrWW9oUTduU0psNF8yQjFFQy1NSVBUNGp3ajNNR0dYaUgzZzNhVC16OFc1clZIZ0Y4LWpUdUlVTTVweW9pTENfellhdkVTZDV3TnlmUmMwdWFmMmJRQmFzd1E4OXFRd01HODg4?oc=5","as_of":"2026-04-08T00:41:56.215119+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxPVjVTd3JPRmhXN21DNXZjR2JlU0o2Vk1NeVdrbERLUTlBRldjY290SnRNUVpwVjNZamdjcEExWFFrWW9oUTduU0psNF8yQjFFQy1NSVBUNGp3ajNNR0dYaUgzZzNhVC16OFc1clZIZ0Y4LWpUdUlVTTVweW9pTENfellhdkVTZDV3TnlmUmMwdWFmMmJRQmFzd1E4OXFRd01HODg4?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4c9d9fa080fa747c","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:43:40.700266+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxPVjVTd3JPRmhXN21DNXZjR2JlU0o2Vk1NeVdrbERLUTlBRldjY290SnRNUVpwVjNZamdjcEExWFFrWW9oUTduU0psNF8yQjFFQy1NSVBUNGp3ajNNR0dYaUgzZzNhVC16OFc1clZIZ0Y4LWpUdUlVTTVweW9pTENfellhdkVTZDV3TnlmUmMwdWFmMmJRQmFzd1E4OXFRd01HODg4?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiowFBVV95cUxPVjVTd3JPRmhXN21DNXZjR2JlU0o2Vk1NeVdrbERLUTlBRldjY290SnRNUVpwVjNZamdjcEExWFFrWW9oUTduU0psNF8yQjFFQy1NSVBUNGp3ajNNR0dYaUgzZzNhVC16OFc1clZIZ0Y4LWpUdUlVTTVweW9pTENfellhdkVTZDV3TnlmUmMwdWFmMmJRQmFzd1E4OXFRd01HODg4?oc=5","source_event_id":"evt_83b1d44f056b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"14ff725d86f2fd60","published_at":"2026-04-08T00:06:59+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["2026","Election Day in Wisconsin (date not specified in provided text)"],"entities":[{"asset_class":"other","name":"Wisconsin Supreme Court","relevance":"high","symbol":"","type":"government_judiciary"},{"asset_class":"other","name":"Wisconsin","relevance":"high","symbol":"","type":"location"},{"asset_class":"other","name":"The Washington Post","relevance":"high","symbol":"","type":"media_outlet"}],"event_type":"other","information_gaps":["Actual election results (winners/losers) are not present in the provided article text.","Candidate names, party affiliations, vote shares, and margins are not included.","The specific timing/catalyst window beyond \u201clive updates\u201d is not specified in the provided text.","No market/sector impact is described; any directional impact on markets would be speculative."],"key_facts":["The headline indicates live updates for Wisconsin Supreme Court election results in 2026.","The source summary references additional election-related coverage (e.g., polling and voter guide items) from other outlets.","The cleaned article text provided contains only page styling/HTML/CSS and does not include election results, vote totals, or candidate information."],"numeric_claims":[],"primary_claim":"The Washington Post is publishing live updates for the 2026 Wisconsin Supreme Court election results on election day in Wisconsin.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"The Washington Post is running live updates for the 2026 Wisconsin Supreme Court election results. The provided text does not include the actual vote outcomes or candidate names, only the existence of election-day coverage and related polling context.","topics":["elections","judiciary","Wisconsin","live results","polling context"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"Wisconsin Supreme Court election results 2026: Live updates The Washington Post Wisconsin Supreme Court Election 2026 Live Results NBC News Polls in Wisconsin Reflect a More Muted Supreme Court Race The New York Times Voter Guide WPR It's Election Day in Wisconsin; time, voting, polling places, ballot Milwaukee Journal Sentinel","title":"Wisconsin Supreme Court election results 2026: Live updates - The Washington Post","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_9144b32c27cf in signals