Countries States Cities Database

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

@kaggle.darshangada_countries_states_cities_database

Subregions

@kaggle.darshangada_countries_states_cities_database.subregions

id Id	name Name	region_id Region Id	wikidataid WikiDataId
19	Australia and New Zealand	5	Q45256
7	Caribbean	2	Q664609
9	Central America	2	Q27611
10	Central Asia	3	Q27275
4	Eastern Africa	1	Q27407
12	Eastern Asia	3	Q27231
15	Eastern Europe	4	Q27468
20	Melanesia	5	Q37394
21	Micronesia	5	Q3359409
2	Middle Africa	1	Q27433


CREATE TABLE subregions (
  "id" BIGINT,
  "name" VARCHAR,
  "region_id" BIGINT,
  "wikidataid" VARCHAR
);