Convert 2022 General Election Precinct Results

[dwillis]

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 Ticket, U.S. Senate, U.S. House, State Treasurer, State Senate and State House. File names should be: 20221108__ut__general__{county_name}__precinct.csv, with the county name lower case and spaces replaced with underscores.

• [x] Beaver
• [x] Box Elder
• [x] Cache
• [x] Carbon
• [x] Daggett
• [x] Davis
• [x] Duchesne
• [x] Emery
• [x] Garfield
• [x] Grand
• [x] Iron
• [x] Juab
• [x] Kane
• [x] Millard
• [x] Morgan
• [x] Piute
• [x] Rich
• [x] Salt Lake
• [x] San Juan
• [x] Sanpete
• [x] Sevier
• [x] Summit
• [x] Tooele
• [x] Uintah
• [x] Utah
• [x] Wasatch
• [x] Washington
• [x] Wayne
• [x] Weber

[sbaltzmit]

If this is OK, I'll start working roughly from the bottom up, potentially skipping some in the interest of doing the easiest ones first. Sevier county looks especially doable so I'll probably try that one next. Just let me know if anyone wants to take one at the end of the alphabet so that I know to avoid it.