OpenElections
@openelections.bsky.social
We make official precinct-level election results into data. You can help.
https://github.com/openelections/
openelections@gmail.com
https://github.com/openelections/
openelections@gmail.com
September 22, 2025 at 1:33 AM
Official 2024 general election results from Ward County, Texas.
June 7, 2025 at 1:23 AM
Official 2024 general election results from Ward County, Texas.
We have questions about the scanner/copier in the Ward County, Texas, clerk's office:
June 3, 2025 at 4:42 PM
We have questions about the scanner/copier in the Ward County, Texas, clerk's office:
Actual 2024 official election results posted on the website of Dickens County, Texas:
May 28, 2025 at 1:30 AM
Actual 2024 official election results posted on the website of Dickens County, Texas:
Gemini got close, but this is a tough one:
May 28, 2025 at 12:24 AM
Gemini got close, but this is a tough one:
Borden County, Texas, has a population of ~720 according to the Census Bureau. About two-thirds are registered to vote.
Turnout in 2024 was 16.4 percent.
In one precinct it was 7 percent.
Turnout in 2024 was 16.4 percent.
In one precinct it was 7 percent.
May 27, 2025 at 11:09 PM
Borden County, Texas, has a population of ~720 according to the Census Bureau. About two-thirds are registered to vote.
Turnout in 2024 was 16.4 percent.
In one precinct it was 7 percent.
Turnout in 2024 was 16.4 percent.
In one precinct it was 7 percent.
Never change, Collingsworth County, Texas:
(They probably never will)
(They probably never will)
May 27, 2025 at 9:40 PM
Never change, Collingsworth County, Texas:
(They probably never will)
(They probably never will)
Sure, you've see official results, but have you seen "official reults"?
January 22, 2025 at 2:13 AM
Sure, you've see official results, but have you seen "official reults"?
We'd much rather have an electronic file of precinct results, but rarely is that file a Word doc. Here's Crawford County, Michigan:
www.crawfordco.org/wp-content/u...
www.crawfordco.org/wp-content/u...
December 31, 2024 at 1:57 AM
We'd much rather have an electronic file of precinct results, but rarely is that file a Word doc. Here's Crawford County, Michigan:
www.crawfordco.org/wp-content/u...
www.crawfordco.org/wp-content/u...
We've finished converting official precinct-level election results for 66 of Michigan's 83 counties.
github.com/openelection...
Some of the remaining ones are image PDFs like Gogebic County, which we need to OCR in order to turn into a CSV.
github.com/openelection...
Some of the remaining ones are image PDFs like Gogebic County, which we need to OCR in order to turn into a CSV.
December 31, 2024 at 1:51 AM
We've finished converting official precinct-level election results for 66 of Michigan's 83 counties.
github.com/openelection...
Some of the remaining ones are image PDFs like Gogebic County, which we need to OCR in order to turn into a CSV.
github.com/openelection...
Some of the remaining ones are image PDFs like Gogebic County, which we need to OCR in order to turn into a CSV.
A lot of Michigan precinct results files look like this PDF, which frankly is not great.
But we can make spreadsheets of this file so all you need to do is copy and paste into our format. Grab a county from here and we'll send you the spreadsheet:
github.com/openelection...
But we can make spreadsheets of this file so all you need to do is copy and paste into our format. Grab a county from here and we'll send you the spreadsheet:
github.com/openelection...
December 26, 2024 at 3:58 PM
A lot of Michigan precinct results files look like this PDF, which frankly is not great.
But we can make spreadsheets of this file so all you need to do is copy and paste into our format. Grab a county from here and we'll send you the spreadsheet:
github.com/openelection...
But we can make spreadsheets of this file so all you need to do is copy and paste into our format. Grab a county from here and we'll send you the spreadsheet:
github.com/openelection...
Selected recipients of write-in votes for President from York County, PA.
December 24, 2024 at 1:06 AM
Selected recipients of write-in votes for President from York County, PA.
We're on the lookout for Webster County, Mississippi's Nov. 5 precinct-level election results, which haven't been posted on the Secretary of State's website.
Closest we've found are these images posted on the Facebook page of the county circuit clerk:
www.facebook.com/photo?fbid=1...
Closest we've found are these images posted on the Facebook page of the county circuit clerk:
www.facebook.com/photo?fbid=1...
December 23, 2024 at 9:07 PM
We're on the lookout for Webster County, Mississippi's Nov. 5 precinct-level election results, which haven't been posted on the Secretary of State's website.
Closest we've found are these images posted on the Facebook page of the county circuit clerk:
www.facebook.com/photo?fbid=1...
Closest we've found are these images posted on the Facebook page of the county circuit clerk:
www.facebook.com/photo?fbid=1...
A few other small edits for OpenElections style and we're basically done. That's a 500-page PDF parsed in a pretty low-tech way in less than 30 minutes.
Want to learn more or pitch in? DMs are open, or email us at openelections AT gmail.
7/7
Want to learn more or pitch in? DMs are open, or email us at openelections AT gmail.
7/7
December 22, 2024 at 10:45 PM
A few other small edits for OpenElections style and we're basically done. That's a 500-page PDF parsed in a pretty low-tech way in less than 30 minutes.
Want to learn more or pitch in? DMs are open, or email us at openelections AT gmail.
7/7
Want to learn more or pitch in? DMs are open, or email us at openelections AT gmail.
7/7
To ensure we keep the values, we can copy them and use Paste Special -> Values to remove any formulas. Rinse and repeat the process for the office column, remove rows with no votes and now you have the data:
6/X
6/X
December 22, 2024 at 10:40 PM
To ensure we keep the values, we can copy them and use Paste Special -> Values to remove any formulas. Rinse and repeat the process for the office column, remove rows with no votes and now you have the data:
6/X
6/X
You'll notice the blank cells in the precinct column. Excel has a neat feature that allows you to fill down based on the previous value. Highlight the entire column, then choose
Edit -> Find -> Go To -> Special -> Blanks
And fill in the formula in the first blank cell. Before and after:
5/X
Edit -> Find -> Go To -> Special -> Blanks
And fill in the formula in the first blank cell. Before and after:
5/X
December 22, 2024 at 10:36 PM
You'll notice the blank cells in the precinct column. Excel has a neat feature that allows you to fill down based on the previous value. Highlight the entire column, then choose
Edit -> Find -> Go To -> Special -> Blanks
And fill in the formula in the first blank cell. Before and after:
5/X
Edit -> Find -> Go To -> Special -> Blanks
And fill in the formula in the first blank cell. Before and after:
5/X
Now we definitely could write a program to parse this into the correct format, but you also can do this in a spreadsheet. The key is to add a column with a sequential row ID so that you can preserve the original order. Then we can move different info into the correct columns:
4/X
4/X
December 22, 2024 at 10:31 PM
Now we definitely could write a program to parse this into the correct format, but you also can do this in a spreadsheet. The key is to add a column with a sequential row ID so that you can preserve the original order. Then we can move different info into the correct columns:
4/X
4/X
The next step is basically a whole bunch of find and replace commands, mostly removing the lines we don't need and replacing multiple spaces with tab characters.
That's important because then we can pull it into something that reads this as rows and columns.
3/X
That's important because then we can pull it into something that reads this as rows and columns.
3/X
December 22, 2024 at 10:28 PM
The next step is basically a whole bunch of find and replace commands, mostly removing the lines we don't need and replacing multiple spaces with tab characters.
That's important because then we can pull it into something that reads this as rows and columns.
3/X
That's important because then we can pull it into something that reads this as rows and columns.
3/X
The first thing we do is dump the text from the PDF while preserving the layout. For that we use xPDF from Foo Labs (www.xpdfreader.com). The result looks like this:
Sure we could write a program to clean this up, but a text editor will work, too. We like UltraEdit on the Mac.
2/X
Sure we could write a program to clean this up, but a text editor will work, too. We like UltraEdit on the Mac.
2/X
December 22, 2024 at 10:25 PM
The first thing we do is dump the text from the PDF while preserving the layout. For that we use xPDF from Foo Labs (www.xpdfreader.com). The result looks like this:
Sure we could write a program to clean this up, but a text editor will work, too. We like UltraEdit on the Mac.
2/X
Sure we could write a program to clean this up, but a text editor will work, too. We like UltraEdit on the Mac.
2/X
We've started converting official precinct election results from New Jersey, and wanted to give you a look at how we handle certain files.
For example, Gloucester County's results are in a 500-page PDF. Some of our usual solutions, like Tabula, don't really work here. What does? Plain text.
1/X
For example, Gloucester County's results are in a 500-page PDF. Some of our usual solutions, like Tabula, don't really work here. What does? Plain text.
1/X
December 22, 2024 at 10:22 PM
We've started converting official precinct election results from New Jersey, and wanted to give you a look at how we handle certain files.
For example, Gloucester County's results are in a 500-page PDF. Some of our usual solutions, like Tabula, don't really work here. What does? Plain text.
1/X
For example, Gloucester County's results are in a 500-page PDF. Some of our usual solutions, like Tabula, don't really work here. What does? Plain text.
1/X
The second official results file, apparently sent on Dec. 3, has Trump with 7,943 votes (with a similar gain for Harris, fwiw). This document isn't signed by one of the county's five election commissioners:
sos.ms.gov/elections/el...
2/2
sos.ms.gov/elections/el...
2/2
December 21, 2024 at 4:05 PM
The second official results file, apparently sent on Dec. 3, has Trump with 7,943 votes (with a similar gain for Harris, fwiw). This document isn't signed by one of the county's five election commissioners:
sos.ms.gov/elections/el...
2/2
sos.ms.gov/elections/el...
2/2
Mississippi always has surprises in its election results, and this year is no exception. Take Pike County, which sent two different "official" results files to the state.
One of them labeled "Certified Results" & dated 11/15 has Trump with 6,504 votes in the county:
sos.ms.gov/elections/el...
1/2
One of them labeled "Certified Results" & dated 11/15 has Trump with 6,504 votes in the county:
sos.ms.gov/elections/el...
1/2
December 21, 2024 at 4:03 PM
Mississippi always has surprises in its election results, and this year is no exception. Take Pike County, which sent two different "official" results files to the state.
One of them labeled "Certified Results" & dated 11/15 has Trump with 6,504 votes in the county:
sos.ms.gov/elections/el...
1/2
One of them labeled "Certified Results" & dated 11/15 has Trump with 6,504 votes in the county:
sos.ms.gov/elections/el...
1/2