openelections/openelections-data-ny

2012 Primary Election Precinct Results

dwillis opened this issue · 0 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