openelections / openelections-data-sd

Election results for South Dakota
3 stars 6 forks source link

Convert 2012 General Precinct-Level Election Results #8

Open dwillis opened 6 years ago

dwillis commented 6 years ago

If you want to work on a county, add a comment saying which one you'd like to work on or email openelections@gmail.com. You can either email us finished CSV files or submit a pull request, whatever is easiest.

The results files you'll be converting can be found in our sources repository or in this statewide PDF and state legislative PDF. Many of these are either PDFs or Excel files, and in some cases you'll need to convert a number of office-specific files. For electronic PDFs, we recommend using Tabula, which is free, to extract data. The goal is to create a single CSV file for each county, with the following headers:

county, precinct, office, district, party, candidate, votes

For the following offices: U.S. Senate, U.S. House, Governor, Secretary of State, Attorney General, State Auditor, State Treasurer, Commissioner of School and Public Lands, Public Utilities Commissioner, State Senate, State House. You can use the Aurora County file as an example of how things should look.