Statement of Completion#d10e556e
Beginning SQL: Basic Selection Statements
medium
Skill Assessment: Accessing MySQL from Python
Resolution
Activities
Importing Libraries¶
In [13]:
import pymysql.cursors
import pandas as pd
In [3]:
HOST = "192.33.93.3"
USER = "datawars"
DATABASE = "world"
PASSWORD = ""
PORT = 3306
Verify the connection
In [4]:
conn = pymysql.connect(
host=HOST, user=USER, port=PORT,
password=PASSWORD, database=DATABASE,
cursorclass=pymysql.cursors.DictCursor)
conn
Out[4]:
<pymysql.connections.Connection at 0x78ff01d13010>
In [5]:
cursor = conn.cursor()
cursor.execute("SELECT COUNT(*) as city_count FROM city")
cursor.fetchall()
Out[5]:
[{'city_count': 4079}]
Activities¶
Activity 1: Find top 5 countries with max Surface Area¶
In [7]:
cursor.execute("SELECT Name, Continent, Region, SurfaceArea FROM country ORDER BY SurfaceArea DESC LIMIT 5")
top_5_countries = cursor.fetchall()
Activity 2: Find language spoken by most of the people.¶
In [18]:
cursor.execute("SELECT Code,Name FROM country")
df_country = pd.DataFrame(cursor.fetchall())
cursor.execute("SELECT CountryCode, Language FROM countrylanguage WHERE IsOfficial='T'")
df_language = pd.DataFrame(cursor.fetchall())
df = df_country.merge(df_language,left_on='Code',right_on='CountryCode')
df2 = df.drop(columns=['Code','CountryCode'])
country_language = [tuple(x) for x in df2.to_numpy()]
Out[18]:
[('Aruba', 'Dutch'), ('Afghanistan', 'Dari'), ('Afghanistan', 'Pashto'), ('Anguilla', 'English'), ('Albania', 'Albaniana'), ('Andorra', 'Catalan'), ('Netherlands Antilles', 'Dutch'), ('Netherlands Antilles', 'Papiamento'), ('United Arab Emirates', 'Arabic'), ('Argentina', 'Spanish'), ('Armenia', 'Armenian'), ('American Samoa', 'English'), ('American Samoa', 'Samoan'), ('Antigua and Barbuda', 'English'), ('Australia', 'English'), ('Austria', 'German'), ('Azerbaijan', 'Azerbaijani'), ('Burundi', 'French'), ('Burundi', 'Kirundi'), ('Belgium', 'Dutch'), ('Belgium', 'French'), ('Belgium', 'German'), ('Bangladesh', 'Bengali'), ('Bulgaria', 'Bulgariana'), ('Bahrain', 'Arabic'), ('Bosnia and Herzegovina', 'Serbo-Croatian'), ('Belarus', 'Belorussian'), ('Belarus', 'Russian'), ('Belize', 'English'), ('Bermuda', 'English'), ('Bolivia', 'Aimará'), ('Bolivia', 'Ketšua'), ('Bolivia', 'Spanish'), ('Brazil', 'Portuguese'), ('Barbados', 'English'), ('Brunei', 'Malay'), ('Bhutan', 'Dzongkha'), ('Canada', 'English'), ('Canada', 'French'), ('Cocos (Keeling) Islands', 'English'), ('Switzerland', 'French'), ('Switzerland', 'German'), ('Switzerland', 'Italian'), ('Switzerland', 'Romansh'), ('Chile', 'Spanish'), ('China', 'Chinese'), ('Cook Islands', 'Maori'), ('Colombia', 'Spanish'), ('Comoros', 'Comorian'), ('Cape Verde', 'Portuguese'), ('Costa Rica', 'Spanish'), ('Cuba', 'Spanish'), ('Christmas Island', 'English'), ('Cayman Islands', 'English'), ('Cyprus', 'Greek'), ('Cyprus', 'Turkish'), ('Czech Republic', 'Czech'), ('Germany', 'German'), ('Djibouti', 'Arabic'), ('Denmark', 'Danish'), ('Dominican Republic', 'Spanish'), ('Algeria', 'Arabic'), ('Ecuador', 'Spanish'), ('Egypt', 'Arabic'), ('Eritrea', 'Tigrinja'), ('Western Sahara', 'Arabic'), ('Spain', 'Spanish'), ('Estonia', 'Estonian'), ('Finland', 'Finnish'), ('Finland', 'Swedish'), ('Fiji Islands', 'Fijian'), ('Falkland Islands', 'English'), ('France', 'French'), ('Faroe Islands', 'Danish'), ('Faroe Islands', 'Faroese'), ('United Kingdom', 'English'), ('Georgia', 'Georgiana'), ('Gibraltar', 'English'), ('Guadeloupe', 'French'), ('Guinea-Bissau', 'Portuguese'), ('Greece', 'Greek'), ('Greenland', 'Danish'), ('Greenland', 'Greenlandic'), ('Guatemala', 'Spanish'), ('Guam', 'Chamorro'), ('Guam', 'English'), ('Hong Kong', 'English'), ('Honduras', 'Spanish'), ('Croatia', 'Serbo-Croatian'), ('Haiti', 'French'), ('Hungary', 'Hungarian'), ('Indonesia', 'Malay'), ('India', 'Hindi'), ('Ireland', 'English'), ('Ireland', 'Irish'), ('Iran', 'Persian'), ('Iraq', 'Arabic'), ('Iceland', 'Icelandic'), ('Israel', 'Arabic'), ('Israel', 'Hebrew'), ('Italy', 'Italian'), ('Jordan', 'Arabic'), ('Japan', 'Japanese'), ('Kazakstan', 'Kazakh'), ('Kyrgyzstan', 'Kirgiz'), ('Kyrgyzstan', 'Russian'), ('Cambodia', 'Khmer'), ('Kiribati', 'Kiribati'), ('Saint Kitts and Nevis', 'English'), ('South Korea', 'Korean'), ('Kuwait', 'Arabic'), ('Laos', 'Lao'), ('Lebanon', 'Arabic'), ('Libyan Arab Jamahiriya', 'Arabic'), ('Saint Lucia', 'English'), ('Liechtenstein', 'German'), ('Sri Lanka', 'Singali'), ('Sri Lanka', 'Tamil'), ('Lesotho', 'English'), ('Lesotho', 'Sotho'), ('Lithuania', 'Lithuanian'), ('Luxembourg', 'French'), ('Luxembourg', 'German'), ('Luxembourg', 'Luxembourgish'), ('Latvia', 'Latvian'), ('Macao', 'Portuguese'), ('Morocco', 'Arabic'), ('Monaco', 'French'), ('Moldova', 'Romanian'), ('Madagascar', 'French'), ('Madagascar', 'Malagasy'), ('Maldives', 'Dhivehi'), ('Mexico', 'Spanish'), ('Marshall Islands', 'English'), ('Marshall Islands', 'Marshallese'), ('Macedonia', 'Macedonian'), ('Malta', 'English'), ('Malta', 'Maltese'), ('Myanmar', 'Burmese'), ('Mongolia', 'Mongolian'), ('Northern Mariana Islands', 'English'), ('Montserrat', 'English'), ('Martinique', 'French'), ('Malawi', 'Chichewa'), ('Malaysia', 'Malay'), ('Mayotte', 'French'), ('New Caledonia', 'French'), ('Norfolk Island', 'English'), ('Nicaragua', 'Spanish'), ('Niue', 'English'), ('Netherlands', 'Dutch'), ('Norway', 'Norwegian'), ('Nepal', 'Nepali'), ('Nauru', 'English'), ('Nauru', 'Nauru'), ('New Zealand', 'English'), ('Oman', 'Arabic'), ('Pakistan', 'Urdu'), ('Panama', 'Spanish'), ('Peru', 'Aimará'), ('Peru', 'Ketšua'), ('Peru', 'Spanish'), ('Philippines', 'Pilipino'), ('Palau', 'English'), ('Palau', 'Palau'), ('Poland', 'Polish'), ('Puerto Rico', 'Spanish'), ('North Korea', 'Korean'), ('Portugal', 'Portuguese'), ('Paraguay', 'Guaraní'), ('Paraguay', 'Spanish'), ('French Polynesia', 'French'), ('Qatar', 'Arabic'), ('Romania', 'Romani'), ('Romania', 'Romanian'), ('Russian Federation', 'Russian'), ('Rwanda', 'French'), ('Rwanda', 'Rwanda'), ('Saudi Arabia', 'Arabic'), ('Sudan', 'Arabic'), ('Senegal', 'Wolof'), ('Singapore', 'Chinese'), ('Singapore', 'Malay'), ('Singapore', 'Tamil'), ('Saint Helena', 'English'), ('Svalbard and Jan Mayen', 'Norwegian'), ('El Salvador', 'Spanish'), ('San Marino', 'Italian'), ('Somalia', 'Arabic'), ('Somalia', 'Somali'), ('Saint Pierre and Miquelon', 'French'), ('Slovakia', 'Slovak'), ('Slovenia', 'Slovene'), ('Sweden', 'Swedish'), ('Swaziland', 'Swazi'), ('Seychelles', 'English'), ('Seychelles', 'French'), ('Syria', 'Arabic'), ('Turks and Caicos Islands', 'English'), ('Chad', 'Arabic'), ('Togo', 'Ewe'), ('Togo', 'Kabyé'), ('Thailand', 'Thai'), ('Tajikistan', 'Tadzhik'), ('Tokelau', 'English'), ('Turkmenistan', 'Turkmenian'), ('East Timor', 'Portuguese'), ('Tonga', 'English'), ('Tonga', 'Tongan'), ('Tunisia', 'Arabic'), ('Turkey', 'Turkish'), ('Tuvalu', 'English'), ('Tuvalu', 'Tuvalu'), ('Taiwan', 'Mandarin Chinese'), ('Tanzania', 'Swahili'), ('Ukraine', 'Ukrainian'), ('United States Minor Outlying Islands', 'English'), ('Uruguay', 'Spanish'), ('United States', 'English'), ('Uzbekistan', 'Uzbek'), ('Holy See (Vatican City State)', 'Italian'), ('Saint Vincent and the Grenadines', 'English'), ('Venezuela', 'Spanish'), ('Virgin Islands, British', 'English'), ('Virgin Islands, U.S.', 'English'), ('Vietnam', 'Vietnamese'), ('Vanuatu', 'Bislama'), ('Vanuatu', 'English'), ('Vanuatu', 'French'), ('Samoa', 'English'), ('Samoa', 'Samoan'), ('Yemen', 'Arabic'), ('Yugoslavia', 'Serbo-Croatian'), ('South Africa', 'Afrikaans'), ('South Africa', 'English'), ('South Africa', 'Xhosa'), ('South Africa', 'Zulu'), ('Zimbabwe', 'English')]
Activity 3: Find the cities where language is spoken by most of the people.¶
In [22]:
cursor.execute("SELECT name FROM city WHERE countrycode='BMU'")
cities = cursor.fetchall()
cities = set([city['name'] for city in cities])
Activity 4: Find the countries where life expectancy is below average.¶
In [25]:
cursor.execute("SELECT AVG(LifeExpectancy) FROM country")
cursor.fetchall()
Out[25]:
[{'AVG(LifeExpectancy)': Decimal('66.48604')}]
In [26]:
cursor.execute("SELECT name, lifeexpectancy FROM country WHERE lifeexpectancy<66.48604")
below_avg_life_expectancy = cursor.fetchall()
Activity 5: Find the countries who have their official language as English.¶
In [28]:
cursor.execute("SELECT * FROM country")
cursor.fetchall()
Out[28]:
[{'Code': 'ABW', 'Name': 'Aruba', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('193.00'), 'IndepYear': None, 'Population': 103000, 'LifeExpectancy': Decimal('78.4'), 'GNP': Decimal('828.00'), 'GNPOld': Decimal('793.00'), 'LocalName': 'Aruba', 'GovernmentForm': 'Nonmetropolitan Territory of The Netherlands', 'HeadOfState': 'Beatrix', 'Capital': 129, 'Code2': 'AW'}, {'Code': 'AFG', 'Name': 'Afghanistan', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('652090.00'), 'IndepYear': 1919, 'Population': 22720000, 'LifeExpectancy': Decimal('45.9'), 'GNP': Decimal('5976.00'), 'GNPOld': None, 'LocalName': 'Afganistan/Afqanestan', 'GovernmentForm': 'Islamic Emirate', 'HeadOfState': 'Mohammad Omar', 'Capital': 1, 'Code2': 'AF'}, {'Code': 'AGO', 'Name': 'Angola', 'Continent': 'Africa', 'Region': 'Central Africa', 'SurfaceArea': Decimal('1246700.00'), 'IndepYear': 1975, 'Population': 12878000, 'LifeExpectancy': Decimal('38.3'), 'GNP': Decimal('6648.00'), 'GNPOld': Decimal('7984.00'), 'LocalName': 'Angola', 'GovernmentForm': 'Republic', 'HeadOfState': 'José Eduardo dos Santos', 'Capital': 56, 'Code2': 'AO'}, {'Code': 'AIA', 'Name': 'Anguilla', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('96.00'), 'IndepYear': None, 'Population': 8000, 'LifeExpectancy': Decimal('76.1'), 'GNP': Decimal('63.20'), 'GNPOld': None, 'LocalName': 'Anguilla', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 62, 'Code2': 'AI'}, {'Code': 'ALB', 'Name': 'Albania', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('28748.00'), 'IndepYear': 1912, 'Population': 3401200, 'LifeExpectancy': Decimal('71.6'), 'GNP': Decimal('3205.00'), 'GNPOld': Decimal('2500.00'), 'LocalName': 'Shqipëria', 'GovernmentForm': 'Republic', 'HeadOfState': 'Rexhep Mejdani', 'Capital': 34, 'Code2': 'AL'}, {'Code': 'AND', 'Name': 'Andorra', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('468.00'), 'IndepYear': 1278, 'Population': 78000, 'LifeExpectancy': Decimal('83.5'), 'GNP': Decimal('1630.00'), 'GNPOld': None, 'LocalName': 'Andorra', 'GovernmentForm': 'Parliamentary Coprincipality', 'HeadOfState': '', 'Capital': 55, 'Code2': 'AD'}, {'Code': 'ANT', 'Name': 'Netherlands Antilles', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('800.00'), 'IndepYear': None, 'Population': 217000, 'LifeExpectancy': Decimal('74.7'), 'GNP': Decimal('1941.00'), 'GNPOld': None, 'LocalName': 'Nederlandse Antillen', 'GovernmentForm': 'Nonmetropolitan Territory of The Netherlands', 'HeadOfState': 'Beatrix', 'Capital': 33, 'Code2': 'AN'}, {'Code': 'ARE', 'Name': 'United Arab Emirates', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('83600.00'), 'IndepYear': 1971, 'Population': 2441000, 'LifeExpectancy': Decimal('74.1'), 'GNP': Decimal('37966.00'), 'GNPOld': Decimal('36846.00'), 'LocalName': 'Al-Imarat al-´Arabiya al-Muttahida', 'GovernmentForm': 'Emirate Federation', 'HeadOfState': 'Zayid bin Sultan al-Nahayan', 'Capital': 65, 'Code2': 'AE'}, {'Code': 'ARG', 'Name': 'Argentina', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('2780400.00'), 'IndepYear': 1816, 'Population': 37032000, 'LifeExpectancy': Decimal('75.1'), 'GNP': Decimal('340238.00'), 'GNPOld': Decimal('323310.00'), 'LocalName': 'Argentina', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Fernando de la Rúa', 'Capital': 69, 'Code2': 'AR'}, {'Code': 'ARM', 'Name': 'Armenia', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('29800.00'), 'IndepYear': 1991, 'Population': 3520000, 'LifeExpectancy': Decimal('66.4'), 'GNP': Decimal('1813.00'), 'GNPOld': Decimal('1627.00'), 'LocalName': 'Hajastan', 'GovernmentForm': 'Republic', 'HeadOfState': 'Robert Kotšarjan', 'Capital': 126, 'Code2': 'AM'}, {'Code': 'ASM', 'Name': 'American Samoa', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': Decimal('199.00'), 'IndepYear': None, 'Population': 68000, 'LifeExpectancy': Decimal('75.1'), 'GNP': Decimal('334.00'), 'GNPOld': None, 'LocalName': 'Amerika Samoa', 'GovernmentForm': 'US Territory', 'HeadOfState': 'George W. Bush', 'Capital': 54, 'Code2': 'AS'}, {'Code': 'ATA', 'Name': 'Antarctica', 'Continent': 'Antarctica', 'Region': 'Antarctica', 'SurfaceArea': Decimal('13120000.00'), 'IndepYear': None, 'Population': 0, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': '–', 'GovernmentForm': 'Co-administrated', 'HeadOfState': '', 'Capital': None, 'Code2': 'AQ'}, {'Code': 'ATF', 'Name': 'French Southern territories', 'Continent': 'Antarctica', 'Region': 'Antarctica', 'SurfaceArea': Decimal('7780.00'), 'IndepYear': None, 'Population': 0, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Terres australes françaises', 'GovernmentForm': 'Nonmetropolitan Territory of France', 'HeadOfState': 'Jacques Chirac', 'Capital': None, 'Code2': 'TF'}, {'Code': 'ATG', 'Name': 'Antigua and Barbuda', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('442.00'), 'IndepYear': 1981, 'Population': 68000, 'LifeExpectancy': Decimal('70.5'), 'GNP': Decimal('612.00'), 'GNPOld': Decimal('584.00'), 'LocalName': 'Antigua and Barbuda', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 63, 'Code2': 'AG'}, {'Code': 'AUS', 'Name': 'Australia', 'Continent': 'Oceania', 'Region': 'Australia and New Zealand', 'SurfaceArea': Decimal('7741220.00'), 'IndepYear': 1901, 'Population': 18886000, 'LifeExpectancy': Decimal('79.8'), 'GNP': Decimal('351182.00'), 'GNPOld': Decimal('392911.00'), 'LocalName': 'Australia', 'GovernmentForm': 'Constitutional Monarchy, Federation', 'HeadOfState': 'Elisabeth II', 'Capital': 135, 'Code2': 'AU'}, {'Code': 'AUT', 'Name': 'Austria', 'Continent': 'Europe', 'Region': 'Western Europe', 'SurfaceArea': Decimal('83859.00'), 'IndepYear': 1918, 'Population': 8091800, 'LifeExpectancy': Decimal('77.7'), 'GNP': Decimal('211860.00'), 'GNPOld': Decimal('206025.00'), 'LocalName': 'Österreich', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Thomas Klestil', 'Capital': 1523, 'Code2': 'AT'}, {'Code': 'AZE', 'Name': 'Azerbaijan', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('86600.00'), 'IndepYear': 1991, 'Population': 7734000, 'LifeExpectancy': Decimal('62.9'), 'GNP': Decimal('4127.00'), 'GNPOld': Decimal('4100.00'), 'LocalName': 'Azərbaycan', 'GovernmentForm': 'Republic', 'HeadOfState': 'İlham Əliyev', 'Capital': 144, 'Code2': 'AZ'}, {'Code': 'BDI', 'Name': 'Burundi', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('27834.00'), 'IndepYear': 1962, 'Population': 6695000, 'LifeExpectancy': Decimal('46.2'), 'GNP': Decimal('903.00'), 'GNPOld': Decimal('982.00'), 'LocalName': 'Burundi/Uburundi', 'GovernmentForm': 'Republic', 'HeadOfState': 'Pierre Buyoya', 'Capital': 552, 'Code2': 'BI'}, {'Code': 'BEL', 'Name': 'Belgium', 'Continent': 'Europe', 'Region': 'Western Europe', 'SurfaceArea': Decimal('30518.00'), 'IndepYear': 1830, 'Population': 10239000, 'LifeExpectancy': Decimal('77.8'), 'GNP': Decimal('249704.00'), 'GNPOld': Decimal('243948.00'), 'LocalName': 'België/Belgique', 'GovernmentForm': 'Constitutional Monarchy, Federation', 'HeadOfState': 'Albert II', 'Capital': 179, 'Code2': 'BE'}, {'Code': 'BEN', 'Name': 'Benin', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('112622.00'), 'IndepYear': 1960, 'Population': 6097000, 'LifeExpectancy': Decimal('50.2'), 'GNP': Decimal('2357.00'), 'GNPOld': Decimal('2141.00'), 'LocalName': 'Bénin', 'GovernmentForm': 'Republic', 'HeadOfState': 'Mathieu Kérékou', 'Capital': 187, 'Code2': 'BJ'}, {'Code': 'BFA', 'Name': 'Burkina Faso', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('274000.00'), 'IndepYear': 1960, 'Population': 11937000, 'LifeExpectancy': Decimal('46.7'), 'GNP': Decimal('2425.00'), 'GNPOld': Decimal('2201.00'), 'LocalName': 'Burkina Faso', 'GovernmentForm': 'Republic', 'HeadOfState': 'Blaise Compaoré', 'Capital': 549, 'Code2': 'BF'}, {'Code': 'BGD', 'Name': 'Bangladesh', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('143998.00'), 'IndepYear': 1971, 'Population': 129155000, 'LifeExpectancy': Decimal('60.2'), 'GNP': Decimal('32852.00'), 'GNPOld': Decimal('31966.00'), 'LocalName': 'Bangladesh', 'GovernmentForm': 'Republic', 'HeadOfState': 'Shahabuddin Ahmad', 'Capital': 150, 'Code2': 'BD'}, {'Code': 'BGR', 'Name': 'Bulgaria', 'Continent': 'Europe', 'Region': 'Eastern Europe', 'SurfaceArea': Decimal('110994.00'), 'IndepYear': 1908, 'Population': 8190900, 'LifeExpectancy': Decimal('70.9'), 'GNP': Decimal('12178.00'), 'GNPOld': Decimal('10169.00'), 'LocalName': 'Balgarija', 'GovernmentForm': 'Republic', 'HeadOfState': 'Petar Stojanov', 'Capital': 539, 'Code2': 'BG'}, {'Code': 'BHR', 'Name': 'Bahrain', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('694.00'), 'IndepYear': 1971, 'Population': 617000, 'LifeExpectancy': Decimal('73.0'), 'GNP': Decimal('6366.00'), 'GNPOld': Decimal('6097.00'), 'LocalName': 'Al-Bahrayn', 'GovernmentForm': 'Monarchy (Emirate)', 'HeadOfState': 'Hamad ibn Isa al-Khalifa', 'Capital': 149, 'Code2': 'BH'}, {'Code': 'BHS', 'Name': 'Bahamas', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('13878.00'), 'IndepYear': 1973, 'Population': 307000, 'LifeExpectancy': Decimal('71.1'), 'GNP': Decimal('3527.00'), 'GNPOld': Decimal('3347.00'), 'LocalName': 'The Bahamas', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 148, 'Code2': 'BS'}, {'Code': 'BIH', 'Name': 'Bosnia and Herzegovina', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('51197.00'), 'IndepYear': 1992, 'Population': 3972000, 'LifeExpectancy': Decimal('71.5'), 'GNP': Decimal('2841.00'), 'GNPOld': None, 'LocalName': 'Bosna i Hercegovina', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Ante Jelavic', 'Capital': 201, 'Code2': 'BA'}, {'Code': 'BLR', 'Name': 'Belarus', 'Continent': 'Europe', 'Region': 'Eastern Europe', 'SurfaceArea': Decimal('207600.00'), 'IndepYear': 1991, 'Population': 10236000, 'LifeExpectancy': Decimal('68.0'), 'GNP': Decimal('13714.00'), 'GNPOld': None, 'LocalName': 'Belarus', 'GovernmentForm': 'Republic', 'HeadOfState': 'Aljaksandr Lukašenka', 'Capital': 3520, 'Code2': 'BY'}, {'Code': 'BLZ', 'Name': 'Belize', 'Continent': 'North America', 'Region': 'Central America', 'SurfaceArea': Decimal('22696.00'), 'IndepYear': 1981, 'Population': 241000, 'LifeExpectancy': Decimal('70.9'), 'GNP': Decimal('630.00'), 'GNPOld': Decimal('616.00'), 'LocalName': 'Belize', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 185, 'Code2': 'BZ'}, {'Code': 'BMU', 'Name': 'Bermuda', 'Continent': 'North America', 'Region': 'North America', 'SurfaceArea': Decimal('53.00'), 'IndepYear': None, 'Population': 65000, 'LifeExpectancy': Decimal('76.9'), 'GNP': Decimal('2328.00'), 'GNPOld': Decimal('2190.00'), 'LocalName': 'Bermuda', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 191, 'Code2': 'BM'}, {'Code': 'BOL', 'Name': 'Bolivia', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('1098581.00'), 'IndepYear': 1825, 'Population': 8329000, 'LifeExpectancy': Decimal('63.7'), 'GNP': Decimal('8571.00'), 'GNPOld': Decimal('7967.00'), 'LocalName': 'Bolivia', 'GovernmentForm': 'Republic', 'HeadOfState': 'Hugo Bánzer Suárez', 'Capital': 194, 'Code2': 'BO'}, {'Code': 'BRA', 'Name': 'Brazil', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('8547403.00'), 'IndepYear': 1822, 'Population': 170115000, 'LifeExpectancy': Decimal('62.9'), 'GNP': Decimal('776739.00'), 'GNPOld': Decimal('804108.00'), 'LocalName': 'Brasil', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Fernando Henrique Cardoso', 'Capital': 211, 'Code2': 'BR'}, {'Code': 'BRB', 'Name': 'Barbados', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('430.00'), 'IndepYear': 1966, 'Population': 270000, 'LifeExpectancy': Decimal('73.0'), 'GNP': Decimal('2223.00'), 'GNPOld': Decimal('2186.00'), 'LocalName': 'Barbados', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 174, 'Code2': 'BB'}, {'Code': 'BRN', 'Name': 'Brunei', 'Continent': 'Asia', 'Region': 'Southeast Asia', 'SurfaceArea': Decimal('5765.00'), 'IndepYear': 1984, 'Population': 328000, 'LifeExpectancy': Decimal('73.6'), 'GNP': Decimal('11705.00'), 'GNPOld': Decimal('12460.00'), 'LocalName': 'Brunei Darussalam', 'GovernmentForm': 'Monarchy (Sultanate)', 'HeadOfState': 'Haji Hassan al-Bolkiah', 'Capital': 538, 'Code2': 'BN'}, {'Code': 'BTN', 'Name': 'Bhutan', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('47000.00'), 'IndepYear': 1910, 'Population': 2124000, 'LifeExpectancy': Decimal('52.4'), 'GNP': Decimal('372.00'), 'GNPOld': Decimal('383.00'), 'LocalName': 'Druk-Yul', 'GovernmentForm': 'Monarchy', 'HeadOfState': 'Jigme Singye Wangchuk', 'Capital': 192, 'Code2': 'BT'}, {'Code': 'BVT', 'Name': 'Bouvet Island', 'Continent': 'Antarctica', 'Region': 'Antarctica', 'SurfaceArea': Decimal('59.00'), 'IndepYear': None, 'Population': 0, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Bouvetøya', 'GovernmentForm': 'Dependent Territory of Norway', 'HeadOfState': 'Harald V', 'Capital': None, 'Code2': 'BV'}, {'Code': 'BWA', 'Name': 'Botswana', 'Continent': 'Africa', 'Region': 'Southern Africa', 'SurfaceArea': Decimal('581730.00'), 'IndepYear': 1966, 'Population': 1622000, 'LifeExpectancy': Decimal('39.3'), 'GNP': Decimal('4834.00'), 'GNPOld': Decimal('4935.00'), 'LocalName': 'Botswana', 'GovernmentForm': 'Republic', 'HeadOfState': 'Festus G. Mogae', 'Capital': 204, 'Code2': 'BW'}, {'Code': 'CAF', 'Name': 'Central African Republic', 'Continent': 'Africa', 'Region': 'Central Africa', 'SurfaceArea': Decimal('622984.00'), 'IndepYear': 1960, 'Population': 3615000, 'LifeExpectancy': Decimal('44.0'), 'GNP': Decimal('1054.00'), 'GNPOld': Decimal('993.00'), 'LocalName': 'Centrafrique/Bê-Afrîka', 'GovernmentForm': 'Republic', 'HeadOfState': 'Ange-Félix Patassé', 'Capital': 1889, 'Code2': 'CF'}, {'Code': 'CAN', 'Name': 'Canada', 'Continent': 'North America', 'Region': 'North America', 'SurfaceArea': Decimal('9970610.00'), 'IndepYear': 1867, 'Population': 31147000, 'LifeExpectancy': Decimal('79.4'), 'GNP': Decimal('598862.00'), 'GNPOld': Decimal('625626.00'), 'LocalName': 'Canada', 'GovernmentForm': 'Constitutional Monarchy, Federation', 'HeadOfState': 'Elisabeth II', 'Capital': 1822, 'Code2': 'CA'}, {'Code': 'CCK', 'Name': 'Cocos (Keeling) Islands', 'Continent': 'Oceania', 'Region': 'Australia and New Zealand', 'SurfaceArea': Decimal('14.00'), 'IndepYear': None, 'Population': 600, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Cocos (Keeling) Islands', 'GovernmentForm': 'Territory of Australia', 'HeadOfState': 'Elisabeth II', 'Capital': 2317, 'Code2': 'CC'}, {'Code': 'CHE', 'Name': 'Switzerland', 'Continent': 'Europe', 'Region': 'Western Europe', 'SurfaceArea': Decimal('41284.00'), 'IndepYear': 1499, 'Population': 7160400, 'LifeExpectancy': Decimal('79.6'), 'GNP': Decimal('264478.00'), 'GNPOld': Decimal('256092.00'), 'LocalName': 'Schweiz/Suisse/Svizzera/Svizra', 'GovernmentForm': 'Federation', 'HeadOfState': 'Adolf Ogi', 'Capital': 3248, 'Code2': 'CH'}, {'Code': 'CHL', 'Name': 'Chile', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('756626.00'), 'IndepYear': 1810, 'Population': 15211000, 'LifeExpectancy': Decimal('75.7'), 'GNP': Decimal('72949.00'), 'GNPOld': Decimal('75780.00'), 'LocalName': 'Chile', 'GovernmentForm': 'Republic', 'HeadOfState': 'Ricardo Lagos Escobar', 'Capital': 554, 'Code2': 'CL'}, {'Code': 'CHN', 'Name': 'China', 'Continent': 'Asia', 'Region': 'Eastern Asia', 'SurfaceArea': Decimal('9572900.00'), 'IndepYear': -1523, 'Population': 1277558000, 'LifeExpectancy': Decimal('71.4'), 'GNP': Decimal('982268.00'), 'GNPOld': Decimal('917719.00'), 'LocalName': 'Zhongquo', 'GovernmentForm': "People'sRepublic", 'HeadOfState': 'Jiang Zemin', 'Capital': 1891, 'Code2': 'CN'}, {'Code': 'CIV', 'Name': 'Côte d’Ivoire', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('322463.00'), 'IndepYear': 1960, 'Population': 14786000, 'LifeExpectancy': Decimal('45.2'), 'GNP': Decimal('11345.00'), 'GNPOld': Decimal('10285.00'), 'LocalName': 'Côte d’Ivoire', 'GovernmentForm': 'Republic', 'HeadOfState': 'Laurent Gbagbo', 'Capital': 2814, 'Code2': 'CI'}, {'Code': 'CMR', 'Name': 'Cameroon', 'Continent': 'Africa', 'Region': 'Central Africa', 'SurfaceArea': Decimal('475442.00'), 'IndepYear': 1960, 'Population': 15085000, 'LifeExpectancy': Decimal('54.8'), 'GNP': Decimal('9174.00'), 'GNPOld': Decimal('8596.00'), 'LocalName': 'Cameroun/Cameroon', 'GovernmentForm': 'Republic', 'HeadOfState': 'Paul Biya', 'Capital': 1804, 'Code2': 'CM'}, {'Code': 'COD', 'Name': 'Congo, The Democratic Republic of the', 'Continent': 'Africa', 'Region': 'Central Africa', 'SurfaceArea': Decimal('2344858.00'), 'IndepYear': 1960, 'Population': 51654000, 'LifeExpectancy': Decimal('48.8'), 'GNP': Decimal('6964.00'), 'GNPOld': Decimal('2474.00'), 'LocalName': 'République Démocratique du Congo', 'GovernmentForm': 'Republic', 'HeadOfState': 'Joseph Kabila', 'Capital': 2298, 'Code2': 'CD'}, {'Code': 'COG', 'Name': 'Congo', 'Continent': 'Africa', 'Region': 'Central Africa', 'SurfaceArea': Decimal('342000.00'), 'IndepYear': 1960, 'Population': 2943000, 'LifeExpectancy': Decimal('47.4'), 'GNP': Decimal('2108.00'), 'GNPOld': Decimal('2287.00'), 'LocalName': 'Congo', 'GovernmentForm': 'Republic', 'HeadOfState': 'Denis Sassou-Nguesso', 'Capital': 2296, 'Code2': 'CG'}, {'Code': 'COK', 'Name': 'Cook Islands', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': Decimal('236.00'), 'IndepYear': None, 'Population': 20000, 'LifeExpectancy': Decimal('71.1'), 'GNP': Decimal('100.00'), 'GNPOld': None, 'LocalName': 'The Cook Islands', 'GovernmentForm': 'Nonmetropolitan Territory of New Zealand', 'HeadOfState': 'Elisabeth II', 'Capital': 583, 'Code2': 'CK'}, {'Code': 'COL', 'Name': 'Colombia', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('1138914.00'), 'IndepYear': 1810, 'Population': 42321000, 'LifeExpectancy': Decimal('70.3'), 'GNP': Decimal('102896.00'), 'GNPOld': Decimal('105116.00'), 'LocalName': 'Colombia', 'GovernmentForm': 'Republic', 'HeadOfState': 'Andrés Pastrana Arango', 'Capital': 2257, 'Code2': 'CO'}, {'Code': 'COM', 'Name': 'Comoros', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('1862.00'), 'IndepYear': 1975, 'Population': 578000, 'LifeExpectancy': Decimal('60.0'), 'GNP': Decimal('4401.00'), 'GNPOld': Decimal('4361.00'), 'LocalName': 'Komori/Comores', 'GovernmentForm': 'Republic', 'HeadOfState': 'Azali Assoumani', 'Capital': 2295, 'Code2': 'KM'}, {'Code': 'CPV', 'Name': 'Cape Verde', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('4033.00'), 'IndepYear': 1975, 'Population': 428000, 'LifeExpectancy': Decimal('68.9'), 'GNP': Decimal('435.00'), 'GNPOld': Decimal('420.00'), 'LocalName': 'Cabo Verde', 'GovernmentForm': 'Republic', 'HeadOfState': 'António Mascarenhas Monteiro', 'Capital': 1859, 'Code2': 'CV'}, {'Code': 'CRI', 'Name': 'Costa Rica', 'Continent': 'North America', 'Region': 'Central America', 'SurfaceArea': Decimal('51100.00'), 'IndepYear': 1821, 'Population': 4023000, 'LifeExpectancy': Decimal('75.8'), 'GNP': Decimal('10226.00'), 'GNPOld': Decimal('9757.00'), 'LocalName': 'Costa Rica', 'GovernmentForm': 'Republic', 'HeadOfState': 'Miguel Ángel Rodríguez Echeverría', 'Capital': 584, 'Code2': 'CR'}, {'Code': 'CUB', 'Name': 'Cuba', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('110861.00'), 'IndepYear': 1902, 'Population': 11201000, 'LifeExpectancy': Decimal('76.2'), 'GNP': Decimal('17843.00'), 'GNPOld': Decimal('18862.00'), 'LocalName': 'Cuba', 'GovernmentForm': 'Socialistic Republic', 'HeadOfState': 'Fidel Castro Ruz', 'Capital': 2413, 'Code2': 'CU'}, {'Code': 'CXR', 'Name': 'Christmas Island', 'Continent': 'Oceania', 'Region': 'Australia and New Zealand', 'SurfaceArea': Decimal('135.00'), 'IndepYear': None, 'Population': 2500, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Christmas Island', 'GovernmentForm': 'Territory of Australia', 'HeadOfState': 'Elisabeth II', 'Capital': 1791, 'Code2': 'CX'}, {'Code': 'CYM', 'Name': 'Cayman Islands', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('264.00'), 'IndepYear': None, 'Population': 38000, 'LifeExpectancy': Decimal('78.9'), 'GNP': Decimal('1263.00'), 'GNPOld': Decimal('1186.00'), 'LocalName': 'Cayman Islands', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 553, 'Code2': 'KY'}, {'Code': 'CYP', 'Name': 'Cyprus', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('9251.00'), 'IndepYear': 1960, 'Population': 754700, 'LifeExpectancy': Decimal('76.7'), 'GNP': Decimal('9333.00'), 'GNPOld': Decimal('8246.00'), 'LocalName': 'Kýpros/Kibris', 'GovernmentForm': 'Republic', 'HeadOfState': 'Glafkos Klerides', 'Capital': 2430, 'Code2': 'CY'}, {'Code': 'CZE', 'Name': 'Czech Republic', 'Continent': 'Europe', 'Region': 'Eastern Europe', 'SurfaceArea': Decimal('78866.00'), 'IndepYear': 1993, 'Population': 10278100, 'LifeExpectancy': Decimal('74.5'), 'GNP': Decimal('55017.00'), 'GNPOld': Decimal('52037.00'), 'LocalName': '¸esko', 'GovernmentForm': 'Republic', 'HeadOfState': 'Václav Havel', 'Capital': 3339, 'Code2': 'CZ'}, {'Code': 'DEU', 'Name': 'Germany', 'Continent': 'Europe', 'Region': 'Western Europe', 'SurfaceArea': Decimal('357022.00'), 'IndepYear': 1955, 'Population': 82164700, 'LifeExpectancy': Decimal('77.4'), 'GNP': Decimal('2133367.00'), 'GNPOld': Decimal('2102826.00'), 'LocalName': 'Deutschland', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Johannes Rau', 'Capital': 3068, 'Code2': 'DE'}, {'Code': 'DJI', 'Name': 'Djibouti', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('23200.00'), 'IndepYear': 1977, 'Population': 638000, 'LifeExpectancy': Decimal('50.8'), 'GNP': Decimal('382.00'), 'GNPOld': Decimal('373.00'), 'LocalName': 'Djibouti/Jibuti', 'GovernmentForm': 'Republic', 'HeadOfState': 'Ismail Omar Guelleh', 'Capital': 585, 'Code2': 'DJ'}, {'Code': 'DMA', 'Name': 'Dominica', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('751.00'), 'IndepYear': 1978, 'Population': 71000, 'LifeExpectancy': Decimal('73.4'), 'GNP': Decimal('256.00'), 'GNPOld': Decimal('243.00'), 'LocalName': 'Dominica', 'GovernmentForm': 'Republic', 'HeadOfState': 'Vernon Shaw', 'Capital': 586, 'Code2': 'DM'}, {'Code': 'DNK', 'Name': 'Denmark', 'Continent': 'Europe', 'Region': 'Nordic Countries', 'SurfaceArea': Decimal('43094.00'), 'IndepYear': 800, 'Population': 5330000, 'LifeExpectancy': Decimal('76.5'), 'GNP': Decimal('174099.00'), 'GNPOld': Decimal('169264.00'), 'LocalName': 'Danmark', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Margrethe II', 'Capital': 3315, 'Code2': 'DK'}, {'Code': 'DOM', 'Name': 'Dominican Republic', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('48511.00'), 'IndepYear': 1844, 'Population': 8495000, 'LifeExpectancy': Decimal('73.2'), 'GNP': Decimal('15846.00'), 'GNPOld': Decimal('15076.00'), 'LocalName': 'República Dominicana', 'GovernmentForm': 'Republic', 'HeadOfState': 'Hipólito Mejía Domínguez', 'Capital': 587, 'Code2': 'DO'}, {'Code': 'DZA', 'Name': 'Algeria', 'Continent': 'Africa', 'Region': 'Northern Africa', 'SurfaceArea': Decimal('2381741.00'), 'IndepYear': 1962, 'Population': 31471000, 'LifeExpectancy': Decimal('69.7'), 'GNP': Decimal('49982.00'), 'GNPOld': Decimal('46966.00'), 'LocalName': 'Al-Jaza’ir/Algérie', 'GovernmentForm': 'Republic', 'HeadOfState': 'Abdelaziz Bouteflika', 'Capital': 35, 'Code2': 'DZ'}, {'Code': 'ECU', 'Name': 'Ecuador', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('283561.00'), 'IndepYear': 1822, 'Population': 12646000, 'LifeExpectancy': Decimal('71.1'), 'GNP': Decimal('19770.00'), 'GNPOld': Decimal('19769.00'), 'LocalName': 'Ecuador', 'GovernmentForm': 'Republic', 'HeadOfState': 'Gustavo Noboa Bejarano', 'Capital': 594, 'Code2': 'EC'}, {'Code': 'EGY', 'Name': 'Egypt', 'Continent': 'Africa', 'Region': 'Northern Africa', 'SurfaceArea': Decimal('1001449.00'), 'IndepYear': 1922, 'Population': 68470000, 'LifeExpectancy': Decimal('63.3'), 'GNP': Decimal('82710.00'), 'GNPOld': Decimal('75617.00'), 'LocalName': 'Misr', 'GovernmentForm': 'Republic', 'HeadOfState': 'Hosni Mubarak', 'Capital': 608, 'Code2': 'EG'}, {'Code': 'ERI', 'Name': 'Eritrea', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('117600.00'), 'IndepYear': 1993, 'Population': 3850000, 'LifeExpectancy': Decimal('55.8'), 'GNP': Decimal('650.00'), 'GNPOld': Decimal('755.00'), 'LocalName': 'Ertra', 'GovernmentForm': 'Republic', 'HeadOfState': 'Isayas Afewerki [Isaias Afwerki]', 'Capital': 652, 'Code2': 'ER'}, {'Code': 'ESH', 'Name': 'Western Sahara', 'Continent': 'Africa', 'Region': 'Northern Africa', 'SurfaceArea': Decimal('266000.00'), 'IndepYear': None, 'Population': 293000, 'LifeExpectancy': Decimal('49.8'), 'GNP': Decimal('60.00'), 'GNPOld': None, 'LocalName': 'As-Sahrawiya', 'GovernmentForm': 'Occupied by Marocco', 'HeadOfState': 'Mohammed Abdel Aziz', 'Capital': 2453, 'Code2': 'EH'}, {'Code': 'ESP', 'Name': 'Spain', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('505992.00'), 'IndepYear': 1492, 'Population': 39441700, 'LifeExpectancy': Decimal('78.8'), 'GNP': Decimal('553233.00'), 'GNPOld': Decimal('532031.00'), 'LocalName': 'España', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Juan Carlos I', 'Capital': 653, 'Code2': 'ES'}, {'Code': 'EST', 'Name': 'Estonia', 'Continent': 'Europe', 'Region': 'Baltic Countries', 'SurfaceArea': Decimal('45227.00'), 'IndepYear': 1991, 'Population': 1439200, 'LifeExpectancy': Decimal('69.5'), 'GNP': Decimal('5328.00'), 'GNPOld': Decimal('3371.00'), 'LocalName': 'Eesti', 'GovernmentForm': 'Republic', 'HeadOfState': 'Lennart Meri', 'Capital': 3791, 'Code2': 'EE'}, {'Code': 'ETH', 'Name': 'Ethiopia', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('1104300.00'), 'IndepYear': -1000, 'Population': 62565000, 'LifeExpectancy': Decimal('45.2'), 'GNP': Decimal('6353.00'), 'GNPOld': Decimal('6180.00'), 'LocalName': 'YeItyop´iya', 'GovernmentForm': 'Republic', 'HeadOfState': 'Negasso Gidada', 'Capital': 756, 'Code2': 'ET'}, {'Code': 'FIN', 'Name': 'Finland', 'Continent': 'Europe', 'Region': 'Nordic Countries', 'SurfaceArea': Decimal('338145.00'), 'IndepYear': 1917, 'Population': 5171300, 'LifeExpectancy': Decimal('77.4'), 'GNP': Decimal('121914.00'), 'GNPOld': Decimal('119833.00'), 'LocalName': 'Suomi', 'GovernmentForm': 'Republic', 'HeadOfState': 'Tarja Halonen', 'Capital': 3236, 'Code2': 'FI'}, {'Code': 'FJI', 'Name': 'Fiji Islands', 'Continent': 'Oceania', 'Region': 'Melanesia', 'SurfaceArea': Decimal('18274.00'), 'IndepYear': 1970, 'Population': 817000, 'LifeExpectancy': Decimal('67.9'), 'GNP': Decimal('1536.00'), 'GNPOld': Decimal('2149.00'), 'LocalName': 'Fiji Islands', 'GovernmentForm': 'Republic', 'HeadOfState': 'Josefa Iloilo', 'Capital': 764, 'Code2': 'FJ'}, {'Code': 'FLK', 'Name': 'Falkland Islands', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('12173.00'), 'IndepYear': None, 'Population': 2000, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Falkland Islands', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 763, 'Code2': 'FK'}, {'Code': 'FRA', 'Name': 'France', 'Continent': 'Europe', 'Region': 'Western Europe', 'SurfaceArea': Decimal('551500.00'), 'IndepYear': 843, 'Population': 59225700, 'LifeExpectancy': Decimal('78.8'), 'GNP': Decimal('1424285.00'), 'GNPOld': Decimal('1392448.00'), 'LocalName': 'France', 'GovernmentForm': 'Republic', 'HeadOfState': 'Jacques Chirac', 'Capital': 2974, 'Code2': 'FR'}, {'Code': 'FRO', 'Name': 'Faroe Islands', 'Continent': 'Europe', 'Region': 'Nordic Countries', 'SurfaceArea': Decimal('1399.00'), 'IndepYear': None, 'Population': 43000, 'LifeExpectancy': Decimal('78.4'), 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Føroyar', 'GovernmentForm': 'Part of Denmark', 'HeadOfState': 'Margrethe II', 'Capital': 901, 'Code2': 'FO'}, {'Code': 'FSM', 'Name': 'Micronesia, Federated States of', 'Continent': 'Oceania', 'Region': 'Micronesia', 'SurfaceArea': Decimal('702.00'), 'IndepYear': 1990, 'Population': 119000, 'LifeExpectancy': Decimal('68.6'), 'GNP': Decimal('212.00'), 'GNPOld': None, 'LocalName': 'Micronesia', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Leo A. Falcam', 'Capital': 2689, 'Code2': 'FM'}, {'Code': 'GAB', 'Name': 'Gabon', 'Continent': 'Africa', 'Region': 'Central Africa', 'SurfaceArea': Decimal('267668.00'), 'IndepYear': 1960, 'Population': 1226000, 'LifeExpectancy': Decimal('50.1'), 'GNP': Decimal('5493.00'), 'GNPOld': Decimal('5279.00'), 'LocalName': 'Le Gabon', 'GovernmentForm': 'Republic', 'HeadOfState': 'Omar Bongo', 'Capital': 902, 'Code2': 'GA'}, {'Code': 'GBR', 'Name': 'United Kingdom', 'Continent': 'Europe', 'Region': 'British Islands', 'SurfaceArea': Decimal('242900.00'), 'IndepYear': 1066, 'Population': 59623400, 'LifeExpectancy': Decimal('77.7'), 'GNP': Decimal('1378330.00'), 'GNPOld': Decimal('1296830.00'), 'LocalName': 'United Kingdom', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 456, 'Code2': 'GB'}, {'Code': 'GEO', 'Name': 'Georgia', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('69700.00'), 'IndepYear': 1991, 'Population': 4968000, 'LifeExpectancy': Decimal('64.5'), 'GNP': Decimal('6064.00'), 'GNPOld': Decimal('5924.00'), 'LocalName': 'Sakartvelo', 'GovernmentForm': 'Republic', 'HeadOfState': 'Eduard Ševardnadze', 'Capital': 905, 'Code2': 'GE'}, {'Code': 'GHA', 'Name': 'Ghana', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('238533.00'), 'IndepYear': 1957, 'Population': 20212000, 'LifeExpectancy': Decimal('57.4'), 'GNP': Decimal('7137.00'), 'GNPOld': Decimal('6884.00'), 'LocalName': 'Ghana', 'GovernmentForm': 'Republic', 'HeadOfState': 'John Kufuor', 'Capital': 910, 'Code2': 'GH'}, {'Code': 'GIB', 'Name': 'Gibraltar', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('6.00'), 'IndepYear': None, 'Population': 25000, 'LifeExpectancy': Decimal('79.0'), 'GNP': Decimal('258.00'), 'GNPOld': None, 'LocalName': 'Gibraltar', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 915, 'Code2': 'GI'}, {'Code': 'GIN', 'Name': 'Guinea', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('245857.00'), 'IndepYear': 1958, 'Population': 7430000, 'LifeExpectancy': Decimal('45.6'), 'GNP': Decimal('2352.00'), 'GNPOld': Decimal('2383.00'), 'LocalName': 'Guinée', 'GovernmentForm': 'Republic', 'HeadOfState': 'Lansana Conté', 'Capital': 926, 'Code2': 'GN'}, {'Code': 'GLP', 'Name': 'Guadeloupe', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('1705.00'), 'IndepYear': None, 'Population': 456000, 'LifeExpectancy': Decimal('77.0'), 'GNP': Decimal('3501.00'), 'GNPOld': None, 'LocalName': 'Guadeloupe', 'GovernmentForm': 'Overseas Department of France', 'HeadOfState': 'Jacques Chirac', 'Capital': 919, 'Code2': 'GP'}, {'Code': 'GMB', 'Name': 'Gambia', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('11295.00'), 'IndepYear': 1965, 'Population': 1305000, 'LifeExpectancy': Decimal('53.2'), 'GNP': Decimal('320.00'), 'GNPOld': Decimal('325.00'), 'LocalName': 'The Gambia', 'GovernmentForm': 'Republic', 'HeadOfState': 'Yahya Jammeh', 'Capital': 904, 'Code2': 'GM'}, {'Code': 'GNB', 'Name': 'Guinea-Bissau', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('36125.00'), 'IndepYear': 1974, 'Population': 1213000, 'LifeExpectancy': Decimal('49.0'), 'GNP': Decimal('293.00'), 'GNPOld': Decimal('272.00'), 'LocalName': 'Guiné-Bissau', 'GovernmentForm': 'Republic', 'HeadOfState': 'Kumba Ialá', 'Capital': 927, 'Code2': 'GW'}, {'Code': 'GNQ', 'Name': 'Equatorial Guinea', 'Continent': 'Africa', 'Region': 'Central Africa', 'SurfaceArea': Decimal('28051.00'), 'IndepYear': 1968, 'Population': 453000, 'LifeExpectancy': Decimal('53.6'), 'GNP': Decimal('283.00'), 'GNPOld': Decimal('542.00'), 'LocalName': 'Guinea Ecuatorial', 'GovernmentForm': 'Republic', 'HeadOfState': 'Teodoro Obiang Nguema Mbasogo', 'Capital': 2972, 'Code2': 'GQ'}, {'Code': 'GRC', 'Name': 'Greece', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('131626.00'), 'IndepYear': 1830, 'Population': 10545700, 'LifeExpectancy': Decimal('78.4'), 'GNP': Decimal('120724.00'), 'GNPOld': Decimal('119946.00'), 'LocalName': 'Elláda', 'GovernmentForm': 'Republic', 'HeadOfState': 'Kostis Stefanopoulos', 'Capital': 2401, 'Code2': 'GR'}, {'Code': 'GRD', 'Name': 'Grenada', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('344.00'), 'IndepYear': 1974, 'Population': 94000, 'LifeExpectancy': Decimal('64.5'), 'GNP': Decimal('318.00'), 'GNPOld': None, 'LocalName': 'Grenada', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 916, 'Code2': 'GD'}, {'Code': 'GRL', 'Name': 'Greenland', 'Continent': 'North America', 'Region': 'North America', 'SurfaceArea': Decimal('2166090.00'), 'IndepYear': None, 'Population': 56000, 'LifeExpectancy': Decimal('68.1'), 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Kalaallit Nunaat/Grønland', 'GovernmentForm': 'Part of Denmark', 'HeadOfState': 'Margrethe II', 'Capital': 917, 'Code2': 'GL'}, {'Code': 'GTM', 'Name': 'Guatemala', 'Continent': 'North America', 'Region': 'Central America', 'SurfaceArea': Decimal('108889.00'), 'IndepYear': 1821, 'Population': 11385000, 'LifeExpectancy': Decimal('66.2'), 'GNP': Decimal('19008.00'), 'GNPOld': Decimal('17797.00'), 'LocalName': 'Guatemala', 'GovernmentForm': 'Republic', 'HeadOfState': 'Alfonso Portillo Cabrera', 'Capital': 922, 'Code2': 'GT'}, {'Code': 'GUF', 'Name': 'French Guiana', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('90000.00'), 'IndepYear': None, 'Population': 181000, 'LifeExpectancy': Decimal('76.1'), 'GNP': Decimal('681.00'), 'GNPOld': None, 'LocalName': 'Guyane française', 'GovernmentForm': 'Overseas Department of France', 'HeadOfState': 'Jacques Chirac', 'Capital': 3014, 'Code2': 'GF'}, {'Code': 'GUM', 'Name': 'Guam', 'Continent': 'Oceania', 'Region': 'Micronesia', 'SurfaceArea': Decimal('549.00'), 'IndepYear': None, 'Population': 168000, 'LifeExpectancy': Decimal('77.8'), 'GNP': Decimal('1197.00'), 'GNPOld': Decimal('1136.00'), 'LocalName': 'Guam', 'GovernmentForm': 'US Territory', 'HeadOfState': 'George W. Bush', 'Capital': 921, 'Code2': 'GU'}, {'Code': 'GUY', 'Name': 'Guyana', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('214969.00'), 'IndepYear': 1966, 'Population': 861000, 'LifeExpectancy': Decimal('64.0'), 'GNP': Decimal('722.00'), 'GNPOld': Decimal('743.00'), 'LocalName': 'Guyana', 'GovernmentForm': 'Republic', 'HeadOfState': 'Bharrat Jagdeo', 'Capital': 928, 'Code2': 'GY'}, {'Code': 'HKG', 'Name': 'Hong Kong', 'Continent': 'Asia', 'Region': 'Eastern Asia', 'SurfaceArea': Decimal('1075.00'), 'IndepYear': None, 'Population': 6782000, 'LifeExpectancy': Decimal('79.5'), 'GNP': Decimal('166448.00'), 'GNPOld': Decimal('173610.00'), 'LocalName': 'Xianggang/Hong Kong', 'GovernmentForm': 'Special Administrative Region of China', 'HeadOfState': 'Jiang Zemin', 'Capital': 937, 'Code2': 'HK'}, {'Code': 'HMD', 'Name': 'Heard Island and McDonald Islands', 'Continent': 'Antarctica', 'Region': 'Antarctica', 'SurfaceArea': Decimal('359.00'), 'IndepYear': None, 'Population': 0, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Heard and McDonald Islands', 'GovernmentForm': 'Territory of Australia', 'HeadOfState': 'Elisabeth II', 'Capital': None, 'Code2': 'HM'}, {'Code': 'HND', 'Name': 'Honduras', 'Continent': 'North America', 'Region': 'Central America', 'SurfaceArea': Decimal('112088.00'), 'IndepYear': 1838, 'Population': 6485000, 'LifeExpectancy': Decimal('69.9'), 'GNP': Decimal('5333.00'), 'GNPOld': Decimal('4697.00'), 'LocalName': 'Honduras', 'GovernmentForm': 'Republic', 'HeadOfState': 'Carlos Roberto Flores Facussé', 'Capital': 933, 'Code2': 'HN'}, {'Code': 'HRV', 'Name': 'Croatia', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('56538.00'), 'IndepYear': 1991, 'Population': 4473000, 'LifeExpectancy': Decimal('73.7'), 'GNP': Decimal('20208.00'), 'GNPOld': Decimal('19300.00'), 'LocalName': 'Hrvatska', 'GovernmentForm': 'Republic', 'HeadOfState': 'Štipe Mesic', 'Capital': 2409, 'Code2': 'HR'}, {'Code': 'HTI', 'Name': 'Haiti', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('27750.00'), 'IndepYear': 1804, 'Population': 8222000, 'LifeExpectancy': Decimal('49.2'), 'GNP': Decimal('3459.00'), 'GNPOld': Decimal('3107.00'), 'LocalName': 'Haïti/Dayti', 'GovernmentForm': 'Republic', 'HeadOfState': 'Jean-Bertrand Aristide', 'Capital': 929, 'Code2': 'HT'}, {'Code': 'HUN', 'Name': 'Hungary', 'Continent': 'Europe', 'Region': 'Eastern Europe', 'SurfaceArea': Decimal('93030.00'), 'IndepYear': 1918, 'Population': 10043200, 'LifeExpectancy': Decimal('71.4'), 'GNP': Decimal('48267.00'), 'GNPOld': Decimal('45914.00'), 'LocalName': 'Magyarország', 'GovernmentForm': 'Republic', 'HeadOfState': 'Ferenc Mádl', 'Capital': 3483, 'Code2': 'HU'}, {'Code': 'IDN', 'Name': 'Indonesia', 'Continent': 'Asia', 'Region': 'Southeast Asia', 'SurfaceArea': Decimal('1904569.00'), 'IndepYear': 1945, 'Population': 212107000, 'LifeExpectancy': Decimal('68.0'), 'GNP': Decimal('84982.00'), 'GNPOld': Decimal('215002.00'), 'LocalName': 'Indonesia', 'GovernmentForm': 'Republic', 'HeadOfState': 'Abdurrahman Wahid', 'Capital': 939, 'Code2': 'ID'}, {'Code': 'IND', 'Name': 'India', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('3287263.00'), 'IndepYear': 1947, 'Population': 1013662000, 'LifeExpectancy': Decimal('62.5'), 'GNP': Decimal('447114.00'), 'GNPOld': Decimal('430572.00'), 'LocalName': 'Bharat/India', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Kocheril Raman Narayanan', 'Capital': 1109, 'Code2': 'IN'}, {'Code': 'IOT', 'Name': 'British Indian Ocean Territory', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('78.00'), 'IndepYear': None, 'Population': 0, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'British Indian Ocean Territory', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': None, 'Code2': 'IO'}, {'Code': 'IRL', 'Name': 'Ireland', 'Continent': 'Europe', 'Region': 'British Islands', 'SurfaceArea': Decimal('70273.00'), 'IndepYear': 1921, 'Population': 3775100, 'LifeExpectancy': Decimal('76.8'), 'GNP': Decimal('75921.00'), 'GNPOld': Decimal('73132.00'), 'LocalName': 'Ireland/Éire', 'GovernmentForm': 'Republic', 'HeadOfState': 'Mary McAleese', 'Capital': 1447, 'Code2': 'IE'}, {'Code': 'IRN', 'Name': 'Iran', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('1648195.00'), 'IndepYear': 1906, 'Population': 67702000, 'LifeExpectancy': Decimal('69.7'), 'GNP': Decimal('195746.00'), 'GNPOld': Decimal('160151.00'), 'LocalName': 'Iran', 'GovernmentForm': 'Islamic Republic', 'HeadOfState': 'Ali Mohammad Khatami-Ardakani', 'Capital': 1380, 'Code2': 'IR'}, {'Code': 'IRQ', 'Name': 'Iraq', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('438317.00'), 'IndepYear': 1932, 'Population': 23115000, 'LifeExpectancy': Decimal('66.5'), 'GNP': Decimal('11500.00'), 'GNPOld': None, 'LocalName': 'Al-´Iraq', 'GovernmentForm': 'Republic', 'HeadOfState': 'Saddam Hussein al-Takriti', 'Capital': 1365, 'Code2': 'IQ'}, {'Code': 'ISL', 'Name': 'Iceland', 'Continent': 'Europe', 'Region': 'Nordic Countries', 'SurfaceArea': Decimal('103000.00'), 'IndepYear': 1944, 'Population': 279000, 'LifeExpectancy': Decimal('79.4'), 'GNP': Decimal('8255.00'), 'GNPOld': Decimal('7474.00'), 'LocalName': 'Ísland', 'GovernmentForm': 'Republic', 'HeadOfState': 'Ólafur Ragnar Grímsson', 'Capital': 1449, 'Code2': 'IS'}, {'Code': 'ISR', 'Name': 'Israel', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('21056.00'), 'IndepYear': 1948, 'Population': 6217000, 'LifeExpectancy': Decimal('78.6'), 'GNP': Decimal('97477.00'), 'GNPOld': Decimal('98577.00'), 'LocalName': 'Yisra’el/Isra’il', 'GovernmentForm': 'Republic', 'HeadOfState': 'Moshe Katzav', 'Capital': 1450, 'Code2': 'IL'}, {'Code': 'ITA', 'Name': 'Italy', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('301316.00'), 'IndepYear': 1861, 'Population': 57680000, 'LifeExpectancy': Decimal('79.0'), 'GNP': Decimal('1161755.00'), 'GNPOld': Decimal('1145372.00'), 'LocalName': 'Italia', 'GovernmentForm': 'Republic', 'HeadOfState': 'Carlo Azeglio Ciampi', 'Capital': 1464, 'Code2': 'IT'}, {'Code': 'JAM', 'Name': 'Jamaica', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('10990.00'), 'IndepYear': 1962, 'Population': 2583000, 'LifeExpectancy': Decimal('75.2'), 'GNP': Decimal('6871.00'), 'GNPOld': Decimal('6722.00'), 'LocalName': 'Jamaica', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 1530, 'Code2': 'JM'}, {'Code': 'JOR', 'Name': 'Jordan', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('88946.00'), 'IndepYear': 1946, 'Population': 5083000, 'LifeExpectancy': Decimal('77.4'), 'GNP': Decimal('7526.00'), 'GNPOld': Decimal('7051.00'), 'LocalName': 'Al-Urdunn', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Abdullah II', 'Capital': 1786, 'Code2': 'JO'}, {'Code': 'JPN', 'Name': 'Japan', 'Continent': 'Asia', 'Region': 'Eastern Asia', 'SurfaceArea': Decimal('377829.00'), 'IndepYear': -660, 'Population': 126714000, 'LifeExpectancy': Decimal('80.7'), 'GNP': Decimal('3787042.00'), 'GNPOld': Decimal('4192638.00'), 'LocalName': 'Nihon/Nippon', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Akihito', 'Capital': 1532, 'Code2': 'JP'}, {'Code': 'KAZ', 'Name': 'Kazakstan', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('2724900.00'), 'IndepYear': 1991, 'Population': 16223000, 'LifeExpectancy': Decimal('63.2'), 'GNP': Decimal('24375.00'), 'GNPOld': Decimal('23383.00'), 'LocalName': 'Qazaqstan', 'GovernmentForm': 'Republic', 'HeadOfState': 'Nursultan Nazarbajev', 'Capital': 1864, 'Code2': 'KZ'}, {'Code': 'KEN', 'Name': 'Kenya', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('580367.00'), 'IndepYear': 1963, 'Population': 30080000, 'LifeExpectancy': Decimal('48.0'), 'GNP': Decimal('9217.00'), 'GNPOld': Decimal('10241.00'), 'LocalName': 'Kenya', 'GovernmentForm': 'Republic', 'HeadOfState': 'Daniel arap Moi', 'Capital': 1881, 'Code2': 'KE'}, {'Code': 'KGZ', 'Name': 'Kyrgyzstan', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('199900.00'), 'IndepYear': 1991, 'Population': 4699000, 'LifeExpectancy': Decimal('63.4'), 'GNP': Decimal('1626.00'), 'GNPOld': Decimal('1767.00'), 'LocalName': 'Kyrgyzstan', 'GovernmentForm': 'Republic', 'HeadOfState': 'Askar Akajev', 'Capital': 2253, 'Code2': 'KG'}, {'Code': 'KHM', 'Name': 'Cambodia', 'Continent': 'Asia', 'Region': 'Southeast Asia', 'SurfaceArea': Decimal('181035.00'), 'IndepYear': 1953, 'Population': 11168000, 'LifeExpectancy': Decimal('56.5'), 'GNP': Decimal('5121.00'), 'GNPOld': Decimal('5670.00'), 'LocalName': 'Kâmpuchéa', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Norodom Sihanouk', 'Capital': 1800, 'Code2': 'KH'}, {'Code': 'KIR', 'Name': 'Kiribati', 'Continent': 'Oceania', 'Region': 'Micronesia', 'SurfaceArea': Decimal('726.00'), 'IndepYear': 1979, 'Population': 83000, 'LifeExpectancy': Decimal('59.8'), 'GNP': Decimal('40.70'), 'GNPOld': None, 'LocalName': 'Kiribati', 'GovernmentForm': 'Republic', 'HeadOfState': 'Teburoro Tito', 'Capital': 2256, 'Code2': 'KI'}, {'Code': 'KNA', 'Name': 'Saint Kitts and Nevis', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('261.00'), 'IndepYear': 1983, 'Population': 38000, 'LifeExpectancy': Decimal('70.7'), 'GNP': Decimal('299.00'), 'GNPOld': None, 'LocalName': 'Saint Kitts and Nevis', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 3064, 'Code2': 'KN'}, {'Code': 'KOR', 'Name': 'South Korea', 'Continent': 'Asia', 'Region': 'Eastern Asia', 'SurfaceArea': Decimal('99434.00'), 'IndepYear': 1948, 'Population': 46844000, 'LifeExpectancy': Decimal('74.4'), 'GNP': Decimal('320749.00'), 'GNPOld': Decimal('442544.00'), 'LocalName': 'Taehan Min’guk (Namhan)', 'GovernmentForm': 'Republic', 'HeadOfState': 'Kim Dae-jung', 'Capital': 2331, 'Code2': 'KR'}, {'Code': 'KWT', 'Name': 'Kuwait', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('17818.00'), 'IndepYear': 1961, 'Population': 1972000, 'LifeExpectancy': Decimal('76.1'), 'GNP': Decimal('27037.00'), 'GNPOld': Decimal('30373.00'), 'LocalName': 'Al-Kuwayt', 'GovernmentForm': 'Constitutional Monarchy (Emirate)', 'HeadOfState': 'Jabir al-Ahmad al-Jabir al-Sabah', 'Capital': 2429, 'Code2': 'KW'}, {'Code': 'LAO', 'Name': 'Laos', 'Continent': 'Asia', 'Region': 'Southeast Asia', 'SurfaceArea': Decimal('236800.00'), 'IndepYear': 1953, 'Population': 5433000, 'LifeExpectancy': Decimal('53.1'), 'GNP': Decimal('1292.00'), 'GNPOld': Decimal('1746.00'), 'LocalName': 'Lao', 'GovernmentForm': 'Republic', 'HeadOfState': 'Khamtay Siphandone', 'Capital': 2432, 'Code2': 'LA'}, {'Code': 'LBN', 'Name': 'Lebanon', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('10400.00'), 'IndepYear': 1941, 'Population': 3282000, 'LifeExpectancy': Decimal('71.3'), 'GNP': Decimal('17121.00'), 'GNPOld': Decimal('15129.00'), 'LocalName': 'Lubnan', 'GovernmentForm': 'Republic', 'HeadOfState': 'Émile Lahoud', 'Capital': 2438, 'Code2': 'LB'}, {'Code': 'LBR', 'Name': 'Liberia', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('111369.00'), 'IndepYear': 1847, 'Population': 3154000, 'LifeExpectancy': Decimal('51.0'), 'GNP': Decimal('2012.00'), 'GNPOld': None, 'LocalName': 'Liberia', 'GovernmentForm': 'Republic', 'HeadOfState': 'Charles Taylor', 'Capital': 2440, 'Code2': 'LR'}, {'Code': 'LBY', 'Name': 'Libyan Arab Jamahiriya', 'Continent': 'Africa', 'Region': 'Northern Africa', 'SurfaceArea': Decimal('1759540.00'), 'IndepYear': 1951, 'Population': 5605000, 'LifeExpectancy': Decimal('75.5'), 'GNP': Decimal('44806.00'), 'GNPOld': Decimal('40562.00'), 'LocalName': 'Libiya', 'GovernmentForm': 'Socialistic State', 'HeadOfState': 'Muammar al-Qadhafi', 'Capital': 2441, 'Code2': 'LY'}, {'Code': 'LCA', 'Name': 'Saint Lucia', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('622.00'), 'IndepYear': 1979, 'Population': 154000, 'LifeExpectancy': Decimal('72.3'), 'GNP': Decimal('571.00'), 'GNPOld': None, 'LocalName': 'Saint Lucia', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 3065, 'Code2': 'LC'}, {'Code': 'LIE', 'Name': 'Liechtenstein', 'Continent': 'Europe', 'Region': 'Western Europe', 'SurfaceArea': Decimal('160.00'), 'IndepYear': 1806, 'Population': 32300, 'LifeExpectancy': Decimal('78.8'), 'GNP': Decimal('1119.00'), 'GNPOld': Decimal('1084.00'), 'LocalName': 'Liechtenstein', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Hans-Adam II', 'Capital': 2446, 'Code2': 'LI'}, {'Code': 'LKA', 'Name': 'Sri Lanka', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('65610.00'), 'IndepYear': 1948, 'Population': 18827000, 'LifeExpectancy': Decimal('71.8'), 'GNP': Decimal('15706.00'), 'GNPOld': Decimal('15091.00'), 'LocalName': 'Sri Lanka/Ilankai', 'GovernmentForm': 'Republic', 'HeadOfState': 'Chandrika Kumaratunga', 'Capital': 3217, 'Code2': 'LK'}, {'Code': 'LSO', 'Name': 'Lesotho', 'Continent': 'Africa', 'Region': 'Southern Africa', 'SurfaceArea': Decimal('30355.00'), 'IndepYear': 1966, 'Population': 2153000, 'LifeExpectancy': Decimal('50.8'), 'GNP': Decimal('1061.00'), 'GNPOld': Decimal('1161.00'), 'LocalName': 'Lesotho', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Letsie III', 'Capital': 2437, 'Code2': 'LS'}, {'Code': 'LTU', 'Name': 'Lithuania', 'Continent': 'Europe', 'Region': 'Baltic Countries', 'SurfaceArea': Decimal('65301.00'), 'IndepYear': 1991, 'Population': 3698500, 'LifeExpectancy': Decimal('69.1'), 'GNP': Decimal('10692.00'), 'GNPOld': Decimal('9585.00'), 'LocalName': 'Lietuva', 'GovernmentForm': 'Republic', 'HeadOfState': 'Valdas Adamkus', 'Capital': 2447, 'Code2': 'LT'}, {'Code': 'LUX', 'Name': 'Luxembourg', 'Continent': 'Europe', 'Region': 'Western Europe', 'SurfaceArea': Decimal('2586.00'), 'IndepYear': 1867, 'Population': 435700, 'LifeExpectancy': Decimal('77.1'), 'GNP': Decimal('16321.00'), 'GNPOld': Decimal('15519.00'), 'LocalName': 'Luxembourg/Lëtzebuerg', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Henri', 'Capital': 2452, 'Code2': 'LU'}, {'Code': 'LVA', 'Name': 'Latvia', 'Continent': 'Europe', 'Region': 'Baltic Countries', 'SurfaceArea': Decimal('64589.00'), 'IndepYear': 1991, 'Population': 2424200, 'LifeExpectancy': Decimal('68.4'), 'GNP': Decimal('6398.00'), 'GNPOld': Decimal('5639.00'), 'LocalName': 'Latvija', 'GovernmentForm': 'Republic', 'HeadOfState': 'Vaira Vike-Freiberga', 'Capital': 2434, 'Code2': 'LV'}, {'Code': 'MAC', 'Name': 'Macao', 'Continent': 'Asia', 'Region': 'Eastern Asia', 'SurfaceArea': Decimal('18.00'), 'IndepYear': None, 'Population': 473000, 'LifeExpectancy': Decimal('81.6'), 'GNP': Decimal('5749.00'), 'GNPOld': Decimal('5940.00'), 'LocalName': 'Macau/Aomen', 'GovernmentForm': 'Special Administrative Region of China', 'HeadOfState': 'Jiang Zemin', 'Capital': 2454, 'Code2': 'MO'}, {'Code': 'MAR', 'Name': 'Morocco', 'Continent': 'Africa', 'Region': 'Northern Africa', 'SurfaceArea': Decimal('446550.00'), 'IndepYear': 1956, 'Population': 28351000, 'LifeExpectancy': Decimal('69.1'), 'GNP': Decimal('36124.00'), 'GNPOld': Decimal('33514.00'), 'LocalName': 'Al-Maghrib', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Mohammed VI', 'Capital': 2486, 'Code2': 'MA'}, {'Code': 'MCO', 'Name': 'Monaco', 'Continent': 'Europe', 'Region': 'Western Europe', 'SurfaceArea': Decimal('1.50'), 'IndepYear': 1861, 'Population': 34000, 'LifeExpectancy': Decimal('78.8'), 'GNP': Decimal('776.00'), 'GNPOld': None, 'LocalName': 'Monaco', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Rainier III', 'Capital': 2695, 'Code2': 'MC'}, {'Code': 'MDA', 'Name': 'Moldova', 'Continent': 'Europe', 'Region': 'Eastern Europe', 'SurfaceArea': Decimal('33851.00'), 'IndepYear': 1991, 'Population': 4380000, 'LifeExpectancy': Decimal('64.5'), 'GNP': Decimal('1579.00'), 'GNPOld': Decimal('1872.00'), 'LocalName': 'Moldova', 'GovernmentForm': 'Republic', 'HeadOfState': 'Vladimir Voronin', 'Capital': 2690, 'Code2': 'MD'}, {'Code': 'MDG', 'Name': 'Madagascar', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('587041.00'), 'IndepYear': 1960, 'Population': 15942000, 'LifeExpectancy': Decimal('55.0'), 'GNP': Decimal('3750.00'), 'GNPOld': Decimal('3545.00'), 'LocalName': 'Madagasikara/Madagascar', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Didier Ratsiraka', 'Capital': 2455, 'Code2': 'MG'}, {'Code': 'MDV', 'Name': 'Maldives', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('298.00'), 'IndepYear': 1965, 'Population': 286000, 'LifeExpectancy': Decimal('62.2'), 'GNP': Decimal('199.00'), 'GNPOld': None, 'LocalName': 'Dhivehi Raajje/Maldives', 'GovernmentForm': 'Republic', 'HeadOfState': 'Maumoon Abdul Gayoom', 'Capital': 2463, 'Code2': 'MV'}, {'Code': 'MEX', 'Name': 'Mexico', 'Continent': 'North America', 'Region': 'Central America', 'SurfaceArea': Decimal('1958201.00'), 'IndepYear': 1810, 'Population': 98881000, 'LifeExpectancy': Decimal('71.5'), 'GNP': Decimal('414972.00'), 'GNPOld': Decimal('401461.00'), 'LocalName': 'México', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Vicente Fox Quesada', 'Capital': 2515, 'Code2': 'MX'}, {'Code': 'MHL', 'Name': 'Marshall Islands', 'Continent': 'Oceania', 'Region': 'Micronesia', 'SurfaceArea': Decimal('181.00'), 'IndepYear': 1990, 'Population': 64000, 'LifeExpectancy': Decimal('65.5'), 'GNP': Decimal('97.00'), 'GNPOld': None, 'LocalName': 'Marshall Islands/Majol', 'GovernmentForm': 'Republic', 'HeadOfState': 'Kessai Note', 'Capital': 2507, 'Code2': 'MH'}, {'Code': 'MKD', 'Name': 'Macedonia', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('25713.00'), 'IndepYear': 1991, 'Population': 2024000, 'LifeExpectancy': Decimal('73.8'), 'GNP': Decimal('1694.00'), 'GNPOld': Decimal('1915.00'), 'LocalName': 'Makedonija', 'GovernmentForm': 'Republic', 'HeadOfState': 'Boris Trajkovski', 'Capital': 2460, 'Code2': 'MK'}, {'Code': 'MLI', 'Name': 'Mali', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('1240192.00'), 'IndepYear': 1960, 'Population': 11234000, 'LifeExpectancy': Decimal('46.7'), 'GNP': Decimal('2642.00'), 'GNPOld': Decimal('2453.00'), 'LocalName': 'Mali', 'GovernmentForm': 'Republic', 'HeadOfState': 'Alpha Oumar Konaré', 'Capital': 2482, 'Code2': 'ML'}, {'Code': 'MLT', 'Name': 'Malta', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('316.00'), 'IndepYear': 1964, 'Population': 380200, 'LifeExpectancy': Decimal('77.9'), 'GNP': Decimal('3512.00'), 'GNPOld': Decimal('3338.00'), 'LocalName': 'Malta', 'GovernmentForm': 'Republic', 'HeadOfState': 'Guido de Marco', 'Capital': 2484, 'Code2': 'MT'}, {'Code': 'MMR', 'Name': 'Myanmar', 'Continent': 'Asia', 'Region': 'Southeast Asia', 'SurfaceArea': Decimal('676578.00'), 'IndepYear': 1948, 'Population': 45611000, 'LifeExpectancy': Decimal('54.9'), 'GNP': Decimal('180375.00'), 'GNPOld': Decimal('171028.00'), 'LocalName': 'Myanma Pye', 'GovernmentForm': 'Republic', 'HeadOfState': 'kenraali Than Shwe', 'Capital': 2710, 'Code2': 'MM'}, {'Code': 'MNG', 'Name': 'Mongolia', 'Continent': 'Asia', 'Region': 'Eastern Asia', 'SurfaceArea': Decimal('1566500.00'), 'IndepYear': 1921, 'Population': 2662000, 'LifeExpectancy': Decimal('67.3'), 'GNP': Decimal('1043.00'), 'GNPOld': Decimal('933.00'), 'LocalName': 'Mongol Uls', 'GovernmentForm': 'Republic', 'HeadOfState': 'Natsagiin Bagabandi', 'Capital': 2696, 'Code2': 'MN'}, {'Code': 'MNP', 'Name': 'Northern Mariana Islands', 'Continent': 'Oceania', 'Region': 'Micronesia', 'SurfaceArea': Decimal('464.00'), 'IndepYear': None, 'Population': 78000, 'LifeExpectancy': Decimal('75.5'), 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Northern Mariana Islands', 'GovernmentForm': 'Commonwealth of the US', 'HeadOfState': 'George W. Bush', 'Capital': 2913, 'Code2': 'MP'}, {'Code': 'MOZ', 'Name': 'Mozambique', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('801590.00'), 'IndepYear': 1975, 'Population': 19680000, 'LifeExpectancy': Decimal('37.5'), 'GNP': Decimal('2891.00'), 'GNPOld': Decimal('2711.00'), 'LocalName': 'Moçambique', 'GovernmentForm': 'Republic', 'HeadOfState': 'Joaquím A. Chissano', 'Capital': 2698, 'Code2': 'MZ'}, {'Code': 'MRT', 'Name': 'Mauritania', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('1025520.00'), 'IndepYear': 1960, 'Population': 2670000, 'LifeExpectancy': Decimal('50.8'), 'GNP': Decimal('998.00'), 'GNPOld': Decimal('1081.00'), 'LocalName': 'Muritaniya/Mauritanie', 'GovernmentForm': 'Republic', 'HeadOfState': 'Maaouiya Ould Sid´Ahmad Taya', 'Capital': 2509, 'Code2': 'MR'}, {'Code': 'MSR', 'Name': 'Montserrat', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('102.00'), 'IndepYear': None, 'Population': 11000, 'LifeExpectancy': Decimal('78.0'), 'GNP': Decimal('109.00'), 'GNPOld': None, 'LocalName': 'Montserrat', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 2697, 'Code2': 'MS'}, {'Code': 'MTQ', 'Name': 'Martinique', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('1102.00'), 'IndepYear': None, 'Population': 395000, 'LifeExpectancy': Decimal('78.3'), 'GNP': Decimal('2731.00'), 'GNPOld': Decimal('2559.00'), 'LocalName': 'Martinique', 'GovernmentForm': 'Overseas Department of France', 'HeadOfState': 'Jacques Chirac', 'Capital': 2508, 'Code2': 'MQ'}, {'Code': 'MUS', 'Name': 'Mauritius', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('2040.00'), 'IndepYear': 1968, 'Population': 1158000, 'LifeExpectancy': Decimal('71.0'), 'GNP': Decimal('4251.00'), 'GNPOld': Decimal('4186.00'), 'LocalName': 'Mauritius', 'GovernmentForm': 'Republic', 'HeadOfState': 'Cassam Uteem', 'Capital': 2511, 'Code2': 'MU'}, {'Code': 'MWI', 'Name': 'Malawi', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('118484.00'), 'IndepYear': 1964, 'Population': 10925000, 'LifeExpectancy': Decimal('37.6'), 'GNP': Decimal('1687.00'), 'GNPOld': Decimal('2527.00'), 'LocalName': 'Malawi', 'GovernmentForm': 'Republic', 'HeadOfState': 'Bakili Muluzi', 'Capital': 2462, 'Code2': 'MW'}, {'Code': 'MYS', 'Name': 'Malaysia', 'Continent': 'Asia', 'Region': 'Southeast Asia', 'SurfaceArea': Decimal('329758.00'), 'IndepYear': 1957, 'Population': 22244000, 'LifeExpectancy': Decimal('70.8'), 'GNP': Decimal('69213.00'), 'GNPOld': Decimal('97884.00'), 'LocalName': 'Malaysia', 'GovernmentForm': 'Constitutional Monarchy, Federation', 'HeadOfState': 'Salahuddin Abdul Aziz Shah Alhaj', 'Capital': 2464, 'Code2': 'MY'}, {'Code': 'MYT', 'Name': 'Mayotte', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('373.00'), 'IndepYear': None, 'Population': 149000, 'LifeExpectancy': Decimal('59.5'), 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Mayotte', 'GovernmentForm': 'Territorial Collectivity of France', 'HeadOfState': 'Jacques Chirac', 'Capital': 2514, 'Code2': 'YT'}, {'Code': 'NAM', 'Name': 'Namibia', 'Continent': 'Africa', 'Region': 'Southern Africa', 'SurfaceArea': Decimal('824292.00'), 'IndepYear': 1990, 'Population': 1726000, 'LifeExpectancy': Decimal('42.5'), 'GNP': Decimal('3101.00'), 'GNPOld': Decimal('3384.00'), 'LocalName': 'Namibia', 'GovernmentForm': 'Republic', 'HeadOfState': 'Sam Nujoma', 'Capital': 2726, 'Code2': 'NA'}, {'Code': 'NCL', 'Name': 'New Caledonia', 'Continent': 'Oceania', 'Region': 'Melanesia', 'SurfaceArea': Decimal('18575.00'), 'IndepYear': None, 'Population': 214000, 'LifeExpectancy': Decimal('72.8'), 'GNP': Decimal('3563.00'), 'GNPOld': None, 'LocalName': 'Nouvelle-Calédonie', 'GovernmentForm': 'Nonmetropolitan Territory of France', 'HeadOfState': 'Jacques Chirac', 'Capital': 3493, 'Code2': 'NC'}, {'Code': 'NER', 'Name': 'Niger', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('1267000.00'), 'IndepYear': 1960, 'Population': 10730000, 'LifeExpectancy': Decimal('41.3'), 'GNP': Decimal('1706.00'), 'GNPOld': Decimal('1580.00'), 'LocalName': 'Niger', 'GovernmentForm': 'Republic', 'HeadOfState': 'Mamadou Tandja', 'Capital': 2738, 'Code2': 'NE'}, {'Code': 'NFK', 'Name': 'Norfolk Island', 'Continent': 'Oceania', 'Region': 'Australia and New Zealand', 'SurfaceArea': Decimal('36.00'), 'IndepYear': None, 'Population': 2000, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Norfolk Island', 'GovernmentForm': 'Territory of Australia', 'HeadOfState': 'Elisabeth II', 'Capital': 2806, 'Code2': 'NF'}, {'Code': 'NGA', 'Name': 'Nigeria', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('923768.00'), 'IndepYear': 1960, 'Population': 111506000, 'LifeExpectancy': Decimal('51.6'), 'GNP': Decimal('65707.00'), 'GNPOld': Decimal('58623.00'), 'LocalName': 'Nigeria', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Olusegun Obasanjo', 'Capital': 2754, 'Code2': 'NG'}, {'Code': 'NIC', 'Name': 'Nicaragua', 'Continent': 'North America', 'Region': 'Central America', 'SurfaceArea': Decimal('130000.00'), 'IndepYear': 1838, 'Population': 5074000, 'LifeExpectancy': Decimal('68.7'), 'GNP': Decimal('1988.00'), 'GNPOld': Decimal('2023.00'), 'LocalName': 'Nicaragua', 'GovernmentForm': 'Republic', 'HeadOfState': 'Arnoldo Alemán Lacayo', 'Capital': 2734, 'Code2': 'NI'}, {'Code': 'NIU', 'Name': 'Niue', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': Decimal('260.00'), 'IndepYear': None, 'Population': 2000, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Niue', 'GovernmentForm': 'Nonmetropolitan Territory of New Zealand', 'HeadOfState': 'Elisabeth II', 'Capital': 2805, 'Code2': 'NU'}, {'Code': 'NLD', 'Name': 'Netherlands', 'Continent': 'Europe', 'Region': 'Western Europe', 'SurfaceArea': Decimal('41526.00'), 'IndepYear': 1581, 'Population': 15864000, 'LifeExpectancy': Decimal('78.3'), 'GNP': Decimal('371362.00'), 'GNPOld': Decimal('360478.00'), 'LocalName': 'Nederland', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Beatrix', 'Capital': 5, 'Code2': 'NL'}, {'Code': 'NOR', 'Name': 'Norway', 'Continent': 'Europe', 'Region': 'Nordic Countries', 'SurfaceArea': Decimal('323877.00'), 'IndepYear': 1905, 'Population': 4478500, 'LifeExpectancy': Decimal('78.7'), 'GNP': Decimal('145895.00'), 'GNPOld': Decimal('153370.00'), 'LocalName': 'Norge', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Harald V', 'Capital': 2807, 'Code2': 'NO'}, {'Code': 'NPL', 'Name': 'Nepal', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('147181.00'), 'IndepYear': 1769, 'Population': 23930000, 'LifeExpectancy': Decimal('57.8'), 'GNP': Decimal('4768.00'), 'GNPOld': Decimal('4837.00'), 'LocalName': 'Nepal', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Gyanendra Bir Bikram', 'Capital': 2729, 'Code2': 'NP'}, {'Code': 'NRU', 'Name': 'Nauru', 'Continent': 'Oceania', 'Region': 'Micronesia', 'SurfaceArea': Decimal('21.00'), 'IndepYear': 1968, 'Population': 12000, 'LifeExpectancy': Decimal('60.8'), 'GNP': Decimal('197.00'), 'GNPOld': None, 'LocalName': 'Naoero/Nauru', 'GovernmentForm': 'Republic', 'HeadOfState': 'Bernard Dowiyogo', 'Capital': 2728, 'Code2': 'NR'}, {'Code': 'NZL', 'Name': 'New Zealand', 'Continent': 'Oceania', 'Region': 'Australia and New Zealand', 'SurfaceArea': Decimal('270534.00'), 'IndepYear': 1907, 'Population': 3862000, 'LifeExpectancy': Decimal('77.8'), 'GNP': Decimal('54669.00'), 'GNPOld': Decimal('64960.00'), 'LocalName': 'New Zealand/Aotearoa', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 3499, 'Code2': 'NZ'}, {'Code': 'OMN', 'Name': 'Oman', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('309500.00'), 'IndepYear': 1951, 'Population': 2542000, 'LifeExpectancy': Decimal('71.8'), 'GNP': Decimal('16904.00'), 'GNPOld': Decimal('16153.00'), 'LocalName': '´Uman', 'GovernmentForm': 'Monarchy (Sultanate)', 'HeadOfState': 'Qabus ibn Sa´id', 'Capital': 2821, 'Code2': 'OM'}, {'Code': 'PAK', 'Name': 'Pakistan', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('796095.00'), 'IndepYear': 1947, 'Population': 156483000, 'LifeExpectancy': Decimal('61.1'), 'GNP': Decimal('61289.00'), 'GNPOld': Decimal('58549.00'), 'LocalName': 'Pakistan', 'GovernmentForm': 'Republic', 'HeadOfState': 'Mohammad Rafiq Tarar', 'Capital': 2831, 'Code2': 'PK'}, {'Code': 'PAN', 'Name': 'Panama', 'Continent': 'North America', 'Region': 'Central America', 'SurfaceArea': Decimal('75517.00'), 'IndepYear': 1903, 'Population': 2856000, 'LifeExpectancy': Decimal('75.5'), 'GNP': Decimal('9131.00'), 'GNPOld': Decimal('8700.00'), 'LocalName': 'Panamá', 'GovernmentForm': 'Republic', 'HeadOfState': 'Mireya Elisa Moscoso Rodríguez', 'Capital': 2882, 'Code2': 'PA'}, {'Code': 'PCN', 'Name': 'Pitcairn', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': Decimal('49.00'), 'IndepYear': None, 'Population': 50, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Pitcairn', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 2912, 'Code2': 'PN'}, {'Code': 'PER', 'Name': 'Peru', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('1285216.00'), 'IndepYear': 1821, 'Population': 25662000, 'LifeExpectancy': Decimal('70.0'), 'GNP': Decimal('64140.00'), 'GNPOld': Decimal('65186.00'), 'LocalName': 'Perú/Piruw', 'GovernmentForm': 'Republic', 'HeadOfState': 'Valentin Paniagua Corazao', 'Capital': 2890, 'Code2': 'PE'}, {'Code': 'PHL', 'Name': 'Philippines', 'Continent': 'Asia', 'Region': 'Southeast Asia', 'SurfaceArea': Decimal('300000.00'), 'IndepYear': 1946, 'Population': 75967000, 'LifeExpectancy': Decimal('67.5'), 'GNP': Decimal('65107.00'), 'GNPOld': Decimal('82239.00'), 'LocalName': 'Pilipinas', 'GovernmentForm': 'Republic', 'HeadOfState': 'Gloria Macapagal-Arroyo', 'Capital': 766, 'Code2': 'PH'}, {'Code': 'PLW', 'Name': 'Palau', 'Continent': 'Oceania', 'Region': 'Micronesia', 'SurfaceArea': Decimal('459.00'), 'IndepYear': 1994, 'Population': 19000, 'LifeExpectancy': Decimal('68.6'), 'GNP': Decimal('105.00'), 'GNPOld': None, 'LocalName': 'Belau/Palau', 'GovernmentForm': 'Republic', 'HeadOfState': 'Kuniwo Nakamura', 'Capital': 2881, 'Code2': 'PW'}, {'Code': 'PNG', 'Name': 'Papua New Guinea', 'Continent': 'Oceania', 'Region': 'Melanesia', 'SurfaceArea': Decimal('462840.00'), 'IndepYear': 1975, 'Population': 4807000, 'LifeExpectancy': Decimal('63.1'), 'GNP': Decimal('4988.00'), 'GNPOld': Decimal('6328.00'), 'LocalName': 'Papua New Guinea/Papua Niugini', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 2884, 'Code2': 'PG'}, {'Code': 'POL', 'Name': 'Poland', 'Continent': 'Europe', 'Region': 'Eastern Europe', 'SurfaceArea': Decimal('323250.00'), 'IndepYear': 1918, 'Population': 38653600, 'LifeExpectancy': Decimal('73.2'), 'GNP': Decimal('151697.00'), 'GNPOld': Decimal('135636.00'), 'LocalName': 'Polska', 'GovernmentForm': 'Republic', 'HeadOfState': 'Aleksander Kwasniewski', 'Capital': 2928, 'Code2': 'PL'}, {'Code': 'PRI', 'Name': 'Puerto Rico', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('8875.00'), 'IndepYear': None, 'Population': 3869000, 'LifeExpectancy': Decimal('75.6'), 'GNP': Decimal('34100.00'), 'GNPOld': Decimal('32100.00'), 'LocalName': 'Puerto Rico', 'GovernmentForm': 'Commonwealth of the US', 'HeadOfState': 'George W. Bush', 'Capital': 2919, 'Code2': 'PR'}, {'Code': 'PRK', 'Name': 'North Korea', 'Continent': 'Asia', 'Region': 'Eastern Asia', 'SurfaceArea': Decimal('120538.00'), 'IndepYear': 1948, 'Population': 24039000, 'LifeExpectancy': Decimal('70.7'), 'GNP': Decimal('5332.00'), 'GNPOld': None, 'LocalName': 'Choson Minjujuui In´min Konghwaguk (Bukhan)', 'GovernmentForm': 'Socialistic Republic', 'HeadOfState': 'Kim Jong-il', 'Capital': 2318, 'Code2': 'KP'}, {'Code': 'PRT', 'Name': 'Portugal', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('91982.00'), 'IndepYear': 1143, 'Population': 9997600, 'LifeExpectancy': Decimal('75.8'), 'GNP': Decimal('105954.00'), 'GNPOld': Decimal('102133.00'), 'LocalName': 'Portugal', 'GovernmentForm': 'Republic', 'HeadOfState': 'Jorge Sampãio', 'Capital': 2914, 'Code2': 'PT'}, {'Code': 'PRY', 'Name': 'Paraguay', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('406752.00'), 'IndepYear': 1811, 'Population': 5496000, 'LifeExpectancy': Decimal('73.7'), 'GNP': Decimal('8444.00'), 'GNPOld': Decimal('9555.00'), 'LocalName': 'Paraguay', 'GovernmentForm': 'Republic', 'HeadOfState': 'Luis Ángel González Macchi', 'Capital': 2885, 'Code2': 'PY'}, {'Code': 'PSE', 'Name': 'Palestine', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('6257.00'), 'IndepYear': None, 'Population': 3101000, 'LifeExpectancy': Decimal('71.4'), 'GNP': Decimal('4173.00'), 'GNPOld': None, 'LocalName': 'Filastin', 'GovernmentForm': 'Autonomous Area', 'HeadOfState': 'Yasser (Yasir) Arafat', 'Capital': 4074, 'Code2': 'PS'}, {'Code': 'PYF', 'Name': 'French Polynesia', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': Decimal('4000.00'), 'IndepYear': None, 'Population': 235000, 'LifeExpectancy': Decimal('74.8'), 'GNP': Decimal('818.00'), 'GNPOld': Decimal('781.00'), 'LocalName': 'Polynésie française', 'GovernmentForm': 'Nonmetropolitan Territory of France', 'HeadOfState': 'Jacques Chirac', 'Capital': 3016, 'Code2': 'PF'}, {'Code': 'QAT', 'Name': 'Qatar', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('11000.00'), 'IndepYear': 1971, 'Population': 599000, 'LifeExpectancy': Decimal('72.4'), 'GNP': Decimal('9472.00'), 'GNPOld': Decimal('8920.00'), 'LocalName': 'Qatar', 'GovernmentForm': 'Monarchy', 'HeadOfState': 'Hamad ibn Khalifa al-Thani', 'Capital': 2973, 'Code2': 'QA'}, {'Code': 'REU', 'Name': 'Réunion', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('2510.00'), 'IndepYear': None, 'Population': 699000, 'LifeExpectancy': Decimal('72.7'), 'GNP': Decimal('8287.00'), 'GNPOld': Decimal('7988.00'), 'LocalName': 'Réunion', 'GovernmentForm': 'Overseas Department of France', 'HeadOfState': 'Jacques Chirac', 'Capital': 3017, 'Code2': 'RE'}, {'Code': 'ROM', 'Name': 'Romania', 'Continent': 'Europe', 'Region': 'Eastern Europe', 'SurfaceArea': Decimal('238391.00'), 'IndepYear': 1878, 'Population': 22455500, 'LifeExpectancy': Decimal('69.9'), 'GNP': Decimal('38158.00'), 'GNPOld': Decimal('34843.00'), 'LocalName': 'România', 'GovernmentForm': 'Republic', 'HeadOfState': 'Ion Iliescu', 'Capital': 3018, 'Code2': 'RO'}, {'Code': 'RUS', 'Name': 'Russian Federation', 'Continent': 'Europe', 'Region': 'Eastern Europe', 'SurfaceArea': Decimal('17075400.00'), 'IndepYear': 1991, 'Population': 146934000, 'LifeExpectancy': Decimal('67.2'), 'GNP': Decimal('276608.00'), 'GNPOld': Decimal('442989.00'), 'LocalName': 'Rossija', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Vladimir Putin', 'Capital': 3580, 'Code2': 'RU'}, {'Code': 'RWA', 'Name': 'Rwanda', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('26338.00'), 'IndepYear': 1962, 'Population': 7733000, 'LifeExpectancy': Decimal('39.3'), 'GNP': Decimal('2036.00'), 'GNPOld': Decimal('1863.00'), 'LocalName': 'Rwanda/Urwanda', 'GovernmentForm': 'Republic', 'HeadOfState': 'Paul Kagame', 'Capital': 3047, 'Code2': 'RW'}, {'Code': 'SAU', 'Name': 'Saudi Arabia', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('2149690.00'), 'IndepYear': 1932, 'Population': 21607000, 'LifeExpectancy': Decimal('67.8'), 'GNP': Decimal('137635.00'), 'GNPOld': Decimal('146171.00'), 'LocalName': 'Al-´Arabiya as-Sa´udiya', 'GovernmentForm': 'Monarchy', 'HeadOfState': 'Fahd ibn Abdul-Aziz al-Sa´ud', 'Capital': 3173, 'Code2': 'SA'}, {'Code': 'SDN', 'Name': 'Sudan', 'Continent': 'Africa', 'Region': 'Northern Africa', 'SurfaceArea': Decimal('2505813.00'), 'IndepYear': 1956, 'Population': 29490000, 'LifeExpectancy': Decimal('56.6'), 'GNP': Decimal('10162.00'), 'GNPOld': None, 'LocalName': 'As-Sudan', 'GovernmentForm': 'Islamic Republic', 'HeadOfState': 'Omar Hassan Ahmad al-Bashir', 'Capital': 3225, 'Code2': 'SD'}, {'Code': 'SEN', 'Name': 'Senegal', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('196722.00'), 'IndepYear': 1960, 'Population': 9481000, 'LifeExpectancy': Decimal('62.2'), 'GNP': Decimal('4787.00'), 'GNPOld': Decimal('4542.00'), 'LocalName': 'Sénégal/Sounougal', 'GovernmentForm': 'Republic', 'HeadOfState': 'Abdoulaye Wade', 'Capital': 3198, 'Code2': 'SN'}, {'Code': 'SGP', 'Name': 'Singapore', 'Continent': 'Asia', 'Region': 'Southeast Asia', 'SurfaceArea': Decimal('618.00'), 'IndepYear': 1965, 'Population': 3567000, 'LifeExpectancy': Decimal('80.1'), 'GNP': Decimal('86503.00'), 'GNPOld': Decimal('96318.00'), 'LocalName': 'Singapore/Singapura/Xinjiapo/Singapur', 'GovernmentForm': 'Republic', 'HeadOfState': 'Sellapan Rama Nathan', 'Capital': 3208, 'Code2': 'SG'}, {'Code': 'SGS', 'Name': 'South Georgia and the South Sandwich Islands', 'Continent': 'Antarctica', 'Region': 'Antarctica', 'SurfaceArea': Decimal('3903.00'), 'IndepYear': None, 'Population': 0, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'South Georgia and the South Sandwich Islands', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': None, 'Code2': 'GS'}, {'Code': 'SHN', 'Name': 'Saint Helena', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('314.00'), 'IndepYear': None, 'Population': 6000, 'LifeExpectancy': Decimal('76.8'), 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Saint Helena', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 3063, 'Code2': 'SH'}, {'Code': 'SJM', 'Name': 'Svalbard and Jan Mayen', 'Continent': 'Europe', 'Region': 'Nordic Countries', 'SurfaceArea': Decimal('62422.00'), 'IndepYear': None, 'Population': 3200, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Svalbard og Jan Mayen', 'GovernmentForm': 'Dependent Territory of Norway', 'HeadOfState': 'Harald V', 'Capital': 938, 'Code2': 'SJ'}, {'Code': 'SLB', 'Name': 'Solomon Islands', 'Continent': 'Oceania', 'Region': 'Melanesia', 'SurfaceArea': Decimal('28896.00'), 'IndepYear': 1978, 'Population': 444000, 'LifeExpectancy': Decimal('71.3'), 'GNP': Decimal('182.00'), 'GNPOld': Decimal('220.00'), 'LocalName': 'Solomon Islands', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 3161, 'Code2': 'SB'}, {'Code': 'SLE', 'Name': 'Sierra Leone', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('71740.00'), 'IndepYear': 1961, 'Population': 4854000, 'LifeExpectancy': Decimal('45.3'), 'GNP': Decimal('746.00'), 'GNPOld': Decimal('858.00'), 'LocalName': 'Sierra Leone', 'GovernmentForm': 'Republic', 'HeadOfState': 'Ahmed Tejan Kabbah', 'Capital': 3207, 'Code2': 'SL'}, {'Code': 'SLV', 'Name': 'El Salvador', 'Continent': 'North America', 'Region': 'Central America', 'SurfaceArea': Decimal('21041.00'), 'IndepYear': 1841, 'Population': 6276000, 'LifeExpectancy': Decimal('69.7'), 'GNP': Decimal('11863.00'), 'GNPOld': Decimal('11203.00'), 'LocalName': 'El Salvador', 'GovernmentForm': 'Republic', 'HeadOfState': 'Francisco Guillermo Flores Pérez', 'Capital': 645, 'Code2': 'SV'}, {'Code': 'SMR', 'Name': 'San Marino', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('61.00'), 'IndepYear': 885, 'Population': 27000, 'LifeExpectancy': Decimal('81.1'), 'GNP': Decimal('510.00'), 'GNPOld': None, 'LocalName': 'San Marino', 'GovernmentForm': 'Republic', 'HeadOfState': None, 'Capital': 3171, 'Code2': 'SM'}, {'Code': 'SOM', 'Name': 'Somalia', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('637657.00'), 'IndepYear': 1960, 'Population': 10097000, 'LifeExpectancy': Decimal('46.2'), 'GNP': Decimal('935.00'), 'GNPOld': None, 'LocalName': 'Soomaaliya', 'GovernmentForm': 'Republic', 'HeadOfState': 'Abdiqassim Salad Hassan', 'Capital': 3214, 'Code2': 'SO'}, {'Code': 'SPM', 'Name': 'Saint Pierre and Miquelon', 'Continent': 'North America', 'Region': 'North America', 'SurfaceArea': Decimal('242.00'), 'IndepYear': None, 'Population': 7000, 'LifeExpectancy': Decimal('77.6'), 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Saint-Pierre-et-Miquelon', 'GovernmentForm': 'Territorial Collectivity of France', 'HeadOfState': 'Jacques Chirac', 'Capital': 3067, 'Code2': 'PM'}, {'Code': 'STP', 'Name': 'Sao Tome and Principe', 'Continent': 'Africa', 'Region': 'Central Africa', 'SurfaceArea': Decimal('964.00'), 'IndepYear': 1975, 'Population': 147000, 'LifeExpectancy': Decimal('65.3'), 'GNP': Decimal('6.00'), 'GNPOld': None, 'LocalName': 'São Tomé e Príncipe', 'GovernmentForm': 'Republic', 'HeadOfState': 'Miguel Trovoada', 'Capital': 3172, 'Code2': 'ST'}, {'Code': 'SUR', 'Name': 'Suriname', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('163265.00'), 'IndepYear': 1975, 'Population': 417000, 'LifeExpectancy': Decimal('71.4'), 'GNP': Decimal('870.00'), 'GNPOld': Decimal('706.00'), 'LocalName': 'Suriname', 'GovernmentForm': 'Republic', 'HeadOfState': 'Ronald Venetiaan', 'Capital': 3243, 'Code2': 'SR'}, {'Code': 'SVK', 'Name': 'Slovakia', 'Continent': 'Europe', 'Region': 'Eastern Europe', 'SurfaceArea': Decimal('49012.00'), 'IndepYear': 1993, 'Population': 5398700, 'LifeExpectancy': Decimal('73.7'), 'GNP': Decimal('20594.00'), 'GNPOld': Decimal('19452.00'), 'LocalName': 'Slovensko', 'GovernmentForm': 'Republic', 'HeadOfState': 'Rudolf Schuster', 'Capital': 3209, 'Code2': 'SK'}, {'Code': 'SVN', 'Name': 'Slovenia', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('20256.00'), 'IndepYear': 1991, 'Population': 1987800, 'LifeExpectancy': Decimal('74.9'), 'GNP': Decimal('19756.00'), 'GNPOld': Decimal('18202.00'), 'LocalName': 'Slovenija', 'GovernmentForm': 'Republic', 'HeadOfState': 'Milan Kucan', 'Capital': 3212, 'Code2': 'SI'}, {'Code': 'SWE', 'Name': 'Sweden', 'Continent': 'Europe', 'Region': 'Nordic Countries', 'SurfaceArea': Decimal('449964.00'), 'IndepYear': 836, 'Population': 8861400, 'LifeExpectancy': Decimal('79.6'), 'GNP': Decimal('226492.00'), 'GNPOld': Decimal('227757.00'), 'LocalName': 'Sverige', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Carl XVI Gustaf', 'Capital': 3048, 'Code2': 'SE'}, {'Code': 'SWZ', 'Name': 'Swaziland', 'Continent': 'Africa', 'Region': 'Southern Africa', 'SurfaceArea': Decimal('17364.00'), 'IndepYear': 1968, 'Population': 1008000, 'LifeExpectancy': Decimal('40.4'), 'GNP': Decimal('1206.00'), 'GNPOld': Decimal('1312.00'), 'LocalName': 'kaNgwane', 'GovernmentForm': 'Monarchy', 'HeadOfState': 'Mswati III', 'Capital': 3244, 'Code2': 'SZ'}, {'Code': 'SYC', 'Name': 'Seychelles', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('455.00'), 'IndepYear': 1976, 'Population': 77000, 'LifeExpectancy': Decimal('70.4'), 'GNP': Decimal('536.00'), 'GNPOld': Decimal('539.00'), 'LocalName': 'Sesel/Seychelles', 'GovernmentForm': 'Republic', 'HeadOfState': 'France-Albert René', 'Capital': 3206, 'Code2': 'SC'}, {'Code': 'SYR', 'Name': 'Syria', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('185180.00'), 'IndepYear': 1941, 'Population': 16125000, 'LifeExpectancy': Decimal('68.5'), 'GNP': Decimal('65984.00'), 'GNPOld': Decimal('64926.00'), 'LocalName': 'Suriya', 'GovernmentForm': 'Republic', 'HeadOfState': 'Bashar al-Assad', 'Capital': 3250, 'Code2': 'SY'}, {'Code': 'TCA', 'Name': 'Turks and Caicos Islands', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('430.00'), 'IndepYear': None, 'Population': 17000, 'LifeExpectancy': Decimal('73.3'), 'GNP': Decimal('96.00'), 'GNPOld': None, 'LocalName': 'The Turks and Caicos Islands', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 3423, 'Code2': 'TC'}, {'Code': 'TCD', 'Name': 'Chad', 'Continent': 'Africa', 'Region': 'Central Africa', 'SurfaceArea': Decimal('1284000.00'), 'IndepYear': 1960, 'Population': 7651000, 'LifeExpectancy': Decimal('50.5'), 'GNP': Decimal('1208.00'), 'GNPOld': Decimal('1102.00'), 'LocalName': 'Tchad/Tshad', 'GovernmentForm': 'Republic', 'HeadOfState': 'Idriss Déby', 'Capital': 3337, 'Code2': 'TD'}, {'Code': 'TGO', 'Name': 'Togo', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': Decimal('56785.00'), 'IndepYear': 1960, 'Population': 4629000, 'LifeExpectancy': Decimal('54.7'), 'GNP': Decimal('1449.00'), 'GNPOld': Decimal('1400.00'), 'LocalName': 'Togo', 'GovernmentForm': 'Republic', 'HeadOfState': 'Gnassingbé Eyadéma', 'Capital': 3332, 'Code2': 'TG'}, {'Code': 'THA', 'Name': 'Thailand', 'Continent': 'Asia', 'Region': 'Southeast Asia', 'SurfaceArea': Decimal('513115.00'), 'IndepYear': 1350, 'Population': 61399000, 'LifeExpectancy': Decimal('68.6'), 'GNP': Decimal('116416.00'), 'GNPOld': Decimal('153907.00'), 'LocalName': 'Prathet Thai', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Bhumibol Adulyadej', 'Capital': 3320, 'Code2': 'TH'}, {'Code': 'TJK', 'Name': 'Tajikistan', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('143100.00'), 'IndepYear': 1991, 'Population': 6188000, 'LifeExpectancy': Decimal('64.1'), 'GNP': Decimal('1990.00'), 'GNPOld': Decimal('1056.00'), 'LocalName': 'Toçikiston', 'GovernmentForm': 'Republic', 'HeadOfState': 'Emomali Rahmonov', 'Capital': 3261, 'Code2': 'TJ'}, {'Code': 'TKL', 'Name': 'Tokelau', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': Decimal('12.00'), 'IndepYear': None, 'Population': 2000, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Tokelau', 'GovernmentForm': 'Nonmetropolitan Territory of New Zealand', 'HeadOfState': 'Elisabeth II', 'Capital': 3333, 'Code2': 'TK'}, {'Code': 'TKM', 'Name': 'Turkmenistan', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('488100.00'), 'IndepYear': 1991, 'Population': 4459000, 'LifeExpectancy': Decimal('60.9'), 'GNP': Decimal('4397.00'), 'GNPOld': Decimal('2000.00'), 'LocalName': 'Türkmenostan', 'GovernmentForm': 'Republic', 'HeadOfState': 'Saparmurad Nijazov', 'Capital': 3419, 'Code2': 'TM'}, {'Code': 'TMP', 'Name': 'East Timor', 'Continent': 'Asia', 'Region': 'Southeast Asia', 'SurfaceArea': Decimal('14874.00'), 'IndepYear': None, 'Population': 885000, 'LifeExpectancy': Decimal('46.0'), 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Timor Timur', 'GovernmentForm': 'Administrated by the UN', 'HeadOfState': 'José Alexandre Gusmão', 'Capital': 1522, 'Code2': 'TP'}, {'Code': 'TON', 'Name': 'Tonga', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': Decimal('650.00'), 'IndepYear': 1970, 'Population': 99000, 'LifeExpectancy': Decimal('67.9'), 'GNP': Decimal('146.00'), 'GNPOld': Decimal('170.00'), 'LocalName': 'Tonga', 'GovernmentForm': 'Monarchy', 'HeadOfState': "Taufa'ahau Tupou IV", 'Capital': 3334, 'Code2': 'TO'}, {'Code': 'TTO', 'Name': 'Trinidad and Tobago', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('5130.00'), 'IndepYear': 1962, 'Population': 1295000, 'LifeExpectancy': Decimal('68.0'), 'GNP': Decimal('6232.00'), 'GNPOld': Decimal('5867.00'), 'LocalName': 'Trinidad and Tobago', 'GovernmentForm': 'Republic', 'HeadOfState': 'Arthur N. R. Robinson', 'Capital': 3336, 'Code2': 'TT'}, {'Code': 'TUN', 'Name': 'Tunisia', 'Continent': 'Africa', 'Region': 'Northern Africa', 'SurfaceArea': Decimal('163610.00'), 'IndepYear': 1956, 'Population': 9586000, 'LifeExpectancy': Decimal('73.7'), 'GNP': Decimal('20026.00'), 'GNPOld': Decimal('18898.00'), 'LocalName': 'Tunis/Tunisie', 'GovernmentForm': 'Republic', 'HeadOfState': 'Zine al-Abidine Ben Ali', 'Capital': 3349, 'Code2': 'TN'}, {'Code': 'TUR', 'Name': 'Turkey', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('774815.00'), 'IndepYear': 1923, 'Population': 66591000, 'LifeExpectancy': Decimal('71.0'), 'GNP': Decimal('210721.00'), 'GNPOld': Decimal('189122.00'), 'LocalName': 'Türkiye', 'GovernmentForm': 'Republic', 'HeadOfState': 'Ahmet Necdet Sezer', 'Capital': 3358, 'Code2': 'TR'}, {'Code': 'TUV', 'Name': 'Tuvalu', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': Decimal('26.00'), 'IndepYear': 1978, 'Population': 12000, 'LifeExpectancy': Decimal('66.3'), 'GNP': Decimal('6.00'), 'GNPOld': None, 'LocalName': 'Tuvalu', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 3424, 'Code2': 'TV'}, {'Code': 'TWN', 'Name': 'Taiwan', 'Continent': 'Asia', 'Region': 'Eastern Asia', 'SurfaceArea': Decimal('36188.00'), 'IndepYear': 1945, 'Population': 22256000, 'LifeExpectancy': Decimal('76.4'), 'GNP': Decimal('256254.00'), 'GNPOld': Decimal('263451.00'), 'LocalName': 'T’ai-wan', 'GovernmentForm': 'Republic', 'HeadOfState': 'Chen Shui-bian', 'Capital': 3263, 'Code2': 'TW'}, {'Code': 'TZA', 'Name': 'Tanzania', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('883749.00'), 'IndepYear': 1961, 'Population': 33517000, 'LifeExpectancy': Decimal('52.3'), 'GNP': Decimal('8005.00'), 'GNPOld': Decimal('7388.00'), 'LocalName': 'Tanzania', 'GovernmentForm': 'Republic', 'HeadOfState': 'Benjamin William Mkapa', 'Capital': 3306, 'Code2': 'TZ'}, {'Code': 'UGA', 'Name': 'Uganda', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('241038.00'), 'IndepYear': 1962, 'Population': 21778000, 'LifeExpectancy': Decimal('42.9'), 'GNP': Decimal('6313.00'), 'GNPOld': Decimal('6887.00'), 'LocalName': 'Uganda', 'GovernmentForm': 'Republic', 'HeadOfState': 'Yoweri Museveni', 'Capital': 3425, 'Code2': 'UG'}, {'Code': 'UKR', 'Name': 'Ukraine', 'Continent': 'Europe', 'Region': 'Eastern Europe', 'SurfaceArea': Decimal('603700.00'), 'IndepYear': 1991, 'Population': 50456000, 'LifeExpectancy': Decimal('66.0'), 'GNP': Decimal('42168.00'), 'GNPOld': Decimal('49677.00'), 'LocalName': 'Ukrajina', 'GovernmentForm': 'Republic', 'HeadOfState': 'Leonid Kutšma', 'Capital': 3426, 'Code2': 'UA'}, {'Code': 'UMI', 'Name': 'United States Minor Outlying Islands', 'Continent': 'Oceania', 'Region': 'Micronesia/Caribbean', 'SurfaceArea': Decimal('16.00'), 'IndepYear': None, 'Population': 0, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'United States Minor Outlying Islands', 'GovernmentForm': 'Dependent Territory of the US', 'HeadOfState': 'George W. Bush', 'Capital': None, 'Code2': 'UM'}, {'Code': 'URY', 'Name': 'Uruguay', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('175016.00'), 'IndepYear': 1828, 'Population': 3337000, 'LifeExpectancy': Decimal('75.2'), 'GNP': Decimal('20831.00'), 'GNPOld': Decimal('19967.00'), 'LocalName': 'Uruguay', 'GovernmentForm': 'Republic', 'HeadOfState': 'Jorge Batlle Ibáñez', 'Capital': 3492, 'Code2': 'UY'}, {'Code': 'USA', 'Name': 'United States', 'Continent': 'North America', 'Region': 'North America', 'SurfaceArea': Decimal('9363520.00'), 'IndepYear': 1776, 'Population': 278357000, 'LifeExpectancy': Decimal('77.1'), 'GNP': Decimal('8510700.00'), 'GNPOld': Decimal('8110900.00'), 'LocalName': 'United States', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'George W. Bush', 'Capital': 3813, 'Code2': 'US'}, {'Code': 'UZB', 'Name': 'Uzbekistan', 'Continent': 'Asia', 'Region': 'Southern and Central Asia', 'SurfaceArea': Decimal('447400.00'), 'IndepYear': 1991, 'Population': 24318000, 'LifeExpectancy': Decimal('63.7'), 'GNP': Decimal('14194.00'), 'GNPOld': Decimal('21300.00'), 'LocalName': 'Uzbekiston', 'GovernmentForm': 'Republic', 'HeadOfState': 'Islam Karimov', 'Capital': 3503, 'Code2': 'UZ'}, {'Code': 'VAT', 'Name': 'Holy See (Vatican City State)', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('0.40'), 'IndepYear': 1929, 'Population': 1000, 'LifeExpectancy': None, 'GNP': Decimal('9.00'), 'GNPOld': None, 'LocalName': 'Santa Sede/Città del Vaticano', 'GovernmentForm': 'Independent Church State', 'HeadOfState': 'Johannes Paavali II', 'Capital': 3538, 'Code2': 'VA'}, {'Code': 'VCT', 'Name': 'Saint Vincent and the Grenadines', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('388.00'), 'IndepYear': 1979, 'Population': 114000, 'LifeExpectancy': Decimal('72.3'), 'GNP': Decimal('285.00'), 'GNPOld': None, 'LocalName': 'Saint Vincent and the Grenadines', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 3066, 'Code2': 'VC'}, {'Code': 'VEN', 'Name': 'Venezuela', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': Decimal('912050.00'), 'IndepYear': 1811, 'Population': 24170000, 'LifeExpectancy': Decimal('73.1'), 'GNP': Decimal('95023.00'), 'GNPOld': Decimal('88434.00'), 'LocalName': 'Venezuela', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Hugo Chávez Frías', 'Capital': 3539, 'Code2': 'VE'}, {'Code': 'VGB', 'Name': 'Virgin Islands, British', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('151.00'), 'IndepYear': None, 'Population': 21000, 'LifeExpectancy': Decimal('75.4'), 'GNP': Decimal('612.00'), 'GNPOld': Decimal('573.00'), 'LocalName': 'British Virgin Islands', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 537, 'Code2': 'VG'}, {'Code': 'VIR', 'Name': 'Virgin Islands, U.S.', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': Decimal('347.00'), 'IndepYear': None, 'Population': 93000, 'LifeExpectancy': Decimal('78.1'), 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Virgin Islands of the United States', 'GovernmentForm': 'US Territory', 'HeadOfState': 'George W. Bush', 'Capital': 4067, 'Code2': 'VI'}, {'Code': 'VNM', 'Name': 'Vietnam', 'Continent': 'Asia', 'Region': 'Southeast Asia', 'SurfaceArea': Decimal('331689.00'), 'IndepYear': 1945, 'Population': 79832000, 'LifeExpectancy': Decimal('69.3'), 'GNP': Decimal('21929.00'), 'GNPOld': Decimal('22834.00'), 'LocalName': 'Viêt Nam', 'GovernmentForm': 'Socialistic Republic', 'HeadOfState': 'Trân Duc Luong', 'Capital': 3770, 'Code2': 'VN'}, {'Code': 'VUT', 'Name': 'Vanuatu', 'Continent': 'Oceania', 'Region': 'Melanesia', 'SurfaceArea': Decimal('12189.00'), 'IndepYear': 1980, 'Population': 190000, 'LifeExpectancy': Decimal('60.6'), 'GNP': Decimal('261.00'), 'GNPOld': Decimal('246.00'), 'LocalName': 'Vanuatu', 'GovernmentForm': 'Republic', 'HeadOfState': 'John Bani', 'Capital': 3537, 'Code2': 'VU'}, {'Code': 'WLF', 'Name': 'Wallis and Futuna', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': Decimal('200.00'), 'IndepYear': None, 'Population': 15000, 'LifeExpectancy': None, 'GNP': Decimal('0.00'), 'GNPOld': None, 'LocalName': 'Wallis-et-Futuna', 'GovernmentForm': 'Nonmetropolitan Territory of France', 'HeadOfState': 'Jacques Chirac', 'Capital': 3536, 'Code2': 'WF'}, {'Code': 'WSM', 'Name': 'Samoa', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': Decimal('2831.00'), 'IndepYear': 1962, 'Population': 180000, 'LifeExpectancy': Decimal('69.2'), 'GNP': Decimal('141.00'), 'GNPOld': Decimal('157.00'), 'LocalName': 'Samoa', 'GovernmentForm': 'Parlementary Monarchy', 'HeadOfState': 'Malietoa Tanumafili II', 'Capital': 3169, 'Code2': 'WS'}, {'Code': 'YEM', 'Name': 'Yemen', 'Continent': 'Asia', 'Region': 'Middle East', 'SurfaceArea': Decimal('527968.00'), 'IndepYear': 1918, 'Population': 18112000, 'LifeExpectancy': Decimal('59.8'), 'GNP': Decimal('6041.00'), 'GNPOld': Decimal('5729.00'), 'LocalName': 'Al-Yaman', 'GovernmentForm': 'Republic', 'HeadOfState': 'Ali Abdallah Salih', 'Capital': 1780, 'Code2': 'YE'}, {'Code': 'YUG', 'Name': 'Yugoslavia', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': Decimal('102173.00'), 'IndepYear': 1918, 'Population': 10640000, 'LifeExpectancy': Decimal('72.4'), 'GNP': Decimal('17000.00'), 'GNPOld': None, 'LocalName': 'Jugoslavija', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'Vojislav Koštunica', 'Capital': 1792, 'Code2': 'YU'}, {'Code': 'ZAF', 'Name': 'South Africa', 'Continent': 'Africa', 'Region': 'Southern Africa', 'SurfaceArea': Decimal('1221037.00'), 'IndepYear': 1910, 'Population': 40377000, 'LifeExpectancy': Decimal('51.1'), 'GNP': Decimal('116729.00'), 'GNPOld': Decimal('129092.00'), 'LocalName': 'South Africa', 'GovernmentForm': 'Republic', 'HeadOfState': 'Thabo Mbeki', 'Capital': 716, 'Code2': 'ZA'}, {'Code': 'ZMB', 'Name': 'Zambia', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('752618.00'), 'IndepYear': 1964, 'Population': 9169000, 'LifeExpectancy': Decimal('37.2'), 'GNP': Decimal('3377.00'), 'GNPOld': Decimal('3922.00'), 'LocalName': 'Zambia', 'GovernmentForm': 'Republic', 'HeadOfState': 'Frederick Chiluba', 'Capital': 3162, 'Code2': 'ZM'}, {'Code': 'ZWE', 'Name': 'Zimbabwe', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': Decimal('390757.00'), 'IndepYear': 1980, 'Population': 11669000, 'LifeExpectancy': Decimal('37.8'), 'GNP': Decimal('5951.00'), 'GNPOld': Decimal('8670.00'), 'LocalName': 'Zimbabwe', 'GovernmentForm': 'Republic', 'HeadOfState': 'Robert G. Mugabe', 'Capital': 4068, 'Code2': 'ZW'}]
In [37]:
cursor.execute("SELECT Code, Name FROM country")
df_countries = pd.DataFrame(cursor.fetchall())
cursor.execute("SELECT CountryCode, Language FROM countrylanguage WHERE Language='English' AND IsOfficial='T'")
df_languages = pd.DataFrame(cursor.fetchall())
df = df_countries.merge(df_languages,left_on='Code',right_on='CountryCode')
english_countries = list(df['Name'].sort_values().unique())
english_countries
Out[37]:
['American Samoa', 'Anguilla', 'Antigua and Barbuda', 'Australia', 'Barbados', 'Belize', 'Bermuda', 'Canada', 'Cayman Islands', 'Christmas Island', 'Cocos (Keeling) Islands', 'Falkland Islands', 'Gibraltar', 'Guam', 'Hong Kong', 'Ireland', 'Lesotho', 'Malta', 'Marshall Islands', 'Montserrat', 'Nauru', 'New Zealand', 'Niue', 'Norfolk Island', 'Northern Mariana Islands', 'Palau', 'Saint Helena', 'Saint Kitts and Nevis', 'Saint Lucia', 'Saint Vincent and the Grenadines', 'Samoa', 'Seychelles', 'South Africa', 'Tokelau', 'Tonga', 'Turks and Caicos Islands', 'Tuvalu', 'United Kingdom', 'United States', 'United States Minor Outlying Islands', 'Vanuatu', 'Virgin Islands, British', 'Virgin Islands, U.S.', 'Zimbabwe']
Activity 6: Find the cities with population greater than 5 million.¶
In [44]:
cursor.execute("SELECT name, population FROM city WHERE Population>5000000")
cities_population = cursor.fetchall()
cities_population
Out[44]:
[{'name': 'São Paulo', 'population': 9968485}, {'name': 'Rio de Janeiro', 'population': 5598953}, {'name': 'London', 'population': 7285000}, {'name': 'Cairo', 'population': 6789479}, {'name': 'Jakarta', 'population': 9604900}, {'name': 'Mumbai (Bombay)', 'population': 10500000}, {'name': 'Delhi', 'population': 7206704}, {'name': 'Teheran', 'population': 6758845}, {'name': 'Tokyo', 'population': 7980230}, {'name': 'Shanghai', 'population': 9696300}, {'name': 'Peking', 'population': 7472000}, {'name': 'Chongqing', 'population': 6351600}, {'name': 'Tianjin', 'population': 5286800}, {'name': 'Santafé de Bogotá', 'population': 6260862}, {'name': 'Kinshasa', 'population': 5064000}, {'name': 'Seoul', 'population': 9981619}, {'name': 'Ciudad de México', 'population': 8591309}, {'name': 'Karachi', 'population': 9269265}, {'name': 'Lahore', 'population': 5063499}, {'name': 'Lima', 'population': 6464693}, {'name': 'Bangkok', 'population': 6320174}, {'name': 'Istanbul', 'population': 8787958}, {'name': 'Moscow', 'population': 8389200}, {'name': 'New York', 'population': 8008278}]
Activity 7: Find all the official languages spoken.¶
In [58]:
cursor.execute("SELECT language FROM countrylanguage WHERE IsOfficial='T'")
official_languages = cursor.fetchall()
official_languages = list(set([language['language'] for language in official_languages]))
official_languages.sort()
Activity 8: Find the countries from the continent Asia
.¶
In [64]:
cursor.execute("SELECT name FROM country WHERE continent='Asia' ORDER BY name")
asia_countries = cursor.fetchall()
Activity 9: Find the countries where GNPOld
is not equal to NULL
.¶
In [66]:
cursor.execute("SELECT name, region, gnpold FROM country WHERE gnpold IS NOT NULL")
gnp_countries= cursor.fetchall()
Activity 10: Find the countries where local name is not equal to the name of the country.¶
In [8]:
curso
local_name_countries = ...