search

openelections / openelections-data-ut

Pre-processed election results for Utah
6 stars 13 forks source link

Added Beaver County and Cache County 2012 general #32

Closed migurski closed 4 years ago

migurski commented 4 years ago

Ref. https://github.com/openelections/openelections-data-ut/issues/29

This Python script generates a CSV file from input in Google Sheets for Beaver County and Cache County generated from original county PDF files.

Multi-Page Tables

Each office is grouped as one logical table but they're often split up among multiple PDF pages. Here’s an example for House District 2, pages 15-18:

four-up@1x

With Tabula and some spreadsheet copy/pasting, it’s useful to get this into an actual single table for this office:

Screen Shot 2020-01-26 at 7 29 54 PM

Precinct Row Groups

Each precinct is expressed as a repeated series of seven rows, with the precinct name followed by polling, absentee, provisional, early, paper at polls, and total vote counts. Only the total vote counts at the end are important for OpenElections:

one-precinct@2x

Totals After Precincts

After all the precincts, a grand total for the whole county is included in its own set of rows. These should be ignored or they will double the vote counts:

total-rows@2x

dwillis commented 4 years ago

@migurski Thanks! It looks to me like the CSV is missing presidential results?

migurski commented 4 years ago

I thought it was odd that the issue didn't ask for presidential results! I’ll add them and update this PR.

dwillis commented 4 years ago

It definitely is odd, and I'll fix that!

migurski commented 4 years ago

Done adding US Pres vote.

migurski commented 4 years ago

Added Cache County as well.

dwillis commented 4 years ago

@migurski thank you!