mathie's tech+business bits: MySQL database of geographical countries

CREATE TABLE `geo_country` (
  `CountryId` int(10) unsigned NOT NULL default '0',
  `Country` varchar(100) NOT NULL default '',
  `FIPS104` char(2) NOT NULL default '',
  `ISO2` char(2) NOT NULL default '',
  `ISO3` char(3) NOT NULL default '',
  `ISON` int(10) unsigned NOT NULL default '0',
  `Internet` char(2) NOT NULL default '',
  `Capital` varchar(100) NOT NULL default '',
  `MapReference` varchar(100) NOT NULL default '',
  `NationalitySingular` varchar(100) NOT NULL default '',
  `NationalityPlural` varchar(100) NOT NULL default '',
  `Currency` varchar(100) NOT NULL default '',
  `CurrencyCode` char(3) NOT NULL default '',
  `Population` float unsigned NOT NULL default '0',
  `Comment` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`CountryId`),
  KEY `Country` (`Country`),
  KEY `Capital` (`Capital`),
  KEY `Internet` (`Internet`),
  KEY `FIPS104` (`FIPS104`),
  KEY `ISO2` (`ISO2`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Countries from GeoBytes.com';

--
-- Dumping data for table `geo_country`
--

INSERT INTO `geo_country` VALUES(1, 'Afghanistan', 'AF', 'AF', 'AFG', 4, 'AF', 'Kabul', 'Asia', 'Afghan', 'Afghans', 'Afghani', 'AFA', 2.68131e+07, '');
INSERT INTO `geo_country` VALUES(2, 'Albania', 'AL', 'AL', 'ALB', 8, 'AL', 'Tirana', 'Europe', 'Albanian', 'Albanians', 'Lek', 'ALL', 3.51048e+06, '');
INSERT INTO `geo_country` VALUES(3, 'Algeria', 'AG', 'DZ', 'DZA', 12, 'DZ', 'Algiers', 'Africa', 'Algerian', 'Algerians', 'Algerian Dinar', 'DZD', 3.17361e+07, '');
INSERT INTO `geo_country` VALUES(4, 'American Samoa', 'AQ', 'AS', 'ASM', 16, 'AS', 'Pago Pago', 'Oceania', 'American Samoan', 'American Samoans', 'US Dollar', 'USD', 67084, '');
INSERT INTO `geo_country` VALUES(5, 'Andorra', 'AN', 'AD', 'AND', 20, 'AD', 'Andorra la Vella', 'Europe', 'Andorran', 'Andorrans', 'Euro', 'EUR', 67627, '');
INSERT INTO `geo_country` VALUES(6, 'Angola', 'AO', 'AO', 'AGO', 24, 'AO', 'Luanda', 'Africa', 'Angolan', 'Angolans', 'Kwanza', 'AOA', 1.0366e+07, '');
INSERT INTO `geo_country` VALUES(7, 'Anguilla', 'AV', 'AI', 'AIA', 660, 'AI', 'The Valley', 'Central America and the Caribbean', 'Anguillan', 'Anguillans', 'East Caribbean Dollar', 'XCD', 12132, '');
INSERT INTO `geo_country` VALUES(8, 'Antarctica', 'AY', 'AQ', 'ATA', 10, 'AQ', '', 'Antarctic Region', '', '', '', '', 0, 'ISO defines as the territory south of 60 degrees south latitude');
INSERT INTO `geo_country` VALUES(9, 'Antigua and Barbuda', 'AC', 'AG', 'ATG', 28, 'AG', 'Saint John''s', 'Central America and the Caribbean', 'Antiguan and Barbudan', 'Antiguans and Barbudans', 'East Caribbean Dollar', 'XCD', 66970, '');
INSERT INTO `geo_country` VALUES(10, 'Argentina', 'AR', 'AR', 'ARG', 32, 'AR', 'Buenos Aires', 'South America', 'Argentine', 'Argentines', 'Argentine Peso', 'ARS', 3.73848e+07, '');
INSERT INTO `geo_country` VALUES(11, 'Armenia', 'AM', 'AM', 'ARM', 51, 'AM', 'Yerevan', 'Commonwealth of Independent States', 'Armenian', 'Armenians', 'Armenian Dram', 'AMD', 3.3361e+06, '');
INSERT INTO `geo_country` VALUES(12, 'Aruba', 'AA', 'AW', 'ABW', 533, 'AW', 'Oranjestad', 'Central America and the Caribbean', 'Aruban', 'Arubans', 'Aruban Guilder', 'AWG', 70007, '');
INSERT INTO `geo_country` VALUES(13, 'Ashmore and Cartier', 'AT', '--', '--', 0, '--', '', 'Southeast Asia', '', '', '', '', 0, 'ISO includes with Australia');
INSERT INTO `geo_country` VALUES(14, 'Australia', 'AS', 'AU', 'AUS', 36, 'AU', 'Canberra', 'Oceania', 'Australian', 'Australians', 'Australian dollar', 'AUD', 1.93576e+07, 'ISO includes Ashmore and Cartier Islands,Coral Sea Islands');
INSERT INTO `geo_country` VALUES(15, 'Austria', 'AU', 'AT', 'AUT', 40, 'AT', 'Vienna', 'Europe', 'Austrian', 'Austrians', 'Euro', 'EUR', 8.15084e+06, '');
INSERT INTO `geo_country` VALUES(16, 'Azerbaijan', 'AJ', 'AZ', 'AZE', 31, 'AZ', 'Baku (Baki)', 'Commonwealth of Independent States', 'Azerbaijani', 'Azerbaijanis', 'Azerbaijani Manat', 'AZM', 7.77109e+06, '');
INSERT INTO `geo_country` VALUES(17, 'The Bahamas', 'BF', 'BS', 'BHS', 44, 'BS', 'Nassau', 'Central America and the Caribbean', 'Bahamian', 'Bahamians', 'Bahamian Dollar', 'BSD', 297852, '');
INSERT INTO `geo_country` VALUES(18, 'Bahrain', 'BA', 'BH', 'BHR', 48, 'BH', 'Manama', 'Middle East', 'Bahraini', 'Bahrainis', 'Bahraini Dinar', 'BHD', 645361, '');
INSERT INTO `geo_country` VALUES(19, 'Baker Island', 'FQ', '--', '--', 0, '--', '', 'Oceania', '', '', '', '', 0, 'ISO includes with the US Minor Outlying Islands');
INSERT INTO `geo_country` VALUES(20, 'Bangladesh', 'BG', 'BD', 'BGD', 50, 'BD', 'Dhaka', 'Asia', 'Bangladeshi', 'Bangladeshis', 'Taka', 'BDT', 1.3127e+08, '');
INSERT INTO `geo_country` VALUES(21, 'Barbados', 'BB', 'BB', 'BRB', 52, 'BB', 'Bridgetown', 'Central America and the Caribbean', 'Barbadian', 'Barbadians', 'Barbados Dollar', 'BBD', 275330, '');
INSERT INTO `geo_country` VALUES(22, 'Bassas da India', 'BS', '--', '--', 0, '--', '', 'Africa', '', '', '', '', 0, 'ISO includes with the Miscellaneous (French) Indian Ocean Islands');
INSERT INTO `geo_country` VALUES(23, 'Belarus', 'BO', 'BY', 'BLR', 112, 'BY', 'Minsk', 'Commonwealth of Independent States', 'Belarusian', 'Belarusians', 'Belarussian Ruble', 'BYR', 1.03502e+07, '');
INSERT INTO `geo_country` VALUES(24, 'Belgium', 'BE', 'BE', 'BEL', 56, 'BE', 'Brussels', 'Europe', 'Belgian', 'Belgians', 'Euro', 'EUR', 1.02588e+07, '');
INSERT INTO `geo_country` VALUES(25, 'Belize', 'BH', 'BZ', 'BLZ', 84, 'BZ', 'Belmopan', 'Central America and the Caribbean', 'Belizean', 'Belizeans', 'Belize Dollar', 'BZD', 256062, '');
INSERT INTO `geo_country` VALUES(26, 'Benin', 'BN', 'BJ', 'BEN', 204, 'BJ', 'Porto-Novo', 'Africa', 'Beninese', 'Beninese', 'CFA Franc BCEAO', 'XOF', 6.59078e+06, '');
INSERT INTO `geo_country` VALUES(27, 'Bermuda', 'BD', 'BM', 'BMU', 60, 'BM', 'Hamilton', 'North America', 'Bermudian', 'Bermudians', 'Bermudian Dollar', 'BMD', 63503, '');
INSERT INTO `geo_country` VALUES(28, 'Bhutan', 'BT', 'BT', 'BTN', 64, 'BT', 'Thimphu', 'Asia', 'Bhutanese', 'Bhutanese', 'Ngultrum', 'BTN', 2.04941e+06, '');
INSERT INTO `geo_country` VALUES(29, 'Bolivia', 'BL', 'BO', 'BOL', 68, 'BO', 'La Paz /Sucre', 'South America', 'Bolivian', 'Bolivians', 'Boliviano', 'BOB', 8.30046e+06, '');
INSERT INTO `geo_country` VALUES(30, 'Bosnia and Herzegovina', 'BK', 'BA', 'BIH', 70, 'BA', 'Sarajevo', 'Bosnia and Herzegovina, Europe', 'Bosnian and Herzegovinian', 'Bosnians and Herzegovinians', 'Convertible Marka', 'BAM', 3.9222e+06, '');
INSERT INTO `geo_country` VALUES(31, 'Botswana', 'BC', 'BW', 'BWA', 72, 'BW', 'Gaborone', 'Africa', 'Motswana', 'Batswana', 'Pula', 'BWP', 1.58612e+06, '');
INSERT INTO `geo_country` VALUES(32, 'Bouvet Island', 'BV', 'BV', 'BVT', 74, 'BV', '', 'Antarctic Region', '', '', 'Norwegian Krone', 'NOK', 0, '');
INSERT INTO `geo_country` VALUES(33, 'Brazil', 'BR', 'BR', 'BRA', 76, 'BR', 'Brasilia', 'South America', 'Brazilian', 'Brazilians', 'Brazilian Real', 'BRL', 1.74469e+08, '');
INSERT INTO `geo_country` VALUES(34, 'British Indian Ocean Territory', 'IO', 'IO', 'IOT', 86, 'IO', '', 'World', '', '', 'US Dollar', 'USD', 0, '');
INSERT INTO `geo_country` VALUES(35, 'British Virgin Islands', 'VI', 'VG', 'VGB', 92, 'VG', 'Road Town', 'Central America and the Caribbean', 'British Virgin Islander', 'British Virgin Islanders', 'US Dollar', 'USD', 20812, '');
INSERT INTO `geo_country` VALUES(36, 'Brunei Darussalam', 'BX', 'BN', 'BRN', 96, 'BN', '', '', '', '', 'Brunei Dollar', 'BND', 0, '');
INSERT INTO `geo_country` VALUES(37, 'Bulgaria', 'BU', 'BG', 'BGR', 100, 'BG', 'Sofia', 'Europe', 'Bulgarian', 'Bulgarians', 'Lev', 'BGL', 7.7075e+06, '');
INSERT INTO `geo_country` VALUES(38, 'Burkina Faso', 'UV', 'BF', 'BFA', 854, 'BF', 'Ouagadougou', 'Africa', 'Burkinabe', 'Burkinabe', 'CFA Franc BCEAO', 'XOF', 1.22723e+07, '');
INSERT INTO `geo_country` VALUES(39, 'Burma', 'BM', 'MM', 'MMR', 104, 'MM', 'Rangoon', 'Southeast Asia', 'Burmese', 'Burmese', 'kyat', 'MMK', 4.19947e+07, 'ISO uses the name Myanmar');
INSERT INTO `geo_country` VALUES(40, 'Burundi', 'BY', 'BI', 'BDI', 108, 'BI', 'Bujumbura', 'Africa', 'Burundi', 'Burundians', 'Burundi Franc', 'BIF', 6.2239e+06, '');
INSERT INTO `geo_country` VALUES(41, 'Cambodia', 'CB', 'KH', 'KHM', 116, 'KH', 'Phnom Penh', 'Southeast Asia', 'Cambodian', 'Cambodians', 'Riel', 'KHR', 1.24915e+07, '');
INSERT INTO `geo_country` VALUES(42, 'Cameroon', 'CM', 'CM', 'CMR', 120, 'CM', 'Yaounde', 'Africa', 'Cameroonian', 'Cameroonians', 'CFA Franc BEAC', 'XAF', 1.58032e+07, '');
INSERT INTO `geo_country` VALUES(43, 'Canada', 'CA', 'CA', 'CAN', 124, 'CA', 'Ottawa', 'North America', 'Canadian', 'Canadians', 'Canadian Dollar', 'CAD', 3.15928e+07, '');
INSERT INTO `geo_country` VALUES(44, 'Cape Verde', 'CV', 'CV', 'CPV', 132, 'CV', 'Praia', 'World', 'Cape Verdean', 'Cape Verdeans', 'Cape Verdean Escudo', 'CVE', 405163, '');
INSERT INTO `geo_country` VALUES(45, 'Cayman Islands', 'CJ', 'KY', 'CYM', 136, 'KY', 'George Town', 'Central America and the Caribbean', 'Caymanian', 'Caymanians', 'Cayman Islands Dollar', 'KYD', 35527, '');
INSERT INTO `geo_country` VALUES(46, 'Central African Republic', 'CT', 'CF', 'CAF', 140, 'CF', 'Bangui', 'Africa', 'Central African', 'Central Africans', 'CFA Franc BEAC', 'XAF', 3.57688e+06, '');
INSERT INTO `geo_country` VALUES(47, 'Chad', 'CD', 'TD', 'TCD', 148, 'TD', 'N''Djamena', 'Africa', 'Chadian', 'Chadians', 'CFA Franc BEAC', 'XAF', 8.70708e+06, '');
INSERT INTO `geo_country` VALUES(48, 'Chile', 'CI', 'CL', 'CHL', 152, 'CL', 'Santiago', 'South America', 'Chilean', 'Chileans', 'Chilean Peso', 'CLP', 1.53285e+07, '');
INSERT INTO `geo_country` VALUES(49, 'China', 'CH', 'CN', 'CHN', 156, 'CN', 'Beijing', 'Asia', 'Chinese', 'Chinese', 'Yuan Renminbi', 'CNY', 1.27311e+09, 'see also Taiwan');
INSERT INTO `geo_country` VALUES(50, 'Christmas Island', 'KT', 'CX', 'CXR', 162, 'CX', 'The Settlement', 'Southeast Asia', 'Christmas Island', 'Christmas Islanders', 'Australian Dollar', 'AUD', 2771, '');
INSERT INTO `geo_country` VALUES(51, 'Clipperton Island', 'IP', '--', '--', 0, '--', '', 'World', '', '', '', '', 0, 'ISO includes with French Polynesia');
INSERT INTO `geo_country` VALUES(52, 'Cocos (Keeling) Islands', 'CK', 'CC', 'CCK', 166, 'CC', 'West Island', 'Southeast Asia', 'Cocos Islander', 'Cocos Islanders', 'Australian Dollar', 'AUD', 633, '');
INSERT INTO `geo_country` VALUES(53, 'Colombia', 'CO', 'CO', 'COL', 170, 'CO', 'Bogota', 'South America, Central America and the Caribbean', 'Colombian', 'Colombians', 'Colombian Peso', 'COP', 4.03494e+07, '');
INSERT INTO `geo_country` VALUES(54, 'Comoros', 'CN', 'KM', 'COM', 174, 'KM', 'Moroni', 'Africa', 'Comoran', 'Comorans', 'Comoro Franc', 'KMF', 596202, '');
INSERT INTO `geo_country` VALUES(55, 'Congo, Democratic Republic of the', 'CG', 'CD', 'COD', 180, 'CD', 'Kinshasa', 'Africa', 'Congolese', 'Congolese', 'Franc Congolais', 'CDF', 5.36247e+07, 'formerly Zaire');
INSERT INTO `geo_country` VALUES(56, 'Congo, Republic of the', 'CF', 'CG', 'COG', 178, 'CG', 'Brazzaville', 'Africa', 'Congolese', 'Congolese', 'CFA Franc BEAC', 'XAF', 2.89434e+06, '');
INSERT INTO `geo_country` VALUES(57, 'Cook Islands', 'CW', 'CK', 'COK', 184, 'CK', 'Avarua', 'Oceania', 'Cook Islander', 'Cook Islanders', 'New Zealand Dollar', 'NZD', 20611, '');
INSERT INTO `geo_country` VALUES(58, 'Coral Sea Islands', 'CR', '--', '--', 0, '--', '', 'Oceania', '', '', '', '', 0, 'ISO includes with Australia');
INSERT INTO `geo_country` VALUES(59, 'Costa Rica', 'CS', 'CR', 'CRI', 188, 'CR', 'San Jose', 'Central America and the Caribbean', 'Costa Rican', 'Costa Ricans', 'Costa Rican Colon', 'CRC', 3.77306e+06, '');
INSERT INTO `geo_country` VALUES(60, 'Cote d''Ivoire', 'IV', 'CI', 'CIV', 384, 'CI', 'Yamoussoukro', 'Africa', 'Ivorian', 'Ivorians', 'CFA Franc BCEAO', 'XOF', 1.63932e+07, '');
INSERT INTO `geo_country` VALUES(61, 'Croatia', 'HR', 'HR', 'HRV', 191, 'HR', 'Zagreb', 'Europe', 'Croatian', 'Croats', 'Kuna', 'HRK', 4.33414e+06, '');
INSERT INTO `geo_country` VALUES(62, 'Cuba', 'CU', 'CU', 'CUB', 192, 'CU', 'Havana', 'Central America and the Caribbean', 'Cuban', 'Cubans', 'Cuban Peso', 'CUP', 1.1184e+07, '');
INSERT INTO `geo_country` VALUES(63, 'Cyprus', 'CY', 'CY', 'CYP', 196, 'CY', 'Nicosia', 'Middle East', 'Cypriot', 'Cypriots', 'Cyprus Pound', 'CYP', 762887, '');
INSERT INTO `geo_country` VALUES(64, 'Czech Republic', 'EZ', 'CZ', 'CZE', 203, 'CZ', 'Prague', 'Europe', 'Czech', 'Czechs', 'Czech Koruna', 'CZK', 1.02642e+07, '');
INSERT INTO `geo_country` VALUES(65, 'Denmark', 'DA', 'DK', 'DNK', 208, 'DK', 'Copenhagen', 'Europe', 'Danish', 'Danes', 'Danish Krone', 'DKK', 5.35282e+06, '');
INSERT INTO `geo_country` VALUES(66, 'Djibouti', 'DJ', 'DJ', 'DJI', 262, 'DJ', 'Djibouti', 'Africa', 'Djiboutian', 'Djiboutians', 'Djibouti Franc', 'DJF', 460700, '');
INSERT INTO `geo_country` VALUES(67, 'Dominica', 'DO', 'DM', 'DMA', 212, 'DM', 'Roseau', 'Central America and the Caribbean', 'Dominican', 'Dominicans', 'East Caribbean Dollar', 'XCD', 70786, '');
INSERT INTO `geo_country` VALUES(68, 'Dominican Republic', 'DR', 'DO', 'DOM', 214, 'DO', 'Santo Domingo', 'Central America and the Caribbean', 'Dominican', 'Dominicans', 'Dominican Peso', 'DOP', 8.58148e+06, '');
INSERT INTO `geo_country` VALUES(69, 'East Timor', 'TT', 'TL', 'TLS', 626, 'TP', '', '', '', '', 'Timor Escudo', 'TPE', 0, 'NULL');
INSERT INTO `geo_country` VALUES(70, 'Ecuador', 'EC', 'EC', 'ECU', 218, 'EC', 'Quito', 'South America', 'Ecuadorian', 'Ecuadorians', 'US Dollar', 'USD', 1.3184e+07, '');
INSERT INTO `geo_country` VALUES(71, 'Egypt', 'EG', 'EG', 'EGY', 818, 'EG', 'Cairo', 'Africa', 'Egyptian', 'Egyptians', 'Egyptian Pound', 'EGP', 6.95366e+07, '');
INSERT INTO `geo_country` VALUES(72, 'El Salvador', 'ES', 'SV', 'SLV', 222, 'SV', 'San Salvador', 'Central America and the Caribbean', 'Salvadoran', 'Salvadorans', 'El Salvador Colon', 'SVC', 6.23766e+06, '');
INSERT INTO `geo_country` VALUES(73, 'Equatorial Guinea', 'EK', 'GQ', 'GNQ', 226, 'GQ', 'Malabo', 'Africa', 'Equatorial Guinean', 'Equatorial Guineans', 'CFA Franc BEAC', 'XAF', 486060, '');
INSERT INTO `geo_country` VALUES(74, 'Eritrea', 'ER', 'ER', 'ERI', 232, 'ER', 'Asmara', 'Africa', 'Eritrean', 'Eritreans', 'Nakfa', 'ERN', 4.29827e+06, '');
INSERT INTO `geo_country` VALUES(75, 'Estonia', 'EN', 'EE', 'EST', 233, 'EE', 'Tallinn', 'Europe', 'Estonian', 'Estonians', 'Kroon', 'EEK', 1.42332e+06, '');
INSERT INTO `geo_country` VALUES(76, 'Ethiopia', 'ET', 'ET', 'ETH', 231, 'ET', 'Addis Ababa', 'Africa', 'Ethiopian', 'Ethiopians', 'Ethiopian Birr', 'ETB', 6.58919e+07, '');
INSERT INTO `geo_country` VALUES(77, 'Europa Island', 'EU', '--', '--', 0, '--', '', 'Africa', '', '', '', '', 0, 'ISO includes with the Miscellaneous (French) Indian Ocean Islands');
INSERT INTO `geo_country` VALUES(78, 'Falkland Islands (Islas Malvinas)', 'FK', 'FK', 'FLK', 238, 'FK', 'Stanley', 'South America', 'Falkland Island', 'Falkland Islanders', 'Falkland Islands Pound', 'FKP', 2895, '');
INSERT INTO `geo_country` VALUES(79, 'Faroe Islands', 'FO', 'FO', 'FRO', 234, 'FO', 'Torshavn', 'Europe', 'Faroese', 'Faroese', 'Danish Krone', 'DKK', 45661, '');
INSERT INTO `geo_country` VALUES(80, 'Fiji', 'FJ', 'FJ', 'FJI', 242, 'FJ', 'Suva', 'Oceania', 'Fijian', 'Fijians', 'Fijian Dollar', 'FJD', 844330, '');
INSERT INTO `geo_country` VALUES(81, 'Finland', 'FI', 'FI', 'FIN', 246, 'FI', 'Helsinki', 'Europe', 'Finnish', 'Finns', 'Euro', 'EUR', 5.17578e+06, '');
INSERT INTO `geo_country` VALUES(82, 'France', 'FR', 'FR', 'FRA', 250, 'FR', 'Paris', 'Europe', 'Frenchman', 'Frenchmen', 'Euro', 'EUR', 5.95512e+07, '');
INSERT INTO `geo_country` VALUES(83, 'France, Metropolitan', '--', '--', '--', 0, 'FX', '', '', '', '', 'Euro', 'EUR', 0, 'ISO limits to the European part of France, excluding French Guiana, French Polynesia, French Souther');
INSERT INTO `geo_country` VALUES(84, 'French Guiana', 'FG', 'GF', 'GUF', 254, 'GF', 'Cayenne', 'South America', 'French Guianese', 'French Guianese', 'Euro', 'EUR', 177562, '');
INSERT INTO `geo_country` VALUES(85, 'French Polynesia', 'FP', 'PF', 'PYF', 258, 'PF', 'Papeete', 'Oceania', 'French Polynesian', 'French Polynesians', 'CFP Franc', 'XPF', 253506, 'ISO includes Clipperton Island');
INSERT INTO `geo_country` VALUES(86, 'French Southern and Antarctic Lands', 'FS', 'TF', 'ATF', 260, 'TF', '', 'Antarctic Region', '', '', 'Euro', 'EUR', 0, 'FIPS 10-4 does not include the French-claimed portion of Antarctica (Terre Adelie)');
INSERT INTO `geo_country` VALUES(87, 'Gabon', 'GB', 'GA', 'GAB', 266, 'GA', 'Libreville', 'Africa', 'Gabonese', 'Gabonese', 'CFA Franc BEAC', 'XAF', 1.22118e+06, '');
INSERT INTO `geo_country` VALUES(88, 'The Gambia', 'GA', 'GM', 'GMB', 270, 'GM', 'Banjul', 'Africa', 'Gambian', 'Gambians', 'Dalasi', 'GMD', 1.4112e+06, '');
INSERT INTO `geo_country` VALUES(89, 'Gaza Strip', 'GZ', '--', '--', 0, '--', '', 'Middle East', '', '', 'New Israeli Shekel', 'ILS', 1.17812e+06, '');
INSERT INTO `geo_country` VALUES(90, 'Georgia', 'GG', 'GE', 'GEO', 268, 'GE', 'T''bilisi', 'Commonwealth of Independent States', 'Georgian', 'Georgians', 'Lari', 'GEL', 4.98928e+06, '');
INSERT INTO `geo_country` VALUES(91, 'Germany', 'GM', 'DE', 'DEU', 276, 'DE', 'Berlin', 'Europe', 'German', 'Germans', 'Euro', 'EUR', 8.30295e+07, '');
INSERT INTO `geo_country` VALUES(92, 'Ghana', 'GH', 'GH', 'GHA', 288, 'GH', 'Accra', 'Africa', 'Ghanaian', 'Ghanaians', 'Cedi', 'GHC', 1.9894e+07, '');
INSERT INTO `geo_country` VALUES(93, 'Gibraltar', 'GI', 'GI', 'GIB', 292, 'GI', 'Gibraltar', 'Europe', 'Gibraltar', 'Gibraltarians', 'Gibraltar Pound', 'GIP', 27649, '');
INSERT INTO `geo_country` VALUES(94, 'Glorioso Islands', 'GO', '--', '--', 0, '--', '', 'Africa', '', '', '', '', 0, 'ISO includes with the Miscellaneous (French) Indian Ocean Islands');
INSERT INTO `geo_country` VALUES(95, 'Greece', 'GR', 'GR', 'GRC', 300, 'GR', 'Athens', 'Europe', 'Greek', 'Greeks', 'Euro', 'EUR', 1.06238e+07, '');
INSERT INTO `geo_country` VALUES(96, 'Greenland', 'GL', 'GL', 'GRL', 304, 'GL', 'Nuuk', 'Arctic Region', 'Greenlandic', 'Greenlanders', 'Danish Krone', 'DKK', 56352, '');
INSERT INTO `geo_country` VALUES(97, 'Grenada', 'GJ', 'GD', 'GRD', 308, 'GD', 'Saint George''s', 'Central America and the Caribbean', 'Grenadian', 'Grenadians', 'East Caribbean Dollar', 'XCD', 89227, '');
INSERT INTO `geo_country` VALUES(98, 'Guadeloupe', 'GP', 'GP', 'GLP', 312, 'GP', 'Basse-Terre', 'Central America and the Caribbean', 'Guadeloupe', 'Guadeloupians', 'Euro', 'EUR', 431170, '');
INSERT INTO `geo_country` VALUES(99, 'Guam', 'GQ', 'GU', 'GUM', 316, 'GU', 'Hagatna', 'Oceania', 'Guamanian', 'Guamanians', 'US Dollar', 'USD', 157557, '');
INSERT INTO `geo_country` VALUES(100, 'Guatemala', 'GT', 'GT', 'GTM', 320, 'GT', 'Guatemala', 'Central America and the Caribbean', 'Guatemalan', 'Guatemalans', 'Quetzal', 'GTQ', 1.29744e+07, '');
INSERT INTO `geo_country` VALUES(101, 'Guernsey', 'GK', '--', '--', 0, 'GG', 'Saint Peter Port', 'Europe', 'Channel Islander', 'Channel Islanders', 'Pound Sterling', 'GBP', 64342, 'ISO includes with the United Kingdom');
INSERT INTO `geo_country` VALUES(102, 'Guinea', 'GV', 'GN', 'GIN', 324, 'GN', 'Conakry', 'Africa', 'Guinean', 'Guineans', 'Guinean Franc', 'GNF', 7.61387e+06, '');
INSERT INTO `geo_country` VALUES(103, 'Guinea-Bissau', 'PU', 'GW', 'GNB', 624, 'GW', 'Bissau', 'Africa', 'Guinean', 'Guineans', 'CFA Franc BCEAO', 'XOF', 1.31582e+06, '');
INSERT INTO `geo_country` VALUES(104, 'Guyana', 'GY', 'GY', 'GUY', 328, 'GY', 'Georgetown', 'South America', 'Guyanese', 'Guyanese', 'Guyana Dollar', 'GYD', 697181, '');
INSERT INTO `geo_country` VALUES(105, 'Haiti', 'HA', 'HT', 'HTI', 332, 'HT', 'Port-au-Prince', 'Central America and the Caribbean', 'Haitian', 'Haitians', 'Gourde', 'HTG', 6.96455e+06, '');
INSERT INTO `geo_country` VALUES(106, 'Heard Island and McDonald Islands', 'HM', 'HM', 'HMD', 334, 'HM', '', 'Antarctic Region', '', '', 'Australian Dollar', 'AUD', 0, '');
INSERT INTO `geo_country` VALUES(107, 'Holy See (Vatican City)', 'VT', 'VA', 'VAT', 336, 'VA', 'Vatican City', 'Europe', '', '', 'Euro', 'EUR', 890, '');
INSERT INTO `geo_country` VALUES(108, 'Honduras', 'HO', 'HN', 'HND', 340, 'HN', 'Tegucigalpa', 'Central America and the Caribbean', 'Honduran', 'Hondurans', 'Lempira', 'HNL', 6.40605e+06, '');
INSERT INTO `geo_country` VALUES(109, 'Hong Kong (SAR)', 'HK', 'HK', 'HKG', 344, 'HK', '', 'Southeast Asia', '', '', 'Hong Kong Dollar', 'HKD', 0, '');
INSERT INTO `geo_country` VALUES(110, 'Howland Island', 'HQ', '--', '--', 0, '--', '', 'Oceania', '', '', '', '', 7.2105e+06, 'ISO includes with the US Minor Outlying Islands');
INSERT INTO `geo_country` VALUES(111, 'Hungary', 'HU', 'HU', 'HUN', 348, 'HU', 'Budapest', 'Europe', 'Hungarian', 'Hungarians', 'Forint', 'HUF', 1.0106e+07, '');
INSERT INTO `geo_country` VALUES(112, 'Iceland', 'IC', 'IS', 'ISL', 352, 'IS', 'Reykjavik', 'Arctic Region', 'Icelandic', 'Icelanders', 'Iceland Krona', 'ISK', 277906, '');
INSERT INTO `geo_country` VALUES(113, 'India', 'IN', 'IN', 'IND', 356, 'IN', 'New Delhi', 'Asia', 'Indian', 'Indians', 'Indian Rupee', 'INR', 1.02999e+09, '');
INSERT INTO `geo_country` VALUES(114, 'Indonesia', 'ID', 'ID', 'IDN', 360, 'ID', 'Jakarta', 'Southeast Asia', 'Indonesian', 'Indonesians', 'Rupiah', 'IDR', 2.28438e+08, '');
INSERT INTO `geo_country` VALUES(115, 'Iran', 'IR', 'IR', 'IRN', 364, 'IR', 'Tehran', 'Middle East', 'Iranian', 'Iranians', 'Iranian Rial', 'IRR', 6.6129e+07, '');
INSERT INTO `geo_country` VALUES(116, 'Iraq', 'IZ', 'IQ', 'IRQ', 368, 'IQ', 'Baghdad', 'Middle East', 'Iraqi', 'Iraqis', 'Iraqi Dinar', 'IQD', 2.3332e+07, '');
INSERT INTO `geo_country` VALUES(117, 'Ireland', 'EI', 'IE', 'IRL', 372, 'IE', 'Dublin', 'Europe', 'Irish', 'Irishmen', 'Euro', 'EUR', 3.84084e+06, '');
INSERT INTO `geo_country` VALUES(118, 'Israel', 'IS', 'IL', 'ISR', 376, 'IL', 'Jerusalem', 'Middle East', 'Israeli', 'Israelis', 'New Israeli Sheqel', 'ILS', 5.93809e+06, '');
INSERT INTO `geo_country` VALUES(119, 'Italy', 'IT', 'IT', 'ITA', 380, 'IT', 'Rome', 'Europe', 'Italian', 'Italians', 'Euro', 'EUR', 5.76798e+07, '');
INSERT INTO `geo_country` VALUES(120, 'Jamaica', 'JM', 'JM', 'JAM', 388, 'JM', 'Kingston', 'Central America and the Caribbean', 'Jamaican', 'Jamaicans', 'Jamaican dollar', 'JMD', 2.66564e+06, '');
INSERT INTO `geo_country` VALUES(121, 'Jan Mayen', 'JN', '--', '--', 0, '--', '', 'Arctic Region', '', '', 'Norway Kroner', 'NOK', 0, 'ISO includes with Svalbard');
INSERT INTO `geo_country` VALUES(122, 'Japan', 'JA', 'JP', 'JPN', 392, 'JP', 'Tokyo', 'Asia', 'Japanese', 'Japanese', 'Yen', 'JPY', 1.26772e+08, '');
INSERT INTO `geo_country` VALUES(123, 'Jarvis Island', 'DQ', '--', '--', 0, '--', '', 'Oceania', '', '', '', '', 0, 'ISO includes with the US Minor Outlying Islands');
INSERT INTO `geo_country` VALUES(124, 'Jersey', 'JE', '--', '--', 0, 'JE', 'Saint Helier', 'Europe', 'Channel Islander', 'Channel Islanders', 'Pound Sterling', 'GBP', 89361, 'ISO includes with the United Kingdom');
INSERT INTO `geo_country` VALUES(125, 'Johnston Atoll', 'JQ', '--', '--', 0, '--', '', 'Oceania', '', '', '', '', 0, 'ISO includes with the US Minor Outlying Islands');
INSERT INTO `geo_country` VALUES(126, 'Jordan', 'JO', 'JO', 'JOR', 400, 'JO', 'Amman', 'Middle East', 'Jordanian', 'Jordanians', 'Jordanian Dinar', 'JOD', 5.15338e+06, '');
INSERT INTO `geo_country` VALUES(127, 'Juan de Nova Island', 'JU', '--', '--', 0, '--', '', 'Africa', '', '', '', '', 0, 'ISO includes with the Miscellaneous (French) Indian Ocean Islands');
INSERT INTO `geo_country` VALUES(128, 'Kazakhstan', 'KZ', 'KZ', 'KAZ', 398, 'KZ', 'Astana', 'Commonwealth of Independent States', 'Kazakhstani', 'Kazakhstanis', 'Tenge', 'KZT', 1.67313e+07, '');
INSERT INTO `geo_country` VALUES(129, 'Kenya', 'KE', 'KE', 'KEN', 404, 'KE', 'Nairobi', 'Africa', 'Kenyan', 'Kenyans', 'Kenyan shilling', 'KES', 3.07659e+07, '');
INSERT INTO `geo_country` VALUES(130, 'Kingman Reef', 'KQ', '--', '--', 0, '--', '', 'Oceania', '', '', '', '', 0, 'ISO includes with the US Minor Outlying Islands');
INSERT INTO `geo_country` VALUES(131, 'Kiribati', 'KR', 'KI', 'KIR', 296, 'KI', 'Tarawa', 'Oceania', 'I-Kiribati', 'I-Kiribati', 'Australian dollar', 'AUD', 94149, '');
INSERT INTO `geo_country` VALUES(132, 'Korea, North', 'KN', 'KP', 'PRK', 408, 'KP', 'P''yongyang', 'Asia', 'Korean', 'Koreans', 'North Korean Won', 'KPW', 2.19682e+07, '');
INSERT INTO `geo_country` VALUES(133, 'Korea, South', 'KS', 'KR', 'KOR', 410, 'KR', 'Seoul', 'Asia', 'Korean', 'Koreans', 'Won', 'KRW', 4.79044e+07, '');
INSERT INTO `geo_country` VALUES(134, 'Kuwait', 'KU', 'KW', 'KWT', 414, 'KW', 'Kuwait', 'Middle East', 'Kuwaiti', 'Kuwaitis', 'Kuwaiti Dinar', 'KWD', 2.04196e+06, '');
INSERT INTO `geo_country` VALUES(135, 'Kyrgyzstan', 'KG', 'KG', 'KGZ', 417, 'KG', 'Bishkek', 'Commonwealth of Independent States', 'Kyrgyzstani', 'Kyrgyzstanis', 'Som', 'KGS', 4.753e+06, '');
INSERT INTO `geo_country` VALUES(136, 'Laos', 'LA', 'LA', 'LAO', 418, 'LA', 'Vientiane', 'Southeast Asia', 'Lao', 'Laos', 'Kip', 'LAK', 5.63597e+06, '');
INSERT INTO `geo_country` VALUES(137, 'Latvia', 'LG', 'LV', 'LVA', 428, 'LV', 'Riga', 'Europe', 'Latvian', 'Latvians', 'Latvian Lats', 'LVL', 2.38523e+06, '');
INSERT INTO `geo_country` VALUES(138, 'Lebanon', 'LE', 'LB', 'LBN', 422, 'LB', 'Beirut', 'Middle East', 'Lebanese', 'Lebanese', 'Lebanese Pound', 'LBP', 3.62777e+06, '');
INSERT INTO `geo_country` VALUES(139, 'Lesotho', 'LT', 'LS', 'LSO', 426, 'LS', 'Maseru', 'Africa', 'Basotho', 'Mosotho', 'Loti', 'LSL', 2.17706e+06, '');
INSERT INTO `geo_country` VALUES(140, 'Liberia', 'LI', 'LR', 'LBR', 430, 'LR', 'Monrovia', 'Africa', 'Liberian', 'Liberians', 'Liberian Dollar', 'LRD', 3.22584e+06, '');
INSERT INTO `geo_country` VALUES(141, 'Libya', 'LY', 'LY', 'LBY', 434, 'LY', 'Tripoli', 'Africa', 'Libyan', 'Libyans', 'Libyan Dinar', 'LYD', 5.2406e+06, '');
INSERT INTO `geo_country` VALUES(142, 'Liechtenstein', 'LS', 'LI', 'LIE', 438, 'LI', 'Vaduz', 'Europe', 'Liechtenstein', 'Liechtensteiners', 'Swiss Franc', 'CHF', 32528, '');
INSERT INTO `geo_country` VALUES(143, 'Lithuania', 'LH', 'LT', 'LTU', 440, 'LT', 'Vilnius', 'Europe', 'Lithuanian', 'Lithuanians', 'Lithuanian Litas', 'LTL', 3.61054e+06, '');
INSERT INTO `geo_country` VALUES(144, 'Luxembourg', 'LU', 'LU', 'LUX', 442, 'LU', 'Luxembourg', 'Europe', 'Luxembourg', 'Luxembourgers', 'Euro', 'EUR', 442972, '');
INSERT INTO `geo_country` VALUES(145, 'Macao', 'MC', 'MO', 'MAC', 446, 'MO', '', 'Southeast Asia', 'Chinese', 'Chinese', 'Pataca', 'MOP', 453733, '');
INSERT INTO `geo_country` VALUES(146, 'Macedonia, The Former Yugoslav Republic of', 'MK', 'MK', 'MKD', 807, 'MK', 'Skopje', 'Europe', 'Macedonian', 'Macedonians', 'Denar', 'MKD', 2.04621e+06, '');
INSERT INTO `geo_country` VALUES(147, 'Madagascar', 'MA', 'MG', 'MDG', 450, 'MG', 'Antananarivo', 'Africa', 'Malagasy', 'Malagasy', 'Malagasy Franc', 'MGF', 1.59826e+07, '');
INSERT INTO `geo_country` VALUES(148, 'Malawi', 'MI', 'MW', 'MWI', 454, 'MW', 'Lilongwe', 'Africa', 'Malawian', 'Malawians', 'Kwacha', 'MWK', 1.05482e+07, '');
INSERT INTO `geo_country` VALUES(149, 'Malaysia', 'MY', 'MY', 'MYS', 458, 'MY', 'Kuala Lumpur', 'Southeast Asia', 'Malaysian', 'Malaysians', 'Malaysian Ringgit', 'MYR', 2.2229e+07, '');
INSERT INTO `geo_country` VALUES(150, 'Maldives', 'MV', 'MV', 'MDV', 462, 'MV', 'Male', 'Asia', 'Maldivian', 'Maldivians', 'Rufiyaa', 'MVR', 310764, '');
INSERT INTO `geo_country` VALUES(151, 'Mali', 'ML', 'ML', 'MLI', 466, 'ML', 'Bamako', 'Africa', 'Malian', 'Malians', 'CFA Franc BCEAO', 'XOF', 1.10085e+07, '');
INSERT INTO `geo_country` VALUES(152, 'Malta', 'MT', 'MT', 'MLT', 470, 'MT', 'Valletta', 'Europe', 'Maltese', 'Maltese', 'Maltese Lira', 'MTL', 394583, '');
INSERT INTO `geo_country` VALUES(153, 'Man, Isle of', 'IM', '--', '--', 0, 'IM', 'Douglas', 'Europe', 'Manxman', 'Manxmen', 'Pound Sterling', 'GBP', 73489, 'ISO includes with the United Kingdom');
INSERT INTO `geo_country` VALUES(154, 'Marshall Islands', 'RM', 'MH', 'MHL', 584, 'MH', 'Majuro', 'Oceania', 'Marshallese', 'Marshallese', 'US Dollar', 'USD', 70822, '');
INSERT INTO `geo_country` VALUES(155, 'Martinique', 'MB', 'MQ', 'MTQ', 474, 'MQ', 'Fort-de-France', 'Central America and the Caribbean', 'Martiniquais', 'Martiniquais', 'Euro', 'EUR', 418454, '');
INSERT INTO `geo_country` VALUES(156, 'Mauritania', 'MR', 'MR', 'MRT', 478, 'MR', 'Nouakchott', 'Africa', 'Mauritanian', 'Mauritanians', 'Ouguiya', 'MRO', 2.74731e+06, '');
INSERT INTO `geo_country` VALUES(157, 'Mauritius', 'MP', 'MU', 'MUS', 480, 'MU', 'Port Louis', 'World', 'Mauritian', 'Mauritians', 'Mauritius Rupee', 'MUR', 1.18982e+06, '');
INSERT INTO `geo_country` VALUES(158, 'Mayotte', 'MF', 'YT', 'MYT', 175, 'YT', 'Mamoutzou', 'Africa', 'Mahorais', 'Mahorais', 'Euro', 'EUR', 163366, '');
INSERT INTO `geo_country` VALUES(159, 'Mexico', 'MX', 'MX', 'MEX', 484, 'MX', 'Mexico', 'North America', 'Mexican', 'Mexicans', 'Mexican Peso', 'MXN', 1.01879e+08, '');
INSERT INTO `geo_country` VALUES(160, 'Micronesia, Federated States of', 'FM', 'FM', 'FSM', 583, 'FM', 'Palikir', 'Oceania', 'Micronesian', 'Micronesians', 'US Dollar', 'USD', 134597, '');
INSERT INTO `geo_country` VALUES(161, 'Midway Islands', 'MQ', '--', '--', 0, '--', '', 'Oceania', '', '', 'United States Dollars', 'USD', 0, 'ISO includes with the US Minor Outlying Islands');
INSERT INTO `geo_country` VALUES(162, 'Miscellaneous (French)', '--', '--', '--', 0, '--', '', '', '', '', '', '', 0, 'ISO includes Bassas da India, Europa Island, Glorioso Islands, Juan de Nova Island, Tromelin Island');
INSERT INTO `geo_country` VALUES(163, 'Moldova', 'MD', 'MD', 'MDA', 498, 'MD', 'Chisinau', 'Commonwealth of Independent States', 'Moldovan', 'Moldovans', 'Moldovan Leu', 'MDL', 4.43157e+06, '');
INSERT INTO `geo_country` VALUES(164, 'Monaco', 'MN', 'MC', 'MCO', 492, 'MC', 'Monaco', 'Europe', 'Monegasque', 'Monegasques', 'Euro', 'EUR', 31842, '');
INSERT INTO `geo_country` VALUES(165, 'Mongolia', 'MG', 'MN', 'MNG', 496, 'MN', 'Ulaanbaatar', 'Asia', 'Mongolian', 'Mongolians', 'Tugrik', 'MNT', 2.655e+06, '');
INSERT INTO `geo_country` VALUES(166, 'Montenegro', '--', '--', '--', 0, '--', '', '', '', '', '', '', 0, 'now included as region within Yugoslavia');
INSERT INTO `geo_country` VALUES(167, 'Montserrat', 'MH', 'MS', 'MSR', 500, 'MS', 'Plymouth', 'Central America and the Caribbean', 'Montserratian', 'Montserratians', 'East Caribbean Dollar', 'XCD', 7574, '');
INSERT INTO `geo_country` VALUES(168, 'Morocco', 'MO', 'MA', 'MAR', 504, 'MA', 'Rabat', 'Africa', 'Moroccan', 'Moroccans', 'Moroccan Dirham', 'MAD', 3.06453e+07, '');
INSERT INTO `geo_country` VALUES(169, 'Mozambique', 'MZ', 'MZ', 'MOZ', 508, 'MZ', 'Maputo', 'Africa', 'Mozambican', 'Mozambicans', 'Metical', 'MZM', 1.93711e+07, '');
INSERT INTO `geo_country` VALUES(170, 'Myanmar', '--', '--', '--', 0, '--', '', '', '', '', 'Kyat', 'MMK', 0, 'see Burma');
INSERT INTO `geo_country` VALUES(171, 'Namibia', 'WA', 'NA', 'NAM', 516, 'NA', 'Windhoek', 'Africa', 'Namibian', 'Namibians', 'Namibian Dollar', 'NAD', 1.79768e+06, '');
INSERT INTO `geo_country` VALUES(172, 'Nauru', 'NR', 'NR', 'NRU', 520, 'NR', '', 'Oceania', 'Nauruan', 'Nauruans', 'Australian Dollar', 'AUD', 12088, '');
INSERT INTO `geo_country` VALUES(173, 'Navassa Island', 'BQ', '--', '--', 0, '--', '', 'Central America and the Caribbean', '', '', '', '', 0, '');
INSERT INTO `geo_country` VALUES(174, 'Nepal', 'NP', 'NP', 'NPL', 524, 'NP', 'Kathmandu', 'Asia', 'Nepalese', 'Nepalese', 'Nepalese Rupee', 'NPR', 2.52845e+07, '');
INSERT INTO `geo_country` VALUES(175, 'Netherlands', 'NL', 'NL', 'NLD', 528, 'NL', 'Amsterdam', 'Europe', 'Dutchman', 'Dutchmen', 'Euro', 'EUR', 1.59815e+07, '');
INSERT INTO `geo_country` VALUES(176, 'Netherlands Antilles', 'NT', 'AN', 'ANT', 530, 'AN', 'Willemstad', 'Central America and the Caribbean', 'Dutch Antillean', 'Dutch Antilleans', 'Netherlands Antillean guilder', 'ANG', 212226, '');
INSERT INTO `geo_country` VALUES(177, 'New Caledonia', 'NC', 'NC', 'NCL', 540, 'NC', 'Noumea', 'Oceania', 'New Caledonian', 'New Caledonians', 'CFP Franc', 'XPF', 204863, '');
INSERT INTO `geo_country` VALUES(178, 'New Zealand', 'NZ', 'NZ', 'NZL', 554, 'NZ', 'Wellington', 'Oceania', 'New Zealand', 'New Zealanders', 'New Zealand Dollar', 'NZD', 3.86413e+06, '');
INSERT INTO `geo_country` VALUES(179, 'Nicaragua', 'NU', 'NI', 'NIC', 558, 'NI', 'Managua', 'Central America and the Caribbean', 'Nicaraguan', 'Nicaraguans', 'Cordoba Oro', 'NIO', 4.91839e+06, '');
INSERT INTO `geo_country` VALUES(180, 'Niger', 'NG', 'NE', 'NER', 562, 'NE', 'Niamey', 'Africa', 'Nigerien', 'Nigeriens', 'CFA Franc BCEAO', 'XOF', 1.03552e+07, '');
INSERT INTO `geo_country` VALUES(181, 'Nigeria', 'NI', 'NG', 'NGA', 566, 'NG', 'Abuja', 'Africa', 'Nigerian', 'Nigerians', 'Naira', 'NGN', 1.26636e+08, '');
INSERT INTO `geo_country` VALUES(182, 'Niue', 'NE', 'NU', 'NIU', 570, 'NU', 'Alofi', 'Oceania', 'Niuean', 'Niueans', 'New Zealand Dollar', 'NZD', 2124, '');
INSERT INTO `geo_country` VALUES(183, 'Norfolk Island', 'NF', 'NF', 'NFK', 574, 'NF', 'Kingston', 'Oceania', 'Norfolk Islander', 'Norfolk Islanders', 'Australian Dollar', 'AUD', 1879, '');
INSERT INTO `geo_country` VALUES(184, 'Northern Mariana Islands', 'CQ', 'MP', 'MNP', 580, 'MP', 'Saipan', 'Oceania', '', '', 'US Dollar', 'USD', 74612, '');
INSERT INTO `geo_country` VALUES(185, 'Norway', 'NO', 'NO', 'NOR', 578, 'NO', 'Oslo', 'Europe', 'Norwegian', 'Norwegians', 'Norwegian Krone', 'NOK', 4.50344e+06, '');
INSERT INTO `geo_country` VALUES(186, 'Oman', 'MU', 'OM', 'OMN', 512, 'OM', 'Muscat', 'Middle East', 'Omani', 'Omanis', 'Rial Omani', 'OMR', 2.6222e+06, '');
INSERT INTO `geo_country` VALUES(187, 'Pakistan', 'PK', 'PK', 'PAK', 586, 'PK', 'Islamabad', 'Asia', 'Pakistani', 'Pakistanis', 'Pakistan Rupee', 'PKR', 1.44617e+08, '');
INSERT INTO `geo_country` VALUES(188, 'Palau', 'PS', 'PW', 'PLW', 585, 'PW', 'Koror', 'Oceania', 'Palauan', 'Palauans', 'US Dollar', 'USD', 19092, '');
INSERT INTO `geo_country` VALUES(189, 'Palmyra Atoll', 'LQ', '--', '--', 0, '--', '', 'Oceania', '', '', '', '', 0, 'ISO includes with the US Minor Outlying Islands');
INSERT INTO `geo_country` VALUES(190, 'Panama', 'PM', 'PA', 'PAN', 591, 'PA', 'Panama', 'Central America and the Caribbean', 'Panamanian', 'Panamanians', 'balboa', 'PAB', 2.84565e+06, '');
INSERT INTO `geo_country` VALUES(191, 'Papua New Guinea', 'PP', 'PG', 'PNG', 598, 'PG', 'Port Moresby', 'Oceania', 'Papua New Guinean', 'Papua New Guineans', 'Kina', 'PGK', 5.04906e+06, '');
INSERT INTO `geo_country` VALUES(192, 'Paracel Islands', 'PF', '--', '--', 0, '--', '', 'Southeast Asia', '', '', '', '', 0, '');
INSERT INTO `geo_country` VALUES(193, 'Paraguay', 'PA', 'PY', 'PRY', 600, 'PY', 'Asuncion', 'South America', 'Paraguayan', 'Paraguayans', 'Guarani', 'PYG', 5.73414e+06, '');
INSERT INTO `geo_country` VALUES(194, 'Peru', 'PE', 'PE', 'PER', 604, 'PE', 'Lima', 'South America', 'Peruvian', 'Peruvians', 'Nuevo Sol', 'PEN', 2.74839e+07, '');
INSERT INTO `geo_country` VALUES(195, 'Philippines', 'RP', 'PH', 'PHL', 608, 'PH', 'Manila', 'Southeast Asia', 'Philippine', 'Filipinos', 'Philippine Peso', 'PHP', 8.28415e+07, '');
INSERT INTO `geo_country` VALUES(196, 'Pitcairn Islands', 'PC', 'PN', 'PCN', 612, 'PN', 'Adamstown', 'Oceania', 'Pitcairn Islander', 'Pitcairn Islanders', 'New Zealand Dollar', 'NZD', 47, '');
INSERT INTO `geo_country` VALUES(197, 'Poland', 'PL', 'PL', 'POL', 616, 'PL', 'Warsaw', 'Europe', 'Polish', 'Poles', 'Zloty', 'PLN', 3.86339e+07, '');
INSERT INTO `geo_country` VALUES(198, 'Portugal', 'PO', 'PT', 'PRT', 620, 'PT', 'Lisbon', 'Europe', 'Portuguese', 'Portuguese', 'Euro', 'EUR', 1.00663e+07, '');
INSERT INTO `geo_country` VALUES(199, 'Puerto Rico', 'RQ', 'PR', 'PRI', 630, 'PR', 'San Juan', 'Central America and the Caribbean', 'Puerto Rican', 'Puerto Ricans', 'US Dollar', 'USD', 3.93732e+06, '');
INSERT INTO `geo_country` VALUES(200, 'Qatar', 'QA', 'QA', 'QAT', 634, 'QA', 'Doha', 'Middle East', 'Qatari', 'Qataris', 'Qatari Rial', 'QAR', 769152, '');
INSERT INTO `geo_country` VALUES(201, 'R?union', 'RE', 'RE', 'REU', 638, 'RE', 'Saint-Denis', 'World', 'Reunionese', 'Reunionese', 'Euro', 'EUR', 732570, '');
INSERT INTO `geo_country` VALUES(202, 'Romania', 'RO', 'RO', 'ROU', 642, 'RO', 'Bucharest', 'Europe', 'Romanian', 'Romanians', 'Leu', 'ROL', 2.2364e+07, '');
INSERT INTO `geo_country` VALUES(203, 'Russia', 'RS', 'RU', 'RUS', 643, 'RU', 'Moscow', 'Asia', 'Russian', 'Russians', 'Russian Ruble', 'RUB', 1.4547e+08, '');
INSERT INTO `geo_country` VALUES(204, 'Rwanda', 'RW', 'RW', 'RWA', 646, 'RW', 'Kigali', 'Africa', 'Rwandan', 'Rwandans', 'Rwanda Franc', 'RWF', 7.31276e+06, '');
INSERT INTO `geo_country` VALUES(205, 'Saint Helena', 'SH', 'SH', 'SHN', 654, 'SH', 'Jamestown', 'Africa', 'Saint Helenian', 'Saint Helenians', 'Saint Helenian Pound', 'SHP', 7266, '');
INSERT INTO `geo_country` VALUES(206, 'Saint Kitts and Nevis', 'SC', 'KN', 'KNA', 659, 'KN', 'Basseterre', 'Central America and the Caribbean', 'Kittitian and Nevisian', 'Kittitians and Nevisians', 'East Caribbean Dollar', 'XCD', 38756, '');
INSERT INTO `geo_country` VALUES(207, 'Saint Lucia', 'ST', 'LC', 'LCA', 662, 'LC', 'Castries', 'Central America and the Caribbean', 'Saint Lucian', 'Saint Lucians', 'East Caribbean Dollar', 'XCD', 158178, '');
INSERT INTO `geo_country` VALUES(208, 'Saint Pierre and Miquelon', 'SB', 'PM', 'SPM', 666, 'PM', 'Saint-Pierre', 'North America', 'Frenchman', 'Frenchmen', 'Euro', 'EUR', 6928, '');
INSERT INTO `geo_country` VALUES(209, 'Saint Vincent and the Grenadines', 'VC', 'VC', 'VCT', 670, 'VC', 'Kingstown', 'Central America and the Caribbean', 'Saint Vincentian', 'Saint Vincentians', 'East Caribbean Dollar', 'XCD', 115942, '');
INSERT INTO `geo_country` VALUES(210, 'Samoa', 'WS', 'WS', 'WSM', 882, 'WS', 'Apia', 'Oceania', 'Samoan', 'Samoans', 'Tala', 'WST', 179058, 'NULL');
INSERT INTO `geo_country` VALUES(211, 'San Marino', 'SM', 'SM', 'SMR', 674, 'SM', 'San Marino', 'Europe', 'Sammarinese', 'Sammarinese', 'Euro', 'EUR', 27336, '');
INSERT INTO `geo_country` VALUES(212, 'S?o Tom? and Pr?ncipe', 'TP', 'ST', 'STP', 678, 'ST', 'Sao Tome', 'Africa', 'Sao Tomean', 'Sao Tomeans', 'Dobra', 'STD', 165034, '');
INSERT INTO `geo_country` VALUES(213, 'Saudi Arabia', 'SA', 'SA', 'SAU', 682, 'SA', 'Riyadh', 'Middle East', 'Saudi Arabian', 'Saudis', 'Saudi Riyal', 'SAR', 2.27571e+07, '');
INSERT INTO `geo_country` VALUES(214, 'Senegal', 'SG', 'SN', 'SEN', 686, 'SN', 'Dakar', 'Africa', 'Senegalese', 'Senegalese', 'CFA Franc BCEAO', 'XOF', 1.02849e+07, '');
INSERT INTO `geo_country` VALUES(215, 'Serbia', '--', '--', '--', 0, '--', '', '', '', '', '', '', 0, 'now included as region within Yugoslavia');
INSERT INTO `geo_country` VALUES(216, 'Serbia and Montenegro', '--', '--', '--', 0, '--', '', '', '', '', '', '', 0, 'See Yugoslavia');
INSERT INTO `geo_country` VALUES(217, 'Seychelles', 'SE', 'SC', 'SYC', 690, 'SC', 'Victoria', 'Africa', 'Seychellois', 'Seychellois', 'Seychelles Rupee', 'SCR', 79715, '');
INSERT INTO `geo_country` VALUES(218, 'Sierra Leone', 'SL', 'SL', 'SLE', 694, 'SL', 'Freetown', 'Africa', 'Sierra Leonean', 'Sierra Leoneans', 'Leone', 'SLL', 5.42662e+06, '');
INSERT INTO `geo_country` VALUES(219, 'Singapore', 'SN', 'SG', 'SGP', 702, 'SG', 'Singapore', 'Southeast Asia', 'Singaporeian', 'Singaporeans', 'Singapore Dollar', 'SGD', 4.30042e+06, '');
INSERT INTO `geo_country` VALUES(220, 'Slovakia', 'LO', 'SK', 'SVK', 703, 'SK', 'Bratislava', 'Europe', 'Slovakian', 'Slovaks', 'Slovak Koruna', 'SKK', 5.41494e+06, '');
INSERT INTO `geo_country` VALUES(221, 'Slovenia', 'SI', 'SI', 'SVN', 705, 'SI', 'Ljubljana', 'Europe', 'Slovenian', 'Slovenes', 'Tolar', 'SIT', 1.93013e+06, '');
INSERT INTO `geo_country` VALUES(222, 'Solomon Islands', 'BP', 'SB', 'SLB', 90, 'SB', 'Honiara', 'Oceania', 'Solomon Islander', 'Solomon Islanders', 'Solomon Islands Dollar', 'SBD', 480442, '');
INSERT INTO `geo_country` VALUES(223, 'Somalia', 'SO', 'SO', 'SOM', 706, 'SO', 'Mogadishu', 'Africa', 'Somali', 'Somalis', 'Somali Shilling', 'SOS', 7.48877e+06, '');
INSERT INTO `geo_country` VALUES(224, 'South Africa', 'SF', 'ZA', 'ZAF', 710, 'ZA', 'Pretoria', 'Africa', 'South African', 'South Africans', 'Rand', 'ZAR', 4.35861e+07, '');
INSERT INTO `geo_country` VALUES(225, 'South Georgia and the South Sandwich Islands', 'SX', 'GS', 'SGS', 239, 'GS', '', 'Antarctic Region', '', '', 'Pound Sterling', 'GBP', 0, '');
INSERT INTO `geo_country` VALUES(226, 'Spain', 'SP', 'ES', 'ESP', 724, 'ES', 'Madrid', 'Europe', 'Spanish', 'Spaniards', 'Euro', 'EUR', 4.0038e+07, '');
INSERT INTO `geo_country` VALUES(227, 'Spratly Islands', 'PG', '--', '--', 0, '--', '', 'Southeast Asia', '', '', '', '', 0, '');
INSERT INTO `geo_country` VALUES(228, 'Sri Lanka', 'CE', 'LK', 'LKA', 144, 'LK', 'Colombo', 'Asia', 'Sri Lankan', 'Sri Lankans', 'Sri Lanka Rupee', 'LKR', 1.94086e+07, '');
INSERT INTO `geo_country` VALUES(229, 'Sudan', 'SU', 'SD', 'SDN', 736, 'SD', 'Khartoum', 'Africa', 'Sudanese', 'Sudanese', 'Sudanese Dinar', 'SDD', 3.60804e+07, '');
INSERT INTO `geo_country` VALUES(230, 'Suriname', 'NS', 'SR', 'SUR', 740, 'SR', 'Paramaribo', 'South America', 'Surinamese', 'Surinamers', 'Suriname Guilder', 'SRG', 433998, '');
INSERT INTO `geo_country` VALUES(231, 'Svalbard', 'SV', 'SJ', 'SJM', 744, 'SJ', 'Longyearbyen', 'Arctic Region', '', '', 'Norwegian Krone', 'NOK', 2332, 'ISO includes Jan Mayen');
INSERT INTO `geo_country` VALUES(232, 'Swaziland', 'WZ', 'SZ', 'SWZ', 748, 'SZ', 'Mbabane', 'Africa', 'Swazi', 'Swazis', 'Lilangeni', 'SZL', 1.10434e+06, '');
INSERT INTO `geo_country` VALUES(233, 'Sweden', 'SW', 'SE', 'SWE', 752, 'SE', 'Stockholm', 'Europe', 'Swedish', 'Swedes', 'Swedish Krona', 'SEK', 8.87505e+06, '');
INSERT INTO `geo_country` VALUES(234, 'Switzerland', 'SZ', 'CH', 'CHE', 756, 'CH', 'Bern', 'Europe', 'Swiss', 'Swiss', 'Swiss Franc', 'CHF', 7.28327e+06, '');
INSERT INTO `geo_country` VALUES(235, 'Syria', 'SY', 'SY', 'SYR', 760, 'SY', 'Damascus', 'Middle East', 'Syrian', 'Syrians', 'Syrian Pound', 'SYP', 1.67288e+07, '');
INSERT INTO `geo_country` VALUES(236, 'Taiwan', 'TW', 'TW', 'TWN', 158, 'TW', 'Taipei', 'Southeast Asia', 'Chinese', 'Chinese', 'New Taiwan Dollar', 'TWD', 2.23705e+07, '');
INSERT INTO `geo_country` VALUES(237, 'Tajikistan', 'TI', 'TJ', 'TJK', 762, 'TJ', 'Dushanbe', 'Commonwealth of Independent States', 'Tajikistani', 'Tajikistanis', 'Somoni', 'TJS', 6.57868e+06, '');
INSERT INTO `geo_country` VALUES(238, 'Tanzania', 'TZ', 'TZ', 'TZA', 834, 'TZ', 'Dar es Salaam', 'Africa', 'Tanzanian', 'Tanzanians', 'Tanzanian Shilling', 'TZS', 3.62321e+07, '');
INSERT INTO `geo_country` VALUES(239, 'Thailand', 'TH', 'TH', 'THA', 764, 'TH', 'Bangkok', 'Southeast Asia', 'Thai', 'Thai', 'Baht', 'THB', 6.17978e+07, '');
INSERT INTO `geo_country` VALUES(240, 'Togo', 'TO', 'TG', 'TGO', 768, 'TG', 'Lome', 'Africa', 'Togolese', 'Togolese', 'CFA Franc BCEAO', 'XOF', 5.15309e+06, '');
INSERT INTO `geo_country` VALUES(241, 'Tokelau', 'TL', 'TK', 'TKL', 772, 'TK', '', 'Oceania', 'Tokelauan', 'Tokelauans', 'New Zealand Dollar', 'NZD', 1445, '');
INSERT INTO `geo_country` VALUES(242, 'Tonga', 'TN', 'TO', 'TON', 776, 'TO', 'Nuku''alofa', 'Oceania', 'Tongan', 'Tongans', 'Pa''anga', 'TOP', 104227, '');
INSERT INTO `geo_country` VALUES(243, 'Trinidad and Tobago', 'TD', 'TT', 'TTO', 780, 'TT', 'Port-of-Spain', 'Central America and the Caribbean', 'Trinidadian and Tobagonian', 'Trinidadians and Tobagonians', 'Trinidad and Tobago Dollar', 'TTD', 1.16968e+06, '');
INSERT INTO `geo_country` VALUES(244, 'Tromelin Island', 'TE', '--', '--', 0, '--', '', 'Africa', '', '', '', '', 0, 'ISO includes with the Miscellaneous (French) Indian Ocean Islands');
INSERT INTO `geo_country` VALUES(245, 'Tunisia', 'TS', 'TN', 'TUN', 788, 'TN', 'Tunis', 'Africa', 'Tunisian', 'Tunisians', 'Tunisian Dinar', 'TND', 9.7051e+06, '');
INSERT INTO `geo_country` VALUES(246, 'Turkey', 'TU', 'TR', 'TUR', 792, 'TR', 'Ankara', 'Middle East', 'Turkish', 'Turks', 'Turkish Lira', 'TRL', 6.6494e+07, '');
INSERT INTO `geo_country` VALUES(247, 'Turkmenistan', 'TX', 'TM', 'TKM', 795, 'TM', 'Ashgabat', 'Commonwealth of Independent States', 'Turkmen', 'Turkmens', 'Manat', 'TMM', 4.60324e+06, '');
INSERT INTO `geo_country` VALUES(248, 'Turks and Caicos Islands', 'TK', 'TC', 'TCA', 796, 'TC', 'Cockburn Town', 'Central America and the Caribbean', '', '', 'US Dollar', 'USD', 18122, '');
INSERT INTO `geo_country` VALUES(249, 'Tuvalu', 'TV', 'TV', 'TUV', 798, 'TV', 'Funafuti', 'Oceania', 'Tuvaluan', 'Tuvaluans', 'Australian Dollar', 'AUD', 10991, '');
INSERT INTO `geo_country` VALUES(250, 'Uganda', 'UG', 'UG', 'UGA', 800, 'UG', 'Kampala', 'Africa', 'Ugandan', 'Ugandans', 'Uganda Shilling', 'UGX', 2.39857e+07, '');
INSERT INTO `geo_country` VALUES(251, 'Ukraine', 'UP', 'UA', 'UKR', 804, 'UA', 'Kiev', 'Commonwealth of Independent States', 'Ukrainian', 'Ukrainians', 'Hryvnia', 'UAH', 4.87605e+07, '');
INSERT INTO `geo_country` VALUES(252, 'United Arab Emirates', 'AE', 'AE', 'ARE', 784, 'AE', 'Abu Dhabi', 'Middle East', 'Emirati', 'Emiratis', 'UAE Dirham', 'AED', 2.40746e+06, '');
INSERT INTO `geo_country` VALUES(253, 'United Kingdom', 'UK', 'GB', 'GBR', 826, 'UK', 'London', 'Europe', 'British', 'Britons', 'Pound Sterling', 'GBP', 5.96478e+07, 'ISO includes Guernsey, Isle of Man, Jersey');
INSERT INTO `geo_country` VALUES(254, 'United States', 'US', 'US', 'USA', 840, 'US', 'Washington', 'North America', 'American', 'Americans', 'US Dollar', 'USD', 2.78059e+08, '');
INSERT INTO `geo_country` VALUES(255, 'United States Minor Outlying Islands', '--', 'UM', 'UMI', 581, 'UM', '', '', '', '', 'US Dollar', 'USD', 0, 'ISO includes Baker Island, Howland Island, Jarvis Island, Johnston Atoll, Kingman Reef, Midway Islan');
INSERT INTO `geo_country` VALUES(256, 'Uruguay', 'UY', 'UY', 'URY', 858, 'UY', 'Montevideo', 'South America', 'Uruguayan', 'Uruguayans', 'Peso Uruguayo', 'UYU', 3.3601e+06, '');
INSERT INTO `geo_country` VALUES(257, 'Uzbekistan', 'UZ', 'UZ', 'UZB', 860, 'UZ', 'Tashkent', 'Commonwealth of Independent States', 'Uzbekistani', 'Uzbekistanis', 'Uzbekistan Sum', 'UZS', 2.51551e+07, '');
INSERT INTO `geo_country` VALUES(258, 'Vanuatu', 'NH', 'VU', 'VUT', 548, 'VU', 'Port-Vila', 'Oceania', 'Ni-Vanuatu', 'Ni-Vanuatu', 'Vatu', 'VUV', 192910, '');
INSERT INTO `geo_country` VALUES(259, 'Venezuela', 'VE', 'VE', 'VEN', 862, 'VE', 'Caracas', 'South America, Central America and the Caribbean', 'Venezuelan', 'Venezuelans', 'Bolivar', 'VEB', 2.39168e+07, '');
INSERT INTO `geo_country` VALUES(260, 'Vietnam', 'VM', 'VN', 'VNM', 704, 'VN', 'Hanoi', 'Southeast Asia', 'Vietnamese', 'Vietnamese', 'Dong', 'VND', 7.9939e+07, '');
INSERT INTO `geo_country` VALUES(261, 'Virgin Islands', 'VQ', 'VI', 'VIR', 850, 'VI', 'Charlotte Amalie', 'Central America and the Caribbean', 'Virgin Islander', 'Virgin Islanders', 'US Dollar', 'USD', 122211, '');
INSERT INTO `geo_country` VALUES(262, 'Virgin Islands (UK)', '--', '--', '--', 0, '--', '', '', '', '', 'US Dollar', 'USD', 0, 'see British Virgin Islands');
INSERT INTO `geo_country` VALUES(263, 'Virgin Islands (US)', '--', '--', '--', 0, '--', '', '', '', '', 'US Dollar', 'USD', 0, 'see Virgin Islands');
INSERT INTO `geo_country` VALUES(264, 'Wake Island', 'WQ', '--', '--', 0, '--', '', 'Oceania', '', '', 'US Dollar', 'USD', 0, 'ISO includes with the US Minor Outlying Islands');
INSERT INTO `geo_country` VALUES(265, 'Wallis and Futuna', 'WF', 'WF', 'WLF', 876, 'WF', 'Mata-Utu', 'Oceania', 'Wallis and Futuna Islander', 'Wallis and Futuna Islanders', 'CFP Franc', 'XPF', 15435, '');
INSERT INTO `geo_country` VALUES(266, 'West Bank', 'WE', '--', '--', 0, '--', '', 'Middle East', '', '', 'New Israeli Shekel', 'ILS', 2.09071e+06, '');
INSERT INTO `geo_country` VALUES(267, 'Western Sahara', 'WI', 'EH', 'ESH', 732, 'EH', '', 'Africa', 'Sahrawian', 'Sahrawis', 'Moroccan Dirham', 'MAD', 250559, '');
INSERT INTO `geo_country` VALUES(268, 'Western Samoa', '--', '--', '--', 0, '--', '', '', '', '', 'Tala', 'WST', 0, 'see Samoa');
INSERT INTO `geo_country` VALUES(269, 'World', '--', '--', '--', 0, '--', '', 'World, Time Zones', '', '', '', '', 6.1574e+09, 'NULL');
INSERT INTO `geo_country` VALUES(270, 'Yemen', 'YM', 'YE', 'YEM', 887, 'YE', 'Sanaa', 'Middle East', 'Yemeni', 'Yemenis', 'Yemeni Rial', 'YER', 1.8078e+07, '');
INSERT INTO `geo_country` VALUES(271, 'Yugoslavia', 'YI', 'YU', 'YUG', 891, 'YU', 'Belgrade', 'Europe', 'Serbian', 'Serbs', 'Yugoslavian Dinar', 'YUM', 1.06773e+07, 'NULL');
INSERT INTO `geo_country` VALUES(272, 'Zaire', '--', '--', '--', 0, '--', '', '', '', '', '', '', 0, 'see Democratic Republic of the Congo');
INSERT INTO `geo_country` VALUES(273, 'Zambia', 'ZA', 'ZM', 'ZWB', 894, 'ZM', 'Lusaka', 'Africa', 'Zambian', 'Zambians', 'Kwacha', 'ZMK', 9.7702e+06, '');
INSERT INTO `geo_country` VALUES(274, 'Zimbabwe', 'ZI', 'ZW', 'ZWE', 716, 'ZW', 'Harare', 'Africa', 'Zimbabwean', 'Zimbabweans', 'Zimbabwe Dollar', 'ZWD', 1.13654e+07, '');
INSERT INTO `geo_country` VALUES(275, 'Palestinian Territory, Occupied', '--', 'PS', 'PSE', 275, 'PS', '', '', '', '', '', '', 0, 'NULL');

Labels: database

mathie's tech+business bits

Sunday, May 25, 2008

MySQL database of geographical countries

1 Comments:

Links

Source Code

Support This Blog

Previous Posts