openelections/openelections-data-ny

2014 Primary Election Precinct Results

dwillis opened this issue ยท 3 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 2014 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'll start work on converting the 2014 primary files available in the sources repo and will make note of what's missing along the way.

I'll work on Ulster County

I'll work on Ulster County

Ok, I will start working on Ulster Co this weekend- really.