Open dwillis opened 7 years ago
I'll take a crack at Tyler and see if script works on other Counties.
@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?
@scuerda For 2008, those are all the parties you'll need.
@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.
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 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.