Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

2020 Primary Precinct Election Results #29

Open
48 of 67 tasks
dwillis opened this issue Jul 18, 2020 · 1 comment
Open
48 of 67 tasks

2020 Primary Precinct Election Results #29

dwillis opened this issue Jul 18, 2020 · 1 comment

Comments

@dwillis
Copy link
Contributor

dwillis commented Jul 18, 2020 •
edited
Loading

Using Tabula, OCR or whatever method you can, parse precinct-level results for the following counties. Original sources are in the sources-pa repository.

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:

early_voting, election_day, provisional, absentee

Include the following offices:

  • Registered Voters (if available)
  • Ballots Cast (if available)
  • Straight Party
  • President
  • U.S. House
  • Attorney General
  • Auditor General
  • State Treasurer
  • State Senate
  • General Assembly

The CSV files should be named 20200602__pa__primary__{county}__precinct.csv. Here's an example finished file: https://github.com/openelections/openelections-data-pa/blob/master/2020/20200602__pa__primary__elk__precinct.csv.

  • Adams
  • Allegheny
  • Armstrong
  • Beaver
  • Bedford
  • Berks
  • Blair
  • Bradford
  • Bucks
  • Butler
  • Cambria
  • Cameron
  • Carbon
  • Centre
  • Chester
  • Clarion
  • Clearfield
  • Clinton
  • Columbia
  • Crawford
  • Cumberland
  • Dauphin
  • Delaware
  • Elk
  • Erie
  • Fayette
  • Forest
  • Franklin
  • Fulton
  • Greene
  • Huntingdon
  • Indiana
  • Jefferson
  • Juniata
  • Lackawanna
  • Lancaster
  • Lawrence
  • Lebanon
  • Lehigh
  • Luzerne
  • Lycoming
  • McKean
  • Mercer
  • Mifflin
  • Monroe
  • Montgomery
  • Montour
  • Northampton
  • Northumberland
  • Perry
  • Philadelphia
  • Pike
  • Potter
  • Schuylkill
  • Snyder
  • Somerset
  • Sullivan
  • Susquehanna
  • Tioga
  • Union
  • Venango
  • Warren
  • Washington
  • Wayne
  • Westmoreland
  • Wyoming
  • York
@lephead
Copy link

lephead commented Jul 19, 2020

Here is Erie
20200604_pa_primary_erie_precinct.xlsx

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@dwillis @lephead