dr5hn / countries-states-cities-database

🌍 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 language, timezones (for countries), and more. #countries #states #cities
https://dr5hn.github.io/countries-states-cities-database/
Open Data Commons Open Database License v1.0
6.81k stars 2.44k forks source link

countries-states-cities-database/master/cities.json is missing location info. #790

Open luke-song opened 1 week ago

luke-song commented 1 week ago

The cities. Json is missing location information. Here is missing location information. Please add to the database.

[ { "id": 1, "name": "Bora Bora", "state_id": null, "state_code": null, "state_name": null, "country_id": 154, "country_code": "PF", "country_name": "French Polynesia", "latitude": "-16.500412", "longitude": "-151.741490", "wikiDataId": "Q34039", "flag": "🇵🇫", "destinationId": 1001, "iataCode": "BOB", "destinationName": "Bora Bora" }, { "id": 3, "name": "Maui", "state_id": 13, "state_code": "HI", "state_name": "Hawaii", "country_id": 233, "country_code": "US", "country_name": "United States", "latitude": "20.798362", "longitude": "-156.331925", "wikiDataId": "Q160309", "flag": "🇺🇸", "destinationId": 1003, "iataCode": "OGG", "destinationName": "Maui" }, { "id": 5, "name": "Fiji", "state_id": null, "state_code": null, "state_name": null, "country_id": 60, "country_code": "FJ", "country_name": "Fiji", "latitude": "-17.713371", "longitude": "178.065033", "wikiDataId": "Q712", "flag": "🇫🇯", "destinationId": 1005, "iataCode": "NAN", "destinationName": "Fiji" }, { "id": 8, "name": "Santorini", "state_id": 1, "state_code": "L", "state_name": "South Aegean", "country_id": 71, "country_code": "GR", "country_name": "Greece", "latitude": "36.393156", "longitude": "25.461509", "wikiDataId": "Q22890", "flag": "🇬🇷", "destinationId": 1008, "iataCode": "JTR", "destinationName": "Santorini" }, { "id": 9, "name": "Tahiti", "state_id": null, "state_code": null, "state_name": null, "country_id": 154, "country_code": "PF", "country_name": "French Polynesia", "latitude": "-17.650919", "longitude": "-149.426042", "wikiDataId": "Q34115", "flag": "🇵🇫", "destinationId": 1009, "iataCode": "PPT", "destinationName": "Tahiti" }, { "id": 10, "name": "Palawan", "state_id": 50, "state_code": "PH-PLW", "state_name": "Palawan", "country_id": 166, "country_code": "PH", "country_name": "Philippines", "latitude": "9.834949", "longitude": "118.738361", "wikiDataId": "Q837028", "flag": "🇵🇭", "destinationId": 1010, "iataCode": "PPS", "destinationName": "Palawan" }, { "id": 13, "name": "Barbados", "state_id": null, "state_code": null, "state_name": null, "country_id": 23, "country_code": "BB", "country_name": "Barbados", "latitude": "13.193887", "longitude": "-59.543198", "wikiDataId": "Q244", "flag": "🇧🇧", "destinationId": 1013, "iataCode": "BGI", "destinationName": "Barbados" }, { "id": 14, "name": "Turks and Caicos", "state_id": null, "state_code": null, "state_name": null, "country_id": 215, "country_code": "TC", "country_name": "Turks and Caicos Islands", "latitude": "21.694025", "longitude": "-71.797928", "wikiDataId": "Q30971", "flag": "🇹🇨", "destinationId": 1017, "iataCode": "PLS", "destinationName": "Providenciales" }, { "id": 15, "name": "St. Barths", "state_id": null, "state_code": null, "state_name": null, "country_id": 54, "country_code": "BL", "country_name": "Saint Barthélemy", "latitude": "17.913922", "longitude": "-62.833853", "wikiDataId": "Q25305", "flag": "🇧🇱", "destinationId": 1018, "iataCode": "SBH", "destinationName": "St. Barths" }, { "id": 16, "name": "Saint Martin", "state_id": null, "state_code": null, "state_name": null, "country_id": 60, "country_code": "MF", "country_name": "Saint Martin", "latitude": "18.0708", "longitude": "-63.0501", "wikiDataId": "Q25151", "flag": "🇲🇫", "destinationId": 1019, "iataCode": "SFG", "destinationName": "Saint Martin" }, { "id": 17, "name": "Aruba", "state_id": null, "state_code": null, "state_name": null, "country_id": 8, "country_code": "AW", "country_name": "Aruba", "latitude": "12.521110", "longitude": "-69.968338", "wikiDataId": "Q21203", "flag": "🇦🇼", "destinationId": 1014, "iataCode": "AUA", "destinationName": "Aruba" }, { "id": 19, "name": "Cayman Islands", "state_id": null, "state_code": null, "state_name": null, "country_id": 50, "country_code": "KY", "country_name": "Cayman Islands", "latitude": "19.3133", "longitude": "-81.2546", "wikiDataId": "Q5785", "flag": "🇰🇾", "destinationId": 1021, "iataCode": "GCM", "destinationName": "Grand Cayman" }, { "id": 20, "name": "Curaçao", "state_id": null, "state_code": null, "state_name": null, "country_id": 160, "country_code": "CW", "country_name": "Curaçao", "latitude": "12.169570", "longitude": "-68.990021", "wikiDataId": "Q25279", "flag": "🇨🇼", "destinationId": 1022, "iataCode": "CUR", "destinationName": "Curaçao" }, { "id": 21, "name": "St. Lucia", "state_id": null, "state_code": null, "state_name": null, "country_id": 196, "country_code": "LC", "country_name": "Saint Lucia", "latitude": "13.9094", "longitude": "-60.9789", "wikiDataId": "Q760", "flag": "🇱🇨", "destinationId": 1023, "iataCode": "UVF", "destinationName": "Hewanorra International Airport" }, { "id": 22, "name": "British Virgin Islands", "state_id": null, "state_code": null, "state_name": null, "country_id": 39, "country_code": "VG", "country_name": "British Virgin Islands", "latitude": "18.4207", "longitude": "-64.6400", "wikiDataId": "Q25305", "flag": "🇻🇬", "destinationId": 1024, "iataCode": "EIS", "destinationName": "Terrance B. Lettsome International Airport" }, { "id": 23, "name": "Lombok", "state_id": 1, "state_code": "NB", "state_name": "West Nusa Tenggara", "country_id": 103, "country_code": "ID", "country_name": "Indonesia", "latitude": "-8.650000", "longitude": "116.324943", "wikiDataId": "Q28560", "flag": "🇮🇩", "destinationId": 1025, "iataCode": "LOP", "destinationName": "Lombok" }, { "id": 24, "name": "Koh Lipe", "state_id": 83, "state_code": "83", "state_name": "Satun", "country_id": 216, "country_code": "TH", "country_name": "Thailand", "latitude": "6.490045", "longitude": "99.300337", "wikiDataId": "Q122034", "flag": "🇹🇭", "destinationId": 1026, "iataCode": "HDY", "destinationName": "Koh Lipe" }, { "id": 25, "name": "Saba", "state_id": null, "state_code": null, "state_name": null, "country_id": 179, "country_code": "BQ", "country_name": "Caribbean Netherlands", "latitude": "17.637546", "longitude": "-63.236006", "wikiDataId": "Q207429", "flag": "🇧🇶", "destinationId": 1027, "iataCode": "SAB", "destinationName": "Saba" }, { "id": 26, "name": "Aitutaki", "state_id": null, "state_code": null, "state_name": null, "country_id": 61, "country_code": "CK", "country_name": "Cook Islands", "latitude": "-18.830812", "longitude": "-159.774785", "wikiDataId": "Q152998", "flag": "🇨🇰", "destinationId": 1028, "iataCode": "AIT", "destinationName": "Aitutaki" }, { "id": 27, "name": "La Digue", "state_id": null, "state_code": null, "state_name": null, "country_id": 201, "country_code": "SC", "country_name": "Seychelles", "latitude": "-4.357493", "longitude": "55.827469", "wikiDataId": "Q139910", "flag": "🇸🇨", "destinationId": 1029, "iataCode": null, "destinationName": "La Digue" }, { "id": 28, "name": "Fakarava", "state_id": null, "state_code": null, "state_name": null, "country_id": 154, "country_code": "PF", "country_name": "French Polynesia", "latitude": "-16.315967", "longitude": "-145.614191", "wikiDataId": "Q641092", "flag": "🇵🇫", "destinationId": 1030, "iataCode": "FAV", "destinationName": "Fakarava" }, { "id": 29, "name": "Roatán", "state_id": null, "state_code": null, "state_name": null, "country_id": 95, "country_code": "HN", "country_name": "Honduras", "latitude": "16.329205", "longitude": "-86.537558", "wikiDataId": "Q148237", "flag": "🇭🇳", "destinationId": 1031, "iataCode": "RTB", "destinationName": "Roatán" }, { "id": 30, "name": "Isla Holbox", "state_id": 31, "state_code": "ROO", "state_name": "Quintana Roo", "country_id": 157, "country_code": "MX", "country_name": "Mexico", "latitude": "21.521757", "longitude": "-87.376138", "wikiDataId": "Q318960", "flag": "🇲🇽", "destinationId": 1032, "iataCode": "CUN", "destinationName": "Isla Holbox" } ]