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.

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