County-level results parsing
dwillis opened this issue · 9 comments
Convert presidential, statewide and state legislative race results into CSV files from the original PDFs or Excel spreadsheets produced by the state (use whichever is easiest). Include primary, general and special elections for those offices.
The names of the CSV files should have the following format: yymmdd__ny__general.csv for general elections and yymmdd__ny__primary.csv for primaries.
We're interested in results for all federal and state offices, but if you want to generate files for the entire file, that's fine. The CSV files should have at least these fields: county, office, district, party, candidate, votes
We use Python and Tabula for the most part, but you can use whatever gets the job done, and we welcome contributions of parsers and other utilities.
I'll pitch in here @dwillis
Thanks @RedOakMark! I'm grabbing 2000, but the others are wide open.
Working on 2016 to start with just to make sure I get the formatting down.
@dwillis do you usually combine Write Ins into one selection, or keep them all separate?
Count me in for 2004:2006 to start. I'll submit a pull request when I complete all three years.
@dwillis It seems like 2016 data is in the repo but not showing on the website: http://www.openelections.net/results/#ny
Is there some further processing needed?
Hey @AlJohri, yes, we need to implement NY in the core repository. Closest state in terms of similar data is probably Oregon.
Starting 2002 excepting Onondaga county. No 2003 statewide races to parse I think.