Convert 2016 general election files #1
Comments
|
Leon County, FL |
|
@krishnan-viswanathan Florida has election results files you can download; this is the Kansas repository. |
|
Realized that after I put in my comment that it is KS specific. Sorry about that. Brown County. |
|
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! |
|
@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. |
|
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. |
|
Many thanks! |
|
Is Nemaha and Neosho available? Happy to work on them |
|
@mishelley: yes, absolutely, thanks! |
|
Getting started |
|
Harper. |
|
20161108_ks_general_dickinson_precinct.xlsx I deleted the blank state leg lines in Abilene and am resubmitting. |
|
@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. |
|
I'll add the county totals from now on. |
|
Ford with totals |
|
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. |
|
I'll be honest: it's Kansas. I can believe it. :-) |
|
@lephead The Sherman and Logan results above don't seem to have successfully uploaded. Can you have a look again, please? |
|
Here is Labette |
|
Here's Jackson for ya |
|
Hey, I'm going to be working some of these throughout the day. Working on Chase currently |
|
Working on Chautauqua. Will try to run through some of these as well as part of the hackathon |
|
Working on Lane next |
|
I'm planning to work on Clay next, but it's pretty gross, so may take me a while |
|
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 |
|
@karpet thanks, if you see any that we don't have that you do, would love to have them. |
|
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 ***@***.***> 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
<#1 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AJkjUisAuNlYZkjW76hn1E_QJb9hTipiks5sK_-0gaJpZM4LkAW5>
.
--
John Mifflin
|
Updated party for Patrick Wiesner from LBT to D
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,votesFor 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.
The text was updated successfully, but these errors were encountered: