Baselight

🌍 Countries, States And Cities Around The World

150k cities in 5k states in 250 countries

@kaggle.mexwell_countries_states_and_cities_around_the_world

Loading...
Loading...

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
Loading...

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
Loading...

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
Loading...

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

Share link

Anyone who has the link will be able to view this.