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

Countries

@kaggle.darshangada_countries_states_cities_database.countries

54.99 KB
250 rows
22 columns

id Id	name Name	iso3 Iso3	iso2 Iso2	numeric_code Numeric Code	phonecode Phonecode	capital Capital	currency Currency	currency_name Currency Name	currency_symbol Currency Symbol	tld Tld	native Native	region Region	region_id Region Id	subregion Subregion	subregion_id Subregion Id	nationality Nationality	timezones Timezones	latitude Latitude	longitude Longitude	emoji Emoji	emojiu EmojiU
1	Afghanistan	AFG	AF	4	93	Kabul	AFN	Afghan afghani	؋	.af	افغانستان	Asia	3	Southern Asia	14	Afghan	[{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	Mariehamn	EUR	Euro	€	.ax	Åland	Europe	4	Northern Europe	18	Aland Island	[{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	4	Southern Europe	16	Albanian	[{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	1	Northern Africa	1	Algerian	[{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	Pago Pago	USD	United States dollar	$	.as	American Samoa	Oceania	5	Polynesia	22	American Samoan	[{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	4	Southern Europe	16	Andorran	[{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	1	Middle Africa	2	Angolan	[{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	The Valley	XCD	Eastern Caribbean dollar	$	.ai	Anguilla	Americas	2	Caribbean	7	Anguillan	[{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	6	nan		Antarctic	[{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	St. John's	XCD	Eastern Caribbean dollar	$	.ag	Antigua and Barbuda	Americas	2	Caribbean	7	Antiguan or Barbudan	[{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,
  "phonecode" BIGINT,
  "capital" VARCHAR,
  "currency" VARCHAR,
  "currency_name" VARCHAR,
  "currency_symbol" VARCHAR,
  "tld" VARCHAR,
  "native" VARCHAR,
  "region" VARCHAR,
  "region_id" BIGINT,
  "subregion" VARCHAR,
  "subregion_id" BIGINT,
  "nationality" VARCHAR,
  "timezones" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "emoji" VARCHAR,
  "emojiu" VARCHAR
);