🌍 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

Countries

@kaggle.mexwell_countries_states_and_cities_around_the_world.countries

49.83 KB
250 rows
19 columns

id Id	name Name	iso3 Iso3	iso2 Iso2	numeric_code Numeric Code	phone_code Phone Code	capital Capital	currency Currency	currency_name Currency Name	currency_symbol Currency Symbol	tld Tld	native Native	region Region	subregion Subregion	timezones Timezones	latitude Latitude	longitude Longitude	emoji Emoji	emojiu EmojiU
1	Afghanistan	AFG	AF	4	93	Kabul	AFN	Afghan afghani	؋	.af	افغانستان	Asia	Southern Asia	[{zoneName:'Asia\/Kabul',gmtOffset:16200,gmtOffsetName:'UTC+04:30',abbreviation:'AFT',tzName:'Afghanistan Time'}]	33	65	🇦🇫	U+1F1E6 U+1F1EB
2	Aland Islands	ALA	AX	248	+358-18	Mariehamn	EUR	Euro	€	.ax	Åland	Europe	Northern Europe	[{zoneName:'Europe\/Mariehamn',gmtOffset:7200,gmtOffsetName:'UTC+02:00',abbreviation:'EET',tzName:'Eastern European Time'}]	60.116667	19.9	🇦🇽	U+1F1E6 U+1F1FD
3	Albania	ALB	AL	8	355	Tirana	ALL	Albanian lek	Lek	.al	Shqipëria	Europe	Southern Europe	[{zoneName:'Europe\/Tirane',gmtOffset:3600,gmtOffsetName:'UTC+01:00',abbreviation:'CET',tzName:'Central European Time'}]	41	20	🇦🇱	U+1F1E6 U+1F1F1
4	Algeria	DZA	DZ	12	213	Algiers	DZD	Algerian dinar	دج	.dz	الجزائر	Africa	Northern Africa	[{zoneName:'Africa\/Algiers',gmtOffset:3600,gmtOffsetName:'UTC+01:00',abbreviation:'CET',tzName:'Central European Time'}]	28	3	🇩🇿	U+1F1E9 U+1F1FF
5	American Samoa	ASM	AS	16	+1-684	Pago Pago	USD	US Dollar	$	.as	American Samoa	Oceania	Polynesia	[{zoneName:'Pacific\/Pago_Pago',gmtOffset:-39600,gmtOffsetName:'UTC-11:00',abbreviation:'SST',tzName:'Samoa Standard Time'}]	-14.33333333	-170	🇦🇸	U+1F1E6 U+1F1F8
6	Andorra	AND	AD	20	376	Andorra la Vella	EUR	Euro	€	.ad	Andorra	Europe	Southern Europe	[{zoneName:'Europe\/Andorra',gmtOffset:3600,gmtOffsetName:'UTC+01:00',abbreviation:'CET',tzName:'Central European Time'}]	42.5	1.5	🇦🇩	U+1F1E6 U+1F1E9
7	Angola	AGO	AO	24	244	Luanda	AOA	Angolan kwanza	Kz	.ao	Angola	Africa	Middle Africa	[{zoneName:'Africa\/Luanda',gmtOffset:3600,gmtOffsetName:'UTC+01:00',abbreviation:'WAT',tzName:'West Africa Time'}]	-12.5	18.5	🇦🇴	U+1F1E6 U+1F1F4
8	Anguilla	AIA	AI	660	+1-264	The Valley	XCD	East Caribbean dollar	$	.ai	Anguilla	Americas	Caribbean	[{zoneName:'America\/Anguilla',gmtOffset:-14400,gmtOffsetName:'UTC-04:00',abbreviation:'AST',tzName:'Atlantic Standard Time'}]	18.25	-63.16666666	🇦🇮	U+1F1E6 U+1F1EE
9	Antarctica	ATA	AQ	10	672	nan	AAD	Antarctican dollar	$	.aq	Antarctica	Polar	nan	[{zoneName:'Antarctica\/Casey',gmtOffset:39600,gmtOffsetName:'UTC+11:00',abbreviation:'AWST',tzName:'Australian Western Standard Time'},{zoneName:'Antarctica\/Davis',gmtOffset:25200,gmtOffsetName:'UTC+07:00',abbreviation:'DAVT',tzName:'Davis Time'},{zoneName:'Antarctica\/DumontDUrville',gmtOffset:36…	-74.65	4.48	🇦🇶	U+1F1E6 U+1F1F6
10	Antigua And Barbuda	ATG	AG	28	+1-268	St. John's	XCD	Eastern Caribbean dollar	$	.ag	Antigua and Barbuda	Americas	Caribbean	[{zoneName:'America\/Antigua',gmtOffset:-14400,gmtOffsetName:'UTC-04:00',abbreviation:'AST',tzName:'Atlantic Standard Time'}]	17.05	-61.8	🇦🇬	U+1F1E6 U+1F1EC


CREATE TABLE countries (
  "id" BIGINT,
  "name" VARCHAR,
  "iso3" VARCHAR,
  "iso2" VARCHAR,
  "numeric_code" BIGINT,
  "phone_code" VARCHAR,
  "capital" VARCHAR,
  "currency" VARCHAR,
  "currency_name" VARCHAR,
  "currency_symbol" VARCHAR,
  "tld" VARCHAR,
  "native" VARCHAR,
  "region" VARCHAR,
  "subregion" VARCHAR,
  "timezones" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "emoji" VARCHAR,
  "emojiu" VARCHAR
);