Convert 2016 general election files

[dwillis]

If you want to work on a county, add a comment saying which one you'd like to work on or email openelections@gmail.com. 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.

• [x] Allen
• [x] Anderson
• [x] Atchison
• [x] Barber
• [x] Barton
• [x] Bourbon
• [x] Brown
• [x] Butler
• [x] Chase
• [x] Chautauqua
• [x] Cherokee
• [x] Cheyenne
• [x] Clark
• [x] Clay
• [x] Cloud
• [x] Coffey
• [x] Comanche
• [x] Cowley
• [x] Crawford
• [x] Decatur
• [x] Dickinson
• [x] Doniphan
• [x] Douglas
• [x] Edwards
• [x] Elk
• [x] Ellis
• [x] Ellsworth
• [x] Finney
• [x] Ford
• [x] Franklin
• [x] Geary
• [x] Gove
• [x] Graham
• [x] Grant
• [x] Gray
• [x] Greeley
• [x] Greenwood
• [x] Hamilton
• [x] Harper
• [x] Harvey
• [x] Haskell
• [x] Hodgeman
• [x] Jackson
• [x] Jefferson
• [x] Jewell
• [x] Johnson
• [x] Kearny
• [x] Kingman
• [x] Kiowa
• [x] Labette
• [x] Lane
• [x] Leavenworth
• [x] Lincoln
• [x] Linn
• [x] Logan
• [x] Lyon
• [x] McPherson
• [x] Marion
• [x] Marshall
• [x] Meade
• [x] Miami
• [x] Mitchell
• [x] Montgomery
• [x] Morris
• [x] Morton
• [x] Nemaha
• [x] Neosho
• [x] Ness
• [x] Norton
• [x] Osage
• [x] Osborne
• [x] Ottawa
• [x] Pawnee
• [x] Phillips
• [x] Pottawatomie
• [x] Pratt
• [x] Rawlins
• [x] Reno
• [x] Republic
• [x] Rice
• [x] Riley
• [x] Rooks
• [x] Rush
• [x] Russell
• [x] Saline
• [x] Scott
• [x] Sedgwick
• [x] Seward
• [x] Shawnee
• [x] Sheridan
• [x] Sherman
• [x] Smith
• [x] Stafford
• [x] Stanton
• [x] Stevens
• [x] Sumner
• [x] Thomas
• [x] Trego
• [x] Wabaunsee
• [x] Wallace
• [x] Washington
• [x] Wichita
• [x] Wilson
• [x] Woodson
• [x] Wyandotte

[krishnan-viswanathan]

Leon County, FL

[dwillis]

@krishnan-viswanathan Florida has election results files you can download; this is the Kansas repository.

[krishnan-viswanathan]

Realized that after I put in my comment that it is KS specific. Sorry about that.

Brown County.

[taylorterry3]

I've got Allen county done. I can't push since I'm a first time contributor, but it's in a gist at https://gist.github.com/taylorterry3/aca4785c0d65147484dda4c107af429f. Let me know if any edits are needed.

Thanks!

[dwillis]

@taylorterry3 Thanks! It looks like districts for U.S. House and state senate are missing. Can you fix? You can't push directly, but you can fork this repository, push to your own copy and then create a pull request.

[taylorterry3]

OK, cool, didn't realize you guys did forks rather than branches. Makes sense.

Re: districts, they're not present in the source file (nor is party). I'm guessing the whole county is in one state senate and US House, though, so I'll research that and hand-jam them.

[dwillis]

Many thanks!

[mishelley]

Is Nemaha and Neosho available? Happy to work on them

[dwillis]

@mishelley: yes, absolutely, thanks!

[mishelley]

Getting started

[brentajones]

Harper.

[lephead]

20161108_ks_general_decatur_precinct.xlsx

[lephead]

20161108_ks_general_dickinson_precinct.xlsx

I deleted the blank state leg lines in Abilene and am resubmitting.

[lephead]

20161108_ks_general_harvey_precinct.xlsx

[lephead]

20161108_ks_general_linn_precinct.xlsx

[lephead]

[Uploading 20161108_ks_general_logan_general.xlsx…]()

[lephead]

[Uploading 20161108_ks_general_sherman_precinct.xlsx…]()

[lephead]

20161108_ks_general_stafford_precinct.xlsx

[lephead]

20161108_ks_general_sumner_precinct.xlsx

[nk9]

@lephead Thanks for all of these! Will convert them into CSVs and upload. In the future, please include the candidate and/or precinct totals where possible. This means we can have a checksum to make sure there weren't any typos/scannos/copy-paste errors in the results. Have a look at this CSV for how to include precinct totals. Candidate totals simply put the "Total" marker in the precinct field.

In addition, if you find it easier, you're welcome to use this format to submit the results. We have a script which takes that and turns it directly into an OE CSV file.

[lephead]

I'll add the county totals from now on.

[lephead]

20161108_ks_general_ford_precinct.xlsx

[lephead]

Ford with totals

20161108_ks_general_ford_precinct.xlsx

[lephead]

20161108_ks_general_franklin_precinct.xlsx

You won't believe this but between Franklin County and the Sec of State, there were no totals except president on the internet.

[lephead]

20161108_ks_general_geary_precinct.xlsx

[nk9]

I'll be honest: it's Kansas. I can believe it. :-)

[nk9]

@lephead The Sherman and Logan results above don't seem to have successfully uploaded. Can you have a look again, please?

[lephead]

20161108_ks_general_logan_general.xlsx 20161108_ks_general_sherman_precinct.xlsx

[lephead]

Here is Labette

20161108_ks_general_labette_precinct.xlsx

[lephead]

Here's Jackson for ya

20161108_ks_general_jackson_precinct.xlsx

[lephead]

Jewell

2016 jewell ks official.pdf 2016 jewell ks official.xlsx

[michaelgreis]

Hey, I'm going to be working some of these throughout the day. Working on Chase currently

[gvpeek]

Working on Chautauqua. Will try to run through some of these as well as part of the hackathon

[gvpeek]

Working on Lane next

[gvpeek]

I'm planning to work on Clay next, but it's pretty gross, so may take me a while

[lephead]

2016 clay ks General Election Final.pdf [Uploading 2016 CLAY KS PREC.pdf…]() 2016 CLAY KS Voter Turnout Official Final.pdf

[karpet]

I have obtained precinct level reports from the KS SoS office but they are mostly in PDF format. Would these be helpful for the remaining work here?

--edit Ah nevermind, I see you already have the same data in https://github.com/openelections/openelections-sources-ks

[dwillis]

@karpet thanks, if you see any that we don't have that you do, would love to have them.

[lephead]

Kansas is a difficult one because sometimes the county has more precincts than the state chart. Very annoying.

On Wed, Jul 5, 2017 at 2:27 PM, Derek Willis notifications@github.com wrote:

@karpet https://github.com/karpet thanks, if you see any that we don't have that you do, would love to have them.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/openelections/openelections-data-ks/issues/1#issuecomment-313231786, or mute the thread https://github.com/notifications/unsubscribe-auth/AJkjUisAuNlYZkjW76hn1E_QJb9hTipiks5sK_-0gaJpZM4LkAW5 .

-- John Mifflin