Free MySQL Query for Countries, Cities, States, Continents List

This is a very detailed database with data about the world continents, countries, and cities. The continent, country, state, city database has datasets as follows:

• Dataset with all 7 continents
• Dataset with all 250 countries
• Dataset with all 127k cities in the world
• Dataset with all 4.7k subdivisions, states, and provinces of the world
• Dataset with all the languages spoken on each country
• Dataset with the geographical shapes of each country

The list of countries and cities database is specially designed to meet developer’s needs. A developer is able to perform the following actions with the database:

• Clone and make changes to the database
• Connect any app to the database
• Make queries and retrieve data from the database
• Find relations between the fields
• Download the database in a JSON format

Here some ways developer can benefit using the database of countries and states:

• Insert data on autocomplete forms
• Access/Retrieve data from different data sources under a single API Key
• Run multiple queries on multiple datasets and centralize the results
• Receive regular updates from the data sources the API Key is connected

Here are some easy-to-understand examples of the type of information you can retrieve using the database:

• Countries by Continent
• Cities by Country
• Languages by Country

Below, details of the datasets available:

This dataset provides the following information for each continent:

• Continent Name in a String Format
• Continent Code in a String Format

Example below:

• Continent Name: Asia
• Continent Code: AS

This dataset provides the following information for each country:

• Country Name in a String Format
• Country Name Native Language in a String Format
• Country Code in a String Format
• Country Phone Code in a Number Format
• Country Flag in a String Format (emoji)
• Country Capital in a String Format
• Country Currencies in a String Format

Example below:

• Country Name: Germany
• Country Name Native Language: Deutschland
• Country Code: DE
• Country Phone Code: 49
• Country Flag:
• Country Capital: Berlin
• Country Currencies: EUR

This dataset provides the following information for each city in the world:

• City Name in a String format
• City Country in a Pointer format
• City Population in a Number format
• City Location (Latitude / Longitude) in a Geopoint format
• City ID in a Number format
• City Admin Code in a String format
• Capital or Not in a Boolean format

Example below:

• City Name: Berlin
• City Country: Germany
• City Population: 3,426,354
• City Location: 52.52437 / 13.41053
• City ID: 2950159
• City Admin Code: 16
• Capital: True

Link