2014 General Precinct Results

dwillis commented 6 years ago

Using Tabula, OCR or whatever method you can, parse precinct-level results for the following counties. Original sources are in the sources-tx repository.

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 that using the following headers:

early_voting, election_day, provisional

Include the following offices:

Registered Voters (if available)
Ballots Cast (if available)
Straight Party
U.S. Senate
U.S. House
Governor
Lieutenant Governor
Attorney General
Comptroller of Public Accounts
Commissioner of the General Land Office
State Senator
State Representative

The CSV files should be named 20141104__tx__general__{county}__precinct.csv. Here's an example finished file from 2016: https://github.com/openelections/openelections-data-tx/blob/master/2016/20161108__tx__general__sabine__precinct.csv.

[x] Anderson
[x] Andrews
[x] Angelina
[x] Aransas
[x] Archer
[x] Armstrong
[x] Atascosa
[ ] Austin
[ ] Bailey
[x] Bandera
[x] Bastrop
[x] Baylor
[x] Bee
[x] Bell
[x] Bexar
[ ] Blanco
[x] Borden
[x] Bosque
[x] Bowie
[x] Brazoria
[x] Brazos
[x] Brewster
[x] Briscoe
[ ] Brooks
[x] Brown
[x] Burleson
[x] Burnet
[x] Caldwell
[x] Calhoun
[x] Callahan
[ ] Cameron
[x] Camp
[x] Carson
[x] Cass
[x] Castro
[x] Chambers
[x] Cherokee
[x] Childress
[x] Clay
[ ] Cochran
[x] Coke
[x] Coleman
[x] Collin
[x] Collingsworth
[x] Colorado
[x] Comal
[x] Comanche
[x] Concho
[x] Cooke
[x] Coryell
[x] Cottle
[x] Crane
[x] Crockett
[ ] Crosby
[ ] Culberson (requested results)
[x] Dallam
[x] Dallas
[ ] Dawson
[ ] Deaf Smith
[x] Delta
[x] Denton
[x] DeWitt
[ ] Dickens (requested results)
[ ] Dimmit
[x] Donley
[x] Duval
[x] Eastland
[x] Ector
[x] Edwards
[x] Ellis
[x] El Paso
[x] Erath
[x] Falls
[x] Fannin
[x] Fayette
[x] Fisher
[x] Floyd
[x] Foard
[x] Fort Bend
[x] Franklin
[x] Freestone
[x] Frio
[x] Gaines
[x] Galveston
[x] Garza
[x] Gillespie
[x] Glasscock
[ ] Goliad
[x] Gonzales
[x] Gray
[x] Grayson
[x] Gregg
[x] Grimes
[x] Guadalupe
[x] Hale
[ ] Hall
[x] Hamilton
[x] Hansford
[ ] Hardeman
[x] Hardin
[x] Harris
[x] Harrison
[x] Hartley
[x] Haskell
[x] Hays
[x] Hemphill
[x] Henderson
[x] Hidalgo
[x] Hill
[x] Hockley
[x] Hood
[x] Hopkins
[x] Houston
[x] Howard
[x] Hudspeth
[x] Hunt
[x] Hutchinson
[x] Irion
[x] Jack
[ ] Jackson
[ ] Jasper
[ ] Jeff Davis
[x] Jefferson
[ ] Jim Hogg
[x] Jim Wells
[x] Johnson
[x] Jones
[x] Karnes
[x] Kaufman
[x] Kendall
[x] Kenedy
[ ] Kent
[x] Kerr
[x] Kimble
[ ] King
[ ] Kinney
[x] Kleberg
[ ] Knox
[x] Lamar
[ ] Lamb
[x] Lampasas
[x] La Salle
[x] Lavaca
[x] Lee
[ ] Leon
[x] Liberty
[x] Limestone
[x] Lipscomb
[ ] Live Oak
[x] Llano
[ ] Loving
[x] Lubbock
[x] Lynn
[ ] McCulloch
[x] McLennan
[x] McMullen
[x] Madison
[x] Marion
[x] Martin
[ ] Mason
[x] Matagorda
[ ] Maverick
[x] Medina
[x] Menard
[x] Midland
[x] Milam
[ ] Mills
[x] Mitchell
[x] Montague
[x] Montgomery
[x] Moore
[ ] Morris
[ ] Motley
[x] Nacogdoches
[x] Navarro
[x] Newton
[x] Nolan
[x] Nueces
[x] Ochiltree
[x] Oldham
[x] Orange
[x] Palo Pinto
[x] Panola
[x] Parker
[ ] Parmer (requested results)
[x] Pecos
[x] Polk
[x] Potter
[ ] Presidio
[ ] Rains
[x] Randall
[x] Reagan
[ ] Real
[x] Red River
[ ] Reeves
[x] Refugio
[x] Roberts
[x] Robertson
[x] Rockwall
[x] Runnels
[x] Rusk
[x] Sabine
[x] San Augustine
[x] San Jacinto
[x] San Patricio
[ ] San Saba
[x] Schleicher
[x] Scurry
[x] Shackelford
[x] Shelby
[ ] Sherman
[x] Smith
[x] Somervell
[ ] Starr
[ ] Stephens
[x] Sterling
[x] Stonewall
[x] Sutton
[x] Swisher
[x] Tarrant
[x] Taylor
[ ] Terrell
[x] Terry
[ ] Throckmorton (county does not have results)
[x] Titus
[x] Tom Green
[x] Travis
[ ] Trinity (county does not have results)
[x] Tyler
[x] Upshur
[ ] Upton
[x] Uvalde
[x] Val Verde
[ ] Van Zandt
[x] Victoria
[x] Walker
[x] Waller
[ ] Ward
[x] Washington
[x] Webb
[x] Wharton
[x] Wheeler
[x] Wichita
[x] Wilbarger
[x] Willacy
[x] Williamson
[x] Wilson
[ ] Winkler
[x] Wise
[x] Wood
[x] Yoakum
[x] Young
[ ] Zapata
[ ] Zavala

timtrice commented 6 years ago

@dwillis , I have parsed Sabine county but have a couple of questions:

Early votes are not broken down by precinct. The example shown above has an "early_votes" column per precinct. Based on the original post I have ignored this variable. Is this correct?
Candidate is not broken down by party. Does this require manual lookup or is there a reference table available?
What types of offices do "district" apply? I can easily parse "US Rep", "Member State Board of Education", "State Senator", and "State Rep". I did not include "Chief Justice, 12th Court of Appeals District", "District Judge, 273rd Judicial District".

dwillis commented 6 years ago

Hey @timtrice, thanks!

Yeah, if Sabine doesn't have early votes broken out, you can skip that column (and election_day).
You can use this to lookup parties: http://elections.sos.state.tx.us/elchist175_state.htm
District applies to US Rep, State Senator and State Rep. You can skip the judicial races and board of education.

AngeloCioffi commented 6 years ago

Hey @dwillis! I'm working on the Fort Bend county data. I have a few questions:

Do we want registered voters and ballots cast as values to the office field and not their own columns? If so, I'm confused on what one of those rows would look like.
Fort Bend county has absentee ballot information. Is their anything we want to do with that information?

dwillis commented 6 years ago

Hi @AngeloCioffi! Thanks for your questions:

Yes! The row would look like this one: https://github.com/openelections/openelections-data-tx/blob/master/2014/20141104__tx__general__marion__precinct.csv#L4
Yes, if we have absentee votes, they would get a separate column like early votes or election day votes.

openelections / openelections-data-tx

2014 General Precinct Results #11