Baselight
Sign In

🌍 Countries, States And Cities Around The World

150k cities in 5k states in 250 countries

@kaggle.mexwell_countries_states_and_cities_around_the_world

Cities
@kaggle.mexwell_countries_states_and_cities_around_the_world.cities

  • 5.86 MB
  • 150454 rows
  • 11 columns
id

Id

name

Name

state_id

State Id

state_code

State Code

state_name

State Name

country_id

Country Id

country_code

Country Code

country_name

Country Name

latitude

Latitude

longitude

Longitude

wikidataid

WikiDataId

52Ashkāsham3901BDSBadakhshan1AFAfghanistan36.6833371.53333Q4805192
68Fayzabad3901BDSBadakhshan1AFAfghanistan37.1166470.58002Q156558
78Jurm3901BDSBadakhshan1AFAfghanistan36.8647770.83421Q10308323
84Khandūd3901BDSBadakhshan1AFAfghanistan36.9512772.318Q3290334
115Rāghistān3901BDSBadakhshan1AFAfghanistan37.6607970.67346Q2670909
131Wākhān3901BDSBadakhshan1AFAfghanistan37.057173.34928Q2509959
72Ghormach3871BDGBadghis1AFAfghanistan35.7306263.78264Q5556982
108Qala i Naw3871BDGBadghis1AFAfghanistan34.9873563.12891Q26396
54Baghlān3875BGLBaghlan1AFAfghanistan36.1306868.70829Q732879
140Ḩukūmatī Dahanah-ye Ghōrī3875BGLBaghlan1AFAfghanistan35.9061768.48869Q5194960

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