2012 General Election Precinct Results
dwillis opened this issue · 5 comments
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.
You'll find 2012 results files you'll be converting in some of the county-specific folders in the NY sources repository. 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
If a county reports votes by type, add a absentee column for those votes and use votes for the total number.
For the following offices: President, U.S. Senate, U.S. House, State Senate, State Assembly. Since NY reports separate candidate-and-party totals, you should list each combination of candidate and party on a separate line. You can use the Herkimer County file as an example of how things should look.
In New York, the concept of a precinct is often called an "election district," so if the file says "district" or "election district," use that as the precinct.
- Albany
- Allegany
- Bronx
- Broome
- Cattaraugus
- Cayuga
- Chautauqua
- Chemung
- Chenango
- Clinton
- Columbia
- Cortland
- Delaware
- Dutchess
- Erie
- Essex
- Franklin
- Fulton
- Genesee
- Greene
- Hamilton
- Herkimer
- Jefferson
- Kings
- Lewis
- Livingston
- Madison
- Monroe
- Montgomery
- Nassau
- New York
- Niagara
- Oneida
- Onondaga
- Ontario
- Orange
- Orleans
- Oswego
- Otsego
- Putnam
- Queens
- Rensselaer
- Richmond
- Rockland
- St. Lawrence
- Saratoga
- Schenectady
- Schoharie
- Schuyler
- Seneca
- Steuben
- Suffolk
- Sullivan
- Tioga
- Tompkins
- Ulster
- Warren
- Washington
- Wayne
- Westchester
- Wyoming
- Yates
I've got Chatauqua.
finished my first (Chautauqua, president) - not sure if it went through. it's just for you to check at this point. a few questions - one, are you doing every race in a separate sheet or should they be tabs in the same sheet like in the original. Also,can't remember, what 's proper label for party and candidate fields when values are W-IN/Scattering and (isblank)/BlankVoid?
@GulliverDataJournalist Just gave you access to push to the repository, so your changes haven't made it yet. If you want, you can email the file to openelections@gmail.com so I can check it. The CSV should have all races in the same sheet and the labels for Scattering should be:
party: blank
candidate: Scattering
and for Blank/Void
party: blank
candidate: Blank/Void
Hey, FYI, been busy but I'm basically doing a race a day (US president, then Senate, etc)
Tried to push again just so you could see where I was at and it didn't go through. Will try again. With Devin watching, so I'll have a guide to the terrain. :)
@GulliverDataJournalist no worries - I've sent you an email invite that should allow you to push.