2024 General Election Precinct 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 2024/counties/ folder in this repository and should have the following filename structure:

20241105__mi__general__{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
• U.S. Senate
• U.S. House
• State Senate
• State House
• County offices (including Sheriff and Register of Deeds)

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

[moonshiner]

Question - didn't I see you write up good experiences using TextExtract via AWS? Worth looking into ? (I may just to play with it)

[dwillis]

You did! https://thescoop.org/archives/2024/01/27/a-better-way-to-process-mississippi-precinct-results/