Convert 2020 Primary Precinct Results

[dwillis]

If you want to work on a county, add a comment saying which one you'd like to work on or email openelections@gmail.com. You can either email us finished CSV files or submit a pull request, whatever is easiest.

The results files you'll be converting are in the California sources repository. Many of these are either PDFs or Excel files. For electronic PDFs, we recommend using Tabula, which is free, to extract data. The goal is to create a single CSV file for each county, with the following headers:

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

If the county file also provides a breakdown of votes by method, include those using the following headers:

early_voting, election_day, provisional, mail

For the following offices: U.S. Senate, U.S. House, and any state legislative races. File names should be: 20200303__ca__primary__{county_name}__precinct.csv, with the county name lower case and spaces replaced with underscores.

An example file from 2018 looks like this

• [x] Alameda
• [ ] Alpine
• [ ] Amador
• [ ] Butte
• [ ] Calaveras
• [ ] Colusa
• [ ] Contra Costa
• [ ] Del Norte
• [ ] El Dorado
• [ ] Fresno
• [ ] Glenn
• [ ] Humboldt
• [ ] Imperial
• [ ] Inyo
• [ ] Kern
• [ ] Kings
• [ ] Lake
• [ ] Lassen
• [ ] Los Angeles
• [ ] Madera
• [ ] Marin
• [ ] Mariposa
• [ ] Mendocino
• [ ] Merced
• [ ] Modoc
• [ ] Mono
• [ ] Monterey
• [ ] Napa
• [ ] Nevada
• [ ] Orange
• [ ] Placer
• [ ] Plumas
• [ ] Riverside
• [ ] Sacramento
• [ ] San Benito
• [ ] San Bernardino
• [ ] San Diego
• [ ] San Francisco
• [ ] San Joaquin
• [ ] San Luis Obispo
• [ ] San Mateo
• [ ] Santa Barbara
• [ ] Santa Clara
• [ ] Santa Cruz
• [ ] Shasta
• [ ] Sierra
• [x] Siskiyou
• [ ] Solano
• [ ] Sonoma
• [ ] Stanislaus
• [ ] Sutter
• [ ] Tehama
• [ ] Trinity
• [x] Tulare
• [x] Tuolumne
• [ ] Ventura
• [ ] Yolo
• [x] Yuba

[MartinRakacolli]

I can do Siskiyou county.

[dwillis]

@MartinRakacolli Thanks! I think they have an excel file: https://www.co.siskiyou.ca.us/sites/default/files/fileattachments/elections/page/6981/ele-20200325_state.statementofvotescastrpt.xlsx

If you want to reshape that into our CSV format, that would be great.

[goodasha]

I'll take Tulare

[goodasha]

I'll take Tulare

....months later, still plodding with this. For the Dem Pres results, there are columns for some candidates that only contain '***' - and that is only present sparsely.

Do these candidates get included (Nakia Anthony, Daphne Bradford, Willie Carter, Jeffrey Drobman, Robert Jordan, Michael Dename, Heather Stagg)?

[dwillis]

@goodasha thanks! You can skip those write-in candidates.

[goodasha]

I can take Yuba

[goodasha]

Skipping over Yuba and taking Tuolumne instead.

[carbonphyber]

I can take Yuba.

[goodasha]

I will give Colusa a try.

[carbonphyber]

I will take Imperial.