New Mexico has county-by-county files with precinct-level results that can be parsed using Tabula or another approach. The file name format is 20121106__nm__general__{county}__precinct.csv, where the county name is the slugified version of the county (lowercase, with underscores replacing spaces).
The source PDFs have several sections covering the various kinds of votes: absentee, early voting, "regular" (election-day) and summary. We'd like the CSV files to combine them so that each row represents a single candidate result in a race with all vote types included.
CSV headers: county, precinct, office, district, party, candidate, absentee, early_voting, regular, votes
The votes column represents the numbers in the "county summary" section of the PDFs. The absentee, early voting and regular columns represent votes in those categories.
We are interested in the following offices: President, U.S. Senate, U.S. House, State Senate and State House.
New Mexico has county-by-county files with precinct-level results that can be parsed using Tabula or another approach. The file name format is
20121106__nm__general__{county}__precinct.csv, where the county name is the slugified version of the county (lowercase, with underscores replacing spaces).The source PDFs have several sections covering the various kinds of votes: absentee, early voting, "regular" (election-day) and summary. We'd like the CSV files to combine them so that each row represents a single candidate result in a race with all vote types included.
CSV headers:
county,precinct,office,district,party,candidate,absentee,early_voting,regular,votesThe
votescolumn represents the numbers in the "county summary" section of the PDFs. The absentee, early voting and regular columns represent votes in those categories.We are interested in the following offices: President, U.S. Senate, U.S. House, State Senate and State House.