Where can I find an updated DB of countries, states and cities?
13th June 2013
My answer to Where can I find an updated DB of countries, states and cities? on Quora
This is a surprisingly complicated question. The first thing you might want to ask yourself is “what’s a country”—how do you deal with places on this List of states with limited recognition for example?
That said, data sets do exist that can help you with this. I’m a big fan of Yahoo!’s GeoPlanet dataset, which represents places around the world as a hierarchy. We use it as the basis for the geo features of our site Lanyrd—take a look at the breadcrumbs on Conferences in London | Conferences & Events | Lanyrd for example.
You can access GeoPlanet through the GeoPlanet API Yahoo! GeoPlanet™—YDN or using Yahoo!’s YQL API language: YQL Console
Yahoo! used to make a full dump of the GeoPlanet database available at Yahoo! GeoPlanet—YDN but they no longer publish it. However, there are copies of their old releases available on the Internet Archive: Internet Archive Search: geoplanet
More recent articles
- Slop is the new name for unwanted AI-generated content - 8th May 2024
- Weeknotes: more datasette-secrets, plus a mystery video project - 7th May 2024
- Weeknotes: Llama 3, AI for Data Journalism, llm-evals and datasette-secrets - 23rd April 2024
- Options for accessing Llama 3 from the terminal using LLM - 22nd April 2024
- AI for Data Journalism: demonstrating what we can do with this stuff right now - 17th April 2024
- Three major LLM releases in 24 hours (plus weeknotes) - 10th April 2024
- Building files-to-prompt entirely using Claude 3 Opus - 8th April 2024
- Running OCR against PDFs and images directly in your browser - 30th March 2024
- llm cmd undo last git commit - a new plugin for LLM - 26th March 2024
- Building and testing C extensions for SQLite with ChatGPT Code Interpreter - 23rd March 2024