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/CBMinAFBVV95cUxQSVJnaGpMeE00UW9mcDBjT0dUaDBKLVRZbm55NkdVZk9XeFJFVEJ0eXJVVjQydlM3SVFQQTR2R2owRDJmaGxzUi1RcTdKRE1rTk5TVWFvRmpkUlEyaUZ4cWJ5QzVEMm1lRXpsWEZpdWZLM2tlaFVnX2J4OVVDeURGbEt2WXJHdGRLcnhHZGRYblRUTW80eU9VbzJRcEY?oc=5","as_of":"2026-04-08T07:36:47.267036+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/CBMinAFBVV95cUxQSVJnaGpMeE00UW9mcDBjT0dUaDBKLVRZbm55NkdVZk9XeFJFVEJ0eXJVVjQydlM3SVFQQTR2R2owRDJmaGxzUi1RcTdKRE1rTk5TVWFvRmpkUlEyaUZ4cWJ5QzVEMm1lRXpsWEZpdWZLM2tlaFVnX2J4OVVDeURGbEt2WXJHdGRLcnhHZGRYblRUTW80eU9VbzJRcEY?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f6be4685a55ccb7e","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-08T07:37:27.996730+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxQSVJnaGpMeE00UW9mcDBjT0dUaDBKLVRZbm55NkdVZk9XeFJFVEJ0eXJVVjQydlM3SVFQQTR2R2owRDJmaGxzUi1RcTdKRE1rTk5TVWFvRmpkUlEyaUZ4cWJ5QzVEMm1lRXpsWEZpdWZLM2tlaFVnX2J4OVVDeURGbEt2WXJHdGRLcnhHZGRYblRUTW80eU9VbzJRcEY?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxQSVJnaGpMeE00UW9mcDBjT0dUaDBKLVRZbm55NkdVZk9XeFJFVEJ0eXJVVjQydlM3SVFQQTR2R2owRDJmaGxzUi1RcTdKRE1rTk5TVWFvRmpkUlEyaUZ4cWJ5QzVEMm1lRXpsWEZpdWZLM2tlaFVnX2J4OVVDeURGbEt2WXJHdGRLcnhHZGRYblRUTW80eU9VbzJRcEY?oc=5","source_event_id":"evt_af7b084d1f9d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"38e64d345cbedf0f","published_at":"2026-04-08T01:39:11+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"Chris Taylor","relevance":"high","symbol":"","type":"person"},{"asset_class":"political_institution","name":"Wisconsin Supreme Court","relevance":"high","symbol":"","type":"institution"},{"asset_class":"jurisdiction","name":"Wisconsin","relevance":"high","symbol":"","type":"location"},{"asset_class":"","name":"Maria Lazar","relevance":"medium","symbol":"","type":"person"}],"event_type":"other","information_gaps":["The provided article text is not actually present (only page styling/HTML), so vote totals, margin, and timing (election date/when results were finalized) are not verifiable from the supplied content.","The specific \u201ccruises to victory\u201d margin is not included in the provided text.","Whether the seat changes party control or the court\u2019s ideological balance is not explicitly stated in the supplied content (only implied by \u201ctilts Democrats\u2019 way\u201d).","No details are provided on the term length, whether it was an open seat, or incumbency status."],"key_facts":["Politico headline states a liberal judge (Chris Taylor) won the Wisconsin Supreme Court race.","Source summary indicates Chris Taylor won the race for Wisconsin Supreme Court.","Source summary also references an opponent matchup: Chris Taylor vs. Maria Lazar (implied by \u201cChris Taylor, Maria Lazar meet in Wisconsin Supreme Court election\u201d)."],"numeric_claims":[],"primary_claim":"Chris Taylor won the Wisconsin Supreme Court race, cruising to victory as a liberal judge.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"Politico reports that Chris Taylor, described as a liberal judge, won the Wisconsin Supreme Court race, indicating a Democratic-leaning outcome in the state\u2019s high court election.","topics":["elections","judicial elections","Wisconsin politics","Democrats","liberal judge"]},"source":"politico.com","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Liberal judge cruises to victory in Wisconsin Supreme Court race politico.com Chris Taylor, a Liberal Judge, Wins Race for Wisconsin Supreme Court The New York Times Wisconsin Supreme Court Election 2026 Live Results NBC News A subdued Wisconsin Supreme Court race tilts Democrats\u2019 way politico.com Chris Taylor, Maria Lazar meet in Wisconsin Supreme Court election Milwaukee Journal Sentinel","title":"Liberal judge cruises to victory in Wisconsin Supreme Court race - politico.com","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_c7d2bf2cd1d3 in signals