Texas county FIPS codes
Every Texas county FIPS code with name, type, area, centre point and ZIP count, as CSV, Excel or JSON. Updated 19 November 2026.
Texas counties and FIPS codes
Texas has state FIPS code 48, and this list has 254 counties and county equivalents: 254 counties. Each full FIPS code joins the state code and a three-digit county code, so Anderson County is 48001: 48 for Texas and 001 for the county.
By area the largest is Brewster at about 15,896 km² (6,137 sq mi) and the smallest is Rockwall at about 385 km² (149 sq mi); the counties add up to about 685,327 km². Harris has the most ZIP codes assigned to it (232).
All 254 counties
| FIPS | Name | Type | Area km² | Latitude | Longitude | ZIP codes |
|---|---|---|---|---|---|---|
| 48001 | Anderson County | County | 2,772 | 31.836324 | -95.645228 | 13 |
| 48003 | Andrews County | County | 3,885 | 32.304906 | -102.637566 | 1 |
| 48005 | Angelina County | County | 2,325 | 31.284599 | -94.638502 | 9 |
| 48007 | Aransas County | County | 708 | 28.2235 | -96.874192 | 3 |
| 48009 | Archer County | County | 2,398 | 33.615157 | -98.687709 | 5 |
| 48011 | Armstrong County | County | 2,366 | 34.965036 | -101.357405 | 2 |
| 48013 | Atascosa County | County | 3,164 | 28.903045 | -98.533727 | 9 |
| 48015 | Austin County | County | 1,720 | 29.923783 | -96.24671 | 9 |
| 48017 | Bailey County | County | 2,186 | 34.068796 | -102.834108 | 3 |
| 48019 | Bandera County | County | 2,072 | 29.763429 | -99.245466 | 5 |
| 48021 | Bastrop County | County | 2,325 | 30.092253 | -97.306887 | 8 |
| 48023 | Baylor County | County | 2,333 | 33.616144 | -99.213426 | 1 |
| 48025 | Bee County | County | 2,280 | 28.361527 | -97.706056 | 9 |
| 48027 | Bell County | County | 2,818 | 31.052417 | -97.47182 | 23 |
| 48029 | Bexar County | County | 3,255 | 29.432366 | -98.526495 | 96 |
| 48031 | Blanco County | County | 1,848 | 30.276357 | -98.404217 | 4 |
| 48033 | Borden County | County | 2,346 | 32.743311 | -101.431805 | 1 |
| 48035 | Bosque County | County | 2,730 | 31.912935 | -97.623945 | 9 |
| 48037 | Bowie County | County | 2,448 | 33.458454 | -94.535302 | 13 |
| 48039 | Brazoria County | County | 3,791 | 29.172269 | -95.414084 | 21 |
| 48041 | Brazos County | County | 1,442 | 30.679945 | -96.327332 | 16 |
| 48043 | Brewster County | County | 15,896 | 29.854053 | -103.254438 | 6 |
| 48045 | Briscoe County | County | 2,336 | 34.530037 | -101.208643 | 2 |
| 48047 | Brooks County | County | 2,442 | 27.033045 | -98.204091 | 2 |
| 48049 | Brown County | County | 2,444 | 31.754816 | -98.976807 | 9 |
| 48051 | Burleson County | County | 1,815 | 30.478438 | -96.637955 | 6 |
| 48053 | Burnet County | County | 2,632 | 30.807148 | -98.1813 | 4 |
| 48055 | Caldwell County | County | 1,416 | 29.8326 | -97.624292 | 7 |
| 48057 | Calhoun County | County | 1,458 | 28.511854 | -96.682737 | 4 |
| 48059 | Callahan County | County | 2,334 | 32.297458 | -99.373626 | 4 |
| 48061 | Cameron County | County | 2,471 | 26.133007 | -97.507103 | 21 |
| 48063 | Camp County | County | 582 | 32.997721 | -94.97158 | 2 |
| 48065 | Carson County | County | 2,395 | 35.402891 | -101.353945 | 4 |
| 48067 | Cass County | County | 2,493 | 33.067832 | -94.347268 | 11 |
| 48069 | Castro County | County | 2,329 | 34.52993 | -102.261625 | 4 |
| 48071 | Chambers County | County | 1,640 | 29.726212 | -94.538753 | 7 |
| 48073 | Cherokee County | County | 2,704 | 31.898085 | -95.196672 | 9 |
| 48075 | Childress County | County | 1,846 | 34.529386 | -100.207599 | 2 |
| 48077 | Clay County | County | 2,926 | 33.788599 | -98.202211 | 5 |
| 48079 | Cochran County | County | 2,028 | 33.606518 | -102.83069 | 3 |
| 48081 | Coke County | County | 2,405 | 31.88844 | -100.529793 | 4 |
| 48083 | Coleman County | County | 3,211 | 31.788164 | -99.457943 | 10 |
| 48085 | Collin County | County | 2,296 | 33.191606 | -96.572474 | 32 |
| 48087 | Collingsworth County | County | 2,384 | 34.964756 | -100.269659 | 4 |
| 48089 | Colorado County | County | 2,521 | 29.619823 | -96.520987 | 11 |
| 48091 | Comal County | County | 1,488 | 29.806878 | -98.224316 | 9 |
| 48093 | Comanche County | County | 2,454 | 31.932437 | -98.563966 | 6 |
| 48095 | Concho County | County | 2,593 | 31.332491 | -99.862235 | 5 |
| 48097 | Cooke County | County | 2,320 | 33.602855 | -97.288313 | 8 |
| 48099 | Coryell County | County | 2,738 | 31.390284 | -97.799315 | 12 |
| 48101 | Cottle County | County | 2,335 | 34.074245 | -100.282376 | 2 |
| 48103 | Crane County | County | 1,962 | 31.45857 | -102.511284 | 1 |
| 48105 | Crockett County | County | 7,202 | 30.72389 | -101.321405 | 1 |
| 48107 | Crosby County | County | 2,335 | 33.614549 | -101.299929 | 3 |
| 48109 | Culberson County | County | 9,891 | 31.443995 | -104.509155 | 1 |
| 48111 | Dallam County | County | 3,902 | 36.277664 | -102.602827 | 3 |
| 48113 | Dallas County | County | 2,353 | 32.766659 | -96.77748 | 165 |
| 48115 | Dawson County | County | 2,336 | 32.742256 | -101.947683 | 3 |
| 48117 | Deaf Smith County | County | 3,913 | 34.967093 | -102.608376 | 2 |
| 48119 | Delta County | County | 724 | 33.390961 | -95.695287 | 6 |
| 48121 | Denton County | County | 2,482 | 33.204541 | -97.117267 | 30 |
| 48123 | DeWitt County | County | 2,357 | 29.105945 | -97.298142 | 7 |
| 48125 | Dickens County | County | 2,345 | 33.616474 | -100.778877 | 4 |
| 48127 | Dimmit County | County | 3,457 | 28.422281 | -99.756708 | 4 |
| 48129 | Donley County | County | 2,418 | 34.965585 | -100.814019 | 3 |
| 48131 | Duval County | County | 4,650 | 27.683979 | -98.512674 | 5 |
| 48133 | Eastland County | County | 2,415 | 32.335196 | -98.838393 | 8 |
| 48135 | Ector County | County | 2,336 | 31.868974 | -102.542755 | 13 |
| 48137 | Edwards County | County | 5,479 | 29.956377 | -100.34338 | 3 |
| 48139 | Ellis County | County | 2,475 | 32.354394 | -96.800231 | 16 |
| 48141 | El Paso County | County | 2,583 | 31.796478 | -106.183103 | 145 |
| 48143 | Erath County | County | 2,823 | 32.246303 | -98.22435 | 6 |
| 48145 | Falls County | County | 2,004 | 31.25373 | -96.935682 | 6 |
| 48147 | Fannin County | County | 2,376 | 33.594366 | -96.102041 | 15 |
| 48149 | Fayette County | County | 2,480 | 29.849725 | -96.944971 | 13 |
| 48151 | Fisher County | County | 2,336 | 32.742971 | -100.402097 | 4 |
| 48153 | Floyd County | County | 2,570 | 34.072413 | -101.303191 | 5 |
| 48155 | Foard County | County | 1,778 | 33.96702 | -99.779803 | 1 |
| 48157 | Fort Bend County | County | 2,270 | 29.531108 | -95.780283 | 22 |
| 48159 | Franklin County | County | 763 | 33.173988 | -95.216954 | 3 |
| 48161 | Freestone County | County | 2,290 | 31.688219 | -96.155065 | 6 |
| 48163 | Frio County | County | 2,939 | 28.868007 | -99.108221 | 4 |
| 48165 | Gaines County | County | 3,878 | 32.740907 | -102.633546 | 3 |
| 48167 | Galveston County | County | 1,051 | 29.403799 | -95.058043 | 23 |
| 48169 | Garza County | County | 2,322 | 33.179627 | -101.298432 | 2 |
| 48171 | Gillespie County | County | 2,748 | 30.318259 | -98.946355 | 5 |
| 48173 | Glasscock County | County | 2,334 | 31.869225 | -101.520757 | 1 |
| 48175 | Goliad County | County | 2,214 | 28.663296 | -97.402638 | 4 |
| 48177 | Gonzales County | County | 2,771 | 29.457475 | -97.498017 | 10 |
| 48179 | Gray County | County | 2,407 | 35.401582 | -100.81253 | 5 |
| 48181 | Grayson County | County | 2,619 | 33.627376 | -96.672011 | 18 |
| 48183 | Gregg County | County | 718 | 32.475921 | -94.812148 | 15 |
| 48185 | Grimes County | County | 2,091 | 30.584629 | -95.987588 | 8 |
| 48187 | Guadalupe County | County | 1,854 | 29.561748 | -97.943253 | 9 |
| 48189 | Hale County | County | 2,603 | 34.070112 | -101.826847 | 7 |
| 48191 | Hall County | County | 2,342 | 34.530596 | -100.681072 | 4 |
| 48193 | Hamilton County | County | 2,166 | 31.687275 | -98.105462 | 4 |
| 48195 | Hansford County | County | 2,388 | 36.277658 | -101.35466 | 3 |
| 48197 | Hardeman County | County | 1,890 | 34.269413 | -99.769596 | 2 |
| 48199 | Hardin County | County | 2,263 | 30.315317 | -94.423581 | 9 |
| 48201 | Harris County | County | 4,561 | 29.850507 | -95.448519 | 232 |
| 48203 | Harrison County | County | 2,377 | 32.533019 | -94.30929 | 11 |
| 48205 | Hartley County | County | 3,811 | 35.839723 | -102.60534 | 2 |
| 48207 | Haskell County | County | 2,358 | 33.178186 | -99.730272 | 6 |
| 48209 | Hays County | County | 1,761 | 30.056032 | -98.035565 | 7 |
| 48211 | Hemphill County | County | 2,358 | 35.837423 | -100.270928 | 1 |
| 48213 | Henderson County | County | 2,429 | 32.192131 | -95.858442 | 11 |
| 48215 | Hidalgo County | County | 4,047 | 26.392632 | -98.243308 | 30 |
| 48217 | Hill County | County | 2,438 | 32.021025 | -97.177305 | 15 |
| 48219 | Hockley County | County | 2,353 | 33.606775 | -102.343072 | 8 |
| 48221 | Hood County | County | 1,130 | 32.436011 | -97.836601 | 6 |
| 48223 | Hopkins County | County | 2,057 | 33.147454 | -95.549142 | 9 |
| 48225 | Houston County | County | 3,274 | 31.337376 | -95.425889 | 6 |
| 48227 | Howard County | County | 2,342 | 32.305946 | -101.435502 | 5 |
| 48229 | Hudspeth County | County | 11,760 | 31.497374 | -105.385136 | 4 |
| 48231 | Hunt County | County | 2,282 | 33.144426 | -96.08266 | 13 |
| 48233 | Hutchinson County | County | 2,318 | 35.839918 | -101.3547 | 5 |
| 48235 | Irion County | County | 2,724 | 31.304883 | -100.982462 | 2 |
| 48237 | Jack County | County | 2,384 | 33.235418 | -98.172438 | 4 |
| 48239 | Jackson County | County | 2,195 | 28.964095 | -96.574851 | 7 |
| 48241 | Jasper County | County | 2,565 | 30.837481 | -94.020194 | 4 |
| 48243 | Jeff Davis County | County | 5,879 | 30.739197 | -104.130172 | 2 |
| 48245 | Jefferson County | County | 2,386 | 29.874948 | -94.168261 | 24 |
| 48247 | Jim Hogg County | County | 2,945 | 27.038483 | -98.711482 | 2 |
| 48249 | Jim Wells County | County | 2,240 | 27.781354 | -98.087047 | 6 |
| 48251 | Johnson County | County | 1,883 | 32.379829 | -97.364767 | 12 |
| 48253 | Jones County | County | 2,427 | 32.740076 | -99.87859 | 6 |
| 48255 | Karnes County | County | 1,951 | 28.888361 | -97.880164 | 8 |
| 48257 | Kaufman County | County | 2,084 | 32.600147 | -96.290265 | 10 |
| 48259 | Kendall County | County | 1,716 | 29.94662 | -98.716388 | 5 |
| 48261 | Kenedy County | County | 3,670 | 26.91345 | -97.762822 | 2 |
| 48263 | Kent County | County | 2,338 | 33.18111 | -100.777607 | 2 |
| 48265 | Kerr County | County | 2,869 | 30.097311 | -99.484049 | 6 |
| 48267 | Kimble County | County | 3,241 | 30.50062 | -99.748704 | 3 |
| 48269 | King County | County | 2,365 | 33.616678 | -100.255782 | 1 |
| 48271 | Kinney County | County | 3,510 | 29.354545 | -100.415836 | 1 |
| 48273 | Kleberg County | County | 2,287 | 27.397219 | -97.91186 | 3 |
| 48275 | Knox County | County | 2,273 | 33.615616 | -99.740608 | 4 |
| 48277 | Lamar County | County | 2,447 | 33.68859 | -95.567448 | 14 |
| 48279 | Lamb County | County | 2,635 | 34.068957 | -102.351652 | 8 |
| 48281 | Lampasas County | County | 1,833 | 31.214993 | -98.232833 | 4 |
| 48283 | La Salle County | County | 3,870 | 28.344444 | -99.099665 | 4 |
| 48285 | Lavaca County | County | 2,512 | 29.372456 | -96.923715 | 6 |
| 48287 | Lee County | County | 1,643 | 30.273957 | -96.913213 | 4 |
| 48289 | Leon County | County | 2,776 | 31.300108 | -95.999217 | 9 |
| 48291 | Liberty County | County | 3,049 | 30.163087 | -94.855128 | 11 |
| 48293 | Limestone County | County | 2,411 | 31.548526 | -96.575811 | 7 |
| 48295 | Lipscomb County | County | 2,411 | 36.277793 | -100.274044 | 5 |
| 48297 | Live Oak County | County | 2,796 | 28.335615 | -98.129607 | 5 |
| 48299 | Llano County | County | 2,511 | 30.71022 | -98.682976 | 8 |
| 48301 | Loving County | County | 1,634 | 31.845266 | -103.508704 | 1 |
| 48303 | Lubbock County | County | 2,332 | 33.610063 | -101.820428 | 32 |
| 48305 | Lynn County | County | 2,314 | 33.176919 | -101.816161 | 4 |
| 48307 | McCulloch County | County | 2,883 | 31.191373 | -99.347295 | 6 |
| 48309 | McLennan County | County | 2,748 | 31.550567 | -97.201937 | 32 |
| 48311 | McMullen County | County | 2,996 | 28.352736 | -98.567769 | 2 |
| 48313 | Madison County | County | 1,227 | 30.97457 | -95.92345 | 3 |
| 48315 | Marion County | County | 1,074 | 32.787203 | -94.394505 | 2 |
| 48317 | Martin County | County | 2,372 | 32.305436 | -101.951224 | 3 |
| 48319 | Mason County | County | 2,415 | 30.719834 | -99.226014 | 4 |
| 48321 | Matagorda County | County | 3,036 | 28.888712 | -96.008017 | 13 |
| 48323 | Maverick County | County | 3,185 | 28.793276 | -100.313149 | 4 |
| 48325 | Medina County | County | 3,449 | 29.345522 | -99.126645 | 9 |
| 48327 | Menard County | County | 2,338 | 30.898886 | -99.82063 | 3 |
| 48329 | Midland County | County | 2,336 | 31.869178 | -102.031584 | 11 |
| 48331 | Milam County | County | 2,705 | 30.795017 | -96.971337 | 8 |
| 48333 | Mills County | County | 1,873 | 31.507747 | -98.560608 | 4 |
| 48335 | Mitchell County | County | 2,373 | 32.306685 | -100.920986 | 3 |
| 48337 | Montague County | County | 2,444 | 33.674011 | -97.722405 | 7 |
| 48339 | Montgomery County | County | 2,787 | 30.340362 | -95.496338 | 25 |
| 48341 | Moore County | County | 2,355 | 35.837632 | -101.89332 | 4 |
| 48343 | Morris County | County | 646 | 33.120055 | -94.733615 | 5 |
| 48345 | Motley County | County | 2,563 | 34.073929 | -100.779818 | 3 |
| 48347 | Nacogdoches County | County | 2,406 | 31.651735 | -94.609298 | 13 |
| 48349 | Navarro County | County | 2,853 | 32.048829 | -96.470164 | 12 |
| 48351 | Newton County | County | 2,387 | 30.851716 | -93.723476 | 6 |
| 48353 | Nolan County | County | 2,366 | 32.303087 | -100.406169 | 5 |
| 48355 | Nueces County | County | 2,260 | 27.746439 | -97.734012 | 37 |
| 48357 | Ochiltree County | County | 2,381 | 36.278652 | -100.81567 | 3 |
| 48359 | Oldham County | County | 3,907 | 35.405698 | -102.604907 | 4 |
| 48361 | Orange County | County | 984 | 30.120349 | -93.908592 | 8 |
| 48363 | Palo Pinto County | County | 2,552 | 32.749046 | -98.299172 | 8 |
| 48365 | Panola County | County | 2,109 | 32.157448 | -94.303254 | 7 |
| 48367 | Parker County | County | 2,357 | 32.777965 | -97.805144 | 12 |
| 48369 | Parmer County | County | 2,330 | 34.530119 | -102.788762 | 4 |
| 48371 | Pecos County | County | 12,550 | 30.814907 | -102.731503 | 6 |
| 48373 | Polk County | County | 2,899 | 30.812567 | -94.854102 | 10 |
| 48375 | Potter County | County | 2,387 | 35.401346 | -101.894052 | 22 |
| 48377 | Presidio County | County | 9,873 | 30.017971 | -104.226176 | 3 |
| 48379 | Rains County | County | 644 | 32.875251 | -95.797095 | 3 |
| 48381 | Randall County | County | 2,388 | 34.965402 | -101.896886 | 9 |
| 48383 | Reagan County | County | 3,045 | 31.365315 | -101.52309 | 1 |
| 48385 | Real County | County | 1,821 | 29.805333 | -99.840585 | 3 |
| 48387 | Red River County | County | 2,785 | 33.62608 | -95.074183 | 6 |
| 48389 | Reeves County | County | 7,085 | 31.294239 | -103.743382 | 6 |
| 48391 | Refugio County | County | 2,080 | 28.397512 | -97.161683 | 5 |
| 48393 | Roberts County | County | 2,393 | 35.83843 | -100.813116 | 1 |
| 48395 | Robertson County | County | 2,180 | 31.033622 | -96.510336 | 7 |
| 48397 | Rockwall County | County | 385 | 32.897961 | -96.407719 | 4 |
| 48399 | Runnels County | County | 2,736 | 31.830122 | -99.976219 | 6 |
| 48401 | Rusk County | County | 2,430 | 32.107386 | -94.793516 | 13 |
| 48403 | Sabine County | County | 1,516 | 31.344019 | -93.855002 | 5 |
| 48405 | San Augustine County | County | 1,492 | 31.395408 | -94.170069 | 2 |
| 48407 | San Jacinto County | County | 1,665 | 30.547114 | -95.189842 | 4 |
| 48409 | San Patricio County | County | 1,795 | 28.014122 | -97.516745 | 10 |
| 48411 | San Saba County | County | 3,056 | 31.16234 | -98.824781 | 3 |
| 48413 | Schleicher County | County | 3,395 | 30.897628 | -100.538543 | 1 |
| 48415 | Scurry County | County | 2,350 | 32.745679 | -100.916457 | 6 |
| 48417 | Shackelford County | County | 2,371 | 32.735999 | -99.353954 | 2 |
| 48419 | Shelby County | County | 2,159 | 31.804692 | -94.147174 | 5 |
| 48421 | Sherman County | County | 2,392 | 36.277744 | -101.893386 | 2 |
| 48423 | Smith County | County | 2,494 | 32.353052 | -95.24449 | 22 |
| 48425 | Somervell County | County | 495 | 32.223843 | -97.77801 | 3 |
| 48427 | Starr County | County | 3,133 | 26.565161 | -98.77017 | 9 |
| 48429 | Stephens County | County | 2,387 | 32.73596 | -98.836221 | 2 |
| 48431 | Sterling County | County | 2,392 | 31.832106 | -101.04704 | 1 |
| 48433 | Stonewall County | County | 2,384 | 33.179163 | -100.253361 | 2 |
| 48435 | Sutton County | County | 3,767 | 30.497859 | -100.538246 | 1 |
| 48437 | Swisher County | County | 2,333 | 34.53025 | -101.735098 | 3 |
| 48439 | Tarrant County | County | 2,325 | 32.770107 | -97.291915 | 97 |
| 48441 | Taylor County | County | 2,382 | 32.301292 | -99.890256 | 18 |
| 48443 | Terrell County | County | 6,023 | 30.204437 | -102.070117 | 2 |
| 48445 | Terry County | County | 2,308 | 33.173778 | -102.335168 | 3 |
| 48447 | Throckmorton County | County | 2,371 | 33.177703 | -99.212372 | 2 |
| 48449 | Titus County | County | 1,066 | 33.241713 | -94.967301 | 4 |
| 48451 | Tom Green County | County | 3,989 | 31.390354 | -100.422534 | 16 |
| 48453 | Travis County | County | 2,651 | 30.260003 | -97.708324 | 80 |
| 48455 | Trinity County | County | 1,829 | 31.079 | -95.130766 | 6 |
| 48457 | Tyler County | County | 2,462 | 30.768214 | -94.384769 | 9 |
| 48459 | Upshur County | County | 1,543 | 32.73935 | -94.941933 | 6 |
| 48461 | Upton County | County | 3,214 | 31.367283 | -102.043056 | 3 |
| 48463 | Uvalde County | County | 4,040 | 29.35694 | -99.762405 | 6 |
| 48465 | Val Verde County | County | 8,233 | 29.943227 | -101.09699 | 7 |
| 48467 | Van Zandt County | County | 2,262 | 32.570137 | -95.833874 | 7 |
| 48469 | Victoria County | County | 2,276 | 28.799766 | -96.966493 | 11 |
| 48471 | Walker County | County | 2,078 | 30.713321 | -95.544674 | 11 |
| 48473 | Waller County | County | 1,301 | 29.92932 | -95.99822 | 5 |
| 48475 | Ward County | County | 2,019 | 31.511738 | -103.100226 | 5 |
| 48477 | Washington County | County | 1,660 | 30.218174 | -96.395687 | 5 |
| 48479 | Webb County | County | 8,600 | 27.695217 | -99.173296 | 10 |
| 48481 | Wharton County | County | 2,836 | 29.274254 | -96.183291 | 12 |
| 48483 | Wheeler County | County | 2,370 | 35.400978 | -100.269882 | 5 |
| 48485 | Wichita County | County | 1,673 | 33.988531 | -98.703423 | 13 |
| 48487 | Wilbarger County | County | 2,570 | 34.049034 | -99.271905 | 5 |
| 48489 | Willacy County | County | 1,536 | 26.460419 | -97.68456 | 7 |
| 48491 | Williamson County | County | 2,934 | 30.67771 | -97.637121 | 27 |
| 48493 | Wilson County | County | 2,093 | 29.169521 | -98.109644 | 6 |
| 48495 | Winkler County | County | 2,182 | 31.82681 | -103.048411 | 2 |
| 48497 | Wise County | County | 2,389 | 33.214967 | -97.65444 | 10 |
| 48499 | Wood County | County | 1,781 | 32.787159 | -95.38292 | 6 |
| 48501 | Yoakum County | County | 2,068 | 33.173446 | -102.827245 | 3 |
| 48503 | Young County | County | 2,411 | 33.175774 | -98.687705 | 5 |
| 48505 | Zapata County | County | 2,719 | 27.036506 | -99.163043 | 3 |
| 48507 | Zavala County | County | 3,370 | 28.866406 | -99.76074 | 3 |
No row matches. Clear the filter to see all.
File: texas-county-fips-codes.csv
Using FIPS codes
FIPS codes are the join key for most US county data, from Census population tables to election results and BLS unemployment files. Store them as five-character text even though Texas's codes start with 4: codes in states such as Alabama (01) and California (06) start with 0, and a number column drops that zero as soon as you combine states.
-- add county names to any table that has a 5-digit fips column
SELECT d.*, c.name AS county_name
FROM my_data d
LEFT JOIN county_fips c ON c.fips = d.fips
WHERE c.state = 'TX';In Excel, build the 5-digit code from two parts with =TEXT(A2,"00")&TEXT(B2,"000"), where A2 is the state code (48) and B2 the county code.
Where the data comes from
Names, types, areas and centre points come from Natural Earth's 1:10m admin-2 counties (version 5.1.1, public domain). We checked every FIPS code against the GeoNames admin-2 list: 254 of 254 match. ZIP counts come from the GeoNames postal code file on the Texas ZIP code page.
Data dictionary
| Column | Type | Meaning |
|---|---|---|
| fips | text | Five-digit county FIPS code |
| state_fips | text | Two-digit state FIPS code |
| county_fips | text | Three-digit county code within the state |
| name | text | Short name |
| full_name | text | Name with its type, e.g. 'Kent County' |
| type | text | County, Parish, Borough, City, Census Area, Planning Region… |
| state | text | Two-letter state code |
| state_name | text | State name |
| area_sq_km | number | Area in km² (Natural Earth; rounded) |
| latitude | number | Centre point latitude (Natural Earth) |
| longitude | number | Centre point longitude (Natural Earth) |
| zip_codes | number | ZIP codes assigned to it in the GeoNames postal list |
| wikidata_id | text | Wikidata item, for linking to other data |