openelections / openelections-data-co

Pre-processed election results for Colorado elections
5 stars 11 forks source link

2016 Primary Election Precinct Results #34

Open dwillis opened 6 years ago

dwillis commented 6 years ago

Using Tabula, OCR or whatever method you can, parse precinct-level results for the following counties. Original sources can be found on most county websites.

The goal is to create a single CSV file for each county, with the following headers:

county, precinct, office, district, party, candidate, votes

For all federal and state races, including state legislature but excluding judicial contests.

The CSV files should be named 20160628__co__primary__{county}__precinct.csv

amanda-price commented 6 years ago

Working on Arapahoe county!

amanda-price commented 6 years ago

Working on El Paso and Routt county!

dsharps commented 6 years ago

Working on Adams, Alamosa, Archuleta and Baca counties.

amanda-price commented 6 years ago

dsharps, I couldn't find precinct level breakdowns of those counties, could you share where you found the information?

dsharps commented 6 years ago

amanda-price, hi! I'm a new volunteer and figuring out the ropes. I was only able to find precinct-level information for the 2008 Alamosa County primary. To summarize, for the 2016 primaries:

Adams: County-level Alamosa: County-level Arculeta: County-level Baca: County-level

Sorry if we duplicated efforts! Maybe I could start from the bottom of the list and work my way up, or let me know if you'd like to divide labor in any way.

dwillis commented 6 years ago

@amanda-price @dsharps this is my bad; I should have given Daron more guidance on where to start. I think dividing the counties is a great idea.

amanda-price commented 6 years ago

@dwillis @dsharps Yeah that's what I found for the primaries, that a majority of the counties didnt have precinct-level results. I went through the counties to find which one were precinct-level (attached below). There are a few counties where I couldn't find any results online, but didn't dig into Clarity to see if it was there. It may be that we need to bug some clerks :)

co_primaryworkbook_2016.xlsx

dsharps commented 6 years ago

@amanda-price Ooooo OK this is super helpful, thank you!! If it's OK with you, I can make phone calls to the clerks of 8 of the 15 counties that don't have results online (will move to the next set of 7 later, unless you beat me to it): Kiowa, Lake, Montezuma, Phillips, Prowers, Sedgwick, Summit, Washington. Sound like a plan?

amanda-price commented 6 years ago

@dsharps That sounds great! Definitely let me know how it goes, but that sounds like a great plan!

dsharps commented 6 years ago

@amanda-price FYI - I reached out directly to Kiowa, Lake, Montezuma, Phillips, Prowers, Sedgwick, Summit, and Washington counties. Of these, only Lake County had precinct-level results. I've uploaded that data and added source files wherever I could (even if they were at the county level; requested going back a few years if primary or general election data was missing from the source file).

Tomorrow, I'll start working through other counties that don't have results online: Bent, Chaffee, Cheyenne, Costilla, Hinsdale, Huerfano, Jackson!

dsharps commented 6 years ago

@amanda-price @dwillis OK! I've finally finished reaching out to all 16 counties on Amanda's spreadsheet that were marked as "no results online?" - Bent, Chaffee, Cheyenne, Clear Creek, Costilla, Hinsdale, Huerfano, Jackson, Kiowa, Lake, Montezuma, Phillips, Prowers, Sedgwick, Summit, and Washington. Of these, ONLY 3 had precinct-level results for 2016 - Hinsdale, Jackson, and Lake. I also updated the source file wherever I could, going back as far as possible.

Is there anything else I can do to help with the 2016 primary results? Happy to jump wherever I can be helpful.

dwillis commented 6 years ago

@dsharps @amanda-price thanks! I think that might be as far as we can get for the 2016 primary, unfortunately. It might be worth grabbing the 2018 primary precinct results if they have them, since it seems like a number of counties don't retain them.