2020 Presidential Primary Results

[dwillis]

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:

20200310__mi__primary__president__{county}__precinct.csv, where county 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:

• Registered Voters (if available)
• Ballots Cast (if available)
• President

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 of Write-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 and Under Votes as the candidate values.

• Alcona
• Alger
• Allegan
• Alpena
• Antrim
• Arenac
• Baraga
• Barry
• Bay
• Benzie
• Berrien
• Branch
• Calhoun
• Cass
• Charlevoix
• Cheboygan
• Chippewa
• Clare
• Clinton
• Crawford
• Delta
• Dickinson
• Eaton
• Emmet
• Genesee
• Gladwin
• Gogebic
• Grand Traverse
• Gratiot
• Hillsdale
• Houghton
• Huron
• Ingham
• Ionia
• Iosco
• Iron
• Isabella
• Jackson
• Kalamazoo
• Kalkaska
• Kent
• Keweenaw
• Lake
• Lapeer
• Leelanau
• Lenawee
• Livingston
• Luce
• Mackinac
• Macomb
• Manistee
• Marquette
• Mason
• Mecosta
• Menominee
• Midland
• Missaukee
• Monroe
• Montcalm
• Montmorency
• Muskegon
• Newaygo
• Oakland
• Oceana
• Ogemaw
• Ontonagon
• Osceola
• Oscoda
• Otsego
• Ottawa
• Presque Isle
• Roscommon
• Saginaw
• St. Clair
• St. Joseph
• Sanilac
• Schoolcraft
• Shiawassee
• Tuscola
• Van Buren
• Washtenaw
• Wayne
• Wexford

[aidanconnolly]

I've started converting the PDFs into CSVs. Should they just get added to the same directory as the PDFs? https://github.com/openelections/openelections-sources-mi/tree/master/2020

[dwillis]

@aidanconnolly Thanks Aidan! The converted files, which should look like this, go in the 2020 folder in this repository.

[aidanconnolly]

Okay. Pull requests aren't my specialty, but I think I've got three more counties in there for you. Let me know if anything should be different!

[dwillis]

@aidanconnolly thanks!