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/CBMilAFBVV95cUxPT053di1ocEhnM3ZKN2pDeXZMdE1tZ2M0WnRQZmd3TUtYY2NFdzRoZG9jZHF1ZmlHSktiSDVBLW1sX1RLUnl6SXBPZXpHOGM3Z0VTdzI5M0dZZWxfajNDT2IzS0RGWExpTy1ua0tiSEQ5cHFsSmQwSmRNMmdoeFRzWHQybi1PWVBuZDNoZ0VBWnBQUzRB?oc=5","as_of":"2026-04-07T23:39:52.353079+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/CBMilAFBVV95cUxPT053di1ocEhnM3ZKN2pDeXZMdE1tZ2M0WnRQZmd3TUtYY2NFdzRoZG9jZHF1ZmlHSktiSDVBLW1sX1RLUnl6SXBPZXpHOGM3Z0VTdzI5M0dZZWxfajNDT2IzS0RGWExpTy1ua0tiSEQ5cHFsSmQwSmRNMmdoeFRzWHQybi1PWVBuZDNoZ0VBWnBQUzRB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6dfb9e1d2bdc280b","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-08T00:39:00.717597+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilAFBVV95cUxPT053di1ocEhnM3ZKN2pDeXZMdE1tZ2M0WnRQZmd3TUtYY2NFdzRoZG9jZHF1ZmlHSktiSDVBLW1sX1RLUnl6SXBPZXpHOGM3Z0VTdzI5M0dZZWxfajNDT2IzS0RGWExpTy1ua0tiSEQ5cHFsSmQwSmRNMmdoeFRzWHQybi1PWVBuZDNoZ0VBWnBQUzRB?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/CBMilAFBVV95cUxPT053di1ocEhnM3ZKN2pDeXZMdE1tZ2M0WnRQZmd3TUtYY2NFdzRoZG9jZHF1ZmlHSktiSDVBLW1sX1RLUnl6SXBPZXpHOGM3Z0VTdzI5M0dZZWxfajNDT2IzS0RGWExpTy1ua0tiSEQ5cHFsSmQwSmRNMmdoeFRzWHQybi1PWVBuZDNoZ0VBWnBQUzRB?oc=5","source_event_id":"evt_bff6be5a4d78","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"665a60829db616d6","published_at":"2026-04-07T17:22:38+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["2026","Tuesday"],"entities":[{"asset_class":"government","name":"Wisconsin Supreme Court","relevance":"high","symbol":"","type":"government_body"},{"asset_class":"government","name":"Wisconsin","relevance":"high","symbol":"","type":"jurisdiction"},{"asset_class":"government","name":"Milwaukee races","relevance":"medium","symbol":"","type":"election_races"},{"asset_class":"media","name":"New York Times","relevance":"high","symbol":"NYT","type":"publisher"},{"asset_class":"political","name":"Liberals","relevance":"medium","symbol":"","type":"political_group"},{"asset_class":"media","name":"CNN","relevance":"low","symbol":"CNN","type":"publisher"},{"asset_class":"media","name":"Milwaukee Journal Sentinel","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"media","name":"WPR","relevance":"low","symbol":"WPR","type":"publisher"}],"event_type":"other","information_gaps":["No specific vote totals, candidate names, or seat counts are provided in the supplied text.","The exact date of the \u201cTuesday election\u201d is not specified.","The \u201cWithout Elon Musk\u201d claim is mentioned but not substantiated with details in the provided content.","No direct market/asset impact is stated; any directional impact is limited to political-control framing."],"key_facts":["The signal references a New York Times page titled \u201cWisconsin Supreme Court 2026: Live Election Results.\u201d","The referenced coverage includes \u201cSupreme Court\u201d and \u201cMilwaukee races.\u201d","The provided source summary states that \u201cLiberals will try to expand their majority on the Wisconsin Supreme Court in a Tuesday election.\u201d","The source summary also mentions that \u201cWithout Elon Musk, Wisconsin\u2019s Supreme Court Race Goes Quiet,\u201d but no further concrete details are included in the provided text."],"numeric_claims":[],"primary_claim":"The New York Times is providing live election results for the 2026 Wisconsin Supreme Court election (and related Milwaukee races) on a Tuesday election day.","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"The New York Times is running live election coverage for the 2026 Wisconsin Supreme Court election, including Milwaukee races. The coverage frames the contest as an effort by liberals to expand their majority on the Wisconsin Supreme Court in a Tuesday election.","topics":["2026 election","Wisconsin Supreme Court","live election results","partisan control","Milwaukee races"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Wisconsin Supreme Court 2026: Live Election Results The New York Times Wisconsin 2026 election live updates; Supreme Court, Milwaukee races Milwaukee Journal Sentinel Voter Guide WPR Without Elon Musk, Wisconsin\u2019s Supreme Court Race Goes Quiet The New York Times Liberals will try to expand their majority on the Wisconsin Supreme Court in a Tuesday election CNN","title":"Wisconsin Supreme Court 2026: Live Election Results - 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_c26417981a2b in signals