I’m working on building business directories for specific cities on my Hyp3rL0cal project. I really needed a database of cities in the United States, rather than manually entering them as I am targeting each city.
I’m sure there are a lot of places I can go to find a list of cities, I wrote a harvest script for Wikipedia last time I needed this. This time I found an easy CSV download of US cities over at the Google Adwords API.
The US Cities CSV download has cities broken down by state, and provides metro name, code and the state abbreviation, and is available under a Creative Commons Attribution 3.0 License. Using the CSV I was able to quickly import into MySQL as well make a JSON representation for use in some of my projects that don’t use a database back-end.
I’m adding the Google Adwords API, US City CSV to my list of valuable datasets that CityGrid publishers can use in their web and mobile applications. Let me know if there are other datasets that you need, and I’ll see what I can do to find them.Cities / City / CSV / Data / Download / Metro / US