Convert 2012 General Precinct-Level Election Results #8
Description
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.
- Aurora
- Beadle
- Bennett
- Bon Homme
- Brookings
- Brown
- Brule
- Buffalo
- Butte
- Campbell
- Charles Mix
- Clark
- Clay
- Codington
- Corson
- Custer
- Davison
- Day
- Deuel
- Dewey
- Douglas
- Edmunds
- Fall River
- Faulk
- Grant
- Gregory
- Haakon
- Hamlin
- Hand
- Hanson
- Harding
- Hughes
- Hutchinson
- Hyde
- Jackson
- Jerauld
- Jones
- Kingsbury
- Lake
- Lawrence
- Lincoln
- Lyman
- Marshall
- McCook
- McPherson
- Meade
- Mellette
- Miner
- Minnehaha
- Moody
- Pennington
- Perkins
- Potter
- Roberts
- Sanborn
- Shannon
- Spink
- Stanley
- Sully
- Todd
- Tripp
- Turner
- Union
- Walworth
- Yankton
- Ziebach