Using Tabula, OCR or whatever method you can, parse precinct-level results for the following counties. Original sources are in the sources-tx repository.
The goal is to create a single CSV file for each county, with the following headers:
county, precinct, office, district, party, candidate, votes
The filename should be in this format: 20221108__tx__general__{county}__precinct.csv, with the county name being lowercase and replacing spaces with underscores.
If the county file also provides a breakdown of votes by method, include that using the following headers:
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)
Governor
Lieutenant Governor
Attorney General
Comptroller of Public Accounts
Commissioner of the General Land Office
Commissioner of Agriculture
Railroad Commissioner
U.S. House
State Senate
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 the sources-tx repository.
The goal is to create a single CSV file for each county, with the following headers:
county,precinct,office,district,party,candidate,votesThe filename should be in this format:
20221108__tx__general__{county}__precinct.csv, with the county name being lowercase and replacing spaces with underscores.If the county file also provides a breakdown of votes by method, include that using the following headers:
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.