Dataset: 🌍 Countries, States And Cities Around The World

About this Dataset

🌍 Countries, States And Cities Around The World

This dataset contains meta information for

contries
states
cities

Original data

Photo taken by PIRO4D

Tables

States

@kaggle.mexwell_countries_states_and_cities_around_the_world.states

204.73 KB
5077 rows
9 columns


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
);

Countries

@kaggle.mexwell_countries_states_and_cities_around_the_world.countries

49.83 KB
250 rows
19 columns


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
);

Cities

@kaggle.mexwell_countries_states_and_cities_around_the_world.cities

5.86 MB
150454 rows
11 columns


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
);