mathie's tech+business bits

Sunday, May 25, 2008

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

MySQL database for geographical regions

Full file: uploads/georegions.txt

Labels: database

Geographical city MySQL database

CREATE TABLE `geo_city` (
  `CityId` int(10) unsigned NOT NULL default '0',
  `CountryId` int(10) unsigned NOT NULL default '0',
  `RegionId` int(10) unsigned NOT NULL default '0',
  `City` varchar(100) NOT NULL default '',
  `Latitude` float NOT NULL default '0',
  `Longitude` float NOT NULL default '0',
  `TimeZone` varchar(6) NOT NULL default '',
  `DmaId` int(10) unsigned NOT NULL default '0',
  `Code` varchar(5) NOT NULL default '',
  PRIMARY KEY  (`CityId`),
  KEY `CountryId` (`CountryId`),
  KEY `RegionId` (`RegionId`),
  KEY `City` (`City`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Cities from GeoBytes';

--
-- Dumping data for table `geo_city`
--

INSERT INTO `geo_city` VALUES(27239, 254, 124, 'Gray Mountain', 35.8756, -111.412, '-07:00', 753, 'GMOU');
INSERT INTO `geo_city` VALUES(35786, 254, 148, 'Rapelje', 45.9932, -109.288, '-07:00', 756, 'RAPE');
INSERT INTO `geo_city` VALUES(4354, 122, 2329, 'Tamana', 32.917, 130.567, '+09:00', 0, 'TAMA');
INSERT INTO `geo_city` VALUES(13343, 254, 144, 'Croswell', 43.2651, -82.6467, '-05:00', 505, 'CROS');
INSERT INTO `geo_city` VALUES(39829, 254, 146, 'Vardaman', 33.9472, -89.1968, '-06:00', 673, 'VARD');
INSERT INTO `geo_city` VALUES(39933, 254, 144, 'Vicksburg', 42.1149, -85.4789, '-05:00', 563, 'VICK');
INSERT INTO `geo_city` VALUES(21609, 254, 137, 'Bryant', 41.9723, -90.3407, '-06:00', 682, 'BRYA');
INSERT INTO `geo_city` VALUES(29400, 254, 134, 'Kellogg', 47.7187, -116.088, '-08:00', 881, 'KELL');
INSERT INTO `geo_city` VALUES(38484, 254, 152, 'Stockton', 40.4365, -74.9753, '-05:00', 501, 'STOC');
INSERT INTO `geo_city` VALUES(7528, 254, 127, 'Akron', 40.1266, -103.261, '-07:00', 751, 'AKRO');

Full File: uploads/geocities.txt

Labels: database

Saturday, December 22, 2007

US zipcode database in SQL format

Don't remember where I got this file, but might be useful for some: us.zipcodes.sql

Labels: database

Monday, February 12, 2007

SQL World Cities Database

Some data sets about world cities we no longer use

-- Generation Time: Feb 13, 2007 at 02:12 AM

CREATE TABLE cities (
  ID int(11) NOT NULL auto_increment,
  Name char(35) NOT NULL default '',
  CountryCode char(3) NOT NULL default '',
  District char(20) NOT NULL default '',
  Population int(11) NOT NULL default '0',
  PRIMARY KEY  (ID)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

INSERT INTO cities VALUES (1,'Kabul','AFG','Kabol', 1780000);
INSERT INTO cities VALUES (2,'Qandahar','AFG','Qandahar', 237500);
INSERT INTO cities VALUES (3,'Herat','AFG','Herat', 186800);
INSERT INTO cities VALUES (4,'Mazar-e-Sharif','AFG','Balkh', 127800);
INSERT INTO cities VALUES (5,'Amsterdam','NLD','Noord-Holland', 731200);
INSERT INTO cities VALUES (6,'Rotterdam','NLD','Zuid-Holland', 593321);
INSERT INTO cities VALUES (7,'Haag','NLD','Zuid-Holland', 440900);
INSERT INTO cities VALUES (8,'Utrecht','NLD','Utrecht', 234323);
INSERT INTO cities VALUES (9,'Eindhoven','NLD','Noord-Brabant', 201843);
INSERT INTO cities VALUES (10,'Tilburg','NLD','Noord-Brabant', 193238);
INSERT INTO cities VALUES (30,'Delft','NLD','Zuid-Holland', 95268);
INSERT INTO cities VALUES (31,'Heerlen','NLD','Limburg', 95052);
INSERT INTO cities VALUES (32,'Alkmaar','NLD','Noord-Holland', 92713);
INSERT INTO cities VALUES (33,'Willemstad','ANT','Curaçao', 2345);
INSERT INTO cities VALUES (50,'Tiaret','DZA','Tiaret', 100118);
INSERT INTO cities VALUES (51,'Ech-Chleff (el-Asnam)','DZA','Chlef', 96794);
INSERT INTO cities VALUES (52,'Ghardaïa','DZA','Ghardaïa', 89415);
INSERT INTO cities VALUES (53,'Tafuna','ASM','Tutuila', 5200);
INSERT INTO cities VALUES (54,'Fagatogo','ASM','Tutuila', 2323);
INSERT INTO cities VALUES (55,'Andorra la Vella','AND','Andorra la Vella', 21189);
INSERT INTO cities VALUES (56,'Luanda','AGO','Luanda', 2022000);
INSERT INTO cities VALUES (57,'Huambo','AGO','Huambo', 163100);
INSERT INTO cities VALUES (58,'Lobito','AGO','Benguela', 130000);
INSERT INTO cities VALUES (59,'Benguela','AGO','Benguela', 128300);
INSERT INTO cities VALUES (60,'Namibe','AGO','Namibe', 118200);
INSERT INTO cities VALUES (61,'South Hill','AIA','–', 961);
INSERT INTO cities VALUES (62,'The Valley','AIA','–', 595);
INSERT INTO cities VALUES (63,'Saint John´s','ATG','St John', 24000);
INSERT INTO cities VALUES (64,'Dubai','ARE','Dubai', 669181);
INSERT INTO cities VALUES (65,'Abu Dhabi','ARE','Abu Dhabi', 398695);
INSERT INTO cities VALUES (66,'Sharja','ARE','Sharja', 320095);
INSERT INTO cities VALUES (67,'al-Ayn','ARE','Abu Dhabi', 225970);
INSERT INTO cities VALUES (68,'Ajman','ARE','Ajman', 114395);
INSERT INTO cities VALUES (81,'General San Martín','ARG','Buenos Aires', 422542);
INSERT INTO cities VALUES (82,'Salta','ARG','Salta', 367550);
INSERT INTO cities VALUES (83,'Moreno','ARG','Buenos Aires', 356993);
INSERT INTO cities VALUES (84,'Santa Fé','ARG','Santa Fé', 353063);
INSERT INTO cities VALUES (85,'Avellaneda','ARG','Buenos Aires', 353046);
INSERT INTO cities VALUES (86,'Tres de Febrero','ARG','Buenos Aires', 352311);
INSERT INTO cities VALUES (87,'Morón','ARG','Buenos Aires', 349246);
INSERT INTO cities VALUES (88,'Florencio Varela','ARG','Buenos Aires', 315432);
INSERT INTO cities VALUES (89,'San Isidro','ARG','Buenos Aires', 306341);
INSERT INTO cities VALUES (90,'Tigre','ARG','Buenos Aires', 296226);
INSERT INTO cities VALUES (91,'Malvinas Argentinas','ARG','Buenos Aires', 290335);
INSERT INTO cities VALUES (92,'Vicente López','ARG','Buenos Aires', 288341);
INSERT INTO cities VALUES (93,'Berazategui','ARG','Buenos Aires', 276916);
INSERT INTO cities VALUES (94,'Corrientes','ARG','Corrientes', 258103);
INSERT INTO cities VALUES (95,'San Miguel','ARG','Buenos Aires', 248700);
INSERT INTO cities VALUES (96,'Bahía Blanca','ARG','Buenos Aires', 239810);
INSERT INTO cities VALUES (97,'Esteban Echeverría','ARG','Buenos Aires', 235760);
INSERT INTO cities VALUES (98,'Resistencia','ARG','Chaco', 229212);
INSERT INTO cities VALUES (99,'José C. Paz','ARG','Buenos Aires', 221754);
INSERT INTO cities VALUES (115,'Comodoro Rivadavia','ARG','Chubut', 124104);
INSERT INTO cities VALUES (116,'Mendoza','ARG','Mendoza', 123027);
INSERT INTO cities VALUES (117,'San Nicolás de los Arroyos','ARG','Buenos Aires', 119302);
INSERT INTO cities VALUES (118,'San Juan','ARG','San Juan', 119152);
INSERT INTO cities VALUES (119,'Escobar','ARG','Buenos Aires', 116675);
INSERT INTO cities VALUES (120,'Concordia','ARG','Entre Rios', 116485);
INSERT INTO cities VALUES (121,'Pilar','ARG','Buenos Aires', 113428);
INSERT INTO cities VALUES (122,'San Luis','ARG','San Luis', 110136);
INSERT INTO cities VALUES (123,'Ezeiza','ARG','Buenos Aires', 99578);
INSERT INTO cities VALUES (124,'San Rafael','ARG','Mendoza', 94651);
INSERT INTO cities VALUES (125,'Tandil','ARG','Buenos Aires', 91101);
INSERT INTO cities VALUES (126,'Yerevan','ARM','Yerevan', 1248700);
INSERT INTO cities VALUES (127,'Gjumri','ARM','Širak', 211700);
INSERT INTO cities VALUES (128,'Vanadzor','ARM','Lori', 172700);
INSERT INTO cities VALUES (129,'Oranjestad','ABW','–', 29034);
INSERT INTO cities VALUES (130,'Sydney','AUS','New South Wales', 3276207);
INSERT INTO cities VALUES (131,'Melbourne','AUS','Victoria', 2865329);
INSERT INTO cities VALUES (132,'Brisbane','AUS','Queensland', 1291117);
INSERT INTO cities VALUES (133,'Perth','AUS','West Australia', 1096829);
INSERT INTO cities VALUES (134,'Adelaide','AUS','South Australia', 978100);
INSERT INTO cities VALUES (135,'Canberra','AUS','Capital Region', 322723);
INSERT INTO cities VALUES (136,'Gold Coast','AUS','Queensland', 311932);
INSERT INTO cities VALUES (137,'Newcastle','AUS','New South Wales', 270324);
INSERT INTO cities VALUES (138,'Central Coast','AUS','New South Wales', 227657);
INSERT INTO cities VALUES (139,'Wollongong','AUS','New South Wales', 219761);
INSERT INTO cities VALUES (140,'Hobart','AUS','Tasmania', 126118);
INSERT INTO cities VALUES (141,'Geelong','AUS','Victoria', 125382);
INSERT INTO cities VALUES (142,'Townsville','AUS','Queensland', 109914);
INSERT INTO cities VALUES (143,'Cairns','AUS','Queensland', 92273);
INSERT INTO cities VALUES (144,'Baku','AZE','Baki', 1787800);
INSERT INTO cities VALUES (145,'Gäncä','AZE','Gäncä', 299300);
INSERT INTO cities VALUES (146,'Sumqayit','AZE','Sumqayit', 283000);
INSERT INTO cities VALUES (147,'Mingäçevir','AZE','Mingäçevir', 93900);
INSERT INTO cities VALUES (148,'Nassau','BHS','New Providence', 172000);
INSERT INTO cities VALUES (149,'al-Manama','BHR','al-Manama', 148000);
INSERT INTO cities VALUES (150,'Dhaka','BGD','Dhaka', 3612850);
INSERT INTO cities VALUES (151,'Chittagong','BGD','Chittagong', 1392860);
INSERT INTO cities VALUES (152,'Khulna','BGD','Khulna', 663340);
INSERT INTO cities VALUES (153,'Rajshahi','BGD','Rajshahi', 294056);
INSERT INTO cities VALUES (154,'Narayanganj','BGD','Dhaka', 202134);
INSERT INTO cities VALUES (155,'Rangpur','BGD','Rajshahi', 191398);
INSERT INTO cities VALUES (156,'Mymensingh','BGD','Dhaka', 188713);
INSERT INTO cities VALUES (157,'Barisal','BGD','Barisal', 170232);
INSERT INTO cities VALUES (158,'Tungi','BGD','Dhaka', 168702);
INSERT INTO cities VALUES (159,'Jessore','BGD','Khulna', 139710);
INSERT INTO cities VALUES (160,'Comilla','BGD','Chittagong', 135313);
INSERT INTO cities VALUES (161,'Nawabganj','BGD','Rajshahi', 130577);
INSERT INTO cities VALUES (162,'Dinajpur','BGD','Rajshahi', 127815);
INSERT INTO cities VALUES (163,'Bogra','BGD','Rajshahi', 120170);
INSERT INTO cities VALUES (164,'Sylhet','BGD','Sylhet', 117396);
INSERT INTO cities VALUES (165,'Brahmanbaria','BGD','Chittagong', 109032);
INSERT INTO cities VALUES (166,'Tangail','BGD','Dhaka', 106004);
INSERT INTO cities VALUES (167,'Jamalpur','BGD','Dhaka', 103556);
INSERT INTO cities VALUES (168,'Pabna','BGD','Rajshahi', 103277);
INSERT INTO cities VALUES (169,'Naogaon','BGD','Rajshahi', 101266);
INSERT INTO cities VALUES (170,'Sirajganj','BGD','Rajshahi', 99669);
INSERT INTO cities VALUES (171,'Narsinghdi','BGD','Dhaka', 98342);
INSERT INTO cities VALUES (172,'Saidpur','BGD','Rajshahi', 96777);
INSERT INTO cities VALUES (173,'Gazipur','BGD','Dhaka', 96717);
INSERT INTO cities VALUES (174,'Bridgetown','BRB','St Michael', 6070);
INSERT INTO cities VALUES (175,'Antwerpen','BEL','Antwerpen', 446525);
INSERT INTO cities VALUES (176,'Gent','BEL','East Flanderi', 224180);
INSERT INTO cities VALUES (177,'Charleroi','BEL','Hainaut', 200827);
INSERT INTO cities VALUES (178,'Liège','BEL','Liège', 185639);
INSERT INTO cities VALUES (179,'Bruxelles [Brussel]','BEL','Bryssel', 133859);
INSERT INTO cities VALUES (180,'Brugge','BEL','West Flanderi', 116246);
INSERT INTO cities VALUES (181,'Schaerbeek','BEL','Bryssel', 105692);
INSERT INTO cities VALUES (182,'Namur','BEL','Namur', 105419);
INSERT INTO cities VALUES (183,'Mons','BEL','Hainaut', 90935);
INSERT INTO cities VALUES (184,'Belize City','BLZ','Belize City', 55810);
INSERT INTO cities VALUES (185,'Belmopan','BLZ','Cayo', 7105);
INSERT INTO cities VALUES (186,'Cotonou','BEN','Atlantique', 536827);
INSERT INTO cities VALUES (187,'Porto-Novo','BEN','Ouémé', 194000);
INSERT INTO cities VALUES (188,'Djougou','BEN','Atacora', 134099);
INSERT INTO cities VALUES (189,'Parakou','BEN','Borgou', 103577);
INSERT INTO cities VALUES (190,'Saint George','BMU','Saint George´s', 1800);
INSERT INTO cities VALUES (191,'Hamilton','BMU','Hamilton', 1200);
INSERT INTO cities VALUES (192,'Thimphu','BTN','Thimphu', 22000);
INSERT INTO cities VALUES (193,'Santa Cruz de la Sierra','BOL','Santa Cruz', 935361);
INSERT INTO cities VALUES (194,'La Paz','BOL','La Paz', 758141);
INSERT INTO cities VALUES (195,'El Alto','BOL','La Paz', 534466);
INSERT INTO cities VALUES (196,'Cochabamba','BOL','Cochabamba', 482800);
INSERT INTO cities VALUES (197,'Oruro','BOL','Oruro', 223553);
INSERT INTO cities VALUES (198,'Sucre','BOL','Chuquisaca', 178426);
INSERT INTO cities VALUES (199,'Potosí','BOL','Potosí', 140642);
INSERT INTO cities VALUES (200,'Tarija','BOL','Tarija', 125255);
INSERT INTO cities VALUES (201,'Sarajevo','BIH','Federaatio', 360000);
INSERT INTO cities VALUES (202,'Banja Luka','BIH','Republika Srpska', 143079);
INSERT INTO cities VALUES (203,'Zenica','BIH','Federaatio', 96027);
INSERT INTO cities VALUES (204,'Gaborone','BWA','Gaborone', 213017);
INSERT INTO cities VALUES (205,'Francistown','BWA','Francistown', 101805);
INSERT INTO cities VALUES (206,'São Paulo','BRA','São Paulo', 9968485);
INSERT INTO cities VALUES (207,'Rio de Janeiro','BRA','Rio de Janeiro', 5598953);
INSERT INTO cities VALUES (208,'Salvador','BRA','Bahia', 2302832);
INSERT INTO cities VALUES (209,'Belo Horizonte','BRA','Minas Gerais', 2139125);
INSERT INTO cities VALUES (210,'Fortaleza','BRA','Ceará', 2097757);
INSERT INTO cities VALUES (211,'Brasília','BRA','Distrito Federal', 1969868);
INSERT INTO cities VALUES (212,'Curitiba','BRA','Paraná', 1584232);
INSERT INTO cities VALUES (213,'Recife','BRA','Pernambuco', 1378087);
INSERT INTO cities VALUES (214,'Porto Alegre','BRA','Rio Grande do Sul', 1314032);
INSERT INTO cities VALUES (215,'Manaus','BRA','Amazonas', 1255049);
INSERT INTO cities VALUES (216,'Belém','BRA','Pará', 1186926);
INSERT INTO cities VALUES (217,'Guarulhos','BRA','São Paulo', 1095874);
INSERT INTO cities VALUES (218,'Goiânia','BRA','Goiás', 1056330);
....

Full file: cities.txt

Labels: database

mathie's tech+business bits

Sunday, May 25, 2008

MySQL database of geographical countries

MySQL database for geographical regions

Geographical city MySQL database

Saturday, December 22, 2007

US zipcode database in SQL format

Monday, February 12, 2007

SQL World Cities Database

Links

Source Code

Support This Blog

Previous Posts

Archives