
CREATE TABLE city (
	"ID" INTEGER NOT NULL, 
	"Name" CHAR(35) DEFAULT '' NOT NULL, 
	"CountryCode" CHAR(3) DEFAULT '' NOT NULL, 
	"District" CHAR(20) DEFAULT '' NOT NULL, 
	"Population" INTEGER DEFAULT '0' NOT NULL, 
	PRIMARY KEY ("ID"), 
	FOREIGN KEY("CountryCode") REFERENCES country ("Code")
)


CREATE TABLE country (
	"Code" CHAR(3) DEFAULT '' NOT NULL, 
	"Name" CHAR(52) DEFAULT '' NOT NULL, 
	"Continent" TEXT DEFAULT 'Asia' NOT NULL, 
	"Region" CHAR(26) DEFAULT '' NOT NULL, 
	"SurfaceArea" FLOAT DEFAULT '0.00' NOT NULL, 
	"IndepYear" INTEGER DEFAULT NULL, 
	"Population" INTEGER DEFAULT '0' NOT NULL, 
	"LifeExpectancy" FLOAT DEFAULT NULL, 
	"GNP" FLOAT DEFAULT NULL, 
	"GNPOld" FLOAT DEFAULT NULL, 
	"LocalName" CHAR(45) DEFAULT '' NOT NULL, 
	"GovernmentForm" CHAR(45) DEFAULT '' NOT NULL, 
	"HeadOfState" CHAR(60) DEFAULT NULL, 
	"Capital" INTEGER DEFAULT NULL, 
	"Code2" CHAR(2) DEFAULT '' NOT NULL, 
	PRIMARY KEY ("Code")
)


CREATE TABLE countrylanguage (
	"CountryCode" CHAR(3) DEFAULT '' NOT NULL, 
	"Language" CHAR(30) DEFAULT '' NOT NULL, 
	"IsOfficial" TEXT DEFAULT 'F' NOT NULL, 
	"Percentage" FLOAT DEFAULT '0.0' NOT NULL, 
	PRIMARY KEY ("CountryCode", "Language"), 
	FOREIGN KEY("CountryCode") REFERENCES country ("Code")
)

CREATE TABLE city (
	"ID" INTEGER NOT NULL, 
	"Name" CHAR(35) DEFAULT '' NOT NULL, 
	"CountryCode" CHAR(3) DEFAULT '' NOT NULL, 
	"District" CHAR(20) DEFAULT '' NOT NULL, 
	"Population" INTEGER DEFAULT '0' NOT NULL, 
	PRIMARY KEY ("ID"), 
	FOREIGN KEY("CountryCode") REFERENCES country ("Code")
)

/*
2 rows from city table:
ID	Name	CountryCode	District	Population
1	Kabul	AFG	Kabol	1780000
2	Qandahar	AFG	Qandahar	237500
*/


CREATE TABLE country (
	"Code" CHAR(3) DEFAULT '' NOT NULL, 
	"Name" CHAR(52) DEFAULT '' NOT NULL, 
	"Continent" TEXT DEFAULT 'Asia' NOT NULL, 
	"Region" CHAR(26) DEFAULT '' NOT NULL, 
	"SurfaceArea" FLOAT DEFAULT '0.00' NOT NULL, 
	"IndepYear" INTEGER DEFAULT NULL, 
	"Population" INTEGER DEFAULT '0' NOT NULL, 
	"LifeExpectancy" FLOAT DEFAULT NULL, 
	"GNP" FLOAT DEFAULT NULL, 
	"GNPOld" FLOAT DEFAULT NULL, 
	"LocalName" CHAR(45) DEFAULT '' NOT NULL, 
	"GovernmentForm" CHAR(45) DEFAULT '' NOT NULL, 
	"HeadOfState" CHAR(60) DEFAULT NULL, 
	"Capital" INTEGER DEFAULT NULL, 
	"Code2" CHAR(2) DEFAULT '' NOT NULL, 
	PRIMARY KEY ("Code")
)

/*
2 rows from country table:
Code	Name	Continent	Region	SurfaceArea	IndepYear	Population	LifeExpectancy	GNP	GNPOld	LocalName	GovernmentForm	HeadOfState	Capital	Code2
ABW	Aruba	North America	Caribbean	193.0000000000	None	103000	78.4000000000	828.0000000000	793.0000000000	Aruba	Nonmetropolitan Territory of The Netherlands	Beatrix	129	AW
AFG	Afghanistan	Asia	Southern and Central Asia	652090.0000000000	1919	22720000	45.9000000000	5976.0000000000	None	Afganistan/Afqanestan	Islamic Emirate	Mohammad Omar	1	AF
*/


CREATE TABLE countrylanguage (
	"CountryCode" CHAR(3) DEFAULT '' NOT NULL, 
	"Language" CHAR(30) DEFAULT '' NOT NULL, 
	"IsOfficial" TEXT DEFAULT 'F' NOT NULL, 
	"Percentage" FLOAT DEFAULT '0.0' NOT NULL, 
	PRIMARY KEY ("CountryCode", "Language"), 
	FOREIGN KEY("CountryCode") REFERENCES country ("Code")
)

/*
2 rows from countrylanguage table:
CountryCode	Language	IsOfficial	Percentage
ABW	Dutch	T	5.3000000000
ABW	English	F	9.5000000000
*/
Which countries have either English or Dutch as an official language?
SELECT * FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode WHERE T2.Language  =  "English" AND IsOfficial  =  "T" UNION SELECT * FROM country AS T1 JOIN countrylanguage AS T2 ON T1.Code  =  T2.CountryCode WHERE T2.Language  =  "Dutch" AND IsOfficial  =  "T"
[{'Code': 'ABW', 'Name': 'Aruba', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 193.0, 'IndepYear': None, 'Population': 103000, 'LifeExpectancy': 78.4, 'GNP': 828.0, 'GNPOld': 793.0, 'LocalName': 'Aruba', 'GovernmentForm': 'Nonmetropolitan Territory of The Netherlands', 'HeadOfState': 'Beatrix', 'Capital': 129, 'Code2': 'AW', 'CountryCode': 'ABW', 'Language': 'Dutch', 'IsOfficial': 'T', 'Percentage': 5.3}, {'Code': 'AIA', 'Name': 'Anguilla', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 96.0, 'IndepYear': None, 'Population': 8000, 'LifeExpectancy': 76.1, 'GNP': 63.2, 'GNPOld': None, 'LocalName': 'Anguilla', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 62, 'Code2': 'AI', 'CountryCode': 'AIA', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'ANT', 'Name': 'Netherlands Antilles', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 800.0, 'IndepYear': None, 'Population': 217000, 'LifeExpectancy': 74.7, 'GNP': 1941.0, 'GNPOld': None, 'LocalName': 'Nederlandse Antillen', 'GovernmentForm': 'Nonmetropolitan Territory of The Netherlands', 'HeadOfState': 'Beatrix', 'Capital': 33, 'Code2': 'AN', 'CountryCode': 'ANT', 'Language': 'Dutch', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'ASM', 'Name': 'American Samoa', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': 199.0, 'IndepYear': None, 'Population': 68000, 'LifeExpectancy': 75.1, 'GNP': 334.0, 'GNPOld': None, 'LocalName': 'Amerika Samoa', 'GovernmentForm': 'US Territory', 'HeadOfState': 'George W. Bush', 'Capital': 54, 'Code2': 'AS', 'CountryCode': 'ASM', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 3.1}, {'Code': 'ATG', 'Name': 'Antigua and Barbuda', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 442.0, 'IndepYear': 1981, 'Population': 68000, 'LifeExpectancy': 70.5, 'GNP': 612.0, 'GNPOld': 584.0, 'LocalName': 'Antigua and Barbuda', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 63, 'Code2': 'AG', 'CountryCode': 'ATG', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'AUS', 'Name': 'Australia', 'Continent': 'Oceania', 'Region': 'Australia and New Zealand', 'SurfaceArea': 7741220.0, 'IndepYear': 1901, 'Population': 18886000, 'LifeExpectancy': 79.8, 'GNP': 351182.0, 'GNPOld': 392911.0, 'LocalName': 'Australia', 'GovernmentForm': 'Constitutional Monarchy, Federation', 'HeadOfState': 'Elisabeth II', 'Capital': 135, 'Code2': 'AU', 'CountryCode': 'AUS', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 81.2}, {'Code': 'BEL', 'Name': 'Belgium', 'Continent': 'Europe', 'Region': 'Western Europe', 'SurfaceArea': 30518.0, 'IndepYear': 1830, 'Population': 10239000, 'LifeExpectancy': 77.8, 'GNP': 249704.0, 'GNPOld': 243948.0, 'LocalName': 'België/Belgique', 'GovernmentForm': 'Constitutional Monarchy, Federation', 'HeadOfState': 'Albert II', 'Capital': 179, 'Code2': 'BE', 'CountryCode': 'BEL', 'Language': 'Dutch', 'IsOfficial': 'T', 'Percentage': 59.2}, {'Code': 'BLZ', 'Name': 'Belize', 'Continent': 'North America', 'Region': 'Central America', 'SurfaceArea': 22696.0, 'IndepYear': 1981, 'Population': 241000, 'LifeExpectancy': 70.9, 'GNP': 630.0, 'GNPOld': 616.0, 'LocalName': 'Belize', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 185, 'Code2': 'BZ', 'CountryCode': 'BLZ', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 50.8}, {'Code': 'BMU', 'Name': 'Bermuda', 'Continent': 'North America', 'Region': 'North America', 'SurfaceArea': 53.0, 'IndepYear': None, 'Population': 65000, 'LifeExpectancy': 76.9, 'GNP': 2328.0, 'GNPOld': 2190.0, 'LocalName': 'Bermuda', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 191, 'Code2': 'BM', 'CountryCode': 'BMU', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 100.0}, {'Code': 'BRB', 'Name': 'Barbados', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 430.0, 'IndepYear': 1966, 'Population': 270000, 'LifeExpectancy': 73.0, 'GNP': 2223.0, 'GNPOld': 2186.0, 'LocalName': 'Barbados', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 174, 'Code2': 'BB', 'CountryCode': 'BRB', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'CAN', 'Name': 'Canada', 'Continent': 'North America', 'Region': 'North America', 'SurfaceArea': 9970610.0, 'IndepYear': 1867, 'Population': 31147000, 'LifeExpectancy': 79.4, 'GNP': 598862.0, 'GNPOld': 625626.0, 'LocalName': 'Canada', 'GovernmentForm': 'Constitutional Monarchy, Federation', 'HeadOfState': 'Elisabeth II', 'Capital': 1822, 'Code2': 'CA', 'CountryCode': 'CAN', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 60.4}, {'Code': 'CCK', 'Name': 'Cocos (Keeling) Islands', 'Continent': 'Oceania', 'Region': 'Australia and New Zealand', 'SurfaceArea': 14.0, 'IndepYear': None, 'Population': 600, 'LifeExpectancy': None, 'GNP': 0.0, 'GNPOld': None, 'LocalName': 'Cocos (Keeling) Islands', 'GovernmentForm': 'Territory of Australia', 'HeadOfState': 'Elisabeth II', 'Capital': 2317, 'Code2': 'CC', 'CountryCode': 'CCK', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'CXR', 'Name': 'Christmas Island', 'Continent': 'Oceania', 'Region': 'Australia and New Zealand', 'SurfaceArea': 135.0, 'IndepYear': None, 'Population': 2500, 'LifeExpectancy': None, 'GNP': 0.0, 'GNPOld': None, 'LocalName': 'Christmas Island', 'GovernmentForm': 'Territory of Australia', 'HeadOfState': 'Elisabeth II', 'Capital': 1791, 'Code2': 'CX', 'CountryCode': 'CXR', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'CYM', 'Name': 'Cayman Islands', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 264.0, 'IndepYear': None, 'Population': 38000, 'LifeExpectancy': 78.9, 'GNP': 1263.0, 'GNPOld': 1186.0, 'LocalName': 'Cayman Islands', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 553, 'Code2': 'KY', 'CountryCode': 'CYM', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'FLK', 'Name': 'Falkland Islands', 'Continent': 'South America', 'Region': 'South America', 'SurfaceArea': 12173.0, 'IndepYear': None, 'Population': 2000, 'LifeExpectancy': None, 'GNP': 0.0, 'GNPOld': None, 'LocalName': 'Falkland Islands', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 763, 'Code2': 'FK', 'CountryCode': 'FLK', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'GBR', 'Name': 'United Kingdom', 'Continent': 'Europe', 'Region': 'British Islands', 'SurfaceArea': 242900.0, 'IndepYear': 1066, 'Population': 59623400, 'LifeExpectancy': 77.7, 'GNP': 1378330.0, 'GNPOld': 1296830.0, 'LocalName': 'United Kingdom', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 456, 'Code2': 'GB', 'CountryCode': 'GBR', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 97.3}, {'Code': 'GIB', 'Name': 'Gibraltar', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': 6.0, 'IndepYear': None, 'Population': 25000, 'LifeExpectancy': 79.0, 'GNP': 258.0, 'GNPOld': None, 'LocalName': 'Gibraltar', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 915, 'Code2': 'GI', 'CountryCode': 'GIB', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 88.9}, {'Code': 'GUM', 'Name': 'Guam', 'Continent': 'Oceania', 'Region': 'Micronesia', 'SurfaceArea': 549.0, 'IndepYear': None, 'Population': 168000, 'LifeExpectancy': 77.8, 'GNP': 1197.0, 'GNPOld': 1136.0, 'LocalName': 'Guam', 'GovernmentForm': 'US Territory', 'HeadOfState': 'George W. Bush', 'Capital': 921, 'Code2': 'GU', 'CountryCode': 'GUM', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 37.5}, {'Code': 'HKG', 'Name': 'Hong Kong', 'Continent': 'Asia', 'Region': 'Eastern Asia', 'SurfaceArea': 1075.0, 'IndepYear': None, 'Population': 6782000, 'LifeExpectancy': 79.5, 'GNP': 166448.0, 'GNPOld': 173610.0, 'LocalName': 'Xianggang/Hong Kong', 'GovernmentForm': 'Special Administrative Region of China', 'HeadOfState': 'Jiang Zemin', 'Capital': 937, 'Code2': 'HK', 'CountryCode': 'HKG', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 2.2}, {'Code': 'IRL', 'Name': 'Ireland', 'Continent': 'Europe', 'Region': 'British Islands', 'SurfaceArea': 70273.0, 'IndepYear': 1921, 'Population': 3775100, 'LifeExpectancy': 76.8, 'GNP': 75921.0, 'GNPOld': 73132.0, 'LocalName': 'Ireland/Éire', 'GovernmentForm': 'Republic', 'HeadOfState': 'Mary McAleese', 'Capital': 1447, 'Code2': 'IE', 'CountryCode': 'IRL', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 98.4}, {'Code': 'KNA', 'Name': 'Saint Kitts and Nevis', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 261.0, 'IndepYear': 1983, 'Population': 38000, 'LifeExpectancy': 70.7, 'GNP': 299.0, 'GNPOld': None, 'LocalName': 'Saint Kitts and Nevis', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 3064, 'Code2': 'KN', 'CountryCode': 'KNA', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'LCA', 'Name': 'Saint Lucia', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 622.0, 'IndepYear': 1979, 'Population': 154000, 'LifeExpectancy': 72.3, 'GNP': 571.0, 'GNPOld': None, 'LocalName': 'Saint Lucia', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 3065, 'Code2': 'LC', 'CountryCode': 'LCA', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 20.0}, {'Code': 'LSO', 'Name': 'Lesotho', 'Continent': 'Africa', 'Region': 'Southern Africa', 'SurfaceArea': 30355.0, 'IndepYear': 1966, 'Population': 2153000, 'LifeExpectancy': 50.8, 'GNP': 1061.0, 'GNPOld': 1161.0, 'LocalName': 'Lesotho', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Letsie III', 'Capital': 2437, 'Code2': 'LS', 'CountryCode': 'LSO', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'MHL', 'Name': 'Marshall Islands', 'Continent': 'Oceania', 'Region': 'Micronesia', 'SurfaceArea': 181.0, 'IndepYear': 1990, 'Population': 64000, 'LifeExpectancy': 65.5, 'GNP': 97.0, 'GNPOld': None, 'LocalName': 'Marshall Islands/Majol', 'GovernmentForm': 'Republic', 'HeadOfState': 'Kessai Note', 'Capital': 2507, 'Code2': 'MH', 'CountryCode': 'MHL', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'MLT', 'Name': 'Malta', 'Continent': 'Europe', 'Region': 'Southern Europe', 'SurfaceArea': 316.0, 'IndepYear': 1964, 'Population': 380200, 'LifeExpectancy': 77.9, 'GNP': 3512.0, 'GNPOld': 3338.0, 'LocalName': 'Malta', 'GovernmentForm': 'Republic', 'HeadOfState': 'Guido de Marco', 'Capital': 2484, 'Code2': 'MT', 'CountryCode': 'MLT', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 2.1}, {'Code': 'MNP', 'Name': 'Northern Mariana Islands', 'Continent': 'Oceania', 'Region': 'Micronesia', 'SurfaceArea': 464.0, 'IndepYear': None, 'Population': 78000, 'LifeExpectancy': 75.5, 'GNP': 0.0, 'GNPOld': None, 'LocalName': 'Northern Mariana Islands', 'GovernmentForm': 'Commonwealth of the US', 'HeadOfState': 'George W. Bush', 'Capital': 2913, 'Code2': 'MP', 'CountryCode': 'MNP', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 4.8}, {'Code': 'MSR', 'Name': 'Montserrat', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 102.0, 'IndepYear': None, 'Population': 11000, 'LifeExpectancy': 78.0, 'GNP': 109.0, 'GNPOld': None, 'LocalName': 'Montserrat', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 2697, 'Code2': 'MS', 'CountryCode': 'MSR', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'NFK', 'Name': 'Norfolk Island', 'Continent': 'Oceania', 'Region': 'Australia and New Zealand', 'SurfaceArea': 36.0, 'IndepYear': None, 'Population': 2000, 'LifeExpectancy': None, 'GNP': 0.0, 'GNPOld': None, 'LocalName': 'Norfolk Island', 'GovernmentForm': 'Territory of Australia', 'HeadOfState': 'Elisabeth II', 'Capital': 2806, 'Code2': 'NF', 'CountryCode': 'NFK', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'NIU', 'Name': 'Niue', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': 260.0, 'IndepYear': None, 'Population': 2000, 'LifeExpectancy': None, 'GNP': 0.0, 'GNPOld': None, 'LocalName': 'Niue', 'GovernmentForm': 'Nonmetropolitan Territory of New Zealand', 'HeadOfState': 'Elisabeth II', 'Capital': 2805, 'Code2': 'NU', 'CountryCode': 'NIU', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'NLD', 'Name': 'Netherlands', 'Continent': 'Europe', 'Region': 'Western Europe', 'SurfaceArea': 41526.0, 'IndepYear': 1581, 'Population': 15864000, 'LifeExpectancy': 78.3, 'GNP': 371362.0, 'GNPOld': 360478.0, 'LocalName': 'Nederland', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Beatrix', 'Capital': 5, 'Code2': 'NL', 'CountryCode': 'NLD', 'Language': 'Dutch', 'IsOfficial': 'T', 'Percentage': 95.6}, {'Code': 'NRU', 'Name': 'Nauru', 'Continent': 'Oceania', 'Region': 'Micronesia', 'SurfaceArea': 21.0, 'IndepYear': 1968, 'Population': 12000, 'LifeExpectancy': 60.8, 'GNP': 197.0, 'GNPOld': None, 'LocalName': 'Naoero/Nauru', 'GovernmentForm': 'Republic', 'HeadOfState': 'Bernard Dowiyogo', 'Capital': 2728, 'Code2': 'NR', 'CountryCode': 'NRU', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 7.5}, {'Code': 'NZL', 'Name': 'New Zealand', 'Continent': 'Oceania', 'Region': 'Australia and New Zealand', 'SurfaceArea': 270534.0, 'IndepYear': 1907, 'Population': 3862000, 'LifeExpectancy': 77.8, 'GNP': 54669.0, 'GNPOld': 64960.0, 'LocalName': 'New Zealand/Aotearoa', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 3499, 'Code2': 'NZ', 'CountryCode': 'NZL', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 87.0}, {'Code': 'PLW', 'Name': 'Palau', 'Continent': 'Oceania', 'Region': 'Micronesia', 'SurfaceArea': 459.0, 'IndepYear': 1994, 'Population': 19000, 'LifeExpectancy': 68.6, 'GNP': 105.0, 'GNPOld': None, 'LocalName': 'Belau/Palau', 'GovernmentForm': 'Republic', 'HeadOfState': 'Kuniwo Nakamura', 'Capital': 2881, 'Code2': 'PW', 'CountryCode': 'PLW', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 3.2}, {'Code': 'SHN', 'Name': 'Saint Helena', 'Continent': 'Africa', 'Region': 'Western Africa', 'SurfaceArea': 314.0, 'IndepYear': None, 'Population': 6000, 'LifeExpectancy': 76.8, 'GNP': 0.0, 'GNPOld': None, 'LocalName': 'Saint Helena', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 3063, 'Code2': 'SH', 'CountryCode': 'SHN', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'SYC', 'Name': 'Seychelles', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': 455.0, 'IndepYear': 1976, 'Population': 77000, 'LifeExpectancy': 70.4, 'GNP': 536.0, 'GNPOld': 539.0, 'LocalName': 'Sesel/Seychelles', 'GovernmentForm': 'Republic', 'HeadOfState': 'France-Albert René', 'Capital': 3206, 'Code2': 'SC', 'CountryCode': 'SYC', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 3.8}, {'Code': 'TCA', 'Name': 'Turks and Caicos Islands', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 430.0, 'IndepYear': None, 'Population': 17000, 'LifeExpectancy': 73.3, 'GNP': 96.0, 'GNPOld': None, 'LocalName': 'The Turks and Caicos Islands', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 3423, 'Code2': 'TC', 'CountryCode': 'TCA', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'TKL', 'Name': 'Tokelau', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': 12.0, 'IndepYear': None, 'Population': 2000, 'LifeExpectancy': None, 'GNP': 0.0, 'GNPOld': None, 'LocalName': 'Tokelau', 'GovernmentForm': 'Nonmetropolitan Territory of New Zealand', 'HeadOfState': 'Elisabeth II', 'Capital': 3333, 'Code2': 'TK', 'CountryCode': 'TKL', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'TON', 'Name': 'Tonga', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': 650.0, 'IndepYear': 1970, 'Population': 99000, 'LifeExpectancy': 67.9, 'GNP': 146.0, 'GNPOld': 170.0, 'LocalName': 'Tonga', 'GovernmentForm': 'Monarchy', 'HeadOfState': "Taufa'ahau Tupou IV", 'Capital': 3334, 'Code2': 'TO', 'CountryCode': 'TON', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'TUV', 'Name': 'Tuvalu', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': 26.0, 'IndepYear': 1978, 'Population': 12000, 'LifeExpectancy': 66.3, 'GNP': 6.0, 'GNPOld': None, 'LocalName': 'Tuvalu', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 3424, 'Code2': 'TV', 'CountryCode': 'TUV', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'UMI', 'Name': 'United States Minor Outlying Islands', 'Continent': 'Oceania', 'Region': 'Micronesia/Caribbean', 'SurfaceArea': 16.0, 'IndepYear': None, 'Population': 0, 'LifeExpectancy': None, 'GNP': 0.0, 'GNPOld': None, 'LocalName': 'United States Minor Outlying Islands', 'GovernmentForm': 'Dependent Territory of the US', 'HeadOfState': 'George W. Bush', 'Capital': None, 'Code2': 'UM', 'CountryCode': 'UMI', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'USA', 'Name': 'United States', 'Continent': 'North America', 'Region': 'North America', 'SurfaceArea': 9363520.0, 'IndepYear': 1776, 'Population': 278357000, 'LifeExpectancy': 77.1, 'GNP': 8510700.0, 'GNPOld': 8110900.0, 'LocalName': 'United States', 'GovernmentForm': 'Federal Republic', 'HeadOfState': 'George W. Bush', 'Capital': 3813, 'Code2': 'US', 'CountryCode': 'USA', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 86.2}, {'Code': 'VCT', 'Name': 'Saint Vincent and the Grenadines', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 388.0, 'IndepYear': 1979, 'Population': 114000, 'LifeExpectancy': 72.3, 'GNP': 285.0, 'GNPOld': None, 'LocalName': 'Saint Vincent and the Grenadines', 'GovernmentForm': 'Constitutional Monarchy', 'HeadOfState': 'Elisabeth II', 'Capital': 3066, 'Code2': 'VC', 'CountryCode': 'VCT', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'VGB', 'Name': 'Virgin Islands, British', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 151.0, 'IndepYear': None, 'Population': 21000, 'LifeExpectancy': 75.4, 'GNP': 612.0, 'GNPOld': 573.0, 'LocalName': 'British Virgin Islands', 'GovernmentForm': 'Dependent Territory of the UK', 'HeadOfState': 'Elisabeth II', 'Capital': 537, 'Code2': 'VG', 'CountryCode': 'VGB', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.0}, {'Code': 'VIR', 'Name': 'Virgin Islands, U.S.', 'Continent': 'North America', 'Region': 'Caribbean', 'SurfaceArea': 347.0, 'IndepYear': None, 'Population': 93000, 'LifeExpectancy': 78.1, 'GNP': 0.0, 'GNPOld': None, 'LocalName': 'Virgin Islands of the United States', 'GovernmentForm': 'US Territory', 'HeadOfState': 'George W. Bush', 'Capital': 4067, 'Code2': 'VI', 'CountryCode': 'VIR', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 81.7}, {'Code': 'VUT', 'Name': 'Vanuatu', 'Continent': 'Oceania', 'Region': 'Melanesia', 'SurfaceArea': 12189.0, 'IndepYear': 1980, 'Population': 190000, 'LifeExpectancy': 60.6, 'GNP': 261.0, 'GNPOld': 246.0, 'LocalName': 'Vanuatu', 'GovernmentForm': 'Republic', 'HeadOfState': 'John Bani', 'Capital': 3537, 'Code2': 'VU', 'CountryCode': 'VUT', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 28.3}, {'Code': 'WSM', 'Name': 'Samoa', 'Continent': 'Oceania', 'Region': 'Polynesia', 'SurfaceArea': 2831.0, 'IndepYear': 1962, 'Population': 180000, 'LifeExpectancy': 69.2, 'GNP': 141.0, 'GNPOld': 157.0, 'LocalName': 'Samoa', 'GovernmentForm': 'Parlementary Monarchy', 'HeadOfState': 'Malietoa Tanumafili II', 'Capital': 3169, 'Code2': 'WS', 'CountryCode': 'WSM', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 0.6}, {'Code': 'ZAF', 'Name': 'South Africa', 'Continent': 'Africa', 'Region': 'Southern Africa', 'SurfaceArea': 1221037.0, 'IndepYear': 1910, 'Population': 40377000, 'LifeExpectancy': 51.1, 'GNP': 116729.0, 'GNPOld': 129092.0, 'LocalName': 'South Africa', 'GovernmentForm': 'Republic', 'HeadOfState': 'Thabo Mbeki', 'Capital': 716, 'Code2': 'ZA', 'CountryCode': 'ZAF', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 8.5}, {'Code': 'ZWE', 'Name': 'Zimbabwe', 'Continent': 'Africa', 'Region': 'Eastern Africa', 'SurfaceArea': 390757.0, 'IndepYear': 1980, 'Population': 11669000, 'LifeExpectancy': 37.8, 'GNP': 5951.0, 'GNPOld': 8670.0, 'LocalName': 'Zimbabwe', 'GovernmentForm': 'Republic', 'HeadOfState': 'Robert G. Mugabe', 'Capital': 4068, 'Code2': 'ZW', 'CountryCode': 'ZWE', 'Language': 'English', 'IsOfficial': 'T', 'Percentage': 2.2}]