openelections / openelections-data-ca

Pre-processed election results for California elections
MIT License
13 stars 17 forks source link

Incorrect values for precinct 588270MB in Imperial general file #221

Closed warwickmm closed 3 years ago

warwickmm commented 3 years ago

The values for precinct 588270MB in 2020/20201103cageneralimperialprecinct.csv seem suspect:

https://github.com/openelections/openelections-data-ca/blob/7ba0dea27501bfd06c88f421d6ffe360969a5f89/2020/20201103__ca__general__imperial__precinct.csv#L1

https://github.com/openelections/openelections-data-ca/blob/7ba0dea27501bfd06c88f421d6ffe360969a5f89/2020/20201103__ca__general__imperial__precinct.csv#L1955-L1963

There are non-integer values, and they don't appear to be close to what the source file contains:

image

image

warwickmm commented 3 years ago

Upon closer inspection, it seems the values in the csv file are half of what they are supposed to be. Perhaps the parser got confused by the presence of the "Electionwide - Total" row.

I can take care of this.