openelections / openelections-data-pa

Pre-processed election results for Pennsylvania elections
21 stars 29 forks source link

In statewide precinct file, Delaware County precincts have one row for each vote method #82

Open mileswwatkins opened 3 years ago

mileswwatkins commented 3 years ago

Strangely, all vote methods are in a single row for the Delaware County county file, but in the statewide file here are some example county and precinct columns:

Delaware,ALDAN Eastern
Delaware,ALDAN Eastern - Federal
Delaware,ALDAN Eastern - Mail
Delaware,ALDAN Eastern - Prov
Delaware,ALDAN Western
Delaware,ALDAN Western - Federal
Delaware,ALDAN Western - Mail
Delaware,ALDAN Western - Prov
Delaware,ASTON 1W
Delaware,ASTON 1W - Federal
Delaware,ASTON 1W - Mail
Delaware,ASTON 1W - Prov

Each row has only one vote method counted.

dwillis commented 3 years ago

Ok, yeah, the county file has these, too. We'll clean things up.

UPDATE: this is a mess, and it's not totally clear that we can clear things up without some context from DelCo.

danabauer commented 3 years ago

I live in DelCo and have been looking at this (messy) county election data. Can I help track down info from DelCo elections folks?

dwillis commented 3 years ago

@danabauer thanks! I don't know if the elections office is open, but they have been almost singularly unresponsive to my attempts to contact them. basically, we're looking for an explanation of what this file represents:

https://github.com/openelections/openelections-sources-pa/blob/master/2020/general/2020%20Delaware%20County%2C%20PA%20precinct-level%20results.csv

Or, if they have a published report that includes the same information but with better labels/documentation, that would be great, too.

rootsmusic commented 2 years ago

@dwillis I don't know whether the numbers differ, but the County archived nicely formatted precinct-level reports at https://election.co.delaware.pa.us/eb/November_2020/index.html