Open dwillis opened 4 years ago
I had downloaded Comal, but came in handy after all.
Here iss Lubbock Dem 20200303_tx_primary_lubbock.xlsx
Lubbock Rep 20200303_tx_primaryrep_lubbock_precinct.xlsx
Looks like Maverick REP primary is missing several precincts.
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
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:
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 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 Votes
andUnder Votes
as thecandidate
values.