Using Tabula, OCR or whatever method you can, parse precinct-level results for the following counties. Original sources are in individual county folders in the sources-or repository.
The goal is to create a single CSV file for each county, with the following headers:
county, precinct, office, district, party, candidate, votes
Here's an example of a finished CSV file.
If the county file also provides a breakdown of votes by method, include that using the following headers, where applicable:
early_voting, election_day, provisional, mail
If there are other possible vote types, include them, using a lowercase version of the vote type with underscores instead of spaces for the column name.
Include the following offices:
- Registered Voters (if available)
- Ballots Cast (if available)
- U.S. House
- Governor
- State Senator
- State Representative
If a county provides precinct results for Write-in candidates, they should be grouped in a single row for each precinct and office with a candidate value of Write-ins.
If a county provides Under Votes or Over Votes, those should be recorded in the same way, with a single row per precinct and office with Over Votes and Under Votes as the candidate values.
Using Tabula, OCR or whatever method you can, parse precinct-level results for the following counties. Original sources are in individual county folders in the sources-or repository.
The goal is to create a single CSV file for each county, with the following headers:
county,precinct,office,district,party,candidate,votesHere's an example of a finished CSV file.
If the county file also provides a breakdown of votes by method, include that using the following headers, where applicable:
early_voting,election_day,provisional,mailIf there are other possible vote types, include them, using a lowercase version of the vote type with underscores instead of spaces for the column name.
Include the following offices:
If a county provides precinct results for Write-in candidates, they should be grouped in a single row for each precinct and office with a
candidatevalue ofWrite-ins.If a county provides Under Votes or Over Votes, those should be recorded in the same way, with a single row per precinct and office with
Over VotesandUnder Votesas thecandidatevalues.