Data

The full database underlying every figure on this site, in two formats. No signup, no rate limit, no abridged view.

Snapshot generated 2026-05-05T16:02:28.106Z · source docs/LEH-{2021..2025}-results-HoC*.xlsx · 5 election cycles, 15,496 races, 22,608 elected seats across 847 council×cycle pairs.

Downloads

results.sqlite — full database for all cycles (open in DBeaver, sqlite3, DuckDB CLI, Python, R, or any SQLite-compatible tool)
cycles.csv — one row per election cycle
councils.csv — one row per (year, council) pair
races.csv — one row per ward race
candidates.csv — one row per candidacy

Schema

All tables are keyed by year as the leading column; everything else joins on (year, council_slug) and (year, council_slug, ward_slug).

`cycles`

`year`	Election year (primary key)
`election_date`	ISO date the polls were held
`council_count, race_count, seat_count`	Volumetrics for the cycle
`below_quota_seat_count, below_quota_share`	Seats whose marginal candidate share fell below the proportional quota

`councils`

`year, council_slug`	Composite primary key
`council`	Display name (Lower-tier authority)
`authority_type`	UC / MD / LB / SD / etc.
`race_count`	Ward races in this council in this cycle
`total_seats, below_quota_seats, below_quota_share`	Per-(year, council) aggregates

`races`

`year, council_slug, ward_slug`	Composite primary key
`ec_code`	Electoral Commission ward code where the source provides one (null for 2023)
`ward_name, council`	Display labels
`seats`	Seats contested in this ward
`electorate, ballots, invalid_votes`	Source figures (some null in earlier years)
`valid_ballots`	Sum of candidate votes — the LEH "Valid vote turnout (HoC method)" denominator
`winning_pct`	Marginal-elected-candidate share of valid ballots
`quota`	Proportional quota: `1.0 / (seats + 1)`
`under_par`	`quota − winning_pct` (positive = below par)
`is_below_quota`	`1` when `winning_pct < quota`

`candidates`

`year, council_slug, ward_slug`	Joins `races`
`candidate_name, party`	Public election record (party normalised to canonical full name)
`votes`	Votes cast for this candidate
`elected`	`1` if elected — recomputed as top-N-by-votes (see methodology)
`elected_source`	The LEH source `Elected` flag, before our correction; differs on a small number of candidacies where the workbook is internally inconsistent
`rank`	1 = highest-vote candidate in the ward

Licensing

Source data is published by the House of Commons Library under the Open Parliament Licence. Our derived columns (winning_pct, quota, under_par, the below_quota_* aggregates) are released under CC BY-SA 4.0. Attribution: "electionresults.uk".