2012 General Election Precinct Results

[dwillis]

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

[GulliverDataJournalist]

I've got Chatauqua.

[GulliverDataJournalist]

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?

[dwillis]

@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 [email protected] 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

[GulliverDataJournalist]

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. :)

[dwillis]

@GulliverDataJournalist no worries - I've sent you an email invite that should allow you to push.