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

Cities

@kaggle.darshangada_countries_states_cities_database.cities

6.03 MB
150525 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
52	Ashkāsham	3901	BDS	Badakhshan	1	AF	Afghanistan	36.68333	71.53333	Q4805192
68	Fayzabad	3901	BDS	Badakhshan	1	AF	Afghanistan	37.11664	70.58002	Q156558
78	Jurm	3901	BDS	Badakhshan	1	AF	Afghanistan	36.86477	70.83421	Q10308323
84	Khandūd	3901	BDS	Badakhshan	1	AF	Afghanistan	36.95127	72.318	Q3290334
115	Rāghistān	3901	BDS	Badakhshan	1	AF	Afghanistan	37.66079	70.67346	Q2670909
131	Wākhān	3901	BDS	Badakhshan	1	AF	Afghanistan	37.0571	73.34928	Q2509959
72	Ghormach	3871	BDG	Badghis	1	AF	Afghanistan	35.73062	63.78264	Q5556982
108	Qala i Naw	3871	BDG	Badghis	1	AF	Afghanistan	34.98735	63.12891	Q26396
54	Baghlān	3875	BGL	Baghlan	1	AF	Afghanistan	36.13068	68.70829	Q732879
140	Ḩukūmatī Dahanah-ye Ghōrī	3875	BGL	Baghlan	1	AF	Afghanistan	35.90617	68.48869	Q5194960


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