2020 GE Official Precinct Results Sources by State

[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

[RI]

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?

[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?

[RI]

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.

[Skye]

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.

Hey RI, I noticed your spreadsheet doesn't include Montgomery county. I'm not sure if you forgot it or you just haven't compiled the data. Anyway, I did it myself, though I only included Biden, Trump, and the vote total. Not sure if you'd like for that one to be included.

[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?

[RI]

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.

[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.

[RI]

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.

[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?

[RI]

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.

[Sorenroy]

Just FYI, the North Carolina link is incorrect. The official general election results listed here do not sort absentee one-stop votes by precinct, so you'll notice if you go to "Results by Precinct" on any of those counties, there will be a significant number of votes still sorted by their early vote location. If you want to get the actual votes by precinct, you should use this link instead: https://www.ncsbe.gov/results-data/election-results/historical-election-results-data#precinct-sorted

[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.

[mileslunn]

Much like 2016, New York times has detailed precinct map although still some counties and states missing https://www.nytimes.com/interactive/2021/upshot/2020-election-map.html

[RI]

Much like 2016, New York times has detailed precinct map although still some counties and states missing https://www.nytimes.com/interactive/2021/upshot/2020-election-map.html

I built their complete 2016 precinct dataset, but they're attempting to fly solo this time around. I'm not particularly impressed so far.

[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.

[RI]

I've managed to wring precinct data out of several of the outstanding TX counties, but I'm still missing 23. I've called most of these counties and put in requests, but they've been slow to get back to me.

San Saba County said they weren't producing precinct data. Freestone County is requiring a request in writing and payment. When I called Mason County, they said they couldn't give me results as the county clerk was out with a serious case of COVID.

[jimrtex]

I've managed to wring precinct data out of several of the outstanding TX counties, but I'm still missing 23. I've called most of these counties and put in requests, but they've been slow to get back to me.

San Saba County said they weren't producing precinct data. Freestone County is requiring a request in writing and payment. When I called Mason County, they said they couldn't give me results as the county clerk was out with a serious case of COVID.

Have you been in contact with the SOS?

The reporting of the precinct data to the SOS is state law (Texas Election Code 67.017).

The data is also part of the county canvass and placed in the county election register. I'm wondering whether they can charge beyond duplication costs?

When I had discovered TEC 67.017, they replied that I was correct, that it was public information, and here were the links to the data.

[RI]

I've managed to wring precinct data out of several of the outstanding TX counties, but I'm still missing 23. I've called most of these counties and put in requests, but they've been slow to get back to me.

San Saba County said they weren't producing precinct data. Freestone County is requiring a request in writing and payment. When I called Mason County, they said they couldn't give me results as the county clerk was out with a serious case of COVID.

Have you been in contact with the SOS?

The reporting of the precinct data to the SOS is state law (Texas Election Code 67.017).

The data is also part of the county canvass and placed in the county election register. I'm wondering whether they can charge beyond duplication costs?

When I had discovered TEC 67.017, they replied that I was correct, that it was public information, and here were the links to the data.

Yes, I've contacted the TX SOS, who said it's on the counties; if they haven't uploaded it to the Google Drive, they don't have it yet. They plan to reach back out to the counties in the next couple of weeks.