Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

2008 general precinct results #3

Open
49 of 55 tasks
dwillis opened this issue Jun 20, 2017 · 4 comments
Open
49 of 55 tasks

2008 general precinct results #3

dwillis opened this issue Jun 20, 2017 · 4 comments

Comments

@dwillis
Copy link
Contributor

dwillis commented Jun 20, 2017

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

The source files you'll be converting can be found here. 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: President, U.S. Senate, U.S. House, Governor, Secretary of State, State Treasurer, State Auditor, Commissioner of Agriculture, Attorney General, State Senate, State House. You can use the Wayne County file as an example of how things should look.

  • Barbour
  • Berkeley
  • Boone
  • Braxton
  • Brooke
  • Cabell
  • Calhoun
  • Clay
  • Doddridge
  • Fayette
  • Gilmer
  • Grant
  • Greenbrier
  • Hampshire
  • Hancock
  • Hardy
  • Harrison
  • Jackson
  • Jefferson
  • Kanawha
  • Lewis
  • Lincoln
  • Logan
  • Marion
  • Marshall
  • Mason
  • McDowell
  • Mercer
  • Mineral
  • Mingo
  • Monongalia
  • Monroe
  • Morgan
  • Nicholas
  • Ohio
  • Pendleton
  • Pleasants
  • Pocahontas
  • Preston
  • Putnam
  • Raleigh
  • Randolph
  • Ritchie
  • Roane
  • Summers
  • Taylor
  • Tucker
  • Tyler
  • Upshur
  • Wayne
  • Webster
  • Wetzel
  • Wirt
  • Wood
  • Wyoming
@scuerda
Copy link
Contributor

scuerda commented Jun 22, 2017

I'll take a crack at Tyler and see if script works on other Counties.

@scuerda
Copy link
Contributor

scuerda commented Jun 22, 2017

@dwillis Quick question when you have a minute. In the sample results, 3 parties appear (DEM, REP, MTN, CON). Is there a canonical list of possible WV parties to work from?

@dwillis
Copy link
Contributor Author

dwillis commented Jun 22, 2017

@scuerda For 2008, those are all the parties you'll need.

@scuerda
Copy link
Contributor

scuerda commented Jun 22, 2017

@dwillis Sounds good. Have a few more things to do (handle rollups, look up house districts), but I've tested the basic parsing on Tyler, Webster and Wetzel and everything looks on point.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants