County-level results parsing

[dwillis]

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.

• [ ] 2018 general
• [ ] 2018 federal primary
• [x] 2018 state primary
• [x] 2016
• [x] 2015
• [x] 2014
• [x] 2013
• [ ] 2012
• [ ] 2011
• [ ] 2010
• [ ] 2009
• [ ] 2008
• [ ] 2007
• [x] 2006
• [x] 2005
• [x] 2004
• [ ] 2003
• [x] 2002
• [ ] 2000

[RedOakMark]

I'll pitch in here @dwillis

[dwillis]

Thanks @RedOakMark! I'm grabbing 2000, but the others are wide open.

[RedOakMark]

Working on 2016 to start with just to make sure I get the formatting down.

[RedOakMark]

@dwillis do you usually combine Write Ins into one selection, or keep them all separate?

[ursulams]

Count me in for 2004:2006 to start. I'll submit a pull request when I complete all three years.

[solumos]

@dwillis I'll give 2008 a try!

[AlJohri]

@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?

[dwillis]

Hey @AlJohri, yes, we need to implement NY in the core repository. Closest state in terms of similar data is probably Oregon.

[ursulams]

Starting 2002 excepting Onondaga county. No 2003 statewide races to parse I think.