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/CBMiigFBVV95cUxNRjVaQS1VVFZYejV3X3lmcmlXRWk1djg4dS1PWDVsZUhkUFo3NFViMTUtajZQLWFyMnlJdFV0aVZGMElUUkZneEhTTHZTbzJxQ25zR0Rmbl81MGhqWjRxcGxOYWRNZEpWLTJJZ0c5VWJOVmNmLWtmaXBUd0M5dnAyYkdKUkt0V09qdWc?oc=5","as_of":"2026-04-08T03:15:56.471280+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/CBMiigFBVV95cUxNRjVaQS1VVFZYejV3X3lmcmlXRWk1djg4dS1PWDVsZUhkUFo3NFViMTUtajZQLWFyMnlJdFV0aVZGMElUUkZneEhTTHZTbzJxQ25zR0Rmbl81MGhqWjRxcGxOYWRNZEpWLTJJZ0c5VWJOVmNmLWtmaXBUd0M5dnAyYkdKUkt0V09qdWc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c91f3d53f4b7ebca","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-08T03:47:55.798892+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiigFBVV95cUxNRjVaQS1VVFZYejV3X3lmcmlXRWk1djg4dS1PWDVsZUhkUFo3NFViMTUtajZQLWFyMnlJdFV0aVZGMElUUkZneEhTTHZTbzJxQ25zR0Rmbl81MGhqWjRxcGxOYWRNZEpWLTJJZ0c5VWJOVmNmLWtmaXBUd0M5dnAyYkdKUkt0V09qdWc?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/CBMiigFBVV95cUxNRjVaQS1VVFZYejV3X3lmcmlXRWk1djg4dS1PWDVsZUhkUFo3NFViMTUtajZQLWFyMnlJdFV0aVZGMElUUkZneEhTTHZTbzJxQ25zR0Rmbl81MGhqWjRxcGxOYWRNZEpWLTJJZ0c5VWJOVmNmLWtmaXBUd0M5dnAyYkdKUkt0V09qdWc?oc=5","source_event_id":"evt_4dc7e964ea7f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0d498466e2ca7e60","published_at":"2026-04-08T01:37:39+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["2026"],"entities":[{"asset_class":"equity","name":"Chris Taylor","relevance":"high","symbol":"","type":"person"},{"asset_class":"equity","name":"Lazar","relevance":"medium","symbol":"","type":"person"},{"asset_class":"other","name":"Wisconsin Supreme Court","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"The New York Times","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"CNN","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"WLUK","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"other","name":"FOX6 News Milwaukee","relevance":"low","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["The provided article text is not actually present (only CSS/HTML styling), so detailed supporting statements (e.g., vote totals, timing of projection, or final certification) are not verifiable from the supplied content.","The exact name of the conservative opponent is only given as \u201cLazar\u201d in the source summary; full name is not provided.","The specific mechanism of \u201cexpanding\u201d the liberal majority (e.g., seat count change) is not quantified in the provided text."],"key_facts":["The headline states that Chris Taylor, described as a Liberal Judge, wins the Wisconsin Supreme Court race.","Source summary indicates CNN projected Taylor\u2019s win.","The source summary indicates the win would expand the Wisconsin Supreme Court\u2019s liberal majority.","The source summary indicates voters chose between conservative Lazar and liberal Taylor.","The election is referenced as Wisconsin Supreme Court 2026 with live election results."],"numeric_claims":[],"primary_claim":"Chris Taylor is projected to win the Wisconsin Supreme Court race, increasing the court\u2019s liberal majority.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"Chris Taylor, described as a liberal judge, is projected to win the Wisconsin Supreme Court race, defeating conservative opponent Lazar, which would expand/maintain the court\u2019s liberal majority. The result is being reported as a near-term election outcome (2026 Wisconsin Supreme Court election).","topics":["US state supreme court election","Wisconsin politics","judicial ideology","court composition"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Chris Taylor, a Liberal Judge, Wins Race for Wisconsin Supreme Court The New York Times Wisconsin Supreme Court 2026: Live Election Results The New York Times Judge Chris Taylor will win Wisconsin Supreme Court race, CNN projects, expanding court\u2019s liberal majority CNN Voters to choose between conservative Lazar and liberal Taylor for Wisconsin Supreme Court WLUK Wisconsin Supreme Court race: Judge Chris Taylor optimistic FOX6 News Milwaukee","title":"Chris Taylor, a Liberal Judge, Wins Race for Wisconsin Supreme Court - 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

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_89b65a2aac20 in signals