The openelections-data-ks from openelections

Rice 2016 general results have 2 mistakes

These two errors have been verified against the official results PDF.

==> 20161108__ks__general__rice__precinct.csv
ERROR: candidate total incorrect, line 183. 2979 != 2980
{'county': 'Rice', 'precinct': 'Total', 'office': 'U.S. Senate', 'district': '', 'party': 'R', 'candidate': 'Jerry Moran', 'votes': 2979}
ERROR: candidate total incorrect, line 270. 732 != 738
{'county': 'Rice', 'precinct': 'Total', 'office': 'U.S. House', 'district': 1.0, 'party': 'IND', 'candidate': 'Alan LaPolice', 'votes': 732}

Precinct names

I am looking at the precinct names in 2016/20161108__ks__general__douglas__precinct.csv and I am trying to understand where they are coming from. The presidential results source file in https://github.com/openelections/openelections-sources-ks/blob/master/2016%20general%20precinct/2016%20General%20Election%20-%20President%20Results%20by%20Precinct.xlsx for example, has nothing like this line:

Douglas,Prec 67-78,President,,write-in,Evan McMullin,3

I can't correlate Prec 67-78 to any real precinct in Douglas county.

I can kind of squint and see how Lawrence Precinct 46 S3 might be shortened to Prec 46 but it is spelled out in the source xlsx file, so it makes me wonder: how was this data-ks/2016/... file created in the first place?

Montgomery 2014 general results don't match official file

There are discrepancies between the official abstract and the converted CSV file in a number of races.

Convert 2014 general election files

If you want to work on a county, add a comment saying which one you'd like to work on or email [email protected]. You can either email us finished CSV files or submit a pull request, whatever is easiest.

The source files you'll be converting can be found here. Many of these are either PDFs or Excel files, and in some cases you'll need to convert a number of office-specific 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: President, U.S. Senate, U.S. House, State Senate, State House. You can use the Kiowa County file as an example of how things should look.

U.S. House 0

Is this a typo in the transcription?

https://github.com/openelections/openelections-data-ks/blob/master/2016/20161108__ks__general__cherokee__precinct.csv#L181

Convert 2016 general election files

If you want to work on a county, add a comment saying which one you'd like to work on or email [email protected]. You can either email us finished CSV files or submit a pull request, whatever is easiest.

The source files you'll be converting can be found here. Many of these are either PDFs or Excel files, and in some cases you'll need to convert a number of office-specific 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: President, U.S. Senate, U.S. House, State Senate, State House. You can use the Kiowa County file as an example of how things should look.

Multiple issues with 20141104 totals file

2014/20141104-totals.csv has a few problems:

Missing column headers.
Inconsistent number of columns. The first row has 7 columns

openelections-data-ks/2014/20141104-totals.csv

Line 1 in 913c5c0

Allen,0001 Carlyle,Voters,,,Ballots cast,132

However, starting on line 96 there are rows with 11 columns

openelections-data-ks/2014/20141104-totals.csv

Line 96 in 913c5c0

Cherokee,0001 Baxter Sprs W1,Voters,,,BALLOTS CAST,193,3,18,166,6

2018: Johnson County missing Vicki Schmidt's votes (Commissioner of Insurance)

There only look to be entries for her opponent in the general precinct file.

20161108ksgeneraledwardsprecinct.csv doesn't have President vote

Odd I know, but seems to be missing Presidential vote in all precincts.

2014 results are wrong

I am working through 2014 results and there are some systemic mistakes which make me suspicious of the whole.

For example, in Douglas county there are references to "Paul Davis" as the Democratic candidate for US Senate. He was not. He ran for Governor.

In the same file, for the Governor office the precinct vote counts are swapped for the Democrat and the Republican.

I have source files from the KS SOS and am going to reparse from source. I will try and preserve any totals in the originals per discussion in #39

Bourbon, Cherokee 2016, 2012 have strange data

The verifier is complaining because 20161108__ks__general__bourbon__precinct.csv has 35 duplicate rows. While investigating this, I discovered that there are some precincts supposedly called "Fort Scott Ward 1 Exclave Halls" and the like. This precinct name appears in the 2012 general too. However, the PDF of the precinct-level results doesn't list these, and the vote totals are all 0. Probably they should be removed, but I can't find the original source of them, so I wasn't sure.

Also, the 2016 file seems to have the official precincts of "E Marion" and "W Marion" from the PDF combined into a single "Marion Township." Probably we should use the same divisions that the county used that year?

I'm seeing very similar lines in 20161108__ks__general__cherokee__precinct.csv as well.

It looks like precinct and office are swapped in 20141104ksgeneralgoveprecinct

https://github.com/openelections/openelections-data-ks/blob/eeee2dd53554c349250a6d6c9738bbf87740a51c/2014/20141104__ks__general__gove__precinct.csv

Example:

county,precinct,office,district,party,candidate,votes
Gove,Attorney General,Baker,,D,A J Kotich,73
Gove,Attorney General,Grainfield,,D,A J Kotich,37

It looks like precinct and office are swapped.

Should nil votes be treated like zero?

e.g. https://github.com/openelections/openelections-data-ks/blob/master/2016/20161108__ks__general__dickinson__precinct.csv#L19

Not sure if that's an empty spot in the source files, or a missing 0 in the csv.

Party naming consistency for 2018 General

For 20181106__ks__general__precinct.csv, Wyandotte County uses a different naming convention for the parties compared to the rest of the counties. For example, is uses "DEM" instead of "Democratic". Standardizing this across the counties would be helpful.

2020 General results

placeholder - I am working on this.

Add Registered Voters and Ballots Cast to 2016 general Douglas file

Convert 2017 U.S. House special election precinct results

Using files from the Kansas sources repo, parse precinct-level files from the following counties for the April 11, 2017 special election for U.S. House district 4:

Candidate totals—keep?

A few weeks ago in 3adcc35, @karpet removed the TOTAL lines in a few files. I have been using them to do vote checksums (see total-checksum.py in OR). Especially in cases where the data is coming from hand keying, I've found lots of errors with the checksums in the past. But even without that, the checksum can still flag up duplicate or garbage lines, candidate name variations, and a whole bunch of other issues.

I realize I'm new to this state, so I didn't want to step on any toes. But I'm wondering if there's a particular reason to exclude them here?

openelections / openelections-data-ks Goto Github PK

openelections-data-ks's People

Contributors

Stargazers

Watchers

Forkers

openelections-data-ks's Issues

Recommend Projects

Recommend Topics

Recommend Org