election_results
Data license: CC BY 4.0 · Data source: MyTown
75,388 rows
This data as json, CSV (advanced)
Suggested facets: state, term_years, match_method, election_date (date)
| Link | rowid ▼ | id | muni_id | place_name | state | county | office | election_date | candidate_name | party | votes | total_votes_in_race | is_winner | term_years | source | source_url | created_at | election_type | match_method |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2 | 73 | Alameda | California | Alameda | City Council | 2020-11-03 | Malia Vella | 16022 | 70796 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 2 | 2 | 3 | 73 | Alameda | California | Alameda | City Council | 2020-11-03 | Trish Spencer | 14253 | 70796 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 3 | 3 | 4 | 73 | Alameda | California | Alameda | City Council | 2020-11-03 | Amos J. White | 14187 | 70796 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 4 | 4 | 5 | 73 | Alameda | California | Alameda | City Council | 2020-11-03 | Jim Oddie | 13161 | 70796 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 5 | 5 | 6 | 73 | Alameda | California | Alameda | City Council | 2020-11-03 | Gig Codiga | 12942 | 70796 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 6 | 6 | 7 | 3798 | Albany | California | Alameda | City Council | 2020-11-03 | Preston Jordan | 6254 | 22081 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 7 | 7 | 8 | 3798 | Albany | California | Alameda | City Council | 2020-11-03 | Gary Ge'nell | 5400 | 22081 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 8 | 8 | 9 | 3798 | Albany | California | Alameda | City Council | 2020-11-03 | Aaron Tiedemann | 5393 | 22081 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 9 | 9 | 10 | 3798 | Albany | California | Alameda | City Council | 2020-11-03 | Tod Abbott | 4906 | 22081 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 10 | 10 | 11 | 2429 | Berkeley | California | Alameda | City Council District 2 | 2020-11-03 | Terry Taplin | 3213 | 8179 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 11 | 11 | 12 | 2429 | Berkeley | California | Alameda | City Council District 2 | 2020-11-03 | Cheryl Davila | 2413 | 8179 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 12 | 12 | 13 | 2429 | Berkeley | California | Alameda | City Council District 2 | 2020-11-03 | Alex Sharenko | 1962 | 8179 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 13 | 13 | 14 | 2429 | Berkeley | California | Alameda | City Council District 2 | 2020-11-03 | Timothy W. Carter | 553 | 8179 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 14 | 14 | 15 | 2429 | Berkeley | California | Alameda | City Council District 2 | 2020-11-03 | Ben Bartlett | 5328 | 7694 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 15 | 15 | 16 | 2429 | Berkeley | California | Alameda | City Council District 2 | 2020-11-03 | Deborah Matthews | 1834 | 7694 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 16 | 16 | 17 | 2429 | Berkeley | California | Alameda | City Council District 2 | 2020-11-03 | Orlando Martinez | 494 | 7694 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 17 | 17 | 18 | 2429 | Berkeley | California | Alameda | City Council District 2 | 2020-11-03 | Sophie Hahn | 7666 | 10014 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 18 | 18 | 19 | 2429 | Berkeley | California | Alameda | City Council District 2 | 2020-11-03 | Todd Andrew | 1886 | 10014 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 19 | 19 | 20 | 2429 | Berkeley | California | Alameda | City Council District 2 | 2020-11-03 | Paul Darwin Picklesimer | 425 | 10014 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 20 | 20 | 21 | 2429 | Berkeley | California | Alameda | City Council District 2 | 2020-11-03 | Susan Wengraf | 5619 | 7766 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 21 | 21 | 22 | 2429 | Berkeley | California | Alameda | City Council District 2 | 2020-11-03 | Richard Illgen | 2112 | 7766 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 22 | 22 | 23 | 2429 | Berkeley | California | Alameda | Mayor | 2020-11-03 | Jesse Arreguín | 36515 | 58375 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 23 | 23 | 24 | 2429 | Berkeley | California | Alameda | Mayor | 2020-11-03 | Wayne Hsiung | 14064 | 58375 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 24 | 24 | 25 | 2429 | Berkeley | California | Alameda | Mayor | 2020-11-03 | Aidan Hill | 5922 | 58375 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 25 | 25 | 26 | 2429 | Berkeley | California | Alameda | Mayor | 2020-11-03 | Naomi D. Pete | 1384 | 58375 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 26 | 26 | 27 | 229 | Dublin | California | Alameda | City Council | 2020-11-03 | Sherry Hu | 12355 | 46912 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 27 | 27 | 28 | 229 | Dublin | California | Alameda | City Council | 2020-11-03 | Michael McCorriston | 7570 | 46912 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 28 | 28 | 29 | 229 | Dublin | California | Alameda | City Council | 2020-11-03 | Dawn Plants | 6032 | 46912 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 29 | 29 | 30 | 229 | Dublin | California | Alameda | City Council | 2020-11-03 | Sri Muppidi | 5836 | 46912 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 30 | 30 | 31 | 229 | Dublin | California | Alameda | City Council | 2020-11-03 | Samir Qureshi | 5078 | 46912 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 31 | 31 | 32 | 229 | Dublin | California | Alameda | City Council | 2020-11-03 | Kashef Qaadri | 3437 | 46912 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 32 | 32 | 33 | 229 | Dublin | California | Alameda | City Council | 2020-11-03 | Shawn Costello | 2545 | 46912 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 33 | 33 | 34 | 229 | Dublin | California | Alameda | City Council | 2020-11-03 | Razi Hasni | 2258 | 46912 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 34 | 34 | 35 | 229 | Dublin | California | Alameda | City Council | 2020-11-03 | Lucrecia Deleon | 1688 | 46912 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 35 | 35 | 36 | 229 | Dublin | California | Alameda | Mayor | 2020-11-03 | Melissa Hernandez | 13599 | 27280 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 36 | 36 | 37 | 229 | Dublin | California | Alameda | Mayor | 2020-11-03 | Arun Goel | 10864 | 27280 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 37 | 37 | 38 | 229 | Dublin | California | Alameda | Mayor | 2020-11-03 | Regina Pangelinan | 2736 | 27280 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 38 | 38 | 39 | 187 | Fremont | California | Alameda | City Council District 1 | 2020-11-03 | Teresa Keng | 11436 | 11600 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 39 | 39 | 40 | 187 | Fremont | California | Alameda | City Council District 1 | 2020-11-03 | Raj Salwan | 12540 | 15850 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 40 | 40 | 41 | 187 | Fremont | California | Alameda | City Council District 1 | 2020-11-03 | Dolev Gandler | 3259 | 15850 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 41 | 41 | 42 | 187 | Fremont | California | Alameda | City Council District 1 | 2020-11-03 | Teresa Cox | 4327 | 13704 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 42 | 42 | 43 | 187 | Fremont | California | Alameda | City Council District 1 | 2020-11-03 | Charles Liu | 3351 | 13704 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 43 | 43 | 44 | 187 | Fremont | California | Alameda | City Council District 1 | 2020-11-03 | Yogi Chugh | 3307 | 13704 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 44 | 44 | 45 | 187 | Fremont | California | Alameda | City Council District 1 | 2020-11-03 | Roman Reed | 1422 | 13704 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 45 | 45 | 46 | 187 | Fremont | California | Alameda | City Council District 1 | 2020-11-03 | Jhansi Kalapala | 696 | 13704 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 46 | 46 | 47 | 187 | Fremont | California | Alameda | City Council District 1 | 2020-11-03 | Andrew Quang Nguyen | 569 | 13704 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 47 | 47 | 48 | 187 | Fremont | California | Alameda | Mayor | 2020-11-03 | Lily Mei | 44038 | 88652 | 1 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 48 | 48 | 49 | 187 | Fremont | California | Alameda | Mayor | 2020-11-03 | Justin Sha | 22617 | 88652 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 49 | 49 | 50 | 187 | Fremont | California | Alameda | Mayor | 2020-11-03 | Chris Hampton | 7726 | 88652 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 | ||||
| 50 | 50 | 51 | 187 | Fremont | California | Alameda | Mayor | 2020-11-03 | Vik Bajwa Singh | 7023 | 88652 | 0 | ceda | https://elections.cdn.sos.ca.gov/county-city-school-district-election-results/2020/city.pdf | 2026-07-20 00:43:04.665915+00 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "election_results" ("id", "muni_id", "place_name", "state", "county", "office", "election_date", "candidate_name", "party", "votes", "total_votes_in_race", "is_winner", "term_years", "source", "source_url", "created_at", "election_type", "match_method");