2012 general election precinct results parsing

[dwillis]

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.

• [ ] Bernalillo
• [ ] Catron
• [ ] Chaves
• [ ] Cibola
• [ ] Colfax
• [ ] Curry
• [ ] De Baca
• [ ] Dona Ana
• [ ] Eddy
• [ ] Grant
• [ ] Guadalupe
• [ ] Harding
• [ ] Hidalgo
• [ ] Lea
• [ ] Lincoln
• [ ] Los Alamos
• [ ] Luna
• [ ] McKinley
• [ ] Mora
• [ ] Otero
• [ ] Quay
• [ ] Rio Arriba
• [ ] Roosevelt
• [ ] San Juan
• [ ] San Miguel
• [ ] Sandoval
• [ ] Santa Fe
• [ ] Sierra
• [ ] Socorro
• [ ] Taos
• [ ] Torrance
• [ ] Union
• [ ] Valencia

[lawsonbh]

I've started working with the data files in Tabula. - Ostrich