Countries States Cities Database

🌍 Discover our global repository of countries, states, and cities!

@kaggle.darshangada_countries_states_cities_database

Table List

5 tables(6.29 MB)

States

Countries

Cities

Regions

Subregions

States

@kaggle.darshangada_countries_states_cities_database.states

204.05 KB
5143 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	province	36.7347725	70.8119953
3871	Badghis	1	AF	Afghanistan	BDG	province	35.1671339	63.7695384
3875	Baghlan	1	AF	Afghanistan	BGL	province	36.1789026	68.7453064
3884	Balkh	1	AF	Afghanistan	BAL	province	36.7550603	66.8975372
3872	Bamyan	1	AF	Afghanistan	BAM	province	34.8100067	67.8212104
3892	Daykundi	1	AF	Afghanistan	DAY	province	33.669495	66.0463534
3899	Farah	1	AF	Afghanistan	FRA	province	32.495328	62.2626627
3889	Faryab	1	AF	Afghanistan	FYB	province	36.0795613	64.905955
3870	Ghazni	1	AF	Afghanistan	GHA	province	33.5450587	68.4173972
3888	Ghōr	1	AF	Afghanistan	GHO	province	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
);