🌍 Countries, States And Cities Around The World

150k cities in 5k states in 250 countries

@kaggle.mexwell_countries_states_and_cities_around_the_world

Table List

3 tables(6.11 MB)

States

Countries

Cities

States

@kaggle.mexwell_countries_states_and_cities_around_the_world.states

204.73 KB
5077 rows
9 columns

id Id	name Name	country_id Country Id	country_code Country Code	country_name Country Name	state_code State Code	type Type	latitude Latitude	longitude Longitude
3901	Badakhshan	1	AF	Afghanistan	BDS	nan	36.7347725	70.8119953
3871	Badghis	1	AF	Afghanistan	BDG	nan	35.1671339	63.7695384
3875	Baghlan	1	AF	Afghanistan	BGL	nan	36.1789026	68.7453064
3884	Balkh	1	AF	Afghanistan	BAL	nan	36.7550603	66.8975372
3872	Bamyan	1	AF	Afghanistan	BAM	nan	34.8100067	67.8212104
3892	Daykundi	1	AF	Afghanistan	DAY	nan	33.669495	66.0463534
3899	Farah	1	AF	Afghanistan	FRA	nan	32.495328	62.2626627
3889	Faryab	1	AF	Afghanistan	FYB	nan	36.0795613	64.905955
3870	Ghazni	1	AF	Afghanistan	GHA	nan	33.5450587	68.4173972
3888	Ghōr	1	AF	Afghanistan	GHO	nan	34.0995776	64.905955


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