Open dwillis opened 4 years ago
How would you recommend we include data on Registered Voters and/or Ballots Cast in the CSV structure?
@migurski usually we just put Registered Voters or Ballots Cast in the office
column and the number in the votes
column.
Got it. I’ll try to do that moving forward — I’m planning to do a handful more of these.
Thanks @migurski!
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 are in the Utah sources repository. Many of these are either PDFs or Excel 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: Straight Party, President, U.S. House, Attorney General, State Senate and State House. If data on Registered Voters and/or Ballots Cast is available, please include that as well.
File names should be:
20121106__ut__general__{county_name}__precinct.csv
, with the county name lower case and spaces replaced with underscores.