2018 Primary 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 folders in the sources-or 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.

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)
• U.S. House
• Governor
• State Senator
• State Representative

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.

• Baker
• Benton
• Clackamas
• Clatsop
• Columbia
• Coos
• Crook
• Curry
• Deschutes
• Douglas
• Gilliam
• Grant
• Harney
• Hood River
• Jackson
• Jefferson
• Josephine
• Klamath
• Lake
• Lane
• Lincoln
• Linn
• Malheur
• Marion
• Morrow
• Multnomah
• Polk
• Sherman
• Tillamook
• Umatilla
• Union
• Wallowa
• Wasco
• Washington
• Wheeler
• Yamhill

[acolter]

Working on Jackson primary.

[dwillis]

Am working on Marion & Multnomah