countries-states-cities-database
countries-states-cities-database copied to clipboard
dr5hn
🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native la...
The cities in Western Visayas in the Philippines are all bunched up in the state Antique which is incorrect.
First I want to thank you for your nice work here! This is very useful. I lived in Wales for 2 years near Carmarthen, maybe I can help. The issue...
First let me thank you for all the work you've put into this and take this issue as an improvement "Croatia (Hrvatska)" - Should be named only "Croatia" "Netherlands The"...
The states: https://en.wikipedia.org/wiki/Provinces_of_Spain
**Hell's Kitchen** in US_NYC is a neighborhood area (Q840133). Its city would be "New York City". Wonder if there's an underlying issue causing this?! Will report if I find similar...
Hi Team , There are some state and cities which are not available into your code base. I will share a list of all those. can you please add into...
using this : select wikiDataId,count(*) from cities GROUP BY wikiDataId having count(1) > 1 result: wikidataId count(*) Q24554 2 Q24413 2 Q1050185 3 Q3492826 2 Q234600 9 Q1023786 5 Q6742405...
Are there any plans to generate SQL files to support importing the data into Microsoft SQL Server? I compared the SQL data with the CSV file and would prefer to...
cities.json file change id and states_id states.json file change id and country_id countries.json file change id
Some Italian "states" are, in reality, "boroughs". This makes that some cities are duplicated. For example this { "id": 137775, "name": "Città metropolitana di Milano", "latitude": "45.45186000", "longitude": "9.14586000" },...
