🌍 Countries, States And Cities Around The World
150k cities in 5k states in 250 countries
@kaggle.mexwell_countries_states_and_cities_around_the_world
150k cities in 5k states in 250 countries
@kaggle.mexwell_countries_states_and_cities_around_the_world
CREATE TABLE states (
"id" BIGINT,
"name" VARCHAR,
"country_id" BIGINT,
"country_code" VARCHAR,
"country_name" VARCHAR,
"state_code" VARCHAR,
"type" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE
);
CREATE TABLE countries (
"id" BIGINT,
"name" VARCHAR,
"iso3" VARCHAR,
"iso2" VARCHAR,
"numeric_code" BIGINT,
"phone_code" VARCHAR,
"capital" VARCHAR,
"currency" VARCHAR,
"currency_name" VARCHAR,
"currency_symbol" VARCHAR,
"tld" VARCHAR,
"native" VARCHAR,
"region" VARCHAR,
"subregion" VARCHAR,
"timezones" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"emoji" VARCHAR,
"emojiu" VARCHAR
);
CREATE TABLE cities (
"id" BIGINT,
"name" VARCHAR,
"state_id" BIGINT,
"state_code" VARCHAR,
"state_name" VARCHAR,
"country_id" BIGINT,
"country_code" VARCHAR,
"country_name" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"wikidataid" VARCHAR
);
Anyone who has the link will be able to view this.