openelections / openelections-data-ut

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

Juab 2018 general does not sum to match the official canvass #23

Open npelikan opened 5 years ago

npelikan commented 5 years ago

Juab 2018 precinct file sums to the following:

> library(readr)
> 
> ti <- read_csv("~/openelections/openelections-data-ut/2018/20181106__ut__general__juab__precinct.csv")
Parsed with column specification:
cols(
  candidate = col_character(),
  office = col_character(),
  district = col_integer(),
  party = col_character(),
  county = col_character(),
  precinct = col_character(),
  votes = col_integer(),
  winner = col_character()
)
> 
> sum(ti$votes[ti$candidate %in% "Mitt Romney"])
[1] 3206
> 
> sum(ti$votes[ti$candidate %in% "Jenny Wilson"])
[1] 484
> 
> sum(ti$votes[ti$candidate %in% "Straight Party"])
[1] 0

These, however, do not match the official canvass of results from the state found here: https://elections.utah.gov/Media/Default/2018%20Election/2018%20General%20Election%20Canvass.pdf

As the Juab county file is not in openelections/openelections-sources-ut, I cannot diagnose the source of the error

dwillis commented 5 years ago

@npelikan thanks for the report. The precinct results from Juab are in the sources repo here, and we've asked the Juab clerk about the discrepancy.