openelections/openelections-data-ky

Pre-processed results for Kentucky elections

openelections-data-ky

Pre-processed results for Kentucky elections

Almost all of the results here are converted from PDFs, mostly posted by the State Board of Elections. Many of these files are marked or labeled as unofficial, but in checking with county clerks we've found that they in fact represent official results. Some counties post their own precinct results and a few use Clarity Elections software to post results (the state also uses Clarity for unofficial election night results).

Help us turn PDF files into data! We're looking for volunteers to convert county-level results.

openelections-data-ky's Issues

2016 General Precinct Level Results

Parse the Excel files in the Kentucky sources repo and output either individual county-specific files or a single statewide precinct file.

The headers for those files:

county, precinct, office, district, party, candidate, votes

You should include the following offices: President, U.S. Senate, U.S. House, State Senate and State House.

Ideally you'd write a script and include that script here.

Incomplete state house precinct data for Todd county.

Looking at 20181106__ky__general__precinct.csv, it's missing the state house precinct results from Todd county, but it does have the US House data. However, the state house data is in 20181106__ky__general__todd__precinct.csv and looks complete. Which script is used to map that data into the 20181106__ky__general__precinct.csv file? Is it just concatenated into the master file?

This might an issue for a few other counties.

Precinct result discrepancy between state unofficial results and Clarity Elections data

It looks like there's a discrepancy between the unofficial results from the ky.gov website and unofficial results from Clarity Elections.

For example, for the 9th State Representative District election in 2018, according to the certified results, Myron B. Dossett received 3665 votes from Hopkins county.

However, adding up the data in the Hopkins county results only shows 2828 votes. Looks like this was the original source for this data.

However, the unofficial data from Clarity Elections shows results from precincts D026, D027, D028 which the state's unofficial results don't even include. I'm not sure why these are missing, but including the data from these precincts brings the total to 3665 which is the official vote total from Hopkins county.

@dwillis I'm not sure the best way to fix this, but thought I would flag it.

County-level results from 2018 Primary

Unfortunately, the PDF posted by the Secretary of State appears to be an image, so OCR might be necessary here.

Header row for the output CSV (20180522__ky__primary__county.csv) is:

county, office, district, party, candidate, votes

For the following contests: U.S. Representative, State Senator, State Representative

The file should look something like this:

https://github.com/openelections/openelections-data-ky/blob/master/2016/20160517__ky__primary__county.csv

2016 general election precinct results errors

Underreported in precincts:

• Breckinridge
• Hart
• Mercer

and it looks like some provisional votes are not included in the official totals for Jefferson.

Replace

• Jefferson County 2016 general results has 0 votes for everyone. Convert this PDF using Tabula into a CSV file that matches the other KY precinct files (here's an example).

Missing

Convert the PDF files located here for the following counties into CSV files matching our format (here's an example).

• Campbell
• Warren
• Breckinridge
• Elliott
• Hart
• Lee
• Lewis
• Mercer
• Morgan
• Owsley
• Powell
• Robertson
• Wolfe

Discrepancies

Compared to the state's official count, the file has 6 fewer votes in Fayette, 1 fewer in Hardin, 1 fewer in Kenton, 1 more in Menifee, 1 fewer in Nelson, 13 fewer in Pike, 2 fewer in Pulaski, 2 fewer in Scott, 3 fewer in Trigg, 1 fewer in Wayne.

Missing Bell and Lewis from 2012 primary precinct results

Missing Leslie from 2011 primary precinct results

Can we match candidate parties to pre-processed results files?

The 2016 general precinct results file has no values for candidate parties, because the information isn't in the general election results produced by the state. Can we extract candidate names from the primary results and match them to the general results to populate the parties?

20181106 general precinct file has inconsistent columns

2018/20181106__ky__general__precinct.csv has a header with 13 columns

county,precinct,office,district,candidate,party,votes,eslate,escan,absentee_mail,absentee,absentee_eslate,absentee_escan

However, there are many lines with an inconsistent number of columns. For example:

Line 30921 only has 7 columns

Franklin,AB,Ballots Cast,,,,1214

Line 7380 has 1 column and line 7381 has 12 columns, due to a line break

Marshall,"A101 South
Benton",U.S. House,1,James R Comer,REP,388,,,,,,

Missing 2019 General Precinct Results

• Anderson
• Bell
• Bracken
• Carlisle
• Carter
• Edmonson
• Elliott
• Franklin
• Harrison
• Lee
• Lewis
• Mason
• Menifee
• Mercer
• Metcalfe
• Morgan
• Nicholas
• Oldham
• Owsley
• Rowan
• Russell
• Spencer
• Taylor
• Union
• Wolfe

2018 general election precinct return problems

In the raw data for Kentucky’s 2018 general elections, there’s multiple occurrences of candidates for US House appearing with US Senate listed in the office column. This includes candidates like Seth Hall and Thomas Massie- where they are listed as US House in some parts of the data and US Senate in others.

County-level results

Recent Kentucky county-level election results are contained in electronic PDFs that can be parsed using Tabula or other utilities that can extract formatted text from PDFs. Convert presidential, statewide and state legislative race results into CSV files. An example of what a finished CSV file looks like is here.

• 2018 general
• 2018 primary
• 2016 general
• 2016 primary
• 2015 general
• 2015 primary
• 2014 general
• 2014 primary
• 2012 general
• 2012 primary

Earlier election results are in image PDFs that will require OCR:

• 2011 general
• 2011 primary
• 2010 general
• 2010 primary

2018 General Election Precinct Results

• Adair
• Allen
• Anderson
• Ballard
• Barren
• Bath
• Bell
• Boone
• Bourbon
• Boyd
• Boyle
• Bracken
• Breathitt
• Breckinridge
• Bullitt
• Butler
• Caldwell
• Calloway
• Campbell
• Carlisle
• Carroll
• Carter
• Casey
• Christian
• Clark
• Clay
• Clinton
• Crittenden
• Cumberland
• Daviess
• Edmonson
• Elliott
• Estill
• Fayette
• Fleming
• Floyd
• Franklin
• Fulton
• Gallatin
• Garrard
• Grant
• Graves
• Grayson
• Green
• Greenup
• Hancock
• Hardin
• Harlan
• Harrison
• Hart
• Henderson
• Henry
• Hickman
• Hopkins
• Jackson
• Jefferson
• Jessamine
• Johnson
• Kenton
• Knott
• Knox
• Larue
• Laurel
• Lawrence
• Lee
• Leslie
• Letcher
• Lewis
• Lincoln
• Livingston
• Logan (Clarity, clerk says it's official)
• Lyon
• Madison
• Magoffin
• Marion
• Marshall
• Martin
• Mason
• McCracken
• McCreary
• McLean
• Meade
• Menifee
• Mercer
• Metcalfe
• Monroe
• Montgomery
• Morgan
• Muhlenberg
• Nelson
• Nicholas
• Ohio
• Oldham
• Owen
• Owsley
• Pendleton
• Perry
• Pike
• Powell
• Pulaski
• Robertson
• Rockcastle
• Rowan
• Russell
• Scott
• Shelby
• Simpson
• Spencer
• Taylor
• Todd
• Trigg
• Trimble
• Union
• Warren
• Washington
• Wayne
• Webster
• Whitley
• Wolfe
• Woodford

Franklin County missing in statewide precinct file

Franklin county is missing from https://github.com/openelections/openelections-data-ky/blob/master/2018/20181106__ky__general__precinct.csv even though https://github.com/openelections/openelections-data-ky/blob/master/2018/counties/20181106__ky__general__franklin__precinct.csv exists.

Missing 2018 data from Hardin county.

Some candidates/races from Hardin county are missing in the parsed Hardin 2018 precinct results. Looking at the source data, it looks like some candidates were parsed like (S Brett Guthrie, Hank Linderman, etc), but some candidates were missing (Jim DuPlessis, Tom Williamson, etc).

@dwillis