World
Show SQL  [Hide]
 
SQL Count SQL
select
   c.Code as Code, c.Name as Name, c.Continent as Continent, c.Region as Region, cls_o.languages as official_languages, c.SurfaceArea as surface_area, c.IndepYear as independence, c.Population as Population, c.LifeExpectancy as life_expectancy, c.GNP as GNP, c.GovernmentForm as form_of_government, c.HeadOfState as head_of_state
from
   Country c
   join (
      select
         cl.CountryCode, group_concat(cl.Language separator ', ') as languages
      from
         CountryLanguage cl
      where
         cl.IsOfficial = 'T'
      group by
         cl.CountryCode ) cls_o on c.Code = cls_o.CountryCode
      order by
         Name asc
      limit
         100 offset 0
;
select
   count(*) as count
from
   Country c
;
X
Filters
Country Spoken Languages (multiple - space separated)
Official Languages (multiple - space separated)






Summaries
Summarize by:
Reset Filters
Columns
Country Data Official Languages Population Cities
Code Spoken Languages Life Expectancy [ x ] Count
Name [   ] Languages GNP
Continent Surface Area Form Of Government
Region Independence Head Of State
Reset Columns
World Report   -   All   -   Rows 1 - 100, of 239   -   Next>>   -   Download CSV
Code Name Continent Region Official Languages Surface Area Independence Population Life Expectancy GNP Form Of Government Head Of State
AFG Afghanistan Asia Southern and Central Asia Dari, Pashto 652090.0 1919 22720000 45.9 5,976.00 Islamic Emirate Mohammad Omar
ALB Albania Europe Southern Europe Albaniana 28748.0 1912 3401200 71.6 3,205.00 Republic Rexhep Mejdani
DZA Algeria Africa Northern Africa Arabic 2381741.0 1962 31471000 69.7 49,982.00 Republic Abdelaziz Bouteflika
ASM American Samoa Oceania Polynesia English, Samoan 199.0 68000 75.1 334.00 US Territory George W. Bush
AND Andorra Europe Southern Europe Catalan 468.0 1278 78000 83.5 1,630.00 Parliamentary Coprincipality
AIA Anguilla North America Caribbean English 96.0 8000 76.1 63.20 Dependent Territory of the UK Elisabeth II
ATG Antigua and Barbuda North America Caribbean English 442.0 1981 68000 70.5 612.00 Constitutional Monarchy Elisabeth II
ARG Argentina South America South America Spanish 2780400.0 1816 37032000 75.1 340,238.00 Federal Republic Fernando de la Rúa
ARM Armenia Asia Middle East Armenian 29800.0 1991 3520000 66.4 1,813.00 Republic Robert Kotšarjan
ABW Aruba North America Caribbean Dutch 193.0 103000 78.4 828.00 Nonmetropolitan Territory of The Netherlands Beatrix
AUS Australia Oceania Australia and New Zealand English 7741220.0 1901 18886000 79.8 351,182.00 Constitutional Monarchy, Federation Elisabeth II
AUT Austria Europe Western Europe German 83859.0 1918 8091800 77.7 211,860.00 Federal Republic Thomas Klestil
AZE Azerbaijan Asia Middle East Azerbaijani 86600.0 1991 7734000 62.9 4,127.00 Federal Republic Heydär Äliyev
BHR Bahrain Asia Middle East Arabic 694.0 1971 617000 73.0 6,366.00 Monarchy (Emirate) Hamad ibn Isa al-Khalifa
BGD Bangladesh Asia Southern and Central Asia Bengali 143998.0 1971 129155000 60.2 32,852.00 Republic Shahabuddin Ahmad
BRB Barbados North America Caribbean English 430.0 1966 270000 73.0 2,223.00 Constitutional Monarchy Elisabeth II
BLR Belarus Europe Eastern Europe Belorussian, Russian 207600.0 1991 10236000 68.0 13,714.00 Republic Aljaksandr Lukašenka
BEL Belgium Europe Western Europe Dutch, French, German 30518.0 1830 10239000 77.8 249,704.00 Constitutional Monarchy, Federation Albert II
BLZ Belize North America Central America English 22696.0 1981 241000 70.9 630.00 Constitutional Monarchy Elisabeth II
BMU Bermuda North America North America English 53.0 65000 76.9 2,328.00 Dependent Territory of the UK Elisabeth II
BTN Bhutan Asia Southern and Central Asia Dzongkha 47000.0 1910 2124000 52.4 372.00 Monarchy Jigme Singye Wangchuk
BOL Bolivia South America South America Aimará, Ketšua, Spanish 1098581.0 1825 8329000 63.7 8,571.00 Republic Hugo Bánzer Suárez
BIH Bosnia and Herzegovina Europe Southern Europe Serbo-Croatian 51197.0 1992 3972000 71.5 2,841.00 Federal Republic Ante Jelavic
BRA Brazil South America South America Portuguese 8547403.0 1822 170115000 62.9 776,739.00 Federal Republic Fernando Henrique Cardoso
BRN Brunei Asia Southeast Asia Malay 5765.0 1984 328000 73.6 11,705.00 Monarchy (Sultanate) Haji Hassan al-Bolkiah
BGR Bulgaria Europe Eastern Europe Bulgariana 110994.0 1908 8190900 70.9 12,178.00 Republic Petar Stojanov
BDI Burundi Africa Eastern Africa French, Kirundi 27834.0 1962 6695000 46.2 903.00 Republic Pierre Buyoya
KHM Cambodia Asia Southeast Asia Khmer 181035.0 1953 11168000 56.5 5,121.00 Constitutional Monarchy Norodom Sihanouk
CAN Canada North America North America French, English 9970610.0 1867 31147000 79.4 598,862.00 Constitutional Monarchy, Federation Elisabeth II
CPV Cape Verde Africa Western Africa Portuguese 4033.0 1975 428000 68.9 435.00 Republic António Mascarenhas Monteiro
CYM Cayman Islands North America Caribbean English 264.0 38000 78.9 1,263.00 Dependent Territory of the UK Elisabeth II
TCD Chad Africa Central Africa Arabic 1284000.0 1960 7651000 50.5 1,208.00 Republic Idriss Déby
CHL Chile South America South America Spanish 756626.0 1810 15211000 75.7 72,949.00 Republic Ricardo Lagos Escobar
CHN China Asia Eastern Asia Chinese 9572900.0 -1523 1277558000 71.4 982,268.00 People'sRepublic Jiang Zemin
CXR Christmas Island Oceania Australia and New Zealand English 135.0 2500 0.00 Territory of Australia Elisabeth II
CCK Cocos (Keeling) Islands Oceania Australia and New Zealand English 14.0 600 0.00 Territory of Australia Elisabeth II
COL Colombia South America South America Spanish 1138914.0 1810 42321000 70.3 102,896.00 Republic Andrés Pastrana Arango
COM Comoros Africa Eastern Africa Comorian 1862.0 1975 578000 60.0 4,401.00 Republic Azali Assoumani
COK Cook Islands Oceania Polynesia Maori 236.0 20000 71.1 100.00 Nonmetropolitan Territory of New Zealand Elisabeth II
CRI Costa Rica North America Central America Spanish 51100.0 1821 4023000 75.8 10,226.00 Republic Miguel Ángel Rodríguez Echeverría
HRV Croatia Europe Southern Europe Serbo-Croatian 56538.0 1991 4473000 73.7 20,208.00 Republic Štipe Mesic
CUB Cuba North America Caribbean Spanish 110861.0 1902 11201000 76.2 17,843.00 Socialistic Republic Fidel Castro Ruz
CYP Cyprus Asia Middle East Greek, Turkish 9251.0 1960 754700 76.7 9,333.00 Republic Glafkos Klerides
CZE Czech Republic Europe Eastern Europe Czech 78866.0 1993 10278100 74.5 55,017.00 Republic Václav Havel
DNK Denmark Europe Nordic Countries Danish 43094.0 800 5330000 76.5 174,099.00 Constitutional Monarchy Margrethe II
DJI Djibouti Africa Eastern Africa Arabic 23200.0 1977 638000 50.8 382.00 Republic Ismail Omar Guelleh
DOM Dominican Republic North America Caribbean Spanish 48511.0 1844 8495000 73.2 15,846.00 Republic Hipólito Mejía Domínguez
TMP East Timor Asia Southeast Asia Portuguese 14874.0 885000 46.0 0.00 Administrated by the UN José Alexandre Gusmão
ECU Ecuador South America South America Spanish 283561.0 1822 12646000 71.1 19,770.00 Republic Gustavo Noboa Bejarano
EGY Egypt Africa Northern Africa Arabic 1001449.0 1922 68470000 63.3 82,710.00 Republic Hosni Mubarak
SLV El Salvador North America Central America Spanish 21041.0 1841 6276000 69.7 11,863.00 Republic Francisco Guillermo Flores Pérez
ERI Eritrea Africa Eastern Africa Tigrinja 117600.0 1993 3850000 55.8 650.00 Republic Isayas Afewerki [Isaias Afwerki]
EST Estonia Europe Baltic Countries Estonian 45227.0 1991 1439200 69.5 5,328.00 Republic Lennart Meri
FLK Falkland Islands South America South America English 12173.0 2000 0.00 Dependent Territory of the UK Elisabeth II
FRO Faroe Islands Europe Nordic Countries Faroese, Danish 1399.0 43000 78.4 0.00 Part of Denmark Margrethe II
FJI Fiji Islands Oceania Melanesia Fijian 18274.0 1970 817000 67.9 1,536.00 Republic Josefa Iloilo
FIN Finland Europe Nordic Countries Finnish, Swedish 338145.0 1917 5171300 77.4 121,914.00 Republic Tarja Halonen
FRA France Europe Western Europe French 551500.0 843 59225700 78.8 1,424,285.00 Republic Jacques Chirac
PYF French Polynesia Oceania Polynesia French 4000.0 235000 74.8 818.00 Nonmetropolitan Territory of France Jacques Chirac
GEO Georgia Asia Middle East Georgiana 69700.0 1991 4968000 64.5 6,064.00 Republic Eduard Ševardnadze
DEU Germany Europe Western Europe German 357022.0 1955 82164700 77.4 2,133,367.00 Federal Republic Johannes Rau
GIB Gibraltar Europe Southern Europe English 6.0 25000 79.0 258.00 Dependent Territory of the UK Elisabeth II
GRC Greece Europe Southern Europe Greek 131626.0 1830 10545700 78.4 120,724.00 Republic Kostis Stefanopoulos
GRL Greenland North America North America Greenlandic, Danish 2166090.0 56000 68.1 0.00 Part of Denmark Margrethe II
GLP Guadeloupe North America Caribbean French 1705.0 456000 77.0 3,501.00 Overseas Department of France Jacques Chirac
GUM Guam Oceania Micronesia Chamorro, English 549.0 168000 77.8 1,197.00 US Territory George W. Bush
GTM Guatemala North America Central America Spanish 108889.0 1821 11385000 66.2 19,008.00 Republic Alfonso Portillo Cabrera
GNB Guinea-Bissau Africa Western Africa Portuguese 36125.0 1974 1213000 49.0 293.00 Republic Kumba Ialá
HTI Haiti North America Caribbean French 27750.0 1804 8222000 49.2 3,459.00 Republic Jean-Bertrand Aristide
VAT Holy See (Vatican City State) Europe Southern Europe Italian 0.4 1929 1000 9.00 Independent Church State Johannes Paavali II
HND Honduras North America Central America Spanish 112088.0 1838 6485000 69.9 5,333.00 Republic Carlos Roberto Flores Facussé
HKG Hong Kong Asia Eastern Asia English 1075.0 6782000 79.5 166,448.00 Special Administrative Region of China Jiang Zemin
HUN Hungary Europe Eastern Europe Hungarian 93030.0 1918 10043200 71.4 48,267.00 Republic Ferenc Mádl
ISL Iceland Europe Nordic Countries Icelandic 103000.0 1944 279000 79.4 8,255.00 Republic Ólafur Ragnar Grímsson
IND India Asia Southern and Central Asia Hindi 3287263.0 1947 1013662000 62.5 447,114.00 Federal Republic Kocheril Raman Narayanan
IDN Indonesia Asia Southeast Asia Malay 1904569.0 1945 212107000 68.0 84,982.00 Republic Abdurrahman Wahid
IRN Iran Asia Southern and Central Asia Persian 1648195.0 1906 67702000 69.7 195,746.00 Islamic Republic Ali Mohammad Khatami-Ardakani
IRQ Iraq Asia Middle East Arabic 438317.0 1932 23115000 66.5 11,500.00 Republic Saddam Hussein al-Takriti
IRL Ireland Europe British Islands English, Irish 70273.0 1921 3775100 76.8 75,921.00 Republic Mary McAleese
ISR Israel Asia Middle East Arabic, Hebrew 21056.0 1948 6217000 78.6 97,477.00 Republic Moshe Katzav
ITA Italy Europe Southern Europe Italian 301316.0 1861 57680000 79.0 1,161,755.00 Republic Carlo Azeglio Ciampi
JPN Japan Asia Eastern Asia Japanese 377829.0 -660 126714000 80.7 3,787,042.00 Constitutional Monarchy Akihito
JOR Jordan Asia Middle East Arabic 88946.0 1946 5083000 77.4 7,526.00 Constitutional Monarchy Abdullah II
KAZ Kazakstan Asia Southern and Central Asia Kazakh 2724900.0 1991 16223000 63.2 24,375.00 Republic Nursultan Nazarbajev
KIR Kiribati Oceania Micronesia Kiribati 726.0 1979 83000 59.8 40.70 Republic Teburoro Tito
KWT Kuwait Asia Middle East Arabic 17818.0 1961 1972000 76.1 27,037.00 Constitutional Monarchy (Emirate) Jabir al-Ahmad al-Jabir al-Sabah
KGZ Kyrgyzstan Asia Southern and Central Asia Russian, Kirgiz 199900.0 1991 4699000 63.4 1,626.00 Republic Askar Akajev
LAO Laos Asia Southeast Asia Lao 236800.0 1953 5433000 53.1 1,292.00 Republic Khamtay Siphandone
LVA Latvia Europe Baltic Countries Latvian 64589.0 1991 2424200 68.4 6,398.00 Republic Vaira Vike-Freiberga
LBN Lebanon Asia Middle East Arabic 10400.0 1941 3282000 71.3 17,121.00 Republic Émile Lahoud
LSO Lesotho Africa Southern Africa Sotho, English 30355.0 1966 2153000 50.8 1,061.00 Constitutional Monarchy Letsie III
LBY Libyan Arab Jamahiriya Africa Northern Africa Arabic 1759540.0 1951 5605000 75.5 44,806.00 Socialistic State Muammar al-Qadhafi
LIE Liechtenstein Europe Western Europe German 160.0 1806 32300 78.8 1,119.00 Constitutional Monarchy Hans-Adam II
LTU Lithuania Europe Baltic Countries Lithuanian 65301.0 1991 3698500 69.1 10,692.00 Republic Valdas Adamkus
LUX Luxembourg Europe Western Europe French, German, Luxembourgish 2586.0 1867 435700 77.1 16,321.00 Constitutional Monarchy Henri
MAC Macao Asia Eastern Asia Portuguese 18.0 473000 81.6 5,749.00 Special Administrative Region of China Jiang Zemin
MKD Macedonia Europe Southern Europe Macedonian 25713.0 1991 2024000 73.8 1,694.00 Republic Boris Trajkovski
MDG Madagascar Africa Eastern Africa French, Malagasy 587041.0 1960 15942000 55.0 3,750.00 Federal Republic Didier Ratsiraka
MWI Malawi Africa Eastern Africa Chichewa 118484.0 1964 10925000 37.6 1,687.00 Republic Bakili Muluzi
MYS Malaysia Asia Southeast Asia Malay 329758.0 1957 22244000 70.8 69,213.00 Constitutional Monarchy, Federation Salahuddin Abdul Aziz Shah Alhaj