Convert 2012 general election results

[dwillis]

Using data posted here, use either Excel or PDF files to produce CSV file with town-specific results in each county for offices from President down to state legislature. A single output file would be 20121106__nh__general__town.csv and would have at least the following headers: county, town, office, district, party, candidate, votes.

[mjguidry]

For State Representative, since the offices are county based, what would be the proper district designation? For instance, for Hillsborough 1, is the district label just '1' or is it something like "Hillsborough 1"? Also, should there be some way of designating the number of seats per office? For instance, Hillsborough 1 has two seats but Hillsborough 21 has eight.

[dwillis]

Good questions - the proper designation is the district number, and for offices with multiple seats, you can add a winner column and set its value to True for those who won office. Does that work?

[mjguidry]

Let's give it a shot, once I'm able to extract the State Rep results I don't think it will be tough to add these. I think...

[dwillis]

Thanks, and please don't hesitate to let us know if you have questions/issues.