Open dwillis opened 3 years ago
I think Cheboygan County may be missing 20 votes for Trump. I summed his votes and compared it to the official results https://mielections.us/election/results/2020GEN_CENR.html. It could be that the state and county results aren't the same.
I think Monroe County may be missing 12 votes for Trump and and 5 votes for Biden for the same reason as above. The state election results document and county election results document aren't the same; the data in this repository does match the county election results document. https://www.co.monroe.mi.us/officials_and_departments/officials/county_clerk/elections.php
Started trying to match Michigan's precinct IDs to our GIS boundaries, and have seen this one class of issues in the CSVs so far. Thank again for extracting and providing these data!
Chocolay Township, Precinct 2
or Michigamme Township, Precinct 1
Marion Township, Precinct 1
for exampleMeyer Township, Precinct 1
for exampleWest Branch Township, Precinct 1
for exampleGrim Township, Precinct 1
for exampleLeland Township, Precinct 1
for exampleSt. Ignace Township, Precinct 1
Superior Township, Precinct 1
City of Holland, Ward 5, Precinct 11 (Ottawa)
Looks like the Kent County file has candidate name and party swapped (ie, CSV header and rows do not line up):
county,precinct,office,district,candidate,party,votes,election_day,absentee
...
Kent,"Ada Township, Precinct 1",President,,DEM,Joseph R. Biden,593,131,462
Kent,"Ada Township, Precinct 2",President,,DEM,Joseph R. Biden,1043,216,827
Kent,"Ada Township, Precinct 3",President,,DEM,Joseph R. Biden,512,100,412
Kent,"Ada Township, Precinct 4",President,,DEM,Joseph R. Biden,402,94,308
...
@mileswwatkins fixed in #38
Using Tabula, OCR or whatever method you can, parse precinct-level results for the following counties. Original sources are in individual county files in the sources-mi repository.
The goal is to create a single CSV file for each county, with the following headers:
county
,precinct
,office
,district
,party
,candidate
,votes
Here's an example of a finished CSV file. The files should go in the 2020 folder in this repository and should have the following filename structure:
20201103__mi__general__{county}__precinct.csv
, wherecounty
is the lower case version of the county name, with punctuation removed.If the county file also provides a breakdown of votes by method, include that using the following headers, where applicable:
early_voting
,election_day
,provisional
,mail
If there are other possible vote types, include them, using a lowercase version of the vote type with underscores instead of spaces for the column name.
Include the following offices:
If a county provides precinct results for Write-in candidates, they should be grouped in a single row for each precinct and office with a
candidate
value ofWrite-ins
.If a county provides Under Votes or Over Votes, those should be recorded in the same way, with a single row per precinct and office with
Over Votes
andUnder Votes
as thecandidate
values.