CSV
Major Countries Capitals and Official Languages - CSV
This dataset compiles basic information about major countries around the world. It includes details such as capitals, official languages, regions, ISO codes, and population. Covering major countries in Asia, Europe, North America, South America, Africa, Oceania, and the Middle East, it is provided in a multilingual data structure. This resource can be utilized for various purposes including international business, education, and travel.
world
countries
capitals
official languages
geography
international
ISO codes
code,slug,name,description,capital,isoCode_alpha2,isoCode_alpha3,isoCode_numeric,officialLanguages,population,region,subRegion
JP,japan,Japan,An island nation located in East Asia with the world's third-largest economy.,Tokyo,JP,JPN,392,"[""Japanese""]",125000000,Asia,East Asia
US,united-states,United States of America,A federal republic located in North America with the world's largest economy.,"Washington, D.C.",US,USA,840,"[""English (de facto)""]",331000000,North America,Northern America
CN,china,China,A socialist state located in East Asia with the world's largest population.,Beijing,CN,CHN,156,"[""Standard Chinese (Mandarin)""]",1447000000,Asia,East Asia
GB,united-kingdom,United Kingdom,"A constitutional monarchy located in Western Europe, the birthplace of the English language.",London,GB,GBR,826,"[""English""]",67000000,Europe,Western Europe
FR,france,France,"A republic located in Western Europe, a center of culture and arts.",Paris,FR,FRA,250,"[""French""]",68000000,Europe,Western Europe
DE,germany,Germany,A federal republic located in Central Europe with the EU's largest economy.,Berlin,DE,DEU,276,"[""German""]",83000000,Europe,Western Europe
KR,south-korea,South Korea,"A republic located in East Asia, globally popular for IT industry and entertainment.",Seoul,KR,KOR,410,"[""Korean""]",52000000,Asia,East Asia
IN,india,India,A federal republic located in South Asia with the world's second-largest population.,New Delhi,IN,IND,356,"[""Hindi"",""English""]",1403000000,Asia,South Asia
BR,brazil,Brazil,The largest country in South America with Portuguese as its official language.,Brasília,BR,BRA,076,"[""Portuguese""]",215000000,South America,South America
RU,russia,Russia,The world's largest federation spanning Europe and Asia.,Moscow,RU,RUS,643,"[""Russian""]",146000000,Europe/Asia,Eastern Europe/Northern Asia
IT,italy,Italy,A republic in Southern Europe famous for ancient Roman heritage and cuisine.,Rome,IT,ITA,380,"[""Italian""]",59000000,Europe,Southern Europe
CA,canada,Canada,A federal state in North America with English and French as official languages.,Ottawa,CA,CAN,124,"[""English"",""French""]",38000000,North America,Northern America
AU,australia,Australia,"A federal state in Oceania, a continental nation with a unique ecosystem.",Canberra,AU,AUS,036,"[""English (de facto)""]",26000000,Oceania,Australia and New Zealand
ES,spain,Spain,"A kingdom in Southern Europe, the birthplace of the Spanish language.",Madrid,ES,ESP,724,"[""Spanish (Castilian)""]",47000000,Europe,Southern Europe
MX,mexico,Mexico,A republic in southern North America with ancient Maya and Aztec heritage.,Mexico City,MX,MEX,484,"[""Spanish""]",126000000,North America,Central America
ID,indonesia,Indonesia,The largest country in Southeast Asia and the world's largest archipelagic nation.,Jakarta,ID,IDN,360,"[""Indonesian""]",278000000,Asia,Southeast Asia
SA,saudi-arabia,Saudi Arabia,A kingdom in the Middle East home to the holiest sites of Islam.,Riyadh,SA,SAU,682,"[""Arabic""]",36000000,Asia,Middle East
ZA,south-africa,South Africa,A republic at the southernmost tip of Africa with three capital cities.,"Pretoria, Cape Town, Bloemfontein",ZA,ZAF,710,"[""Zulu"",""Xhosa"",""Afrikaans"",""English"",""Northern Sotho"",""Southern Sotho"",""Tswana"",""Swazi"",""Venda"",""Tsonga"",""Ndebele""]",60000000,Africa,Southern Africa
EG,egypt,Egypt,A republic in North Africa with ancient Egyptian civilization heritage.,Cairo,EG,EGY,818,"[""Arabic""]",109000000,Africa,Northern Africa
TH,thailand,Thailand,"A kingdom in Southeast Asia, the only country in the region never colonized.",Bangkok,TH,THA,764,"[""Thai""]",70000000,Asia,Southeast Asia
VN,vietnam,Vietnam,A socialist republic in Southeast Asia experiencing rapid economic growth.,Hanoi,VN,VNM,704,"[""Vietnamese""]",99000000,Asia,Southeast Asia
TR,turkey,Turkey,A republic spanning Europe and Asia where Eastern and Western cultures meet.,Ankara,TR,TUR,792,"[""Turkish""]",85000000,Asia/Europe,Middle East/Southern Europe
AR,argentina,Argentina,"A republic in southern South America, the birthplace of tango.",Buenos Aires,AR,ARG,032,"[""Spanish""]",46000000,South America,South America
NL,netherlands,Netherlands,"A constitutional monarchy in Western Europe, the land of lowlands.",Amsterdam,NL,NLD,528,"[""Dutch""]",17000000,Europe,Western Europe
SE,sweden,Sweden,A kingdom in Northern Europe known as a high welfare state.,Stockholm,SE,SWE,752,"[""Swedish""]",10000000,Europe,Northern Europe
CH,switzerland,Switzerland,A federal republic in Central Europe with four official languages.,Bern,CH,CHE,756,"[""German"",""French"",""Italian"",""Romansh""]",8700000,Europe,Western Europe
BE,belgium,Belgium,"A kingdom in Western Europe home to Brussels, the capital of the EU.",Brussels,BE,BEL,056,"[""Dutch"",""French"",""German""]",11600000,Europe,Western Europe
AT,austria,Austria,"A republic in Central Europe with Vienna, the city of music and arts.",Vienna,AT,AUT,040,"[""German""]",9000000,Europe,Western Europe
PL,poland,Poland,A republic in Eastern Europe rich in history and culture.,Warsaw,PL,POL,616,"[""Polish""]",38000000,Europe,Eastern Europe
PH,philippines,Philippines,An archipelagic nation in Southeast Asia where English is widely spoken.,Manila,PH,PHL,608,"[""Filipino"",""English""]",114000000,Asia,Southeast Asia
MY,malaysia,Malaysia,"A federal constitutional monarchy in Southeast Asia, a multi-ethnic nation.",Kuala Lumpur,MY,MYS,458,"[""Malay""]",33000000,Asia,Southeast Asia
SG,singapore,Singapore,A city-state in Southeast Asia and one of the world's leading financial centers.,Singapore,SG,SGP,702,"[""English"",""Chinese"",""Malay"",""Tamil""]",6000000,Asia,Southeast Asia
NZ,new-zealand,New Zealand,An island nation in Oceania with beautiful nature and Māori culture.,Wellington,NZ,NZL,554,"[""English"",""Māori""]",5000000,Oceania,Australia and New Zealand
GR,greece,Greece,"A republic in Southern Europe, the birthplace of Western civilization.",Athens,GR,GRC,300,"[""Greek""]",10400000,Europe,Southern Europe
PT,portugal,Portugal,"A republic in Southern Europe, a pioneer of the Age of Discovery.",Lisbon,PT,PRT,620,"[""Portuguese""]",10300000,Europe,Southern Europe
CZ,czech-republic,Czech Republic,A republic in Central Europe with the beautiful cityscape of Prague.,Prague,CZ,CZE,203,"[""Czech""]",10700000,Europe,Eastern Europe
HU,hungary,Hungary,A republic in Central Europe with a beautiful capital along the Danube River.,Budapest,HU,HUN,348,"[""Hungarian""]",9700000,Europe,Eastern Europe
UA,ukraine,Ukraine,A republic in Eastern Europe with the largest territory in Europe.,Kyiv,UA,UKR,804,"[""Ukrainian""]",44000000,Europe,Eastern Europe
IL,israel,Israel,"A parliamentary republic in the Middle East, a startup powerhouse.",Jerusalem,IL,ISR,376,"[""Hebrew""]",9500000,Asia,Middle East
AE,united-arab-emirates,United Arab Emirates,A federation in the Middle East famous for Dubai and Abu Dhabi.,Abu Dhabi,AE,ARE,784,"[""Arabic""]",10000000,Asia,Middle East
NG,nigeria,Nigeria,A federal republic in West Africa with Africa's largest population and economy.,Abuja,NG,NGA,566,"[""English""]",218000000,Africa,Western Africa
KE,kenya,Kenya,A republic in East Africa world-famous for safari tourism.,Nairobi,KE,KEN,404,"[""Swahili"",""English""]",55000000,Africa,Eastern Africa
CL,chile,Chile,"A republic in western South America with a long, narrow territory.",Santiago,CL,CHL,152,"[""Spanish""]",19000000,South America,South America
FI,finland,Finland,A republic in Northern Europe with high education standards and welfare.,Helsinki,FI,FIN,246,"[""Finnish"",""Swedish""]",5500000,Europe,Northern Europe
NO,norway,Norway,A kingdom in Northern Europe with rich oil resources and beautiful fjords.,Oslo,NO,NOR,578,"[""Norwegian""]",5400000,Europe,Northern Europe
DK,denmark,Denmark,A kingdom in Northern Europe frequently ranking high in happiness indexes.,Copenhagen,DK,DNK,208,"[""Danish""]",5900000,Europe,Northern Europe