2020 GE Official Precinct Results Sources by State

[jimrtex]

Texas: 11/22/20 Update- 21/254 Counties

11/22/20- Added Bell, Brazos, Ellis, Galveston, Guadalupe, Hays, Jefferson, Lubbock, McLennan, Montgomery, Webb

Adding a few of the largest counties just for starters. (I'll keep adding to the list. Back in 2018 I believe I was only able to track down about 50% of the Counties in Texas for official online precinct results)

To paraphrase a Gary Nunn song: "you can ask me what I hate about Texas... it's the precincts lines Statewide. Everything between the Sabine and Rio Grande.... you ask me what I love about Texas, and I can be here all.... night...long"  

Bell County:

https://results.enr.clarityelections.com/TX/Bell/107173/web.264614/#/summary

Brazos County:

http://www.brazosvotes.org/sites/default/files/inline-files/Brazos%20County%20November%202020%20General%20Canvass%20Report-11-12-2020%2011-00-39%20AM.pdf

Cameron County:

https://www.cameroncounty.us/elections/wp-content/uploads/2020/11/GN20-PCT-BY-PCT_202011101648.pdf

Collin County:

Scroll down and click on the Statement of Votes Cast at the bottom of the page.
I would post the full URL, but it would blow up the size of the Atlas Page.

https://www.collincountytx.gov/elections/election_results/Pages/default.aspx

Dallas County:

*** Download the precinct zip file ***

https://www.dallascountyvotes.org/election-results-and-maps/election-results/historical-election-results/#Election

Denton County:

Standard ENR engine. Click on precincts on the right of the webpage.

https://results.enr.clarityelections.com/TX/Denton/105530/web.264614/#/summary

El Paso County:

https://el-paso-county-elections.s3.amazonaws.com/documents/files/000/003/188/original/Official_Final_Precinct_by_Precinct_Results.pdf?1605641831

Ellis County:

https://www.co.ellis.tx.us/996/November-3-2020-General-and-Special-Elec

Fort Bend County:

https://www.fortbendcountytx.gov/home/showdocument?id=56566

Galveston County:

https://results.enr.clarityelections.com/TX/Galveston/106269/web.264614/#/summary

Guadalupe County:

https://www.co.guadalupe.tx.us/elections/PastElectionResults/2020/nov/3/general_election_pctbypct-official_results.pdf

Harris County:

https://www.harrisvotes.com/HISTORY/20201103/Official%20Canvass.pdf

Hays County:

https://hayscountytx.com/departments/elections/election-results/

Hidalgo County:

https://www.hidalgocounty.us/DocumentCenter/View/42882/County-Precinct-Results-11-13-2020-12-19-54-PM

Jefferson County:

https://results.enr.clarityelections.com/TX/Jefferson/107172/web.264614/#/summary

Lubbock County:

https://www.votelubbock.org/election-information/historical-election-results/

McLennan County:

http://www.co.mclennan.tx.us/Archive.aspx?ADID=1742

Montgomery County:

http://elections.mctx.org/pdf/GEN110320/Unofficial%20Precinct%20Report.pdf?ts=88346

Randall County:

https://randallcounty.com/DocumentCenter/View/1435/11-03-2020-General-Election-Canvass-Results

Tarrant County:

Typical ENR engine... Precinct downloads on the Right.

https://results.enr.clarityelections.com/TX/Tarrant/105205/web.264614/#/summary

Travis County:

https://countyclerk.traviscountytx.gov/images/pdfs/election_results/2020.11.03/G20%20Final%20Precinct.pdf

Webb County:

http://www.webbcountytx.gov/ElectionsAdministration/PctByPctResults/default.aspx

This is through largest 33 counties.

Bexar County:

PDF:

https://www.bexar.org/DocumentCenter/View/28533/November-3-2020-General-Election-by-Precinct

Text File:

https://www.bexar.org/DocumentCenter/View/28546/November-3-2020-General-Election-by-Precinct-Text-File

Text File Format:

https://www.bexar.org/DocumentCenter/View/28547/Election-by-Precinct-Text-File-Layout

Williamson County:

Note: Early Voting in Person is separate from Early Voting by Mail + Election Day

https://www.wilco.org/Portals/0/Departments/Elections/1120/20201116%20-%20Final%20Precinct-Level%20Report.pdf

Brazoria County:

Precinct Report

https://www.brazoriacountyclerk.net/home/showpublisheddocument?id=6795

Canvass Report

https://www.brazoriacountyclerk.net/home/showpublisheddocument?id=6791

Guadalupe County:

https://www.co.guadalupe.tx.us/elections/PastElectionResults/2020/nov/3/general_election_pctbypct-official_results.pdf

Comal County:

https://www.co.comal.tx.us/Vote/2020/11-03-2020/Results/Official%2020201103%20General%20Election%20Precinct%20by%20Precinct%20Results.pdf

Parker County:

xls inside zip. Might not be official but was November 13.

https://results.enr.clarityelections.com//TX/Parker/107164/271282/reports/detailxls.zip

No apparent precinct files for Nueces, Smith, Midland, Johnson, and Ector.

[jimrtex]

Edit: eliminated long URL for Hunt County

You rock--- awesome jimrtex!!!

I'll go ahead and update the Master Texas directory a bit later to include all of these updates so they are easy to find and alphabetical in one location for anyone doing research.

I believe for 2018 GE, I was able to track down official online precinct results for (82) Counties in TX before I started to hit a diminishing rate of returns, plus there are so many counties in TX doing online searches through county websites was taking an Hour each time just to pursue the missing ones...

So for example for MO 2020 GE, I just started with counties which I tracked down official results for the '18 GE to save myself, excess time, and will probably do the same with TX as well at some point for counties that other posters haven't already tracked down numbers for.

See Note at Bottom

Here are some more:

Gregg County:

xls inside zip. May not be official, but was as of November 13.

https://results.enr.clarityelections.com//TX/Gregg/107131/271405/reports/detailxls.zip

Potter County:

Precinct results are available by clicking on view contest detail.

https://results.enr.clarityelections.com/TX/Potter/107169/web.264623/#/summary

Rockwall County:

https://results.enr.clarityelections.com/TX/Rockwall/

Select results for November 2020 General Election. Precinct results are available by clicking on view contest detail.

Hunt County:

from:

http://www.huntcounty.net/page/hunt.election

click on November 3, General Election results.

Precinct results are available by clicking on view contest detail.


Victoria County:

https://results.enr.clarityelections.com/TX/Potter/107169/web.264623/#/summary

Precinct results are available by clicking on view contest detail.

Bastrop County:

https://results.enr.clarityelections.com/TX/Bastrop/107132/web.264614/#/summary

Precinct results are available by clicking on view contest detail.

Henderson County:

Listed as "unofficial"

https://www.henderson-county.com/home/showpublisheddocument?id=14992

Walker County:

Election precinct results are organized by Commissioners Precinct (every county in Texas has four county commissioners, and thus four commissioners precincts). A link to each of the four commissioners precincts are here:

https://www.co.walker.tx.us/department/division.php?structureid=141

Or the direct link to the four precincts are:

Precinct 1

https://www.co.walker.tx.us/egov/apps/document/center.egov?view=item;id=4373

Precinct 2

https://www.co.walker.tx.us/egov/apps/document/center.egov?view=item;id=4374

Precinct 3

https://www.co.walker.tx.us/egov/apps/document/center.egov?view=item;id=4375

Precinct 4

https://www.co.walker.tx.us/egov/apps/document/center.egov?view=item;id=4376


I found countywide, but not precinct results for Kaufman, Taylor, Wichita, Tom Green, Bowie, and Orange.

No countywide results found for Grayson, Liberty, Angelina, and Coryell.

I've gone through the 50 largest counties (73,000+), with 87% of the population.

Precinct canvasses must exist, since that is part of the state election law.

And now perusing the Texas Election Code (TEC 67.017), I find that these returns must be sent to the Secretary of State in electronic form, and that this has been the case since 2005.

I've sent an e-mail to the SOS asking about the 2018 returns, and when those for 2020 would be available.

[jimrtex]

[.) There are certain States which do not provide any type of centralized system (CA, UT, TX, MO, IN, PA, NJ, NY), where County level reporting is the only game in town.

I've got an update on TX. They're not like CA or NY.

4.) Maine is just weird, and maybe somebody can help sort me out on this.

I am assuming a City as large as Portland has Wards, in which case by my book even if that is lowest level of reporting would be the closest thing to a "precinct" for a decent sized town?

Maine elections are administered by each town (or city). Portland has election results reported for each polling place (it has 5 wards, and two or three polling places per ward. BUT most of the votes are listed as "CP" (about 27K for CP and 6K for the precincts).

You might not be able to get anything more useful for Maine than for towns (cities) even if you scanned the city web sites.

[jimrtex]

TEXAS

Texas 2020 Precinct Election Results are Here

https://drive.google.com/drive/folders/17RamU8sOERU8jM22X-rchIOeClbtZTOz?usp=sharing

An index of previous elections is here (it includes a link to the 2020 GE as well).

https://drive.google.com/drive/folders/1vxIpkpMF_Io93hHWv9l5o6c4zfQr8H1t?usp=sharing

It includes a combination of xls, pdf, csv, and txt files. Each county uploads their own.

The 2018 general election appears to be missing 71 counties mostly smaller.

The 2020 file is a work in progress. Counties have until December 7 to upload their files.

21 of the 71 counties that did not upload in 2018, have uploaded in 2020, while many of the larger counties have not done so yet. Maybe they are working at getting better compliance.

In smaller counties, the county clerk is The elections department as well as other duties. Preparing the electronic results may actually involve keying the results into a spreadsheet.

I'll work to get the format of the txt file and csv files.

[jimrtex]

jimrtex, Texas precinct-level results for 2018 can be found here: https://data.capitol.texas.gov/dataset/2018_general

Thanks. I figured the Legislative Council must have results since they manage the redistricting data. It looks like they have shapefiles as well.

The 2018 results were published in October 2019, so it may or may not be a while for 2020. It is possible that they will want to get that done sooner rather than later so it can be used for redistricting.

[jimrtex]

TEXAS

Texas 2020 Precinct Election Results are Here

https://drive.google.com/drive/folders/17RamU8sOERU8jM22X-rchIOeClbtZTOz?usp=sharing

An index of previous elections is here (it includes a link to the 2020 GE as well).

https://drive.google.com/drive/folders/1vxIpkpMF_Io93hHWv9l5o6c4zfQr8H1t?usp=sharing

It includes a combination of xls, pdf, csv, and txt files. Each county uploads their own.

The 2018 general election appears to be missing 71 counties mostly smaller.

The 2020 file is a work in progress. Counties have until December 7 to upload their files.

21 of the 71 counties that did not upload in 2018, have uploaded in 2020, while many of the larger counties have not done so yet. Maybe they are working at getting better compliance.

In smaller counties, the county clerk is The elections department as well as other duties. Preparing the electronic results may actually involve keying the results into a spreadsheet.

I'll work to get the format of the txt file and csv files.

Excellent work ferreting these out!

I have gone ahead and updated the master index at the top of the thread to link to the GoogleDrive site, and also hyperlinked to your post for your additional comments / context.

Question for you (and anyone else interested) should I delete the TX County list post as part of thread maintenance, or keep it around as a backup in case something happens to the Google Drive site?

The bigger counties (Top 4, and 9 of 14 haven't uploaded to the SOS website, but have been found on the county web sites, so I would keep the county links for now.

The precinct results are public information (it is a statutory requirement for the counties and SOS) so they won't be lost. I'm going to suggest they add a link to the SOS ELection Results web site. If they do, we can get rid of the cryptic Google Drive link.

In 2019, they added some requirements for county election officials to provide listings of polling locations, etc. on county websites. It was pointed out that not all counties have a website, and there are areas without any sort of broadband internet service. Anyone who doesn't know that early voting is at the courthouse, and that Bessie Mae takes off for lunch from 12:00 to 1 pm, is a stranger in town. If it were really urgent, you can find her at the Cafe. So they ended up having the counties upload polling locations and days and hours of operation to the SOS website. Now you can go to the SOS and find out that early voting is at the courthouse from 9-5 M-F.

[jimrtex]

Edit: Two more counties have reported to the SOS. I have spoilered them.

The Secretary of State now has precinct results from most of the counties we had identified on county websites. I have spoilered those counties, so that we still have the county links if we need to go back to them.

There are still 85 counties missing from the SOS website. But there is a file: pctcpct_dataentry... that appears to be precinct results from a bunch of smaller counties, 29 of which there is no separate file from the county (but there are few counties that are both in this file, and with a separate county file). I don't know if they differ, or which is authoritative.

Along with 8 counties which have precinct results on the county website, but not uploaded to the SOS website, we are down to 48 counties. The only one of much size is Nueces. I'm pretty sure we have 95%+ of all votes, maybe even more.



Texas:- 34/254 Counties

11/29/20 Update:- Added Bastrop, Bexar, Brazoria, Comal, Gregg, Henderson, Hunt, Parker, Potter,  Rockwall, Victoria, Walker, and Williamson.

Thanks jimrtex for tracking these down!!!!

Here is a link to his post, where there is some additional information posted which I did not include in the directory, but well worth reviewing for updates:

https://talkelections.org/FORUM/index.php?topic=412981.msg7800897#msg7800897

11/22/20- Added Bell, Brazos, Ellis, Galveston, Guadalupe, Hays, Jefferson, Lubbock, McLennan, Montgomery, Webb

Adding a few of the largest counties just for starters. (I'll keep adding to the list. Back in 2018 I believe I was only able to track down about 50% of the Counties in Texas for official online precinct results)

Spoiler alert! Click Show to show the content.

Show

Bastrop County:

https://results.enr.clarityelections.com/TX/Bastrop/107132/web.264614/#/summary

Precinct results are available by clicking on view contest detail.

Bell County:

https://results.enr.clarityelections.com/TX/Bell/107173/web.264614/#/summary

Bexar:

PDF:

https://www.bexar.org/DocumentCenter/View/28533/November-3-2020-General-Election-by-Precinct

Text File:

https://www.bexar.org/DocumentCenter/View/28546/November-3-2020-General-Election-by-Precinct-Text-File

Text File Format:

https://www.bexar.org/DocumentCenter/View/28547/Election-by-Precinct-Text-File-Layout

Spoiler alert! Click Show to show the content.

Show

Brazoria County:

Precinct Report

https://www.brazoriacountyclerk.net/home/showpublisheddocument?id=6795

Canvass Report

https://www.brazoriacountyclerk.net/home/showpublisheddocument?id=6791

Brazos County:

http://www.brazosvotes.org/sites/default/files/inline-files/Brazos%20County%20November%202020%20General%20Canvass%20Report-11-12-2020%2011-00-39%20AM.pdf

Cameron County:

https://www.cameroncounty.us/elections/wp-content/uploads/2020/11/GN20-PCT-BY-PCT_202011101648.pdf

Collin County:

Scroll down and click on the Statement of Votes Cast at the bottom of the page.
I would post the full URL, but it would blow up the size of the Atlas Page.

https://www.collincountytx.gov/elections/election_results/Pages/default.aspx

Comal County:

https://www.co.comal.tx.us/Vote/2020/11-03-2020/Results/Official%2020201103%20General%20Election%20Precinct%20by%20Precinct%20Results.pdf

Dallas County:

*** Download the precinct zip file ***

https://www.dallascountyvotes.org/election-results-and-maps/election-results/historical-election-results/#Election

Denton County:

Standard ENR engine. Click on precincts on the right of the webpage.

https://results.enr.clarityelections.com/TX/Denton/105530/web.264614/#/summary

El Paso County:

https://el-paso-county-elections.s3.amazonaws.com/documents/files/000/003/188/original/Official_Final_Precinct_by_Precinct_Results.pdf?1605641831

Spoiler alert! Click Show to show the content.

Show

Ellis County:

https://www.co.ellis.tx.us/996/November-3-2020-General-and-Special-Elec

Fort Bend County:

https://www.fortbendcountytx.gov/home/showdocument?id=56566

Spoiler alert! Click Show to show the content.

Show

Galveston County:

https://results.enr.clarityelections.com/TX/Galveston/106269/web.264614/#/summary

Gregg County:

xls inside zip. May not be official, but was as of November 13.

https://results.enr.clarityelections.com//TX/Gregg/107131/271405/reports/detailxls.zip

Guadalupe County:

https://www.co.guadalupe.tx.us/elections/PastElectionResults/2020/nov/3/general_election_pctbypct-official_results.pdf

Harris County:

https://www.harrisvotes.com/HISTORY/20201103/Official%20Canvass.pdf

Hays County:

https://hayscountytx.com/departments/elections/election-results/

Henderson County:

Listed as "unofficial"

https://www.henderson-county.com/home/showpublisheddocument?id=14992

Hidalgo County:

https://www.hidalgocounty.us/DocumentCenter/View/42882/County-Precinct-Results-11-13-2020-12-19-54-PM

Hunt County:

http://www.huntcounty.net/page/hunt.election

Spoiler alert! Click Show to show the content.

Show

Jefferson County:

https://results.enr.clarityelections.com/TX/Jefferson/107172/web.264614/#/summary

Lubbock County:

https://www.votelubbock.org/election-information/historical-election-results/

McLennan County:

http://www.co.mclennan.tx.us/Archive.aspx?ADID=1742

Montgomery County:

http://elections.mctx.org/pdf/GEN110320/Unofficial%20Precinct%20Report.pdf?ts=88346

Spoiler alert! Click Show to show the content.

Show

Parker County:

xls inside zip. Might not be official but was November 13.

https://results.enr.clarityelections.com//TX/Parker/107164/271282/reports/detailxls.zip

Potter County:

Precinct results are available by clicking on view contest detail.

https://results.enr.clarityelections.com/TX/Potter/107169/web.264623/#/summary

Randall County:

https://randallcounty.com/DocumentCenter/View/1435/11-03-2020-General-Election-Canvass-Results

Rockwall County:

https://results.enr.clarityelections.com/TX/Rockwall/

Select results for November 2020 General Election. Precinct results are available by clicking on view contest detail.

Spoiler alert! Click Show to show the content.

Show

Tarrant County:

Typical ENR engine... Precinct downloads on the Right.

https://results.enr.clarityelections.com/TX/Tarrant/105205/web.264614/#/summary

Travis County:

https://countyclerk.traviscountytx.gov/images/pdfs/election_results/2020.11.03/G20%20Final%20Precinct.pdf

Victoria County:

https://results.enr.clarityelections.com/TX/Potter/107169/web.264623/#/summary

Precinct results are available by clicking on view contest detail.

Walker County:

Election precinct results are organized by Commissioners Precinct (every county in Texas has four county commissioners, and thus four commissioners precincts). A link to each of the four commissioners precincts are here:

https://www.co.walker.tx.us/department/division.php?structureid=141

Webb County:

http://www.webbcountytx.gov/ElectionsAdministration/PctByPctResults/default.aspx

Williamson County:

Note: Early Voting in Person is separate from Early Voting by Mail + Election Day

https://www.wilco.org/Portals/0/Departments/Elections/1120/20201116%20-%20Final%20Precinct-Level%20Report.pdf

[jimrtex]

OK--- Here is an updated map of where I believe we currently are at with States & Counties reporting by Precinct, at least based upon current State & County links...

Light Gray is Texas, courtesy of the Google Drive links provided by jmrtex (Which if is likely missing some counties).

I've started going through Google Drive.

So far for ABCDEFGHIJKLMNOP(Q)RS (Anderson-Sutton)

219 total counties (86.2% done)
171 are in the Google Drive (which is just a collection of county files in a variety of formats)
13 located on county web sites
35 none located, though I am collecting links to county websites

These 30 represent 16.0% of counties, but 2.13% of the population (naughty Kaufman and Starr) (So I guess we can say 97.9% of returns are in). Unless the SOS can get them to upload their results, it will probably require phone calls or letters.

I need to check on the lege council web site as well. They compile the results for redistricting purposes, which would be the easiest to use when it is completed.

[jimrtex]

OK--- Here is an updated map of where I believe we currently are at with States & Counties reporting by Precinct, at least based upon current State & County links...

Light Gray is Texas, courtesy of the Google Drive links provided by jmrtex (Which if is likely missing some counties).

I've started going through Google Drive.

So far for ABCDEFGHIJKLMN (Anderson-Nueces)

178 total counties (70% done)
136 are in the Google Drive (which is just a collection of county files in a variety of formats)
12 located on county web sites
30 none located, though I am collecting links to county websites

These 30 represent 1.83% of the population (naughty Kaufman!) (So I guess we can say 98.2% of returns are in). Unless the SOS can get them to upload their results, it will probably require phone calls or letters.

I need to check on the lege council web site as well. They compile the results for redistricting purposes, which would be the easiest to use when it is completed.

Excellent work!

So probably what I will do later is go through and generated a map of Texas indicating reporting status to make it an easier visual reference.

Texas has so many counties that I can't even quantify how much time I spent searching county websites back after the 2018 election, so again this makes it so much easier for anyone trying to locate data being able to pull the vast majority of them off of the google drive!

I can do a map.

It would be a monumental task to normalize the data.

What is interesting is that most of the counties that don't have results, don't have their own website. Instead they use websites hosted by the association of counties. All they have to do is put links to files. It appears that the links are actually inserted by the niece of the county clerk who is taking a computer literacy class in high school. Depending on the timing she may be off to college when the general election came around, and so there may be results from the primaries in the spring or not the general elections. You may also find links to previous years elections but not 2020.

During the 2019 session, the LWV was complaining that there were not sample ballots on county web sites, or information about polling places, so voters who live in a county of 3000 people without internet service beyond dial-up would not know when or where to vote.

So they made counties post all this information on the county web site. Meanwhile the requirement to send to the SOS precinct canvass results has been in effect for a decade but is not enforced. I suspect that county election officials will forget to post sample ballots, etc. for the next election.

[jimrtex]

Edit: Reclassified Kimble and Pecos to pct_pct.

This is a final tally for all 254 counties.

format	counties	population	pop %
xlsx	39	9629810	32.86%
xls	8	154417	0.53%
xlsb	1	2126179	7.25%
txt	27	1150643	3.93%
csv	49	6487445	22.14%
asc	8	834196	2.85%
pdf	36	2962909	10.11%
xml	1	29060	0.10%
pct_pct	34	376750	1.29%
web	13	4969806	16.96%
none	38	586811	2.00%
	254	29308026	100.00%

I'll start from the bottom.

none 38 counties I could find no precinct results. This is 15.0% of counties, but the represent only 2.00% of the population.

I have included a link to the "elections" page or county clerk page. Some of these might not have entered the e-mail era (unless they still have an aol address). But you might be able to find a phone number or mailing address. In Texas, the default elections officer is the County Clerk, while the Tax Assessor/Collector is responsible for voter registration (this is a vestige of when there was  no voter registration, but you would simply show your poll tax receipt in order to vote).

A larger county may have a dedicated elections staff (or a staffer) under the county clerk, while in the smallest counties, the county clerk may be responsible for everything: marriage licenses, county records, etc. Some counties have a formal elections administrator. The county may decide to have an appointed elections administrator, who is appointed by the county clerk, the tax assessor/collector, the county judge, and the chairs of the Democratic and Republican parties. In the best cases, this may result in a hyper-nonpartisan technocrat (in one instance the elections administrator actually did not personally register to vote, so as to not have to choose a primary ballot). In other cases, it might be a little more partisan if four of the five appointers are from one party, elected on a partisan basis or a party chair, they are likely to also have some partisanship or less likely to act independently.

On some of the web sites there will be the summary results for the entire county. There might be precinct results, but not for November 2020. They likely exist if for no other reason that the vote counting machines produced the reports.

Footnote: In Texas, the county commissioners are elected from commissioners precincts. There are four commissioners in every county Loving (100 people) to Harris (4.75 million). Since election precincts can't cross commissioner precinct boundaries, every county has at least four election precincts. The commissioner precincts tend to be of similar area as well as roughly equal population. In many counties, the county commissioner is responsible for county facilities, particularly county roads in his commissioner precinct (I suspect in the smallest counties, a county road grader or dump truck is parked in his farm yard. A county barn is a building holding county vehicles. Redistricting involves not only making sure populations are balanced, but that facilities are balanced as well. In small counties, you may find all four precincts include part of the county seat (only town in the county, so as to balance population). In larger counties, the election precincts may be numbered based on commissioners precincts (101, ..., 201, ..., 301, ..., 401, ...).

This is illustrated for Washington County:

http://www.co.washington.tx.us/upload/page/0898/docs/Elections/new%20washington%20county%20map.pdf

The black-yellow-black lines separate commissioner precincts. The numbers in red are election precinct numbers (the precinct numbers run from 01 to 21, with the commissioner precinct as a prefix).

The commissioners precincts converge in Brenham, the county seat and largest town (see bottom inset). It appears that commissioners precincts 1 and 4 have had to expand at the expense of 2 and 3 to balance population.

Take particular attention to the secondary inset at the lower right (box in main inset). Election Precinct 307 crosses Election Precinct 104. Precinct 307 is only the width or Park Street, but where it dead-ends at Main Street is the Washington County Courthouse. The Precinct 3 commissioner can drive to the courthouse without leaving his district. This feature does not exist for the Precinct 2 commissioner.

Kaufman	138814	none	https://www.kaufmancounty.net/elections/about/
Starr	64930	none	http://www.co.starr.tx.us/page/starr.County.Clerk
Matagorda	36638	none	http://www.co.matagorda.tx.us/page/matagorda.Elections
Washington	36059	none	http://www.co.washington.tx.us/page/washington.Elections
Kleberg	30568	none	http://www.co.kleberg.tx.us/page/kleberg.Elections
Uvalde	26768	none	https://uvaldecounty.com/index.php/county/electionsadministrator
Willacy	21295	none	http://www.co.willacy.tx.us/page/willacy.Elections
Gonzales	20920	none	http://www.co.gonzales.tx.us/page/gonzales.County.Clerk
Lavaca	20226	none	https://www.co.lavaca.tx.us/page/lavaca.Elections
Freestone	19709	none	http://www.co.freestone.tx.us/page/freestone.Elections
Jackson	14816	none	http://www.co.jackson.tx.us/page/jackson.VotingElectionInformation
Newton	13526	none	http://www.co.newton.tx.us/page/newton.Elections
Lamb	12805	none	http://www.co.lamb.tx.us/page/lamb.ElectionsHome
Live Oak	12262	none	http://www.co.live-oak.tx.us/page/liveoak.Elections
Zavala	11853	none	http://www.co.zavala.tx.us/page/Elections
Dimmit	10134	none	http://www.dimmitcounty.org/departments/county-clerk/
Jack	8926	none	http://www.jackcounty.org/clerk/
McCulloch	7960	none	http://www.co.mcculloch.tx.us/page/mcculloch.ElectionInfo
Castro	7487	none	http://www.co.castro.tx.us/page/castro.County.Clerk
Childress	7327	none	http://www.childresscountytexas.us/
Presidio	6614	none	http://www.co.presidio.tx.us/page/presidio.Voting.Elections
San Saba	6049	none	http://www.co.san-saba.tx.us/page/sansaba.Elections
Delta	5339	none	https://www.deltacountytx.com/elections.html
Hudspeth	5000	none	http://www.co.hudspeth.tx.us/page/hudspeth.Elections
Mills	4867	none	https://www.co.mills.tx.us/page/mills.Elections
Mason	4295	none	http://www.co.mason.tx.us/page/mason.Elections
Sutton	3747	none	https://www.co.sutton.tx.us/government/county_offices/county_clerk/index.php
Upton	3682	none	http://www.co.upton.tx.us/page/upton.elections
Kinney	3673	none	http://www.co.kinney.tx.us/page/kinney.Elections
Knox	3660	none	https://www.knoxcountytexas.org/offices.htm
Lipscomb	3227	none	http://www.co.lipscomb.tx.us/page/lipscomb.ElectionInformation
Cochran	2831	none	http://www.co.cochran.tx.us/page/cochran.County.Clerk
Concho	2616	none	https://newtools.cira.state.tx.us/page/concho.Elections
Dickens	2192	none	http://www.co.dickens.tx.us/page/dickens.Elections
Edwards	1926	none	http://www.co.edwards.tx.us/page/edwards.electionsnew
Armstrong	1886	none	http://www.co.armstrong.tx.us/page/armstrong.County.Clerk
Glasscock	1424	none	http://www.co.glasscock.tx.us/page/glasscock.Elections
Kent	758	none	http://www.kentcountytexas.us/

[jimrtex]

web 13 counties have posted precinct results on the county web sites BUT not on the SOS web sites.

*Seven counties marked with asterisk are counties that were not on previous lists.

Bexar	2026968	web	https://www.bexar.org/DocumentCenter/View/28546/November-3-2020-General-Election-by-Precinct-Text-File
El Paso	842368	web	https://el-paso-county-elections.s3.amazonaws.com/documents/files/000/003/188/original/Official_Final_Precinct_by_Precinct_Results.pdf?1605641831
Fort Bend	830093	web	https://www.fortbendcountytx.gov/home/showdocument?id=56566
Montgomery	619686	web	http://elections.mctx.org/pdf/GEN110320/Unofficial%20Precinct%20Report.pdf?ts=88346
*Nueces	364084	web	https://www.nuecesco.com/Home/ShowDocument?id=27609
Rockwall	107069	web	https://results.enr.clarityelections.com/TX/Rockwall/
Hunt	99603	web	http://www.huntcounty.net/page/hunt.election
*Milam	24828	web	http://www.milamcounty.net/upload/page/8929/2020%20General%20Election.pdf
*Montague	19826	web	https://results.enr.clarityelections.com/TX/Montague/106712/web.264614/#/summary
*Bosque	18723	web	http://www.bosquecounty.us/bosquewebsite/wp-content/uploads/2020/11/Official-Results-PCT-by-PCT.pdf
*Hamilton	8457	web	http://www.co.hamilton.tx.us/upload/page/8825/Hamilton%20County%20Joint%20General%20Election%202020.pdf
*Jim Hogg	5192	web	http://www.co.jim-hogg.tx.us/upload/page/9452/2020%20Home/unofficial_election_precinct_results_11320.pdf
*Collingsworth	2909	web	http://www.co.collingsworth.tx.us/upload/page/8101/113general.pdf

[jimrtex]

Edit: Kimble and Pecos added in a new version of pct_pct file;

pctcpct_dataentry_20210122-1337.xlsx


pct_pct 34 counties are combined in a single file on the SOS Google Drive.

pctcpct_dataentry_20210122-1337.xlsx


There is another file with an earlier date, which appears to be the same data with fewer counties. I'm not sure what the nature of this file is. Perhaps instead of uploading the data in a file, election officials can enter the data directly in this file. But that seems like a lot of work since there are two rows per candidate (for all offices on the ballot - and there are lots of offices even for small counties).

A very few of these counties have other files on the SOS Google Drive. I'd probably use the pct_pct files since they are more easily accessible.

 

Van Zandt	56917	pct_pct
Val Verde	49037	pct_pct
Titus	32784	pct_pct
Calhoun	21283	pct_pct
Frio	20556	pct_pct
Falls	17251	pct_pct
Pecos	15849	pct_pct
Karnes	15664	pct_pct
Comanche	13609	pct_pct
Camp	13150	pct_pct
Rains	12644	pct_pct
Ward	12107	pct_pct
Sabine	10518	pct_pct
Brewster	9201	pct_pct
San Augustine	8186	pct_pct
Winkler	8083	pct_pct
Brooks	7082	pct_pct
Bailey	6987	pct_pct
Haskell	5638	pct_pct
Hansford	5382	pct_pct
Kimble	4315	pct_pct
Hardeman	3916	pct_pct
Baylor	3491	pct_pct
Real	3464	pct_pct
Crockett	3443	pct_pct
Donley	3242	pct_pct
Schleicher	2739	pct_pct
Jeff Davis	2268	pct_pct
Culberson	2153	pct_pct
Throckmorton	1490	pct_pct
Cottle	1389	pct_pct
Stonewall	1339	pct_pct
Sterling	1303	pct_pct
King	271	pct_pct

[jimrtex]

FYI, the file for Coke County, TX appears to be incomplete.

You are correct. I don't even think they are precinct results.

There appear to be three "units", beginning with the presidential results. But the total of those three is nowhere near enough to match the countywide results on the SOS web site.

Texas permits local authorities (cities, school districts, etc.) to hold elections in the spring or in November, and also in odd years. The spring uniform election date is independent of the partisan primaries. This year, there was an executive order that permitted the spring elections to be delayed until November (terms were extended), but this was optional.

The first "unit" included results from RLISD (Robert Lee ISD) and City (of Robert Lee).

The second "unit" included results from RLISD.

But both of these had results for County Commissioner Precinct 1. In Texas, commissioners for precinct 1 and 3 are elected in one election, and for 2 and 4 in the alternate election (for a four year term).

Election precincts can't cross county commissioner precinct lines, so even in the smallest counties there are at least four election precincts.

Historically city and school district elections were conducted independently from state and county elections. The city would conduct their election, as would the school districts (ISD), so it wouldn't matter whether the school district and city boundaries crossed election precinct lines - they were totally separated elections.

But there has been has been a move to joint elections conducted by county election officials. It would be a real hassle for Robert Lee or RLISD to hold their own elections. They would have to get the voting roll from the county, and then secure voting machines.

In a joint election, voters would go to there polling place, and if they lived in Robert Lee the ballot would include the city races, and if they lived in RLISD they would be given the ISD races. I don't know how it works in smaller counties. In Harris County, the voting machines magically produced the correct ballot based on combinations of races.

This is less of a problem than it might seem. Early voting is done on a countywide basis. In a small county like Coke, you would go to the courthouse in Robert Lee and vote. You would be given the correct ballot.

The first two "units" together appear to have about 1/4 of the countywide votes for president. They might together comprise all of election precinct 1.

The third "unit" includes city results for the city of Bronte (I think that is what "C: Bronte" stands for. There is no commissioners race so that it is likely from election precinct 2. The number of votes cast for mayor is nowhere close to the total votes cast for mayor, so the portion of the Bronte city results from precinct 4 are missing.

With four ISD's in part of the county, the two cities, and four commissioner precincts, it is a reasonable possibility of 12 ballot styles in the county.

Note of a county population of 3300, about 1000 live in Robert Lee and 1000 live in Bronte.


I mostly didn't look at the results on the SOS website. Some I checked if the file size was small. The results for McCulloch County are missing.

Because the results for Coke County are a visual image of a sheet of paper, the file is actually quite large (compared with PDF files with actual text results).

If it would help, I do have a spreadsheet with the formats for the various counties. Send me a PM with your e-mail address if you would like.

Are you producing a statewide data set by election precinct?

[jimrtex]

asc and txt and csv

On the SOS Google Drive site, 8 counties submitted .asc files, 27 submitted .txt files, and 49 submitted .csv files. These are all text files which should be readily readable into Excel.

The .asc and .txt files are fixed-length fields. I do not know if there is a consistent format among counties. I don't know if there is a difference between .asc and .txt files, but I'm pretty sure Excel will handle the difference.

The .csv files are commas separated value files. I don't know if there is a difference between the files.
 

Cameron	424537	asc
Webb	278788	asc
Lamar	49865	asc
Limestone	23441	asc
Jones	20074	asc
Leon	17453	asc
Morris	12344	asc
Goliad	7694	asc

 

Ellis	187681	txt
Guadalupe	169711	txt
Grayson	137455	txt
Bastrop	89899	txt
Angelina	86710	txt
Orange	83522	txt
Wilson	51732	txt
Navarro	50297	txt
Kendall	48570	txt
Erath	43087	txt
Tyler	21665	txt
Colorado	21543	txt
Moore	20862	txt
Andrews	19023	txt
Lee	17290	txt
Robertson	17111	txt
Scurry	16685	txt
Nolan	14674	txt
Parmer	9551	txt
Somervell	9180	txt
Coleman	8117	txt
Swisher	7360	txt
Carson	5905	txt
Hartley	5537	txt
Hemphill	3820	txt
Oldham	2117	txt
Briscoe	1539	txt

Dallas	2657253	csv
Collin	1055269	csv
Brazoria	379222	csv
Galveston	346260	csv
Brazos	231996	csv
Midland	180072	csv
Comal	160076	csv
Randall	139091	csv
Gregg	124123	csv
Potter	117118	csv
Liberty	89239	csv
Henderson	83074	csv
Coryell	75990	csv
Wise	70865	csv
San Patricio	66886	csv
Waller	56217	csv
Atascosa	51658	csv
Chambers	44545	csv
Cooke	41486	csv
Jim Wells	40453	csv
Hopkins	37240	csv
Howard	36798	csv
Hale	33179	csv
Bee	32622	csv
Palo Pinto	29275	csv
Fayette	25410	csv
Bandera	23325	csv
Llano	21997	csv
Gray	21833	csv
Gaines	21814	csv
Lampasas	21570	csv
Hutchinson	20832	csv
Eastland	18342	csv
Young	17966	csv
Zapata	14192	csv
Callahan	13975	csv
Red River	11955	csv
Duval	11107	csv
Clay	10448	csv
Archer	8512	csv
Dallam	7335	csv
Refugio	6913	csv
Martin	5850	csv
Floyd	5652	csv
Wheeler	5028	csv
Crane	4831	csv
Reagan	3888	csv
Fisher	3818	csv
Roberts	848	csv

[jimrtex]

jimrtex,

I've complied almost all of the available TX precinct data from the SOS Google Drive and county sites into a spreadsheet and have been contacting the remaining counties. Unfortunately, most have not gotten back to me yet.

The file for Liberty County on the Google Drive is laid out in a very strange format which I can't decipher easily. Do you have any insight there?

You must have some insight into stripping data out of PDF files. Are you working in alphabetical order? Have you got to San Jacinto?

I think Liberty County transferred their data from another file and in the process stripped precinct numbers. I am inferring this by the cryptic header names.

Column G: "Absentee" votes for candidate Column E, Office Column A (E/A)
Column I: Early voting for (E/A)
Column K: Election Day voting (E/A)
Column M: Total votes for (E/A)

Column O: "Absentee" votes for all candidates Office Column A
Column Q: Early voting (A)
Column S: Election Day Voting (A)
Column U: Election Day Voting (A)

The values in columns O, Q, S, U repeat for all candidates for an office (and may repeat for other offices, until there is a drop off).

If you total all values in Column M for Column E = "Trump/Pence" you will match the 23,302 shown on the SOS web site. This will also be true for other candidates.

Texas does not have "absentee voting". It has (1) early voting and (2) election day voting. Early voting has two forms: (1) by mail; and (2) in-person.

By mail is for cause only:
(1) Over age 65.
(2) Disability.
(3) Incarcerated in jail.
(4) Absent from county during early voting period and election day.

Some counties report mail voting and early voting separately, but the SOS combines them as early voting.

Some counties have an additional pseudo-precinct for election night reporting. See Coke County which has 4 precincts, but the SOS shows 5 precincts. Early votes can be counted on election day, and reported immediately after the polls close (early voting in person ends on Friday before the election). So you will often see a county reporting most of their votes with only one precinct reporting.

Some counties, including Liberty use what is called Countywide Voting, where voters can vote on election day at any polling place in the county, regardless of their precinct. In Liberty County in 2020, there were 20 countywide polling places. Though you can vote anywhere, the votes eventually are attributed back to the election precinct.

For this to be possible, the ballot must have the precinct number on it. In addition, a voter must be given the correct ballot based on their residence. The 2020 election had a number of local elections for cities (Ames, Cleveland, Daisetta, Dayton, Hardin, Liberty, and Plum Grove), school districts (Cleveland, Liberty, and Tarkington), and special districts (Raywood Drainage District). In addition, there were two county commissioner races, and a constable race. City and school district boundaries don't match election precincts boundaries.

So in addition to the the precinct, a ballot must include the ballot style (combination of races that a voter may vote on).

For Liberty County, there are 80 blocks of data that begin with the presidential race. Some of these have 35 rows, the number of races and candidates which were on the ballot countywide. But others have additional local races. I surmise that each block is a precinct-ballot style combination. I think they may be further grouped by precinct. But I couldn't figure out a pattern. I'm very sure that the first block is not for Precinct 1, which is a rural precinct in the extreme NE corner of the county.

The number of votes cast in the blocks varies wildly. The maximum is 2369, the mean 399, and the median 99.

There also some blocks with 1 or 2 votes. These might be overseas ballots, which can not vote in local races.

So there is precinct data, though in some cases it is divided among multiple blocks. So it is kind of like when they give the football scores:

    23-0, 14-13, 13-6

without the teams.

The good news is that the county elections website did have the precinct results from the primary runoff in July, so if you can contact them they should be able to get the precinct results. Some of the smaller counties are probably just getting dial phones.

p.s. Some counties have messed up the write-in results. Liberty County is probably one of them.

[jimrtex]

jimrtex,

I've complied almost all of the available TX precinct data from the SOS Google Drive and county sites into a spreadsheet and have been contacting the remaining counties. Unfortunately, most have not gotten back to me yet.

What does your spreadsheet look like? e.g. What are the columns?

[jimrtex]

jimrtex,

I've complied almost all of the available TX precinct data from the SOS Google Drive and county sites into a spreadsheet and have been contacting the remaining counties. Unfortunately, most have not gotten back to me yet.

What does your spreadsheet look like? e.g. What are the columns?

County, Precinct, Trump, Biden, Jorgensen, Hawkins, Write-in. I haven't been keeping the breakdown by EV/ED/Mail, but I may go back in and pull that at some point.

I was going to check whether I could match the results on the SOS website - that is can we duplicate the county canvass that was reported to the SOS.

So I was also including registered voters. Harris County reported registered voters with a text field, and missed a number of precincts which are shown on their web site canvass.

Harris also did not report votes for Brian Carroll. A number of counties botched the write-in count.

Any counties beyond Liberty and Coke that are not complete?

[jimrtex]

Mod: Updated status for Kimble and Pecos (but not map).

Here is apparent precinct availability for Texas:



White areas have no identified precinct data. All have a county clerk or county elections web site that would at least provide contact information.

Gold areas have precinct data on county websites, but not uploaded to SOS Google Drive. The data is in a variety of formats.

Green areas have precinct data uploaded to SOS Google Drive.

Bright Green have xlsx, xls, or xlsb for county or are incorporated into the pct_pct.xlsx file which is a spreadsheet with multiple counties.

Off-green have csv, asc, or txt files which should be readily readable into Excel, but may take a bit to figure out fields.

Yellow-green have PDF files, which will require parsing.

Blue (San Jacinto) has ballot images in XML format on SOS Google Drive. It is in a .zip file with over 12,000 files, one per ballot cast. It has a whole bunch of junk that reduces to 1 vote for Trump or Biden, and so on for all offices, from Precinct NNN.

Notes:

Coke is mostly not there. It might be better shown in white.

Gray has uploaded a new version of their .csv file. I don't know what changed.

Harris is missing some registration numbers, and write-in votes for Brian Carroll.

Liberty has stripped the precinct numbers. It is like football scores with the teams missing. 21-14, 13-3, 14-12(3Q), etc.


This is a link to a Google Drive maintained by the SOS where counties (are supposed to) upload their precinct results.

https://drive.google.com/drive/folders/17RamU8sOERU8jM22X-rchIOeClbtZTOz?usp=sharing

The file pctcpct_dataentry_20201207.xlsx is a composite of 34 counties.


38 Counties with no precinct data found. Links are to county clerk or county elections on county web site. You might not find anything more than a contact.

Armstrong	1886	none	http://www.co.armstrong.tx.us/page/armstrong.County.Clerk
Castro	7487	none	http://www.co.castro.tx.us/page/castro.County.Clerk
Childress	7327	none	http://www.childresscountytexas.us/
Cochran	2831	none	http://www.co.cochran.tx.us/page/cochran.County.Clerk
Concho	2616	none	https://newtools.cira.state.tx.us/page/concho.Elections
Delta	5339	none	https://www.deltacountytx.com/elections.html
Dickens	2192	none	http://www.co.dickens.tx.us/page/dickens.Elections
Dimmit	10134	none	http://www.dimmitcounty.org/departments/county-clerk/
Edwards	1926	none	http://www.co.edwards.tx.us/page/edwards.electionsnew
Freestone	19709	none	http://www.co.freestone.tx.us/page/freestone.Elections
Glasscock	1424	none	http://www.co.glasscock.tx.us/page/glasscock.Elections
Gonzales	20920	none	http://www.co.gonzales.tx.us/page/gonzales.County.Clerk
Hudspeth	5000	none	http://www.co.hudspeth.tx.us/page/hudspeth.Elections
Jack	8926	none	http://www.jackcounty.org/clerk/
Jackson	14816	none	http://www.co.jackson.tx.us/page/jackson.VotingElectionInformation
Kaufman	138814	none	https://www.kaufmancounty.net/elections/about/
Kent	758	none	http://www.kentcountytexas.us/
Kinney	3673	none	http://www.co.kinney.tx.us/page/kinney.Elections
Kleberg	30568	none	http://www.co.kleberg.tx.us/page/kleberg.Elections
Knox	3660	none	https://www.knoxcountytexas.org/offices.htm
Lamb	12805	none	http://www.co.lamb.tx.us/page/lamb.ElectionsHome
Lavaca	20226	none	https://www.co.lavaca.tx.us/page/lavaca.Elections
Lipscomb	3227	none	http://www.co.lipscomb.tx.us/page/lipscomb.ElectionInformation
Live Oak	12262	none	http://www.co.live-oak.tx.us/page/liveoak.Elections
Mason	4295	none	http://www.co.mason.tx.us/page/mason.Elections
Matagorda	36638	none	http://www.co.matagorda.tx.us/page/matagorda.Elections
McCulloch	7960	none	http://www.co.mcculloch.tx.us/page/mcculloch.ElectionInfo
Mills	4867	none	https://www.co.mills.tx.us/page/mills.Elections
Newton	13526	none	http://www.co.newton.tx.us/page/newton.Elections
Presidio	6614	none	http://www.co.presidio.tx.us/page/presidio.Voting.Elections
San Saba	6049	none	http://www.co.san-saba.tx.us/page/sansaba.Elections
Starr	64930	none	http://www.co.starr.tx.us/page/starr.County.Clerk
Sutton	3747	none	https://www.co.sutton.tx.us/government/county_offices/county_clerk/index.php
Upton	3682	none	http://www.co.upton.tx.us/page/upton.elections
Uvalde	26768	none	https://uvaldecounty.com/index.php/county/electionsadministrator
Washington	36059	none	http://www.co.washington.tx.us/page/washington.Elections
Willacy	21295	none	http://www.co.willacy.tx.us/page/willacy.Elections
Zavala	11853	none	http://www.co.zavala.tx.us/page/Elections

13 counties with precinct data on county website, but not on SOS Google Drive.

Bexar	2026968	web	https://www.bexar.org/DocumentCenter/View/28546/November-3-2020-General-Election-by-Precinct-Text-File
Bosque	18723	web	http://www.bosquecounty.us/bosquewebsite/wp-content/uploads/2020/11/Official-Results-PCT-by-PCT.pdf
Collingsworth	2909	web	http://www.co.collingsworth.tx.us/upload/page/8101/113general.pdf
El Paso	842368	web	https://el-paso-county-elections.s3.amazonaws.com/documents/files/000/003/188/original/Official_Final_Precinct_by_Precinct_Results.pdf?1605641831
Fort Bend	830093	web	https://www.fortbendcountytx.gov/home/showdocument?id=56566
Hamilton	8457	web	http://www.co.hamilton.tx.us/upload/page/8825/Hamilton%20County%20Joint%20General%20Election%202020.pdf
Hunt	99603	web	http://www.huntcounty.net/page/hunt.election
Jim Hogg	5192	web	http://www.co.jim-hogg.tx.us/upload/page/9452/2020%20Home/unofficial_election_precinct_results_11320.pdf
Milam	24828	web	http://www.milamcounty.net/upload/page/8929/2020%20General%20Election.pdf
Montague	19826	web	https://results.enr.clarityelections.com/TX/Montague/106712/web.264614/#/summary
Montgomery	619686	web	http://elections.mctx.org/pdf/GEN110320/Unofficial%20Precinct%20Report.pdf?ts=88346
Nueces	364084	web	https://www.nuecesco.com/Home/ShowDocument?id=27609
Rockwall	107069	web	https://results.enr.clarityelections.com/TX/Rockwall/

[jimrtex]

jimrtex,

I've complied almost all of the available TX precinct data from the SOS Google Drive and county sites into a spreadsheet and have been contacting the remaining counties. Unfortunately, most have not gotten back to me yet.

What does your spreadsheet look like? e.g. What are the columns?

County, Precinct, Trump, Biden, Jorgensen, Hawkins, Write-in. I haven't been keeping the breakdown by EV/ED/Mail, but I may go back in and pull that at some point.

Gray County has uploaded a new .csv file (January 14). Had you captured the old version, and if so, what has changed?

[jimrtex]

jimrtex,

I've complied almost all of the available TX precinct data from the SOS Google Drive and county sites into a spreadsheet and have been contacting the remaining counties. Unfortunately, most have not gotten back to me yet.

What does your spreadsheet look like? e.g. What are the columns?

County, Precinct, Trump, Biden, Jorgensen, Hawkins, Write-in. I haven't been keeping the breakdown by EV/ED/Mail, but I may go back in and pull that at some point.

Gray County has uploaded a new .csv file (January 14). Had you captured the old version, and if so, what has changed?

I don't see any differences between the two versions which I have.

It was kind of weird coming more than a month after the last file was posted which was at the "deadline" for submitting them.

[jimrtex]

How many precincts are missing for a national map to be created ?

I have official precinct-level results for all counties except: 37 in MO, 2 in MI, 4 in PA, 6 in NY, 5 in CA, 5 in IN, a bunch in KS (they should be releasing statewide precinct results within a few weeks) and TX, and whatever is going on in KY. I'm also waiting on NC to release their results with absentees assigned to polling places, which they usually release in January or February. There are also a handful of counties where I have the results, but am waiting on updated precinct maps.

To update this, I now have official precinct-level results for all counties except: 36 in TX, 16 in MO, 6 in NY, 4 in PA, 2 in CA, 1 in MI, and whatever is going on in KY.

Do you have maps (shapefiles) for Texas?

[jimrtex]

How many precincts are missing for a national map to be created ?

I have official precinct-level results for all counties except: 37 in MO, 2 in MI, 4 in PA, 6 in NY, 5 in CA, 5 in IN, a bunch in KS (they should be releasing statewide precinct results within a few weeks) and TX, and whatever is going on in KY. I'm also waiting on NC to release their results with absentees assigned to polling places, which they usually release in January or February. There are also a handful of counties where I have the results, but am waiting on updated precinct maps.

To update this, I now have official precinct-level results for all counties except: 36 in TX, 16 in MO, 6 in NY, 4 in PA, 2 in CA, 1 in MI, and whatever is going on in KY.

Do you have maps (shapefiles) for Texas?

I've found this file but haven't matched it to any data yet.

OK, I checked Harris County, the numbers appear to match except some precincts on the shapefile have multiple parts and include a suffix.

So precinct 0731 is portrayed as 0731A and 0731B shapefiles.

In some cases it looks like a case where a house district line zigged and senate district line zagged. In the past the three plans have been developed independently, and you will get some areas where one side of a street is House District A and Senate District Y; while the other side is House District B; and Senate District Z; but there might be a tiny area that is in House District A and Senate District Z.

Technically, these should be in different election precincts, but if they are non-populated with no voters so they can get merged.

0001B is 143 square meters (several could fit on a baseball infield). 0001A is 614 acres (almost a square mile, though clearly not a mile square). They might have tried to fix the boundary in the past but it got fixed on one map but not another.

Other multi-part precincts are in newly developed areas. It looks like precincts that have well-defined boundaries using streets built post-2010 get broken up when using the 2010 census geography which did not have those streets.

The lege council web site emphasizes that they are based on the 2010 Census Geography. It may be that they are planning on converting to the 2020 Census Geography as soon as it is released.

This might resolve some of these mismatches. For now you might have to merge the precinct parts and change the names if you going to join to election data, or perhaps join to the largest part. This would leave a few small holes with no election data.

Bexar has a few dozen precincts for which they do not report registered voters, but show zero votes cast. These are often along freeways where there might be a district boundary along a feeder that doesn't match up. So these will show up as holes in an election map.

Bexar also has some election data which don't match any geographical area. The regular precincts are numbered by commissioners precinct (1,2,3, and 4). But these start with 5 and 6, and appear to be limited ballots (federal only, or state only without local races). San Antonio has a large military population, so it is probably related.

[jimrtex]

Changed map: Switched from simple ramp to more of a S-Curve so there is greater differentiation in mid-ranges around 50% and less on extremes.

Greyed out precincts with no votes, and low votes (precincts with low votes tend to be anomalous. A 1:0 or 0:1 precinct is 100% or 0% for Trump. Precincts with few votes are likely to be statistically unstable (e.g. a 700:400 is more likely to reflect the political orientation of the area, than its 4:7 neighbor).

How many precincts are missing for a national map to be created ?

I have official precinct-level results for all counties except: 37 in MO, 2 in MI, 4 in PA, 6 in NY, 5 in CA, 5 in IN, a bunch in KS (they should be releasing statewide precinct results within a few weeks) and TX, and whatever is going on in KY. I'm also waiting on NC to release their results with absentees assigned to polling places, which they usually release in January or February. There are also a handful of counties where I have the results, but am waiting on updated precinct maps.

To update this, I now have official precinct-level results for all counties except: 36 in TX, 16 in MO, 6 in NY, 4 in PA, 2 in CA, 1 in MI, and whatever is going on in KY.

Do you have maps (shapefiles) for Texas?

I've found this file but haven't matched it to any data yet.

Here is a map for Harris County.



This is the process I used.

(1) Started with shapefile from lege council, and trimmed down to Harris County. Not totally necessary but a reduced data set.

(2) Converted .dbf file to .xlsx (or  (since Excel doesn't like writing .dbf file, and Excel is better for editing anyway).

(3) Trimmed suffix letter indicating multi-part VTD (new field). Moved election data (Trump and Biden votes) to .xlsx file, in effect duplicating it for multi-part VTD).

(4) Calculated Trump % of two way vote (I later found that I had to account for zero vote precincts, which I set to 50).

(5) Output .xlsx file as .csv file and joined to edited shapefile, and produced display using Trump% of two-way vote.

[jimrtex]

How many precincts are missing for a national map to be created ?

I have official precinct-level results for all counties except: 37 in MO, 2 in MI, 4 in PA, 6 in NY, 5 in CA, 5 in IN, a bunch in KS (they should be releasing statewide precinct results within a few weeks) and TX, and whatever is going on in KY. I'm also waiting on NC to release their results with absentees assigned to polling places, which they usually release in January or February. There are also a handful of counties where I have the results, but am waiting on updated precinct maps.

To update this, I now have official precinct-level results for all counties except: 36 in TX, 16 in MO, 6 in NY, 4 in PA, 2 in CA, 1 in MI, and whatever is going on in KY.

Do you have maps (shapefiles) for Texas?

Texas has added results for Kimble and Pecos counties in a new version of the PCT_PCT file on the SOS Google Drive. I have added these to the tables but not the map.

[jimrtex]

How many precincts are missing for a national map to be created ?

I have official precinct-level results for all counties except: 37 in MO, 2 in MI, 4 in PA, 6 in NY, 5 in CA, 5 in IN, a bunch in KS (they should be releasing statewide precinct results within a few weeks) and TX, and whatever is going on in KY. I'm also waiting on NC to release their results with absentees assigned to polling places, which they usually release in January or February. There are also a handful of counties where I have the results, but am waiting on updated precinct maps.

To update this, I now have official precinct-level results for all counties except: 36 in TX, 16 in MO, 6 in NY, 4 in PA, 2 in CA, 1 in MI, and whatever is going on in KY.

Do you have maps (shapefiles) for Texas?

I've found this file but haven't matched it to any data yet.

The 2020 Census Shapefiles appear to match (at least for Harris County).

I suspect that the Lege Council was the census liaison for VTD in Texas. The shapefiles that they had posted appear to be current election precincts using the 2010 Census Geography. Some precincts use streets that did not exist in 2010, so they were using a closest match.