List of counties in Texas and the cities in those counties


I consider myself to be a somewhat savvy user of the main internet search engines.  However, I did not have any luck finding a nice compiled list of Texas counties and the respective cities that are in those counties.  Well actually there are some sites that will give you the data that you need but it will be given to you in pieces.  So instead of running 250+ queries for every county in Texas, by searching through several sites and piecing the information together I compiled a list of Texas counties and the cities within those Texas counties.

The list of Texas counties and the cities within the Texas counties is columnar.  It consists of two columns, the Texas county as the first column and the city inside that county in the second column.  In the first column, you will usually find multiple instances of the county name and a unique instance of the city name in the second column.  This is because the relationship of a city to a county is Many To One.  There are many cities in one county, usually anyway.

If you have a similar compilation for other states please share them.  I’m sure some poor sap like myself has spent a good amount of time searching for this information, so any contributions the public can make for other states is greatly appreciated.

Also, in the event you need the data pivoted, to where you have a city in a county per column, I will be posting that soon.  It is going to be part of my next post where I demonstrate the pivot and unpivot features of SQL Server.  Also, I’ll discuss how it came about compiling the list.

Enjoy the list of Texas counties and the cities inside these counties.

Click Here (Google Docs) to get the list in excel 97-2003 format.

Revised version (includes Rockwall – thanks Sharron)

10 Comments

Filed under Sharing Stuff

10 responses to “List of counties in Texas and the cities in those counties

  1. Caesar

    Hey Oscar. You ROCK! This is exactly what I needed and you saved me a bunch of time putting it together myself. Thanks Man. Much Appreciated!

  2. Sharron

    Hi Oscar, I found this blog post by doing a search for a list of texas cities by county. It was very helpful. However, would you mind adding the city of Rockwall (located in Rockwall county) to your list. Thanks so much.

  3. rpb

    thanks, just what I needed in a simple easy format!

  4. T

    hello oscar… I’m trying to download your list for TX counties and cityies within… but I’m unable to do so.. please advise… thanks!

    • Once you click on any of the links above, you will be taken to Google Docs. Then from the menu, click on File > Download or simply hold [Ctrl] + S. Then the file will begin downloading as an .xls file.

  5. MSL

    Good info.
    Appears that only the major communities are part of this list. Other populated areas of the county can be located at http://texas.hometownlocator.com/counties

  6. roundmot

    Thanks, Oscar. You saved me many hours of work. Much appreciated!

  7. BN

    Hmm…seems like hardly any of these sites lists the City of Yoakum in both DeWitt and Lavaca counties, of which it falls.

  8. Chad M

    I just pulled your list last week, and it seems that there are some other towns/counties missing. Also, as BN said many towns/cities that span across multiple counties are only listed under one. Like Mansfield where I live which is mainly in Tarrant but a few parts are in Ellis and Johnson counties. I am going to try and compile a more complete list and when I do so I will share on here.

Comment on this

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s