2022 General Election Official Precinct Results Conversion

[dwillis]

List of county websites here, and source files we've collected are found here.

The goal is to create a single CSV file for each county, with the following headers:

county, precinct, office, district, party, candidate, votes

If the county file also provides a breakdown of votes by method, include that using the following headers, as applicable:

early_voting, election_day, provisional, absentee, federal

The filename should be 20221108__ny__general__{county}__precinct.csv, where {county} is the name of the county in lower case.

Include the following offices:

• Registered Voters (if available)
• Ballots Cast (if available)
• Governor
• Attorney General
• Comptroller
• U.S. Senate
• U.S. House
• State Senate
• State Assembly

• [x] Albany
• [x] Allegany
• [x] Bronx
• [x] Broome
• [x] Cattaraugus
• [x] Cayuga
• [x] Chautauqua
• [x] Chemung
• [x] Chenango
• [x] Clinton
• [x] Columbia
• [x] Cortland
• [x] Delaware
• [x] Dutchess
• [x] Erie
• [x] Essex
• [x] Franklin
• [x] Fulton
• [x] Genesee
• [x] Greene
• [x] Hamilton
• [x] Herkimer
• [x] Jefferson
• [x] Kings
• [x] Lewis
• [x] Livingston
• [x] Madison
• [x] Monroe
• [x] Montgomery
• [x] Nassau
• [x] New York
• [x] Niagara
• [x] Oneida
• [x] Onondaga
• [x] Ontario
• [x] Orange
• [x] Orleans
• [x] Oswego
• [x] Otsego
• [x] Putnam
• [x] Queens
• [x] Rensselaer
• [x] Richmond
• [x] Rockland
• [x] St. Lawrence
• [x] Saratoga
• [x] Schenectady
• [x] Schoharie
• [x] Schuyler
• [x] Seneca
• [x] Steuben
• [x] Suffolk
• [x] Sullivan
• [x] Tioga
• [x] Tompkins
• [x] Ulster
• [x] Warren
• [x] Washington
• [x] Wayne
• [x] Westchester
• [x] Wyoming
• [x] Yates

[kdent]

Hi Derek, The description here has the order of the headers with 'party' followed by 'candidate', but in the two files that were already done the 'candidate' column goes before 'party'. Which is the right way to go or does it not matter?

[dwillis]

@kdent Hey Kyle, order doesn't matter as long as the columns are there.

[Rwmiletich]

Hey Derek, Rensselaer county complete. Moving onto Schenectady. 20221108__ny__general__rensselaer__precinct.csv

[dwillis]

@Rwmiletich thanks!

[Rwmiletich]

Ulster County finished too. 20221108__ny__general__ulster__precinct.csv

[warwickmm]

@Rwmiletich, can you enlighten me on where those links are actually pointing? Some of the components in the target URL (e.g., files/11083856) are unfamiliar to me, so I'm just curious.

[warwickmm]

Never mind, I forgot that was the result of just attaching a file in a comment here. :neutral_face:

[Rwmiletich]

No worries - if there’s a better way for me to upload completed sheets, I’d be happy to hear it. I’m basically completely new to GitHub, so any advice would be much appreciated.

[dwillis]

@Rwmiletich what you're doing is absolutely fine, so if that works for you it's all good.

[warwickmm]

Dropping the files here like you've been doing works just fine. Thanks! Sorry for the confusion.

[Rwmiletich]

Schenectady and Hamilton attached. Moving on to Lewis and Schuyler over the next few days.

20221108__ny__general__hamilton__precinct.csv 20221108__ny__general__schenectady__precinct.csv

[Rwmiletich]

20221108__ny__general__lewis__precinct.csv 20221108__ny__general__schuyler__precinct.csv

Lewis and Schuyler counties complete. Data requests in with Schohaire and Seneca Counties and moving on to Orleans and Essex Counties in the meantime.

[dwillis]

@Rwmiletich thanks! we do have files for Schoharie and Seneca in the sources repo: https://github.com/openelections/openelections-sources-ny/tree/master/2022/general

[Rwmiletich]

20221108__ny__general__orleans__precinct.csv 20221108__ny__general__seneca__precinct.csv 20221108__ny__general__essex__precinct.csv

Essex, Orleans, and Seneca Counties attached. Working on Schoharie and maybe one of the bigger counties this weekend.

[Rwmiletich]

20221108__ny__general__columbia__precinct.csv 20221108__ny__general__schoharie__precinct.csv 20221108__ny__general__wyoming__precinct.csv

Columbia, Schoharie, and Wyoming counties attached. Working on Dutchess and slowly gathering Suffolk.

[Rwmiletich]

20221108__ny__general__dutchess__precinct.csv

Dutchess County completed

[Rwmiletich]

20221108__ny__general__franklin__precinct.csv 20221108__ny__general__greene__precinct.csv 20221108__ny__general__herikimer__precinct.csv 20221108__ny__general__livingston__precinct.csv 20221108__ny__general__madison__precinct.csv Franklin, Greene, Herikimer, Livingston, and Madison complete

[Rwmiletich]

20221108__ny__general__onondaga__precinct.csv 20221108__ny__general__ontario__precinct.csv 20221108__ny__general__orange__precinct.csv 20221108__ny__general__monroe__precinct.csv 20221108__ny__general__niagara__precinct.csv 20221108__ny__general__oneida__precinct.csv Monroe, Niagara, Oneida, Onondaga, Ontario, and Orange counties complete. Moving onto Oswego through Saratoga next

[Rwmiletich]

20221108__ny__general__oswego__precinct.csv 20221108__ny__general__otsego__precinct.csv 20221108__ny__general__putnam__precinct.csv Oswego, Otsego, and Putnam complete. Moving on to Rockland, St. Lawrence, and Saratoga

[Rwmiletich]

20221108__ny__general__saratoga__precinct.csv 20221108__ny__general__stlawrence__precinct.csv 20221108__ny__general__rockland__precinct.csv Rockland, Saratoga, and St. Lawrence complete. Going to save Suffolk for last since it's such a monster. Moving on to Sullivan, Tompkins, Wayne, and Westchester.

[Rwmiletich]

20221108__ny__general__tompkins__precinct.csv 20221108__ny__general__wayne__precinct.csv 20221108__ny__general__westchester__precinct.csv 20221108__ny__general__sullivan__precinct.csv

Sullivan, Tompkins, Wayne, and Westchester. Suffolk is a pain in the ass to format but is in progress.

[Rwmiletich]

20221108__ny__general__suffolk__precinct.csv And finally suffolk. Taking a break but happy to do more volunteering after a few weeks.

[dwillis]

@Rwmiletich amazing, thank you for your efforts!