Making AI trustworthy enough for elections: entity resolution, human review, and an eval with no labels

Learn how to build trustworthy AI for elections using entity resolution, human review, and a novel evaluation method that measures real-world error rates.

PostgreSQL Claude Code pg_trgm Astro Cloudflare

Overview

Election information is a trust problem before it’s a data problem: people don’t know what to believe, and the underlying public records are fragmented across voter files, campaign finance filings, and endorsement lists with no shared IDs and four spellings of the same name.

Torrance Watch is my answer for my own city: a nonpartisan civic site I built solo for the June election, every claim footnoted to a public source, no editorializing. It reached about 17,000 unique visitors in the month around the election, in a city of 145,000, so real people made real voting decisions partly on this data. That’s why the AI layer had to be governed, not just good. Underneath is an entity-resolution pipeline: a deterministic matcher produced 8,136 confident matches and auto-matched 97.1% of contributions, with an LLM handling only residual ambiguity through a human-approved suggestion queue.

Live: the falsification sweep that measures the matcher’s error rate without ground-truth labels, the queue with real approved and rejected rows, and the fix the eval forced.

Links

https://torrancewatch.org/
This website provides real-time, unofficial Torrance 2026 election results, dynamically updating from Los Angeles County data.
https://github.com/dubbl-a
This GitHub profile showcases AI-driven resume generation and web redirection projects.

Tech stack

PostgreSQL

PostgreSQL (Postgres): The world's most advanced, open-source object-relational database (ORDBMS), built for reliability and extensibility.

PostgreSQL is the premier open-source ORDBMS, proven over 35+ years of active development. It adheres strictly to ACID properties (Atomicity, Consistency, Isolation, Durability), ensuring data integrity for mission-critical workloads. Key features include robust SQL compliance, Multi-Version Concurrency Control (MVCC), and superior extensibility (e.g., custom data types, functions in multiple languages). Advanced capabilities like native JSON/JSONB support and the PostGIS extension (geospatial data) make it a powerful, flexible choice for complex enterprise applications.

https://www.postgresql.org/

View projects
Claude Code

Anthropic's agentic coding tool: Unleash Claude's raw power directly in your terminal or IDE to turn complex, hours-long workflows into a single command.

Claude Code is Anthropic’s powerful agentic coding assistant, designed for high-velocity development. It operates natively within your terminal, IDE (VS Code, JetBrains), or via a web interface, allowing you to delegate complex tasks like feature building, bug fixing, and codebase navigation. The agent plans, edits files, executes commands, and creates commits, maintaining awareness of your entire project structure. Internally, Anthropic engineers using Claude Code reported a 67% increase in productivity, demonstrating its capacity to deliver significant gains for Pro and Max plan users.

https://claude.com/code

View projects
pg_trgm

pg_trgm: boosts PostgreSQL's similarity matching and fuzzy searching with trigram-based indexing.

pg_trgm is a PostgreSQL extension that enables efficient similarity measurements and fuzzy string matching. It works by breaking strings into trigrams (sequences of three characters), then calculating the similarity between strings based on their shared trigrams. This method significantly improves the performance of `LIKE`, `ILIKE`, and regular expression queries, especially on large text datasets. For example, using `pg_trgm` with a GIN or GiST index can accelerate searches for misspelled words or partial matches, making it invaluable for applications requiring robust text search capabilities beyond exact matches.

https://www.postgresql.org/docs/current/pgtrgm.html

View projects
Astro

Astro is a web framework engineered for content-driven websites, utilizing a unique islands architecture to deliver zero-client-side JavaScript by default.

Astro optimizes performance by shifting the heavy lifting to the server. Its core feature, Astro Islands, allows developers to build interactive UI components using React, Vue, or Svelte while only shipping the necessary JavaScript to the browser. This approach results in faster Time to Interactive (TTI) and superior SEO outcomes for sites like The Guardian and Nordstrom. Version 4.0 introduced the Dev Toolbar and enhanced View Transitions, further streamlining the developer experience for high-traffic documentation and marketing platforms.

https://astro.build

View projects
Cloudflare

Cloudflare is the global cloud platform that secures, accelerates, and optimizes every internet connection: your network, applications, and teams.

Cloudflare is an essential internet infrastructure and security provider. We operate one of the world's largest networks, proxying approximately 20% of the web and handling an average of 45 million HTTP requests per second. Our platform delivers integrated security (DDoS mitigation, WAF, Zero Trust) and performance (CDN, edge computing via Workers) from 330+ cities worldwide. This architecture ensures millions of internet properties—from small blogs to Fortune 1000 companies—remain fast, reliable, and protected against sophisticated attacks.

https://www.cloudflare.com

View projects

Making AI trustworthy enough for elections: entity resolution, human review, and an eval with no labels

Related talks