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: U.S. House, State Senate, State House. If the files have it, you can also include Registered Voters, Ballots Cast and Straight Party as pseudo-candidate values. You can use the Kanawha County file as an example of how things should look.
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,votesFor the following offices: U.S. House, State Senate, State House. If the files have it, you can also include Registered Voters, Ballots Cast and Straight Party as pseudo-candidate values. You can use the Kanawha County file as an example of how things should look.