Skip to content

2020 General Election Precinct Results #197

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
36 tasks done
dwillis opened this issue Nov 25, 2020 · 7 comments
Closed
36 tasks done

2020 General Election Precinct Results #197

dwillis opened this issue Nov 25, 2020 · 7 comments

Comments

@dwillis
Copy link
Contributor

dwillis commented Nov 25, 2020

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)
  • President
  • U.S. Senate
  • U.S. House
  • Secretary of State
  • State Treasurer
  • Attorney General
  • 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
@lephead
Copy link

lephead commented Dec 27, 2020

I will start working on these counties for you : Benton, Clackamas,Jefferson,Lake,Morrow,Sherman and Washington.

@zgordo
Copy link
Contributor

zgordo commented Dec 30, 2020

I can work on Tillamook.

@ashowalter
Copy link

Hey, sorry I dropped off after doing Clatsop & Marion. It looks like you still need Grant? Either I or one of my team mates will work on Grant unless we hear otherwise.

@lephead
Copy link

lephead commented Jan 5, 2021 via email

@ashowalter
Copy link

Grant is difficult to get if you have it.

On Mon, Jan 4, 2021 at 9:28 PM ashowalter @.***> wrote: Hey, sorry I dropped off after doing Clatsop & Marion. It looks like you still need Grant? Either I or one of my team mates will work on Grant unless we hear otherwise. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#197 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACMSGUQRJ4RAUTOU7FIRZ63SYKPPDANCNFSM4UC5XV3A .
-- John Mifflin

Already got it -- I had to call Grant county and cough up a small fee, but that's part of our budget.

@dwillis
Copy link
Contributor Author

dwillis commented Jan 5, 2021

@ashowalter awesome, thank you!

@dwillis
Copy link
Contributor Author

dwillis commented Jan 5, 2021

I'll take Washington

@dwillis dwillis closed this as completed Mar 27, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants