--Relatsiooniline summa ehk UNION
SELECT 'Linnade arv' AS Kirjeldus, COUNT(*) AS Kokku
FROM tCity
UNION
SELECT 'Riikide arv',COUNT(*)
FROM tCountry
UNION
SELECT 'Kontinendid', COUNT(DISTINCT Continent)
FROM tCountry
UNION
SELECT 'Keskmine riikide Population',AVG(CAST(Population AS bigint))
FROM tCountry
UNION
SELECT 'Väiksem riikide Population',MIN(CAST(Population AS bigint))
FROM tCountry
Kirjeldus | Kokku |
---|---|
Keskmine riikide Population | 25434098 |
Kontinendid | 7 |
Linnade arv | 4079 |
Riikide arv | 239 |
Väiksem riikide Population | 0 |
--Riigid, mille keeled on määramata
SELECT Code
FROM tCountry
EXCEPT --Realtsiooniline miinus ehk vahe
SELECT CountryCode
FROM tLanguage
Code |
---|
ATF |
IOT |
BVT |
HMD |
SGS |
ATA |
--Riigid, mille nimetus on langeb kokku pealinna nimetusega
SELECT CountryName --riikide nimetused
FROM tCountry
INTERSECT --ühisosa
SELECT CityName --pealinnade nimetused
FROM tCity INNER JOIN tCountry
ON ID=Capital
CountryName |
---|
Djibouti |
Gibraltar |
Kuwait |
Macao |
San Marino |
Singapore |
--Riigid, mille keeled on määramata
SELECT *
FROM tCountry
WHERE Code IN
(SELECT Code --alampäring
FROM tCountry
EXCEPT --Realtsiooniline miinus ehk vahe
SELECT CountryCode
FROM tLanguage)
Code | CountryName | Continent | Region | SurfaceArea | IndepYear | Population | LifeExpectancy | GNP | GNPOld | LocalName | GovernmentForm | HeadOfState | Capital |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ATA | Antarctica | Antarctica | Antarctica | 13120000,00 | NULL | 0 | NULL | 0,00 | NULL | – | Co-administrated | NULL | NULL |
ATF | French Southern territories | Antarctica | Antarctica | 7780,00 | NULL | 0 | NULL | 0,00 | NULL | Terres australes fran?aises | Nonmetropolitan Territory of France | Jacques Chirac | NULL |
BVT | Bouvet Island | Antarctica | Antarctica | 59,00 | NULL | 0 | NULL | 0,00 | NULL | Bouvet¸ya | Dependent Territory of Norway | Harald V | NULL |
HMD | Heard Island and McDonald Islands | Antarctica | Antarctica | 359,00 | NULL | 0 | NULL | 0,00 | NULL | Heard and McDonald Islands | Territory of Australia | Elisabeth II | NULL |
IOT | British Indian Ocean Territory | Africa | Eastern Africa | 78,00 | NULL | 0 | NULL | 0,00 | NULL | British Indian Ocean Territory | Dependent Territory of the UK | Elisabeth II | NULL |
SGS | South Georgia and the South Sandwich Islands | Antarctica | Antarctica | 3903,00 | NULL | 0 | NULL | 0,00 | NULL | South Georgia and the South Sandwich Islands | Dependent Territory of the UK | Elisabeth II | NULL |
SELECT *
FROM tCountry
WHERE Population >
(SELECT AVG(CAST(Population as bigint)) FROM tCountry)
Code | CountryName | Continent | Region | SurfaceArea | IndepYear | Population | LifeExpectancy | GNP | GNPOld | LocalName | GovernmentForm | HeadOfState | Capital |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ARG | Argentina | South America | South America | 2780400,00 | 1816 | 37032000 | 75,1 | 340238,00 | 323310,00 | Argentina | Federal Republic | Fernando de la R?a | 69 |
BGD | Bangladesh | Asia | Southern and Central Asia | 143998,00 | 1971 | 129155000 | 60,2 | 32852,00 | 31966,00 | Bangladesh | Republic | Shahabuddin Ahmad | 150 |
BRA | Brazil | South America | South America | 8547403,00 | 1822 | 170115000 | 62,9 | 776739,00 | 804108,00 | Brasil | Federal Republic | Fernando Henrique Cardoso | 211 |
CAN | Canada | North America | North America | 9970610,00 | 1867 | 31147000 | 79,4 | 598862,00 | 625626,00 | Canada | Constitutional Monarchy, Federation | Elisabeth II | 1822 |
CHN | China | Asia | Eastern Asia | 9572900,00 | -1523 | 1277558000 | 71,4 | 982268,00 | 917719,00 | Zhongquo | Republic | Jiang Zemin | 1891 |
COD | Congo, The Democratic Republic of the | Africa | Central Africa | 2344858,00 | 1960 | 51654000 | 48,8 | 6964,00 | 2474,00 | République Démocratique du Congo | Republic | Joseph Kabila | 2298 |
COL | Colombia | South America | South America | 1138914,00 | 1810 | 42321000 | 70,3 | 102896,00 | 105116,00 | Colombia | Republic | Andrés Pastrana Arango | 2257 |
DEU | Germany | Europe | Western Europe | 357022,00 | 1955 | 82164700 | 77,4 | 2133367,00 | 2102826,00 | Deutschland | Federal Republic | Johannes Rau | 3068 |
DZA | Algeria | Africa | Northern Africa | 2381741,00 | 1962 | 31471000 | 69,7 | 49982,00 | 46966,00 | Al-Jaza’’ir/Algérie | Republic | Abdelaziz Bouteflika | 35 |
EGY | Egypt | Africa | Northern Africa | 1001449,00 | 1922 | 68470000 | 63,3 | 82710,00 | 75617,00 | Misr | Republic | Hosni Mubarak | 608 |
ESP | Spain | Europe | Southern Europe | 505992,00 | 1492 | 39441700 | 78,8 | 553233,00 | 532031,00 | Espa?a | Constitutional Monarchy | Juan Carlos I | 653 |
ETH | Ethiopia | Africa | Eastern Africa | 1104300,00 | -1000 | 62565000 | 45,2 | 6353,00 | 6180,00 | YeItyop´iya | Republic | Negasso Gidada | 756 |
FRA | France | Europe | Western Europe | 551500,00 | 843 | 59225700 | 78,8 | 1424285,00 | 1392448,00 | France | Republic | Jacques Chirac | 2974 |
GBR | United Kingdom | Europe | British Islands | 242900,00 | 1066 | 59623400 | 77,7 | 1378330,00 | 1296830,00 | United Kingdom | Constitutional Monarchy | Elisabeth II | 456 |
IDN | Indonesia | Asia | Southeast Asia | 1904569,00 | 1945 | 212107000 | 68,0 | 84982,00 | 215002,00 | Indonesia | Republic | Abdurrahman Wahid | 939 |
IND | India | Asia | Southern and Central Asia | 3287263,00 | 1947 | 1013662000 | 62,5 | 447114,00 | 430572,00 | Bharat/India | Federal Republic | Kocheril Raman Narayanan | 1109 |
IRN | Iran | Asia | Southern and Central Asia | 1648195,00 | 1906 | 67702000 | 69,7 | 195746,00 | 160151,00 | Iran | Islamic Republic | Ali Mohammad Khatami-Ardakani | 1380 |
ITA | Italy | Europe | Southern Europe | 301316,00 | 1861 | 57680000 | 79,0 | 1161755,00 | 1145372,00 | Italia | Republic | Carlo Azeglio Ciampi | 1464 |
JPN | Japan | Asia | Eastern Asia | 377829,00 | -660 | 126714000 | 80,7 | 3787042,00 | 4192638,00 | Nihon/Nippon | Constitutional Monarchy | Akihito | 1532 |
KEN | Kenya | Africa | Eastern Africa | 580367,00 | 1963 | 30080000 | 48,0 | 9217,00 | 10241,00 | Kenya | Republic | Daniel arap Moi | 1881 |
KOR | South Korea | Asia | Eastern Asia | 99434,00 | 1948 | 46844000 | 74,4 | 320749,00 | 442544,00 | Taehan Min’guk (Namhan) | Republic | Kim Dae-jung | 2331 |
MAR | Morocco | Africa | Northern Africa | 446550,00 | 1956 | 28351000 | 69,1 | 36124,00 | 33514,00 | Al-Maghrib | Constitutional Monarchy | Mohammed VI | 2486 |
MEX | Mexico | North America | Central America | 1958201,00 | 1810 | 98881000 | 71,5 | 414972,00 | 401461,00 | México | Federal Republic | Vicente Fox Quesada | 2515 |
MMR | Myanmar | Asia | Southeast Asia | 676578,00 | 1948 | 45611000 | 54,9 | 180375,00 | 171028,00 | Myanma Pye | Republic | kenraali Than Shwe | 2710 |
NGA | Nigeria | Africa | Western Africa | 923768,00 | 1960 | 111506000 | 51,6 | 65707,00 | 58623,00 | Nigeria | Federal Republic | Olusegun Obasanjo | 2754 |
PAK | Pakistan | Asia | Southern and Central Asia | 796095,00 | 1947 | 156483000 | 61,1 | 61289,00 | 58549,00 | Pakistan | Republic | Mohammad Rafiq Tarar | 2831 |
PER | Peru | South America | South America | 1285216,00 | 1821 | 25662000 | 70,0 | 64140,00 | 65186,00 | Perú/Piruw | Republic | Valentin Paniagua Corazao | 2890 |
PHL | Philippines | Asia | Southeast Asia | 300000,00 | 1946 | 75967000 | 67,5 | 65107,00 | 82239,00 | Pilipinas | Republic | Gloria Macapagal-Arroyo | 766 |
POL | Poland | Europe | Eastern Europe | 323250,00 | 1918 | 38653600 | 73,2 | 151697,00 | 135636,00 | Polska | Republic | Aleksander Kwasniewski | 2928 |
RUS | Russian Federation | Europe | Eastern Europe | 17075400,00 | 1991 | 146934000 | 67,2 | 276608,00 | 442989,00 | Rossija | Federal Republic | Vladimir Putin | 3580 |
SDN | Sudan | Africa | Northern Africa | 2505813,00 | 1956 | 29490000 | 56,6 | 10162,00 | NULL | As-Sudan | Islamic Republic | Omar Hassan Ahmad al-Bashir | 3225 |
THA | Thailand | Asia | Southeast Asia | 513115,00 | 1350 | 61399000 | 68,6 | 116416,00 | 153907,00 | Prathet Thai | Constitutional Monarchy | Bhumibol Adulyadej | 3320 |
TUR | Turkey | Asia | Middle East | 774815,00 | 1923 | 66591000 | 71,0 | 210721,00 | 189122,00 | Türkiye | Republic | Ahmet Necdet Sezer | 3358 |
TZA | Tanzania | Africa | Eastern Africa | 883749,00 | 1961 | 33517000 | 52,3 | 8005,00 | 7388,00 | Tanzania | Republic | Benjamin William Mkapa | 3306 |
UKR | Ukraine | Europe | Eastern Europe | 603700,00 | 1991 | 50456000 | 66,0 | 42168,00 | 49677,00 | Ukrajina | Republic | Leonid Kut?ma | 3426 |
USA | United States | North America | North America | 9363520,00 | 1776 | 278357000 | 77,1 | 8510700,00 | 8110900,00 | United States | Federal Republic | George W. Bush | 3813 |
VNM | Vietnam | Asia | Southeast Asia | 331689,00 | 1945 | 79832000 | 69,3 | 21929,00 | 22834,00 | Vi?t Nam | Socialistic Republic | Tr?n Duc Luong | 3770 |
ZAF | South Africa | Africa | Southern Africa | 1221037,00 | 1910 | 40377000 | 51,1 | 116729,00 | 129092,00 | South Africa | Republic | Thabo Mbeki | 716 |
--10. Riigid kus elanikud räägivad keeltes, mis on Belgia (BEL) ametlikud keeled
SELECT * --Riikide info
FROM tCountry
WHERE Code IN
(SELECT DISTINCT CountryCode --Riikide koodid kus on samad ametl.keeled
FROM tLanguage
WHERE IsOfficial =1 AND [Language] IN
(SELECT [Language] -- Belgia (BEL) ametlikud keeled
FROM tLanguage
WHERE CountryCode LIKE 'BEL' AND IsOfficial=1))
Code | CountryName | Continent | Region | SurfaceArea | IndepYear | Population | LifeExpectancy | GNP | GNPOld | LocalName | GovernmentForm | HeadOfState | Capital |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ABW | Aruba | North America | Caribbean | 193,00 | NULL | 103000 | 78,4 | 828,00 | 793,00 | Aruba | Nonmetropolitan Territory of The Netherlands | Beatrix | 129 |
ANT | Netherlands Antilles | North America | Caribbean | 800,00 | NULL | 217000 | 74,7 | 1941,00 | NULL | Nederlandse Antillen | Nonmetropolitan Territory of The Netherlands | Beatrix | 33 |
AUT | Austria | Europe | Western Europe | 83859,00 | 1918 | 8091800 | 77,7 | 211860,00 | 206025,00 | Österreich | Federal Republic | Thomas Klestil | 1523 |
BDI | Burundi | Africa | Eastern Africa | 27834,00 | 1962 | 6695000 | 46,2 | 903,00 | 982,00 | Burundi/Uburundi | Republic | Pierre Buyoya | 552 |
BEL | Belgium | Europe | Western Europe | 30518,00 | 1830 | 10239000 | 77,8 | 249704,00 | 243948,00 | België/Belgique | Constitutional Monarchy, Federation | Albert II | 179 |
CAN | Canada | North America | North America | 9970610,00 | 1867 | 31147000 | 79,4 | 598862,00 | 625626,00 | Canada | Constitutional Monarchy, Federation | Elisabeth II | 1822 |
CHE | Switzerland | Europe | Western Europe | 41284,00 | 1499 | 7160400 | 79,6 | 264478,00 | 256092,00 | Schweiz/Suisse/Svizzera/Svizra | Federation | Adolf Ogi | 3248 |
DEU | Germany | Europe | Western Europe | 357022,00 | 1955 | 82164700 | 77,4 | 2133367,00 | 2102826,00 | Deutschland | Federal Republic | Johannes Rau | 3068 |
FRA | France | Europe | Western Europe | 551500,00 | 843 | 59225700 | 78,8 | 1424285,00 | 1392448,00 | France | Republic | Jacques Chirac | 2974 |
GLP | Guadeloupe | North America | Caribbean | 1705,00 | NULL | 456000 | 77,0 | 3501,00 | NULL | Guadeloupe | Overseas Department of France | Jacques Chirac | 919 |
HTI | Haiti | North America | Caribbean | 27750,00 | 1804 | 8222000 | 49,2 | 3459,00 | 3107,00 | Ha?ti/Dayti | Republic | Jean-Bertrand Aristide | 929 |
LIE | Liechtenstein | Europe | Western Europe | 160,00 | 1806 | 32300 | 78,8 | 1119,00 | 1084,00 | Liechtenstein | Constitutional Monarchy | Hans-Adam II | 2446 |
LUX | Luxembourg | Europe | Western Europe | 2586,00 | 1867 | 435700 | 77,1 | 16321,00 | 15519,00 | Luxembourg/L?tzebuerg | Constitutional Monarchy | Henri | 2452 |
MCO | Monaco | Europe | Western Europe | 1,50 | 1861 | 34000 | 78,8 | 776,00 | NULL | Monaco | Constitutional Monarchy | Rainier III | 2695 |
MDG | Madagascar | Africa | Eastern Africa | 587041,00 | 1960 | 15942000 | 55,0 | 3750,00 | 3545,00 | Madagasikara/Madagascar | Federal Republic | Didier Ratsiraka | 2455 |
MTQ | Martinique | North America | Caribbean | 1102,00 | NULL | 395000 | 78,3 | 2731,00 | 2559,00 | Martinique | Overseas Department of France | Jacques Chirac | 2508 |
MYT | Mayotte | Africa | Eastern Africa | 373,00 | NULL | 149000 | 59,5 | 0,00 | NULL | Mayotte | Territorial Collectivity of France | Jacques Chirac | 2514 |
NCL | New Caledonia | Oceania | Melanesia | 18575,00 | NULL | 214000 | 72,8 | 3563,00 | NULL | Nouvelle-Calédonie | Nonmetropolitan Territory of France | Jacques Chirac | 3493 |
NLD | Netherlands | Europe | Western Europe | 41526,00 | 1581 | 15864000 | 78,3 | 371362,00 | 360478,00 | Nederland | Constitutional Monarchy | Beatrix | 5 |
PYF | French Polynesia | Oceania | Polynesia | 4000,00 | NULL | 235000 | 74,8 | 818,00 | 781,00 | Polynésie Française | Nonmetropolitan Territory of France | Jacques Chirac | 3016 |
RWA | Rwanda | Africa | Eastern Africa | 26338,00 | 1962 | 7733000 | 39,3 | 2036,00 | 1863,00 | Rwanda/Urwanda | Republic | Paul Kagame | 3047 |
SPM | Saint Pierre and Miquelon | North America | North America | 242,00 | NULL | 7000 | 77,6 | 0,00 | NULL | Saint-Pierre-et-Miquelon | Territorial Collectivity of France | Jacques Chirac | 3067 |
SYC | Seychelles | Africa | Eastern Africa | 455,00 | 1976 | 77000 | 70,4 | 536,00 | 539,00 | Sesel/Seychelles | Republic | France-Albert René | 3206 |
VUT | Vanuatu | Oceania | Melanesia | 12189,00 | 1980 | 190000 | 60,6 | 261,00 | 246,00 | Vanuatu | Republic | John Bani | 3537 |
--1. Riigid, kus elanikud räägivad kõige laiemalt levinud maailmas keeles
-- (riikide arvu järgi, kus keel on ametlik)
SELECT *
FROM tCountry
WHERE Code IN
(SELECT DISTINCT CountryCode --Riikide koodid kus on samad ametl.keeled
FROM tLanguage
WHERE IsOfficial=1 AND [Language] IN
(SELECT TOP 1 [Language]--, COUNT(CountryCode) --kõige laiemalt levinud maailmas keel
FROM tLanguage
WHERE IsOfficial=1
GROUP BY [Language]
ORDER BY COUNT(CountryCode) DESC))
Code | CountryName | Continent | Region | SurfaceArea | IndepYear | Population | LifeExpectancy | GNP | GNPOld | LocalName | GovernmentForm | HeadOfState | Capital |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AIA | Anguilla | North America | Caribbean | 96,00 | NULL | 8000 | 76,1 | 63,20 | NULL | Anguilla | Dependent Territory of the UK | Elisabeth II | 62 |
ASM | American Samoa | Oceania | Polynesia | 199,00 | NULL | 68000 | 75,1 | 334,00 | NULL | Amerika Samoa | US Territory | George W. Bush | 54 |
ATG | Antigua and Barbuda | North America | Caribbean | 442,00 | 1981 | 68000 | 70,5 | 612,00 | 584,00 | Antigua and Barbuda | Constitutional Monarchy | Elisabeth II | 63 |
AUS | Australia | Oceania | Australia and New Zealand | 7741220,00 | 1901 | 18886000 | 79,8 | 351182,00 | 392911,00 | Australia | Constitutional Monarchy, Federation | Elisabeth II | 135 |
BLZ | Belize | North America | Central America | 22696,00 | 1981 | 241000 | 70,9 | 630,00 | 616,00 | Belize | Constitutional Monarchy | Elisabeth II | 185 |
BMU | Bermuda | North America | North America | 53,00 | NULL | 65000 | 76,9 | 2328,00 | 2190,00 | Bermuda | Dependent Territory of the UK | Elisabeth II | 191 |
BRB | Barbados | North America | Caribbean | 430,00 | 1966 | 270000 | 73,0 | 2223,00 | 2186,00 | Barbados | Constitutional Monarchy | Elisabeth II | 174 |
CAN | Canada | North America | North America | 9970610,00 | 1867 | 31147000 | 79,4 | 598862,00 | 625626,00 | Canada | Constitutional Monarchy, Federation | Elisabeth II | 1822 |
CCK | Cocos (Keeling) Islands | Oceania | Australia and New Zealand | 14,00 | NULL | 600 | NULL | 0,00 | NULL | Cocos (Keeling) Islands | Territory of Australia | Elisabeth II | 2317 |
CXR | Christmas Island | Oceania | Australia and New Zealand | 135,00 | NULL | 2500 | NULL | 0,00 | NULL | Christmas Island | Territory of Australia | Elisabeth II | 1791 |
CYM | Cayman Islands | North America | Caribbean | 264,00 | NULL | 38000 | 78,9 | 1263,00 | 1186,00 | Cayman Islands | Dependent Territory of the UK | Elisabeth II | 553 |
FLK | Falkland Islands | South America | South America | 12173,00 | NULL | 2000 | NULL | 0,00 | NULL | Falkland Islands | Dependent Territory of the UK | Elisabeth II | 763 |
GBR | United Kingdom | Europe | British Islands | 242900,00 | 1066 | 59623400 | 77,7 | 1378330,00 | 1296830,00 | United Kingdom | Constitutional Monarchy | Elisabeth II | 456 |
GIB | Gibraltar | Europe | Southern Europe | 6,00 | NULL | 25000 | 79,0 | 258,00 | NULL | Gibraltar | Dependent Territory of the UK | Elisabeth II | 915 |
GUM | Guam | Oceania | Micronesia | 549,00 | NULL | 168000 | 77,8 | 1197,00 | 1136,00 | Guam | US Territory | George W. Bush | 921 |
HKG | Hong Kong | Asia | Eastern Asia | 1075,00 | NULL | 6782000 | 79,5 | 166448,00 | 173610,00 | Xianggang/Hong Kong | Special Administrative Region of China | Jiang Zemin | 937 |
IRL | Ireland | Europe | British Islands | 70273,00 | 1921 | 3775100 | 76,8 | 75921,00 | 73132,00 | Ireland/Éire | Republic | Mary McAleese | 1447 |
KNA | Saint Kitts and Nevis | North America | Caribbean | 261,00 | 1983 | 38000 | 70,7 | 299,00 | NULL | Saint Kitts and Nevis | Constitutional Monarchy | Elisabeth II | 3064 |
LCA | Saint Lucia | North America | Caribbean | 622,00 | 1979 | 154000 | 72,3 | 571,00 | NULL | Saint Lucia | Constitutional Monarchy | Elisabeth II | 3065 |
LSO | Lesotho | Africa | Southern Africa | 30355,00 | 1966 | 2153000 | 50,8 | 1061,00 | 1161,00 | Lesotho | Constitutional Monarchy | Letsie III | 2437 |
MHL | Marshall Islands | Oceania | Micronesia | 181,00 | 1990 | 64000 | 65,5 | 97,00 | NULL | Marshall Islands/Majol | Republic | Kessai Note | 2507 |
MLT | Malta | Europe | Southern Europe | 316,00 | 1964 | 380200 | 77,9 | 3512,00 | 3338,00 | Malta | Republic | Guido de Marco | 2484 |
MNP | Northern Mariana Islands | Oceania | Micronesia | 464,00 | NULL | 78000 | 75,5 | 0,00 | NULL | Northern Mariana Islands | Commonwealth of the US | George W. Bush | 2913 |
MSR | Montserrat | North America | Caribbean | 102,00 | NULL | 11000 | 78,0 | 109,00 | NULL | Montserrat | Dependent Territory of the UK | Elisabeth II | 2697 |
NFK | Norfolk Island | Oceania | Australia and New Zealand | 36,00 | NULL | 2000 | NULL | 0,00 | NULL | Norfolk Island | Territory of Australia | Elisabeth II | 2806 |
NIU | Niue | Oceania | Polynesia | 260,00 | NULL | 2000 | NULL | 0,00 | NULL | Niue | Nonmetropolitan Territory of New Zealand | Elisabeth II | 2805 |
NRU | Nauru | Oceania | Micronesia | 21,00 | 1968 | 12000 | 60,8 | 197,00 | NULL | Naoero/Nauru | Republic | Bernard Dowiyogo | 2728 |
NZL | New Zealand | Oceania | Australia and New Zealand | 270534,00 | 1907 | 3862000 | 77,8 | 54669,00 | 64960,00 | New Zealand/Aotearoa | Constitutional Monarchy | Elisabeth II | 3499 |
PLW | Palau | Oceania | Micronesia | 459,00 | 1994 | 19000 | 68,6 | 105,00 | NULL | Belau/Palau | Republic | Kuniwo Nakamura | 2881 |
SHN | Saint Helena | Africa | Western Africa | 314,00 | NULL | 6000 | 76,8 | 0,00 | NULL | Saint Helena | Dependent Territory of the UK | Elisabeth II | 3063 |
SYC | Seychelles | Africa | Eastern Africa | 455,00 | 1976 | 77000 | 70,4 | 536,00 | 539,00 | Sesel/Seychelles | Republic | France-Albert René | 3206 |
TCA | Turks and Caicos Islands | North America | Caribbean | 430,00 | NULL | 17000 | 73,3 | 96,00 | NULL | The Turks and Caicos Islands | Dependent Territory of the UK | Elisabeth II | 3423 |
TKL | Tokelau | Oceania | Polynesia | 12,00 | NULL | 2000 | NULL | 0,00 | NULL | Tokelau | Nonmetropolitan Territory of New Zealand | Elisabeth II | 3333 |
TON | Tonga | Oceania | Polynesia | 650,00 | 1970 | 99000 | 67,9 | 146,00 | 170,00 | Tonga | Monarchy | Taufa ahau Tupou IV | 3334 |
TUV | Tuvalu | Oceania | Polynesia | 26,00 | 1978 | 12000 | 66,3 | 6,00 | NULL | Tuvalu | Constitutional Monarchy | Elisabeth II | 3424 |
UMI | United States Minor Outlying Islands | Oceania | Micronesia/Caribbean | 16,00 | NULL | 0 | NULL | 0,00 | NULL | United States Minor Outlying Islands | Dependent Territory of the US | George W. Bush | NULL |
USA | United States | North America | North America | 9363520,00 | 1776 | 278357000 | 77,1 | 8510700,00 | 8110900,00 | United States | Federal Republic | George W. Bush | 3813 |
VCT | Saint Vincent and the Grenadines | North America | Caribbean | 388,00 | 1979 | 114000 | 72,3 | 285,00 | NULL | Saint Vincent and the Grenadines | Constitutional Monarchy | Elisabeth II | 3066 |
VGB | Virgin Islands, British | North America | Caribbean | 151,00 | NULL | 21000 | 75,4 | 612,00 | 573,00 | British Virgin Islands | Dependent Territory of the UK | Elisabeth II | 537 |
VIR | Virgin Islands, U.S. | North America | Caribbean | 347,00 | NULL | 93000 | 78,1 | 0,00 | NULL | Virgin Islands of the United States | US Territory | George W. Bush | 4067 |
VUT | Vanuatu | Oceania | Melanesia | 12189,00 | 1980 | 190000 | 60,6 | 261,00 | 246,00 | Vanuatu | Republic | John Bani | 3537 |
WSM | Samoa | Oceania | Polynesia | 2831,00 | 1962 | 180000 | 69,2 | 141,00 | 157,00 | Samoa | Parlementary Monarchy | Malietoa Tanumafili II | 3169 |
ZAF | South Africa | Africa | Southern Africa | 1221037,00 | 1910 | 40377000 | 51,1 | 116729,00 | 129092,00 | South Africa | Republic | Thabo Mbeki | 716 |
ZWE | Zimbabwe | Africa | Eastern Africa | 390757,00 | 1980 | 11669000 | 37,8 | 5951,00 | 8670,00 | Zimbabwe | Republic | Robert G. Mugabe | 4068 |
--Teine variant
SELECT CountryCode
FROM tLanguage
WHERE isOfficial=1 AND [Language] IN(
SELECT Language FROM (
SELECT TOP 1 Language AS Lang, COUNT(*) AS Total
FROM tLanguage
WHERE IsOfficial=1
GROUP BY [Language]
ORDER BY COUNT(*) DESC) a
)
CountryCode |
---|
ABW |
AFG |
AFG |
AIA |
ALB |
AND |
ANT |
ANT |
ARE |
ARG |
ARM |
ASM |
ASM |
ATG |
AUS |
AUT |
AZE |
BDI |
BDI |
BEL |
BEL |
BEL |
BGD |
BGR |
BHR |
BIH |
BLR |
BLR |
BLZ |
BMU |
BOL |
BOL |
BOL |
BRA |
BRB |
BRN |
BTN |
CAN |
CAN |
CCK |
CHE |
CHE |
CHE |
CHE |
CHL |
CHN |
COK |
COL |
COM |
CPV |
CRI |
CUB |
CXR |
CYM |
CYP |
CYP |
CZE |
DEU |
DJI |
DNK |
DOM |
DZA |
ECU |
EGY |
ERI |
ESH |
ESP |
EST |
FIN |
FIN |
FJI |
FLK |
FRA |
FRO |
FRO |
GBR |
GEO |
GIB |
GLP |
GNB |
GRC |
GRL |
GRL |
GTM |
GUM |
GUM |
HKG |
HND |
HRV |
HTI |
HUN |
IDN |
IND |
IRL |
IRL |
IRN |
IRQ |
ISL |
ISR |
ISR |
ITA |
JOR |
JPN |
KAZ |
KGZ |
KGZ |
KHM |
KIR |
KNA |
KOR |
KWT |
LAO |
LBN |
LBY |
LCA |
LIE |
LKA |
LKA |
LSO |
LSO |
LTU |
LUX |
LUX |
LUX |
LVA |
MAC |
MAR |
MCO |
MDA |
MDG |
MDG |
MDV |
MEX |
MHL |
MHL |
MKD |
MLT |
MLT |
MMR |
MNG |
MNP |
MSR |
MTQ |
MWI |
MYS |
MYT |
NCL |
NFK |
NIC |
NIU |
NLD |
NOR |
NPL |
NRU |
NRU |
NZL |
OMN |
PAK |
PAN |
PER |
PER |
PER |
PHL |
PLW |
PLW |
POL |
PRI |
PRK |
PRT |
PRY |
PRY |
PYF |
QAT |
ROM |
ROM |
RUS |
RWA |
RWA |
SAU |
SDN |
SEN |
SGP |
SGP |
SGP |
SHN |
SJM |
SLV |
SMR |
SOM |
SOM |
SPM |
SVK |
SVN |
SWE |
SWZ |
SYC |
SYC |
SYR |
TCA |
TCD |
TGO |
TGO |
THA |
TJK |
TKL |
TKM |
TMP |
TON |
TON |
TUN |
TUR |
TUV |
TUV |
TWN |
TZA |
UKR |
UMI |
URY |
USA |
UZB |
VAT |
VCT |
VEN |
VGB |
VIR |
VNM |
VUT |
VUT |
VUT |
WSM |
WSM |
YEM |
YUG |
ZAF |
ZAF |
ZAF |
ZAF |
ZWE |
--2 Riigid, mis asuvad kõige väiksema pindalaga kontinendil
SELECT *
FROM tCountry
WHERE Continent =
(SELECT TOP 1 Continent--, SUM(SurfaceArea) as Total
FROM tCountry
GROUP BY Continent
ORDER BY SUM(SurfaceArea) ASC)
Code | CountryName | Continent | Region | SurfaceArea | IndepYear | Population | LifeExpectancy | GNP | GNPOld | LocalName | GovernmentForm | HeadOfState | Capital |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ASM | American Samoa | Oceania | Polynesia | 199,00 | NULL | 68000 | 75,1 | 334,00 | NULL | Amerika Samoa | US Territory | George W. Bush | 54 |
AUS | Australia | Oceania | Australia and New Zealand | 7741220,00 | 1901 | 18886000 | 79,8 | 351182,00 | 392911,00 | Australia | Constitutional Monarchy, Federation | Elisabeth II | 135 |
CCK | Cocos (Keeling) Islands | Oceania | Australia and New Zealand | 14,00 | NULL | 600 | NULL | 0,00 | NULL | Cocos (Keeling) Islands | Territory of Australia | Elisabeth II | 2317 |
COK | Cook Islands | Oceania | Polynesia | 236,00 | NULL | 20000 | 71,1 | 100,00 | NULL | The Cook Islands | Nonmetropolitan Territory of New Zealand | Elisabeth II | 583 |
CXR | Christmas Island | Oceania | Australia and New Zealand | 135,00 | NULL | 2500 | NULL | 0,00 | NULL | Christmas Island | Territory of Australia | Elisabeth II | 1791 |
FJI | Fiji Islands | Oceania | Melanesia | 18274,00 | 1970 | 817000 | 67,9 | 1536,00 | 2149,00 | Fiji Islands | Republic | Josefa Iloilo | 764 |
FSM | Micronesia, Federated States of | Oceania | Micronesia | 702,00 | 1990 | 119000 | 68,6 | 212,00 | NULL | Micronesia | Federal Republic | Leo A. Falcam | 2689 |
GUM | Guam | Oceania | Micronesia | 549,00 | NULL | 168000 | 77,8 | 1197,00 | 1136,00 | Guam | US Territory | George W. Bush | 921 |
KIR | Kiribati | Oceania | Micronesia | 726,00 | 1979 | 83000 | 59,8 | 40,70 | NULL | Kiribati | Republic | Teburoro Tito | 2256 |
MHL | Marshall Islands | Oceania | Micronesia | 181,00 | 1990 | 64000 | 65,5 | 97,00 | NULL | Marshall Islands/Majol | Republic | Kessai Note | 2507 |
MNP | Northern Mariana Islands | Oceania | Micronesia | 464,00 | NULL | 78000 | 75,5 | 0,00 | NULL | Northern Mariana Islands | Commonwealth of the US | George W. Bush | 2913 |
NCL | New Caledonia | Oceania | Melanesia | 18575,00 | NULL | 214000 | 72,8 | 3563,00 | NULL | Nouvelle-Calédonie | Nonmetropolitan Territory of France | Jacques Chirac | 3493 |
NFK | Norfolk Island | Oceania | Australia and New Zealand | 36,00 | NULL | 2000 | NULL | 0,00 | NULL | Norfolk Island | Territory of Australia | Elisabeth II | 2806 |
NIU | Niue | Oceania | Polynesia | 260,00 | NULL | 2000 | NULL | 0,00 | NULL | Niue | Nonmetropolitan Territory of New Zealand | Elisabeth II | 2805 |
NRU | Nauru | Oceania | Micronesia | 21,00 | 1968 | 12000 | 60,8 | 197,00 | NULL | Naoero/Nauru | Republic | Bernard Dowiyogo | 2728 |
NZL | New Zealand | Oceania | Australia and New Zealand | 270534,00 | 1907 | 3862000 | 77,8 | 54669,00 | 64960,00 | New Zealand/Aotearoa | Constitutional Monarchy | Elisabeth II | 3499 |
PCN | Pitcairn | Oceania | Polynesia | 49,00 | NULL | 50 | NULL | 0,00 | NULL | Pitcairn | Dependent Territory of the UK | Elisabeth II | 2912 |
PLW | Palau | Oceania | Micronesia | 459,00 | 1994 | 19000 | 68,6 | 105,00 | NULL | Belau/Palau | Republic | Kuniwo Nakamura | 2881 |
PNG | Papua New Guinea | Oceania | Melanesia | 462840,00 | 1975 | 4807000 | 63,1 | 4988,00 | 6328,00 | Papua New Guinea/Papua Niugini | Constitutional Monarchy | Elisabeth II | 2884 |
PYF | French Polynesia | Oceania | Polynesia | 4000,00 | NULL | 235000 | 74,8 | 818,00 | 781,00 | Polynésie Française | Nonmetropolitan Territory of France | Jacques Chirac | 3016 |
SLB | Solomon Islands | Oceania | Melanesia | 28896,00 | 1978 | 444000 | 71,3 | 182,00 | 220,00 | Solomon Islands | Constitutional Monarchy | Elisabeth II | 3161 |
TKL | Tokelau | Oceania | Polynesia | 12,00 | NULL | 2000 | NULL | 0,00 | NULL | Tokelau | Nonmetropolitan Territory of New Zealand | Elisabeth II | 3333 |
TON | Tonga | Oceania | Polynesia | 650,00 | 1970 | 99000 | 67,9 | 146,00 | 170,00 | Tonga | Monarchy | Taufa ahau Tupou IV | 3334 |
TUV | Tuvalu | Oceania | Polynesia | 26,00 | 1978 | 12000 | 66,3 | 6,00 | NULL | Tuvalu | Constitutional Monarchy | Elisabeth II | 3424 |
UMI | United States Minor Outlying Islands | Oceania | Micronesia/Caribbean | 16,00 | NULL | 0 | NULL | 0,00 | NULL | United States Minor Outlying Islands | Dependent Territory of the US | George W. Bush | NULL |
VUT | Vanuatu | Oceania | Melanesia | 12189,00 | 1980 | 190000 | 60,6 | 261,00 | 246,00 | Vanuatu | Republic | John Bani | 3537 |
WLF | Wallis and Futuna | Oceania | Polynesia | 200,00 | NULL | 15000 | NULL | 0,00 | NULL | Wallis-et-Futuna | Nonmetropolitan Territory of France | Jacques Chirac | 3536 |
WSM | Samoa | Oceania | Polynesia | 2831,00 | 1962 | 180000 | 69,2 | 141,00 | 157,00 | Samoa | Parlementary Monarchy | Malietoa Tanumafili II | 3169 |
SELECT *
FROM tCity AS A
WHERE A.Population >=
(SELECT AVG(Population)
FROM tCity
WHERE CountryCode = A.CountryCode
GROUP By CountryCode
)
ID | CityName | CountryCode | District | Population |
---|---|---|---|---|
129 | Oranjestad | ABW | NULL | 29034 |
1 | Kabul | AFG | Kabol | 1760000 |
56 | Luanda | AGO | Luanda | 2022000 |
61 | South Hill | AIA | NULL | 961 |
34 | Tirana | ALB | Tirana | 270000 |
55 | Andorra la Vella | AND | Andorra la Vella | 21189 |
33 | Willemstad | ANT | Curaeao | 2345 |
64 | Dubai | ARE | Dubai | 669181 |
65 | Abu Dhabi | ARE | Abu Dhabi | 398695 |
69 | Buenos Aires | ARG | Distrito Federal | 2982146 |
70 | La Matanza | ARG | Buenos Aires | 1266461 |
71 | Córdoba | ARG | Córdoba | 1157507 |
72 | Rosario | ARG | Santa Fé | 907718 |
73 | Lomas de Zamora | ARG | Buenos Aires | 622013 |
74 | Quilmes | ARG | Buenos Aires | 559249 |
75 | Almirante Brown | ARG | Buenos Aires | 538918 |
76 | La Plata | ARG | Buenos Aires | 521936 |
77 | Mar del Plata | ARG | Buenos Aires | 512880 |
78 | San Miguel de Tucumin | ARG | Tucumin | 470809 |
79 | Lanss | ARG | Buenos Aires | 469735 |
80 | Merlo | ARG | Buenos Aires | 463846 |
81 | General San Martkn | ARG | Buenos Aires | 422542 |
82 | Salta | ARG | Salta | 367550 |
83 | Moreno | ARG | Buenos Aires | 356993 |
84 | Santa Fé | ARG | Santa Fé | 353063 |
85 | Avellaneda | ARG | Buenos Aires | 353046 |
86 | Tres de Febrero | ARG | Buenos Aires | 352311 |
126 | Yerevan | ARM | Yerevan | 1248700 |
53 | Tafuna | ASM | Tutuila | 5200 |
63 | Saint John´s | ATG | St John | 24000 |
130 | Sydney | AUS | New South Wales | 3276207 |
131 | Melbourne | AUS | Victoria | 2865329 |
132 | Brisbane | AUS | Queensland | 1291117 |
133 | Perth | AUS | West Australia | 1096829 |
134 | Adelaide | AUS | South Australia | 978100 |
1523 | Wien | AUT | Wien | 1608144 |
144 | Baku | AZE | Baki | 1787800 |
552 | Bujumbura | BDI | Bujumbura | 300000 |
175 | Antwerpen | BEL | Antwerpen | 446525 |
176 | Gent | BEL | East Flanderi | 224180 |
177 | Charleroi | BEL | Hainaut | 200827 |
178 | Licge | BEL | Licge | 185639 |
186 | Cotonou | BEN | Atlantique | 536827 |
549 | Ouagadougou | BFA | Kadiogo | 824000 |
150 | Dhaka | BGD | Dhaka | 3612850 |
151 | Chittagong | BGD | Chittagong | 1392860 |
152 | Khulna | BGD | Khulna | 663340 |
539 | Sofija | BGR | Grad Sofija | 1122302 |
540 | Plovdiv | BGR | Plovdiv | 342584 |
541 | Varna | BGR | Varna | 299801 |
149 | al-Manama | BHR | al-Manama | 148000 |
148 | Nassau | BHS | New Providence | 172000 |
201 | Sarajevo | BIH | Federaatio | 360000 |
3520 | Minsk | BLR | Horad Minsk | 1674000 |
3521 | Gomel | BLR | Gomel | 475000 |
3522 | Mogiljov | BLR | Mogiljov | 356000 |
3523 | Vitebsk | BLR | Vitebsk | 340000 |
3524 | Grodno | BLR | Grodno | 302000 |
184 | Belize City | BLZ | Belize City | 55810 |
190 | Saint George | BMU | Saint George´s | 1800 |
193 | Santa Cruz de la Sierra | BOL | Santa Cruz | 935361 |
194 | La Paz | BOL | La Paz | 758141 |
195 | El Alto | BOL | La Paz | 534466 |
196 | Cochabamba | BOL | Cochabamba | 482800 |
206 | Sco Paulo | BRA | Sco Paulo | 9968485 |
207 | Rio de Janeiro | BRA | Rio de Janeiro | 5598953 |
208 | Salvador | BRA | Bahia | 2302832 |
209 | Belo Horizonte | BRA | Minas Gerais | 2139125 |
210 | Fortaleza | BRA | Ceari | 2097757 |
211 | Brasklia | BRA | Distrito Federal | 1969868 |
212 | Curitiba | BRA | Parani | 1584232 |
213 | Recife | BRA | Pernambuco | 1378087 |
214 | Porto Alegre | BRA | Rio Grande do Sul | 1314032 |
215 | Manaus | BRA | Amazonas | 1255049 |
216 | Belém | BRA | Pari | 1186926 |
217 | Guarulhos | BRA | Sco Paulo | 1095874 |
218 | Goiania | BRA | Goiis | 1056330 |
219 | Campinas | BRA | Sco Paulo | 950043 |
220 | Sco Gonealo | BRA | Rio de Janeiro | 869254 |
221 | Nova Iguaeu | BRA | Rio de Janeiro | 862225 |
222 | Sco Luks | BRA | Maranhco | 837588 |
223 | Maceió | BRA | Alagoas | 786288 |
224 | Duque de Caxias | BRA | Rio de Janeiro | 746758 |
225 | Sco Bernardo do Campo | BRA | Sco Paulo | 723132 |
226 | Teresina | BRA | Piauk | 691942 |
227 | Natal | BRA | Rio Grande do Norte | 688955 |
228 | Osasco | BRA | Sco Paulo | 659604 |
229 | Campo Grande | BRA | Mato Grosso do Sul | 649593 |
230 | Santo André | BRA | Sco Paulo | 630073 |
231 | Joco Pessoa | BRA | Parakba | 584029 |
232 | Jaboatco dos Guararapes | BRA | Pernambuco | 558680 |
233 | Contagem | BRA | Minas Gerais | 520801 |
234 | Sco José dos Campos | BRA | Sco Paulo | 515553 |
235 | Uberlandia | BRA | Minas Gerais | 487222 |
236 | Feira de Santana | BRA | Bahia | 479992 |
237 | Ribeirco Preto | BRA | Sco Paulo | 473276 |
238 | Sorocaba | BRA | Sco Paulo | 466823 |
239 | Niterói | BRA | Rio de Janeiro | 459884 |
240 | Cuiabi | BRA | Mato Grosso | 453813 |
241 | Juiz de Fora | BRA | Minas Gerais | 450288 |
242 | Aracaju | BRA | Sergipe | 445555 |
243 | Sco Joco de Meriti | BRA | Rio de Janeiro | 440052 |
244 | Londrina | BRA | Parani | 432257 |
245 | Joinville | BRA | Santa Catarina | 428011 |
246 | Belford Roxo | BRA | Rio de Janeiro | 425194 |
247 | Santos | BRA | Sco Paulo | 408748 |
248 | Ananindeua | BRA | Pari | 400940 |
249 | Campos dos Goytacazes | BRA | Rio de Janeiro | 398418 |
250 | Maui | BRA | Sco Paulo | 375055 |
251 | Carapicukba | BRA | Sco Paulo | 357552 |
252 | Olinda | BRA | Pernambuco | 354732 |
253 | Campina Grande | BRA | Parakba | 352497 |
254 | Sco José do Rio Preto | BRA | Sco Paulo | 351944 |
255 | Caxias do Sul | BRA | Rio Grande do Sul | 349581 |
174 | Bridgetown | BRB | St Michael | 6070 |
538 | Bandar Seri Begawan | BRN | Brunei and Muara | 21484 |
192 | Thimphu | BTN | Thimphu | 22000 |
204 | Gaborone | BWA | Gaborone | 213017 |
1889 | Bangui | CAF | Bangui | 524000 |
1810 | Montréal | CAN | Québec | 1016376 |
1811 | Calgary | CAN | Alberta | 768082 |
1812 | Toronto | CAN | Ontario | 688275 |
1813 | North York | CAN | Ontario | 622632 |
1814 | Winnipeg | CAN | Manitoba | 618477 |
1815 | Edmonton | CAN | Alberta | 616306 |
1816 | Mississauga | CAN | Ontario | 608072 |
1817 | Scarborough | CAN | Ontario | 594501 |
1818 | Vancouver | CAN | British Colombia | 514008 |
1819 | Etobicoke | CAN | Ontario | 348845 |
1820 | London | CAN | Ontario | 339917 |
1821 | Hamilton | CAN | Ontario | 335614 |
1822 | Ottawa | CAN | Ontario | 335277 |
1823 | Laval | CAN | Québec | 330393 |
1824 | Surrey | CAN | British Colombia | 304477 |
1825 | Brampton | CAN | Ontario | 296711 |
2316 | Bantam | CCK | Home Island | 503 |
3245 | Zürich | CHE | Zürich | 336800 |
554 | Santiago de Chile | CHL | Santiago | 4703954 |
555 | Puente Alto | CHL | Santiago | 386236 |
1890 | Shanghai | CHN | Shanghai | 9696300 |
1891 | Peking | CHN | Peking | 7472000 |
1892 | Chongqing | CHN | Chongqing | 6351600 |
1893 | Tianjin | CHN | Tianjin | 5286800 |
1894 | Wuhan | CHN | Hubei | 4344600 |
1895 | Harbin | CHN | Heilongjiang | 4289800 |
1896 | Shenyang | CHN | Liaoning | 4265200 |
1897 | Kanton [Guangzhou] | CHN | Guangdong | 4256300 |
1898 | Chengdu | CHN | Sichuan | 3361500 |
1899 | Nanking [Nanjing] | CHN | Jiangsu | 2870300 |
1900 | Changchun | CHN | Jilin | 2812000 |
1901 | Xi´an | CHN | Shaanxi | 2761400 |
1902 | Dalian | CHN | Liaoning | 2697000 |
1903 | Qingdao | CHN | Shandong | 2596000 |
1904 | Jinan | CHN | Shandong | 2278100 |
1905 | Hangzhou | CHN | Zhejiang | 2190500 |
1906 | Zhengzhou | CHN | Henan | 2107200 |
1907 | Shijiazhuang | CHN | Hebei | 2041500 |
1908 | Taiyuan | CHN | Shanxi | 1968400 |
1909 | Kunming | CHN | Yunnan | 1829500 |
1910 | Changsha | CHN | Hunan | 1809800 |
1911 | Nanchang | CHN | Jiangxi | 1691600 |
1912 | Fuzhou | CHN | Fujian | 1593800 |
1913 | Lanzhou | CHN | Gansu | 1565800 |
1914 | Guiyang | CHN | Guizhou | 1465200 |
1915 | Ningbo | CHN | Zhejiang | 1371200 |
1916 | Hefei | CHN | Anhui | 1369100 |
1917 | Urumtši [Ürümqi] | CHN | Xinxiang | 1310100 |
1918 | Anshan | CHN | Liaoning | 1200000 |
1919 | Fushun | CHN | Liaoning | 1200000 |
1920 | Nanning | CHN | Guangxi | 1161800 |
1921 | Zibo | CHN | Shandong | 1140000 |
1922 | Qiqihar | CHN | Heilongjiang | 1070000 |
1923 | Jilin | CHN | Jilin | 1040000 |
1924 | Tangshan | CHN | Hebei | 1040000 |
1925 | Baotou | CHN | Inner Mongolia | 980000 |
1926 | Shenzhen | CHN | Guangdong | 950500 |
1927 | Hohhot | CHN | Inner Mongolia | 916700 |
1928 | Handan | CHN | Hebei | 840000 |
1929 | Wuxi | CHN | Jiangsu | 830000 |
1930 | Xuzhou | CHN | Jiangsu | 810000 |
1931 | Datong | CHN | Shanxi | 800000 |
1932 | Yichun | CHN | Heilongjiang | 800000 |
1933 | Benxi | CHN | Liaoning | 770000 |
1934 | Luoyang | CHN | Henan | 760000 |
1935 | Suzhou | CHN | Jiangsu | 710000 |
1936 | Xining | CHN | Qinghai | 700200 |
1937 | Huainan | CHN | Anhui | 700000 |
1938 | Jixi | CHN | Heilongjiang | 683885 |
1939 | Daqing | CHN | Heilongjiang | 660000 |
1940 | Fuxin | CHN | Liaoning | 640000 |
1941 | Amoy [Xiamen] | CHN | Fujian | 627500 |
1942 | Liuzhou | CHN | Guangxi | 610000 |
1943 | Shantou | CHN | Guangdong | 580000 |
1944 | Jinzhou | CHN | Liaoning | 570000 |
1945 | Mudanjiang | CHN | Heilongjiang | 570000 |
1946 | Yinchuan | CHN | Ningxia | 544500 |
1947 | Changzhou | CHN | Jiangsu | 530000 |
1948 | Zhangjiakou | CHN | Hebei | 530000 |
1949 | Dandong | CHN | Liaoning | 520000 |
1950 | Hegang | CHN | Heilongjiang | 520000 |
1951 | Kaifeng | CHN | Henan | 510000 |
1952 | Jiamusi | CHN | Heilongjiang | 493409 |
1953 | Liaoyang | CHN | Liaoning | 492559 |
1954 | Hengyang | CHN | Hunan | 487148 |
2812 | Abidjan | CIV | Abidjan | 2500000 |
1803 | Douala | CMR | Littoral | 1448300 |
1804 | Yaoundé | CMR | Centre | 1372800 |
2298 | Kinshasa | COD | Kinshasa | 5064000 |
2299 | Lubumbashi | COD | Shaba | 851381 |
2300 | Mbuji-Mayi | COD | East Kasai | 806475 |
2296 | Brazzaville | COG | Brazzaville | 950000 |
583 | Avarua | COK | Rarotonga | 11900 |
2257 | Santafé de Bogoti | COL | Santafé de Bogoti | 6260862 |
2258 | Cali | COL | Valle | 2077386 |
2259 | Medellkn | COL | Antioquia | 1861265 |
2260 | Barranquilla | COL | Atlintico | 1223260 |
2261 | Cartagena | COL | Bolkvar | 805757 |
2262 | Cscuta | COL | Norte de Santander | 606932 |
2295 | Moroni | COM | Njazidja | 36000 |
1859 | Praia | CPV | Sco Tiago | 94800 |
584 | San José | CRI | San José | 339131 |
2413 | La Habana | CUB | La Habana | 2256000 |
2414 | Santiago de Cuba | CUB | Santiago de Cuba | 433180 |
1791 | Flying Fish Cove | CXR | NULL | 700 |
553 | George Town | CYM | Grand Cayman | 19600 |
2430 | Nicosia | CYP | Nicosia | 195000 |
3339 | Praha | CZE | Hlavnk mesto Praha | 1181126 |
3340 | Brno | CZE | Jiznk Morava | 381862 |
3341 | Ostrava | CZE | Severnk Morava | 320041 |
3068 | Berlin | DEU | Berliini | 3386667 |
3069 | Hamburg | DEU | Hamburg | 1704735 |
3070 | Munich [München] | DEU | Baijeri | 1194560 |
3071 | Köln | DEU | Nordrhein-Westfalen | 962507 |
3072 | Frankfurt am Main | DEU | Hessen | 643821 |
3073 | Essen | DEU | Nordrhein-Westfalen | 599515 |
3074 | Dortmund | DEU | Nordrhein-Westfalen | 590213 |
3075 | Stuttgart | DEU | Baden-Württemberg | 582443 |
3076 | Düsseldorf | DEU | Nordrhein-Westfalen | 568855 |
3077 | Bremen | DEU | Bremen | 540330 |
3078 | Duisburg | DEU | Nordrhein-Westfalen | 519793 |
3079 | Hannover | DEU | Niedersachsen | 514718 |
3080 | Leipzig | DEU | Saksi | 489532 |
3081 | Nürnberg | DEU | Baijeri | 486628 |
3082 | Dresden | DEU | Saksi | 476668 |
3083 | Bochum | DEU | Nordrhein-Westfalen | 392830 |
3084 | Wuppertal | DEU | Nordrhein-Westfalen | 368993 |
3085 | Bielefeld | DEU | Nordrhein-Westfalen | 321125 |
3086 | Mannheim | DEU | Baden-Württemberg | 307730 |
3087 | Bonn | DEU | Nordrhein-Westfalen | 301048 |
585 | Djibouti | DJI | Djibouti | 383000 |
586 | Roseau | DMA | St George | 16243 |
3315 | Kubenhavn | DNK | Kubenhavn | 495699 |
3316 | Århus | DNK | Århus | 284846 |
587 | Santo Domingo de Guzmin | DOM | Distrito Nacional | 1609966 |
35 | Alger | DZA | Alger | 2168000 |
36 | Oran | DZA | Oran | 609823 |
37 | Constantine | DZA | Constantine | 443727 |
593 | Guayaquil | ECU | Guayas | 2070040 |
594 | Quito | ECU | Pichincha | 1573458 |
608 | Cairo | EGY | Kairo | 6789479 |
609 | Alexandria | EGY | Aleksandria | 3328196 |
610 | Giza | EGY | Giza | 2221868 |
611 | Shubra al-Khayma | EGY | al-Qalyubiya | 870716 |
652 | Asmara | ERI | Maekel | 431000 |
2453 | El-Aaisn | ESH | El-Aaisn | 169000 |
653 | Madrid | ESP | Madrid | 2879052 |
654 | Barcelona | ESP | Katalonia | 1503451 |
655 | Valencia | ESP | Valencia | 739412 |
656 | Sevilla | ESP | Andalusia | 701927 |
657 | Zaragoza | ESP | Aragonia | 603367 |
658 | Milaga | ESP | Andalusia | 530553 |
659 | Bilbao | ESP | Baskimaa | 357589 |
660 | Las Palmas de Gran Canaria | ESP | Canary Islands | 354757 |
661 | Murcia | ESP | Murcia | 353504 |
662 | Palma de Mallorca | ESP | Balears | 326993 |
663 | Valladolid | ESP | Castilla and León | 319998 |
664 | Córdoba | ESP | Andalusia | 311708 |
665 | Vigo | ESP | Galicia | 283670 |
3791 | Tallinn | EST | Harjumaa | 403981 |
756 | Addis Abeba | ETH | Addis Abeba | 2495000 |
3236 | Helsinki [Helsingfors] | FIN | Newmaa | 555474 |
764 | Suva | FJI | Central | 77366 |
763 | Stanley | FLK | East Falkland | 1636 |
2974 | Paris | FRA | Ile-de-France | 2125246 |
2975 | Marseille | FRA | Provence-Alpes-Cote | 798430 |
2976 | Lyon | FRA | Rhone-Alpes | 445452 |
2977 | Toulouse | FRA | Midi-Pyrénées | 390350 |
2978 | Nice | FRA | Provence-Alpes-Cote | 342738 |
2979 | Nantes | FRA | Pays de la Loire | 270251 |
2980 | Strasbourg | FRA | Alsace | 264115 |
901 | Tórshavn | FRO | Streymoyar | 14542 |
2688 | Weno | FSM | Chuuk | 22000 |
902 | Libreville | GAB | Estuaire | 419000 |
456 | London | GBR | England | 7285000 |
457 | Birmingham | GBR | England | 1013000 |
458 | Glasgow | GBR | Scotland | 619680 |
459 | Liverpool | GBR | England | 461000 |
460 | Edinburgh | GBR | Scotland | 450180 |
461 | Sheffield | GBR | England | 431607 |
462 | Manchester | GBR | England | 430000 |
463 | Leeds | GBR | England | 424194 |
464 | Bristol | GBR | England | 402000 |
465 | Cardiff | GBR | Wales | 321000 |
466 | Coventry | GBR | England | 304000 |
467 | Leicester | GBR | England | 294000 |
468 | Bradford | GBR | England | 289376 |
469 | Belfast | GBR | North Ireland | 287500 |
470 | Nottingham | GBR | England | 287000 |
905 | Tbilisi | GEO | Tbilisi | 1235200 |
910 | Accra | GHA | Greater Accra | 1070000 |
911 | Kumasi | GHA | Ashanti | 385192 |
915 | Gibraltar | GIB | NULL | 27025 |
926 | Conakry | GIN | Conakry | 1090610 |
918 | Les Abymes | GLP | Grande-Terre | 62947 |
903 | Serekunda | GMB | Kombo St Mary | 102600 |
927 | Bissau | GNB | Bissau | 241000 |
2972 | Malabo | GNQ | Bioko | 40000 |
2401 | Athenai | GRC | Attika | 772072 |
2402 | Thessaloniki | GRC | Central Macedonia | 383967 |
916 | Saint George´s | GRD | St George | 4621 |
917 | Nuuk | GRL | Kitaa | 13445 |
922 | Ciudad de Guatemala | GTM | Guatemala | 823301 |
3014 | Cayenne | GUF | Cayenne | 50699 |
920 | Tamuning | GUM | NULL | 9500 |
928 | Georgetown | GUY | Georgetown | 254000 |
936 | Kowloon and New Kowloon | HKG | Kowloon and New Kowl | 1987996 |
933 | Tegucigalpa | HND | Distrito Central | 813900 |
2409 | Zagreb | HRV | Grad Zagreb | 706770 |
929 | Port-au-Prince | HTI | Ouest | 884472 |
3483 | Budapest | HUN | Budapest | 1811552 |
939 | Jakarta | IDN | Jakarta Raya | 9604900 |
940 | Surabaya | IDN | East Java | 2663820 |
941 | Bandung | IDN | West Java | 2429000 |
942 | Medan | IDN | Sumatera Utara | 1843919 |
943 | Palembang | IDN | Sumatera Selatan | 1222764 |
944 | Tangerang | IDN | West Java | 1198300 |
945 | Semarang | IDN | Central Java | 1104405 |
946 | Ujung Pandang | IDN | Sulawesi Selatan | 1060257 |
947 | Malang | IDN | East Java | 716862 |
948 | Bandar Lampung | IDN | Lampung | 680332 |
949 | Bekasi | IDN | West Java | 644300 |
950 | Padang | IDN | Sumatera Barat | 534474 |
951 | Surakarta | IDN | Central Java | 518600 |
952 | Banjarmasin | IDN | Kalimantan Selatan | 482931 |
1024 | Mumbai (Bombay) | IND | Maharashtra | 10500000 |
1025 | Delhi | IND | Delhi | 7206704 |
1026 | Calcutta [Kolkata] | IND | West Bengali | 4399819 |
1027 | Chennai (Madras) | IND | Tamil Nadu | 3841396 |
1028 | Hyderabad | IND | Andhra Pradesh | 2964638 |
1029 | Ahmedabad | IND | Gujarat | 2876710 |
1030 | Bangalore | IND | Karnataka | 2660088 |
1031 | Kanpur | IND | Uttar Pradesh | 1874409 |
1032 | Nagpur | IND | Maharashtra | 1624752 |
1033 | Lucknow | IND | Uttar Pradesh | 1619115 |
1034 | Pune | IND | Maharashtra | 1566651 |
1035 | Surat | IND | Gujarat | 1498817 |
1036 | Jaipur | IND | Rajasthan | 1458483 |
1037 | Indore | IND | Madhya Pradesh | 1091674 |
1038 | Bhopal | IND | Madhya Pradesh | 1062771 |
1039 | Ludhiana | IND | Punjab | 1042740 |
1040 | Vadodara (Baroda) | IND | Gujarat | 1031346 |
1041 | Kalyan | IND | Maharashtra | 1014557 |
1042 | Madurai | IND | Tamil Nadu | 977856 |
1043 | Haora (Howrah) | IND | West Bengali | 950435 |
1044 | Varanasi (Benares) | IND | Uttar Pradesh | 929270 |
1045 | Patna | IND | Bihar | 917243 |
1046 | Srinagar | IND | Jammu and Kashmir | 892506 |
1047 | Agra | IND | Uttar Pradesh | 891790 |
1048 | Coimbatore | IND | Tamil Nadu | 816321 |
1049 | Thane (Thana) | IND | Maharashtra | 803389 |
1050 | Allahabad | IND | Uttar Pradesh | 792858 |
1051 | Meerut | IND | Uttar Pradesh | 753778 |
1052 | Vishakhapatnam | IND | Andhra Pradesh | 752037 |
1053 | Jabalpur | IND | Madhya Pradesh | 741927 |
1054 | Amritsar | IND | Punjab | 708835 |
1055 | Faridabad | IND | Haryana | 703592 |
1056 | Vijayawada | IND | Andhra Pradesh | 701827 |
1057 | Gwalior | IND | Madhya Pradesh | 690765 |
1058 | Jodhpur | IND | Rajasthan | 666279 |
1059 | Nashik (Nasik) | IND | Maharashtra | 656925 |
1060 | Hubli-Dharwad | IND | Karnataka | 648298 |
1061 | Solapur (Sholapur) | IND | Maharashtra | 604215 |
1062 | Ranchi | IND | Jharkhand | 599306 |
1063 | Bareilly | IND | Uttar Pradesh | 587211 |
1064 | Guwahati (Gauhati) | IND | Assam | 584342 |
1065 | Shambajinagar (Aurangabad) | IND | Maharashtra | 573272 |
1066 | Cochin (Kochi) | IND | Kerala | 564589 |
1067 | Rajkot | IND | Gujarat | 559407 |
1068 | Kota | IND | Rajasthan | 537371 |
1069 | Thiruvananthapuram (Trivandrum | IND | Kerala | 524006 |
1070 | Pimpri-Chinchwad | IND | Maharashtra | 517083 |
1071 | Jalandhar (Jullundur) | IND | Punjab | 509510 |
1072 | Gorakhpur | IND | Uttar Pradesh | 505566 |
1073 | Chandigarh | IND | Chandigarh | 504094 |
1074 | Mysore | IND | Karnataka | 480692 |
1075 | Aligarh | IND | Uttar Pradesh | 480520 |
1076 | Guntur | IND | Andhra Pradesh | 471051 |
1077 | Jamshedpur | IND | Jharkhand | 460577 |
1078 | Ghaziabad | IND | Uttar Pradesh | 454156 |
1079 | Warangal | IND | Andhra Pradesh | 447657 |
1080 | Raipur | IND | Chhatisgarh | 438639 |
1081 | Moradabad | IND | Uttar Pradesh | 429214 |
1082 | Durgapur | IND | West Bengali | 425836 |
1083 | Amravati | IND | Maharashtra | 421576 |
1084 | Calicut (Kozhikode) | IND | Kerala | 419831 |
1085 | Bikaner | IND | Rajasthan | 416289 |
1086 | Bhubaneswar | IND | Orissa | 411542 |
1087 | Kolhapur | IND | Maharashtra | 406370 |
1088 | Kataka (Cuttack) | IND | Orissa | 403418 |
1089 | Ajmer | IND | Rajasthan | 402700 |
1090 | Bhavnagar | IND | Gujarat | 402338 |
1091 | Tiruchirapalli | IND | Tamil Nadu | 387223 |
1092 | Bhilai | IND | Chhatisgarh | 386159 |
1093 | Bhiwandi | IND | Maharashtra | 379070 |
1094 | Saharanpur | IND | Uttar Pradesh | 374945 |
1095 | Ulhasnagar | IND | Maharashtra | 369077 |
1096 | Salem | IND | Tamil Nadu | 366712 |
1097 | Ujjain | IND | Madhya Pradesh | 362266 |
1447 | Dublin | IRL | Leinster | 481854 |
1380 | Teheran | IRN | Teheran | 6758845 |
1381 | Mashhad | IRN | Khorasan | 1887405 |
1382 | Esfahan | IRN | Esfahan | 1266072 |
1383 | Tabriz | IRN | East Azerbaidzan | 1191043 |
1384 | Shiraz | IRN | Fars | 1053025 |
1385 | Karaj | IRN | Teheran | 940968 |
1386 | Ahvaz | IRN | Khuzestan | 804980 |
1387 | Qom | IRN | Qom | 777677 |
1388 | Kermanshah | IRN | Kermanshah | 692986 |
1389 | Urmia | IRN | West Azerbaidzan | 435200 |
1390 | Zahedan | IRN | Sistan va Baluchesta | 419518 |
1391 | Rasht | IRN | Gilan | 417748 |
1392 | Hamadan | IRN | Hamadan | 401281 |
1365 | Baghdad | IRQ | Baghdad | 4336000 |
1366 | Mosul | IRQ | Ninawa | 879000 |
1449 | Reykjavkk | ISL | Höfušborgarsveši | 109184 |
1450 | Jerusalem | ISR | Jerusalem | 633700 |
1451 | Tel Aviv-Jaffa | ISR | Tel Aviv | 348100 |
1452 | Haifa | ISR | Haifa | 265700 |
1464 | Roma | ITA | Latium | 2643581 |
1465 | Milano | ITA | Lombardia | 1300977 |
1466 | Napoli | ITA | Campania | 1002619 |
1467 | Torino | ITA | Piemonte | 903705 |
1468 | Palermo | ITA | Sisilia | 683794 |
1469 | Genova | ITA | Liguria | 636104 |
1470 | Bologna | ITA | Emilia-Romagna | 381161 |
1471 | Firenze | ITA | Toscana | 376662 |
1472 | Catania | ITA | Sisilia | 337862 |
1473 | Bari | ITA | Apulia | 331848 |
1474 | Venezia | ITA | Veneto | 277305 |
1529 | Spanish Town | JAM | St. Catherine | 110379 |
1786 | Amman | JOR | Amman | 1000000 |
1787 | al-Zarqa | JOR | al-Zarqa | 389815 |
1532 | Tokyo | JPN | Tokyo-to | 7980230 |
1533 | Jokohama [Yokohama] | JPN | Kanagawa | 3339594 |
1534 | Osaka | JPN | Osaka | 2595674 |
1535 | Nagoya | JPN | Aichi | 2154376 |
1536 | Sapporo | JPN | Hokkaido | 1790886 |
1537 | Kioto | JPN | Kyoto | 1461974 |
1538 | Kobe | JPN | Hyogo | 1425139 |
1539 | Fukuoka | JPN | Fukuoka | 1308379 |
1540 | Kawasaki | JPN | Kanagawa | 1217359 |
1541 | Hiroshima | JPN | Hiroshima | 1119117 |
1542 | Kitakyushu | JPN | Fukuoka | 1016264 |
1543 | Sendai | JPN | Miyagi | 989975 |
1544 | Chiba | JPN | Chiba | 863930 |
1545 | Sakai | JPN | Osaka | 797735 |
1546 | Kumamoto | JPN | Kumamoto | 656734 |
1547 | Okayama | JPN | Okayama | 624269 |
1548 | Sagamihara | JPN | Kanagawa | 586300 |
1549 | Hamamatsu | JPN | Shizuoka | 568796 |
1550 | Kagoshima | JPN | Kagoshima | 549977 |
1551 | Funabashi | JPN | Chiba | 545299 |
1552 | Higashiosaka | JPN | Osaka | 517785 |
1553 | Hachioji | JPN | Tokyo-to | 513451 |
1554 | Niigata | JPN | Niigata | 497464 |
1555 | Amagasaki | JPN | Hyogo | 481434 |
1556 | Himeji | JPN | Hyogo | 475167 |
1557 | Shizuoka | JPN | Shizuoka | 473854 |
1558 | Urawa | JPN | Saitama | 469675 |
1559 | Matsuyama | JPN | Ehime | 466133 |
1560 | Matsudo | JPN | Chiba | 461126 |
1561 | Kanazawa | JPN | Ishikawa | 455386 |
1562 | Kawaguchi | JPN | Saitama | 452155 |
1563 | Ichikawa | JPN | Chiba | 441893 |
1564 | Omiya | JPN | Saitama | 441649 |
1565 | Utsunomiya | JPN | Tochigi | 440353 |
1566 | Oita | JPN | Oita | 433401 |
1567 | Nagasaki | JPN | Nagasaki | 432759 |
1568 | Yokosuka | JPN | Kanagawa | 430200 |
1569 | Kurashiki | JPN | Okayama | 425103 |
1570 | Gifu | JPN | Gifu | 408007 |
1571 | Hirakata | JPN | Osaka | 403151 |
1572 | Nishinomiya | JPN | Hyogo | 397618 |
1573 | Toyonaka | JPN | Osaka | 396689 |
1574 | Wakayama | JPN | Wakayama | 391233 |
1575 | Fukuyama | JPN | Hiroshima | 376921 |
1576 | Fujisawa | JPN | Kanagawa | 372840 |
1577 | Asahikawa | JPN | Hokkaido | 364813 |
1578 | Machida | JPN | Tokyo-to | 364197 |
1579 | Nara | JPN | Nara | 362812 |
1580 | Takatsuki | JPN | Osaka | 361747 |
1581 | Iwaki | JPN | Fukushima | 361737 |
1582 | Nagano | JPN | Nagano | 361391 |
1583 | Toyohashi | JPN | Aichi | 360066 |
1584 | Toyota | JPN | Aichi | 346090 |
1585 | Suita | JPN | Osaka | 345750 |
1586 | Takamatsu | JPN | Kagawa | 332471 |
1587 | Koriyama | JPN | Fukushima | 330335 |
1588 | Okazaki | JPN | Aichi | 328711 |
1589 | Kawagoe | JPN | Saitama | 327211 |
1590 | Tokorozawa | JPN | Saitama | 325809 |
1591 | Toyama | JPN | Toyama | 325790 |
1592 | Kochi | JPN | Kochi | 324710 |
1593 | Kashiwa | JPN | Chiba | 320296 |
1594 | Akita | JPN | Akita | 314440 |
1860 | Almaty | KAZ | Almaty Qalasy | 1129400 |
1861 | Qaraghandy | KAZ | Qaraghandy | 436900 |
1862 | Shymkent | KAZ | South Kazakstan | 360100 |
1863 | Taraz | KAZ | Taraz | 330100 |
1864 | Astana | KAZ | Astana | 311200 |
1865 | Öskemen | KAZ | East Kazakstan | 311000 |
1866 | Pavlodar | KAZ | Pavlodar | 300500 |
1867 | Semey | KAZ | East Kazakstan | 269600 |
1881 | Nairobi | KEN | Nairobi | 2290000 |
1882 | Mombasa | KEN | Coast | 461753 |
2253 | Bishkek | KGZ | Bishkek shaary | 589400 |
1800 | Phnom Penh | KHM | Phnom Penh | 570155 |
2255 | Bikenibeu | KIR | South Tarawa | 5055 |
3064 | Basseterre | KNA | St George Basseterre | 11600 |
2331 | Seoul | KOR | Seoul | 9981619 |
2332 | Pusan | KOR | Pusan | 3804522 |
2333 | Inchon | KOR | Inchon | 2559424 |
2334 | Taegu | KOR | Taegu | 2548568 |
2335 | Taejon | KOR | Taejon | 1425835 |
2336 | Kwangju | KOR | Kwangju | 1368341 |
2337 | Ulsan | KOR | Kyongsangnam | 1084891 |
2338 | Songnam | KOR | Kyonggi | 869094 |
2339 | Puchon | KOR | Kyonggi | 779412 |
2340 | Suwon | KOR | Kyonggi | 755550 |
2341 | Anyang | KOR | Kyonggi | 591106 |
2342 | Chonju | KOR | Chollabuk | 563153 |
2427 | al-Salimiya | KWT | Hawalli | 130215 |
2428 | Jalib al-Shuyukh | KWT | Hawalli | 102178 |
2432 | Vientiane | LAO | Viangchan | 531800 |
2438 | Beirut | LBN | Beirut | 1100000 |
2440 | Monrovia | LBR | Montserrado | 850000 |
2441 | Tripoli | LBY | Tripoli | 1682000 |
2442 | Bengasi | LBY | Bengasi | 804000 |
3065 | Castries | LCA | Castries | 2301 |
2445 | Schaan | LIE | Schaan | 5346 |
3217 | Colombo | LKA | Western | 645000 |
2437 | Maseru | LSO | Maseru | 297000 |
2447 | Vilnius | LTU | Vilna | 577969 |
2448 | Kaunas | LTU | Kaunas | 412639 |
2452 | Luxembourg [Luxemburg/Letzebuerg] | LUX | Luxembourg | 80700 |
2434 | Riga | LVA | Riika | 764328 |
2454 | Macao | MAC | Macau | 437500 |
2485 | Casablanca | MAR | Casablanca | 2940623 |
2486 | Rabat | MAR | Rabat-Salé-Zammour-Z | 623457 |
2487 | Marrakech | MAR | Marrakech-Tensift-Al | 621914 |
2488 | Fcs | MAR | Fcs-Boulemane | 541162 |
2489 | Tanger | MAR | Tanger-Tétouan | 521735 |
2490 | Salé | MAR | Rabat-Salé-Zammour-Z | 504420 |
2491 | Mekncs | MAR | Mekncs-Tafilalet | 460000 |
2694 | Monte-Carlo | MCO | NULL | 13154 |
2690 | Chisinau | MDA | Chisinau | 719900 |
2455 | Antananarivo | MDG | Antananarivo | 675669 |
2463 | Male | MDV | Maale | 71000 |
2515 | Ciudad de México | MEX | Distrito Federal | 8591309 |
2516 | Guadalajara | MEX | Jalisco | 1647720 |
2517 | Ecatepec de Morelos | MEX | México | 1620303 |
2518 | Puebla | MEX | Puebla | 1346176 |
2519 | Nezahualcóyotl | MEX | México | 1224924 |
2520 | Juirez | MEX | Chihuahua | 1217818 |
2521 | Tijuana | MEX | Baja California | 1212232 |
2522 | León | MEX | Guanajuato | 1133576 |
2523 | Monterrey | MEX | Nuevo León | 1108499 |
2524 | Zapopan | MEX | Jalisco | 1002239 |
2525 | Naucalpan de Juirez | MEX | México | 857511 |
2526 | Mexicali | MEX | Baja California | 764902 |
2527 | Culiacin | MEX | Sinaloa | 744859 |
2528 | Acapulco de Juirez | MEX | Guerrero | 721011 |
2529 | Tlalnepantla de Baz | MEX | México | 720755 |
2530 | Mérida | MEX | Yucatin | 703324 |
2531 | Chihuahua | MEX | Chihuahua | 670208 |
2532 | San Luis Potosk | MEX | San Luis Potosk | 669353 |
2533 | Guadalupe | MEX | Nuevo León | 668780 |
2534 | Toluca | MEX | México | 665617 |
2535 | Aguascalientes | MEX | Aguascalientes | 643360 |
2536 | Querétaro | MEX | Querétaro de Arteaga | 639839 |
2537 | Morelia | MEX | Michoacin de Ocampo | 619958 |
2538 | Hermosillo | MEX | Sonora | 608697 |
2539 | Saltillo | MEX | Coahuila de Zaragoza | 577352 |
2540 | Torreón | MEX | Coahuila de Zaragoza | 529093 |
2541 | Centro (Villahermosa) | MEX | Tabasco | 519873 |
2542 | San Nicolis de los Garza | MEX | Nuevo León | 495540 |
2543 | Durango | MEX | Durango | 490524 |
2544 | Chimalhuacin | MEX | México | 490245 |
2545 | Tlaquepaque | MEX | Jalisco | 475472 |
2546 | Atizapin de Zaragoza | MEX | México | 467262 |
2547 | Veracruz | MEX | Veracruz | 457119 |
2548 | Cuautitlin Izcalli | MEX | México | 452976 |
2549 | Irapuato | MEX | Guanajuato | 440039 |
2550 | Tuxtla Gutiérrez | MEX | Chiapas | 433544 |
2551 | Tultitlin | MEX | México | 432411 |
2552 | Reynosa | MEX | Tamaulipas | 419776 |
2553 | Benito Juirez | MEX | Quintana Roo | 419276 |
2554 | Matamoros | MEX | Tamaulipas | 416428 |
2555 | Xalapa | MEX | Veracruz | 390058 |
2556 | Celaya | MEX | Guanajuato | 382140 |
2557 | Mazatlin | MEX | Sinaloa | 380265 |
2558 | Ensenada | MEX | Baja California | 369573 |
2559 | Ahome | MEX | Sinaloa | 358663 |
2560 | Cajeme | MEX | Sonora | 355679 |
2507 | Dalap-Uliga-Darrit | MHL | Majuro | 28000 |
2460 | Skopje | MKD | Skopje | 444299 |
2482 | Bamako | MLI | Bamako | 809552 |
2483 | Birkirkara | MLT | Outer Harbour | 21445 |
2710 | Rangoon (Yangon) | MMR | Rangoon [Yangon] | 3361700 |
2711 | Mandalay | MMR | Mandalay | 885300 |
2696 | Ulan Bator | MNG | Ulaanbaatar | 773700 |
2913 | Garapan | MNP | Saipan | 9200 |
2698 | Maputo | MOZ | Maputo | 1018938 |
2699 | Matola | MOZ | Maputo | 424662 |
2700 | Beira | MOZ | Sofala | 397368 |
2701 | Nampula | MOZ | Nampula | 303346 |
2509 | Nouakchott | MRT | Nouakchott | 667300 |
2697 | Plymouth | MSR | Plymouth | 2000 |
2508 | Fort-de-France | MTQ | Fort-de-France | 94050 |
2511 | Port-Louis | MUS | Port-Louis | 138200 |
2461 | Blantyre | MWI | Blantyre | 478155 |
2464 | Kuala Lumpur | MYS | Wilayah Persekutuan | 1297526 |
2465 | Ipoh | MYS | Perak | 382853 |
2466 | Johor Baharu | MYS | Johor | 328436 |
2514 | Mamoutzou | MYT | Mamoutzou | 12000 |
2726 | Windhoek | NAM | Khomas | 169000 |
3493 | Nouméa | NCL | NULL | 76293 |
2738 | Niamey | NER | Niamey | 420000 |
2806 | Kingston | NFK | NULL | 800 |
2741 | Lagos | NGA | Lagos | 1518000 |
2742 | Ibadan | NGA | Oyo & Osun | 1432000 |
2743 | Ogbomosho | NGA | Oyo & Osun | 730000 |
2744 | Kano | NGA | Kano & Jigawa | 674100 |
2745 | Oshogbo | NGA | Oyo & Osun | 476800 |
2746 | Ilorin | NGA | Kwara & Kogi | 475800 |
2747 | Abeokuta | NGA | Ogun | 427400 |
2748 | Port Harcourt | NGA | Rivers & Bayelsa | 410000 |
2749 | Zaria | NGA | Kaduna | 379200 |
2750 | Ilesha | NGA | Oyo & Osun | 378400 |
2751 | Onitsha | NGA | Anambra & Enugu & Eb | 371900 |
2752 | Iwo | NGA | Oyo & Osun | 362000 |
2753 | Ado-Ekiti | NGA | Ondo & Ekiti | 359400 |
2754 | Abuja | NGA | Federal Capital Dist | 350100 |
2755 | Kaduna | NGA | Kaduna | 342200 |
2756 | Mushin | NGA | Lagos | 333200 |
2757 | Maiduguri | NGA | Borno & Yobe | 320000 |
2758 | Enugu | NGA | Anambra & Enugu & Eb | 316100 |
2759 | Ede | NGA | Oyo & Osun | 307100 |
2760 | Aba | NGA | Imo & Abia | 298900 |
2761 | Ife | NGA | Oyo & Osun | 296800 |
2734 | Managua | NIC | Managua | 959000 |
2805 | Alofi | NIU | NULL | 682 |
5 | Amsterdam | NLD | Noord-Holland | 731200 |
6 | Rotterdam | NLD | Zuid-Holland | 593321 |
7 | Haag | NLD | Zuid-Holland | 440900 |
8 | Utrecht | NLD | Utrecht | 234323 |
9 | Eindhoven | NLD | Noord-Brabant | 201843 |
10 | Tilburg | NLD | Noord-Brabant | 193238 |
2807 | Oslo | NOR | Oslo | 508726 |
2808 | Bergen | NOR | Hordaland | 230948 |
2729 | Kathmandu | NPL | Central | 591835 |
2727 | Yangor | NRU | NULL | 4050 |
3494 | Auckland | NZL | Auckland | 381800 |
3495 | Christchurch | NZL | Canterbury | 324200 |
3496 | Manukau | NZL | Auckland | 281800 |
2817 | al-Sib | OMN | Masqat | 155000 |
2818 | Salala | OMN | Zufar | 131813 |
2819 | Bawshar | OMN | Masqat | 107500 |
2822 | Karachi | PAK | Sindh | 9269265 |
2823 | Lahore | PAK | Punjab | 5063499 |
2824 | Faisalabad | PAK | Punjab | 1977246 |
2825 | Rawalpindi | PAK | Punjab | 1406214 |
2826 | Multan | PAK | Punjab | 1182441 |
2827 | Hyderabad | PAK | Sindh | 1151274 |
2828 | Gujranwala | PAK | Punjab | 1124749 |
2829 | Peshawar | PAK | Nothwest Border Prov | 988005 |
2830 | Quetta | PAK | Baluchistan | 560307 |
2882 | Ciudad de Panami | PAN | Panami | 471373 |
2912 | Adamstown | PCN | NULL | 42 |
2890 | Lima | PER | Lima | 6464693 |
2891 | Arequipa | PER | Arequipa | 762000 |
2892 | Trujillo | PER | La Libertad | 652000 |
765 | Quezon | PHL | National Capital Reg | 2173831 |
766 | Manila | PHL | National Capital Reg | 1581082 |
767 | Kalookan | PHL | National Capital Reg | 1177604 |
768 | Davao | PHL | Southern Mindanao | 1147116 |
769 | Cebu | PHL | Central Visayas | 718821 |
770 | Zamboanga | PHL | Western Mindanao | 601794 |
771 | Pasig | PHL | National Capital Reg | 505058 |
772 | Valenzuela | PHL | National Capital Reg | 485433 |
773 | Las Pinas | PHL | National Capital Reg | 472780 |
774 | Antipolo | PHL | Southern Tagalog | 470866 |
775 | Taguig | PHL | National Capital Reg | 467375 |
776 | Cagayan de Oro | PHL | Northern Mindanao | 461877 |
777 | Paranaque | PHL | National Capital Reg | 449811 |
778 | Makati | PHL | National Capital Reg | 444867 |
779 | Bacolod | PHL | Western Visayas | 429076 |
780 | General Santos | PHL | Southern Mindanao | 411822 |
781 | Marikina | PHL | National Capital Reg | 391170 |
782 | Dasmarinas | PHL | Southern Tagalog | 379520 |
783 | Muntinlupa | PHL | National Capital Reg | 379310 |
784 | Iloilo | PHL | Western Visayas | 365820 |
785 | Pasay | PHL | National Capital Reg | 354908 |
786 | Malabon | PHL | National Capital Reg | 338855 |
787 | San José del Monte | PHL | Central Luzon | 315807 |
788 | Bacoor | PHL | Southern Tagalog | 305699 |
789 | Iligan | PHL | Central Mindanao | 285061 |
790 | Calamba | PHL | Southern Tagalog | 281146 |
791 | Mandaluyong | PHL | National Capital Reg | 278474 |
792 | Butuan | PHL | Caraga | 267279 |
793 | Angeles | PHL | Central Luzon | 263971 |
794 | Tarlac | PHL | Central Luzon | 262481 |
795 | Mandaue | PHL | Central Visayas | 259728 |
796 | Baguio | PHL | CAR | 252386 |
797 | Batangas | PHL | Southern Tagalog | 247588 |
798 | Cainta | PHL | Southern Tagalog | 242511 |
799 | San Pedro | PHL | Southern Tagalog | 231403 |
800 | Navotas | PHL | National Capital Reg | 230403 |
2881 | Koror | PLW | Koror | 12000 |
2884 | Port Moresby | PNG | National Capital Dis | 247000 |
2928 | Warszawa | POL | Mazowieckie | 1615369 |
2929 | Lódz | POL | Lodzkie | 800110 |
2930 | Kraków | POL | Malopolskie | 738150 |
2931 | Wroclaw | POL | Dolnoslaskie | 636765 |
2932 | Poznan | POL | Wielkopolskie | 576899 |
2933 | Gdansk | POL | Pomorskie | 458988 |
2934 | Szczecin | POL | Zachodnio-Pomorskie | 416988 |
2935 | Bydgoszcz | POL | Kujawsko-Pomorskie | 386855 |
2936 | Lublin | POL | Lubelskie | 356251 |
2937 | Katowice | POL | Slaskie | 345934 |
2938 | Bialystok | POL | Podlaskie | 283937 |
2919 | San Juan | PRI | San Juan | 434374 |
2920 | Bayamón | PRI | Bayamón | 224044 |
2921 | Ponce | PRI | Ponce | 186475 |
2922 | Carolina | PRI | Carolina | 186076 |
2318 | Pyongyang | PRK | Pyongyang-si | 2484000 |
2319 | Hamhung | PRK | Hamgyong N | 709730 |
2320 | Chongjin | PRK | Hamgyong P | 582480 |
2321 | Nampo | PRK | Nampo-si | 566200 |
2914 | Lisboa | PRT | Lisboa | 563210 |
2915 | Porto | PRT | Porto | 273060 |
2885 | Asunción | PRY | Asunción | 557776 |
4074 | Gaza | PSE | Gaza | 353632 |
3015 | Faaa | PYF | Tahiti | 25888 |
2973 | Doha | QAT | Doha | 355000 |
3017 | Saint-Denis | REU | Saint-Denis | 131480 |
3018 | Bucuresti | ROM | Bukarest | 2016131 |
3019 | Iasi | ROM | Iasi | 348070 |
3020 | Constanta | ROM | Constanta | 342264 |
3021 | Cluj-Napoca | ROM | Cluj | 332498 |
3022 | Galati | ROM | Galati | 330276 |
3023 | Timisoara | ROM | Timis | 324304 |
3024 | Brasov | ROM | Brasov | 314225 |
3025 | Craiova | ROM | Dolj | 313530 |
3580 | Moscow | RUS | Moscow (City) | 8389200 |
3581 | St Petersburg | RUS | Pietari | 4694000 |
3582 | Novosibirsk | RUS | Novosibirsk | 1398800 |
3583 | Nizni Novgorod | RUS | Nizni Novgorod | 1357000 |
3584 | Jekaterinburg | RUS | Sverdlovsk | 1266300 |
3585 | Samara | RUS | Samara | 1156100 |
3586 | Omsk | RUS | Omsk | 1148900 |
3587 | Kazan | RUS | Tatarstan | 1101000 |
3588 | Ufa | RUS | Baškortostan | 1091200 |
3589 | Tšeljabinsk | RUS | Tšeljabinsk | 1083200 |
3590 | Rostov-na-Donu | RUS | Rostov-na-Donu | 1012700 |
3591 | Perm | RUS | Perm | 1009700 |
3592 | Volgograd | RUS | Volgograd | 993400 |
3593 | Voronez | RUS | Voronez | 907700 |
3594 | Krasnojarsk | RUS | Krasnojarsk | 875500 |
3595 | Saratov | RUS | Saratov | 874000 |
3596 | Toljatti | RUS | Samara | 722900 |
3597 | Uljanovsk | RUS | Uljanovsk | 667400 |
3598 | Izevsk | RUS | Udmurtia | 652800 |
3599 | Krasnodar | RUS | Krasnodar | 639000 |
3600 | Jaroslavl | RUS | Jaroslavl | 616700 |
3601 | Habarovsk | RUS | Habarovsk | 609400 |
3602 | Vladivostok | RUS | Primorje | 606200 |
3603 | Irkutsk | RUS | Irkutsk | 593700 |
3604 | Barnaul | RUS | Altai | 580100 |
3605 | Novokuznetsk | RUS | Kemerovo | 561600 |
3606 | Penza | RUS | Penza | 532200 |
3607 | Rjazan | RUS | Rjazan | 529900 |
3608 | Orenburg | RUS | Orenburg | 523600 |
3609 | Lipetsk | RUS | Lipetsk | 521000 |
3610 | Nabereznyje Tšelny | RUS | Tatarstan | 514700 |
3611 | Tula | RUS | Tula | 506100 |
3612 | Tjumen | RUS | Tjumen | 503400 |
3613 | Kemerovo | RUS | Kemerovo | 492700 |
3614 | Astrahan | RUS | Astrahan | 486100 |
3615 | Tomsk | RUS | Tomsk | 482100 |
3616 | Kirov | RUS | Kirov | 466200 |
3617 | Ivanovo | RUS | Ivanovo | 459200 |
3618 | Tšeboksary | RUS | Tšuvassia | 459200 |
3619 | Brjansk | RUS | Brjansk | 457400 |
3620 | Tver | RUS | Tver | 454900 |
3621 | Kursk | RUS | Kursk | 443500 |
3622 | Magnitogorsk | RUS | Tšeljabinsk | 427900 |
3623 | Kaliningrad | RUS | Kaliningrad | 424400 |
3624 | Nizni Tagil | RUS | Sverdlovsk | 390900 |
3625 | Murmansk | RUS | Murmansk | 376300 |
3626 | Ulan-Ude | RUS | Burjatia | 370400 |
3047 | Kigali | RWA | Kigali | 286000 |
3173 | Riyadh | SAU | Riyadh | 3324000 |
3174 | Jedda | SAU | Mekka | 2046300 |
3175 | Mekka | SAU | Mekka | 965700 |
3176 | Medina | SAU | Medina | 608300 |
3177 | al-Dammam | SAU | al-Sharqiya | 482300 |
3224 | Omdurman | SDN | Khartum | 1271403 |
3225 | Khartum | SDN | Khartum | 947483 |
3226 | Sharq al-Nil | SDN | Khartum | 700887 |
3197 | Pikine | SEN | Cap-Vert | 855287 |
3198 | Dakar | SEN | Cap-Vert | 785071 |
3208 | Singapore | SGP | NULL | 4017733 |
3063 | Jamestown | SHN | Saint Helena | 1500 |
938 | Longyearbyen | SJM | Länsimaa | 1438 |
3161 | Honiara | SLB | Honiara | 50100 |
3207 | Freetown | SLE | Western | 850000 |
645 | San Salvador | SLV | San Salvador | 415346 |
3170 | Serravalle | SMR | Serravalle/Dogano | 4802 |
3214 | Mogadishu | SOM | Banaadir | 997000 |
3067 | Saint-Pierre | SPM | Saint-Pierre | 5808 |
3172 | Sco Tomé | STP | Aqua Grande | 49541 |
3243 | Paramaribo | SUR | Paramaribo | 112000 |
3209 | Bratislava | SVK | Bratislava | 448292 |
3212 | Ljubljana | SVN | Osrednjeslovenska | 270986 |
3048 | Stockholm | SWE | Lisboa | 750348 |
3049 | Gothenburg [Göteborg] | SWE | West Götanmaan län | 466990 |
3050 | Malmö | SWE | Skåne län | 259579 |
3244 | Mbabane | SWZ | Hhohho | 61000 |
3206 | Victoria | SYC | Mahé | 41000 |
3250 | Damascus | SYR | Damascus | 1347000 |
3251 | Aleppo | SYR | Aleppo | 1261983 |
3252 | Hims | SYR | Hims | 507404 |
3423 | Cockburn Town | TCA | Grand Turk | 4800 |
3337 | N´Djaména | TCD | Chari-Baguirmi | 530965 |
3332 | Lomé | TGO | Maritime | 375000 |
3320 | Bangkok | THA | Bangkok | 6320174 |
3261 | Dushanbe | TJK | Karotegin | 524000 |
3333 | Fakaofo | TKL | Fakaofo | 300 |
3419 | Ashgabat | TKM | Ahal | 540600 |
1522 | Dili | TMP | Dili | 47900 |
3334 | Nuku´alofa | TON | Tongatapu | 22400 |
3335 | Chaguanas | TTO | Caroni | 56601 |
3349 | Tunis | TUN | Tunis | 690600 |
3350 | Sfax | TUN | Sfax | 257800 |
3357 | Istanbul | TUR | Istanbul | 8787958 |
3358 | Ankara | TUR | Ankara | 3038159 |
3359 | Izmir | TUR | Izmir | 2130359 |
3360 | Adana | TUR | Adana | 1131198 |
3361 | Bursa | TUR | Bursa | 1095842 |
3362 | Gaziantep | TUR | Gaziantep | 789056 |
3363 | Konya | TUR | Konya | 628364 |
3364 | Mersin (Ieel) | TUR | Ieel | 587212 |
3365 | Antalya | TUR | Antalya | 564914 |
3366 | Diyarbakir | TUR | Diyarbakir | 479884 |
3367 | Kayseri | TUR | Kayseri | 475657 |
3368 | Eskisehir | TUR | Eskisehir | 470781 |
3424 | Funafuti | TUV | Funafuti | 4600 |
3263 | Taipei | TWN | Taipei | 2641312 |
3264 | Kaohsiung | TWN | Kaohsiung | 1475505 |
3265 | Taichung | TWN | Taichung | 940589 |
3266 | Tainan | TWN | Tainan | 728060 |
3267 | Panchiao | TWN | Taipei | 523850 |
3268 | Chungho | TWN | Taipei | 392176 |
3269 | Keelung (Chilung) | TWN | Keelung | 385201 |
3270 | Sanchung | TWN | Taipei | 380084 |
3271 | Hsinchuang | TWN | Taipei | 365048 |
3272 | Hsinchu | TWN | Hsinchu | 361958 |
3305 | Dar es Salaam | TZA | Dar es Salaam | 1747000 |
3425 | Kampala | UGA | Central | 890800 |
3426 | Kyiv | UKR | Kiova | 2624000 |
3427 | Harkova [Harkiv] | UKR | Harkova | 1500000 |
3428 | Dnipropetrovsk | UKR | Dnipropetrovsk | 1103000 |
3429 | Donetsk | UKR | Donetsk | 1050000 |
3430 | Odesa | UKR | Odesa | 1011000 |
3431 | Zaporizzja | UKR | Zaporizzja | 848000 |
3432 | Lviv | UKR | Lviv | 788000 |
3433 | Kryvyi Rig | UKR | Dnipropetrovsk | 703000 |
3434 | Mykolajiv | UKR | Mykolajiv | 508000 |
3435 | Mariupol | UKR | Donetsk | 490000 |
3436 | Lugansk | UKR | Lugansk | 469000 |
3437 | Vinnytsja | UKR | Vinnytsja | 391000 |
3438 | Makijivka | UKR | Donetsk | 384000 |
3439 | Herson | UKR | Herson | 353000 |
3492 | Montevideo | URY | Montevideo | 1236000 |
3793 | New York | USA | New York | 8008278 |
3794 | Los Angeles | USA | California | 3694820 |
3795 | Chicago | USA | Illinois | 2896016 |
3796 | Houston | USA | Texas | 1953631 |
3797 | Philadelphia | USA | Pennsylvania | 1517550 |
3798 | Phoenix | USA | Arizona | 1321045 |
3799 | San Diego | USA | California | 1223400 |
3800 | Dallas | USA | Texas | 1188580 |
3801 | San Antonio | USA | Texas | 1144646 |
3802 | Detroit | USA | Michigan | 951270 |
3803 | San Jose | USA | California | 894943 |
3804 | Indianapolis | USA | Indiana | 791926 |
3805 | San Francisco | USA | California | 776733 |
3806 | Jacksonville | USA | Florida | 735167 |
3807 | Columbus | USA | Ohio | 711470 |
3808 | Austin | USA | Texas | 656562 |
3809 | Baltimore | USA | Maryland | 651154 |
3810 | Memphis | USA | Tennessee | 650100 |
3811 | Milwaukee | USA | Wisconsin | 596974 |
3812 | Boston | USA | Massachusetts | 589141 |
3813 | Washington | USA | District of Columbia | 572059 |
3814 | Nashville-Davidson | USA | Tennessee | 569891 |
3815 | El Paso | USA | Texas | 563662 |
3816 | Seattle | USA | Washington | 563374 |
3817 | Denver | USA | Colorado | 554636 |
3818 | Charlotte | USA | North Carolina | 540828 |
3819 | Fort Worth | USA | Texas | 534694 |
3820 | Portland | USA | Oregon | 529121 |
3821 | Oklahoma City | USA | Oklahoma | 506132 |
3822 | Tucson | USA | Arizona | 486699 |
3823 | New Orleans | USA | Louisiana | 484674 |
3824 | Las Vegas | USA | Nevada | 478434 |
3825 | Cleveland | USA | Ohio | 478403 |
3826 | Long Beach | USA | California | 461522 |
3827 | Albuquerque | USA | New Mexico | 448607 |
3828 | Kansas City | USA | Missouri | 441545 |
3829 | Fresno | USA | California | 427652 |
3830 | Virginia Beach | USA | Virginia | 425257 |
3831 | Atlanta | USA | Georgia | 416474 |
3832 | Sacramento | USA | California | 407018 |
3833 | Oakland | USA | California | 399484 |
3834 | Mesa | USA | Arizona | 396375 |
3835 | Tulsa | USA | Oklahoma | 393049 |
3836 | Omaha | USA | Nebraska | 390007 |
3837 | Minneapolis | USA | Minnesota | 382618 |
3838 | Honolulu | USA | Hawaii | 371657 |
3839 | Miami | USA | Florida | 362470 |
3840 | Colorado Springs | USA | Colorado | 360890 |
3841 | Saint Louis | USA | Missouri | 348189 |
3842 | Wichita | USA | Kansas | 344284 |
3843 | Santa Ana | USA | California | 337977 |
3844 | Pittsburgh | USA | Pennsylvania | 334563 |
3845 | Arlington | USA | Texas | 332969 |
3846 | Cincinnati | USA | Ohio | 331285 |
3847 | Anaheim | USA | California | 328014 |
3848 | Toledo | USA | Ohio | 313619 |
3849 | Tampa | USA | Florida | 303447 |
3850 | Buffalo | USA | New York | 292648 |
3851 | Saint Paul | USA | Minnesota | 287151 |
3503 | Toskent | UZB | Toskent Shahri | 2117500 |
3504 | Namangan | UZB | Namangan | 370500 |
3505 | Samarkand | UZB | Samarkand | 361800 |
3506 | Andijon | UZB | Andijon | 318600 |
3538 | Citta del Vaticano | VAT | NULL | 455 |
3066 | Kingstown | VCT | St George | 17100 |
3539 | Caracas | VEN | Distrito Federal | 1975294 |
3540 | Maracakbo | VEN | Zulia | 1304776 |
3541 | Barquisimeto | VEN | Lara | 877239 |
3542 | Valencia | VEN | Carabobo | 794246 |
3543 | Ciudad Guayana | VEN | Bolkvar | 663713 |
3544 | Petare | VEN | Miranda | 488868 |
3545 | Maracay | VEN | Aragua | 444443 |
3546 | Barcelona | VEN | Anzoitegui | 322267 |
3547 | Maturkn | VEN | Monagas | 319726 |
3548 | San Cristóbal | VEN | Tichira | 319373 |
3549 | Ciudad Bolkvar | VEN | Bolkvar | 301107 |
537 | Road Town | VGB | Tortola | 8000 |
4067 | Charlotte Amalie | VIR | St Thomas | 13000 |
3769 | Ho Chi Minh City | VNM | Ho Chi Minh City | 3980000 |
3770 | Hanoi | VNM | Hanoi | 1410000 |
3771 | Haiphong | VNM | Haiphong | 783133 |
3537 | Port-Vila | VUT | Shefa | 33700 |
3536 | Mata-Utu | WLF | Wallis | 1137 |
3169 | Apia | WSM | Upolu | 35900 |
1780 | Sanaa | YEM | Sanaa | 503600 |
1781 | Aden | YEM | Aden | 398300 |
1782 | Taizz | YEM | Taizz | 317600 |
1783 | Hodeida | YEM | Hodeida | 298500 |
1792 | Beograd | YUG | Central Serbia | 1204000 |
712 | Cape Town | ZAF | Western Cape | 2352121 |
713 | Soweto | ZAF | Gauteng | 904165 |
714 | Johannesburg | ZAF | Gauteng | 756653 |
715 | Port Elizabeth | ZAF | Eastern Cape | 752319 |
716 | Pretoria | ZAF | Gauteng | 658630 |
717 | Inanda | ZAF | KwaZulu-Natal | 634065 |
718 | Durban | ZAF | KwaZulu-Natal | 566120 |
719 | Vanderbijlpark | ZAF | Gauteng | 468931 |
720 | Kempton Park | ZAF | Gauteng | 442633 |
721 | Alberton | ZAF | Gauteng | 410102 |
722 | Pinetown | ZAF | KwaZulu-Natal | 378810 |
723 | Pietermaritzburg | ZAF | KwaZulu-Natal | 370190 |
724 | Benoni | ZAF | Gauteng | 365467 |
3162 | Lusaka | ZMB | Lusaka | 1317000 |
4068 | Harare | ZWE | Harare | 1410000 |
4069 | Bulawayo | ZWE | Bulawayo | 621742 |
--Riigid, kus on riigi asuva kontinendi laiemalt levinud juhtimisvorm
SELECT *
FROM tCountry A
WHERE A.GovernmentForm =
(SELECT TOP 1 GovernmentForm
FROM tCountry
WHERE Continent =A.Continent
GROUP BY GovernmentForm
Order by COUNT(GovernmentForm) DESC )
Code | CountryName | Continent | Region | SurfaceArea | IndepYear | Population | LifeExpectancy | GNP | GNPOld | LocalName | GovernmentForm | HeadOfState | Capital |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AGO | Angola | Africa | Central Africa | 1246700,00 | 1975 | 12878000 | 38,3 | 6648,00 | 7984,00 | Angola | Republic | José Eduardo dos Santos | 56 |
ALB | Albania | Europe | Southern Europe | 28748,00 | 1912 | 3401200 | 71,6 | 3205,00 | 2500,00 | Shqiptarët | Republic | Rexhep Mejdani | 34 |
ARM | Armenia | Asia | Middle East | 29800,00 | 1991 | 3520000 | 66,4 | 1813,00 | 1627,00 | Hajastan | Republic | Robert Kot?arjan | 126 |
BDI | Burundi | Africa | Eastern Africa | 27834,00 | 1962 | 6695000 | 46,2 | 903,00 | 982,00 | Burundi/Uburundi | Republic | Pierre Buyoya | 552 |
BEN | Benin | Africa | Western Africa | 112622,00 | 1960 | 6097000 | 50,2 | 2357,00 | 2141,00 | Bénin | Republic | Mathieu Kérékou | 187 |
BFA | Burkina Faso | Africa | Western Africa | 274000,00 | 1960 | 11937000 | 46,7 | 2425,00 | 2201,00 | Burkina Faso | Republic | Blaise Compaoré | 549 |
BGD | Bangladesh | Asia | Southern and Central Asia | 143998,00 | 1971 | 129155000 | 60,2 | 32852,00 | 31966,00 | Bangladesh | Republic | Shahabuddin Ahmad | 150 |
BGR | Bulgaria | Europe | Eastern Europe | 110994,00 | 1908 | 8190900 | 70,9 | 12178,00 | 10169,00 | Balgarija | Republic | Petar Stojanov | 539 |
BLR | Belarus | Europe | Eastern Europe | 207600,00 | 1991 | 10236000 | 68,0 | 13714,00 | NULL | Belarus | Republic | Aljaksandr Luka?enka | 3520 |
BOL | Bolivia | South America | South America | 1098581,00 | 1825 | 8329000 | 63,7 | 8571,00 | 7967,00 | Bolivia | Republic | Hugo B?nzer Su?rez | 194 |
BVT | Bouvet Island | Antarctica | Antarctica | 59,00 | NULL | 0 | NULL | 0,00 | NULL | Bouvet¸ya | Dependent Territory of Norway | Harald V | NULL |
BWA | Botswana | Africa | Southern Africa | 581730,00 | 1966 | 1622000 | 39,3 | 4834,00 | 4935,00 | Botswana | Republic | Festus G. Mogae | 204 |
CAF | Central African Republic | Africa | Central Africa | 622984,00 | 1960 | 3615000 | 44,0 | 1054,00 | 993,00 | Centrafrique/B?-Afr?ka | Republic | Ange-Félix Patassé | 1889 |
CHL | Chile | South America | South America | 756626,00 | 1810 | 15211000 | 75,7 | 72949,00 | 75780,00 | Chile | Republic | Ricardo Lagos Escobar | 554 |
CHN | China | Asia | Eastern Asia | 9572900,00 | -1523 | 1277558000 | 71,4 | 982268,00 | 917719,00 | Zhongquo | Republic | Jiang Zemin | 1891 |
CIV | C?te d’Ivoire | Africa | Western Africa | 322463,00 | 1960 | 14786000 | 45,2 | 11345,00 | 10285,00 | C?te d’Ivoire | Republic | Laurent Gbagbo | 2814 |
CMR | Cameroon | Africa | Central Africa | 475442,00 | 1960 | 15085000 | 54,8 | 9174,00 | 8596,00 | Cameroun/Cameroon | Republic | Paul Biya | 1804 |
COD | Congo, The Democratic Republic of the | Africa | Central Africa | 2344858,00 | 1960 | 51654000 | 48,8 | 6964,00 | 2474,00 | République Démocratique du Congo | Republic | Joseph Kabila | 2298 |
COG | Congo | Africa | Central Africa | 342000,00 | 1960 | 2943000 | 47,4 | 2108,00 | 2287,00 | Congo | Republic | Denis Sassou-Nguesso | 2296 |
COL | Colombia | South America | South America | 1138914,00 | 1810 | 42321000 | 70,3 | 102896,00 | 105116,00 | Colombia | Republic | Andrés Pastrana Arango | 2257 |
COM | Comoros | Africa | Eastern Africa | 1862,00 | 1975 | 578000 | 60,0 | 4401,00 | 4361,00 | Komori/Comores | Republic | Azali Assoumani | 2295 |
CPV | Cape Verde | Africa | Western Africa | 4033,00 | 1975 | 428000 | 68,9 | 435,00 | 420,00 | Cabo Verde | Republic | António Mascarenhas Monteiro | 1859 |
CRI | Costa Rica | North America | Central America | 51100,00 | 1821 | 4023000 | 75,8 | 10226,00 | 9757,00 | Costa Rica | Republic | Miguel ?ngel Rodr?guez Echeverr?a | 584 |
CYP | Cyprus | Asia | Middle East | 9251,00 | 1960 | 754700 | 76,7 | 9333,00 | 8246,00 | Κύπρος/Kıbrıs | Republic | Glafkos Klerides | 2430 |
CZE | Czech Republic | Europe | Eastern Europe | 78866,00 | 1993 | 10278100 | 74,5 | 55017,00 | 52037,00 | Česká | Republic | V?clav Havel | 3339 |
DJI | Djibouti | Africa | Eastern Africa | 23200,00 | 1977 | 638000 | 50,8 | 382,00 | 373,00 | Djibouti/Jibuti | Republic | Ismail Omar Guelleh | 585 |
DMA | Dominica | North America | Caribbean | 751,00 | 1978 | 71000 | 73,4 | 256,00 | 243,00 | Dominica | Republic | Vernon Shaw | 586 |
DOM | Dominican Republic | North America | Caribbean | 48511,00 | 1844 | 8495000 | 73,2 | 15846,00 | 15076,00 | Rep?blica Dominicana | Republic | Hipólito Mej?a Dom?nguez | 587 |
DZA | Algeria | Africa | Northern Africa | 2381741,00 | 1962 | 31471000 | 69,7 | 49982,00 | 46966,00 | Al-Jaza’’ir/Algérie | Republic | Abdelaziz Bouteflika | 35 |
ECU | Ecuador | South America | South America | 283561,00 | 1822 | 12646000 | 71,1 | 19770,00 | 19769,00 | Ecuador | Republic | Gustavo Noboa Bejarano | 594 |
EGY | Egypt | Africa | Northern Africa | 1001449,00 | 1922 | 68470000 | 63,3 | 82710,00 | 75617,00 | Misr | Republic | Hosni Mubarak | 608 |
ERI | Eritrea | Africa | Eastern Africa | 117600,00 | 1993 | 3850000 | 55,8 | 650,00 | 755,00 | Ertra | Republic | Isayas Afewerki [Isaias Afwerki] | 652 |
EST | Estonia | Europe | Baltic Countries | 45227,00 | 1991 | 1439200 | 69,5 | 5328,00 | 3371,00 | Eesti | Republic | Lennart Meri | 3791 |
ETH | Ethiopia | Africa | Eastern Africa | 1104300,00 | -1000 | 62565000 | 45,2 | 6353,00 | 6180,00 | YeItyop´iya | Republic | Negasso Gidada | 756 |
FIN | Finland | Europe | Nordic Countries | 338145,00 | 1917 | 5171300 | 77,4 | 121914,00 | 119833,00 | Suomi | Republic | Tarja Halonen | 3236 |
FJI | Fiji Islands | Oceania | Melanesia | 18274,00 | 1970 | 817000 | 67,9 | 1536,00 | 2149,00 | Fiji Islands | Republic | Josefa Iloilo | 764 |
FRA | France | Europe | Western Europe | 551500,00 | 843 | 59225700 | 78,8 | 1424285,00 | 1392448,00 | France | Republic | Jacques Chirac | 2974 |
GAB | Gabon | Africa | Central Africa | 267668,00 | 1960 | 1226000 | 50,1 | 5493,00 | 5279,00 | Le Gabon | Republic | Omar Bongo | 902 |
GEO | Georgia | Asia | Middle East | 69700,00 | 1991 | 4968000 | 64,5 | 6064,00 | 5924,00 | Sakartvelo | Republic | Eduard ?evardnadze | 905 |
GHA | Ghana | Africa | Western Africa | 238533,00 | 1957 | 20212000 | 57,4 | 7137,00 | 6884,00 | Ghana | Republic | John Kufuor | 910 |
GIN | Guinea | Africa | Western Africa | 245857,00 | 1958 | 7430000 | 45,6 | 2352,00 | 2383,00 | Guinée | Republic | Lansana Conté | 926 |
GMB | Gambia | Africa | Western Africa | 11295,00 | 1965 | 1305000 | 53,2 | 320,00 | 325,00 | The Gambia | Republic | Yahya Jammeh | 904 |
GNB | Guinea-Bissau | Africa | Western Africa | 36125,00 | 1974 | 1213000 | 49,0 | 293,00 | 272,00 | Guiné-Bissau | Republic | Kumba Ial? | 927 |
GNQ | Equatorial Guinea | Africa | Central Africa | 28051,00 | 1968 | 453000 | 53,6 | 283,00 | 542,00 | Guinea Ecuatorial | Republic | Teodoro Obiang Nguema Mbasogo | 2972 |
GRC | Greece | Europe | Southern Europe | 131626,00 | 1830 | 10545700 | 78,4 | 120724,00 | 119946,00 | Ελλάς | Republic | Kostis Stefanopoulos | 2401 |
GTM | Guatemala | North America | Central America | 108889,00 | 1821 | 11385000 | 66,2 | 19008,00 | 17797,00 | Guatemala | Republic | Alfonso Portillo Cabrera | 922 |
GUY | Guyana | South America | South America | 214969,00 | 1966 | 861000 | 64,0 | 722,00 | 743,00 | Guyana | Republic | Bharrat Jagdeo | 928 |
HND | Honduras | North America | Central America | 112088,00 | 1838 | 6485000 | 69,9 | 5333,00 | 4697,00 | Honduras | Republic | Carlos Roberto Flores Facussé | 933 |
HRV | Croatia | Europe | Southern Europe | 56538,00 | 1991 | 4473000 | 73,7 | 20208,00 | 19300,00 | Hrvatska | Republic | ?tipe Mesic | 2409 |
HTI | Haiti | North America | Caribbean | 27750,00 | 1804 | 8222000 | 49,2 | 3459,00 | 3107,00 | Ha?ti/Dayti | Republic | Jean-Bertrand Aristide | 929 |
HUN | Hungary | Europe | Eastern Europe | 93030,00 | 1918 | 10043200 | 71,4 | 48267,00 | 45914,00 | Magyarorsz?g | Republic | Ferenc M?dl | 3483 |
IDN | Indonesia | Asia | Southeast Asia | 1904569,00 | 1945 | 212107000 | 68,0 | 84982,00 | 215002,00 | Indonesia | Republic | Abdurrahman Wahid | 939 |
IRL | Ireland | Europe | British Islands | 70273,00 | 1921 | 3775100 | 76,8 | 75921,00 | 73132,00 | Ireland/Éire | Republic | Mary McAleese | 1447 |
IRQ | Iraq | Asia | Middle East | 438317,00 | 1932 | 23115000 | 66,5 | 11500,00 | NULL | Al-´Iraq | Republic | Saddam Hussein al-Takriti | 1365 |
ISL | Iceland | Europe | Nordic Countries | 103000,00 | 1944 | 279000 | 79,4 | 8255,00 | 7474,00 | Ísland | Republic | Ólafur Ragnar Gr?msson | 1449 |
ISR | Israel | Asia | Middle East | 21056,00 | 1948 | 6217000 | 78,6 | 97477,00 | 98577,00 | Yīsraʾel/Isra’’il | Republic | Moshe Katzav | 1450 |
ITA | Italy | Europe | Southern Europe | 301316,00 | 1861 | 57680000 | 79,0 | 1161755,00 | 1145372,00 | Italia | Republic | Carlo Azeglio Ciampi | 1464 |
KAZ | Kazakstan | Asia | Southern and Central Asia | 2724900,00 | 1991 | 16223000 | 63,2 | 24375,00 | 23383,00 | Qazaqstan | Republic | Nursultan Nazarbajev | 1864 |
KEN | Kenya | Africa | Eastern Africa | 580367,00 | 1963 | 30080000 | 48,0 | 9217,00 | 10241,00 | Kenya | Republic | Daniel arap Moi | 1881 |
KGZ | Kyrgyzstan | Asia | Southern and Central Asia | 199900,00 | 1991 | 4699000 | 63,4 | 1626,00 | 1767,00 | Kyrgyzstan | Republic | Askar Akajev | 2253 |
KIR | Kiribati | Oceania | Micronesia | 726,00 | 1979 | 83000 | 59,8 | 40,70 | NULL | Kiribati | Republic | Teburoro Tito | 2256 |
KOR | South Korea | Asia | Eastern Asia | 99434,00 | 1948 | 46844000 | 74,4 | 320749,00 | 442544,00 | Taehan Min’guk (Namhan) | Republic | Kim Dae-jung | 2331 |
LAO | Laos | Asia | Southeast Asia | 236800,00 | 1953 | 5433000 | 53,1 | 1292,00 | 1746,00 | Lao | Republic | Khamtay Siphandone | 2432 |
LBN | Lebanon | Asia | Middle East | 10400,00 | 1941 | 3282000 | 71,3 | 17121,00 | 15129,00 | Lubnan | Republic | Émile Lahoud | 2438 |
LBR | Liberia | Africa | Western Africa | 111369,00 | 1847 | 3154000 | 51,0 | 2012,00 | NULL | Liberia | Republic | Charles Taylor | 2440 |
LKA | Sri Lanka | Asia | Southern and Central Asia | 65610,00 | 1948 | 18827000 | 71,8 | 15706,00 | 15091,00 | Sri Lanka/Ilankai | Republic | Chandrika Kumaratunga | 3217 |
LTU | Lithuania | Europe | Baltic Countries | 65301,00 | 1991 | 3698500 | 69,1 | 10692,00 | 9585,00 | Lietuva | Republic | Valdas Adamkus | 2447 |
LVA | Latvia | Europe | Baltic Countries | 64589,00 | 1991 | 2424200 | 68,4 | 6398,00 | 5639,00 | Latvija | Republic | Vaira Vike-Freiberga | 2434 |
MDA | Moldova | Europe | Eastern Europe | 33851,00 | 1991 | 4380000 | 64,5 | 1579,00 | 1872,00 | Moldova | Republic | Vladimir Voronin | 2690 |
MDV | Maldives | Asia | Southern and Central Asia | 298,00 | 1965 | 286000 | 62,2 | 199,00 | NULL | Dhivehi Raajje/Maldives | Republic | Maumoon Abdul Gayoom | 2463 |
MHL | Marshall Islands | Oceania | Micronesia | 181,00 | 1990 | 64000 | 65,5 | 97,00 | NULL | Marshall Islands/Majol | Republic | Kessai Note | 2507 |
MKD | Macedonia | Europe | Southern Europe | 25713,00 | 1991 | 2024000 | 73,8 | 1694,00 | 1915,00 | Makedonija | Republic | Boris Trajkovski | 2460 |
MLI | Mali | Africa | Western Africa | 1240192,00 | 1960 | 11234000 | 46,7 | 2642,00 | 2453,00 | Mali | Republic | Alpha Oumar Konaré | 2482 |
MLT | Malta | Europe | Southern Europe | 316,00 | 1964 | 380200 | 77,9 | 3512,00 | 3338,00 | Malta | Republic | Guido de Marco | 2484 |
MMR | Myanmar | Asia | Southeast Asia | 676578,00 | 1948 | 45611000 | 54,9 | 180375,00 | 171028,00 | Myanma Pye | Republic | kenraali Than Shwe | 2710 |
MNG | Mongolia | Asia | Eastern Asia | 1566500,00 | 1921 | 2662000 | 67,3 | 1043,00 | 933,00 | Mongol Uls | Republic | Natsagiin Bagabandi | 2696 |
MOZ | Mozambique | Africa | Eastern Africa | 801590,00 | 1975 | 19680000 | 37,5 | 2891,00 | 2711,00 | Mo?ambique | Republic | Joaqu?m A. Chissano | 2698 |
MRT | Mauritania | Africa | Western Africa | 1025520,00 | 1960 | 2670000 | 50,8 | 998,00 | 1081,00 | Muritaniya/Mauritanie | Republic | Maaouiya Ould Sid´Ahmad Taya | 2509 |
MUS | Mauritius | Africa | Eastern Africa | 2040,00 | 1968 | 1158000 | 71,0 | 4251,00 | 4186,00 | Mauritius | Republic | Cassam Uteem | 2511 |
MWI | Malawi | Africa | Eastern Africa | 118484,00 | 1964 | 10925000 | 37,6 | 1687,00 | 2527,00 | Malawi | Republic | Bakili Muluzi | 2462 |
NAM | Namibia | Africa | Southern Africa | 824292,00 | 1990 | 1726000 | 42,5 | 3101,00 | 3384,00 | Namibia | Republic | Sam Nujoma | 2726 |
NER | Niger | Africa | Western Africa | 1267000,00 | 1960 | 10730000 | 41,3 | 1706,00 | 1580,00 | Niger | Republic | Mamadou Tandja | 2738 |
NIC | Nicaragua | North America | Central America | 130000,00 | 1838 | 5074000 | 68,7 | 1988,00 | 2023,00 | Nicaragua | Republic | Arnoldo Alem?n Lacayo | 2734 |
NRU | Nauru | Oceania | Micronesia | 21,00 | 1968 | 12000 | 60,8 | 197,00 | NULL | Naoero/Nauru | Republic | Bernard Dowiyogo | 2728 |
PAK | Pakistan | Asia | Southern and Central Asia | 796095,00 | 1947 | 156483000 | 61,1 | 61289,00 | 58549,00 | Pakistan | Republic | Mohammad Rafiq Tarar | 2831 |
PAN | Panama | North America | Central America | 75517,00 | 1903 | 2856000 | 75,5 | 9131,00 | 8700,00 | Panamá | Republic | Mireya Elisa Moscoso Rodr?guez | 2882 |
PER | Peru | South America | South America | 1285216,00 | 1821 | 25662000 | 70,0 | 64140,00 | 65186,00 | Perú/Piruw | Republic | Valentin Paniagua Corazao | 2890 |
PHL | Philippines | Asia | Southeast Asia | 300000,00 | 1946 | 75967000 | 67,5 | 65107,00 | 82239,00 | Pilipinas | Republic | Gloria Macapagal-Arroyo | 766 |
PLW | Palau | Oceania | Micronesia | 459,00 | 1994 | 19000 | 68,6 | 105,00 | NULL | Belau/Palau | Republic | Kuniwo Nakamura | 2881 |
POL | Poland | Europe | Eastern Europe | 323250,00 | 1918 | 38653600 | 73,2 | 151697,00 | 135636,00 | Polska | Republic | Aleksander Kwasniewski | 2928 |
PRT | Portugal | Europe | Southern Europe | 91982,00 | 1143 | 9997600 | 75,8 | 105954,00 | 102133,00 | Portugal | Republic | Jorge Samp?io | 2914 |
PRY | Paraguay | South America | South America | 406752,00 | 1811 | 5496000 | 73,7 | 8444,00 | 9555,00 | Paraguay | Republic | Luis ?ngel Gonz?lez Macchi | 2885 |
ROM | Romania | Europe | Eastern Europe | 238391,00 | 1878 | 22455500 | 69,9 | 38158,00 | 34843,00 | România | Republic | Ion Iliescu | 3018 |
RWA | Rwanda | Africa | Eastern Africa | 26338,00 | 1962 | 7733000 | 39,3 | 2036,00 | 1863,00 | Rwanda/Urwanda | Republic | Paul Kagame | 3047 |
SEN | Senegal | Africa | Western Africa | 196722,00 | 1960 | 9481000 | 62,2 | 4787,00 | 4542,00 | Sénégal/Sounougal | Republic | Abdoulaye Wade | 3198 |
SGP | Singapore | Asia | Southeast Asia | 618,00 | 1965 | 3567000 | 80,1 | 86503,00 | 96318,00 | Singapore/Singapura/Xinjiapo/Singapur | Republic | Sellapan Rama Nathan | 3208 |
SLE | Sierra Leone | Africa | Western Africa | 71740,00 | 1961 | 4854000 | 45,3 | 746,00 | 858,00 | Sierra Leone | Republic | Ahmed Tejan Kabbah | 3207 |
SLV | El Salvador | North America | Central America | 21041,00 | 1841 | 6276000 | 69,7 | 11863,00 | 11203,00 | El Salvador | Republic | Francisco Guillermo Flores Pérez | 645 |
SMR | San Marino | Europe | Southern Europe | 61,00 | 885 | 27000 | 81,1 | 510,00 | NULL | San Marino | Republic | NULL | 3171 |
SOM | Somalia | Africa | Eastern Africa | 637657,00 | 1960 | 10097000 | 46,2 | 935,00 | NULL | Soomaaliya | Republic | Abdiqassim Salad Hassan | 3214 |
STP | Sao Tome and Principe | Africa | Central Africa | 964,00 | 1975 | 147000 | 65,3 | 6,00 | NULL | S?o Tomé e Pr?ncipe | Republic | Miguel Trovoada | 3172 |
SUR | Suriname | South America | South America | 163265,00 | 1975 | 417000 | 71,4 | 870,00 | 706,00 | Suriname | Republic | Ronald Venetiaan | 3243 |
SVK | Slovakia | Europe | Eastern Europe | 49012,00 | 1993 | 5398700 | 73,7 | 20594,00 | 19452,00 | Slovensko | Republic | Rudolf Schuster | 3209 |
SVN | Slovenia | Europe | Southern Europe | 20256,00 | 1991 | 1987800 | 74,9 | 19756,00 | 18202,00 | Slovenija | Republic | Milan Kucan | 3212 |
SYC | Seychelles | Africa | Eastern Africa | 455,00 | 1976 | 77000 | 70,4 | 536,00 | 539,00 | Sesel/Seychelles | Republic | France-Albert René | 3206 |
SYR | Syria | Asia | Middle East | 185180,00 | 1941 | 16125000 | 68,5 | 65984,00 | 64926,00 | Suriya | Republic | Bashar al-Assad | 3250 |
TCD | Chad | Africa | Central Africa | 1284000,00 | 1960 | 7651000 | 50,5 | 1208,00 | 1102,00 | Tchad/Tshad | Republic | Idriss Déby | 3337 |
TGO | Togo | Africa | Western Africa | 56785,00 | 1960 | 4629000 | 54,7 | 1449,00 | 1400,00 | Togo | Republic | Gnassingbé Eyadéma | 3332 |
TJK | Tajikistan | Asia | Southern and Central Asia | 143100,00 | 1991 | 6188000 | 64,1 | 1990,00 | 1056,00 | To?ikiston | Republic | Emomali Rahmonov | 3261 |
TKM | Turkmenistan | Asia | Southern and Central Asia | 488100,00 | 1991 | 4459000 | 60,9 | 4397,00 | 2000,00 | Türkmenostan | Republic | Saparmurad Nijazov | 3419 |
TTO | Trinidad and Tobago | North America | Caribbean | 5130,00 | 1962 | 1295000 | 68,0 | 6232,00 | 5867,00 | Trinidad and Tobago | Republic | Arthur N. R. Robinson | 3336 |
TUN | Tunisia | Africa | Northern Africa | 163610,00 | 1956 | 9586000 | 73,7 | 20026,00 | 18898,00 | Tunis/Tunisie | Republic | Zine al-Abidine Ben Ali | 3349 |
TUR | Turkey | Asia | Middle East | 774815,00 | 1923 | 66591000 | 71,0 | 210721,00 | 189122,00 | Türkiye | Republic | Ahmet Necdet Sezer | 3358 |
TWN | Taiwan | Asia | Eastern Asia | 36188,00 | 1945 | 22256000 | 76,4 | 256254,00 | 263451,00 | T’ai-wan | Republic | Chen Shui-bian | 3263 |
TZA | Tanzania | Africa | Eastern Africa | 883749,00 | 1961 | 33517000 | 52,3 | 8005,00 | 7388,00 | Tanzania | Republic | Benjamin William Mkapa | 3306 |
UGA | Uganda | Africa | Eastern Africa | 241038,00 | 1962 | 21778000 | 42,9 | 6313,00 | 6887,00 | Uganda | Republic | Yoweri Museveni | 3425 |
UKR | Ukraine | Europe | Eastern Europe | 603700,00 | 1991 | 50456000 | 66,0 | 42168,00 | 49677,00 | Ukrajina | Republic | Leonid Kut?ma | 3426 |
URY | Uruguay | South America | South America | 175016,00 | 1828 | 3337000 | 75,2 | 20831,00 | 19967,00 | Uruguay | Republic | Jorge Batlle Ib??ez | 3492 |
UZB | Uzbekistan | Asia | Southern and Central Asia | 447400,00 | 1991 | 24318000 | 63,7 | 14194,00 | 21300,00 | Uzbekiston | Republic | Islam Karimov | 3503 |
VUT | Vanuatu | Oceania | Melanesia | 12189,00 | 1980 | 190000 | 60,6 | 261,00 | 246,00 | Vanuatu | Republic | John Bani | 3537 |
YEM | Yemen | Asia | Middle East | 527968,00 | 1918 | 18112000 | 59,8 | 6041,00 | 5729,00 | Al-Yaman | Republic | Ali Abdallah Salih | 1780 |
ZAF | South Africa | Africa | Southern Africa | 1221037,00 | 1910 | 40377000 | 51,1 | 116729,00 | 129092,00 | South Africa | Republic | Thabo Mbeki | 716 |
ZMB | Zambia | Africa | Eastern Africa | 752618,00 | 1964 | 9169000 | 37,2 | 3377,00 | 3922,00 | Zambia | Republic | Frederick Chiluba | 3162 |
ZWE | Zimbabwe | Africa | Eastern Africa | 390757,00 | 1980 | 11669000 | 37,8 | 5951,00 | 8670,00 | Zimbabwe | Republic | Robert G. Mugabe | 4068 |