List of every city and town in the US 5

Posted by Jacob Atkins Mon, 21 Apr 2008 03:23:00 GMT

I am working on a project that I needed a list of every city and town with their state in the US.  It was a little hard to find one but once I did it had to be processed to remove all the crap that I did not need.  If I needed it I thought that someone else out there might need it so here it is.

The file is a comma-separated value or CSV file, it does not have a header, the format is:

ID,Name,State

Enjoy

Download it here

Comments

Leave a comment

  1. Marc 5 days later:

    Thanks for sharing! :)

  2. Sean Kelly 5 days later:

    How’d you make the list? Presumably it will be out of date at some point, so having a procedure on how to create/update the list would be just as helpful as having the list itself.

  3. Nimrod A 5 days later:

    Hi,

    Did you use TIGER data as your source? I’m really curious about how you came up with this list too. As what Sean Kelly says, this will be out of date at some time in the future. Creating and updating is important, but what’s even more important is being able to validate the accuracy of the list.

  4. Me 7 days later:

    Are there doubles?

    $ awk -F, ‘{ print $2,$3 }’ Listof_citiesandtownsin_US.csv | sort | uniq -c | sort -n

    31 times “Five Points” “PA”, 29 times “Oak Grove” “TN”, 27 times “Midway” “TX”, etc…

  5. Miki 7 days later:

    How about http://geonames.usgs.gov/domestic/download_data.htm?

Comments