-- http://www.phpmyadmin.net
--
-- 服务器版本： 10.1.13-MariaDB




--
-- Database: `reach_dsp`
--

-- --------------------------------------------------------

--
-- 表的结构 `beacon_log`
--

CREATE TABLE `beacon_log` (
  `cid` int(11) NOT NULL,
  `mid` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `yymmddhh` int(11) NOT NULL,
  `times` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `bid_request_log`
--

CREATE TABLE `bid_request_log` (
  `ymdh` int(11) NOT NULL,
  `timestamp_hour` int(11) NOT NULL DEFAULT '0',
  `exchange` varchar(50) NOT NULL DEFAULT '',
  `request` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `bid_response_log`
--

CREATE TABLE `bid_response_log` (
  `uniqkey` varchar(32) NOT NULL,
  `ymdh` int(11) NOT NULL,
  `timestamp_hour` int(11) NOT NULL DEFAULT '0',
  `exchange` varchar(50) NOT NULL DEFAULT '',
  `publisher` varchar(255) NOT NULL DEFAULT '',
  `domain` varchar(255) NOT NULL DEFAULT '',
  `campaign_id` int(11) NOT NULL DEFAULT '0',
  `creative_id` int(11) NOT NULL DEFAULT '0',
  `bid` int(11) NOT NULL DEFAULT '0',
  `nurl` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `campaign`
--

CREATE TABLE `campaign` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `url` varchar(1024) NOT NULL DEFAULT '',
  `kind` varchar(255) NOT NULL DEFAULT '',
  `domain` varchar(255) NOT NULL,
  `track_urls_json` varchar(1024) NOT NULL DEFAULT '',
  `start_date` varchar(50) NOT NULL DEFAULT '',
  `end_date` varchar(50) NOT NULL DEFAULT '',
  `budget` double NOT NULL DEFAULT '0',
  `day_budget` double NOT NULL DEFAULT '0',
  `quarter_budget` double NOT NULL DEFAULT '0',
  `app_day_budget` double NOT NULL DEFAULT '0',
  `app_3day_budget` double NOT NULL DEFAULT '0',
  `bid_kind` enum('cpm','cpm_opt_ecpc','cpm_opt_ctr','cpm_opt_cpa','cpc') NOT NULL DEFAULT 'cpm',
  `bid_price` double NOT NULL DEFAULT '0',
  `status` enum('start','stop') NOT NULL DEFAULT 'stop',
  `frequency_kind` enum('infinite','by_ip','by_device') NOT NULL DEFAULT 'infinite',
  `frequency` int(11) NOT NULL DEFAULT '0',
  `frequency_interval_hour` int(11) NOT NULL DEFAULT '0',
  `bid_param_status` enum('close','open') NOT NULL DEFAULT 'close',
  `bid_params_json` varchar(1024) NOT NULL DEFAULT '',
  `impression` int(11) NOT NULL DEFAULT '0',
  `click` int(11) NOT NULL DEFAULT '0',
  `conversion` double NOT NULL DEFAULT '0',
  `ctr` double NOT NULL DEFAULT '0',
  `cr` double NOT NULL DEFAULT '0',
  `ecpc` double NOT NULL DEFAULT '0',
  `ecpm` double NOT NULL DEFAULT '0',
  `ecpa` double NOT NULL DEFAULT '0',
  `fee` double NOT NULL DEFAULT '0',
  `bid_success_ratio` double NOT NULL DEFAULT '0',
  `clear_frequency_hour_time` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- 表的结构 `campaign_click_log`
--

CREATE TABLE `campaign_click_log` (
  `id` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `mid` int(11) NOT NULL DEFAULT '0',
  `tid` int(11) NOT NULL DEFAULT '0',
  `device_idfa` varchar(50) NOT NULL DEFAULT '',
  `device_ip` varchar(50) NOT NULL,
  `joinup` varchar(255) NOT NULL DEFAULT '',
  `create_bigtime` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `campaign_filter`
--

CREATE TABLE `campaign_filter` (
  `id` int(11) NOT NULL,
  `campaign_id` int(11) NOT NULL,
  `country_filter_type` enum('include','exclude','close') NOT NULL DEFAULT 'close',
  `country_filters_json` mediumtext NOT NULL,
  `city_filter_type` enum('include','exclude','close') NOT NULL DEFAULT 'close',
  `city_filters_json` mediumtext NOT NULL,
  `iab_filter_type` enum('include','exclude','close') NOT NULL DEFAULT 'close',
  `iab_filters_json` mediumtext NOT NULL,
  `os_filter_type` enum('include','exclude','close') NOT NULL DEFAULT 'close',
  `os_filters_json` mediumtext NOT NULL,
  `osv_filter_type` enum('close','include','exclude','') NOT NULL DEFAULT 'close',
  `osv_filters_json` mediumtext NOT NULL,
  `devicebrand_filter_type` enum('include','exclude','close') NOT NULL DEFAULT 'close',
  `devicebrand_filters_json` mediumtext NOT NULL,
  `devicetype` int(11) NOT NULL DEFAULT '1',
  `language_filter_type` enum('include','exclude','close') NOT NULL DEFAULT 'close',
  `language_filters_json` mediumtext NOT NULL,
  `wapbrowser_filter_type` enum('include','exclude','close') NOT NULL DEFAULT 'close',
  `wapbrowser_filters_json` mediumtext NOT NULL,
  `connectiontype` int(11) NOT NULL DEFAULT '0',
  `gender` enum('','M','F') NOT NULL,
  `iprange_filter_type` enum('include','exclude','close') NOT NULL DEFAULT 'close',
  `iprange_json` mediumtext NOT NULL,
  `exchange_filter_type` enum('close','include','exclude') NOT NULL DEFAULT 'close',
  `exchange_filters_json` mediumtext NOT NULL,
  `publisher_filter_type` enum('include','exclude','close') NOT NULL DEFAULT 'close',
  `publisher_filters_json` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `campaign_show_log`
--

CREATE TABLE `campaign_show_log` (
  `id` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `mid` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `device_idfa` varchar(50) NOT NULL DEFAULT '',
  `device_ip` varchar(50) NOT NULL,
  `created` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `country`
--

CREATE TABLE `country` (
  `name` varchar(44) NOT NULL,
  `alpha2` varchar(2) NOT NULL DEFAULT '',
  `alpha3` varchar(3) NOT NULL DEFAULT '',
  `numeric_code` int(3) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `country`
--

INSERT INTO `country` (`name`, `alpha2`, `alpha3`, `numeric_code`) VALUES
('Andorra', 'AD', 'AND', 20),
('United Arab Emirates', 'AE', 'ARE', 784),
('Afghanistan', 'AF', 'AFG', 4),
('Antigua and Barbuda', 'AG', 'ATG', 28),
('Anguilla', 'AI', 'AIA', 660),
('Albania', 'AL', 'ALB', 8),
('Armenia', 'AM', 'ARM', 51),
('Angola', 'AO', 'AGO', 24),
('Antarctica', 'AQ', 'ATA', 10),
('Argentina', 'AR', 'ARG', 32),
('American Samoa', 'AS', 'ASM', 16),
('Austria', 'AT', 'AUT', 40),
('Australia', 'AU', 'AUS', 36),
('Aruba', 'AW', 'ABW', 533),
('Aland Islands', 'AX', 'ALA', 248),
('Azerbaijan', 'AZ', 'AZE', 31),
('Bosnia and Herzegovina', 'BA', 'BIH', 70),
('Barbados', 'BB', 'BRB', 52),
('Bangladesh', 'BD', 'BGD', 50),
('Belgium', 'BE', 'BEL', 56),
('Burkina Faso', 'BF', 'BFA', 854),
('Bulgaria', 'BG', 'BGR', 100),
('Bahrain', 'BH', 'BHR', 48),
('Burundi', 'BI', 'BDI', 108),
('Benin', 'BJ', 'BEN', 204),
('Saint Barthelemy', 'BL', 'BLM', 652),
('Bermuda', 'BM', 'BMU', 60),
('Brunei Darussalam', 'BN', 'BRN', 96),
('Bolivia, Plurinational State of', 'BO', 'BOL', 68),
('Bonaire, Sint Eustatius and Saba', 'BQ', 'BES', 535),
('Brazil', 'BR', 'BRA', 76),
('Bahamas', 'BS', 'BHS', 44),
('Bhutan', 'BT', 'BTN', 64),
('Bouvet Island', 'BV', 'BVT', 74),
('Botswana', 'BW', 'BWA', 72),
('Belarus', 'BY', 'BLR', 112),
('Belize', 'BZ', 'BLZ', 84),
('Canada', 'CA', 'CAN', 124),
('Cocos (Keeling) Islands', 'CC', 'CCK', 166),
('Congo, The Democratic Republic of The', 'CD', 'COD', 180),
('Central African Republic', 'CF', 'CAF', 140),
('Congo', 'CG', 'COG', 178),
('Switzerland', 'CH', 'CHE', 756),
('Cote D''ivoire', 'CI', 'CIV', 384),
('Cook Islands', 'CK', 'COK', 184),
('Chile', 'CL', 'CHL', 152),
('Cameroon', 'CM', 'CMR', 120),
('China', 'CN', 'CHN', 156),
('Colombia', 'CO', 'COL', 170),
('Costa Rica', 'CR', 'CRI', 188),
('Cuba', 'CU', 'CUB', 192),
('Cabo Verde', 'CV', 'CPV', 132),
('Curacao', 'CW', 'CUW', 531),
('Christmas Island', 'CX', 'CXR', 162),
('Cyprus', 'CY', 'CYP', 196),
('Czech Republic', 'CZ', 'CZE', 203),
('Germany', 'DE', 'DEU', 276),
('Djibouti', 'DJ', 'DJI', 262),
('Denmark', 'DK', 'DNK', 208),
('Dominica', 'DM', 'DMA', 212),
('Dominican Republic', 'DO', 'DOM', 214),
('Algeria', 'DZ', 'DZA', 12),
('Ecuador', 'EC', 'ECU', 218),
('Estonia', 'EE', 'EST', 233),
('Egypt', 'EG', 'EGY', 818),
('Western Sahara', 'EH', 'ESH', 732),
('Eritrea', 'ER', 'ERI', 232),
('Spain', 'ES', 'ESP', 724),
('Ethiopia', 'ET', 'ETH', 231),
('Finland', 'FI', 'FIN', 246),
('Fiji', 'FJ', 'FJI', 242),
('Falkland Islands (Malvinas)', 'FK', 'FLK', 238),
('Micronesia, Federated States of', 'FM', 'FSM', 583),
('Faroe Islands', 'FO', 'FRO', 234),
('France', 'FR', 'FRA', 250),
('Gabon', 'GA', 'GAB', 266),
('United Kingdom', 'GB', 'GBR', 826),
('Grenada', 'GD', 'GRD', 308),
('Georgia', 'GE', 'GEO', 268),
('French Guiana', 'GF', 'GUF', 254),
('Guernsey', 'GG', 'GGY', 831),
('Ghana', 'GH', 'GHA', 288),
('Gibraltar', 'GI', 'GIB', 292),
('Greenland', 'GL', 'GRL', 304),
('Gambia', 'GM', 'GMB', 270),
('Guinea', 'GN', 'GIN', 324),
('Guadeloupe', 'GP', 'GLP', 312),
('Equatorial Guinea', 'GQ', 'GNQ', 226),
('Greece', 'GR', 'GRC', 300),
('South Georgia and The South Sandwich Islands', 'GS', 'SGS', 239),
('Guatemala', 'GT', 'GTM', 320),
('Guam', 'GU', 'GUM', 316),
('Guinea-Bissau', 'GW', 'GNB', 624),
('Guyana', 'GY', 'GUY', 328),
('Hong Kong', 'HK', 'HKG', 344),
('Heard Island and Mcdonald Islands', 'HM', 'HMD', 334),
('Honduras', 'HN', 'HND', 340),
('Croatia', 'HR', 'HRV', 191),
('Haiti', 'HT', 'HTI', 332),
('Hungary', 'HU', 'HUN', 348),
('Indonesia', 'ID', 'IDN', 360),
('Ireland', 'IE', 'IRL', 372),
('Israel', 'IL', 'ISR', 376),
('Isle of Man', 'IM', 'IMN', 833),
('India', 'IN', 'IND', 356),
('British Indian Ocean Territory', 'IO', 'IOT', 86),
('Iraq', 'IQ', 'IRQ', 368),
('Iran, Islamic Republic of', 'IR', 'IRN', 364),
('Iceland', 'IS', 'ISL', 352),
('Italy', 'IT', 'ITA', 380),
('Jersey', 'JE', 'JEY', 832),
('Jamaica', 'JM', 'JAM', 388),
('Jordan', 'JO', 'JOR', 400),
('Japan', 'JP', 'JPN', 392),
('Kenya', 'KE', 'KEN', 404),
('Kyrgyzstan', 'KG', 'KGZ', 417),
('Cambodia', 'KH', 'KHM', 116),
('Kiribati', 'KI', 'KIR', 296),
('Comoros', 'KM', 'COM', 174),
('Saint Kitts and Nevis', 'KN', 'KNA', 659),
('Korea, Democratic People''s Republic of', 'KP', 'PRK', 408),
('Korea, Republic of', 'KR', 'KOR', 410),
('Kuwait', 'KW', 'KWT', 414),
('Cayman Islands', 'KY', 'CYM', 136),
('Kazakhstan', 'KZ', 'KAZ', 398),
('Lao People''s Democratic Republic', 'LA', 'LAO', 418),
('Lebanon', 'LB', 'LBN', 422),
('Saint Lucia', 'LC', 'LCA', 662),
('Liechtenstein', 'LI', 'LIE', 438),
('Sri Lanka', 'LK', 'LKA', 144),
('Liberia', 'LR', 'LBR', 430),
('Lesotho', 'LS', 'LSO', 426),
('Lithuania', 'LT', 'LTU', 440),
('Luxembourg', 'LU', 'LUX', 442),
('Latvia', 'LV', 'LVA', 428),
('Libya', 'LY', 'LBY', 434),
('Morocco', 'MA', 'MAR', 504),
('Monaco', 'MC', 'MCO', 492),
('Moldova, Republic of', 'MD', 'MDA', 498),
('Montenegro', 'ME', 'MNE', 499),
('Saint Martin (French Part)', 'MF', 'MAF', 663),
('Madagascar', 'MG', 'MDG', 450),
('Marshall Islands', 'MH', 'MHL', 584),
('Macedonia, The Former Yugoslav Republic of', 'MK', 'MKD', 807),
('Mali', 'ML', 'MLI', 466),
('Myanmar', 'MM', 'MMR', 104),
('Mongolia', 'MN', 'MNG', 496),
('Macao', 'MO', 'MAC', 446),
('Northern Mariana Islands', 'MP', 'MNP', 580),
('Martinique', 'MQ', 'MTQ', 474),
('Mauritania', 'MR', 'MRT', 478),
('Montserrat', 'MS', 'MSR', 500),
('Malta', 'MT', 'MLT', 470),
('Mauritius', 'MU', 'MUS', 480),
('Maldives', 'MV', 'MDV', 462),
('Malawi', 'MW', 'MWI', 454),
('Mexico', 'MX', 'MEX', 484),
('Malaysia', 'MY', 'MYS', 458),
('Mozambique', 'MZ', 'MOZ', 508),
('Namibia', 'NA', 'NAM', 516),
('New Caledonia', 'NC', 'NCL', 540),
('Niger', 'NE', 'NER', 562),
('Norfolk Island', 'NF', 'NFK', 574),
('Nigeria', 'NG', 'NGA', 566),
('Nicaragua', 'NI', 'NIC', 558),
('Netherlands', 'NL', 'NLD', 528),
('Norway', 'NO', 'NOR', 578),
('Nepal', 'NP', 'NPL', 524),
('Nauru', 'NR', 'NRU', 520),
('Niue', 'NU', 'NIU', 570),
('New Zealand', 'NZ', 'NZL', 554),
('Oman', 'OM', 'OMN', 512),
('Panama', 'PA', 'PAN', 591),
('Peru', 'PE', 'PER', 604),
('French Polynesia', 'PF', 'PYF', 258),
('Papua New Guinea', 'PG', 'PNG', 598),
('Philippines', 'PH', 'PHL', 608),
('Pakistan', 'PK', 'PAK', 586),
('Poland', 'PL', 'POL', 616),
('Saint Pierre and Miquelon', 'PM', 'SPM', 666),
('Pitcairn', 'PN', 'PCN', 612),
('Puerto Rico', 'PR', 'PRI', 630),
('Palestine, State of', 'PS', 'PSE', 275),
('Portugal', 'PT', 'PRT', 620),
('Palau', 'PW', 'PLW', 585),
('Paraguay', 'PY', 'PRY', 600),
('Qatar', 'QA', 'QAT', 634),
('Reunion', 'RE', 'REU', 638),
('Romania', 'RO', 'ROU', 642),
('Serbia', 'RS', 'SRB', 688),
('Russian Federation', 'RU', 'RUS', 643),
('Rwanda', 'RW', 'RWA', 646),
('Saudi Arabia', 'SA', 'SAU', 682),
('Solomon Islands', 'SB', 'SLB', 90),
('Seychelles', 'SC', 'SYC', 690),
('Sudan', 'SD', 'SDN', 729),
('Sweden', 'SE', 'SWE', 752),
('Singapore', 'SG', 'SGP', 702),
('Saint Helena, Ascension and Tristan Da Cunha', 'SH', 'SHN', 654),
('Slovenia', 'SI', 'SVN', 705),
('Svalbard and Jan Mayen', 'SJ', 'SJM', 744),
('Slovakia', 'SK', 'SVK', 703),
('Sierra Leone', 'SL', 'SLE', 694),
('San Marino', 'SM', 'SMR', 674),
('Senegal', 'SN', 'SEN', 686),
('Somalia', 'SO', 'SOM', 706),
('Suriname', 'SR', 'SUR', 740),
('South Sudan', 'SS', 'SSD', 728),
('Sao Tome and Principe', 'ST', 'STP', 678),
('El Salvador', 'SV', 'SLV', 222),
('Sint Maarten (Dutch Part)', 'SX', 'SXM', 534),
('Syrian Arab Republic', 'SY', 'SYR', 760),
('Swaziland', 'SZ', 'SWZ', 748),
('Turks and Caicos Islands', 'TC', 'TCA', 796),
('Chad', 'TD', 'TCD', 148),
('French Southern Territories', 'TF', 'ATF', 260),
('Togo', 'TG', 'TGO', 768),
('Thailand', 'TH', 'THA', 764),
('Tajikistan', 'TJ', 'TJK', 762),
('Tokelau', 'TK', 'TKL', 772),
('Timor-Leste', 'TL', 'TLS', 626),
('Turkmenistan', 'TM', 'TKM', 795),
('Tunisia', 'TN', 'TUN', 788),
('Tonga', 'TO', 'TON', 776),
('Turkey', 'TR', 'TUR', 792),
('Trinidad and Tobago', 'TT', 'TTO', 780),
('Tuvalu', 'TV', 'TUV', 798),
('Taiwan, Province of China', 'TW', 'TWN', 158),
('Tanzania, United Republic of', 'TZ', 'TZA', 834),
('Ukraine', 'UA', 'UKR', 804),
('Uganda', 'UG', 'UGA', 800),
('United Kingdom', 'UK', 'GBR', 826),
('United States Minor Outlying Islands', 'UM', 'UMI', 581),
('United States', 'US', 'USA', 840),
('Uruguay', 'UY', 'URY', 858),
('Uzbekistan', 'UZ', 'UZB', 860),
('Holy See', 'VA', 'VAT', 336),
('Saint Vincent and The Grenadines', 'VC', 'VCT', 670),
('Venezuela, Bolivarian Republic of', 'VE', 'VEN', 862),
('Virgin Islands, British', 'VG', 'VGB', 92),
('Virgin Islands, U.S.', 'VI', 'VIR', 850),
('Viet Nam', 'VN', 'VNM', 704),
('Vanuatu', 'VU', 'VUT', 548),
('Wallis and Futuna', 'WF', 'WLF', 876),
('Samoa', 'WS', 'WSM', 882),
('Yemen', 'YE', 'YEM', 887),
('Mayotte', 'YT', 'MYT', 175),
('South Africa', 'ZA', 'ZAF', 710),
('Zambia', 'ZM', 'ZMB', 894),
('Zimbabwe', 'ZW', 'ZWE', 716);

-- --------------------------------------------------------

--
-- 表的结构 `country_region`
--

CREATE TABLE `country_region` (
  `country_alpha2` varchar(2) NOT NULL,
  `country_numeric_code` int(3) NOT NULL,
  `country_name` varchar(44) NOT NULL,
  `code` varchar(7) NOT NULL,
  `name` varchar(44) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `country_region`
--

INSERT INTO `country_region` (`country_alpha2`, `country_numeric_code`, `country_name`, `code`, `name`) VALUES
('AD', 20, 'Andorra', '02', 'Canillo'),
('AD', 20, 'Andorra', '03', 'Encamp'),
('AD', 20, 'Andorra', '04', 'La Massana'),
('AD', 20, 'Andorra', '05', 'Ordino'),
('AD', 20, 'Andorra', '06', 'Sant Julia de Loria'),
('AD', 20, 'Andorra', '07', 'Andorra la Vella'),
('AD', 20, 'Andorra', '08', 'Escaldes-Engordany'),
('AE', 784, 'United Arab Emirates', '01', 'Abu Zaby'),
('AE', 784, 'United Arab Emirates', '02', '''Ajman'),
('AE', 784, 'United Arab Emirates', '03', 'Dubayy'),
('AE', 784, 'United Arab Emirates', '04', 'Al Fujayrah'),
('AE', 784, 'United Arab Emirates', '05', 'Ra''s al Khaymah'),
('AE', 784, 'United Arab Emirates', '06', 'Ash Shariqah'),
('AE', 784, 'United Arab Emirates', '07', 'Umm al Qaywayn'),
('AF', 4, 'Afghanistan', '01', 'Badakhshan'),
('AF', 4, 'Afghanistan', '02', 'Badghis'),
('AF', 4, 'Afghanistan', '03', 'Baghlan'),
('AF', 4, 'Afghanistan', '05', 'Bamyan'),
('AF', 4, 'Afghanistan', '06', 'Farah'),
('AF', 4, 'Afghanistan', '07', 'Faryab'),
('AF', 4, 'Afghanistan', '08', 'Ghazni'),
('AF', 4, 'Afghanistan', '09', 'Ghor'),
('AF', 4, 'Afghanistan', '10', 'Helmand'),
('AF', 4, 'Afghanistan', '11', 'Herat'),
('AF', 4, 'Afghanistan', '13', 'Kabul'),
('AF', 4, 'Afghanistan', '14', 'Kapisa'),
('AF', 4, 'Afghanistan', '17', 'Logar'),
('AF', 4, 'Afghanistan', '18', 'Nangarhar'),
('AF', 4, 'Afghanistan', '19', 'Nimroz'),
('AF', 4, 'Afghanistan', '23', 'Kandahar'),
('AF', 4, 'Afghanistan', '24', 'Kunduz'),
('AF', 4, 'Afghanistan', '26', 'Takhar'),
('AF', 4, 'Afghanistan', '27', 'Wardak'),
('AF', 4, 'Afghanistan', '28', 'Zabul'),
('AF', 4, 'Afghanistan', '29', 'Paktika'),
('AF', 4, 'Afghanistan', '30', 'Balkh'),
('AF', 4, 'Afghanistan', '31', 'Jowzjan'),
('AF', 4, 'Afghanistan', '32', 'Samangan'),
('AF', 4, 'Afghanistan', '33', 'Sar-e pul'),
('AF', 4, 'Afghanistan', '34', 'Kunar'),
('AF', 4, 'Afghanistan', '35', 'Laghman'),
('AF', 4, 'Afghanistan', '36', 'Paktiya'),
('AF', 4, 'Afghanistan', '37', 'Khost'),
('AF', 4, 'Afghanistan', '38', 'Nuristan'),
('AF', 4, 'Afghanistan', '39', 'Uruzgan'),
('AF', 4, 'Afghanistan', '40', 'Parwan'),
('AF', 4, 'Afghanistan', '41', 'Daykundi'),
('AF', 4, 'Afghanistan', '42', 'Panjshayr'),
('AG', 28, 'Antigua and Barbuda', '00', 'Saint John'),
('AG', 28, 'Antigua and Barbuda', '04', 'Saint John'),
('AG', 28, 'Antigua and Barbuda', '05', 'Saint Mary'),
('AG', 28, 'Antigua and Barbuda', '06', 'Saint Paul'),
('AI', 660, 'Anguilla', '00', 'Anguilla'),
('AL', 8, 'Albania', '40', 'Berat'),
('AL', 8, 'Albania', '41', 'Diber'),
('AL', 8, 'Albania', '42', 'Durres'),
('AL', 8, 'Albania', '43', 'Elbasan'),
('AL', 8, 'Albania', '44', 'Fier'),
('AL', 8, 'Albania', '45', 'Gjirokaster'),
('AL', 8, 'Albania', '46', 'Korce'),
('AL', 8, 'Albania', '47', 'Kukes'),
('AL', 8, 'Albania', '48', 'Lezhe'),
('AL', 8, 'Albania', '49', 'Shkoder'),
('AL', 8, 'Albania', '50', 'Tirane'),
('AL', 8, 'Albania', '51', 'Vlore'),
('AM', 51, 'Armenia', '01', 'Aragacotn'),
('AM', 51, 'Armenia', '02', 'Ararat'),
('AM', 51, 'Armenia', '03', 'Armavir'),
('AM', 51, 'Armenia', '04', 'Gegark''unik'''),
('AM', 51, 'Armenia', '05', 'Kotayk'''),
('AM', 51, 'Armenia', '06', 'Lori'),
('AM', 51, 'Armenia', '07', 'Sirak'),
('AM', 51, 'Armenia', '08', 'Syunik'''),
('AM', 51, 'Armenia', '09', 'Tavus'),
('AM', 51, 'Armenia', '10', 'Vayoc Jor'),
('AM', 51, 'Armenia', '11', 'Erevan'),
('AO', 24, 'Angola', '01', 'Benguela'),
('AO', 24, 'Angola', '02', 'Bie'),
('AO', 24, 'Angola', '03', 'Cabinda'),
('AO', 24, 'Angola', '04', 'Kuando Kubango'),
('AO', 24, 'Angola', '05', 'Kwanza Norte'),
('AO', 24, 'Angola', '06', 'Kwanza Sul'),
('AO', 24, 'Angola', '07', 'Cunene'),
('AO', 24, 'Angola', '08', 'Huambo'),
('AO', 24, 'Angola', '09', 'Huila'),
('AO', 24, 'Angola', '12', 'Malange'),
('AO', 24, 'Angola', '13', 'Namibe'),
('AO', 24, 'Angola', '14', 'Moxico'),
('AO', 24, 'Angola', '15', 'Uige'),
('AO', 24, 'Angola', '16', 'Zaire'),
('AO', 24, 'Angola', '17', 'Lunda Norte'),
('AO', 24, 'Angola', '18', 'Lunda Sul'),
('AO', 24, 'Angola', '19', 'Bengo'),
('AO', 24, 'Angola', '20', 'Luanda'),
('AQ', 10, 'Antarctica', '00', 'Antarctica'),
('AR', 32, 'Argentina', '01', 'Buenos Aires'),
('AR', 32, 'Argentina', '02', 'Catamarca'),
('AR', 32, 'Argentina', '03', 'Chaco'),
('AR', 32, 'Argentina', '04', 'Chubut'),
('AR', 32, 'Argentina', '05', 'Cordoba'),
('AR', 32, 'Argentina', '06', 'Corrientes'),
('AR', 32, 'Argentina', '07', 'Ciudad Autonoma de Buenos Aires'),
('AR', 32, 'Argentina', '08', 'Entre Rios'),
('AR', 32, 'Argentina', '09', 'Formosa'),
('AR', 32, 'Argentina', '10', 'Jujuy'),
('AR', 32, 'Argentina', '11', 'La Pampa'),
('AR', 32, 'Argentina', '12', 'La Rioja'),
('AR', 32, 'Argentina', '13', 'Mendoza'),
('AR', 32, 'Argentina', '14', 'Misiones'),
('AR', 32, 'Argentina', '15', 'Neuquen'),
('AR', 32, 'Argentina', '16', 'Rio Negro'),
('AR', 32, 'Argentina', '17', 'Salta'),
('AR', 32, 'Argentina', '18', 'San Juan'),
('AR', 32, 'Argentina', '19', 'San Luis'),
('AR', 32, 'Argentina', '20', 'Santa Cruz'),
('AR', 32, 'Argentina', '21', 'Santa Fe'),
('AR', 32, 'Argentina', '22', 'Santiago del Estero'),
('AR', 32, 'Argentina', '23', 'Tierra del Fuego'),
('AR', 32, 'Argentina', '24', 'Tucuman'),
('AS', 16, 'American Samoa', '010', 'Eastern District'),
('AS', 16, 'American Samoa', '050', 'Western District'),
('AT', 40, 'Austria', '01', 'Burgenland'),
('AT', 40, 'Austria', '02', 'Karnten'),
('AT', 40, 'Austria', '03', 'Niederosterreich'),
('AT', 40, 'Austria', '04', 'Oberosterreich'),
('AT', 40, 'Austria', '05', 'Salzburg'),
('AT', 40, 'Austria', '06', 'Steiermark'),
('AT', 40, 'Austria', '07', 'Tirol'),
('AT', 40, 'Austria', '08', 'Vorarlberg'),
('AT', 40, 'Austria', '09', 'Wien'),
('AU', 36, 'Australia', '01', 'Australian Capital Territory'),
('AU', 36, 'Australia', '02', 'New South Wales'),
('AU', 36, 'Australia', '03', 'Northern Territory'),
('AU', 36, 'Australia', '04', 'Queensland'),
('AU', 36, 'Australia', '05', 'South Australia'),
('AU', 36, 'Australia', '06', 'Tasmania'),
('AU', 36, 'Australia', '07', 'Victoria'),
('AU', 36, 'Australia', '08', 'Western Australia'),
('AW', 533, 'Aruba', '00', 'Aruba (general)'),
('AX', 248, 'Aland Islands', '043', 'Eckeroe'),
('AX', 248, 'Aland Islands', '060', 'Finstroem'),
('AX', 248, 'Aland Islands', '076', 'Hammarland'),
('AX', 248, 'Aland Islands', '170', 'Jomala'),
('AX', 248, 'Aland Islands', '417', 'Lemland'),
('AX', 248, 'Aland Islands', '478', 'Mariehamn'),
('AX', 248, 'Aland Islands', '736', 'Saltvik'),
('AX', 248, 'Aland Islands', '771', 'Sund'),
('AZ', 31, 'Azerbaijan', '01', 'Abseron'),
('AZ', 31, 'Azerbaijan', '02', 'Agcabadi'),
('AZ', 31, 'Azerbaijan', '03', 'Agdam'),
('AZ', 31, 'Azerbaijan', '04', 'Agdas'),
('AZ', 31, 'Azerbaijan', '05', 'Agstafa'),
('AZ', 31, 'Azerbaijan', '06', 'Agsu'),
('AZ', 31, 'Azerbaijan', '07', 'Sirvan'),
('AZ', 31, 'Azerbaijan', '08', 'Astara'),
('AZ', 31, 'Azerbaijan', '09', 'Baki'),
('AZ', 31, 'Azerbaijan', '10', 'Balakan'),
('AZ', 31, 'Azerbaijan', '11', 'Barda'),
('AZ', 31, 'Azerbaijan', '12', 'Beylaqan'),
('AZ', 31, 'Azerbaijan', '13', 'Bilasuvar'),
('AZ', 31, 'Azerbaijan', '14', 'Cabrayil'),
('AZ', 31, 'Azerbaijan', '15', 'Calilabad'),
('AZ', 31, 'Azerbaijan', '16', 'Daskasan'),
('AZ', 31, 'Azerbaijan', '18', 'Fuzuli'),
('AZ', 31, 'Azerbaijan', '19', 'Gadabay'),
('AZ', 31, 'Azerbaijan', '20', 'Ganca'),
('AZ', 31, 'Azerbaijan', '21', 'Goranboy'),
('AZ', 31, 'Azerbaijan', '22', 'Goycay'),
('AZ', 31, 'Azerbaijan', '23', 'Haciqabul'),
('AZ', 31, 'Azerbaijan', '24', 'Imisli'),
('AZ', 31, 'Azerbaijan', '25', 'Ismayilli'),
('AZ', 31, 'Azerbaijan', '26', 'Kalbacar'),
('AZ', 31, 'Azerbaijan', '28', 'Lacin'),
('AZ', 31, 'Azerbaijan', '29', 'Lankaran'),
('AZ', 31, 'Azerbaijan', '30', 'Lankaran'),
('AZ', 31, 'Azerbaijan', '31', 'Lerik'),
('AZ', 31, 'Azerbaijan', '32', 'Masalli'),
('AZ', 31, 'Azerbaijan', '33', 'Mingacevir'),
('AZ', 31, 'Azerbaijan', '34', 'Naftalan'),
('AZ', 31, 'Azerbaijan', '35', 'Naxcivan'),
('AZ', 31, 'Azerbaijan', '36', 'Neftcala'),
('AZ', 31, 'Azerbaijan', '37', 'Oguz'),
('AZ', 31, 'Azerbaijan', '38', 'Qabala'),
('AZ', 31, 'Azerbaijan', '39', 'Qax'),
('AZ', 31, 'Azerbaijan', '40', 'Qazax'),
('AZ', 31, 'Azerbaijan', '41', 'Qobustan'),
('AZ', 31, 'Azerbaijan', '42', 'Quba'),
('AZ', 31, 'Azerbaijan', '43', 'Qubadli'),
('AZ', 31, 'Azerbaijan', '44', 'Qusar'),
('AZ', 31, 'Azerbaijan', '45', 'Saatli'),
('AZ', 31, 'Azerbaijan', '46', 'Sabirabad'),
('AZ', 31, 'Azerbaijan', '47', 'Saki'),
('AZ', 31, 'Azerbaijan', '48', 'Saki'),
('AZ', 31, 'Azerbaijan', '49', 'Salyan'),
('AZ', 31, 'Azerbaijan', '50', 'Samaxi'),
('AZ', 31, 'Azerbaijan', '51', 'Samkir'),
('AZ', 31, 'Azerbaijan', '52', 'Samux'),
('AZ', 31, 'Azerbaijan', '54', 'Sumqayit'),
('AZ', 31, 'Azerbaijan', '56', 'Susa'),
('AZ', 31, 'Azerbaijan', '57', 'Tartar'),
('AZ', 31, 'Azerbaijan', '58', 'Tovuz'),
('AZ', 31, 'Azerbaijan', '59', 'Ucar'),
('AZ', 31, 'Azerbaijan', '60', 'Xacmaz'),
('AZ', 31, 'Azerbaijan', '61', 'Xankandi'),
('AZ', 31, 'Azerbaijan', '62', 'Goygol'),
('AZ', 31, 'Azerbaijan', '63', 'Xizi'),
('AZ', 31, 'Azerbaijan', '64', 'Xocali'),
('AZ', 31, 'Azerbaijan', '65', 'Xocavand'),
('AZ', 31, 'Azerbaijan', '66', 'Yardimli'),
('AZ', 31, 'Azerbaijan', '67', 'Yevlax'),
('AZ', 31, 'Azerbaijan', '68', 'Yevlax'),
('AZ', 31, 'Azerbaijan', '69', 'Zangilan'),
('AZ', 31, 'Azerbaijan', '70', 'Zaqatala'),
('AZ', 31, 'Azerbaijan', '71', 'Zardab'),
('BA', 70, 'Bosnia and Herzegovina', '01', 'Federacija Bosna i Hercegovina'),
('BA', 70, 'Bosnia and Herzegovina', '02', 'Republika Srpska'),
('BB', 52, 'Barbados', '01', 'Christ Church'),
('BB', 52, 'Barbados', '04', 'Saint James'),
('BB', 52, 'Barbados', '06', 'Saint Joseph'),
('BB', 52, 'Barbados', '08', 'Saint Michael'),
('BB', 52, 'Barbados', '09', 'Saint Peter'),
('BD', 50, 'Bangladesh', '81', 'Dhaka'),
('BD', 50, 'Bangladesh', '82', 'Khulna'),
('BD', 50, 'Bangladesh', '83', 'Rajshahi'),
('BD', 50, 'Bangladesh', '84', 'Chittagong'),
('BD', 50, 'Bangladesh', '85', 'Barisal'),
('BD', 50, 'Bangladesh', '86', 'Sylhet'),
('BD', 50, 'Bangladesh', '87', 'Rangpur'),
('BE', 56, 'Belgium', '01', 'Antwerpen'),
('BE', 56, 'Belgium', '03', 'Hainaut'),
('BE', 56, 'Belgium', '04', 'Liege'),
('BE', 56, 'Belgium', '05', 'Limburg'),
('BE', 56, 'Belgium', '06', 'Luxembourg'),
('BE', 56, 'Belgium', '07', 'Namur'),
('BE', 56, 'Belgium', '08', 'Oost-Vlaanderen'),
('BE', 56, 'Belgium', '09', 'West-Vlaanderen'),
('BE', 56, 'Belgium', '10', 'Brabant Wallon'),
('BE', 56, 'Belgium', '11', 'Brussels Hoofdstedelijk Gewest'),
('BE', 56, 'Belgium', '12', 'Vlaams-Brabant'),
('BF', 854, 'Burkina Faso', '15', 'Bam'),
('BF', 854, 'Burkina Faso', '19', 'Boulkiemde'),
('BF', 854, 'Burkina Faso', '20', 'Ganzourgou'),
('BF', 854, 'Burkina Faso', '21', 'Gnagna'),
('BF', 854, 'Burkina Faso', '28', 'Kouritenga'),
('BF', 854, 'Burkina Faso', '33', 'Oudalan'),
('BF', 854, 'Burkina Faso', '34', 'Passore'),
('BF', 854, 'Burkina Faso', '36', 'Sanguie'),
('BF', 854, 'Burkina Faso', '40', 'Soum'),
('BF', 854, 'Burkina Faso', '42', 'Tapoa'),
('BF', 854, 'Burkina Faso', '44', 'Zoundweogo'),
('BF', 854, 'Burkina Faso', '45', 'Bale'),
('BF', 854, 'Burkina Faso', '46', 'Banwa'),
('BF', 854, 'Burkina Faso', '47', 'Bazega'),
('BF', 854, 'Burkina Faso', '48', 'Bougouriba'),
('BF', 854, 'Burkina Faso', '49', 'Boulgou'),
('BF', 854, 'Burkina Faso', '50', 'Gourma'),
('BF', 854, 'Burkina Faso', '51', 'Houet'),
('BF', 854, 'Burkina Faso', '52', 'Ioba'),
('BF', 854, 'Burkina Faso', '53', 'Kadiogo'),
('BF', 854, 'Burkina Faso', '54', 'Kenedougou'),
('BF', 854, 'Burkina Faso', '55', 'Comoe'),
('BF', 854, 'Burkina Faso', '56', 'Komondjari'),
('BF', 854, 'Burkina Faso', '57', 'Kompienga'),
('BF', 854, 'Burkina Faso', '58', 'Kossi'),
('BF', 854, 'Burkina Faso', '59', 'Koulpelogo'),
('BF', 854, 'Burkina Faso', '60', 'Kourweogo'),
('BF', 854, 'Burkina Faso', '61', 'Leraba'),
('BF', 854, 'Burkina Faso', '62', 'Loroum'),
('BF', 854, 'Burkina Faso', '63', 'Mouhoun'),
('BF', 854, 'Burkina Faso', '64', 'Namentenga'),
('BF', 854, 'Burkina Faso', '65', 'Nahouri'),
('BF', 854, 'Burkina Faso', '66', 'Nayala'),
('BF', 854, 'Burkina Faso', '67', 'Noumbiel'),
('BF', 854, 'Burkina Faso', '68', 'Oubritenga'),
('BF', 854, 'Burkina Faso', '69', 'Poni'),
('BF', 854, 'Burkina Faso', '70', 'Sanmatenga'),
('BF', 854, 'Burkina Faso', '71', 'Seno'),
('BF', 854, 'Burkina Faso', '72', 'Sissili'),
('BF', 854, 'Burkina Faso', '73', 'Sourou'),
('BF', 854, 'Burkina Faso', '74', 'Tui'),
('BF', 854, 'Burkina Faso', '75', 'Yagha'),
('BF', 854, 'Burkina Faso', '76', 'Yatenga'),
('BF', 854, 'Burkina Faso', '77', 'Ziro'),
('BF', 854, 'Burkina Faso', '78', 'Zondoma'),
('BG', 100, 'Bulgaria', '38', 'Blagoevgrad'),
('BG', 100, 'Bulgaria', '39', 'Burgas'),
('BG', 100, 'Bulgaria', '40', 'Dobrich'),
('BG', 100, 'Bulgaria', '41', 'Gabrovo'),
('BG', 100, 'Bulgaria', '42', 'Sofia (stolitsa)'),
('BG', 100, 'Bulgaria', '43', 'Haskovo'),
('BG', 100, 'Bulgaria', '44', 'Kardzhali'),
('BG', 100, 'Bulgaria', '45', 'Kyustendil'),
('BG', 100, 'Bulgaria', '46', 'Lovech'),
('BG', 100, 'Bulgaria', '47', 'Montana'),
('BG', 100, 'Bulgaria', '48', 'Pazardzhik'),
('BG', 100, 'Bulgaria', '49', 'Pernik'),
('BG', 100, 'Bulgaria', '50', 'Pleven'),
('BG', 100, 'Bulgaria', '51', 'Plovdiv'),
('BG', 100, 'Bulgaria', '52', 'Razgrad'),
('BG', 100, 'Bulgaria', '53', 'Ruse'),
('BG', 100, 'Bulgaria', '54', 'Shumen'),
('BG', 100, 'Bulgaria', '55', 'Silistra'),
('BG', 100, 'Bulgaria', '56', 'Sliven'),
('BG', 100, 'Bulgaria', '57', 'Smolyan'),
('BG', 100, 'Bulgaria', '58', 'Sofia'),
('BG', 100, 'Bulgaria', '59', 'Stara Zagora'),
('BG', 100, 'Bulgaria', '60', 'Targovishte'),
('BG', 100, 'Bulgaria', '61', 'Varna'),
('BG', 100, 'Bulgaria', '62', 'Veliko Tarnovo'),
('BG', 100, 'Bulgaria', '63', 'Vidin'),
('BG', 100, 'Bulgaria', '64', 'Vratsa'),
('BG', 100, 'Bulgaria', '65', 'Yambol'),
('BH', 48, 'Bahrain', '15', 'Al Muharraq'),
('BH', 48, 'Bahrain', '16', 'Al Asimah'),
('BH', 48, 'Bahrain', '18', 'Ash Shamaliyah'),
('BI', 108, 'Burundi', '09', 'Bubanza'),
('BI', 108, 'Burundi', '10', 'Bururi'),
('BI', 108, 'Burundi', '11', 'Cankuzo'),
('BI', 108, 'Burundi', '12', 'Cibitoke'),
('BI', 108, 'Burundi', '13', 'Gitega'),
('BI', 108, 'Burundi', '14', 'Karuzi'),
('BI', 108, 'Burundi', '15', 'Kayanza'),
('BI', 108, 'Burundi', '16', 'Kirundo'),
('BI', 108, 'Burundi', '17', 'Makamba'),
('BI', 108, 'Burundi', '18', 'Muyinga'),
('BI', 108, 'Burundi', '19', 'Ngozi'),
('BI', 108, 'Burundi', '20', 'Rutana'),
('BI', 108, 'Burundi', '21', 'Ruyigi'),
('BI', 108, 'Burundi', '22', 'Muramvya'),
('BI', 108, 'Burundi', '23', 'Mwaro'),
('BI', 108, 'Burundi', '24', 'Bujumbura Mairie'),
('BJ', 204, 'Benin', '07', 'Alibori'),
('BJ', 204, 'Benin', '08', 'Atacora'),
('BJ', 204, 'Benin', '09', 'Atlantique'),
('BJ', 204, 'Benin', '10', 'Borgou'),
('BJ', 204, 'Benin', '11', 'Collines'),
('BJ', 204, 'Benin', '12', 'Couffo'),
('BJ', 204, 'Benin', '13', 'Donga'),
('BJ', 204, 'Benin', '14', 'Littoral'),
('BJ', 204, 'Benin', '15', 'Mono'),
('BJ', 204, 'Benin', '16', 'Oueme'),
('BJ', 204, 'Benin', '17', 'Plateau'),
('BJ', 204, 'Benin', '18', 'Zou'),
('BL', 652, 'Saint Barthelemy', '00', 'Saint Barthelemy'),
('BM', 60, 'Bermuda', '03', 'Hamilton'),
('BM', 60, 'Bermuda', '06', 'Saint George'),
('BN', 96, 'Brunei Darussalam', '01', 'Belait'),
('BN', 96, 'Brunei Darussalam', '02', 'Brunei-Muara'),
('BN', 96, 'Brunei Darussalam', '03', 'Temburong'),
('BN', 96, 'Brunei Darussalam', '04', 'Tutong'),
('BO', 68, 'Bolivia, Plurinational State of', '01', 'Chuquisaca'),
('BO', 68, 'Bolivia, Plurinational State of', '02', 'Cochabamba'),
('BO', 68, 'Bolivia, Plurinational State of', '03', 'El Beni'),
('BO', 68, 'Bolivia, Plurinational State of', '04', 'La Paz'),
('BO', 68, 'Bolivia, Plurinational State of', '05', 'Oruro'),
('BO', 68, 'Bolivia, Plurinational State of', '06', 'Pando'),
('BO', 68, 'Bolivia, Plurinational State of', '07', 'Potosi'),
('BO', 68, 'Bolivia, Plurinational State of', '08', 'Santa Cruz'),
('BO', 68, 'Bolivia, Plurinational State of', '09', 'Tarija'),
('BQ', 535, 'Bonaire, Sint Eustatius and Saba', 'BO', 'Bonaire'),
('BQ', 535, 'Bonaire, Sint Eustatius and Saba', 'SB', 'Saba'),
('BQ', 535, 'Bonaire, Sint Eustatius and Saba', 'SE', 'Sint Eustatius'),
('BR', 76, 'Brazil', '01', 'Acre'),
('BR', 76, 'Brazil', '02', 'Alagoas'),
('BR', 76, 'Brazil', '03', 'Amapa'),
('BR', 76, 'Brazil', '04', 'Amazonas'),
('BR', 76, 'Brazil', '05', 'Bahia'),
('BR', 76, 'Brazil', '06', 'Ceara'),
('BR', 76, 'Brazil', '07', 'Distrito Federal'),
('BR', 76, 'Brazil', '08', 'Espirito Santo'),
('BR', 76, 'Brazil', '11', 'Mato Grosso do Sul'),
('BR', 76, 'Brazil', '13', 'Maranhao'),
('BR', 76, 'Brazil', '14', 'Mato Grosso'),
('BR', 76, 'Brazil', '15', 'Minas Gerais'),
('BR', 76, 'Brazil', '16', 'Para'),
('BR', 76, 'Brazil', '17', 'Paraiba'),
('BR', 76, 'Brazil', '18', 'Parana'),
('BR', 76, 'Brazil', '20', 'Piaui'),
('BR', 76, 'Brazil', '21', 'Rio de Janeiro'),
('BR', 76, 'Brazil', '22', 'Rio Grande do Norte'),
('BR', 76, 'Brazil', '23', 'Rio Grande do Sul'),
('BR', 76, 'Brazil', '24', 'Rondonia'),
('BR', 76, 'Brazil', '25', 'Roraima'),
('BR', 76, 'Brazil', '26', 'Santa Catarina'),
('BR', 76, 'Brazil', '27', 'Sao Paulo'),
('BR', 76, 'Brazil', '28', 'Sergipe'),
('BR', 76, 'Brazil', '29', 'Goias'),
('BR', 76, 'Brazil', '30', 'Pernambuco'),
('BR', 76, 'Brazil', '31', 'Tocantins'),
('BS', 44, 'Bahamas', '15', 'Long Island'),
('BS', 44, 'Bahamas', '22', 'Harbour Island'),
('BS', 44, 'Bahamas', '23', 'New Providence'),
('BS', 44, 'Bahamas', '25', 'Freeport'),
('BS', 44, 'Bahamas', '26', 'Fresh Creek'),
('BS', 44, 'Bahamas', '29', 'High Rock'),
('BS', 44, 'Bahamas', '31', 'Marsh Harbour'),
('BS', 44, 'Bahamas', '33', 'Rock Sound'),
('BT', 64, 'Bhutan', '06', 'Chhukha'),
('BT', 64, 'Bhutan', '08', 'Dagana'),
('BT', 64, 'Bhutan', '10', 'Ha'),
('BT', 64, 'Bhutan', '12', 'Monggar'),
('BT', 64, 'Bhutan', '13', 'Paro'),
('BT', 64, 'Bhutan', '15', 'Punakha'),
('BT', 64, 'Bhutan', '18', 'Zhemgang'),
('BT', 64, 'Bhutan', '20', 'Thimphu'),
('BT', 64, 'Bhutan', '21', 'Trongsa'),
('BT', 64, 'Bhutan', '23', 'Gasa'),
('BT', 64, 'Bhutan', '24', 'Trashi Yangtse'),
('BW', 72, 'Botswana', '01', 'Central'),
('BW', 72, 'Botswana', '03', 'Ghanzi'),
('BW', 72, 'Botswana', '04', 'Kgalagadi'),
('BW', 72, 'Botswana', '05', 'Kgatleng'),
('BW', 72, 'Botswana', '06', 'Kweneng'),
('BW', 72, 'Botswana', '08', 'North-East'),
('BW', 72, 'Botswana', '09', 'South-East'),
('BW', 72, 'Botswana', '10', 'Southern'),
('BW', 72, 'Botswana', '11', 'North-West'),
('BY', 112, 'Belarus', '01', 'Brestskaya Voblasts'''),
('BY', 112, 'Belarus', '02', 'Homyel''skaya Voblasts'''),
('BY', 112, 'Belarus', '03', 'Hrodzyenskaya Voblasts'''),
('BY', 112, 'Belarus', '05', 'Minskaya Voblasts'''),
('BY', 112, 'Belarus', '06', 'Mahilyowskaya Voblasts'''),
('BY', 112, 'Belarus', '07', 'Vitsyebskaya Voblasts'''),
('BZ', 84, 'Belize', '01', 'Belize'),
('BZ', 84, 'Belize', '02', 'Cayo'),
('BZ', 84, 'Belize', '03', 'Corozal'),
('BZ', 84, 'Belize', '04', 'Orange Walk'),
('BZ', 84, 'Belize', '05', 'Stann Creek'),
('BZ', 84, 'Belize', '06', 'Toledo'),
('CA', 124, 'Canada', '01', 'Alberta'),
('CA', 124, 'Canada', '02', 'British Columbia'),
('CA', 124, 'Canada', '03', 'Manitoba'),
('CA', 124, 'Canada', '04', 'New Brunswick'),
('CA', 124, 'Canada', '05', 'Newfoundland and Labrador'),
('CA', 124, 'Canada', '07', 'Nova Scotia'),
('CA', 124, 'Canada', '08', 'Ontario'),
('CA', 124, 'Canada', '09', 'Prince Edward Island'),
('CA', 124, 'Canada', '10', 'Quebec'),
('CA', 124, 'Canada', '11', 'Saskatchewan'),
('CA', 124, 'Canada', '12', 'Yukon'),
('CA', 124, 'Canada', '13', 'Northwest Territories'),
('CA', 124, 'Canada', '14', 'Nunavut'),
('CC', 166, 'Cocos (Keeling) Islands', '00', 'Cocos Islands and Keeling Islands'),
('CD', 180, 'Congo, The Democratic Republic of The', '01', 'Bandundu'),
('CD', 180, 'Congo, The Democratic Republic of The', '02', 'Equateur'),
('CD', 180, 'Congo, The Democratic Republic of The', '03', 'Kasai-Occidental'),
('CD', 180, 'Congo, The Democratic Republic of The', '04', 'Kasai-Oriental'),
('CD', 180, 'Congo, The Democratic Republic of The', '05', 'Katanga'),
('CD', 180, 'Congo, The Democratic Republic of The', '06', 'Kinshasa'),
('CD', 180, 'Congo, The Democratic Republic of The', '08', 'Bas-Congo'),
('CD', 180, 'Congo, The Democratic Republic of The', '09', 'Orientale'),
('CD', 180, 'Congo, The Democratic Republic of The', '10', 'Maniema'),
('CD', 180, 'Congo, The Democratic Republic of The', '11', 'Nord-Kivu'),
('CD', 180, 'Congo, The Democratic Republic of The', '12', 'Sud-Kivu'),
('CF', 140, 'Central African Republic', '01', 'Bamingui-Bangoran'),
('CF', 140, 'Central African Republic', '02', 'Basse-Kotto'),
('CF', 140, 'Central African Republic', '03', 'Haute-Kotto'),
('CF', 140, 'Central African Republic', '04', 'Mambere-Kadei'),
('CF', 140, 'Central African Republic', '05', 'Haut-Mbomou'),
('CF', 140, 'Central African Republic', '06', 'Kemo'),
('CF', 140, 'Central African Republic', '07', 'Lobaye'),
('CF', 140, 'Central African Republic', '08', 'Mbomou'),
('CF', 140, 'Central African Republic', '09', 'Nana-Mambere'),
('CF', 140, 'Central African Republic', '11', 'Ouaka'),
('CF', 140, 'Central African Republic', '12', 'Ouham'),
('CF', 140, 'Central African Republic', '13', 'Ouham-Pende'),
('CF', 140, 'Central African Republic', '15', 'Nana-Grebizi'),
('CF', 140, 'Central African Republic', '16', 'Sangha-Mbaere'),
('CF', 140, 'Central African Republic', '17', 'Ombella-Mpoko'),
('CF', 140, 'Central African Republic', '18', 'Bangui'),
('CG', 178, 'Congo', '01', 'Bouenza'),
('CG', 178, 'Congo', '05', 'Lekoumou'),
('CG', 178, 'Congo', '06', 'Likouala'),
('CG', 178, 'Congo', '07', 'Niari'),
('CG', 178, 'Congo', '08', 'Plateaux'),
('CG', 178, 'Congo', '10', 'Sangha'),
('CG', 178, 'Congo', '11', 'Pool'),
('CG', 178, 'Congo', '12', 'Brazzaville'),
('CG', 178, 'Congo', '13', 'Cuvette'),
('CG', 178, 'Congo', '14', 'Cuvette-Ouest'),
('CG', 178, 'Congo', '15', 'Pointe-Noire'),
('CH', 756, 'Switzerland', '01', 'Aargau'),
('CH', 756, 'Switzerland', '02', 'Appenzell Ausserrhoden'),
('CH', 756, 'Switzerland', '03', 'Basel-Landschaft'),
('CH', 756, 'Switzerland', '04', 'Basel-Stadt'),
('CH', 756, 'Switzerland', '05', 'Bern'),
('CH', 756, 'Switzerland', '06', 'Fribourg'),
('CH', 756, 'Switzerland', '07', 'Geneve'),
('CH', 756, 'Switzerland', '08', 'Glarus'),
('CH', 756, 'Switzerland', '09', 'Graubunden'),
('CH', 756, 'Switzerland', '10', 'Appenzell Innerrhoden'),
('CH', 756, 'Switzerland', '11', 'Luzern'),
('CH', 756, 'Switzerland', '12', 'Neuchatel'),
('CH', 756, 'Switzerland', '13', 'Nidwalden'),
('CH', 756, 'Switzerland', '14', 'Obwalden'),
('CH', 756, 'Switzerland', '15', 'Sankt Gallen'),
('CH', 756, 'Switzerland', '16', 'Schaffhausen'),
('CH', 756, 'Switzerland', '17', 'Schwyz'),
('CH', 756, 'Switzerland', '18', 'Solothurn'),
('CH', 756, 'Switzerland', '19', 'Thurgau'),
('CH', 756, 'Switzerland', '20', 'Ticino'),
('CH', 756, 'Switzerland', '21', 'Uri'),
('CH', 756, 'Switzerland', '22', 'Valais'),
('CH', 756, 'Switzerland', '23', 'Vaud'),
('CH', 756, 'Switzerland', '24', 'Zug'),
('CH', 756, 'Switzerland', '25', 'Zurich'),
('CH', 756, 'Switzerland', '26', 'Jura'),
('CI', 384, 'Cote D''ivoire', '74', 'Agneby'),
('CI', 384, 'Cote D''ivoire', '75', 'Bafing'),
('CI', 384, 'Cote D''ivoire', '76', 'Bas-Sassandra'),
('CI', 384, 'Cote D''ivoire', '77', 'Denguele'),
('CI', 384, 'Cote D''ivoire', '78', 'Dix-Huit Montagnes'),
('CI', 384, 'Cote D''ivoire', '79', 'Fromager'),
('CI', 384, 'Cote D''ivoire', '80', 'Haut-Sassandra'),
('CI', 384, 'Cote D''ivoire', '81', 'Lacs'),
('CI', 384, 'Cote D''ivoire', '82', 'Lagunes'),
('CI', 384, 'Cote D''ivoire', '83', 'Marahoue'),
('CI', 384, 'Cote D''ivoire', '84', 'Moyen-Cavally'),
('CI', 384, 'Cote D''ivoire', '85', 'Moyen-Comoe'),
('CI', 384, 'Cote D''ivoire', '86', 'N''zi-Comoe'),
('CI', 384, 'Cote D''ivoire', '87', 'Savanes'),
('CI', 384, 'Cote D''ivoire', '88', 'Sud-Bandama'),
('CI', 384, 'Cote D''ivoire', '89', 'Sud-Comoe'),
('CI', 384, 'Cote D''ivoire', '90', 'Vallee du Bandama'),
('CI', 384, 'Cote D''ivoire', '91', 'Worodougou'),
('CI', 384, 'Cote D''ivoire', '92', 'Zanzan'),
('CK', 184, 'Cook Islands', '00', 'Cook Islands'),
('CL', 152, 'Chile', '01', 'Valparaiso'),
('CL', 152, 'Chile', '02', 'Aysen'),
('CL', 152, 'Chile', '03', 'Antofagasta'),
('CL', 152, 'Chile', '04', 'Araucania'),
('CL', 152, 'Chile', '05', 'Atacama'),
('CL', 152, 'Chile', '06', 'Biobio'),
('CL', 152, 'Chile', '07', 'Coquimbo'),
('CL', 152, 'Chile', '08', 'Libertador General Bernardo O''Higgins'),
('CL', 152, 'Chile', '10', 'Magallanes'),
('CL', 152, 'Chile', '11', 'Maule'),
('CL', 152, 'Chile', '12', 'Region Metropolitana de Santiago'),
('CL', 152, 'Chile', '14', 'Los Lagos'),
('CL', 152, 'Chile', '15', 'Tarapaca'),
('CL', 152, 'Chile', '16', 'Arica y Parinacota'),
('CL', 152, 'Chile', '17', 'Los Rios'),
('CM', 120, 'Cameroon', '04', 'Est'),
('CM', 120, 'Cameroon', '05', 'Littoral'),
('CM', 120, 'Cameroon', '07', 'Nord-Ouest'),
('CM', 120, 'Cameroon', '08', 'Ouest'),
('CM', 120, 'Cameroon', '09', 'Sud-Ouest'),
('CM', 120, 'Cameroon', '10', 'Adamaoua'),
('CM', 120, 'Cameroon', '11', 'Centre'),
('CM', 120, 'Cameroon', '12', 'Extreme-Nord'),
('CM', 120, 'Cameroon', '13', 'Nord'),
('CM', 120, 'Cameroon', '14', 'Sud'),
('CN', 156, 'China', '01', 'Anhui'),
('CN', 156, 'China', '02', 'Zhejiang'),
('CN', 156, 'China', '03', 'Jiangxi'),
('CN', 156, 'China', '04', 'Jiangsu'),
('CN', 156, 'China', '05', 'Jilin'),
('CN', 156, 'China', '06', 'Qinghai'),
('CN', 156, 'China', '07', 'Fujian'),
('CN', 156, 'China', '08', 'Heilongjiang'),
('CN', 156, 'China', '09', 'Henan'),
('CN', 156, 'China', '10', 'Hebei'),
('CN', 156, 'China', '11', 'Hunan'),
('CN', 156, 'China', '12', 'Hubei'),
('CN', 156, 'China', '13', 'Xinjiang'),
('CN', 156, 'China', '14', 'Xizang'),
('CN', 156, 'China', '15', 'Gansu'),
('CN', 156, 'China', '16', 'Guangxi'),
('CN', 156, 'China', '18', 'Guizhou'),
('CN', 156, 'China', '19', 'Liaoning'),
('CN', 156, 'China', '20', 'Nei Mongol'),
('CN', 156, 'China', '21', 'Ningxia'),
('CN', 156, 'China', '22', 'Beijing'),
('CN', 156, 'China', '23', 'Shanghai'),
('CN', 156, 'China', '24', 'Shanxi'),
('CN', 156, 'China', '25', 'Shandong'),
('CN', 156, 'China', '26', 'Shaanxi'),
('CN', 156, 'China', '28', 'Tianjin'),
('CN', 156, 'China', '29', 'Yunnan'),
('CN', 156, 'China', '30', 'Guangdong'),
('CN', 156, 'China', '31', 'Hainan'),
('CN', 156, 'China', '32', 'Sichuan'),
('CN', 156, 'China', '33', 'Chongqing'),
('CO', 170, 'Colombia', '01', 'Amazonas'),
('CO', 170, 'Colombia', '02', 'Antioquia'),
('CO', 170, 'Colombia', '03', 'Arauca'),
('CO', 170, 'Colombia', '04', 'Atlantico'),
('CO', 170, 'Colombia', '08', 'Caqueta'),
('CO', 170, 'Colombia', '09', 'Cauca'),
('CO', 170, 'Colombia', '10', 'Cesar'),
('CO', 170, 'Colombia', '11', 'Choco'),
('CO', 170, 'Colombia', '12', 'Cordoba'),
('CO', 170, 'Colombia', '14', 'Guaviare'),
('CO', 170, 'Colombia', '15', 'Guainia'),
('CO', 170, 'Colombia', '16', 'Huila'),
('CO', 170, 'Colombia', '17', 'La Guajira'),
('CO', 170, 'Colombia', '19', 'Meta'),
('CO', 170, 'Colombia', '20', 'Narino'),
('CO', 170, 'Colombia', '21', 'Norte de Santander'),
('CO', 170, 'Colombia', '22', 'Putumayo'),
('CO', 170, 'Colombia', '23', 'Quindio'),
('CO', 170, 'Colombia', '24', 'Risaralda'),
('CO', 170, 'Colombia', '25', 'San Andres, Providencia y Santa Catalina'),
('CO', 170, 'Colombia', '26', 'Santander'),
('CO', 170, 'Colombia', '27', 'Sucre'),
('CO', 170, 'Colombia', '28', 'Tolima'),
('CO', 170, 'Colombia', '29', 'Valle del Cauca'),
('CO', 170, 'Colombia', '30', 'Vaupes'),
('CO', 170, 'Colombia', '31', 'Vichada'),
('CO', 170, 'Colombia', '32', 'Casanare'),
('CO', 170, 'Colombia', '33', 'Cundinamarca'),
('CO', 170, 'Colombia', '34', 'Distrito Capital de Bogota'),
('CO', 170, 'Colombia', '35', 'Bolivar'),
('CO', 170, 'Colombia', '36', 'Boyaca'),
('CO', 170, 'Colombia', '37', 'Caldas'),
('CO', 170, 'Colombia', '38', 'Magdalena'),
('CR', 188, 'Costa Rica', '01', 'Alajuela'),
('CR', 188, 'Costa Rica', '02', 'Cartago'),
('CR', 188, 'Costa Rica', '03', 'Guanacaste'),
('CR', 188, 'Costa Rica', '04', 'Heredia'),
('CR', 188, 'Costa Rica', '06', 'Limon'),
('CR', 188, 'Costa Rica', '07', 'Puntarenas'),
('CR', 188, 'Costa Rica', '08', 'San Jose'),
('CU', 192, 'Cuba', '01', 'Pinar del Rio'),
('CU', 192, 'Cuba', '02', 'La Habana'),
('CU', 192, 'Cuba', '03', 'Matanzas'),
('CU', 192, 'Cuba', '04', 'Isla de la Juventud'),
('CU', 192, 'Cuba', '05', 'Camaguey'),
('CU', 192, 'Cuba', '07', 'Ciego de Avila'),
('CU', 192, 'Cuba', '08', 'Cienfuegos'),
('CU', 192, 'Cuba', '09', 'Granma'),
('CU', 192, 'Cuba', '10', 'Guantanamo'),
('CU', 192, 'Cuba', '11', 'La Habana'),
('CU', 192, 'Cuba', '12', 'Holguin'),
('CU', 192, 'Cuba', '13', 'Las Tunas'),
('CU', 192, 'Cuba', '14', 'Sancti Spiritus'),
('CU', 192, 'Cuba', '15', 'Santiago de Cuba'),
('CU', 192, 'Cuba', '16', 'Villa Clara'),
('CU', 192, 'Cuba', '17', 'Artemisa'),
('CU', 192, 'Cuba', '18', 'Mayabeque'),
('CV', 132, 'Cabo Verde', '01', 'Boa Vista'),
('CV', 132, 'Cabo Verde', '02', 'Brava'),
('CV', 132, 'Cabo Verde', '04', 'Maio'),
('CV', 132, 'Cabo Verde', '05', 'Paul'),
('CV', 132, 'Cabo Verde', '07', 'Ribeira Grande'),
('CV', 132, 'Cabo Verde', '08', 'Sal'),
('CV', 132, 'Cabo Verde', '11', 'Sao Vicente'),
('CV', 132, 'Cabo Verde', '13', 'Mosteiros'),
('CV', 132, 'Cabo Verde', '14', 'Praia'),
('CV', 132, 'Cabo Verde', '15', 'Santa Catarina'),
('CV', 132, 'Cabo Verde', '16', 'Santa Cruz'),
('CV', 132, 'Cabo Verde', '17', 'Sao Domingos'),
('CV', 132, 'Cabo Verde', '18', 'Sao Filipe'),
('CV', 132, 'Cabo Verde', '19', 'Sao Miguel'),
('CV', 132, 'Cabo Verde', '20', 'Tarrafal'),
('CV', 132, 'Cabo Verde', '21', 'Porto Novo'),
('CV', 132, 'Cabo Verde', '22', 'Ribeira Brava'),
('CV', 132, 'Cabo Verde', '23', 'Ribeira Grande de Santiago'),
('CV', 132, 'Cabo Verde', '24', 'Santa Catarina do Fogo'),
('CV', 132, 'Cabo Verde', '26', 'Sao Salvador do Mundo'),
('CV', 132, 'Cabo Verde', '27', 'Tarrafal de Sao Nicolau'),
('CW', 531, 'Curacao', '00', 'Curacao'),
('CX', 162, 'Christmas Island', '00', 'Christmas Island'),
('CY', 196, 'Cyprus', '01', 'Ammochostos'),
('CY', 196, 'Cyprus', '02', 'Keryneia'),
('CY', 196, 'Cyprus', '03', 'Larnaka'),
('CY', 196, 'Cyprus', '04', 'Lefkosia'),
('CY', 196, 'Cyprus', '05', 'Lemesos'),
('CY', 196, 'Cyprus', '06', 'Pafos'),
('CZ', 203, 'Czech Republic', '52', 'Praha, hlavni mesto'),
('CZ', 203, 'Czech Republic', '78', 'Jihomoravsky kraj'),
('CZ', 203, 'Czech Republic', '79', 'Jihocesky kraj'),
('CZ', 203, 'Czech Republic', '80', 'Vysocina kraj'),
('CZ', 203, 'Czech Republic', '81', 'Karlovarsky kraj'),
('CZ', 203, 'Czech Republic', '82', 'Kralovehradecky kraj'),
('CZ', 203, 'Czech Republic', '83', 'Liberecky kraj'),
('CZ', 203, 'Czech Republic', '84', 'Olomoucky kraj'),
('CZ', 203, 'Czech Republic', '85', 'Moravskoslezsky kraj'),
('CZ', 203, 'Czech Republic', '86', 'Pardubicky kraj'),
('CZ', 203, 'Czech Republic', '87', 'Plzensky kraj'),
('CZ', 203, 'Czech Republic', '88', 'Stredocesky kraj'),
('CZ', 203, 'Czech Republic', '89', 'Ustecky kraj'),
('CZ', 203, 'Czech Republic', '90', 'Zlinsky kraj'),
('DE', 276, 'Germany', '01', 'Baden-Wurttemberg'),
('DE', 276, 'Germany', '02', 'Bayern'),
('DE', 276, 'Germany', '03', 'Bremen'),
('DE', 276, 'Germany', '04', 'Hamburg'),
('DE', 276, 'Germany', '05', 'Hessen'),
('DE', 276, 'Germany', '06', 'Niedersachsen'),
('DE', 276, 'Germany', '07', 'Nordrhein-Westfalen'),
('DE', 276, 'Germany', '08', 'Rheinland-Pfalz'),
('DE', 276, 'Germany', '09', 'Saarland'),
('DE', 276, 'Germany', '10', 'Schleswig-Holstein'),
('DE', 276, 'Germany', '11', 'Brandenburg'),
('DE', 276, 'Germany', '12', 'Mecklenburg-Vorpommern'),
('DE', 276, 'Germany', '13', 'Sachsen'),
('DE', 276, 'Germany', '14', 'Sachsen-Anhalt'),
('DE', 276, 'Germany', '15', 'Thuringen'),
('DE', 276, 'Germany', '16', 'Berlin'),
('DJ', 262, 'Djibouti', '01', 'Ali Sabieh'),
('DJ', 262, 'Djibouti', '04', 'Obock'),
('DJ', 262, 'Djibouti', '05', 'Tadjourah'),
('DJ', 262, 'Djibouti', '06', 'Dikhil'),
('DJ', 262, 'Djibouti', '07', 'Djibouti'),
('DJ', 262, 'Djibouti', '08', 'Arta'),
('DK', 208, 'Denmark', '17', 'Hovedstaden'),
('DK', 208, 'Denmark', '18', 'Midtjylland'),
('DK', 208, 'Denmark', '19', 'Nordjylland'),
('DK', 208, 'Denmark', '20', 'Sjelland'),
('DK', 208, 'Denmark', '21', 'Syddanmark'),
('DM', 212, 'Dominica', '02', 'Saint Andrew'),
('DM', 212, 'Dominica', '03', 'Saint David'),
('DM', 212, 'Dominica', '04', 'Saint George'),
('DM', 212, 'Dominica', '05', 'Saint John'),
('DM', 212, 'Dominica', '06', 'Saint Joseph'),
('DM', 212, 'Dominica', '07', 'Saint Luke'),
('DM', 212, 'Dominica', '08', 'Saint Mark'),
('DM', 212, 'Dominica', '09', 'Saint Patrick'),
('DM', 212, 'Dominica', '10', 'Saint Paul'),
('DO', 214, 'Dominican Republic', '01', 'Azua'),
('DO', 214, 'Dominican Republic', '02', 'Baoruco'),
('DO', 214, 'Dominican Republic', '03', 'Barahona'),
('DO', 214, 'Dominican Republic', '04', 'Dajabon'),
('DO', 214, 'Dominican Republic', '06', 'Duarte'),
('DO', 214, 'Dominican Republic', '08', 'Espaillat'),
('DO', 214, 'Dominican Republic', '09', 'Independencia'),
('DO', 214, 'Dominican Republic', '10', 'La Altagracia'),
('DO', 214, 'Dominican Republic', '11', 'Elias Pina'),
('DO', 214, 'Dominican Republic', '12', 'La Romana'),
('DO', 214, 'Dominican Republic', '14', 'Maria Trinidad Sanchez'),
('DO', 214, 'Dominican Republic', '15', 'Monte Cristi'),
('DO', 214, 'Dominican Republic', '16', 'Pedernales'),
('DO', 214, 'Dominican Republic', '18', 'Puerto Plata'),
('DO', 214, 'Dominican Republic', '19', 'Salcedo'),
('DO', 214, 'Dominican Republic', '20', 'Samana'),
('DO', 214, 'Dominican Republic', '21', 'Sanchez Ramirez'),
('DO', 214, 'Dominican Republic', '23', 'San Juan'),
('DO', 214, 'Dominican Republic', '24', 'San Pedro De Macoris'),
('DO', 214, 'Dominican Republic', '25', 'Santiago'),
('DO', 214, 'Dominican Republic', '26', 'Santiago Rodriguez'),
('DO', 214, 'Dominican Republic', '27', 'Valverde'),
('DO', 214, 'Dominican Republic', '28', 'El Seibo'),
('DO', 214, 'Dominican Republic', '29', 'Hato Mayor'),
('DO', 214, 'Dominican Republic', '30', 'La Vega'),
('DO', 214, 'Dominican Republic', '31', 'Monsenor Nouel'),
('DO', 214, 'Dominican Republic', '32', 'Monte Plata'),
('DO', 214, 'Dominican Republic', '33', 'San Cristobal'),
('DO', 214, 'Dominican Republic', '34', 'Distrito Nacional'),
('DO', 214, 'Dominican Republic', '35', 'Peravia'),
('DZ', 12, 'Algeria', '01', 'Alger'),
('DZ', 12, 'Algeria', '03', 'Batna'),
('DZ', 12, 'Algeria', '04', 'Constantine'),
('DZ', 12, 'Algeria', '06', 'Medea'),
('DZ', 12, 'Algeria', '07', 'Mostaganem'),
('DZ', 12, 'Algeria', '09', 'Oran'),
('DZ', 12, 'Algeria', '10', 'Saida'),
('DZ', 12, 'Algeria', '12', 'Setif'),
('DZ', 12, 'Algeria', '13', 'Tiaret'),
('DZ', 12, 'Algeria', '14', 'Tizi Ouzou'),
('DZ', 12, 'Algeria', '15', 'Tlemcen'),
('DZ', 12, 'Algeria', '18', 'Bejaia'),
('DZ', 12, 'Algeria', '19', 'Biskra'),
('DZ', 12, 'Algeria', '20', 'Blida'),
('DZ', 12, 'Algeria', '21', 'Bouira'),
('DZ', 12, 'Algeria', '22', 'Djelfa'),
('DZ', 12, 'Algeria', '23', 'Guelma'),
('DZ', 12, 'Algeria', '25', 'Laghouat'),
('DZ', 12, 'Algeria', '26', 'Mascara'),
('DZ', 12, 'Algeria', '27', 'Msila'),
('DZ', 12, 'Algeria', '29', 'Oum el Bouaghi'),
('DZ', 12, 'Algeria', '30', 'Sidi Bel Abbes'),
('DZ', 12, 'Algeria', '31', 'Skikda'),
('DZ', 12, 'Algeria', '33', 'Tebessa'),
('DZ', 12, 'Algeria', '34', 'Adrar'),
('DZ', 12, 'Algeria', '35', 'Ain Defla'),
('DZ', 12, 'Algeria', '36', 'Ain Temouchent'),
('DZ', 12, 'Algeria', '37', 'Annaba'),
('DZ', 12, 'Algeria', '38', 'Bechar'),
('DZ', 12, 'Algeria', '39', 'Bordj Bou Arreridj'),
('DZ', 12, 'Algeria', '40', 'Boumerdes'),
('DZ', 12, 'Algeria', '41', 'Chlef'),
('DZ', 12, 'Algeria', '42', 'El Bayadh'),
('DZ', 12, 'Algeria', '43', 'El Oued'),
('DZ', 12, 'Algeria', '44', 'El Tarf'),
('DZ', 12, 'Algeria', '45', 'Ghardaia'),
('DZ', 12, 'Algeria', '46', 'Illizi'),
('DZ', 12, 'Algeria', '47', 'Khenchela'),
('DZ', 12, 'Algeria', '48', 'Mila'),
('DZ', 12, 'Algeria', '49', 'Naama'),
('DZ', 12, 'Algeria', '50', 'Ouargla'),
('DZ', 12, 'Algeria', '51', 'Relizane'),
('DZ', 12, 'Algeria', '52', 'Souk Ahras'),
('DZ', 12, 'Algeria', '53', 'Tamanrasset'),
('DZ', 12, 'Algeria', '54', 'Tindouf'),
('DZ', 12, 'Algeria', '55', 'Tipaza'),
('DZ', 12, 'Algeria', '56', 'Tissemsilt'),
('EC', 218, 'Ecuador', '01', 'Galapagos'),
('EC', 218, 'Ecuador', '02', 'Azuay'),
('EC', 218, 'Ecuador', '03', 'Bolivar'),
('EC', 218, 'Ecuador', '04', 'Canar'),
('EC', 218, 'Ecuador', '05', 'Carchi'),
('EC', 218, 'Ecuador', '06', 'Chimborazo'),
('EC', 218, 'Ecuador', '07', 'Cotopaxi'),
('EC', 218, 'Ecuador', '08', 'El Oro'),
('EC', 218, 'Ecuador', '09', 'Esmeraldas'),
('EC', 218, 'Ecuador', '10', 'Guayas'),
('EC', 218, 'Ecuador', '11', 'Imbabura'),
('EC', 218, 'Ecuador', '12', 'Loja'),
('EC', 218, 'Ecuador', '13', 'Los Rios'),
('EC', 218, 'Ecuador', '14', 'Manabi'),
('EC', 218, 'Ecuador', '15', 'Morona-Santiago'),
('EC', 218, 'Ecuador', '17', 'Pastaza'),
('EC', 218, 'Ecuador', '18', 'Pichincha'),
('EC', 218, 'Ecuador', '19', 'Tungurahua'),
('EC', 218, 'Ecuador', '20', 'Zamora-Chinchipe'),
('EC', 218, 'Ecuador', '22', 'Sucumbios'),
('EC', 218, 'Ecuador', '23', 'Napo'),
('EC', 218, 'Ecuador', '24', 'Orellana'),
('EC', 218, 'Ecuador', '25', 'Santa Elena'),
('EE', 233, 'Estonia', '01', 'Harjumaa'),
('EE', 233, 'Estonia', '02', 'Hiiumaa'),
('EE', 233, 'Estonia', '03', 'Ida-Virumaa'),
('EE', 233, 'Estonia', '04', 'Jarvamaa'),
('EE', 233, 'Estonia', '05', 'Jogevamaa'),
('EE', 233, 'Estonia', '07', 'Laanemaa'),
('EE', 233, 'Estonia', '08', 'Laane-Virumaa'),
('EE', 233, 'Estonia', '11', 'Parnumaa'),
('EE', 233, 'Estonia', '12', 'Polvamaa'),
('EE', 233, 'Estonia', '13', 'Raplamaa'),
('EE', 233, 'Estonia', '14', 'Saaremaa'),
('EE', 233, 'Estonia', '18', 'Tartumaa'),
('EE', 233, 'Estonia', '19', 'Valgamaa'),
('EE', 233, 'Estonia', '20', 'Viljandimaa'),
('EE', 233, 'Estonia', '21', 'Vorumaa'),
('EG', 818, 'Egypt', '01', 'Ad Daqahliyah'),
('EG', 818, 'Egypt', '02', 'Al Bahr al Ahmar'),
('EG', 818, 'Egypt', '03', 'Al Buhayrah'),
('EG', 818, 'Egypt', '04', 'Al Fayyum'),
('EG', 818, 'Egypt', '05', 'Al Gharbiyah'),
('EG', 818, 'Egypt', '06', 'Al Iskandariyah'),
('EG', 818, 'Egypt', '07', 'Al Ismailiyah'),
('EG', 818, 'Egypt', '08', 'Al Jizah'),
('EG', 818, 'Egypt', '09', 'Al Minufiyah'),
('EG', 818, 'Egypt', '10', 'Al Minya'),
('EG', 818, 'Egypt', '11', 'Al Qahirah'),
('EG', 818, 'Egypt', '12', 'Al Qalyubiyah'),
('EG', 818, 'Egypt', '13', 'Al Wadi al Jadid'),
('EG', 818, 'Egypt', '14', 'Ash Sharqiyah'),
('EG', 818, 'Egypt', '15', 'As Suways'),
('EG', 818, 'Egypt', '16', 'Aswan'),
('EG', 818, 'Egypt', '17', 'Asyut'),
('EG', 818, 'Egypt', '18', 'Bani Suwayf'),
('EG', 818, 'Egypt', '19', 'Bur Sa''id'),
('EG', 818, 'Egypt', '20', 'Dumyat'),
('EG', 818, 'Egypt', '21', 'Kafr ash Shaykh'),
('EG', 818, 'Egypt', '22', 'Matruh'),
('EG', 818, 'Egypt', '23', 'Qina'),
('EG', 818, 'Egypt', '24', 'Suhaj'),
('EG', 818, 'Egypt', '26', 'Janub Sina'''),
('EG', 818, 'Egypt', '27', 'Shamal Sina'''),
('EG', 818, 'Egypt', '28', 'Al Uqsur'),
('EH', 732, 'Western Sahara', '00', 'Western Sahara'),
('EH', 732, 'Western Sahara', 'CE', 'Oued Ed-Dahab-Lagouira'),
('ER', 232, 'Eritrea', '01', 'Ansaba'),
('ER', 232, 'Eritrea', '02', 'Al Janubi'),
('ER', 232, 'Eritrea', '03', 'Janubi al Bahri al Ahmar'),
('ER', 232, 'Eritrea', '04', 'Qash-Barkah'),
('ER', 232, 'Eritrea', '05', 'Al Awsat'),
('ER', 232, 'Eritrea', '06', 'Shimali al Bahri al Ahmar'),
('ES', 724, 'Spain', '07', 'Illes Balears'),
('ES', 724, 'Spain', '27', 'La Rioja'),
('ES', 724, 'Spain', '29', 'Madrid, Comunidad de'),
('ES', 724, 'Spain', '31', 'Murcia, Region de'),
('ES', 724, 'Spain', '32', 'Navarra, Comunidad Foral de'),
('ES', 724, 'Spain', '34', 'Asturias, Principado de'),
('ES', 724, 'Spain', '39', 'Cantabria'),
('ES', 724, 'Spain', '51', 'Andalucia'),
('ES', 724, 'Spain', '52', 'Aragon'),
('ES', 724, 'Spain', '53', 'Canarias'),
('ES', 724, 'Spain', '54', 'Castilla-La Mancha'),
('ES', 724, 'Spain', '55', 'Castilla y Leon'),
('ES', 724, 'Spain', '56', 'Catalunya'),
('ES', 724, 'Spain', '57', 'Extremadura'),
('ES', 724, 'Spain', '58', 'Galicia'),
('ES', 724, 'Spain', '59', 'Pais Vasco'),
('ES', 724, 'Spain', '60', 'Valenciana, Comunidad'),
('ES', 724, 'Spain', 'CE', 'Ceuta'),
('ES', 724, 'Spain', 'ML', 'Melilla'),
('ET', 231, 'Ethiopia', '44', 'Adis Abeba'),
('ET', 231, 'Ethiopia', '45', 'Afar'),
('ET', 231, 'Ethiopia', '46', 'Amara'),
('ET', 231, 'Ethiopia', '47', 'Binshangul Gumuz'),
('ET', 231, 'Ethiopia', '48', 'Dire Dawa'),
('ET', 231, 'Ethiopia', '49', 'Gambela Hizboch'),
('ET', 231, 'Ethiopia', '50', 'Hareri Hizb'),
('ET', 231, 'Ethiopia', '51', 'Oromiya'),
('ET', 231, 'Ethiopia', '52', 'Sumale'),
('ET', 231, 'Ethiopia', '53', 'Tigray'),
('ET', 231, 'Ethiopia', '54', 'YeDebub Biheroch Bihereseboch na Hizboch'),
('FI', 246, 'Finland', '17', 'Etela-Karjala'),
('FI', 246, 'Finland', '18', 'Etela-Pohjanmaa'),
('FI', 246, 'Finland', '19', 'Etela-Savo'),
('FI', 246, 'Finland', '20', 'Kanta-Hame'),
('FI', 246, 'Finland', '22', 'Kainuu'),
('FI', 246, 'Finland', '23', 'Keski-Pohjanmaa'),
('FI', 246, 'Finland', '24', 'Keski-Suomi'),
('FI', 246, 'Finland', '25', 'Kymenlaakso'),
('FI', 246, 'Finland', '26', 'Lappi'),
('FI', 246, 'Finland', '27', 'Paijat-Hame'),
('FI', 246, 'Finland', '28', 'Pirkanmaa'),
('FI', 246, 'Finland', '29', 'Pohjanmaa'),
('FI', 246, 'Finland', '30', 'Pohjois-Karjala'),
('FI', 246, 'Finland', '31', 'Pohjois-Pohjanmaa'),
('FI', 246, 'Finland', '32', 'Satakunta'),
('FI', 246, 'Finland', '33', 'Pohjois-Savo'),
('FI', 246, 'Finland', '34', 'Varsinais-Suomi'),
('FI', 246, 'Finland', '35', 'Uusimaa'),
('FJ', 242, 'Fiji', '01', 'Central'),
('FJ', 242, 'Fiji', '03', 'Northern'),
('FJ', 242, 'Fiji', '05', 'Western'),
('FK', 238, 'Falkland Islands (Malvinas)', '00', 'Falkland Islands'),
('FM', 583, 'Micronesia, Federated States of', '01', 'Kosrae'),
('FM', 583, 'Micronesia, Federated States of', '02', 'Pohnpei'),
('FM', 583, 'Micronesia, Federated States of', '03', 'Chuuk'),
('FM', 583, 'Micronesia, Federated States of', '04', 'Yap'),
('FO', 234, 'Faroe Islands', 'NO', 'Nordoyar'),
('FO', 234, 'Faroe Islands', 'OS', 'Eysturoy'),
('FO', 234, 'Faroe Islands', 'SA', 'Sandoy'),
('FO', 234, 'Faroe Islands', 'ST', 'Streymoy'),
('FO', 234, 'Faroe Islands', 'SU', 'Suduroy'),
('FO', 234, 'Faroe Islands', 'VG', 'Vagar'),
('FR', 250, 'France', '97', 'Aquitaine'),
('FR', 250, 'France', '98', 'Auvergne'),
('FR', 250, 'France', '99', 'Basse-Normandie'),
('FR', 250, 'France', 'A1', 'Bourgogne'),
('FR', 250, 'France', 'A2', 'Bretagne'),
('FR', 250, 'France', 'A3', 'Centre'),
('FR', 250, 'France', 'A4', 'Champagne-Ardenne'),
('FR', 250, 'France', 'A5', 'Corse'),
('FR', 250, 'France', 'A6', 'Franche-Comte'),
('FR', 250, 'France', 'A7', 'Haute-Normandie'),
('FR', 250, 'France', 'A8', 'Ile-de-France'),
('FR', 250, 'France', 'A9', 'Languedoc-Roussillon'),
('FR', 250, 'France', 'B1', 'Limousin'),
('FR', 250, 'France', 'B2', 'Lorraine'),
('FR', 250, 'France', 'B3', 'Midi-Pyrenees'),
('FR', 250, 'France', 'B4', 'Nord-Pas-de-Calais'),
('FR', 250, 'France', 'B5', 'Pays de la Loire'),
('FR', 250, 'France', 'B6', 'Picardie'),
('FR', 250, 'France', 'B7', 'Poitou-Charentes'),
('FR', 250, 'France', 'B8', 'Provence-Alpes-Cote d''Azur'),
('FR', 250, 'France', 'B9', 'Rhone-Alpes'),
('FR', 250, 'France', 'C1', 'Alsace'),
('GA', 266, 'Gabon', '01', 'Estuaire'),
('GA', 266, 'Gabon', '02', 'Haut-Ogooue'),
('GA', 266, 'Gabon', '03', 'Moyen-Ogooue'),
('GA', 266, 'Gabon', '04', 'Ngounie'),
('GA', 266, 'Gabon', '05', 'Nyanga'),
('GA', 266, 'Gabon', '06', 'Ogooue-Ivindo'),
('GA', 266, 'Gabon', '07', 'Ogooue-Lolo'),
('GA', 266, 'Gabon', '08', 'Ogooue-Maritime'),
('GA', 266, 'Gabon', '09', 'Woleu-Ntem'),
('GB', 826, 'United Kingdom', 'ENG', 'England'),
('GB', 826, 'United Kingdom', 'NIR', 'Northern Ireland'),
('GB', 826, 'United Kingdom', 'SCT', 'Scotland'),
('GB', 826, 'United Kingdom', 'WLS', 'Wales'),
('GD', 308, 'Grenada', '01', 'Saint Andrew'),
('GD', 308, 'Grenada', '02', 'Saint David'),
('GD', 308, 'Grenada', '03', 'Saint George'),
('GD', 308, 'Grenada', '04', 'Saint John'),
('GD', 308, 'Grenada', '05', 'Saint Mark'),
('GD', 308, 'Grenada', '06', 'Saint Patrick'),
('GE', 268, 'Georgia', '02', 'Abkhazia'),
('GE', 268, 'Georgia', '04', 'Ajaria'),
('GE', 268, 'Georgia', '06', 'Akhalk''alak''is Raioni'),
('GE', 268, 'Georgia', '11', 'Baghdat''is Raioni'),
('GE', 268, 'Georgia', '13', 'Borjomis Raioni'),
('GE', 268, 'Georgia', '22', 'Goris Raioni'),
('GE', 268, 'Georgia', '24', 'Javis Raioni'),
('GE', 268, 'Georgia', '25', 'K''arelis Raioni'),
('GE', 268, 'Georgia', '28', 'Khashuris Raioni'),
('GE', 268, 'Georgia', '51', 'T''bilisi'),
('GE', 268, 'Georgia', '61', 'Vanis Raioni'),
('GE', 268, 'Georgia', '65', 'Guria'),
('GE', 268, 'Georgia', '66', 'Imereti'),
('GE', 268, 'Georgia', '67', 'Kakheti'),
('GE', 268, 'Georgia', '68', 'Kvemo Kartli'),
('GE', 268, 'Georgia', '69', 'Mtskheta-Mtianeti'),
('GE', 268, 'Georgia', '70', 'Racha-Lechkhumi and Kvemo Svaneti'),
('GE', 268, 'Georgia', '71', 'Samegrelo and Zemo Svaneti'),
('GE', 268, 'Georgia', '72', 'Samtskhe-Javakheti'),
('GE', 268, 'Georgia', '73', 'Shida Kartli'),
('GF', 254, 'French Guiana', 'GF', 'Guyane'),
('GG', 831, 'Guernsey', '00', 'Guernsey (general)'),
('GH', 288, 'Ghana', '01', 'Greater Accra'),
('GH', 288, 'Ghana', '02', 'Ashanti'),
('GH', 288, 'Ghana', '03', 'Brong-Ahafo'),
('GH', 288, 'Ghana', '04', 'Central'),
('GH', 288, 'Ghana', '05', 'Eastern'),
('GH', 288, 'Ghana', '06', 'Northern'),
('GH', 288, 'Ghana', '08', 'Volta'),
('GH', 288, 'Ghana', '09', 'Western'),
('GH', 288, 'Ghana', '10', 'Upper East'),
('GH', 288, 'Ghana', '11', 'Upper West'),
('GI', 292, 'Gibraltar', '00', 'Gibraltar'),
('GL', 304, 'Greenland', '04', 'Kommune Kujalleq'),
('GL', 304, 'Greenland', '05', 'Qaasuitsup Kommunia'),
('GL', 304, 'Greenland', '06', 'Qeqqata Kommunia'),
('GL', 304, 'Greenland', '07', 'Kommuneqarfik Sermersooq'),
('GM', 270, 'Gambia', '01', 'Banjul'),
('GM', 270, 'Gambia', '02', 'Lower River'),
('GM', 270, 'Gambia', '03', 'Central River'),
('GM', 270, 'Gambia', '04', 'Upper River'),
('GM', 270, 'Gambia', '05', 'Western'),
('GM', 270, 'Gambia', '07', 'North Bank'),
('GN', 324, 'Guinea', '01', 'Beyla'),
('GN', 324, 'Guinea', '02', 'Boffa'),
('GN', 324, 'Guinea', '03', 'Boke'),
('GN', 324, 'Guinea', '04', 'Conakry'),
('GN', 324, 'Guinea', '05', 'Dabola'),
('GN', 324, 'Guinea', '06', 'Dalaba'),
('GN', 324, 'Guinea', '07', 'Dinguiraye'),
('GN', 324, 'Guinea', '09', 'Faranah'),
('GN', 324, 'Guinea', '10', 'Forecariah'),
('GN', 324, 'Guinea', '11', 'Fria'),
('GN', 324, 'Guinea', '12', 'Gaoual'),
('GN', 324, 'Guinea', '13', 'Gueckedou'),
('GN', 324, 'Guinea', '15', 'Kerouane'),
('GN', 324, 'Guinea', '16', 'Kindia'),
('GN', 324, 'Guinea', '17', 'Kissidougou'),
('GN', 324, 'Guinea', '18', 'Koundara'),
('GN', 324, 'Guinea', '19', 'Kouroussa'),
('GN', 324, 'Guinea', '21', 'Macenta'),
('GN', 324, 'Guinea', '22', 'Mali'),
('GN', 324, 'Guinea', '23', 'Mamou'),
('GN', 324, 'Guinea', '25', 'Pita'),
('GN', 324, 'Guinea', '27', 'Telimele'),
('GN', 324, 'Guinea', '28', 'Tougue'),
('GN', 324, 'Guinea', '29', 'Yomou'),
('GN', 324, 'Guinea', '30', 'Coyah'),
('GN', 324, 'Guinea', '31', 'Dubreka'),
('GN', 324, 'Guinea', '32', 'Kankan'),
('GN', 324, 'Guinea', '33', 'Koubia'),
('GN', 324, 'Guinea', '34', 'Labe'),
('GN', 324, 'Guinea', '35', 'Lelouma'),
('GN', 324, 'Guinea', '36', 'Lola'),
('GN', 324, 'Guinea', '37', 'Mandiana'),
('GN', 324, 'Guinea', '38', 'Nzerekore'),
('GN', 324, 'Guinea', '39', 'Siguiri'),
('GP', 312, 'Guadeloupe', 'GP', 'Guadeloupe'),
('GQ', 226, 'Equatorial Guinea', '03', 'Annobon'),
('GQ', 226, 'Equatorial Guinea', '04', 'Bioko Norte'),
('GQ', 226, 'Equatorial Guinea', '05', 'Bioko Sur'),
('GQ', 226, 'Equatorial Guinea', '06', 'Centro Sur'),
('GQ', 226, 'Equatorial Guinea', '07', 'Kie-Ntem'),
('GQ', 226, 'Equatorial Guinea', '08', 'Litoral'),
('GQ', 226, 'Equatorial Guinea', '09', 'Wele-Nzas'),
('GR', 300, 'Greece', '01', 'Evros'),
('GR', 300, 'Greece', '02', 'Rodhopi'),
('GR', 300, 'Greece', '03', 'Xanthi'),
('GR', 300, 'Greece', '04', 'Drama'),
('GR', 300, 'Greece', '05', 'Serrai'),
('GR', 300, 'Greece', '06', 'Kilkis'),
('GR', 300, 'Greece', '07', 'Pella'),
('GR', 300, 'Greece', '08', 'Florina'),
('GR', 300, 'Greece', '09', 'Kastoria'),
('GR', 300, 'Greece', '10', 'Grevena'),
('GR', 300, 'Greece', '11', 'Kozani'),
('GR', 300, 'Greece', '12', 'Imathia'),
('GR', 300, 'Greece', '13', 'Thessaloniki'),
('GR', 300, 'Greece', '14', 'Kavala'),
('GR', 300, 'Greece', '15', 'Khalkidhiki'),
('GR', 300, 'Greece', '16', 'Pieria'),
('GR', 300, 'Greece', '17', 'Ioannina'),
('GR', 300, 'Greece', '18', 'Thesprotia'),
('GR', 300, 'Greece', '19', 'Preveza'),
('GR', 300, 'Greece', '20', 'Arta'),
('GR', 300, 'Greece', '21', 'Larisa'),
('GR', 300, 'Greece', '22', 'Trikala'),
('GR', 300, 'Greece', '23', 'Kardhitsa'),
('GR', 300, 'Greece', '24', 'Magnisia'),
('GR', 300, 'Greece', '25', 'Kerkira'),
('GR', 300, 'Greece', '26', 'Levkas'),
('GR', 300, 'Greece', '27', 'Kefallinia'),
('GR', 300, 'Greece', '28', 'Zakinthos'),
('GR', 300, 'Greece', '29', 'Fthiotis'),
('GR', 300, 'Greece', '30', 'Evritania'),
('GR', 300, 'Greece', '31', 'Aitolia kai Akarnania'),
('GR', 300, 'Greece', '32', 'Fokis'),
('GR', 300, 'Greece', '33', 'Voiotia'),
('GR', 300, 'Greece', '34', 'Evvoia'),
('GR', 300, 'Greece', '35', 'Attiki'),
('GR', 300, 'Greece', '36', 'Argolis'),
('GR', 300, 'Greece', '37', 'Korinthia'),
('GR', 300, 'Greece', '38', 'Akhaia'),
('GR', 300, 'Greece', '39', 'Ilia'),
('GR', 300, 'Greece', '40', 'Messinia'),
('GR', 300, 'Greece', '41', 'Arkadhia'),
('GR', 300, 'Greece', '42', 'Lakonia'),
('GR', 300, 'Greece', '43', 'Khania'),
('GR', 300, 'Greece', '44', 'Rethimni'),
('GR', 300, 'Greece', '45', 'Iraklion'),
('GR', 300, 'Greece', '46', 'Lasithi'),
('GR', 300, 'Greece', '47', 'Dhodhekanisos'),
('GR', 300, 'Greece', '48', 'Samos'),
('GR', 300, 'Greece', '49', 'Kikladhes'),
('GR', 300, 'Greece', '50', 'Khios'),
('GR', 300, 'Greece', '51', 'Lesvos'),
('GS', 239, 'South Georgia and The South Sandwich Islands', '00', 'South Georgia and the South Sandwich Islands'),
('GT', 320, 'Guatemala', '01', 'Alta Verapaz'),
('GT', 320, 'Guatemala', '02', 'Baja Verapaz'),
('GT', 320, 'Guatemala', '03', 'Chimaltenango'),
('GT', 320, 'Guatemala', '04', 'Chiquimula'),
('GT', 320, 'Guatemala', '05', 'El Progreso'),
('GT', 320, 'Guatemala', '06', 'Escuintla'),
('GT', 320, 'Guatemala', '07', 'Guatemala'),
('GT', 320, 'Guatemala', '08', 'Huehuetenango'),
('GT', 320, 'Guatemala', '09', 'Izabal'),
('GT', 320, 'Guatemala', '10', 'Jalapa'),
('GT', 320, 'Guatemala', '11', 'Jutiapa'),
('GT', 320, 'Guatemala', '12', 'Peten'),
('GT', 320, 'Guatemala', '13', 'Quetzaltenango'),
('GT', 320, 'Guatemala', '14', 'Quiche'),
('GT', 320, 'Guatemala', '15', 'Retalhuleu'),
('GT', 320, 'Guatemala', '16', 'Sacatepequez'),
('GT', 320, 'Guatemala', '17', 'San Marcos'),
('GT', 320, 'Guatemala', '18', 'Santa Rosa'),
('GT', 320, 'Guatemala', '19', 'Solola'),
('GT', 320, 'Guatemala', '20', 'Suchitepequez'),
('GT', 320, 'Guatemala', '21', 'Totonicapan'),
('GT', 320, 'Guatemala', '22', 'Zacapa'),
('GU', 316, 'Guam', 'AH', 'Agana Heights Municipality'),
('GU', 316, 'Guam', 'AN', 'Hagatna Municipality'),
('GU', 316, 'Guam', 'AS', 'Asan-Maina Municipality'),
('GU', 316, 'Guam', 'AT', 'Agat Municipality'),
('GU', 316, 'Guam', 'BA', 'Barrigada Municipality'),
('GU', 316, 'Guam', 'CP', 'Chalan Pago-Ordot Municipality'),
('GU', 316, 'Guam', 'DD', 'Dededo Municipality'),
('GU', 316, 'Guam', 'IN', 'Inarajan Municipality'),
('GU', 316, 'Guam', 'MA', 'Mangilao Municipality'),
('GU', 316, 'Guam', 'ME', 'Merizo Municipality'),
('GU', 316, 'Guam', 'MT', 'Mongmong-Toto-Maite Municipality'),
('GU', 316, 'Guam', 'PI', 'Piti Municipality'),
('GU', 316, 'Guam', 'SJ', 'Sinajana Municipality'),
('GU', 316, 'Guam', 'SR', 'Santa Rita Municipality'),
('GU', 316, 'Guam', 'TF', 'Talofofo Municipality'),
('GU', 316, 'Guam', 'TM', 'Tamuning-Tumon-Harmon Municipality'),
('GU', 316, 'Guam', 'UM', 'Umatac Municipality'),
('GU', 316, 'Guam', 'YG', 'Yigo Municipality'),
('GU', 316, 'Guam', 'YN', 'Yona Municipality'),
('GW', 624, 'Guinea-Bissau', '01', 'Bafata'),
('GW', 624, 'Guinea-Bissau', '02', 'Quinara'),
('GW', 624, 'Guinea-Bissau', '04', 'Oio');
INSERT INTO `country_region` (`country_alpha2`, `country_numeric_code`, `country_name`, `code`, `name`) VALUES
('GW', 624, 'Guinea-Bissau', '05', 'Bolama'),
('GW', 624, 'Guinea-Bissau', '06', 'Cacheu'),
('GW', 624, 'Guinea-Bissau', '07', 'Tombali'),
('GW', 624, 'Guinea-Bissau', '10', 'Gabu'),
('GW', 624, 'Guinea-Bissau', '11', 'Bissau'),
('GW', 624, 'Guinea-Bissau', '12', 'Biombo'),
('GY', 328, 'Guyana', '11', 'Cuyuni-Mazaruni'),
('GY', 328, 'Guyana', '12', 'Demerara-Mahaica'),
('GY', 328, 'Guyana', '13', 'East Berbice-Corentyne'),
('GY', 328, 'Guyana', '14', 'Essequibo Islands-West Demerara'),
('GY', 328, 'Guyana', '15', 'Mahaica-Berbice'),
('GY', 328, 'Guyana', '16', 'Pomeroon-Supenaam'),
('GY', 328, 'Guyana', '18', 'Upper Demerara-Berbice'),
('HK', 344, 'Hong Kong', 'HK', 'Hong Kong (SAR)'),
('HN', 340, 'Honduras', '01', 'Atlantida'),
('HN', 340, 'Honduras', '02', 'Choluteca'),
('HN', 340, 'Honduras', '03', 'Colon'),
('HN', 340, 'Honduras', '04', 'Comayagua'),
('HN', 340, 'Honduras', '05', 'Copan'),
('HN', 340, 'Honduras', '06', 'Cortes'),
('HN', 340, 'Honduras', '07', 'El Paraiso'),
('HN', 340, 'Honduras', '08', 'Francisco Morazan'),
('HN', 340, 'Honduras', '09', 'Gracias a Dios'),
('HN', 340, 'Honduras', '10', 'Intibuca'),
('HN', 340, 'Honduras', '11', 'Islas de la Bahia'),
('HN', 340, 'Honduras', '12', 'La Paz'),
('HN', 340, 'Honduras', '13', 'Lempira'),
('HN', 340, 'Honduras', '14', 'Ocotepeque'),
('HN', 340, 'Honduras', '15', 'Olancho'),
('HN', 340, 'Honduras', '16', 'Santa Barbara'),
('HN', 340, 'Honduras', '17', 'Valle'),
('HN', 340, 'Honduras', '18', 'Yoro'),
('HR', 191, 'Croatia', '01', 'Bjelovarsko-bilogorska zupanija'),
('HR', 191, 'Croatia', '02', 'Brodsko-posavska zupanija'),
('HR', 191, 'Croatia', '03', 'Dubrovacko-neretvanska zupanija'),
('HR', 191, 'Croatia', '04', 'Istarska zupanija'),
('HR', 191, 'Croatia', '05', 'Karlovacka zupanija'),
('HR', 191, 'Croatia', '06', 'Koprivnicko-krizevacka zupanija'),
('HR', 191, 'Croatia', '07', 'Krapinsko-zagorska zupanija'),
('HR', 191, 'Croatia', '08', 'Licko-senjska zupanija'),
('HR', 191, 'Croatia', '09', 'Medimurska zupanija'),
('HR', 191, 'Croatia', '10', 'Osjecko-baranjska zupanija'),
('HR', 191, 'Croatia', '11', 'Pozesko-slavonska zupanija'),
('HR', 191, 'Croatia', '12', 'Primorsko-goranska zupanija'),
('HR', 191, 'Croatia', '13', 'Sibensko-kninska zupanija'),
('HR', 191, 'Croatia', '14', 'Sisacko-moslavacka zupanija'),
('HR', 191, 'Croatia', '15', 'Splitsko-dalmatinska zupanija'),
('HR', 191, 'Croatia', '16', 'Varazdinska zupanija'),
('HR', 191, 'Croatia', '17', 'Viroviticko-podravska zupanija'),
('HR', 191, 'Croatia', '18', 'Vukovarsko-srijemska zupanija'),
('HR', 191, 'Croatia', '19', 'Zadarska zupanija'),
('HR', 191, 'Croatia', '20', 'Zagrebacka zupanija'),
('HR', 191, 'Croatia', '21', 'Grad Zagreb'),
('HT', 332, 'Haiti', '03', 'Nord-Ouest'),
('HT', 332, 'Haiti', '06', 'Artibonite'),
('HT', 332, 'Haiti', '07', 'Centre'),
('HT', 332, 'Haiti', '09', 'Nord'),
('HT', 332, 'Haiti', '10', 'Nord-Est'),
('HT', 332, 'Haiti', '11', 'Ouest'),
('HT', 332, 'Haiti', '12', 'Sud'),
('HT', 332, 'Haiti', '13', 'Sud-Est'),
('HT', 332, 'Haiti', '14', 'Grand'' Anse'),
('HT', 332, 'Haiti', '15', 'Nippes'),
('HU', 348, 'Hungary', '01', 'Bacs-Kiskun'),
('HU', 348, 'Hungary', '02', 'Baranya'),
('HU', 348, 'Hungary', '03', 'Bekes'),
('HU', 348, 'Hungary', '04', 'Borsod-Abauj-Zemplen'),
('HU', 348, 'Hungary', '05', 'Budapest'),
('HU', 348, 'Hungary', '06', 'Csongrad'),
('HU', 348, 'Hungary', '08', 'Fejer'),
('HU', 348, 'Hungary', '09', 'Gyor-Moson-Sopron'),
('HU', 348, 'Hungary', '10', 'Hajdu-Bihar'),
('HU', 348, 'Hungary', '11', 'Heves'),
('HU', 348, 'Hungary', '12', 'Komarom-Esztergom'),
('HU', 348, 'Hungary', '14', 'Nograd'),
('HU', 348, 'Hungary', '16', 'Pest'),
('HU', 348, 'Hungary', '17', 'Somogy'),
('HU', 348, 'Hungary', '18', 'Szabolcs-Szatmar-Bereg'),
('HU', 348, 'Hungary', '20', 'Jasz-Nagykun-Szolnok'),
('HU', 348, 'Hungary', '21', 'Tolna'),
('HU', 348, 'Hungary', '22', 'Vas'),
('HU', 348, 'Hungary', '23', 'Veszprem'),
('HU', 348, 'Hungary', '24', 'Zala'),
('ID', 360, 'Indonesia', '01', 'Aceh'),
('ID', 360, 'Indonesia', '02', 'Bali'),
('ID', 360, 'Indonesia', '03', 'Bengkulu'),
('ID', 360, 'Indonesia', '04', 'Jakarta Raya'),
('ID', 360, 'Indonesia', '05', 'Jambi'),
('ID', 360, 'Indonesia', '07', 'Jawa Tengah'),
('ID', 360, 'Indonesia', '08', 'Jawa Timur'),
('ID', 360, 'Indonesia', '10', 'Yogyakarta'),
('ID', 360, 'Indonesia', '11', 'Kalimantan Barat'),
('ID', 360, 'Indonesia', '12', 'Kalimantan Selatan'),
('ID', 360, 'Indonesia', '13', 'Kalimantan Tengah'),
('ID', 360, 'Indonesia', '14', 'Kalimantan Timur'),
('ID', 360, 'Indonesia', '15', 'Lampung'),
('ID', 360, 'Indonesia', '17', 'Nusa Tenggara Barat'),
('ID', 360, 'Indonesia', '18', 'Nusa Tenggara Timur'),
('ID', 360, 'Indonesia', '21', 'Sulawesi Tengah'),
('ID', 360, 'Indonesia', '22', 'Sulawesi Tenggara'),
('ID', 360, 'Indonesia', '24', 'Sumatera Barat'),
('ID', 360, 'Indonesia', '26', 'Sumatera Utara'),
('ID', 360, 'Indonesia', '28', 'Maluku'),
('ID', 360, 'Indonesia', '29', 'Maluku Utara'),
('ID', 360, 'Indonesia', '30', 'Jawa Barat'),
('ID', 360, 'Indonesia', '31', 'Sulawesi Utara'),
('ID', 360, 'Indonesia', '32', 'Sumatera Selatan'),
('ID', 360, 'Indonesia', '33', 'Banten'),
('ID', 360, 'Indonesia', '34', 'Gorontalo'),
('ID', 360, 'Indonesia', '35', 'Bangka Belitung'),
('ID', 360, 'Indonesia', '36', 'Papua'),
('ID', 360, 'Indonesia', '37', 'Riau'),
('ID', 360, 'Indonesia', '38', 'Sulawesi Selatan'),
('ID', 360, 'Indonesia', '39', 'Papua Barat'),
('ID', 360, 'Indonesia', '40', 'Kepulauan Riau'),
('ID', 360, 'Indonesia', '41', 'Sulawesi Barat'),
('IE', 372, 'Ireland', '01', 'Carlow'),
('IE', 372, 'Ireland', '02', 'Cavan'),
('IE', 372, 'Ireland', '03', 'Clare'),
('IE', 372, 'Ireland', '04', 'Cork'),
('IE', 372, 'Ireland', '06', 'Donegal'),
('IE', 372, 'Ireland', '07', 'Dublin'),
('IE', 372, 'Ireland', '10', 'Galway'),
('IE', 372, 'Ireland', '11', 'Kerry'),
('IE', 372, 'Ireland', '12', 'Kildare'),
('IE', 372, 'Ireland', '13', 'Kilkenny'),
('IE', 372, 'Ireland', '14', 'Leitrim'),
('IE', 372, 'Ireland', '15', 'Laois'),
('IE', 372, 'Ireland', '16', 'Limerick'),
('IE', 372, 'Ireland', '18', 'Longford'),
('IE', 372, 'Ireland', '19', 'Louth'),
('IE', 372, 'Ireland', '20', 'Mayo'),
('IE', 372, 'Ireland', '21', 'Meath'),
('IE', 372, 'Ireland', '22', 'Monaghan'),
('IE', 372, 'Ireland', '23', 'Offaly'),
('IE', 372, 'Ireland', '24', 'Roscommon'),
('IE', 372, 'Ireland', '25', 'Sligo'),
('IE', 372, 'Ireland', '26', 'Tipperary'),
('IE', 372, 'Ireland', '27', 'Waterford'),
('IE', 372, 'Ireland', '29', 'Westmeath'),
('IE', 372, 'Ireland', '30', 'Wexford'),
('IE', 372, 'Ireland', '31', 'Wicklow'),
('IL', 376, 'Israel', '01', 'HaDarom'),
('IL', 376, 'Israel', '02', 'HaMerkaz'),
('IL', 376, 'Israel', '03', 'HaTsafon'),
('IL', 376, 'Israel', '04', 'Hefa'),
('IL', 376, 'Israel', '05', 'Tel-Aviv'),
('IL', 376, 'Israel', '06', 'Yerushalayim'),
('IM', 833, 'Isle of Man', '00', 'Isle of Man'),
('IN', 356, 'India', '01', 'Andaman and Nicobar Islands'),
('IN', 356, 'India', '02', 'Andhra Pradesh'),
('IN', 356, 'India', '03', 'Assam'),
('IN', 356, 'India', '05', 'Chandigarh'),
('IN', 356, 'India', '06', 'Dadra and Nagar Haveli'),
('IN', 356, 'India', '07', 'Delhi'),
('IN', 356, 'India', '09', 'Gujarat'),
('IN', 356, 'India', '10', 'Haryana'),
('IN', 356, 'India', '11', 'Himachal Pradesh'),
('IN', 356, 'India', '12', 'Jammu and Kashmir'),
('IN', 356, 'India', '13', 'Kerala'),
('IN', 356, 'India', '14', 'Lakshadweep'),
('IN', 356, 'India', '16', 'Maharashtra'),
('IN', 356, 'India', '17', 'Manipur'),
('IN', 356, 'India', '18', 'Meghalaya'),
('IN', 356, 'India', '19', 'Karnataka'),
('IN', 356, 'India', '20', 'Nagaland'),
('IN', 356, 'India', '21', 'Odisha'),
('IN', 356, 'India', '22', 'Puducherry'),
('IN', 356, 'India', '23', 'Punjab'),
('IN', 356, 'India', '24', 'Rajasthan'),
('IN', 356, 'India', '25', 'Tamil Nadu'),
('IN', 356, 'India', '26', 'Tripura'),
('IN', 356, 'India', '28', 'West Bengal'),
('IN', 356, 'India', '29', 'Sikkim'),
('IN', 356, 'India', '30', 'Arunachal Pradesh'),
('IN', 356, 'India', '31', 'Mizoram'),
('IN', 356, 'India', '32', 'Daman and Diu'),
('IN', 356, 'India', '33', 'Goa'),
('IN', 356, 'India', '34', 'Bihar'),
('IN', 356, 'India', '35', 'Madhya Pradesh'),
('IN', 356, 'India', '36', 'Uttar Pradesh'),
('IN', 356, 'India', '37', 'Chhattisgarh'),
('IN', 356, 'India', '38', 'Jharkhand'),
('IN', 356, 'India', '39', 'Uttarakhand'),
('IN', 356, 'India', '40', 'Telangana'),
('IO', 86, 'British Indian Ocean Territory', '00', 'British Indian Ocean Territory'),
('IQ', 368, 'Iraq', '01', 'Al Anbar'),
('IQ', 368, 'Iraq', '02', 'Al Basrah'),
('IQ', 368, 'Iraq', '03', 'Al Muthanna'),
('IQ', 368, 'Iraq', '04', 'Al Qadisiyah'),
('IQ', 368, 'Iraq', '05', 'As Sulaymaniyah'),
('IQ', 368, 'Iraq', '06', 'Babil'),
('IQ', 368, 'Iraq', '07', 'Baghdad'),
('IQ', 368, 'Iraq', '08', 'Dahuk'),
('IQ', 368, 'Iraq', '09', 'Dhi Qar'),
('IQ', 368, 'Iraq', '10', 'Diyala'),
('IQ', 368, 'Iraq', '11', 'Arbil'),
('IQ', 368, 'Iraq', '12', 'Karbala'''),
('IQ', 368, 'Iraq', '13', 'Kirkuk'),
('IQ', 368, 'Iraq', '14', 'Maysan'),
('IQ', 368, 'Iraq', '15', 'Ninawa'),
('IQ', 368, 'Iraq', '16', 'Wasit'),
('IQ', 368, 'Iraq', '17', 'An Najaf'),
('IQ', 368, 'Iraq', '18', 'Salah ad Din'),
('IR', 364, 'Iran, Islamic Republic of', '01', 'Azarbayjan-e Gharbi'),
('IR', 364, 'Iran, Islamic Republic of', '03', 'Chahar Mahal va Bakhtiari'),
('IR', 364, 'Iran, Islamic Republic of', '04', 'Sistan va Baluchestan'),
('IR', 364, 'Iran, Islamic Republic of', '05', 'Kohgiluyeh va Bowyer Ahmad'),
('IR', 364, 'Iran, Islamic Republic of', '07', 'Fars'),
('IR', 364, 'Iran, Islamic Republic of', '08', 'Gilan'),
('IR', 364, 'Iran, Islamic Republic of', '09', 'Hamadan'),
('IR', 364, 'Iran, Islamic Republic of', '10', 'Ilam'),
('IR', 364, 'Iran, Islamic Republic of', '11', 'Hormozgan'),
('IR', 364, 'Iran, Islamic Republic of', '13', 'Kermanshah'),
('IR', 364, 'Iran, Islamic Republic of', '15', 'Khuzestan'),
('IR', 364, 'Iran, Islamic Republic of', '16', 'Kordestan'),
('IR', 364, 'Iran, Islamic Republic of', '22', 'Bushehr'),
('IR', 364, 'Iran, Islamic Republic of', '23', 'Lorestan'),
('IR', 364, 'Iran, Islamic Republic of', '25', 'Semnan'),
('IR', 364, 'Iran, Islamic Republic of', '26', 'Tehran'),
('IR', 364, 'Iran, Islamic Republic of', '28', 'Esfahan'),
('IR', 364, 'Iran, Islamic Republic of', '29', 'Kerman'),
('IR', 364, 'Iran, Islamic Republic of', '32', 'Ardabil'),
('IR', 364, 'Iran, Islamic Republic of', '33', 'Azarbayjan-e Sharqi'),
('IR', 364, 'Iran, Islamic Republic of', '34', 'Markazi'),
('IR', 364, 'Iran, Islamic Republic of', '35', 'Mazandaran'),
('IR', 364, 'Iran, Islamic Republic of', '36', 'Zanjan'),
('IR', 364, 'Iran, Islamic Republic of', '37', 'Golestan'),
('IR', 364, 'Iran, Islamic Republic of', '38', 'Qazvin'),
('IR', 364, 'Iran, Islamic Republic of', '39', 'Qom'),
('IR', 364, 'Iran, Islamic Republic of', '40', 'Yazd'),
('IR', 364, 'Iran, Islamic Republic of', '41', 'Khorasan-e Jonubi'),
('IR', 364, 'Iran, Islamic Republic of', '42', 'Khorasan-e Razavi'),
('IR', 364, 'Iran, Islamic Republic of', '43', 'Khorasan-e Shomali'),
('IR', 364, 'Iran, Islamic Republic of', '44', 'Alborz'),
('IS', 352, 'Iceland', '38', 'Austurland'),
('IS', 352, 'Iceland', '39', 'Hofudborgarsvaedi utan Reykjavikur'),
('IS', 352, 'Iceland', '40', 'Nordurland eystra'),
('IS', 352, 'Iceland', '41', 'Nordurland vestra'),
('IS', 352, 'Iceland', '42', 'Sudurland'),
('IS', 352, 'Iceland', '43', 'Sudurnes'),
('IS', 352, 'Iceland', '44', 'Vestfirdir'),
('IS', 352, 'Iceland', '45', 'Vesturland'),
('IT', 380, 'Italy', '01', 'Abruzzo'),
('IT', 380, 'Italy', '02', 'Basilicata'),
('IT', 380, 'Italy', '03', 'Calabria'),
('IT', 380, 'Italy', '04', 'Campania'),
('IT', 380, 'Italy', '05', 'Emilia-Romagna'),
('IT', 380, 'Italy', '06', 'Friuli-Venezia Giulia'),
('IT', 380, 'Italy', '07', 'Lazio'),
('IT', 380, 'Italy', '08', 'Liguria'),
('IT', 380, 'Italy', '09', 'Lombardia'),
('IT', 380, 'Italy', '10', 'Marche'),
('IT', 380, 'Italy', '11', 'Molise'),
('IT', 380, 'Italy', '12', 'Piemonte'),
('IT', 380, 'Italy', '13', 'Puglia'),
('IT', 380, 'Italy', '14', 'Sardegna'),
('IT', 380, 'Italy', '15', 'Sicilia'),
('IT', 380, 'Italy', '16', 'Toscana'),
('IT', 380, 'Italy', '17', 'Trentino-Alto Adige'),
('IT', 380, 'Italy', '18', 'Umbria'),
('IT', 380, 'Italy', '19', 'Valle d''Aosta'),
('IT', 380, 'Italy', '20', 'Veneto'),
('JE', 832, 'Jersey', '00', 'Jersey'),
('JM', 388, 'Jamaica', '01', 'Clarendon'),
('JM', 388, 'Jamaica', '02', 'Hanover'),
('JM', 388, 'Jamaica', '04', 'Manchester'),
('JM', 388, 'Jamaica', '07', 'Portland'),
('JM', 388, 'Jamaica', '08', 'Saint Andrew'),
('JM', 388, 'Jamaica', '09', 'Saint Ann'),
('JM', 388, 'Jamaica', '10', 'Saint Catherine'),
('JM', 388, 'Jamaica', '11', 'Saint Elizabeth'),
('JM', 388, 'Jamaica', '12', 'Saint James'),
('JM', 388, 'Jamaica', '13', 'Saint Mary'),
('JM', 388, 'Jamaica', '14', 'Saint Thomas'),
('JM', 388, 'Jamaica', '15', 'Trelawny'),
('JM', 388, 'Jamaica', '16', 'Westmoreland'),
('JM', 388, 'Jamaica', '17', 'Kingston'),
('JO', 400, 'Jordan', '02', 'Al Balqa'''),
('JO', 400, 'Jordan', '09', 'Al Karak'),
('JO', 400, 'Jordan', '12', 'At Tafilah'),
('JO', 400, 'Jordan', '15', 'Al Mafraq'),
('JO', 400, 'Jordan', '16', 'Al ''Asimah'),
('JO', 400, 'Jordan', '17', 'Az Zarqa'''),
('JO', 400, 'Jordan', '18', 'Irbid'),
('JO', 400, 'Jordan', '19', 'Ma''an'),
('JO', 400, 'Jordan', '21', 'Al ''Aqabah'),
('JO', 400, 'Jordan', '23', 'Madaba'),
('JP', 392, 'Japan', '01', 'Aichi'),
('JP', 392, 'Japan', '02', 'Akita'),
('JP', 392, 'Japan', '03', 'Aomori'),
('JP', 392, 'Japan', '04', 'Chiba'),
('JP', 392, 'Japan', '05', 'Ehime'),
('JP', 392, 'Japan', '06', 'Fukui'),
('JP', 392, 'Japan', '07', 'Fukuoka'),
('JP', 392, 'Japan', '08', 'Fukushima'),
('JP', 392, 'Japan', '09', 'Gifu'),
('JP', 392, 'Japan', '10', 'Gunma'),
('JP', 392, 'Japan', '11', 'Hiroshima'),
('JP', 392, 'Japan', '12', 'Hokkaido'),
('JP', 392, 'Japan', '13', 'Hyogo'),
('JP', 392, 'Japan', '14', 'Ibaraki'),
('JP', 392, 'Japan', '15', 'Ishikawa'),
('JP', 392, 'Japan', '16', 'Iwate'),
('JP', 392, 'Japan', '17', 'Kagawa'),
('JP', 392, 'Japan', '18', 'Kagoshima'),
('JP', 392, 'Japan', '19', 'Kanagawa'),
('JP', 392, 'Japan', '20', 'Kochi'),
('JP', 392, 'Japan', '21', 'Kumamoto'),
('JP', 392, 'Japan', '22', 'Kyoto'),
('JP', 392, 'Japan', '23', 'Mie'),
('JP', 392, 'Japan', '24', 'Miyagi'),
('JP', 392, 'Japan', '25', 'Miyazaki'),
('JP', 392, 'Japan', '26', 'Nagano'),
('JP', 392, 'Japan', '27', 'Nagasaki'),
('JP', 392, 'Japan', '28', 'Nara'),
('JP', 392, 'Japan', '29', 'Niigata'),
('JP', 392, 'Japan', '30', 'Oita'),
('JP', 392, 'Japan', '31', 'Okayama'),
('JP', 392, 'Japan', '32', 'Osaka'),
('JP', 392, 'Japan', '33', 'Saga'),
('JP', 392, 'Japan', '34', 'Saitama'),
('JP', 392, 'Japan', '35', 'Shiga'),
('JP', 392, 'Japan', '36', 'Shimane'),
('JP', 392, 'Japan', '37', 'Shizuoka'),
('JP', 392, 'Japan', '38', 'Tochigi'),
('JP', 392, 'Japan', '39', 'Tokushima'),
('JP', 392, 'Japan', '40', 'Tokyo'),
('JP', 392, 'Japan', '41', 'Tottori'),
('JP', 392, 'Japan', '42', 'Toyama'),
('JP', 392, 'Japan', '43', 'Wakayama'),
('JP', 392, 'Japan', '44', 'Yamagata'),
('JP', 392, 'Japan', '45', 'Yamaguchi'),
('JP', 392, 'Japan', '46', 'Yamanashi'),
('JP', 392, 'Japan', '47', 'Okinawa'),
('KE', 404, 'Kenya', '01', 'Central'),
('KE', 404, 'Kenya', '02', 'Coast'),
('KE', 404, 'Kenya', '03', 'Eastern'),
('KE', 404, 'Kenya', '05', 'Nairobi Area'),
('KE', 404, 'Kenya', '06', 'North-Eastern'),
('KE', 404, 'Kenya', '07', 'Nyanza'),
('KE', 404, 'Kenya', '08', 'Rift Valley'),
('KE', 404, 'Kenya', '09', 'Western'),
('KG', 417, 'Kyrgyzstan', '01', 'Bishkek'),
('KG', 417, 'Kyrgyzstan', '02', 'Chu'),
('KG', 417, 'Kyrgyzstan', '03', 'Jalal-Abad'),
('KG', 417, 'Kyrgyzstan', '04', 'Naryn'),
('KG', 417, 'Kyrgyzstan', '06', 'Talas'),
('KG', 417, 'Kyrgyzstan', '07', 'Ysyk-Kol'),
('KG', 417, 'Kyrgyzstan', '08', 'Osh'),
('KG', 417, 'Kyrgyzstan', '09', 'Batken'),
('KH', 116, 'Cambodia', '02', 'Kampong Chaam'),
('KH', 116, 'Cambodia', '03', 'Kampong Chhnang'),
('KH', 116, 'Cambodia', '04', 'Kampong Spueu'),
('KH', 116, 'Cambodia', '05', 'Kampong Thum'),
('KH', 116, 'Cambodia', '07', 'Kandaal'),
('KH', 116, 'Cambodia', '08', 'Kaoh Kong'),
('KH', 116, 'Cambodia', '09', 'Kracheh'),
('KH', 116, 'Cambodia', '10', 'Mondol Kiri'),
('KH', 116, 'Cambodia', '12', 'Pousaat'),
('KH', 116, 'Cambodia', '13', 'Preah Vihear'),
('KH', 116, 'Cambodia', '14', 'Prey Veaeng'),
('KH', 116, 'Cambodia', '17', 'Stueng Traeng'),
('KH', 116, 'Cambodia', '18', 'Svaay Rieng'),
('KH', 116, 'Cambodia', '19', 'Taakaev'),
('KH', 116, 'Cambodia', '21', 'Kampot'),
('KH', 116, 'Cambodia', '22', 'Phnom Penh'),
('KH', 116, 'Cambodia', '23', 'Rotanak Kiri'),
('KH', 116, 'Cambodia', '24', 'Siem Reab'),
('KH', 116, 'Cambodia', '25', 'Banteay Mean Chey'),
('KH', 116, 'Cambodia', '26', 'Krong Kaeb'),
('KH', 116, 'Cambodia', '27', 'Otdar Mean Chey'),
('KH', 116, 'Cambodia', '28', 'Krong Preah Sihanouk'),
('KH', 116, 'Cambodia', '29', 'Baat Dambang'),
('KH', 116, 'Cambodia', '30', 'Krong Pailin'),
('KI', 296, 'Kiribati', '01', 'Gilbert Islands'),
('KI', 296, 'Kiribati', '02', 'Line Islands'),
('KM', 174, 'Comoros', '01', 'Anjouan'),
('KM', 174, 'Comoros', '02', 'Grande Comore'),
('KM', 174, 'Comoros', '03', 'Moheli'),
('KN', 659, 'Saint Kitts and Nevis', '03', 'Saint George Basseterre'),
('KN', 659, 'Saint Kitts and Nevis', '10', 'Saint Paul Charlestown'),
('KP', 408, 'Korea, Democratic People''s Republic of', '01', 'Chagang-do'),
('KP', 408, 'Korea, Democratic People''s Republic of', '03', 'Hamgyong-namdo'),
('KP', 408, 'Korea, Democratic People''s Republic of', '06', 'Hwanghae-namdo'),
('KP', 408, 'Korea, Democratic People''s Republic of', '07', 'Hwanghae-bukto'),
('KP', 408, 'Korea, Democratic People''s Republic of', '09', 'Kangwon-do'),
('KP', 408, 'Korea, Democratic People''s Republic of', '11', 'P''yongan-bukto'),
('KP', 408, 'Korea, Democratic People''s Republic of', '12', 'P''yongyang'),
('KP', 408, 'Korea, Democratic People''s Republic of', '13', 'Yanggang-do'),
('KP', 408, 'Korea, Democratic People''s Republic of', '15', 'P''yongan-namdo'),
('KP', 408, 'Korea, Democratic People''s Republic of', '17', 'Hamgyong-bukto'),
('KP', 408, 'Korea, Democratic People''s Republic of', '18', 'Nason (Najin-Sonbong)'),
('KR', 410, 'Korea, Republic of', '01', 'Jeju'),
('KR', 410, 'Korea, Republic of', '03', 'Jeonbuk'),
('KR', 410, 'Korea, Republic of', '05', 'Chungbuk'),
('KR', 410, 'Korea, Republic of', '06', 'Gangwon'),
('KR', 410, 'Korea, Republic of', '10', 'Busan'),
('KR', 410, 'Korea, Republic of', '11', 'Seoul'),
('KR', 410, 'Korea, Republic of', '12', 'Incheon'),
('KR', 410, 'Korea, Republic of', '13', 'Gyeonggi'),
('KR', 410, 'Korea, Republic of', '14', 'Gyeongbuk'),
('KR', 410, 'Korea, Republic of', '15', 'Daegu'),
('KR', 410, 'Korea, Republic of', '16', 'Jeonnam'),
('KR', 410, 'Korea, Republic of', '17', 'Chungnam'),
('KR', 410, 'Korea, Republic of', '18', 'Gwangju'),
('KR', 410, 'Korea, Republic of', '19', 'Daejeon'),
('KR', 410, 'Korea, Republic of', '20', 'Gyeongnam'),
('KR', 410, 'Korea, Republic of', '21', 'Ulsan'),
('KW', 414, 'Kuwait', '02', 'Al Asimah'),
('KW', 414, 'Kuwait', '04', 'Al Ahmadi'),
('KW', 414, 'Kuwait', '05', 'Al Jahra'),
('KW', 414, 'Kuwait', '07', 'Al Farwaniyah'),
('KW', 414, 'Kuwait', '08', 'Hawalli'),
('KW', 414, 'Kuwait', '09', 'Mubarak al Kabir'),
('KY', 136, 'Cayman Islands', '00', 'Cayman Islands'),
('KZ', 398, 'Kazakhstan', '01', 'Almaty oblysy'),
('KZ', 398, 'Kazakhstan', '02', 'Almaty'),
('KZ', 398, 'Kazakhstan', '03', 'Aqmola oblysy'),
('KZ', 398, 'Kazakhstan', '04', 'Aqtobe oblysy'),
('KZ', 398, 'Kazakhstan', '05', 'Astana'),
('KZ', 398, 'Kazakhstan', '06', 'Atyrau oblysy'),
('KZ', 398, 'Kazakhstan', '07', 'Batys Qazaqstan oblysy'),
('KZ', 398, 'Kazakhstan', '08', 'Bayqonyr'),
('KZ', 398, 'Kazakhstan', '09', 'Mangghystau oblysy'),
('KZ', 398, 'Kazakhstan', '10', 'Ongtustik Qazaqstan oblysy'),
('KZ', 398, 'Kazakhstan', '11', 'Pavlodar oblysy'),
('KZ', 398, 'Kazakhstan', '12', 'Qaraghandy oblysy'),
('KZ', 398, 'Kazakhstan', '13', 'Qostanay oblysy'),
('KZ', 398, 'Kazakhstan', '14', 'Qyzylorda oblysy'),
('KZ', 398, 'Kazakhstan', '15', 'Shyghys Qazaqstan oblysy'),
('KZ', 398, 'Kazakhstan', '16', 'Soltustik Qazaqstan oblysy'),
('KZ', 398, 'Kazakhstan', '17', 'Zhambyl oblysy'),
('LA', 418, 'Lao People''s Democratic Republic', '01', 'Attapu'),
('LA', 418, 'Lao People''s Democratic Republic', '02', 'Champasak'),
('LA', 418, 'Lao People''s Democratic Republic', '03', 'Houaphan'),
('LA', 418, 'Lao People''s Democratic Republic', '07', 'Oudomxai'),
('LA', 418, 'Lao People''s Democratic Republic', '13', 'Xaignabouli'),
('LA', 418, 'Lao People''s Democratic Republic', '14', 'Xiangkhouang'),
('LA', 418, 'Lao People''s Democratic Republic', '15', 'Khammouan'),
('LA', 418, 'Lao People''s Democratic Republic', '16', 'Louang Namtha'),
('LA', 418, 'Lao People''s Democratic Republic', '17', 'Louangphabang'),
('LA', 418, 'Lao People''s Democratic Republic', '18', 'Phongsali'),
('LA', 418, 'Lao People''s Democratic Republic', '19', 'Salavan'),
('LA', 418, 'Lao People''s Democratic Republic', '20', 'Savannakhet'),
('LA', 418, 'Lao People''s Democratic Republic', '22', 'Bokeo'),
('LA', 418, 'Lao People''s Democratic Republic', '23', 'Bolikhamxai'),
('LA', 418, 'Lao People''s Democratic Republic', '24', 'Vientiane'),
('LA', 418, 'Lao People''s Democratic Republic', '26', 'Xekong'),
('LA', 418, 'Lao People''s Democratic Republic', '27', 'Vientiane'),
('LB', 422, 'Lebanon', '04', 'Beyrouth'),
('LB', 422, 'Lebanon', '05', 'Mont-Liban'),
('LB', 422, 'Lebanon', '06', 'Liban-Sud'),
('LB', 422, 'Lebanon', '07', 'Nabatiye'),
('LB', 422, 'Lebanon', '08', 'Beqaa'),
('LB', 422, 'Lebanon', '09', 'Liban-Nord'),
('LB', 422, 'Lebanon', '10', 'Aakkar'),
('LB', 422, 'Lebanon', '11', 'Baalbek-Hermel'),
('LC', 662, 'Saint Lucia', '01', 'Anse la Raye'),
('LC', 662, 'Saint Lucia', '03', 'Castries'),
('LC', 662, 'Saint Lucia', '05', 'Dennery'),
('LC', 662, 'Saint Lucia', '06', 'Gros Islet'),
('LC', 662, 'Saint Lucia', '07', 'Laborie'),
('LC', 662, 'Saint Lucia', '08', 'Micoud'),
('LC', 662, 'Saint Lucia', '09', 'Soufriere'),
('LC', 662, 'Saint Lucia', '10', 'Vieux Fort'),
('LI', 438, 'Liechtenstein', '01', 'Balzers'),
('LI', 438, 'Liechtenstein', '02', 'Eschen'),
('LI', 438, 'Liechtenstein', '03', 'Gamprin'),
('LI', 438, 'Liechtenstein', '04', 'Mauren'),
('LI', 438, 'Liechtenstein', '05', 'Planken'),
('LI', 438, 'Liechtenstein', '06', 'Ruggell'),
('LI', 438, 'Liechtenstein', '07', 'Schaan'),
('LI', 438, 'Liechtenstein', '08', 'Schellenberg'),
('LI', 438, 'Liechtenstein', '09', 'Triesen'),
('LI', 438, 'Liechtenstein', '10', 'Triesenberg'),
('LI', 438, 'Liechtenstein', '11', 'Vaduz'),
('LK', 144, 'Sri Lanka', '29', 'Central Province'),
('LK', 144, 'Sri Lanka', '30', 'North Central Province'),
('LK', 144, 'Sri Lanka', '32', 'North Western Province'),
('LK', 144, 'Sri Lanka', '33', 'Sabaragamuwa Province'),
('LK', 144, 'Sri Lanka', '34', 'Southern Province'),
('LK', 144, 'Sri Lanka', '35', 'Uva Province'),
('LK', 144, 'Sri Lanka', '36', 'Western Province'),
('LK', 144, 'Sri Lanka', '37', 'Eastern Province'),
('LK', 144, 'Sri Lanka', '38', 'Northern Province'),
('LR', 430, 'Liberia', '01', 'Bong'),
('LR', 430, 'Liberia', '09', 'Nimba'),
('LR', 430, 'Liberia', '10', 'Sinoe'),
('LR', 430, 'Liberia', '11', 'Grand Bassa'),
('LR', 430, 'Liberia', '12', 'Grand Cape Mount'),
('LR', 430, 'Liberia', '13', 'Maryland'),
('LR', 430, 'Liberia', '14', 'Montserrado'),
('LR', 430, 'Liberia', '15', 'Bomi'),
('LR', 430, 'Liberia', '16', 'Grand Kru'),
('LR', 430, 'Liberia', '17', 'Margibi'),
('LR', 430, 'Liberia', '18', 'River Cess'),
('LR', 430, 'Liberia', '19', 'Grand Gedeh'),
('LR', 430, 'Liberia', '20', 'Lofa'),
('LR', 430, 'Liberia', '21', 'Gbarpolu'),
('LR', 430, 'Liberia', '22', 'River Gee'),
('LS', 426, 'Lesotho', '10', 'Berea'),
('LS', 426, 'Lesotho', '11', 'Butha-Buthe'),
('LS', 426, 'Lesotho', '12', 'Leribe'),
('LS', 426, 'Lesotho', '13', 'Mafeteng'),
('LS', 426, 'Lesotho', '14', 'Maseru'),
('LS', 426, 'Lesotho', '15', 'Mohale''s Hoek'),
('LS', 426, 'Lesotho', '16', 'Mokhotlong'),
('LS', 426, 'Lesotho', '17', 'Qacha''s Nek'),
('LS', 426, 'Lesotho', '18', 'Quthing'),
('LS', 426, 'Lesotho', '19', 'Thaba-Tseka'),
('LT', 440, 'Lithuania', '56', 'Alytaus Apskritis'),
('LT', 440, 'Lithuania', '57', 'Kauno Apskritis'),
('LT', 440, 'Lithuania', '58', 'Klaipedos Apskritis'),
('LT', 440, 'Lithuania', '59', 'Marijampoles Apskritis'),
('LT', 440, 'Lithuania', '60', 'Panevezio Apskritis'),
('LT', 440, 'Lithuania', '61', 'Siauliu Apskritis'),
('LT', 440, 'Lithuania', '62', 'Taurages Apskritis'),
('LT', 440, 'Lithuania', '63', 'Telsiu Apskritis'),
('LT', 440, 'Lithuania', '64', 'Utenos Apskritis'),
('LT', 440, 'Lithuania', '65', 'Vilniaus Apskritis'),
('LU', 442, 'Luxembourg', '01', 'Diekirch'),
('LU', 442, 'Luxembourg', '02', 'Grevenmacher'),
('LU', 442, 'Luxembourg', '03', 'Luxembourg'),
('LV', 428, 'Latvia', '01', 'Aizkraukles'),
('LV', 428, 'Latvia', '02', 'Aluksnes'),
('LV', 428, 'Latvia', '03', 'Balvu'),
('LV', 428, 'Latvia', '04', 'Bauskas'),
('LV', 428, 'Latvia', '05', 'Cesu'),
('LV', 428, 'Latvia', '07', 'Daugavpils'),
('LV', 428, 'Latvia', '08', 'Dobeles'),
('LV', 428, 'Latvia', '09', 'Gulbenes'),
('LV', 428, 'Latvia', '10', 'Jekabpils'),
('LV', 428, 'Latvia', '11', 'Jelgava'),
('LV', 428, 'Latvia', '12', 'Jelgavas'),
('LV', 428, 'Latvia', '13', 'Jurmala'),
('LV', 428, 'Latvia', '14', 'Kraslavas'),
('LV', 428, 'Latvia', '15', 'Kuldigas'),
('LV', 428, 'Latvia', '16', 'Liepaja'),
('LV', 428, 'Latvia', '17', 'Liepajas'),
('LV', 428, 'Latvia', '18', 'Limbazu'),
('LV', 428, 'Latvia', '19', 'Ludzas'),
('LV', 428, 'Latvia', '20', 'Madonas'),
('LV', 428, 'Latvia', '21', 'Ogres'),
('LV', 428, 'Latvia', '22', 'Preilu'),
('LV', 428, 'Latvia', '24', 'Rezeknes'),
('LV', 428, 'Latvia', '25', 'Riga'),
('LV', 428, 'Latvia', '26', 'Rigas'),
('LV', 428, 'Latvia', '27', 'Saldus'),
('LV', 428, 'Latvia', '28', 'Talsu'),
('LV', 428, 'Latvia', '29', 'Tukuma'),
('LV', 428, 'Latvia', '30', 'Valkas'),
('LV', 428, 'Latvia', '31', 'Valmieras'),
('LV', 428, 'Latvia', '33', 'Ventspils'),
('LV', 428, 'Latvia', '34', 'Adazu'),
('LV', 428, 'Latvia', '35', 'Aglonas'),
('LV', 428, 'Latvia', '37', 'Aizputes'),
('LV', 428, 'Latvia', '39', 'Alojas'),
('LV', 428, 'Latvia', '45', 'Babites'),
('LV', 428, 'Latvia', '47', 'Baltinavas'),
('LV', 428, 'Latvia', '50', 'Beverinas'),
('LV', 428, 'Latvia', '51', 'Brocenu'),
('LV', 428, 'Latvia', '53', 'Carnikavas'),
('LV', 428, 'Latvia', '55', 'Cesvaines'),
('LV', 428, 'Latvia', '56', 'Ciblas'),
('LV', 428, 'Latvia', '60', 'Dundagas'),
('LV', 428, 'Latvia', '67', 'Iecavas'),
('LV', 428, 'Latvia', '70', 'Incukalna'),
('LV', 428, 'Latvia', '71', 'Jaunjelgavas'),
('LV', 428, 'Latvia', '72', 'Jaunpiebalgas'),
('LV', 428, 'Latvia', '73', 'Jaunpils'),
('LV', 428, 'Latvia', '80', 'Kekavas'),
('LV', 428, 'Latvia', '82', 'Kokneses'),
('LV', 428, 'Latvia', '91', 'Lubanas'),
('LV', 428, 'Latvia', '94', 'Malpils'),
('LV', 428, 'Latvia', 'A2', 'Olaines'),
('LV', 428, 'Latvia', 'A3', 'Ozolnieku'),
('LV', 428, 'Latvia', 'B4', 'Rojas'),
('LV', 428, 'Latvia', 'B5', 'Ropazu'),
('LV', 428, 'Latvia', 'B7', 'Rugaju'),
('LV', 428, 'Latvia', 'B9', 'Rundales'),
('LV', 428, 'Latvia', 'C1', 'Salacgrivas'),
('LV', 428, 'Latvia', 'C6', 'Sejas'),
('LV', 428, 'Latvia', 'C7', 'Siguldas'),
('LV', 428, 'Latvia', 'C9', 'Skrundas'),
('LV', 428, 'Latvia', 'D2', 'Stopinu'),
('LV', 428, 'Latvia', 'D3', 'Strencu'),
('LV', 428, 'Latvia', 'D7', 'Vainodes'),
('LV', 428, 'Latvia', 'E2', 'Varkavas'),
('LV', 428, 'Latvia', 'E4', 'Vecumnieku'),
('LY', 434, 'Libya', '63', 'Al Jabal al Akhdar'),
('LY', 434, 'Libya', '64', 'Al Jufrah'),
('LY', 434, 'Libya', '65', 'Al Kufrah'),
('LY', 434, 'Libya', '66', 'Al Marj'),
('LY', 434, 'Libya', '67', 'An Nuqat al Khams'),
('LY', 434, 'Libya', '68', 'Az Zawiyah'),
('LY', 434, 'Libya', '69', 'Banghazi'),
('LY', 434, 'Libya', '70', 'Darnah'),
('LY', 434, 'Libya', '71', 'Ghat'),
('LY', 434, 'Libya', '72', 'Misratah'),
('LY', 434, 'Libya', '73', 'Murzuq'),
('LY', 434, 'Libya', '74', 'Nalut'),
('LY', 434, 'Libya', '75', 'Sabha'),
('LY', 434, 'Libya', '76', 'Surt'),
('LY', 434, 'Libya', '77', 'Tarabulus'),
('LY', 434, 'Libya', '78', 'Wadi ash Shati'''),
('LY', 434, 'Libya', '79', 'Al Butnan'),
('LY', 434, 'Libya', '80', 'Al Jabal al Gharbi'),
('LY', 434, 'Libya', '81', 'Al Jafarah'),
('LY', 434, 'Libya', '82', 'Al Marqab'),
('LY', 434, 'Libya', '83', 'Al Wahat'),
('LY', 434, 'Libya', '84', 'Wadi al Hayat'),
('MA', 504, 'Morocco', '45', 'Grand Casablanca'),
('MA', 504, 'Morocco', '46', 'Fes-Boulemane'),
('MA', 504, 'Morocco', '47', 'Marrakech-Tensift-Al Haouz'),
('MA', 504, 'Morocco', '48', 'Meknes-Tafilalet'),
('MA', 504, 'Morocco', '49', 'Rabat-Sale-Zemmour-Zaer'),
('MA', 504, 'Morocco', '50', 'Chaouia-Ouardigha'),
('MA', 504, 'Morocco', '51', 'Doukhala-Abda'),
('MA', 504, 'Morocco', '52', 'Gharb-Chrarda-Beni Hssen'),
('MA', 504, 'Morocco', '53', 'Guelmim-Es Semara'),
('MA', 504, 'Morocco', '54', 'L''Oriental'),
('MA', 504, 'Morocco', '55', 'Souss-Massa-Draa'),
('MA', 504, 'Morocco', '56', 'Tadla-Azilal'),
('MA', 504, 'Morocco', '57', 'Tanger-Tetouan'),
('MA', 504, 'Morocco', '58', 'Taza-Al Hoceima-Taounate'),
('MC', 492, 'Monaco', '00', 'Monaco'),
('MD', 498, 'Moldova, Republic of', '51', 'Gagauzia, Unitatea teritoriala autonoma'),
('MD', 498, 'Moldova, Republic of', '57', 'Chisinau'),
('MD', 498, 'Moldova, Republic of', '58', 'Stinga Nistrului, unitatea teritoriala din'),
('MD', 498, 'Moldova, Republic of', '59', 'Anenii Noi'),
('MD', 498, 'Moldova, Republic of', '60', 'Balti'),
('MD', 498, 'Moldova, Republic of', '61', 'Basarabeasca'),
('MD', 498, 'Moldova, Republic of', '62', 'Bender'),
('MD', 498, 'Moldova, Republic of', '63', 'Briceni'),
('MD', 498, 'Moldova, Republic of', '64', 'Cahul'),
('MD', 498, 'Moldova, Republic of', '65', 'Cantemir'),
('MD', 498, 'Moldova, Republic of', '66', 'Calarasi'),
('MD', 498, 'Moldova, Republic of', '67', 'Causeni'),
('MD', 498, 'Moldova, Republic of', '68', 'Cimislia'),
('MD', 498, 'Moldova, Republic of', '69', 'Criuleni'),
('MD', 498, 'Moldova, Republic of', '70', 'Donduseni'),
('MD', 498, 'Moldova, Republic of', '71', 'Drochia'),
('MD', 498, 'Moldova, Republic of', '72', 'Dubasari'),
('MD', 498, 'Moldova, Republic of', '73', 'Edinet'),
('MD', 498, 'Moldova, Republic of', '74', 'Falesti'),
('MD', 498, 'Moldova, Republic of', '75', 'Floresti'),
('MD', 498, 'Moldova, Republic of', '76', 'Glodeni'),
('MD', 498, 'Moldova, Republic of', '77', 'Hincesti'),
('MD', 498, 'Moldova, Republic of', '78', 'Ialoveni'),
('MD', 498, 'Moldova, Republic of', '79', 'Leova'),
('MD', 498, 'Moldova, Republic of', '80', 'Nisporeni'),
('MD', 498, 'Moldova, Republic of', '81', 'Ocnita'),
('MD', 498, 'Moldova, Republic of', '82', 'Orhei'),
('MD', 498, 'Moldova, Republic of', '83', 'Rezina'),
('MD', 498, 'Moldova, Republic of', '84', 'Riscani'),
('MD', 498, 'Moldova, Republic of', '85', 'Singerei'),
('MD', 498, 'Moldova, Republic of', '86', 'Soldanesti'),
('MD', 498, 'Moldova, Republic of', '87', 'Soroca'),
('MD', 498, 'Moldova, Republic of', '88', 'Stefan Voda'),
('MD', 498, 'Moldova, Republic of', '89', 'Straseni'),
('MD', 498, 'Moldova, Republic of', '90', 'Taraclia'),
('MD', 498, 'Moldova, Republic of', '91', 'Telenesti'),
('MD', 498, 'Moldova, Republic of', '92', 'Ungheni'),
('ME', 499, 'Montenegro', '02', 'Bar'),
('ME', 499, 'Montenegro', '05', 'Budva'),
('ME', 499, 'Montenegro', '06', 'Cetinje'),
('ME', 499, 'Montenegro', '07', 'Danilovgrad'),
('ME', 499, 'Montenegro', '08', 'Herceg-Novi'),
('ME', 499, 'Montenegro', '09', 'Kolasin'),
('ME', 499, 'Montenegro', '10', 'Kotor'),
('ME', 499, 'Montenegro', '11', 'Mojkovac'),
('ME', 499, 'Montenegro', '12', 'Niksic'),
('ME', 499, 'Montenegro', '16', 'Podgorica'),
('ME', 499, 'Montenegro', '19', 'Tivat'),
('ME', 499, 'Montenegro', '20', 'Ulcinj'),
('ME', 499, 'Montenegro', '21', 'Zabljak'),
('MF', 663, 'Saint Martin (French Part)', '00', 'Saint Martin'),
('MG', 450, 'Madagascar', '01', 'Antsiranana'),
('MG', 450, 'Madagascar', '02', 'Fianarantsoa'),
('MG', 450, 'Madagascar', '03', 'Mahajanga'),
('MG', 450, 'Madagascar', '04', 'Toamasina'),
('MG', 450, 'Madagascar', '05', 'Antananarivo'),
('MG', 450, 'Madagascar', '06', 'Toliara'),
('MH', 584, 'Marshall Islands', '010', 'Ailinglaplap Atoll'),
('MH', 584, 'Marshall Islands', '030', 'Ailuk Atoll'),
('MH', 584, 'Marshall Islands', '040', 'Arno Atoll'),
('MH', 584, 'Marshall Islands', '050', 'Aur Atoll'),
('MH', 584, 'Marshall Islands', '080', 'Ebon Atoll'),
('MH', 584, 'Marshall Islands', '090', 'Enewetak Atoll'),
('MH', 584, 'Marshall Islands', '110', 'Jabat Island'),
('MH', 584, 'Marshall Islands', '120', 'Jaluit Atoll'),
('MH', 584, 'Marshall Islands', '140', 'Kili Island'),
('MH', 584, 'Marshall Islands', '150', 'Kwajalein Atoll'),
('MH', 584, 'Marshall Islands', '160', 'Lae Atoll'),
('MH', 584, 'Marshall Islands', '170', 'Lib Island'),
('MH', 584, 'Marshall Islands', '180', 'Likiep Atoll'),
('MH', 584, 'Marshall Islands', '190', 'Majuro Atoll'),
('MH', 584, 'Marshall Islands', '300', 'Maloelap Atoll'),
('MH', 584, 'Marshall Islands', '310', 'Mejit Island'),
('MH', 584, 'Marshall Islands', '320', 'Mili Atoll'),
('MH', 584, 'Marshall Islands', '330', 'Namdrik Atoll'),
('MH', 584, 'Marshall Islands', '340', 'Namu Atoll'),
('MH', 584, 'Marshall Islands', '350', 'Rongelap Atoll'),
('MH', 584, 'Marshall Islands', '390', 'Ujae Atoll'),
('MH', 584, 'Marshall Islands', '410', 'Utrik Atoll'),
('MH', 584, 'Marshall Islands', '420', 'Wotho Atoll'),
('MH', 584, 'Marshall Islands', '430', 'Wotje Atoll'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '01', 'Aracinovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '03', 'Debarca'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '04', 'Berovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '05', 'Bitola'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '06', 'Bitola'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '07', 'Vinica'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '08', 'Bogdanci'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '09', 'Caska'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '10', 'Bogovinje'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '11', 'Bosilovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '12', 'Brvenica'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '14', 'Bitola'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '15', 'Caska'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '16', 'Gostivar'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '18', 'Centar Zupa'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '19', 'Cesinovo-Oblesevo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '20', 'Cucer Sandevo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '21', 'Debar'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '22', 'Delcevo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '23', 'Struga'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '24', 'Demir Hisar'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '25', 'Demir Kapija'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '26', 'Mogila'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '27', 'Gostivar'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '28', 'Dolneni'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '31', 'Tetovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '33', 'Gevgelija'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '34', 'Gostivar'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '35', 'Gradsko'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '36', 'Ilinden'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '38', 'Jegunovce'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '39', 'Bogovinje'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '40', 'Karbinci'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '42', 'Kavadarci'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '43', 'Kicevo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '45', 'Kumanovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '46', 'Kocani'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '47', 'Konce'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '48', 'Kondovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '50', 'Ohrid'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '51', 'Kratovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '52', 'Kriva Palanka'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '53', 'Krivogastani'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '54', 'Krusevo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '55', 'Strumica'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '56', 'Bitola'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '57', 'Kumanovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '58', 'Struga'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '59', 'Lipkovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '60', 'Lozovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '61', 'Struga'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '62', 'Makedonska Kamenica'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '63', 'Makedonski Brod'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '65', 'Debarca'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '66', 'Gevgelija'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '67', 'Mogila'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '68', 'Strumica'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '69', 'Negotino'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '70', 'Vrapciste'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '71', 'Novaci'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '72', 'Novo Selo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '73', 'Cesinovo-Oblesevo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '74', 'Ohrid'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '75', 'Kumanovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '76', 'Kocani'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '78', 'Pehcevo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '79', 'Petrovec'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '80', 'Plasnica'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '81', 'Radovis'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '82', 'Prilep'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '83', 'Probistip'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '84', 'Radovis'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '85', 'Rankovce'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '86', 'Resen'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '87', 'Rosoman'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '88', 'Mavrovo i Rostusa'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '89', 'Makedonski Brod'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '91', 'Tetovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '92', 'Sopiste'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '93', 'Demir Hisar'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '94', 'Gostivar'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '96', 'Dojran'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '97', 'Staro Nagoricane'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '98', 'Stip'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', '99', 'Struga'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'A1', 'Strumica'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'A2', 'Studenicani'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'A4', 'Sveti Nikole'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'A5', 'Tearce'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'A6', 'Tetovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'A7', 'Prilep'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'A8', 'Valandovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'A9', 'Vasilevo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'B1', 'Veles'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'B2', 'Struga'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'B3', 'Vevcani'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'B4', 'Vinica'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'B7', 'Vrapciste'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'B8', 'Jegunovce'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'B9', 'Gostivar'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'C2', 'Zelenikovo'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'C3', 'Zelino'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'C4', 'Dolneni'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'C5', 'Probistip'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'C6', 'Zrnovci'),
('MK', 807, 'Macedonia, The Former Yugoslav Republic of', 'F6', 'Skopje'),
('ML', 466, 'Mali', '01', 'Bamako'),
('ML', 466, 'Mali', '03', 'Kayes'),
('ML', 466, 'Mali', '04', 'Mopti'),
('ML', 466, 'Mali', '05', 'Segou'),
('ML', 466, 'Mali', '06', 'Sikasso'),
('ML', 466, 'Mali', '07', 'Koulikoro'),
('ML', 466, 'Mali', '08', 'Tombouctou'),
('ML', 466, 'Mali', '09', 'Gao'),
('ML', 466, 'Mali', '10', 'Kidal'),
('MM', 104, 'Myanmar', '01', 'Rakhine'),
('MM', 104, 'Myanmar', '02', 'Chin'),
('MM', 104, 'Myanmar', '03', 'Ayeyawady'),
('MM', 104, 'Myanmar', '04', 'Kachin'),
('MM', 104, 'Myanmar', '05', 'Kayin'),
('MM', 104, 'Myanmar', '06', 'Kayah'),
('MM', 104, 'Myanmar', '07', 'Magway'),
('MM', 104, 'Myanmar', '08', 'Mandalay'),
('MM', 104, 'Myanmar', '09', 'Bago'),
('MM', 104, 'Myanmar', '10', 'Sagaing'),
('MM', 104, 'Myanmar', '11', 'Shan'),
('MM', 104, 'Myanmar', '12', 'Taninthayi'),
('MM', 104, 'Myanmar', '13', 'Mon'),
('MM', 104, 'Myanmar', '17', 'Yangon'),
('MM', 104, 'Myanmar', '18', 'Nay Pyi Taw'),
('MN', 496, 'Mongolia', '01', 'Arhangay'),
('MN', 496, 'Mongolia', '02', 'Bayanhongor'),
('MN', 496, 'Mongolia', '03', 'Bayan-Olgiy'),
('MN', 496, 'Mongolia', '06', 'Dornod'),
('MN', 496, 'Mongolia', '07', 'Dornogovi'),
('MN', 496, 'Mongolia', '08', 'Dundgovi'),
('MN', 496, 'Mongolia', '09', 'Dzavhan'),
('MN', 496, 'Mongolia', '10', 'Govi-Altay'),
('MN', 496, 'Mongolia', '11', 'Hentiy'),
('MN', 496, 'Mongolia', '12', 'Hovd'),
('MN', 496, 'Mongolia', '13', 'Hovsgol'),
('MN', 496, 'Mongolia', '14', 'Omnogovi'),
('MN', 496, 'Mongolia', '15', 'Ovorhangay'),
('MN', 496, 'Mongolia', '16', 'Selenge'),
('MN', 496, 'Mongolia', '17', 'Suhbaatar'),
('MN', 496, 'Mongolia', '18', 'Tov'),
('MN', 496, 'Mongolia', '19', 'Uvs'),
('MN', 496, 'Mongolia', '20', 'Ulaanbaatar'),
('MN', 496, 'Mongolia', '21', 'Bulgan'),
('MN', 496, 'Mongolia', '23', 'Darhan uul'),
('MN', 496, 'Mongolia', '24', 'Govi-Sumber'),
('MN', 496, 'Mongolia', '25', 'Orhon'),
('MO', 446, 'Macao', '02', 'Macau'),
('MP', 580, 'Northern Mariana Islands', '00', 'Northern Mariana Islands'),
('MP', 580, 'Northern Mariana Islands', '085', 'Northern Mariana Islands'),
('MP', 580, 'Northern Mariana Islands', '110', 'Northern Mariana Islands'),
('MP', 580, 'Northern Mariana Islands', '120', 'Northern Mariana Islands'),
('MQ', 474, 'Martinique', 'MQ', 'Martinique'),
('MR', 478, 'Mauritania', '01', 'Hodh Ech Chargui'),
('MR', 478, 'Mauritania', '02', 'Hodh El Gharbi'),
('MR', 478, 'Mauritania', '03', 'Assaba'),
('MR', 478, 'Mauritania', '04', 'Gorgol'),
('MR', 478, 'Mauritania', '05', 'Brakna'),
('MR', 478, 'Mauritania', '06', 'Trarza'),
('MR', 478, 'Mauritania', '07', 'Adrar'),
('MR', 478, 'Mauritania', '08', 'Dakhlet Nouadhibou'),
('MR', 478, 'Mauritania', '09', 'Tagant'),
('MR', 478, 'Mauritania', '10', 'Guidimaka'),
('MR', 478, 'Mauritania', '11', 'Tiris Zemmour'),
('MR', 478, 'Mauritania', '12', 'Inchiri'),
('MR', 478, 'Mauritania', 'NKC', 'Nouakchott'),
('MS', 500, 'Montserrat', '01', 'Saint Anthony'),
('MS', 500, 'Montserrat', '03', 'Saint Peter'),
('MT', 470, 'Malta', '00', 'Malta'),
('MU', 480, 'Mauritius', '00', 'Moka'),
('MU', 480, 'Mauritius', '12', 'Black River'),
('MU', 480, 'Mauritius', '13', 'Flacq'),
('MU', 480, 'Mauritius', '14', 'Grand Port'),
('MU', 480, 'Mauritius', '15', 'Moka'),
('MU', 480, 'Mauritius', '16', 'Pamplemousses'),
('MU', 480, 'Mauritius', '17', 'Plaines Wilhems'),
('MU', 480, 'Mauritius', '18', 'Port Louis'),
('MU', 480, 'Mauritius', '19', 'Riviere du Rempart'),
('MU', 480, 'Mauritius', '20', 'Savanne'),
('MV', 462, 'Maldives', '01', 'Seenu'),
('MV', 462, 'Maldives', '05', 'Laamu'),
('MV', 462, 'Maldives', '30', 'Alifu'),
('MV', 462, 'Maldives', '31', 'Baa'),
('MV', 462, 'Maldives', '32', 'Dhaalu'),
('MV', 462, 'Maldives', '35', 'Gaafu Dhaalu'),
('MV', 462, 'Maldives', '36', 'Haa Alifu'),
('MV', 462, 'Maldives', '37', 'Haa Dhaalu'),
('MV', 462, 'Maldives', '38', 'Kaafu'),
('MV', 462, 'Maldives', '40', 'Maale'),
('MV', 462, 'Maldives', '41', 'Meemu'),
('MV', 462, 'Maldives', '43', 'Noonu'),
('MV', 462, 'Maldives', '44', 'Raa'),
('MV', 462, 'Maldives', '45', 'Shaviyani'),
('MV', 462, 'Maldives', '46', 'Thaa'),
('MW', 454, 'Malawi', '02', 'Chikwawa'),
('MW', 454, 'Malawi', '03', 'Chiradzulu'),
('MW', 454, 'Malawi', '04', 'Chitipa'),
('MW', 454, 'Malawi', '05', 'Thyolo'),
('MW', 454, 'Malawi', '06', 'Dedza'),
('MW', 454, 'Malawi', '07', 'Dowa'),
('MW', 454, 'Malawi', '08', 'Karonga'),
('MW', 454, 'Malawi', '09', 'Kasungu'),
('MW', 454, 'Malawi', '11', 'Lilongwe'),
('MW', 454, 'Malawi', '12', 'Mangochi'),
('MW', 454, 'Malawi', '13', 'Mchinji'),
('MW', 454, 'Malawi', '15', 'Mzimba'),
('MW', 454, 'Malawi', '16', 'Ntcheu'),
('MW', 454, 'Malawi', '17', 'Nkhata Bay'),
('MW', 454, 'Malawi', '18', 'Nkhotakota'),
('MW', 454, 'Malawi', '19', 'Nsanje'),
('MW', 454, 'Malawi', '20', 'Ntchisi'),
('MW', 454, 'Malawi', '21', 'Rumphi'),
('MW', 454, 'Malawi', '22', 'Salima'),
('MW', 454, 'Malawi', '23', 'Zomba'),
('MW', 454, 'Malawi', '24', 'Blantyre'),
('MW', 454, 'Malawi', '25', 'Mwanza'),
('MW', 454, 'Malawi', '26', 'Balaka'),
('MW', 454, 'Malawi', '27', 'Likoma'),
('MW', 454, 'Malawi', '28', 'Machinga'),
('MW', 454, 'Malawi', '29', 'Mulanje'),
('MW', 454, 'Malawi', '30', 'Phalombe'),
('MW', 454, 'Malawi', '31', 'Neno'),
('MX', 484, 'Mexico', '01', 'Aguascalientes'),
('MX', 484, 'Mexico', '02', 'Baja California'),
('MX', 484, 'Mexico', '03', 'Baja California Sur'),
('MX', 484, 'Mexico', '04', 'Campeche'),
('MX', 484, 'Mexico', '05', 'Chiapas'),
('MX', 484, 'Mexico', '06', 'Chihuahua'),
('MX', 484, 'Mexico', '07', 'Coahuila'),
('MX', 484, 'Mexico', '08', 'Colima'),
('MX', 484, 'Mexico', '09', 'Distrito Federal'),
('MX', 484, 'Mexico', '10', 'Durango'),
('MX', 484, 'Mexico', '11', 'Guanajuato'),
('MX', 484, 'Mexico', '12', 'Guerrero'),
('MX', 484, 'Mexico', '13', 'Hidalgo'),
('MX', 484, 'Mexico', '14', 'Jalisco'),
('MX', 484, 'Mexico', '15', 'Mexico'),
('MX', 484, 'Mexico', '16', 'Michoacan'),
('MX', 484, 'Mexico', '17', 'Morelos'),
('MX', 484, 'Mexico', '18', 'Nayarit'),
('MX', 484, 'Mexico', '19', 'Nuevo Leon'),
('MX', 484, 'Mexico', '20', 'Oaxaca'),
('MX', 484, 'Mexico', '21', 'Puebla'),
('MX', 484, 'Mexico', '22', 'Queretaro'),
('MX', 484, 'Mexico', '23', 'Quintana Roo'),
('MX', 484, 'Mexico', '24', 'San Luis Potosi'),
('MX', 484, 'Mexico', '25', 'Sinaloa'),
('MX', 484, 'Mexico', '26', 'Sonora'),
('MX', 484, 'Mexico', '27', 'Tabasco'),
('MX', 484, 'Mexico', '28', 'Tamaulipas'),
('MX', 484, 'Mexico', '29', 'Tlaxcala'),
('MX', 484, 'Mexico', '30', 'Veracruz'),
('MX', 484, 'Mexico', '31', 'Yucatan'),
('MX', 484, 'Mexico', '32', 'Zacatecas'),
('MY', 458, 'Malaysia', '01', 'Johor'),
('MY', 458, 'Malaysia', '02', 'Kedah'),
('MY', 458, 'Malaysia', '03', 'Kelantan'),
('MY', 458, 'Malaysia', '04', 'Melaka'),
('MY', 458, 'Malaysia', '05', 'Negeri Sembilan'),
('MY', 458, 'Malaysia', '06', 'Pahang'),
('MY', 458, 'Malaysia', '07', 'Perak'),
('MY', 458, 'Malaysia', '08', 'Perlis'),
('MY', 458, 'Malaysia', '09', 'Pulau Pinang'),
('MY', 458, 'Malaysia', '11', 'Sarawak'),
('MY', 458, 'Malaysia', '12', 'Selangor'),
('MY', 458, 'Malaysia', '13', 'Terengganu'),
('MY', 458, 'Malaysia', '14', 'Wilayah Persekutuan Kuala Lumpur'),
('MY', 458, 'Malaysia', '15', 'Wilayah Persekutuan Labuan'),
('MY', 458, 'Malaysia', '16', 'Sabah'),
('MY', 458, 'Malaysia', '17', 'Wilayah Persekutuan Putrajaya'),
('MZ', 508, 'Mozambique', '01', 'Cabo Delgado'),
('MZ', 508, 'Mozambique', '02', 'Gaza'),
('MZ', 508, 'Mozambique', '03', 'Inhambane'),
('MZ', 508, 'Mozambique', '04', 'Maputo'),
('MZ', 508, 'Mozambique', '05', 'Sofala'),
('MZ', 508, 'Mozambique', '06', 'Nampula'),
('MZ', 508, 'Mozambique', '07', 'Niassa'),
('MZ', 508, 'Mozambique', '08', 'Tete'),
('MZ', 508, 'Mozambique', '09', 'Zambezia'),
('MZ', 508, 'Mozambique', '10', 'Manica'),
('MZ', 508, 'Mozambique', '11', 'Maputo'),
('NA', 516, 'Namibia', '06', 'Kunene'),
('NA', 516, 'Namibia', '13', 'Otjozondjupa'),
('NA', 516, 'Namibia', '21', 'Khomas'),
('NA', 516, 'Namibia', '28', 'Zambezi'),
('NA', 516, 'Namibia', '29', 'Erongo'),
('NA', 516, 'Namibia', '30', 'Hardap'),
('NA', 516, 'Namibia', '31', 'Karas'),
('NA', 516, 'Namibia', '32', 'Kunene'),
('NA', 516, 'Namibia', '33', 'Ohangwena'),
('NA', 516, 'Namibia', '34', 'Okavango'),
('NA', 516, 'Namibia', '35', 'Omaheke'),
('NA', 516, 'Namibia', '36', 'Omusati'),
('NA', 516, 'Namibia', '37', 'Oshana'),
('NA', 516, 'Namibia', '38', 'Oshikoto'),
('NA', 516, 'Namibia', '39', 'Otjozondjupa'),
('NC', 540, 'New Caledonia', '01', 'Province Nord'),
('NC', 540, 'New Caledonia', '02', 'Province Sud'),
('NC', 540, 'New Caledonia', '03', 'Province des iles Loyaute'),
('NE', 562, 'Niger', '01', 'Agadez'),
('NE', 562, 'Niger', '02', 'Diffa'),
('NE', 562, 'Niger', '03', 'Dosso'),
('NE', 562, 'Niger', '04', 'Maradi'),
('NE', 562, 'Niger', '06', 'Tahoua'),
('NE', 562, 'Niger', '07', 'Zinder'),
('NE', 562, 'Niger', '08', 'Niamey'),
('NE', 562, 'Niger', '09', 'Tillaberi'),
('NF', 574, 'Norfolk Island', '00', 'Norfolk Island'),
('NG', 566, 'Nigeria', '05', 'Lagos'),
('NG', 566, 'Nigeria', '11', 'Abuja Federal Capital Territory'),
('NG', 566, 'Nigeria', '16', 'Ogun'),
('NG', 566, 'Nigeria', '21', 'Akwa Ibom'),
('NG', 566, 'Nigeria', '22', 'Cross River'),
('NG', 566, 'Nigeria', '23', 'Kaduna'),
('NG', 566, 'Nigeria', '24', 'Katsina'),
('NG', 566, 'Nigeria', '25', 'Anambra'),
('NG', 566, 'Nigeria', '26', 'Benue'),
('NG', 566, 'Nigeria', '27', 'Borno'),
('NG', 566, 'Nigeria', '28', 'Imo'),
('NG', 566, 'Nigeria', '29', 'Kano'),
('NG', 566, 'Nigeria', '30', 'Kwara'),
('NG', 566, 'Nigeria', '31', 'Niger'),
('NG', 566, 'Nigeria', '32', 'Oyo'),
('NG', 566, 'Nigeria', '35', 'Adamawa'),
('NG', 566, 'Nigeria', '36', 'Delta'),
('NG', 566, 'Nigeria', '37', 'Edo'),
('NG', 566, 'Nigeria', '39', 'Jigawa'),
('NG', 566, 'Nigeria', '40', 'Kebbi'),
('NG', 566, 'Nigeria', '41', 'Kogi'),
('NG', 566, 'Nigeria', '42', 'Osun'),
('NG', 566, 'Nigeria', '43', 'Taraba'),
('NG', 566, 'Nigeria', '44', 'Yobe'),
('NG', 566, 'Nigeria', '45', 'Abia'),
('NG', 566, 'Nigeria', '46', 'Bauchi'),
('NG', 566, 'Nigeria', '47', 'Enugu'),
('NG', 566, 'Nigeria', '48', 'Ondo'),
('NG', 566, 'Nigeria', '49', 'Plateau'),
('NG', 566, 'Nigeria', '50', 'Rivers'),
('NG', 566, 'Nigeria', '51', 'Sokoto'),
('NG', 566, 'Nigeria', '52', 'Bayelsa');
INSERT INTO `country_region` (`country_alpha2`, `country_numeric_code`, `country_name`, `code`, `name`) VALUES
('NG', 566, 'Nigeria', '53', 'Ebonyi'),
('NG', 566, 'Nigeria', '54', 'Ekiti'),
('NG', 566, 'Nigeria', '55', 'Gombe'),
('NG', 566, 'Nigeria', '56', 'Nasarawa'),
('NG', 566, 'Nigeria', '57', 'Zamfara'),
('NI', 558, 'Nicaragua', '01', 'Boaco'),
('NI', 558, 'Nicaragua', '02', 'Carazo'),
('NI', 558, 'Nicaragua', '03', 'Chinandega'),
('NI', 558, 'Nicaragua', '04', 'Chontales'),
('NI', 558, 'Nicaragua', '05', 'Esteli'),
('NI', 558, 'Nicaragua', '06', 'Granada'),
('NI', 558, 'Nicaragua', '07', 'Jinotega'),
('NI', 558, 'Nicaragua', '08', 'Leon'),
('NI', 558, 'Nicaragua', '09', 'Madriz'),
('NI', 558, 'Nicaragua', '10', 'Managua'),
('NI', 558, 'Nicaragua', '11', 'Masaya'),
('NI', 558, 'Nicaragua', '12', 'Matagalpa'),
('NI', 558, 'Nicaragua', '13', 'Nueva Segovia'),
('NI', 558, 'Nicaragua', '14', 'Rio San Juan'),
('NI', 558, 'Nicaragua', '15', 'Rivas'),
('NI', 558, 'Nicaragua', '17', 'Atlantico Norte'),
('NI', 558, 'Nicaragua', '18', 'Atlantico Sur'),
('NL', 528, 'Netherlands', '01', 'Drenthe'),
('NL', 528, 'Netherlands', '02', 'Fryslan'),
('NL', 528, 'Netherlands', '03', 'Gelderland'),
('NL', 528, 'Netherlands', '04', 'Groningen'),
('NL', 528, 'Netherlands', '05', 'Limburg'),
('NL', 528, 'Netherlands', '06', 'Noord-Brabant'),
('NL', 528, 'Netherlands', '07', 'Noord-Holland'),
('NL', 528, 'Netherlands', '09', 'Utrecht'),
('NL', 528, 'Netherlands', '10', 'Zeeland'),
('NL', 528, 'Netherlands', '11', 'Zuid-Holland'),
('NL', 528, 'Netherlands', '15', 'Overijssel'),
('NL', 528, 'Netherlands', '16', 'Flevoland'),
('NO', 578, 'Norway', '01', 'Akershus'),
('NO', 578, 'Norway', '02', 'Aust-Agder'),
('NO', 578, 'Norway', '04', 'Buskerud'),
('NO', 578, 'Norway', '05', 'Finnmark'),
('NO', 578, 'Norway', '06', 'Hedmark'),
('NO', 578, 'Norway', '07', 'Hordaland'),
('NO', 578, 'Norway', '08', 'More og Romsdal'),
('NO', 578, 'Norway', '09', 'Nordland'),
('NO', 578, 'Norway', '10', 'Nord-Trondelag'),
('NO', 578, 'Norway', '11', 'Oppland'),
('NO', 578, 'Norway', '12', 'Oslo'),
('NO', 578, 'Norway', '13', 'Ostfold'),
('NO', 578, 'Norway', '14', 'Rogaland'),
('NO', 578, 'Norway', '15', 'Sogn og Fjordane'),
('NO', 578, 'Norway', '16', 'Sor-Trondelag'),
('NO', 578, 'Norway', '17', 'Telemark'),
('NO', 578, 'Norway', '18', 'Troms'),
('NO', 578, 'Norway', '19', 'Vest-Agder'),
('NO', 578, 'Norway', '20', 'Vestfold'),
('NP', 524, 'Nepal', '01', 'Bagmati'),
('NP', 524, 'Nepal', '02', 'Bheri'),
('NP', 524, 'Nepal', '03', 'Dhawalagiri'),
('NP', 524, 'Nepal', '04', 'Gandaki'),
('NP', 524, 'Nepal', '05', 'Janakpur'),
('NP', 524, 'Nepal', '06', 'Karnali'),
('NP', 524, 'Nepal', '07', 'Kosi'),
('NP', 524, 'Nepal', '08', 'Lumbini'),
('NP', 524, 'Nepal', '09', 'Mahakali'),
('NP', 524, 'Nepal', '10', 'Mechi'),
('NP', 524, 'Nepal', '11', 'Narayani'),
('NP', 524, 'Nepal', '12', 'Rapti'),
('NP', 524, 'Nepal', '13', 'Sagarmatha'),
('NP', 524, 'Nepal', '14', 'Seti'),
('NR', 520, 'Nauru', '14', 'Yaren'),
('NU', 570, 'Niue', '00', 'Niue'),
('NZ', 554, 'New Zealand', '10', 'Chatham Islands'),
('NZ', 554, 'New Zealand', 'E7', 'Auckland'),
('NZ', 554, 'New Zealand', 'E8', 'Bay of Plenty'),
('NZ', 554, 'New Zealand', 'E9', 'Canterbury'),
('NZ', 554, 'New Zealand', 'F1', 'Gisborne'),
('NZ', 554, 'New Zealand', 'F2', 'Hawke''s Bay'),
('NZ', 554, 'New Zealand', 'F3', 'Manawatu-Wanganui'),
('NZ', 554, 'New Zealand', 'F4', 'Marlborough'),
('NZ', 554, 'New Zealand', 'F5', 'Nelson'),
('NZ', 554, 'New Zealand', 'F6', 'Northland'),
('NZ', 554, 'New Zealand', 'F7', 'Otago'),
('NZ', 554, 'New Zealand', 'F8', 'Southland'),
('NZ', 554, 'New Zealand', 'F9', 'Taranaki'),
('NZ', 554, 'New Zealand', 'G1', 'Waikato'),
('NZ', 554, 'New Zealand', 'G2', 'Wellington'),
('NZ', 554, 'New Zealand', 'G3', 'West Coast'),
('NZ', 554, 'New Zealand', 'TAS', 'Tasman'),
('OM', 512, 'Oman', '01', 'Ad Dakhiliyah'),
('OM', 512, 'Oman', '02', 'Janub al Batinah'),
('OM', 512, 'Oman', '03', 'Al Wusta'),
('OM', 512, 'Oman', '04', 'Janub ash Sharqiyah'),
('OM', 512, 'Oman', '05', 'Az Zahirah'),
('OM', 512, 'Oman', '06', 'Masqat'),
('OM', 512, 'Oman', '07', 'Musandam'),
('OM', 512, 'Oman', '08', 'Zufar'),
('OM', 512, 'Oman', '09', 'Az Zahirah'),
('OM', 512, 'Oman', '10', 'Al Buraymi'),
('OM', 512, 'Oman', '11', 'Shamal al Batinah'),
('OM', 512, 'Oman', '12', 'Shamal ash Sharqiyah'),
('PA', 591, 'Panama', '01', 'Bocas del Toro'),
('PA', 591, 'Panama', '02', 'Chiriqui'),
('PA', 591, 'Panama', '03', 'Cocle'),
('PA', 591, 'Panama', '04', 'Colon'),
('PA', 591, 'Panama', '05', 'Darien'),
('PA', 591, 'Panama', '06', 'Herrera'),
('PA', 591, 'Panama', '07', 'Los Santos'),
('PA', 591, 'Panama', '08', 'Panama'),
('PA', 591, 'Panama', '09', 'San Blas'),
('PA', 591, 'Panama', '10', 'Veraguas'),
('PE', 604, 'Peru', '01', 'Amazonas'),
('PE', 604, 'Peru', '02', 'Ancash'),
('PE', 604, 'Peru', '03', 'Apurimac'),
('PE', 604, 'Peru', '04', 'Arequipa'),
('PE', 604, 'Peru', '05', 'Ayacucho'),
('PE', 604, 'Peru', '06', 'Cajamarca'),
('PE', 604, 'Peru', '07', 'Callao'),
('PE', 604, 'Peru', '08', 'Cusco'),
('PE', 604, 'Peru', '09', 'Huancavelica'),
('PE', 604, 'Peru', '10', 'Huanuco'),
('PE', 604, 'Peru', '11', 'Ica'),
('PE', 604, 'Peru', '12', 'Junin'),
('PE', 604, 'Peru', '13', 'La Libertad'),
('PE', 604, 'Peru', '14', 'Lambayeque'),
('PE', 604, 'Peru', '15', 'Lima'),
('PE', 604, 'Peru', '16', 'Loreto'),
('PE', 604, 'Peru', '17', 'Madre de Dios'),
('PE', 604, 'Peru', '18', 'Moquegua'),
('PE', 604, 'Peru', '19', 'Pasco'),
('PE', 604, 'Peru', '20', 'Piura'),
('PE', 604, 'Peru', '21', 'Puno'),
('PE', 604, 'Peru', '22', 'San Martin'),
('PE', 604, 'Peru', '23', 'Tacna'),
('PE', 604, 'Peru', '24', 'Tumbes'),
('PE', 604, 'Peru', '25', 'Ucayali'),
('PF', 258, 'French Polynesia', '01', 'Iles du Vent'),
('PF', 258, 'French Polynesia', '02', 'Iles Sous-le-Vent'),
('PF', 258, 'French Polynesia', '03', 'Iles Tuamotu-Gambier'),
('PF', 258, 'French Polynesia', '04', 'Iles Marquises'),
('PF', 258, 'French Polynesia', '05', 'Iles Australes'),
('PG', 598, 'Papua New Guinea', '02', 'Gulf'),
('PG', 598, 'Papua New Guinea', '03', 'Milne Bay'),
('PG', 598, 'Papua New Guinea', '04', 'Northern'),
('PG', 598, 'Papua New Guinea', '05', 'Southern Highlands'),
('PG', 598, 'Papua New Guinea', '06', 'Western'),
('PG', 598, 'Papua New Guinea', '07', 'Bougainville'),
('PG', 598, 'Papua New Guinea', '08', 'Chimbu'),
('PG', 598, 'Papua New Guinea', '09', 'Eastern Highlands'),
('PG', 598, 'Papua New Guinea', '10', 'East New Britain'),
('PG', 598, 'Papua New Guinea', '11', 'East Sepik'),
('PG', 598, 'Papua New Guinea', '12', 'Madang'),
('PG', 598, 'Papua New Guinea', '13', 'Manus'),
('PG', 598, 'Papua New Guinea', '14', 'Morobe'),
('PG', 598, 'Papua New Guinea', '15', 'New Ireland'),
('PG', 598, 'Papua New Guinea', '16', 'Western Highlands'),
('PG', 598, 'Papua New Guinea', '17', 'West New Britain'),
('PG', 598, 'Papua New Guinea', '18', 'West Sepik'),
('PG', 598, 'Papua New Guinea', '19', 'Enga'),
('PG', 598, 'Papua New Guinea', '20', 'National Capital District'),
('PH', 608, 'Philippines', '01', 'Abra'),
('PH', 608, 'Philippines', '02', 'Agusan del Norte'),
('PH', 608, 'Philippines', '03', 'Agusan del Sur'),
('PH', 608, 'Philippines', '04', 'Aklan'),
('PH', 608, 'Philippines', '05', 'Albay'),
('PH', 608, 'Philippines', '06', 'Antique'),
('PH', 608, 'Philippines', '07', 'Bataan'),
('PH', 608, 'Philippines', '08', 'Batanes'),
('PH', 608, 'Philippines', '09', 'Batangas'),
('PH', 608, 'Philippines', '10', 'Benguet'),
('PH', 608, 'Philippines', '11', 'Bohol'),
('PH', 608, 'Philippines', '12', 'Bukidnon'),
('PH', 608, 'Philippines', '13', 'Bulacan'),
('PH', 608, 'Philippines', '14', 'Cagayan'),
('PH', 608, 'Philippines', '15', 'Camarines Norte'),
('PH', 608, 'Philippines', '16', 'Camarines Sur'),
('PH', 608, 'Philippines', '17', 'Camiguin'),
('PH', 608, 'Philippines', '18', 'Capiz'),
('PH', 608, 'Philippines', '19', 'Catanduanes'),
('PH', 608, 'Philippines', '20', 'Cavite'),
('PH', 608, 'Philippines', '21', 'Cebu'),
('PH', 608, 'Philippines', '22', 'Basilan'),
('PH', 608, 'Philippines', '23', 'Eastern Samar'),
('PH', 608, 'Philippines', '24', 'Davao del Sur'),
('PH', 608, 'Philippines', '25', 'Davao del Sur'),
('PH', 608, 'Philippines', '26', 'Davao Oriental'),
('PH', 608, 'Philippines', '27', 'Ifugao'),
('PH', 608, 'Philippines', '28', 'Ilocos Norte'),
('PH', 608, 'Philippines', '29', 'Ilocos Sur'),
('PH', 608, 'Philippines', '30', 'Iloilo'),
('PH', 608, 'Philippines', '31', 'Isabela'),
('PH', 608, 'Philippines', '33', 'Laguna'),
('PH', 608, 'Philippines', '34', 'Lanao del Norte'),
('PH', 608, 'Philippines', '35', 'Lanao del Sur'),
('PH', 608, 'Philippines', '36', 'La Union'),
('PH', 608, 'Philippines', '37', 'Leyte'),
('PH', 608, 'Philippines', '38', 'Marinduque'),
('PH', 608, 'Philippines', '39', 'Masbate'),
('PH', 608, 'Philippines', '40', 'Mindoro Occidental'),
('PH', 608, 'Philippines', '41', 'Mindoro Oriental'),
('PH', 608, 'Philippines', '42', 'Misamis Occidental'),
('PH', 608, 'Philippines', '43', 'Misamis Oriental'),
('PH', 608, 'Philippines', '44', 'Mountain Province'),
('PH', 608, 'Philippines', '46', 'Negros Oriental'),
('PH', 608, 'Philippines', '47', 'Nueva Ecija'),
('PH', 608, 'Philippines', '48', 'Nueva Vizcaya'),
('PH', 608, 'Philippines', '49', 'Palawan'),
('PH', 608, 'Philippines', '50', 'Pampanga'),
('PH', 608, 'Philippines', '51', 'Pangasinan'),
('PH', 608, 'Philippines', '53', 'Rizal'),
('PH', 608, 'Philippines', '54', 'Romblon'),
('PH', 608, 'Philippines', '55', 'Samar (Western Samar)'),
('PH', 608, 'Philippines', '56', 'Maguindanao'),
('PH', 608, 'Philippines', '57', 'Cotabato'),
('PH', 608, 'Philippines', '58', 'Sorsogon'),
('PH', 608, 'Philippines', '59', 'Southern Leyte'),
('PH', 608, 'Philippines', '60', 'Sulu'),
('PH', 608, 'Philippines', '61', 'Surigao del Norte'),
('PH', 608, 'Philippines', '62', 'Surigao del Sur'),
('PH', 608, 'Philippines', '63', 'Tarlac'),
('PH', 608, 'Philippines', '64', 'Zambales'),
('PH', 608, 'Philippines', '65', 'Zamboanga del Norte'),
('PH', 608, 'Philippines', '66', 'Zamboanga del Sur'),
('PH', 608, 'Philippines', '67', 'Northern Samar'),
('PH', 608, 'Philippines', '68', 'Quirino'),
('PH', 608, 'Philippines', '69', 'Siquijor'),
('PH', 608, 'Philippines', '70', 'South Cotabato'),
('PH', 608, 'Philippines', '71', 'Sultan Kudarat'),
('PH', 608, 'Philippines', '72', 'Tawi-Tawi'),
('PH', 608, 'Philippines', 'A1', 'Pampanga'),
('PH', 608, 'Philippines', 'A2', 'Negros Occidental'),
('PH', 608, 'Philippines', 'A4', 'Benguet'),
('PH', 608, 'Philippines', 'A7', 'Batangas'),
('PH', 608, 'Philippines', 'A8', 'Agusan del Norte'),
('PH', 608, 'Philippines', 'A9', 'Nueva Ecija'),
('PH', 608, 'Philippines', 'B1', 'Negros Occidental'),
('PH', 608, 'Philippines', 'B2', 'Misamis Oriental'),
('PH', 608, 'Philippines', 'B3', 'Samar (Western Samar)'),
('PH', 608, 'Philippines', 'B4', 'National Capital Region'),
('PH', 608, 'Philippines', 'B5', 'Negros Oriental'),
('PH', 608, 'Philippines', 'B6', 'Cavite'),
('PH', 608, 'Philippines', 'B8', 'Cotabato'),
('PH', 608, 'Philippines', 'C1', 'Cebu'),
('PH', 608, 'Philippines', 'C2', 'Zamboanga del Norte'),
('PH', 608, 'Philippines', 'C3', 'Davao del Sur'),
('PH', 608, 'Philippines', 'C4', 'Zamboanga del Norte'),
('PH', 608, 'Philippines', 'C5', 'Negros Oriental'),
('PH', 608, 'Philippines', 'C6', 'South Cotabato'),
('PH', 608, 'Philippines', 'C7', 'Misamis Oriental'),
('PH', 608, 'Philippines', 'C8', 'Lanao del Norte'),
('PH', 608, 'Philippines', 'C9', 'Iloilo'),
('PH', 608, 'Philippines', 'D1', 'Camarines Sur'),
('PH', 608, 'Philippines', 'D2', 'Negros Occidental'),
('PH', 608, 'Philippines', 'D3', 'Ilocos Norte'),
('PH', 608, 'Philippines', 'D4', 'Cebu'),
('PH', 608, 'Philippines', 'D5', 'Albay'),
('PH', 608, 'Philippines', 'D6', 'Batangas'),
('PH', 608, 'Philippines', 'D7', 'Quezon'),
('PH', 608, 'Philippines', 'D8', 'Cebu'),
('PH', 608, 'Philippines', 'D9', 'National Capital Region'),
('PH', 608, 'Philippines', 'E1', 'Lanao del Sur'),
('PH', 608, 'Philippines', 'E2', 'Camarines Sur'),
('PH', 608, 'Philippines', 'E3', 'Zambales'),
('PH', 608, 'Philippines', 'E4', 'Leyte'),
('PH', 608, 'Philippines', 'E5', 'Misamis Occidental'),
('PH', 608, 'Philippines', 'E6', 'Misamis Occidental'),
('PH', 608, 'Philippines', 'E7', 'Zamboanga del Sur'),
('PH', 608, 'Philippines', 'E8', 'Nueva Ecija'),
('PH', 608, 'Philippines', 'F1', 'Palawan'),
('PH', 608, 'Philippines', 'F3', 'Capiz'),
('PH', 608, 'Philippines', 'F4', 'Negros Occidental'),
('PH', 608, 'Philippines', 'F7', 'Laguna'),
('PH', 608, 'Philippines', 'F8', 'Negros Occidental'),
('PH', 608, 'Philippines', 'F9', 'Surigao del Norte'),
('PH', 608, 'Philippines', 'G1', 'Leyte'),
('PH', 608, 'Philippines', 'G2', 'Cavite'),
('PH', 608, 'Philippines', 'G3', 'Bohol'),
('PH', 608, 'Philippines', 'G4', 'Misamis Occidental'),
('PH', 608, 'Philippines', 'G5', 'Cebu'),
('PH', 608, 'Philippines', 'G6', 'Cavite'),
('PH', 608, 'Philippines', 'G7', 'Zamboanga del Sur'),
('PH', 608, 'Philippines', 'G8', 'Aurora'),
('PH', 608, 'Philippines', 'H2', 'Quezon'),
('PH', 608, 'Philippines', 'H3', 'Negros Occidental'),
('PH', 608, 'Philippines', 'H6', 'Apayao'),
('PH', 608, 'Philippines', 'J7', 'Kalinga'),
('PK', 586, 'Pakistan', '01', 'Federally Administered Tribal Areas'),
('PK', 586, 'Pakistan', '02', 'Balochistan'),
('PK', 586, 'Pakistan', '03', 'Khyber Pakhtunkhwa'),
('PK', 586, 'Pakistan', '04', 'Punjab'),
('PK', 586, 'Pakistan', '05', 'Sindh'),
('PK', 586, 'Pakistan', '06', 'Azad Kashmir'),
('PK', 586, 'Pakistan', '07', 'Gilgit-Baltistan'),
('PK', 586, 'Pakistan', '08', 'Islamabad'),
('PL', 616, 'Poland', '72', 'Dolnoslaskie'),
('PL', 616, 'Poland', '73', 'Kujawsko-Pomorskie'),
('PL', 616, 'Poland', '74', 'Lodzkie'),
('PL', 616, 'Poland', '75', 'Lubelskie'),
('PL', 616, 'Poland', '76', 'Lubuskie'),
('PL', 616, 'Poland', '77', 'Malopolskie'),
('PL', 616, 'Poland', '78', 'Mazowieckie'),
('PL', 616, 'Poland', '79', 'Opolskie'),
('PL', 616, 'Poland', '80', 'Podkarpackie'),
('PL', 616, 'Poland', '81', 'Podlaskie'),
('PL', 616, 'Poland', '82', 'Pomorskie'),
('PL', 616, 'Poland', '83', 'Slaskie'),
('PL', 616, 'Poland', '84', 'Swietokrzyskie'),
('PL', 616, 'Poland', '85', 'Warminsko-Mazurskie'),
('PL', 616, 'Poland', '86', 'Wielkopolskie'),
('PL', 616, 'Poland', '87', 'Zachodniopomorskie'),
('PM', 666, 'Saint Pierre and Miquelon', '97501', 'Saint Pierre and Miquelon'),
('PM', 666, 'Saint Pierre and Miquelon', '97502', 'Saint Pierre and Miquelon'),
('PN', 612, 'Pitcairn', '00', 'Pitcairn Islands'),
('PR', 630, 'Puerto Rico', '001', 'Adjuntas'),
('PR', 630, 'Puerto Rico', '003', 'Aguada'),
('PR', 630, 'Puerto Rico', '005', 'Aguadilla'),
('PR', 630, 'Puerto Rico', '007', 'Aguas Buenas'),
('PR', 630, 'Puerto Rico', '009', 'Aibonito'),
('PR', 630, 'Puerto Rico', '011', 'Anasco'),
('PR', 630, 'Puerto Rico', '013', 'Arecibo'),
('PR', 630, 'Puerto Rico', '015', 'Arroyo'),
('PR', 630, 'Puerto Rico', '017', 'Barceloneta'),
('PR', 630, 'Puerto Rico', '019', 'Barranquitas'),
('PR', 630, 'Puerto Rico', '021', 'Bayamon'),
('PR', 630, 'Puerto Rico', '023', 'Cabo Rojo'),
('PR', 630, 'Puerto Rico', '025', 'Caguas'),
('PR', 630, 'Puerto Rico', '027', 'Camuy'),
('PR', 630, 'Puerto Rico', '029', 'Canovanas'),
('PR', 630, 'Puerto Rico', '031', 'Carolina'),
('PR', 630, 'Puerto Rico', '033', 'Catano'),
('PR', 630, 'Puerto Rico', '035', 'Cayey'),
('PR', 630, 'Puerto Rico', '037', 'Ceiba'),
('PR', 630, 'Puerto Rico', '039', 'Ciales'),
('PR', 630, 'Puerto Rico', '041', 'Cidra'),
('PR', 630, 'Puerto Rico', '043', 'Coamo'),
('PR', 630, 'Puerto Rico', '045', 'Comerio'),
('PR', 630, 'Puerto Rico', '047', 'Corozal'),
('PR', 630, 'Puerto Rico', '049', 'Culebra'),
('PR', 630, 'Puerto Rico', '051', 'Dorado'),
('PR', 630, 'Puerto Rico', '053', 'Fajardo'),
('PR', 630, 'Puerto Rico', '054', 'Florida'),
('PR', 630, 'Puerto Rico', '055', 'Guanica'),
('PR', 630, 'Puerto Rico', '057', 'Guayama'),
('PR', 630, 'Puerto Rico', '059', 'Guayanilla'),
('PR', 630, 'Puerto Rico', '061', 'Guaynabo'),
('PR', 630, 'Puerto Rico', '063', 'Gurabo'),
('PR', 630, 'Puerto Rico', '065', 'Hatillo'),
('PR', 630, 'Puerto Rico', '067', 'Hormigueros'),
('PR', 630, 'Puerto Rico', '069', 'Humacao'),
('PR', 630, 'Puerto Rico', '071', 'Isabela'),
('PR', 630, 'Puerto Rico', '073', 'Municipio de Jayuya'),
('PR', 630, 'Puerto Rico', '075', 'Juana Diaz'),
('PR', 630, 'Puerto Rico', '077', 'Municipio de Juncos'),
('PR', 630, 'Puerto Rico', '079', 'Lajas'),
('PR', 630, 'Puerto Rico', '081', 'Lares'),
('PR', 630, 'Puerto Rico', '083', 'Las Marias'),
('PR', 630, 'Puerto Rico', '085', 'Las Piedras'),
('PR', 630, 'Puerto Rico', '087', 'Loiza'),
('PR', 630, 'Puerto Rico', '089', 'Luquillo'),
('PR', 630, 'Puerto Rico', '091', 'Manati'),
('PR', 630, 'Puerto Rico', '093', 'Maricao'),
('PR', 630, 'Puerto Rico', '095', 'Maunabo'),
('PR', 630, 'Puerto Rico', '097', 'Mayaguez'),
('PR', 630, 'Puerto Rico', '099', 'Moca'),
('PR', 630, 'Puerto Rico', '101', 'Morovis'),
('PR', 630, 'Puerto Rico', '103', 'Naguabo'),
('PR', 630, 'Puerto Rico', '105', 'Naranjito'),
('PR', 630, 'Puerto Rico', '109', 'Patillas'),
('PR', 630, 'Puerto Rico', '111', 'Penuelas'),
('PR', 630, 'Puerto Rico', '113', 'Ponce'),
('PR', 630, 'Puerto Rico', '115', 'Quebradillas'),
('PR', 630, 'Puerto Rico', '117', 'Rincon'),
('PR', 630, 'Puerto Rico', '119', 'Rio Grande'),
('PR', 630, 'Puerto Rico', '121', 'Sabana Grande'),
('PR', 630, 'Puerto Rico', '123', 'Salinas'),
('PR', 630, 'Puerto Rico', '125', 'San German'),
('PR', 630, 'Puerto Rico', '127', 'San Juan'),
('PR', 630, 'Puerto Rico', '129', 'San Lorenzo'),
('PR', 630, 'Puerto Rico', '131', 'San Sebastian'),
('PR', 630, 'Puerto Rico', '133', 'Santa Isabel Municipio'),
('PR', 630, 'Puerto Rico', '135', 'Toa Alta'),
('PR', 630, 'Puerto Rico', '137', 'Toa Baja'),
('PR', 630, 'Puerto Rico', '139', 'Trujillo Alto'),
('PR', 630, 'Puerto Rico', '141', 'Utuado'),
('PR', 630, 'Puerto Rico', '143', 'Vega Alta'),
('PR', 630, 'Puerto Rico', '145', 'Vega Baja'),
('PR', 630, 'Puerto Rico', '147', 'Vieques'),
('PR', 630, 'Puerto Rico', '149', 'Villalba'),
('PR', 630, 'Puerto Rico', '151', 'Yabucoa'),
('PR', 630, 'Puerto Rico', '153', 'Yauco'),
('PS', 275, 'Palestine, State of', 'GZ', 'Gaza'),
('PS', 275, 'Palestine, State of', 'WE', 'West Bank'),
('PT', 620, 'Portugal', '02', 'Aveiro'),
('PT', 620, 'Portugal', '03', 'Beja'),
('PT', 620, 'Portugal', '04', 'Braga'),
('PT', 620, 'Portugal', '05', 'Braganca'),
('PT', 620, 'Portugal', '06', 'Castelo Branco'),
('PT', 620, 'Portugal', '07', 'Coimbra'),
('PT', 620, 'Portugal', '08', 'Evora'),
('PT', 620, 'Portugal', '09', 'Faro'),
('PT', 620, 'Portugal', '10', 'Regiao Autonoma da Madeira'),
('PT', 620, 'Portugal', '11', 'Guarda'),
('PT', 620, 'Portugal', '13', 'Leiria'),
('PT', 620, 'Portugal', '14', 'Lisboa'),
('PT', 620, 'Portugal', '16', 'Portalegre'),
('PT', 620, 'Portugal', '17', 'Porto'),
('PT', 620, 'Portugal', '18', 'Santarem'),
('PT', 620, 'Portugal', '19', 'Setubal'),
('PT', 620, 'Portugal', '20', 'Viana do Castelo'),
('PT', 620, 'Portugal', '21', 'Vila Real'),
('PT', 620, 'Portugal', '22', 'Viseu'),
('PT', 620, 'Portugal', '23', 'Regiao Autonoma dos Acores'),
('PW', 585, 'Palau', '01', 'Aimeliik'),
('PW', 585, 'Palau', '02', 'Airai'),
('PW', 585, 'Palau', '03', 'Angaur'),
('PW', 585, 'Palau', '05', 'Kayangel'),
('PW', 585, 'Palau', '06', 'Koror'),
('PW', 585, 'Palau', '07', 'Melekeok'),
('PW', 585, 'Palau', '08', 'Ngaraard'),
('PW', 585, 'Palau', '09', 'Ngarchelong'),
('PW', 585, 'Palau', '10', 'Ngardmau'),
('PW', 585, 'Palau', '11', 'Ngatpang'),
('PW', 585, 'Palau', '14', 'Ngiwal'),
('PW', 585, 'Palau', '15', 'Peleliu'),
('PY', 600, 'Paraguay', '01', 'Alto Parana'),
('PY', 600, 'Paraguay', '02', 'Amambay'),
('PY', 600, 'Paraguay', '04', 'Caaguazu'),
('PY', 600, 'Paraguay', '05', 'Caazapa'),
('PY', 600, 'Paraguay', '06', 'Central'),
('PY', 600, 'Paraguay', '07', 'Concepcion'),
('PY', 600, 'Paraguay', '08', 'Cordillera'),
('PY', 600, 'Paraguay', '10', 'Guaira'),
('PY', 600, 'Paraguay', '11', 'Itapua'),
('PY', 600, 'Paraguay', '12', 'Misiones'),
('PY', 600, 'Paraguay', '13', 'Neembucu'),
('PY', 600, 'Paraguay', '15', 'Paraguari'),
('PY', 600, 'Paraguay', '16', 'Presidente Hayes'),
('PY', 600, 'Paraguay', '17', 'San Pedro'),
('PY', 600, 'Paraguay', '19', 'Canindeyu'),
('PY', 600, 'Paraguay', '22', 'Asuncion'),
('PY', 600, 'Paraguay', '23', 'Alto Paraguay'),
('PY', 600, 'Paraguay', '24', 'Boqueron'),
('QA', 634, 'Qatar', '01', 'Ad Dawhah'),
('QA', 634, 'Qatar', '04', 'Al Khawr wa adh Dhakhirah'),
('QA', 634, 'Qatar', '06', 'Ar Rayyan'),
('QA', 634, 'Qatar', '08', 'Ash Shamal'),
('QA', 634, 'Qatar', '09', 'Umm Salal'),
('QA', 634, 'Qatar', '10', 'Al Wakrah'),
('QA', 634, 'Qatar', '13', 'Az Za''ayin'),
('RE', 638, 'Reunion', 'RE', 'Reunion'),
('RO', 642, 'Romania', '01', 'Alba'),
('RO', 642, 'Romania', '02', 'Arad'),
('RO', 642, 'Romania', '03', 'Arges'),
('RO', 642, 'Romania', '04', 'Bacau'),
('RO', 642, 'Romania', '05', 'Bihor'),
('RO', 642, 'Romania', '06', 'Bistrita-Nasaud'),
('RO', 642, 'Romania', '07', 'Botosani'),
('RO', 642, 'Romania', '08', 'Braila'),
('RO', 642, 'Romania', '09', 'Brasov'),
('RO', 642, 'Romania', '10', 'Bucuresti'),
('RO', 642, 'Romania', '11', 'Buzau'),
('RO', 642, 'Romania', '12', 'Caras-Severin'),
('RO', 642, 'Romania', '13', 'Cluj'),
('RO', 642, 'Romania', '14', 'Constanta'),
('RO', 642, 'Romania', '15', 'Covasna'),
('RO', 642, 'Romania', '16', 'Dambovita'),
('RO', 642, 'Romania', '17', 'Dolj'),
('RO', 642, 'Romania', '18', 'Galati'),
('RO', 642, 'Romania', '19', 'Gorj'),
('RO', 642, 'Romania', '20', 'Harghita'),
('RO', 642, 'Romania', '21', 'Hunedoara'),
('RO', 642, 'Romania', '22', 'Ialomita'),
('RO', 642, 'Romania', '23', 'Iasi'),
('RO', 642, 'Romania', '25', 'Maramures'),
('RO', 642, 'Romania', '26', 'Mehedinti'),
('RO', 642, 'Romania', '27', 'Mures'),
('RO', 642, 'Romania', '28', 'Neamt'),
('RO', 642, 'Romania', '29', 'Olt'),
('RO', 642, 'Romania', '30', 'Prahova'),
('RO', 642, 'Romania', '31', 'Salaj'),
('RO', 642, 'Romania', '32', 'Satu Mare'),
('RO', 642, 'Romania', '33', 'Sibiu'),
('RO', 642, 'Romania', '34', 'Suceava'),
('RO', 642, 'Romania', '35', 'Teleorman'),
('RO', 642, 'Romania', '36', 'Timis'),
('RO', 642, 'Romania', '37', 'Tulcea'),
('RO', 642, 'Romania', '38', 'Vaslui'),
('RO', 642, 'Romania', '39', 'Valcea'),
('RO', 642, 'Romania', '40', 'Vrancea'),
('RO', 642, 'Romania', '41', 'Calarasi'),
('RO', 642, 'Romania', '42', 'Giurgiu'),
('RO', 642, 'Romania', '43', 'Ilfov'),
('RS', 688, 'Serbia', '00', 'Central Serbia'),
('RS', 688, 'Serbia', '01', 'Kosovo'),
('RS', 688, 'Serbia', '02', 'Vojvodina'),
('RU', 643, 'Russian Federation', '01', 'Adygeya, Respublika'),
('RU', 643, 'Russian Federation', '03', 'Altay, Respublika'),
('RU', 643, 'Russian Federation', '04', 'Altayskiy kray'),
('RU', 643, 'Russian Federation', '05', 'Amurskaya oblast'''),
('RU', 643, 'Russian Federation', '06', 'Arkhangel''skaya oblast'''),
('RU', 643, 'Russian Federation', '07', 'Astrakhanskaya oblast'''),
('RU', 643, 'Russian Federation', '08', 'Bashkortostan, Respublika'),
('RU', 643, 'Russian Federation', '09', 'Belgorodskaya oblast'''),
('RU', 643, 'Russian Federation', '10', 'Bryanskaya oblast'''),
('RU', 643, 'Russian Federation', '11', 'Buryatiya, Respublika'),
('RU', 643, 'Russian Federation', '12', 'Chechenskaya Respublika'),
('RU', 643, 'Russian Federation', '13', 'Chelyabinskaya oblast'''),
('RU', 643, 'Russian Federation', '15', 'Chukotskiy avtonomnyy okrug'),
('RU', 643, 'Russian Federation', '16', 'Chuvashskaya Respublika'),
('RU', 643, 'Russian Federation', '17', 'Dagestan, Respublika'),
('RU', 643, 'Russian Federation', '19', 'Ingushetiya, Respublika'),
('RU', 643, 'Russian Federation', '20', 'Irkutskaya oblast'''),
('RU', 643, 'Russian Federation', '21', 'Ivanovskaya oblast'''),
('RU', 643, 'Russian Federation', '22', 'Kabardino-Balkarskaya Respublika'),
('RU', 643, 'Russian Federation', '23', 'Kaliningradskaya oblast'''),
('RU', 643, 'Russian Federation', '24', 'Kalmykiya, Respublika'),
('RU', 643, 'Russian Federation', '25', 'Kaluzhskaya oblast'''),
('RU', 643, 'Russian Federation', '27', 'Karachayevo-Cherkesskaya Respublika'),
('RU', 643, 'Russian Federation', '28', 'Kareliya, Respublika'),
('RU', 643, 'Russian Federation', '29', 'Kemerovskaya oblast'''),
('RU', 643, 'Russian Federation', '30', 'Khabarovskiy kray'),
('RU', 643, 'Russian Federation', '31', 'Khakasiya, Respublika'),
('RU', 643, 'Russian Federation', '32', 'Khanty-Mansiyskiy avtonomnyy okrug-Yugra'),
('RU', 643, 'Russian Federation', '33', 'Kirovskaya oblast'''),
('RU', 643, 'Russian Federation', '34', 'Komi, Respublika'),
('RU', 643, 'Russian Federation', '37', 'Kostromskaya oblast'''),
('RU', 643, 'Russian Federation', '38', 'Krasnodarskiy kray'),
('RU', 643, 'Russian Federation', '40', 'Kurganskaya oblast'''),
('RU', 643, 'Russian Federation', '41', 'Kurskaya oblast'''),
('RU', 643, 'Russian Federation', '42', 'Leningradskaya oblast'''),
('RU', 643, 'Russian Federation', '43', 'Lipetskaya oblast'''),
('RU', 643, 'Russian Federation', '44', 'Magadanskaya oblast'''),
('RU', 643, 'Russian Federation', '45', 'Mariy El, Respublika'),
('RU', 643, 'Russian Federation', '46', 'Mordoviya, Respublika'),
('RU', 643, 'Russian Federation', '47', 'Moskovskaya oblast'''),
('RU', 643, 'Russian Federation', '48', 'Moskva'),
('RU', 643, 'Russian Federation', '49', 'Murmanskaya oblast'''),
('RU', 643, 'Russian Federation', '50', 'Nenetskiy avtonomnyy okrug'),
('RU', 643, 'Russian Federation', '51', 'Nizhegorodskaya oblast'''),
('RU', 643, 'Russian Federation', '52', 'Novgorodskaya oblast'''),
('RU', 643, 'Russian Federation', '53', 'Novosibirskaya oblast'''),
('RU', 643, 'Russian Federation', '54', 'Omskaya oblast'''),
('RU', 643, 'Russian Federation', '55', 'Orenburgskaya oblast'''),
('RU', 643, 'Russian Federation', '56', 'Orlovskaya oblast'''),
('RU', 643, 'Russian Federation', '57', 'Penzenskaya oblast'''),
('RU', 643, 'Russian Federation', '58', 'Permskiy kray'),
('RU', 643, 'Russian Federation', '59', 'Primorskiy kray'),
('RU', 643, 'Russian Federation', '60', 'Pskovskaya oblast'''),
('RU', 643, 'Russian Federation', '61', 'Rostovskaya oblast'''),
('RU', 643, 'Russian Federation', '62', 'Ryazanskaya oblast'''),
('RU', 643, 'Russian Federation', '63', 'Sakha, Respublika'),
('RU', 643, 'Russian Federation', '64', 'Sakhalinskaya oblast'''),
('RU', 643, 'Russian Federation', '65', 'Samarskaya oblast'''),
('RU', 643, 'Russian Federation', '66', 'Sankt-Peterburg'),
('RU', 643, 'Russian Federation', '67', 'Saratovskaya oblast'''),
('RU', 643, 'Russian Federation', '68', 'Severnaya Osetiya-Alaniya, Respublika'),
('RU', 643, 'Russian Federation', '69', 'Smolenskaya oblast'''),
('RU', 643, 'Russian Federation', '70', 'Stavropol''skiy kray'),
('RU', 643, 'Russian Federation', '71', 'Sverdlovskaya oblast'''),
('RU', 643, 'Russian Federation', '72', 'Tambovskaya oblast'''),
('RU', 643, 'Russian Federation', '73', 'Tatarstan, Respublika'),
('RU', 643, 'Russian Federation', '75', 'Tomskaya oblast'''),
('RU', 643, 'Russian Federation', '76', 'Tul''skaya oblast'''),
('RU', 643, 'Russian Federation', '77', 'Tverskaya oblast'''),
('RU', 643, 'Russian Federation', '78', 'Tyumenskaya oblast'''),
('RU', 643, 'Russian Federation', '79', 'Tyva, Respublika'),
('RU', 643, 'Russian Federation', '80', 'Udmurtskaya Respublika'),
('RU', 643, 'Russian Federation', '81', 'Ul''yanovskaya oblast'''),
('RU', 643, 'Russian Federation', '83', 'Vladimirskaya oblast'''),
('RU', 643, 'Russian Federation', '84', 'Volgogradskaya oblast'''),
('RU', 643, 'Russian Federation', '85', 'Vologodskaya oblast'''),
('RU', 643, 'Russian Federation', '86', 'Voronezhskaya oblast'''),
('RU', 643, 'Russian Federation', '87', 'Yamalo-Nenetskiy avtonomnyy okrug'),
('RU', 643, 'Russian Federation', '88', 'Yaroslavskaya oblast'''),
('RU', 643, 'Russian Federation', '89', 'Yevreyskaya avtonomnaya oblast'''),
('RU', 643, 'Russian Federation', '90', 'Permskiy kray'),
('RU', 643, 'Russian Federation', '91', 'Krasnoyarskiy kray'),
('RU', 643, 'Russian Federation', '92', 'Kamchatskiy kray'),
('RU', 643, 'Russian Federation', '93', 'Zabaykal''skiy kray'),
('RW', 646, 'Rwanda', '11', 'Est'),
('RW', 646, 'Rwanda', '12', 'Ville de Kigali'),
('RW', 646, 'Rwanda', '13', 'Nord'),
('RW', 646, 'Rwanda', '14', 'Ouest'),
('RW', 646, 'Rwanda', '15', 'Sud'),
('SA', 682, 'Saudi Arabia', '02', 'Al Bahah'),
('SA', 682, 'Saudi Arabia', '05', 'Al Madinah al Munawwarah'),
('SA', 682, 'Saudi Arabia', '06', 'Ash Sharqiyah'),
('SA', 682, 'Saudi Arabia', '08', 'Al Qasim'),
('SA', 682, 'Saudi Arabia', '10', 'Ar Riyad'),
('SA', 682, 'Saudi Arabia', '11', '''Asir'),
('SA', 682, 'Saudi Arabia', '13', 'Ha''il'),
('SA', 682, 'Saudi Arabia', '14', 'Makkah al Mukarramah'),
('SA', 682, 'Saudi Arabia', '15', 'Al Hudud ash Shamaliyah'),
('SA', 682, 'Saudi Arabia', '16', 'Najran'),
('SA', 682, 'Saudi Arabia', '17', 'Jazan'),
('SA', 682, 'Saudi Arabia', '19', 'Tabuk'),
('SA', 682, 'Saudi Arabia', '20', 'Al Jawf'),
('SB', 90, 'Solomon Islands', '03', 'Malaita'),
('SB', 90, 'Solomon Islands', '06', 'Guadalcanal'),
('SB', 90, 'Solomon Islands', '07', 'Isabel'),
('SB', 90, 'Solomon Islands', '08', 'Makira'),
('SB', 90, 'Solomon Islands', '10', 'Central'),
('SB', 90, 'Solomon Islands', '11', 'Western'),
('SC', 690, 'Seychelles', '26', 'English River'),
('SD', 729, 'Sudan', '29', 'Khartoum'),
('SD', 729, 'Sudan', '36', 'Red Sea'),
('SD', 729, 'Sudan', '38', 'Gezira'),
('SD', 729, 'Sudan', '39', 'Gedaref'),
('SD', 729, 'Sudan', '41', 'White Nile'),
('SD', 729, 'Sudan', '42', 'Blue Nile'),
('SD', 729, 'Sudan', '43', 'Northern'),
('SD', 729, 'Sudan', '47', 'West Darfur'),
('SD', 729, 'Sudan', '49', 'South Darfur'),
('SD', 729, 'Sudan', '50', 'South Kordofan'),
('SD', 729, 'Sudan', '52', 'Kassala'),
('SD', 729, 'Sudan', '53', 'River Nile'),
('SD', 729, 'Sudan', '55', 'North Darfur'),
('SD', 729, 'Sudan', '56', 'North Kordofan'),
('SD', 729, 'Sudan', '58', 'Sennar'),
('SE', 752, 'Sweden', '02', 'Blekinge Lan'),
('SE', 752, 'Sweden', '03', 'Gavleborgs Lan'),
('SE', 752, 'Sweden', '05', 'Gotlands Lan'),
('SE', 752, 'Sweden', '06', 'Hallands Lan'),
('SE', 752, 'Sweden', '07', 'Jamtlands Lan'),
('SE', 752, 'Sweden', '08', 'Jonkopings Lan'),
('SE', 752, 'Sweden', '09', 'Kalmar Lan'),
('SE', 752, 'Sweden', '10', 'Dalarnas Lan'),
('SE', 752, 'Sweden', '12', 'Kronobergs Lan'),
('SE', 752, 'Sweden', '14', 'Norrbottens Lan'),
('SE', 752, 'Sweden', '15', 'Orebro Lan'),
('SE', 752, 'Sweden', '16', 'Ostergotlands Lan'),
('SE', 752, 'Sweden', '18', 'Sodermanlands Lan'),
('SE', 752, 'Sweden', '21', 'Uppsala Lan'),
('SE', 752, 'Sweden', '22', 'Varmlands Lan'),
('SE', 752, 'Sweden', '23', 'Vasterbottens Lan'),
('SE', 752, 'Sweden', '24', 'Vasternorrlands Lan'),
('SE', 752, 'Sweden', '25', 'Vastmanlands Lan'),
('SE', 752, 'Sweden', '26', 'Stockholms Lan'),
('SE', 752, 'Sweden', '27', 'Skane Lan'),
('SE', 752, 'Sweden', '28', 'Vastra Gotaland'),
('SG', 702, 'Singapore', '00', 'Singapore'),
('SH', 654, 'Saint Helena, Ascension and Tristan Da Cunha', '01', 'Ascension'),
('SH', 654, 'Saint Helena, Ascension and Tristan Da Cunha', '02', 'Saint Helena'),
('SH', 654, 'Saint Helena, Ascension and Tristan Da Cunha', '03', 'Tristan da Cunha'),
('SI', 705, 'Slovenia', '01', 'Ajdovscina'),
('SI', 705, 'Slovenia', '03', 'Bled'),
('SI', 705, 'Slovenia', '04', 'Bohinj'),
('SI', 705, 'Slovenia', '05', 'Borovnica'),
('SI', 705, 'Slovenia', '06', 'Bovec'),
('SI', 705, 'Slovenia', '08', 'Brezice'),
('SI', 705, 'Slovenia', '09', 'Brezovica'),
('SI', 705, 'Slovenia', '11', 'Celje'),
('SI', 705, 'Slovenia', '13', 'Cerknica'),
('SI', 705, 'Slovenia', '14', 'Cerkno'),
('SI', 705, 'Slovenia', '15', 'Crensovci'),
('SI', 705, 'Slovenia', '17', 'Crnomelj'),
('SI', 705, 'Slovenia', '19', 'Divaca'),
('SI', 705, 'Slovenia', '25', 'Dravograd'),
('SI', 705, 'Slovenia', '29', 'Gornja Radgona'),
('SI', 705, 'Slovenia', '32', 'Grosuplje'),
('SI', 705, 'Slovenia', '34', 'Hrastnik'),
('SI', 705, 'Slovenia', '36', 'Idrija'),
('SI', 705, 'Slovenia', '37', 'Ig'),
('SI', 705, 'Slovenia', '38', 'Ilirska Bistrica'),
('SI', 705, 'Slovenia', '39', 'Ivancna Gorica'),
('SI', 705, 'Slovenia', '40', 'Izola-Isola'),
('SI', 705, 'Slovenia', '44', 'Kanal'),
('SI', 705, 'Slovenia', '45', 'Kidricevo'),
('SI', 705, 'Slovenia', '46', 'Kobarid'),
('SI', 705, 'Slovenia', '50', 'Koper-Capodistria'),
('SI', 705, 'Slovenia', '52', 'Kranj'),
('SI', 705, 'Slovenia', '53', 'Kranjska Gora'),
('SI', 705, 'Slovenia', '54', 'Krsko'),
('SI', 705, 'Slovenia', '57', 'Lasko'),
('SI', 705, 'Slovenia', '61', 'Ljubljana'),
('SI', 705, 'Slovenia', '64', 'Logatec'),
('SI', 705, 'Slovenia', '71', 'Medvode'),
('SI', 705, 'Slovenia', '72', 'Menges'),
('SI', 705, 'Slovenia', '73', 'Metlika'),
('SI', 705, 'Slovenia', '74', 'Mezica'),
('SI', 705, 'Slovenia', '76', 'Mislinja'),
('SI', 705, 'Slovenia', '79', 'Mozirje'),
('SI', 705, 'Slovenia', '80', 'Murska Sobota'),
('SI', 705, 'Slovenia', '81', 'Muta'),
('SI', 705, 'Slovenia', '84', 'Nova Gorica'),
('SI', 705, 'Slovenia', '86', 'Odranci'),
('SI', 705, 'Slovenia', '87', 'Ormoz'),
('SI', 705, 'Slovenia', '91', 'Pivka'),
('SI', 705, 'Slovenia', '94', 'Postojna'),
('SI', 705, 'Slovenia', '98', 'Racam'),
('SI', 705, 'Slovenia', '99', 'Radece'),
('SI', 705, 'Slovenia', 'A1', 'Radenci'),
('SI', 705, 'Slovenia', 'A2', 'Radlje ob Dravi'),
('SI', 705, 'Slovenia', 'A3', 'Radovljica'),
('SI', 705, 'Slovenia', 'A7', 'Rogaska Slatina'),
('SI', 705, 'Slovenia', 'B2', 'Sencur'),
('SI', 705, 'Slovenia', 'B3', 'Sentilj'),
('SI', 705, 'Slovenia', 'B6', 'Sevnica'),
('SI', 705, 'Slovenia', 'B7', 'Sezana'),
('SI', 705, 'Slovenia', 'B9', 'Skofja Loka'),
('SI', 705, 'Slovenia', 'C1', 'Skofljica'),
('SI', 705, 'Slovenia', 'C2', 'Slovenj Gradec'),
('SI', 705, 'Slovenia', 'C4', 'Slovenske Konjice'),
('SI', 705, 'Slovenia', 'C7', 'Sostanj'),
('SI', 705, 'Slovenia', 'C9', 'Store'),
('SI', 705, 'Slovenia', 'D2', 'Tolmin'),
('SI', 705, 'Slovenia', 'D3', 'Trbovlje'),
('SI', 705, 'Slovenia', 'D4', 'Trebnje'),
('SI', 705, 'Slovenia', 'D5', 'Trzic'),
('SI', 705, 'Slovenia', 'D6', 'Turnisce'),
('SI', 705, 'Slovenia', 'D7', 'Velenje'),
('SI', 705, 'Slovenia', 'E1', 'Vipava'),
('SI', 705, 'Slovenia', 'E3', 'Vodice'),
('SI', 705, 'Slovenia', 'E5', 'Vrhnika'),
('SI', 705, 'Slovenia', 'E6', 'Vuzenica'),
('SI', 705, 'Slovenia', 'E7', 'Zagorje ob Savi'),
('SI', 705, 'Slovenia', 'F1', 'Zelezniki'),
('SI', 705, 'Slovenia', 'F2', 'Ziri'),
('SI', 705, 'Slovenia', 'F3', 'Zrece'),
('SI', 705, 'Slovenia', 'G1', 'Destrnik'),
('SI', 705, 'Slovenia', 'G7', 'Domzale'),
('SI', 705, 'Slovenia', 'H1', 'Hoce-Slivnica'),
('SI', 705, 'Slovenia', 'H3', 'Horjul'),
('SI', 705, 'Slovenia', 'H4', 'Jesenice'),
('SI', 705, 'Slovenia', 'H6', 'Kamnik'),
('SI', 705, 'Slovenia', 'H7', 'Kocevje'),
('SI', 705, 'Slovenia', 'I3', 'Lenart'),
('SI', 705, 'Slovenia', 'I4', 'Lendava'),
('SI', 705, 'Slovenia', 'I5', 'Litija'),
('SI', 705, 'Slovenia', 'I6', 'Ljutomer'),
('SI', 705, 'Slovenia', 'I8', 'Lovrenc na Pohorju'),
('SI', 705, 'Slovenia', 'J2', 'Maribor'),
('SI', 705, 'Slovenia', 'J4', 'Miklavz na Dravskem Polju'),
('SI', 705, 'Slovenia', 'J5', 'Miren-Kostanjevica'),
('SI', 705, 'Slovenia', 'J7', 'Novo Mesto'),
('SI', 705, 'Slovenia', 'J8', 'Oplotnica'),
('SI', 705, 'Slovenia', 'J9', 'Piran'),
('SI', 705, 'Slovenia', 'K3', 'Polzela'),
('SI', 705, 'Slovenia', 'K4', 'Prebold'),
('SI', 705, 'Slovenia', 'K6', 'Prevalje'),
('SI', 705, 'Slovenia', 'K7', 'Ptuj'),
('SI', 705, 'Slovenia', 'K8', 'Ravne na Koroskem'),
('SI', 705, 'Slovenia', 'L1', 'Ribnica'),
('SI', 705, 'Slovenia', 'L3', 'Ruse'),
('SI', 705, 'Slovenia', 'L6', 'Sempeter-Vrtojba'),
('SI', 705, 'Slovenia', 'L7', 'Sentjur pri Celju'),
('SI', 705, 'Slovenia', 'L8', 'Slovenska Bistrica'),
('SI', 705, 'Slovenia', 'M8', 'Trzin'),
('SI', 705, 'Slovenia', 'N3', 'Vojnik'),
('SI', 705, 'Slovenia', 'N5', 'Zalec'),
('SI', 705, 'Slovenia', 'N8', 'Zuzemberk'),
('SI', 705, 'Slovenia', 'O4', 'Log-Dragomer'),
('SI', 705, 'Slovenia', 'O8', 'Poljcane'),
('SI', 705, 'Slovenia', 'P5', 'Straza'),
('SJ', 744, 'Svalbard and Jan Mayen', '21', 'Svalbard and Jan Mayen'),
('SJ', 744, 'Svalbard and Jan Mayen', '22', 'Svalbard and Jan Mayen'),
('SK', 703, 'Slovakia', '01', 'Banskobystricky kraj'),
('SK', 703, 'Slovakia', '02', 'Bratislavsky kraj'),
('SK', 703, 'Slovakia', '03', 'Kosicky kraj'),
('SK', 703, 'Slovakia', '04', 'Nitriansky kraj'),
('SK', 703, 'Slovakia', '05', 'Presovsky kraj'),
('SK', 703, 'Slovakia', '06', 'Trenciansky kraj'),
('SK', 703, 'Slovakia', '07', 'Trnavsky kraj'),
('SK', 703, 'Slovakia', '08', 'Zilinsky kraj'),
('SL', 694, 'Sierra Leone', '01', 'Eastern'),
('SL', 694, 'Sierra Leone', '02', 'Northern'),
('SL', 694, 'Sierra Leone', '03', 'Southern'),
('SL', 694, 'Sierra Leone', '04', 'Western Area'),
('SM', 674, 'San Marino', '01', 'Acquaviva'),
('SM', 674, 'San Marino', '02', 'Chiesanuova'),
('SM', 674, 'San Marino', '07', 'San Marino'),
('SM', 674, 'San Marino', '09', 'Serravalle'),
('SN', 686, 'Senegal', '01', 'Dakar'),
('SN', 686, 'Senegal', '03', 'Diourbel'),
('SN', 686, 'Senegal', '05', 'Tambacounda'),
('SN', 686, 'Senegal', '07', 'Thies'),
('SN', 686, 'Senegal', '09', 'Fatick'),
('SN', 686, 'Senegal', '10', 'Kaolack'),
('SN', 686, 'Senegal', '11', 'Kolda'),
('SN', 686, 'Senegal', '12', 'Ziguinchor'),
('SN', 686, 'Senegal', '13', 'Louga'),
('SN', 686, 'Senegal', '14', 'Saint-Louis'),
('SN', 686, 'Senegal', '15', 'Matam'),
('SN', 686, 'Senegal', '16', 'Kaffrine'),
('SN', 686, 'Senegal', '17', 'Kedougou'),
('SN', 686, 'Senegal', '18', 'Sedhiou'),
('SO', 706, 'Somalia', '01', 'Bakool'),
('SO', 706, 'Somalia', '02', 'Banaadir'),
('SO', 706, 'Somalia', '03', 'Bari'),
('SO', 706, 'Somalia', '04', 'Bay'),
('SO', 706, 'Somalia', '05', 'Galguduud'),
('SO', 706, 'Somalia', '06', 'Gedo'),
('SO', 706, 'Somalia', '07', 'Hiiraan'),
('SO', 706, 'Somalia', '08', 'Jubbada Dhexe'),
('SO', 706, 'Somalia', '09', 'Jubbada Hoose'),
('SO', 706, 'Somalia', '10', 'Mudug'),
('SO', 706, 'Somalia', '12', 'Sanaag'),
('SO', 706, 'Somalia', '13', 'Shabeellaha Dhexe'),
('SO', 706, 'Somalia', '14', 'Shabeellaha Hoose'),
('SO', 706, 'Somalia', '18', 'Nugaal'),
('SO', 706, 'Somalia', '19', 'Togdheer'),
('SO', 706, 'Somalia', '20', 'Woqooyi Galbeed'),
('SO', 706, 'Somalia', '21', 'Awdal'),
('SO', 706, 'Somalia', '22', 'Sool'),
('SR', 740, 'Suriname', '10', 'Brokopondo'),
('SR', 740, 'Suriname', '11', 'Commewijne'),
('SR', 740, 'Suriname', '12', 'Coronie'),
('SR', 740, 'Suriname', '13', 'Marowijne'),
('SR', 740, 'Suriname', '14', 'Nickerie'),
('SR', 740, 'Suriname', '15', 'Para'),
('SR', 740, 'Suriname', '16', 'Paramaribo'),
('SR', 740, 'Suriname', '17', 'Saramacca'),
('SR', 740, 'Suriname', '19', 'Wanica'),
('SS', 728, 'South Sudan', '01', 'Central Equatoria'),
('SS', 728, 'South Sudan', '02', 'Eastern Equatoria'),
('SS', 728, 'South Sudan', '03', 'Jonglei'),
('SS', 728, 'South Sudan', '04', 'Lakes'),
('SS', 728, 'South Sudan', '05', 'Northern Bahr el Ghazal'),
('SS', 728, 'South Sudan', '06', 'Unity'),
('SS', 728, 'South Sudan', '07', 'Upper Nile'),
('SS', 728, 'South Sudan', '08', 'Warrap'),
('SS', 728, 'South Sudan', '09', 'Western Bahr el Ghazal'),
('SS', 728, 'South Sudan', '10', 'Western Equatoria'),
('ST', 678, 'Sao Tome and Principe', '01', 'Principe'),
('ST', 678, 'Sao Tome and Principe', '02', 'Sao Tome'),
('SV', 222, 'El Salvador', '01', 'Ahuachapan'),
('SV', 222, 'El Salvador', '02', 'Cabanas'),
('SV', 222, 'El Salvador', '03', 'Chalatenango'),
('SV', 222, 'El Salvador', '04', 'Cuscatlan'),
('SV', 222, 'El Salvador', '05', 'La Libertad'),
('SV', 222, 'El Salvador', '06', 'La Paz'),
('SV', 222, 'El Salvador', '07', 'La Union'),
('SV', 222, 'El Salvador', '08', 'Morazan'),
('SV', 222, 'El Salvador', '09', 'San Miguel'),
('SV', 222, 'El Salvador', '10', 'San Salvador'),
('SV', 222, 'El Salvador', '11', 'Santa Ana'),
('SV', 222, 'El Salvador', '12', 'San Vicente'),
('SV', 222, 'El Salvador', '13', 'Sonsonate'),
('SV', 222, 'El Salvador', '14', 'Usulutan'),
('SX', 534, 'Sint Maarten (Dutch Part)', '00', 'Sint Maarten'),
('SY', 760, 'Syrian Arab Republic', '01', 'Al Hasakah'),
('SY', 760, 'Syrian Arab Republic', '02', 'Al Ladhiqiyah'),
('SY', 760, 'Syrian Arab Republic', '03', 'Al Qunaytirah'),
('SY', 760, 'Syrian Arab Republic', '04', 'Ar Raqqah'),
('SY', 760, 'Syrian Arab Republic', '05', 'As Suwayda'''),
('SY', 760, 'Syrian Arab Republic', '06', 'Dar''a'),
('SY', 760, 'Syrian Arab Republic', '07', 'Dayr az Zawr'),
('SY', 760, 'Syrian Arab Republic', '08', 'Rif Dimashq'),
('SY', 760, 'Syrian Arab Republic', '09', 'Halab'),
('SY', 760, 'Syrian Arab Republic', '10', 'Hamah'),
('SY', 760, 'Syrian Arab Republic', '11', 'Hims'),
('SY', 760, 'Syrian Arab Republic', '12', 'Idlib'),
('SY', 760, 'Syrian Arab Republic', '13', 'Dimashq'),
('SY', 760, 'Syrian Arab Republic', '14', 'Tartus'),
('SZ', 748, 'Swaziland', '01', 'Hhohho'),
('SZ', 748, 'Swaziland', '02', 'Lubombo'),
('SZ', 748, 'Swaziland', '03', 'Manzini'),
('SZ', 748, 'Swaziland', '04', 'Shiselweni'),
('TC', 796, 'Turks and Caicos Islands', '00', 'Turks and Caicos Islands'),
('TD', 148, 'Chad', '01', 'Batha'),
('TD', 148, 'Chad', '02', 'Wadi Fira'),
('TD', 148, 'Chad', '05', 'Guera'),
('TD', 148, 'Chad', '06', 'Kanem'),
('TD', 148, 'Chad', '07', 'Lac'),
('TD', 148, 'Chad', '08', 'Logone-Occidental'),
('TD', 148, 'Chad', '09', 'Logone-Oriental'),
('TD', 148, 'Chad', '12', 'Ouaddai'),
('TD', 148, 'Chad', '13', 'Salamat'),
('TD', 148, 'Chad', '14', 'Tandjile'),
('TD', 148, 'Chad', '15', 'Chari-Baguirmi'),
('TD', 148, 'Chad', '16', 'Mayo-Kebbi-Est'),
('TD', 148, 'Chad', '17', 'Moyen-Chari'),
('TD', 148, 'Chad', '18', 'Hadjer Lamis'),
('TD', 148, 'Chad', '19', 'Mandoul'),
('TD', 148, 'Chad', '20', 'Mayo-Kebbi-Ouest'),
('TD', 148, 'Chad', '22', 'Bahr el Gazel'),
('TD', 148, 'Chad', '23', 'Borkou'),
('TD', 148, 'Chad', '26', 'Tibesti'),
('TF', 260, 'French Southern Territories', '03', 'French Southern and Antarctic Lands'),
('TG', 768, 'Togo', '22', 'Centre'),
('TG', 768, 'Togo', '23', 'Kara'),
('TG', 768, 'Togo', '24', 'Maritime'),
('TG', 768, 'Togo', '25', 'Plateaux'),
('TG', 768, 'Togo', '26', 'Savannes'),
('TH', 764, 'Thailand', '01', 'Mae Hong Son'),
('TH', 764, 'Thailand', '02', 'Chiang Mai'),
('TH', 764, 'Thailand', '03', 'Chiang Rai'),
('TH', 764, 'Thailand', '04', 'Nan'),
('TH', 764, 'Thailand', '05', 'Lamphun'),
('TH', 764, 'Thailand', '06', 'Lampang'),
('TH', 764, 'Thailand', '07', 'Phrae'),
('TH', 764, 'Thailand', '08', 'Tak'),
('TH', 764, 'Thailand', '09', 'Sukhothai'),
('TH', 764, 'Thailand', '10', 'Uttaradit'),
('TH', 764, 'Thailand', '11', 'Kamphaeng Phet'),
('TH', 764, 'Thailand', '12', 'Phitsanulok'),
('TH', 764, 'Thailand', '13', 'Phichit'),
('TH', 764, 'Thailand', '14', 'Phetchabun'),
('TH', 764, 'Thailand', '15', 'Uthai Thani'),
('TH', 764, 'Thailand', '16', 'Nakhon Sawan'),
('TH', 764, 'Thailand', '17', 'Nong Khai'),
('TH', 764, 'Thailand', '18', 'Loei'),
('TH', 764, 'Thailand', '20', 'Sakon Nakhon'),
('TH', 764, 'Thailand', '22', 'Khon Kaen'),
('TH', 764, 'Thailand', '23', 'Kalasin'),
('TH', 764, 'Thailand', '24', 'Maha Sarakham'),
('TH', 764, 'Thailand', '25', 'Roi Et'),
('TH', 764, 'Thailand', '26', 'Chaiyaphum'),
('TH', 764, 'Thailand', '27', 'Nakhon Ratchasima'),
('TH', 764, 'Thailand', '28', 'Buri Ram'),
('TH', 764, 'Thailand', '29', 'Surin'),
('TH', 764, 'Thailand', '30', 'Si Sa Ket'),
('TH', 764, 'Thailand', '31', 'Narathiwat'),
('TH', 764, 'Thailand', '32', 'Chai Nat'),
('TH', 764, 'Thailand', '33', 'Sing Buri'),
('TH', 764, 'Thailand', '34', 'Lop Buri'),
('TH', 764, 'Thailand', '35', 'Ang Thong'),
('TH', 764, 'Thailand', '36', 'Phra Nakhon Si Ayutthaya'),
('TH', 764, 'Thailand', '37', 'Saraburi'),
('TH', 764, 'Thailand', '38', 'Nonthaburi'),
('TH', 764, 'Thailand', '39', 'Pathum Thani'),
('TH', 764, 'Thailand', '40', 'Krung Thep Maha Nakhon'),
('TH', 764, 'Thailand', '41', 'Phayao'),
('TH', 764, 'Thailand', '42', 'Samut Prakan'),
('TH', 764, 'Thailand', '43', 'Nakhon Nayok'),
('TH', 764, 'Thailand', '44', 'Chachoengsao'),
('TH', 764, 'Thailand', '46', 'Chon Buri'),
('TH', 764, 'Thailand', '47', 'Rayong'),
('TH', 764, 'Thailand', '48', 'Chanthaburi'),
('TH', 764, 'Thailand', '49', 'Trat'),
('TH', 764, 'Thailand', '50', 'Kanchanaburi'),
('TH', 764, 'Thailand', '51', 'Suphan Buri'),
('TH', 764, 'Thailand', '52', 'Ratchaburi'),
('TH', 764, 'Thailand', '53', 'Nakhon Pathom'),
('TH', 764, 'Thailand', '54', 'Samut Songkhram'),
('TH', 764, 'Thailand', '55', 'Samut Sakhon'),
('TH', 764, 'Thailand', '56', 'Phetchaburi'),
('TH', 764, 'Thailand', '57', 'Prachuap Khiri Khan'),
('TH', 764, 'Thailand', '58', 'Chumphon'),
('TH', 764, 'Thailand', '59', 'Ranong'),
('TH', 764, 'Thailand', '60', 'Surat Thani'),
('TH', 764, 'Thailand', '61', 'Phangnga'),
('TH', 764, 'Thailand', '62', 'Phuket'),
('TH', 764, 'Thailand', '63', 'Krabi'),
('TH', 764, 'Thailand', '64', 'Nakhon Si Thammarat'),
('TH', 764, 'Thailand', '65', 'Trang'),
('TH', 764, 'Thailand', '66', 'Phatthalung'),
('TH', 764, 'Thailand', '67', 'Satun'),
('TH', 764, 'Thailand', '68', 'Songkhla'),
('TH', 764, 'Thailand', '69', 'Pattani'),
('TH', 764, 'Thailand', '70', 'Yala'),
('TH', 764, 'Thailand', '72', 'Yasothon'),
('TH', 764, 'Thailand', '73', 'Nakhon Phanom'),
('TH', 764, 'Thailand', '74', 'Prachin Buri'),
('TH', 764, 'Thailand', '75', 'Ubon Ratchathani'),
('TH', 764, 'Thailand', '76', 'Udon Thani'),
('TH', 764, 'Thailand', '77', 'Amnat Charoen'),
('TH', 764, 'Thailand', '78', 'Mukdahan'),
('TH', 764, 'Thailand', '79', 'Nong Bua Lam Phu'),
('TH', 764, 'Thailand', '80', 'Sa Kaeo'),
('TJ', 762, 'Tajikistan', '00', 'Regions of Republican Subordination'),
('TJ', 762, 'Tajikistan', '01', 'Kuhistoni Badakhshon'),
('TJ', 762, 'Tajikistan', '02', 'Khatlon'),
('TJ', 762, 'Tajikistan', '03', 'Sughd'),
('TJ', 762, 'Tajikistan', '7280679', 'Tajikistan'),
('TK', 772, 'Tokelau', 'A', 'Tokelau'),
('TK', 772, 'Tokelau', 'F', 'Tokelau'),
('TL', 626, 'Timor-Leste', 'DI', 'Dili'),
('TM', 795, 'Turkmenistan', '01', 'Ahal'),
('TM', 795, 'Turkmenistan', '02', 'Balkan'),
('TM', 795, 'Turkmenistan', '03', 'Dashoguz'),
('TM', 795, 'Turkmenistan', '04', 'Lebap'),
('TM', 795, 'Turkmenistan', '05', 'Mary'),
('TN', 788, 'Tunisia', '02', 'Kasserine'),
('TN', 788, 'Tunisia', '03', 'Kairouan'),
('TN', 788, 'Tunisia', '06', 'Jendouba'),
('TN', 788, 'Tunisia', '14', 'El Kef'),
('TN', 788, 'Tunisia', '15', 'Al Mahdia'),
('TN', 788, 'Tunisia', '16', 'Al Munastir'),
('TN', 788, 'Tunisia', '17', 'Bajah'),
('TN', 788, 'Tunisia', '18', 'Bizerte'),
('TN', 788, 'Tunisia', '19', 'Nabeul'),
('TN', 788, 'Tunisia', '22', 'Siliana'),
('TN', 788, 'Tunisia', '23', 'Sousse'),
('TN', 788, 'Tunisia', '27', 'Ben Arous'),
('TN', 788, 'Tunisia', '28', 'Madanin'),
('TN', 788, 'Tunisia', '29', 'Gabes'),
('TN', 788, 'Tunisia', '30', 'Gafsa'),
('TN', 788, 'Tunisia', '31', 'Kebili'),
('TN', 788, 'Tunisia', '32', 'Sfax'),
('TN', 788, 'Tunisia', '33', 'Sidi Bou Zid'),
('TN', 788, 'Tunisia', '34', 'Tataouine'),
('TN', 788, 'Tunisia', '35', 'Tozeur'),
('TN', 788, 'Tunisia', '36', 'Tunis'),
('TN', 788, 'Tunisia', '37', 'Zaghouan'),
('TN', 788, 'Tunisia', '38', 'Aiana'),
('TN', 788, 'Tunisia', '39', 'Manouba'),
('TO', 776, 'Tonga', '01', 'Ha''apai'),
('TO', 776, 'Tonga', '02', 'Tongatapu'),
('TO', 776, 'Tonga', '03', 'Vava''u'),
('TR', 792, 'Turkey', '02', 'Adiyaman'),
('TR', 792, 'Turkey', '03', 'Afyonkarahisar'),
('TR', 792, 'Turkey', '04', 'Agri'),
('TR', 792, 'Turkey', '05', 'Amasya'),
('TR', 792, 'Turkey', '07', 'Antalya'),
('TR', 792, 'Turkey', '08', 'Artvin'),
('TR', 792, 'Turkey', '09', 'Aydin'),
('TR', 792, 'Turkey', '10', 'Balikesir'),
('TR', 792, 'Turkey', '11', 'Bilecik'),
('TR', 792, 'Turkey', '12', 'Bingol'),
('TR', 792, 'Turkey', '13', 'Bitlis'),
('TR', 792, 'Turkey', '14', 'Bolu'),
('TR', 792, 'Turkey', '15', 'Burdur'),
('TR', 792, 'Turkey', '16', 'Bursa'),
('TR', 792, 'Turkey', '17', 'Canakkale'),
('TR', 792, 'Turkey', '19', 'Corum'),
('TR', 792, 'Turkey', '20', 'Denizli'),
('TR', 792, 'Turkey', '21', 'Diyarbakir'),
('TR', 792, 'Turkey', '22', 'Edirne'),
('TR', 792, 'Turkey', '23', 'Elazig'),
('TR', 792, 'Turkey', '24', 'Erzincan'),
('TR', 792, 'Turkey', '25', 'Erzurum'),
('TR', 792, 'Turkey', '26', 'Eskisehir'),
('TR', 792, 'Turkey', '28', 'Giresun'),
('TR', 792, 'Turkey', '31', 'Hatay'),
('TR', 792, 'Turkey', '32', 'Mersin'),
('TR', 792, 'Turkey', '33', 'Isparta'),
('TR', 792, 'Turkey', '34', 'Istanbul'),
('TR', 792, 'Turkey', '35', 'Izmir'),
('TR', 792, 'Turkey', '37', 'Kastamonu'),
('TR', 792, 'Turkey', '38', 'Kayseri'),
('TR', 792, 'Turkey', '39', 'Kirklareli'),
('TR', 792, 'Turkey', '40', 'Kirsehir'),
('TR', 792, 'Turkey', '41', 'Kocaeli'),
('TR', 792, 'Turkey', '43', 'Kutahya'),
('TR', 792, 'Turkey', '44', 'Malatya'),
('TR', 792, 'Turkey', '45', 'Manisa'),
('TR', 792, 'Turkey', '46', 'Kahramanmaras'),
('TR', 792, 'Turkey', '48', 'Mugla'),
('TR', 792, 'Turkey', '49', 'Mus'),
('TR', 792, 'Turkey', '50', 'Nevsehir'),
('TR', 792, 'Turkey', '52', 'Ordu'),
('TR', 792, 'Turkey', '53', 'Rize'),
('TR', 792, 'Turkey', '54', 'Sakarya'),
('TR', 792, 'Turkey', '55', 'Samsun'),
('TR', 792, 'Turkey', '57', 'Sinop'),
('TR', 792, 'Turkey', '58', 'Sivas'),
('TR', 792, 'Turkey', '59', 'Tekirdag'),
('TR', 792, 'Turkey', '60', 'Tokat'),
('TR', 792, 'Turkey', '61', 'Trabzon'),
('TR', 792, 'Turkey', '62', 'Tunceli'),
('TR', 792, 'Turkey', '63', 'Sanliurfa'),
('TR', 792, 'Turkey', '64', 'Usak'),
('TR', 792, 'Turkey', '65', 'Van'),
('TR', 792, 'Turkey', '66', 'Yozgat'),
('TR', 792, 'Turkey', '68', 'Ankara'),
('TR', 792, 'Turkey', '69', 'Gumushane'),
('TR', 792, 'Turkey', '70', 'Hakkari'),
('TR', 792, 'Turkey', '71', 'Konya'),
('TR', 792, 'Turkey', '72', 'Mardin'),
('TR', 792, 'Turkey', '73', 'Nigde'),
('TR', 792, 'Turkey', '74', 'Siirt'),
('TR', 792, 'Turkey', '75', 'Aksaray'),
('TR', 792, 'Turkey', '76', 'Batman'),
('TR', 792, 'Turkey', '77', 'Bayburt'),
('TR', 792, 'Turkey', '78', 'Karaman'),
('TR', 792, 'Turkey', '79', 'Kirikkale'),
('TR', 792, 'Turkey', '80', 'Sirnak'),
('TR', 792, 'Turkey', '81', 'Adana'),
('TR', 792, 'Turkey', '82', 'Cankiri'),
('TR', 792, 'Turkey', '83', 'Gaziantep'),
('TR', 792, 'Turkey', '84', 'Kars'),
('TR', 792, 'Turkey', '85', 'Zonguldak'),
('TR', 792, 'Turkey', '86', 'Ardahan'),
('TR', 792, 'Turkey', '87', 'Bartin'),
('TR', 792, 'Turkey', '88', 'Igdir'),
('TR', 792, 'Turkey', '89', 'Karabuk'),
('TR', 792, 'Turkey', '90', 'Kilis'),
('TR', 792, 'Turkey', '91', 'Osmaniye'),
('TR', 792, 'Turkey', '92', 'Yalova'),
('TR', 792, 'Turkey', '93', 'Duzce'),
('TT', 780, 'Trinidad and Tobago', '01', 'Arima'),
('TT', 780, 'Trinidad and Tobago', '02', 'Caroni'),
('TT', 780, 'Trinidad and Tobago', '03', 'Mayaro'),
('TT', 780, 'Trinidad and Tobago', '05', 'Port-of-Spain'),
('TT', 780, 'Trinidad and Tobago', '06', 'Saint Andrew'),
('TT', 780, 'Trinidad and Tobago', '08', 'Saint George'),
('TT', 780, 'Trinidad and Tobago', '10', 'San Fernando'),
('TT', 780, 'Trinidad and Tobago', '11', 'Tobago'),
('TT', 780, 'Trinidad and Tobago', '12', 'Victoria'),
('TT', 780, 'Trinidad and Tobago', 'CHA', 'Trinidad and Tobago'),
('TT', 780, 'Trinidad and Tobago', 'CTT', 'Trinidad and Tobago'),
('TT', 780, 'Trinidad and Tobago', 'DMN', 'Trinidad and Tobago'),
('TT', 780, 'Trinidad and Tobago', 'ETO', 'Trinidad and Tobago'),
('TT', 780, 'Trinidad and Tobago', 'PED', 'Trinidad and Tobago'),
('TT', 780, 'Trinidad and Tobago', 'PRT', 'Trinidad and Tobago'),
('TT', 780, 'Trinidad and Tobago', 'PTF', 'Trinidad and Tobago'),
('TT', 780, 'Trinidad and Tobago', 'SGE', 'Trinidad and Tobago'),
('TT', 780, 'Trinidad and Tobago', 'SIP', 'Trinidad and Tobago'),
('TT', 780, 'Trinidad and Tobago', 'SJL', 'Trinidad and Tobago'),
('TT', 780, 'Trinidad and Tobago', 'TUP', 'Trinidad and Tobago'),
('TV', 798, 'Tuvalu', 'FUN', 'Tuvalu'),
('TW', 158, 'Taiwan, Province of China', '01', 'Fu-chien'),
('TW', 158, 'Taiwan, Province of China', '02', 'Kao-hsiung'),
('TW', 158, 'Taiwan, Province of China', '03', 'T''ai-pei'),
('TW', 158, 'Taiwan, Province of China', '04', 'T''ai-wan'),
('TZ', 834, 'Tanzania, United Republic of', '02', 'Pwani'),
('TZ', 834, 'Tanzania, United Republic of', '03', 'Dodoma'),
('TZ', 834, 'Tanzania, United Republic of', '04', 'Iringa'),
('TZ', 834, 'Tanzania, United Republic of', '05', 'Kigoma'),
('TZ', 834, 'Tanzania, United Republic of', '06', 'Kilimanjaro');
INSERT INTO `country_region` (`country_alpha2`, `country_numeric_code`, `country_name`, `code`, `name`) VALUES
('TZ', 834, 'Tanzania, United Republic of', '07', 'Lindi'),
('TZ', 834, 'Tanzania, United Republic of', '08', 'Mara'),
('TZ', 834, 'Tanzania, United Republic of', '09', 'Mbeya'),
('TZ', 834, 'Tanzania, United Republic of', '10', 'Morogoro'),
('TZ', 834, 'Tanzania, United Republic of', '11', 'Mtwara'),
('TZ', 834, 'Tanzania, United Republic of', '12', 'Mwanza'),
('TZ', 834, 'Tanzania, United Republic of', '13', 'Kaskazini Pemba'),
('TZ', 834, 'Tanzania, United Republic of', '14', 'Ruvuma'),
('TZ', 834, 'Tanzania, United Republic of', '15', 'Shinyanga'),
('TZ', 834, 'Tanzania, United Republic of', '16', 'Singida'),
('TZ', 834, 'Tanzania, United Republic of', '17', 'Tabora'),
('TZ', 834, 'Tanzania, United Republic of', '18', 'Tanga'),
('TZ', 834, 'Tanzania, United Republic of', '19', 'Kagera'),
('TZ', 834, 'Tanzania, United Republic of', '20', 'Kusini Pemba'),
('TZ', 834, 'Tanzania, United Republic of', '21', 'Kusini Unguja'),
('TZ', 834, 'Tanzania, United Republic of', '22', 'Kaskazini Unguja'),
('TZ', 834, 'Tanzania, United Republic of', '23', 'Dar es Salaam'),
('TZ', 834, 'Tanzania, United Republic of', '24', 'Rukwa'),
('TZ', 834, 'Tanzania, United Republic of', '25', 'Mjini Magharibi'),
('TZ', 834, 'Tanzania, United Republic of', '26', 'Arusha'),
('TZ', 834, 'Tanzania, United Republic of', '27', 'Manyara'),
('UA', 804, 'Ukraine', '01', 'Cherkas''ka Oblast'''),
('UA', 804, 'Ukraine', '02', 'Chernihivs''ka Oblast'''),
('UA', 804, 'Ukraine', '03', 'Chernivets''ka Oblast'''),
('UA', 804, 'Ukraine', '04', 'Dnipropetrovs''ka Oblast'''),
('UA', 804, 'Ukraine', '05', 'Donets''ka Oblast'''),
('UA', 804, 'Ukraine', '06', 'Ivano-Frankivs''ka Oblast'''),
('UA', 804, 'Ukraine', '07', 'Kharkivs''ka Oblast'''),
('UA', 804, 'Ukraine', '08', 'Khersons''ka Oblast'''),
('UA', 804, 'Ukraine', '09', 'Khmel''nyts''ka Oblast'''),
('UA', 804, 'Ukraine', '10', 'Kirovohrads''ka Oblast'''),
('UA', 804, 'Ukraine', '11', 'Avtonomna Respublika Krym'),
('UA', 804, 'Ukraine', '12', 'Kyiv'),
('UA', 804, 'Ukraine', '13', 'Kyivs''ka Oblast'''),
('UA', 804, 'Ukraine', '14', 'Luhans''ka Oblast'''),
('UA', 804, 'Ukraine', '15', 'L''vivs''ka Oblast'''),
('UA', 804, 'Ukraine', '16', 'Mykolaivs''ka Oblast'''),
('UA', 804, 'Ukraine', '17', 'Odes''ka Oblast'''),
('UA', 804, 'Ukraine', '18', 'Poltavs''ka Oblast'''),
('UA', 804, 'Ukraine', '19', 'Rivnens''ka Oblast'''),
('UA', 804, 'Ukraine', '20', 'Sevastopol'''),
('UA', 804, 'Ukraine', '21', 'Sums''ka Oblast'''),
('UA', 804, 'Ukraine', '22', 'Ternopil''s''ka Oblast'''),
('UA', 804, 'Ukraine', '23', 'Vinnyts''ka Oblast'''),
('UA', 804, 'Ukraine', '24', 'Volyns''ka Oblast'''),
('UA', 804, 'Ukraine', '25', 'Zakarpats''ka Oblast'''),
('UA', 804, 'Ukraine', '26', 'Zaporiz''ka Oblast'''),
('UA', 804, 'Ukraine', '27', 'Zhytomyrs''ka Oblast'''),
('UG', 800, 'Uganda', '18', 'Kampala'),
('UG', 800, 'Uganda', '26', 'Apac'),
('UG', 800, 'Uganda', '28', 'Bundibugyo'),
('UG', 800, 'Uganda', '29', 'Bushenyi'),
('UG', 800, 'Uganda', '30', 'Gulu'),
('UG', 800, 'Uganda', '31', 'Hoima'),
('UG', 800, 'Uganda', '33', 'Jinja'),
('UG', 800, 'Uganda', '34', 'Kabale'),
('UG', 800, 'Uganda', '36', 'Kalangala'),
('UG', 800, 'Uganda', '37', 'Kampala'),
('UG', 800, 'Uganda', '38', 'Kamuli'),
('UG', 800, 'Uganda', '39', 'Kapchorwa'),
('UG', 800, 'Uganda', '40', 'Kasese'),
('UG', 800, 'Uganda', '41', 'Kibaale'),
('UG', 800, 'Uganda', '42', 'Kiboga'),
('UG', 800, 'Uganda', '43', 'Kisoro'),
('UG', 800, 'Uganda', '45', 'Kotido'),
('UG', 800, 'Uganda', '46', 'Kumi'),
('UG', 800, 'Uganda', '47', 'Lira'),
('UG', 800, 'Uganda', '50', 'Masindi'),
('UG', 800, 'Uganda', '52', 'Mbarara'),
('UG', 800, 'Uganda', '56', 'Mubende'),
('UG', 800, 'Uganda', '58', 'Nebbi'),
('UG', 800, 'Uganda', '59', 'Ntungamo'),
('UG', 800, 'Uganda', '60', 'Pallisa'),
('UG', 800, 'Uganda', '61', 'Rakai'),
('UG', 800, 'Uganda', '65', 'Adjumani'),
('UG', 800, 'Uganda', '66', 'Bugiri'),
('UG', 800, 'Uganda', '67', 'Busia'),
('UG', 800, 'Uganda', '69', 'Katakwi'),
('UG', 800, 'Uganda', '70', 'Luwero'),
('UG', 800, 'Uganda', '71', 'Masaka'),
('UG', 800, 'Uganda', '72', 'Moyo'),
('UG', 800, 'Uganda', '73', 'Nakasongola'),
('UG', 800, 'Uganda', '74', 'Sembabule'),
('UG', 800, 'Uganda', '76', 'Tororo'),
('UG', 800, 'Uganda', '77', 'Arua'),
('UG', 800, 'Uganda', '78', 'Iganga'),
('UG', 800, 'Uganda', '79', 'Kabarole'),
('UG', 800, 'Uganda', '80', 'Kaberamaido'),
('UG', 800, 'Uganda', '81', 'Kamwenge'),
('UG', 800, 'Uganda', '82', 'Kanungu'),
('UG', 800, 'Uganda', '83', 'Kayunga'),
('UG', 800, 'Uganda', '84', 'Kitgum'),
('UG', 800, 'Uganda', '85', 'Kyenjojo'),
('UG', 800, 'Uganda', '86', 'Mayuge'),
('UG', 800, 'Uganda', '87', 'Mbale'),
('UG', 800, 'Uganda', '88', 'Moroto'),
('UG', 800, 'Uganda', '89', 'Mpigi'),
('UG', 800, 'Uganda', '90', 'Mukono'),
('UG', 800, 'Uganda', '91', 'Nakapiripirit'),
('UG', 800, 'Uganda', '92', 'Pader'),
('UG', 800, 'Uganda', '93', 'Rukungiri'),
('UG', 800, 'Uganda', '94', 'Sironko'),
('UG', 800, 'Uganda', '95', 'Soroti'),
('UG', 800, 'Uganda', '96', 'Wakiso'),
('UG', 800, 'Uganda', '97', 'Yumbe'),
('UG', 800, 'Uganda', 'B6', 'Abim'),
('UG', 800, 'Uganda', 'B7', 'Amolatar'),
('UG', 800, 'Uganda', 'B8', 'Amuria'),
('UG', 800, 'Uganda', 'B9', 'Amuru'),
('UG', 800, 'Uganda', 'C1', 'Budaka'),
('UG', 800, 'Uganda', 'C2', 'Bududa'),
('UG', 800, 'Uganda', 'C3', 'Bukedea'),
('UG', 800, 'Uganda', 'C4', 'Bukwa'),
('UG', 800, 'Uganda', 'C5', 'Buliisa'),
('UG', 800, 'Uganda', 'C6', 'Butaleja'),
('UG', 800, 'Uganda', 'C7', 'Dokolo'),
('UG', 800, 'Uganda', 'C9', 'Isingiro'),
('UG', 800, 'Uganda', 'D1', 'Kaabong'),
('UG', 800, 'Uganda', 'D2', 'Kaliro'),
('UG', 800, 'Uganda', 'D4', 'Koboko'),
('UG', 800, 'Uganda', 'D5', 'Lyantonde'),
('UG', 800, 'Uganda', 'D6', 'Manafwa'),
('UG', 800, 'Uganda', 'D7', 'Maracha'),
('UG', 800, 'Uganda', 'D8', 'Mityana'),
('UG', 800, 'Uganda', 'D9', 'Nakaseke'),
('UG', 800, 'Uganda', 'E1', 'Namutumba'),
('UG', 800, 'Uganda', 'E2', 'Oyam'),
('UG', 800, 'Uganda', 'E3', 'Agago'),
('UG', 800, 'Uganda', 'E4', 'Alebtong'),
('UG', 800, 'Uganda', 'E5', 'Amudat'),
('UG', 800, 'Uganda', 'E7', 'Buikwe'),
('UG', 800, 'Uganda', 'E8', 'Bukomansibi'),
('UG', 800, 'Uganda', 'E9', 'Bulambuli'),
('UG', 800, 'Uganda', 'F2', 'Buvuma'),
('UG', 800, 'Uganda', 'F3', 'Buyende'),
('UG', 800, 'Uganda', 'F4', 'Gomba'),
('UG', 800, 'Uganda', 'F6', 'Kibuku'),
('UG', 800, 'Uganda', 'F7', 'Kiryandongo'),
('UG', 800, 'Uganda', 'F8', 'Kole'),
('UG', 800, 'Uganda', 'F9', 'Kween'),
('UG', 800, 'Uganda', 'G1', 'Kyankwanzi'),
('UG', 800, 'Uganda', 'G2', 'Kyegegwa'),
('UG', 800, 'Uganda', 'G4', 'Luuka'),
('UG', 800, 'Uganda', 'G5', 'Lwengo'),
('UG', 800, 'Uganda', 'G6', 'Mitooma'),
('UG', 800, 'Uganda', 'G7', 'Namayingo'),
('UG', 800, 'Uganda', 'G8', 'Napak'),
('UG', 800, 'Uganda', 'G9', 'Ngora'),
('UG', 800, 'Uganda', 'H1', 'Ntoroko'),
('UG', 800, 'Uganda', 'H3', 'Otuke'),
('UG', 800, 'Uganda', 'H4', 'Rubirizi'),
('UG', 800, 'Uganda', 'H5', 'Serere'),
('UG', 800, 'Uganda', 'H6', 'Sheema'),
('UG', 800, 'Uganda', 'H7', 'Zombo'),
('UM', 581, 'United States Minor Outlying Islands', 'LQ', 'Palmyra Atoll'),
('US', 840, 'United States', '01', 'Alabama'),
('US', 840, 'United States', '02', 'Alaska'),
('US', 840, 'United States', '04', 'Arizona'),
('US', 840, 'United States', '05', 'Arkansas'),
('US', 840, 'United States', '06', 'California'),
('US', 840, 'United States', '08', 'Colorado'),
('US', 840, 'United States', '09', 'Connecticut'),
('US', 840, 'United States', '10', 'Delaware'),
('US', 840, 'United States', '12', 'Florida'),
('US', 840, 'United States', '13', 'Georgia'),
('US', 840, 'United States', '15', 'Hawaii'),
('US', 840, 'United States', '16', 'Idaho'),
('US', 840, 'United States', '17', 'Illinois'),
('US', 840, 'United States', '18', 'Indiana'),
('US', 840, 'United States', '19', 'Iowa'),
('US', 840, 'United States', '20', 'Kansas'),
('US', 840, 'United States', '21', 'Kentucky'),
('US', 840, 'United States', '22', 'Louisiana'),
('US', 840, 'United States', '23', 'Maine'),
('US', 840, 'United States', '24', 'Maryland'),
('US', 840, 'United States', '25', 'Massachusetts'),
('US', 840, 'United States', '26', 'Michigan'),
('US', 840, 'United States', '27', 'Minnesota'),
('US', 840, 'United States', '28', 'Mississippi'),
('US', 840, 'United States', '29', 'Missouri'),
('US', 840, 'United States', '30', 'Montana'),
('US', 840, 'United States', '31', 'Nebraska'),
('US', 840, 'United States', '32', 'Nevada'),
('US', 840, 'United States', '33', 'New Hampshire'),
('US', 840, 'United States', '34', 'New Jersey'),
('US', 840, 'United States', '35', 'New Mexico'),
('US', 840, 'United States', '36', 'New York'),
('US', 840, 'United States', '37', 'North Carolina'),
('US', 840, 'United States', '38', 'North Dakota'),
('US', 840, 'United States', '39', 'Ohio'),
('US', 840, 'United States', '40', 'Oklahoma'),
('US', 840, 'United States', '41', 'Oregon'),
('US', 840, 'United States', '42', 'Pennsylvania'),
('US', 840, 'United States', '44', 'Rhode Island'),
('US', 840, 'United States', '45', 'South Carolina'),
('US', 840, 'United States', '46', 'South Dakota'),
('US', 840, 'United States', '47', 'Tennessee'),
('US', 840, 'United States', '48', 'Texas'),
('US', 840, 'United States', '49', 'Utah'),
('US', 840, 'United States', '50', 'Vermont'),
('US', 840, 'United States', '51', 'Virginia'),
('US', 840, 'United States', '53', 'Washington'),
('US', 840, 'United States', '54', 'West Virginia'),
('US', 840, 'United States', '55', 'Wisconsin'),
('US', 840, 'United States', '56', 'Wyoming'),
('US', 840, 'United States', 'DC', 'District Of Columbia'),
('UY', 858, 'Uruguay', '01', 'Artigas'),
('UY', 858, 'Uruguay', '02', 'Canelones'),
('UY', 858, 'Uruguay', '03', 'Cerro Largo'),
('UY', 858, 'Uruguay', '04', 'Colonia'),
('UY', 858, 'Uruguay', '05', 'Durazno'),
('UY', 858, 'Uruguay', '06', 'Flores'),
('UY', 858, 'Uruguay', '07', 'Florida'),
('UY', 858, 'Uruguay', '08', 'Lavalleja'),
('UY', 858, 'Uruguay', '09', 'Maldonado'),
('UY', 858, 'Uruguay', '10', 'Montevideo'),
('UY', 858, 'Uruguay', '11', 'Paysandu'),
('UY', 858, 'Uruguay', '12', 'Rio Negro'),
('UY', 858, 'Uruguay', '13', 'Rivera'),
('UY', 858, 'Uruguay', '14', 'Rocha'),
('UY', 858, 'Uruguay', '15', 'Salto'),
('UY', 858, 'Uruguay', '16', 'San Jose'),
('UY', 858, 'Uruguay', '17', 'Soriano'),
('UY', 858, 'Uruguay', '18', 'Tacuarembo'),
('UY', 858, 'Uruguay', '19', 'Treinta y Tres'),
('UZ', 860, 'Uzbekistan', '01', 'Andijon'),
('UZ', 860, 'Uzbekistan', '02', 'Buxoro'),
('UZ', 860, 'Uzbekistan', '03', 'Farg''ona'),
('UZ', 860, 'Uzbekistan', '05', 'Xorazm'),
('UZ', 860, 'Uzbekistan', '06', 'Namangan'),
('UZ', 860, 'Uzbekistan', '07', 'Navoiy'),
('UZ', 860, 'Uzbekistan', '08', 'Qashqadaryo'),
('UZ', 860, 'Uzbekistan', '09', 'Qoraqalpog''iston Respublikasi'),
('UZ', 860, 'Uzbekistan', '10', 'Samarqand'),
('UZ', 860, 'Uzbekistan', '12', 'Surxondaryo'),
('UZ', 860, 'Uzbekistan', '13', 'Toshkent'),
('UZ', 860, 'Uzbekistan', '14', 'Toshkent'),
('UZ', 860, 'Uzbekistan', '15', 'Jizzax'),
('UZ', 860, 'Uzbekistan', '16', 'Sirdaryo'),
('VA', 336, 'Holy See', '00', 'Vatican City'),
('VC', 670, 'Saint Vincent and The Grenadines', '01', 'Charlotte'),
('VC', 670, 'Saint Vincent and The Grenadines', '04', 'Saint George'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '01', 'Amazonas'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '02', 'Anzoategui'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '03', 'Apure'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '04', 'Aragua'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '05', 'Barinas'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '06', 'Bolivar'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '07', 'Carabobo'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '08', 'Cojedes'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '09', 'Delta Amacuro'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '11', 'Falcon'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '12', 'Guarico'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '13', 'Lara'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '14', 'Merida'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '15', 'Miranda'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '16', 'Monagas'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '17', 'Nueva Esparta'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '18', 'Portuguesa'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '19', 'Sucre'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '20', 'Tachira'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '21', 'Trujillo'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '22', 'Yaracuy'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '23', 'Zulia'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '25', 'Distrito Federal'),
('VE', 862, 'Venezuela, Bolivarian Republic of', '26', 'Vargas'),
('VG', 92, 'Virgin Islands, British', '00', 'British Virgin Islands'),
('VI', 850, 'Virgin Islands, U.S.', '030', 'Virgin Islands'),
('VN', 704, 'Viet Nam', '01', 'An Giang'),
('VN', 704, 'Viet Nam', '03', 'Ben Tre'),
('VN', 704, 'Viet Nam', '05', 'Cao Bang'),
('VN', 704, 'Viet Nam', '09', 'Dong Thap'),
('VN', 704, 'Viet Nam', '13', 'Hai Phong'),
('VN', 704, 'Viet Nam', '20', 'Ho Chi Minh'),
('VN', 704, 'Viet Nam', '21', 'Kien Giang'),
('VN', 704, 'Viet Nam', '23', 'Lam Dong'),
('VN', 704, 'Viet Nam', '24', 'Long An'),
('VN', 704, 'Viet Nam', '30', 'Quang Ninh'),
('VN', 704, 'Viet Nam', '32', 'Son La'),
('VN', 704, 'Viet Nam', '33', 'Tay Ninh'),
('VN', 704, 'Viet Nam', '34', 'Thanh Hoa'),
('VN', 704, 'Viet Nam', '35', 'Thai Binh'),
('VN', 704, 'Viet Nam', '37', 'Tien Giang'),
('VN', 704, 'Viet Nam', '39', 'Lang Son'),
('VN', 704, 'Viet Nam', '43', 'Dong Nai'),
('VN', 704, 'Viet Nam', '44', 'Ha Noi'),
('VN', 704, 'Viet Nam', '46', 'Binh Dinh'),
('VN', 704, 'Viet Nam', '47', 'Binh Thuan'),
('VN', 704, 'Viet Nam', '49', 'Gia Lai'),
('VN', 704, 'Viet Nam', '50', 'Ha Giang'),
('VN', 704, 'Viet Nam', '52', 'Ha Tinh'),
('VN', 704, 'Viet Nam', '53', 'Hoa Binh'),
('VN', 704, 'Viet Nam', '54', 'Khanh Hoa'),
('VN', 704, 'Viet Nam', '58', 'Nghe An'),
('VN', 704, 'Viet Nam', '59', 'Ninh Binh'),
('VN', 704, 'Viet Nam', '60', 'Ninh Thuan'),
('VN', 704, 'Viet Nam', '61', 'Phu Yen'),
('VN', 704, 'Viet Nam', '62', 'Quang Binh'),
('VN', 704, 'Viet Nam', '63', 'Quang Ngai'),
('VN', 704, 'Viet Nam', '64', 'Quang Tri'),
('VN', 704, 'Viet Nam', '65', 'Soc Trang'),
('VN', 704, 'Viet Nam', '66', 'Thua Thien-Hue'),
('VN', 704, 'Viet Nam', '67', 'Tra Vinh'),
('VN', 704, 'Viet Nam', '68', 'Tuyen Quang'),
('VN', 704, 'Viet Nam', '69', 'Vinh Long'),
('VN', 704, 'Viet Nam', '70', 'Yen Bai'),
('VN', 704, 'Viet Nam', '71', 'Bac Giang'),
('VN', 704, 'Viet Nam', '72', 'Bac Kan'),
('VN', 704, 'Viet Nam', '73', 'Bac Lieu'),
('VN', 704, 'Viet Nam', '74', 'Bac Ninh'),
('VN', 704, 'Viet Nam', '75', 'Binh Duong'),
('VN', 704, 'Viet Nam', '76', 'Binh Phuoc'),
('VN', 704, 'Viet Nam', '77', 'Ca Mau'),
('VN', 704, 'Viet Nam', '78', 'Da Nang'),
('VN', 704, 'Viet Nam', '79', 'Hai Duong'),
('VN', 704, 'Viet Nam', '80', 'Ha Nam'),
('VN', 704, 'Viet Nam', '81', 'Hung Yen'),
('VN', 704, 'Viet Nam', '82', 'Nam Dinh'),
('VN', 704, 'Viet Nam', '83', 'Phu Tho'),
('VN', 704, 'Viet Nam', '84', 'Quang Nam'),
('VN', 704, 'Viet Nam', '85', 'Thai Nguyen'),
('VN', 704, 'Viet Nam', '86', 'Vinh Phuc'),
('VN', 704, 'Viet Nam', '87', 'Can Tho'),
('VN', 704, 'Viet Nam', '88', 'Dak Lak'),
('VN', 704, 'Viet Nam', '89', 'Lai Chau'),
('VN', 704, 'Viet Nam', '90', 'Lao Cai'),
('VN', 704, 'Viet Nam', '92', 'Dien Bien'),
('VU', 548, 'Vanuatu', '07', 'Torba'),
('VU', 548, 'Vanuatu', '13', 'Sanma'),
('VU', 548, 'Vanuatu', '15', 'Tafea'),
('VU', 548, 'Vanuatu', '16', 'Malampa'),
('VU', 548, 'Vanuatu', '18', 'Shefa'),
('WF', 876, 'Wallis and Futuna', '98613', 'Wallis and Futuna Islands'),
('WS', 882, 'Samoa', '01', 'A''ana'),
('WS', 882, 'Samoa', '03', 'Atua'),
('WS', 882, 'Samoa', '07', 'Gagaifomauga'),
('WS', 882, 'Samoa', '08', 'Palauli'),
('WS', 882, 'Samoa', '10', 'Tuamasaga'),
('YE', 887, 'Yemen', '01', 'Abyan'),
('YE', 887, 'Yemen', '02', '''Adan'),
('YE', 887, 'Yemen', '03', 'Al Mahrah'),
('YE', 887, 'Yemen', '04', 'Hadramawt'),
('YE', 887, 'Yemen', '05', 'Shabwah'),
('YE', 887, 'Yemen', '08', 'Al Hudaydah'),
('YE', 887, 'Yemen', '10', 'Al Mahwit'),
('YE', 887, 'Yemen', '11', 'Dhamar'),
('YE', 887, 'Yemen', '14', 'Ma''rib'),
('YE', 887, 'Yemen', '15', 'Sa''dah'),
('YE', 887, 'Yemen', '16', 'San''a'''),
('YE', 887, 'Yemen', '18', 'Ad Dali'),
('YE', 887, 'Yemen', '19', '''Amran'),
('YE', 887, 'Yemen', '20', 'Al Bayda'''),
('YE', 887, 'Yemen', '21', 'Al Jawf'),
('YE', 887, 'Yemen', '22', 'Hajjah'),
('YE', 887, 'Yemen', '23', 'Ibb'),
('YE', 887, 'Yemen', '24', 'Lahij'),
('YE', 887, 'Yemen', '25', 'Ta''izz'),
('YE', 887, 'Yemen', '26', 'Amanat al ''Asimah'),
('YE', 887, 'Yemen', '27', 'Raymah'),
('YT', 175, 'Mayotte', '97601', 'Acoua'),
('YT', 175, 'Mayotte', '97602', 'Bandraboua'),
('YT', 175, 'Mayotte', '97603', 'Bandrele'),
('YT', 175, 'Mayotte', '97604', 'Boueni'),
('YT', 175, 'Mayotte', '97605', 'Chiconi'),
('YT', 175, 'Mayotte', '97606', 'Chirongui'),
('YT', 175, 'Mayotte', '97608', 'Dzaoudzi'),
('YT', 175, 'Mayotte', '97609', 'Kani-Keli'),
('YT', 175, 'Mayotte', '97610', 'Koungou'),
('YT', 175, 'Mayotte', '97611', 'Mamoudzou'),
('YT', 175, 'Mayotte', '97612', 'Mtsamboro'),
('YT', 175, 'Mayotte', '97614', 'Ouangani'),
('YT', 175, 'Mayotte', '97615', 'Pamandzi'),
('YT', 175, 'Mayotte', '97616', 'Sada'),
('YT', 175, 'Mayotte', '97617', 'Tsingoni'),
('ZA', 710, 'South Africa', '02', 'KwaZulu-Natal'),
('ZA', 710, 'South Africa', '03', 'Free State'),
('ZA', 710, 'South Africa', '05', 'Eastern Cape'),
('ZA', 710, 'South Africa', '06', 'Gauteng'),
('ZA', 710, 'South Africa', '07', 'Mpumalanga'),
('ZA', 710, 'South Africa', '08', 'Northern Cape'),
('ZA', 710, 'South Africa', '09', 'Limpopo'),
('ZA', 710, 'South Africa', '10', 'North-West'),
('ZA', 710, 'South Africa', '11', 'Western Cape'),
('ZM', 894, 'Zambia', '01', 'Western'),
('ZM', 894, 'Zambia', '02', 'Central'),
('ZM', 894, 'Zambia', '03', 'Eastern'),
('ZM', 894, 'Zambia', '04', 'Luapula'),
('ZM', 894, 'Zambia', '05', 'Northern'),
('ZM', 894, 'Zambia', '06', 'North-Western'),
('ZM', 894, 'Zambia', '07', 'Southern'),
('ZM', 894, 'Zambia', '08', 'Copperbelt'),
('ZM', 894, 'Zambia', '09', 'Lusaka'),
('ZW', 716, 'Zimbabwe', '01', 'Manicaland'),
('ZW', 716, 'Zimbabwe', '02', 'Midlands'),
('ZW', 716, 'Zimbabwe', '03', 'Mashonaland Central'),
('ZW', 716, 'Zimbabwe', '04', 'Mashonaland East'),
('ZW', 716, 'Zimbabwe', '05', 'Mashonaland West'),
('ZW', 716, 'Zimbabwe', '06', 'Matabeleland North'),
('ZW', 716, 'Zimbabwe', '07', 'Matabeleland South'),
('ZW', 716, 'Zimbabwe', '08', 'Masvingo'),
('ZW', 716, 'Zimbabwe', '09', 'Bulawayo'),
('ZW', 716, 'Zimbabwe', '10', 'Harare');

-- --------------------------------------------------------

--
-- 表的结构 `media`
--

CREATE TABLE `media` (
  `id` int(11) NOT NULL,
  `campaign_id` int(11) NOT NULL,
  `relative_dir` varchar(255) NOT NULL DEFAULT '',
  `filename` varchar(512) NOT NULL,
  `status` enum('start','stop') NOT NULL DEFAULT 'start',
  `width` int(11) NOT NULL DEFAULT '0',
  `height` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- 表的结构 `my_traffic`
--

CREATE TABLE `my_traffic` (
  `campaign_id` int(11) NOT NULL,
  `platform_traffic_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `nurl_result`
--

CREATE TABLE `nurl_result` (
  `id` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `crtid` int(11) NOT NULL DEFAULT '0',
  `mid` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  `price` double NOT NULL,
  `admarkup` varchar(1024) NOT NULL DEFAULT '',
  `device_idfa` varchar(50) NOT NULL DEFAULT '',
  `device_ip` varchar(50) DEFAULT '',
  `exchange` varchar(255) NOT NULL DEFAULT '',
  `created` int(11) NOT NULL,
  `brl_uniqkey` char(32) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `platform`
--

CREATE TABLE `platform` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `platform_traffic`
--

CREATE TABLE `platform_traffic` (
  `id` int(11) NOT NULL,
  `platform_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `preset`
--

CREATE TABLE `preset` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `content` mediumtext NOT NULL,
  `created` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `third_creative`
--

CREATE TABLE `third_creative` (
  `id` int(11) NOT NULL,
  `campaign_id` int(11) NOT NULL,
  `width` int(11) NOT NULL DEFAULT '0',
  `height` int(11) NOT NULL DEFAULT '0',
  `content` mediumtext NOT NULL,
  `output_kind` enum('js','html','url','') NOT NULL DEFAULT 'js',
  `status` enum('start','stop') NOT NULL DEFAULT 'stop'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `third_inspired`
--

CREATE TABLE `third_inspired` (
  `id` int(11) NOT NULL,
  `campaign_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `size` varchar(50) NOT NULL,
  `kind` int(11) NOT NULL DEFAULT '1',
  `content` varchar(1024) NOT NULL DEFAULT '',
  `enable_ssl` int(11) NOT NULL,
  `attr` varchar(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- 表的结构 `traffic_control`
--

CREATE TABLE `traffic_control` (
  `id` int(11) NOT NULL,
  `campaign_id` int(11) NOT NULL,
  `traffic_market` enum('public','private') NOT NULL,
  `private_gdtadx_id` int(11) NOT NULL DEFAULT '0',
  `private_index_id` int(11) NOT NULL DEFAULT '0',
  `private_nexage_id` int(11) NOT NULL DEFAULT '0',
  `private_pubmatic_id` int(11) NOT NULL DEFAULT '0',
  `private_rubicon_id` int(11) NOT NULL DEFAULT '0',
  `private_smaato_id` int(11) NOT NULL DEFAULT '0',
  `traffic_kind` enum('all','wap','app') NOT NULL,
  `is_adult` int(11) NOT NULL DEFAULT '0',
  `platforms_json` varchar(2014) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `beacon_log`
--
ALTER TABLE `beacon_log`
  ADD PRIMARY KEY (`cid`,`mid`,`tid`,`yymmddhh`);

--
-- Indexes for table `bid_request_log`
--
ALTER TABLE `bid_request_log`
  ADD PRIMARY KEY (`timestamp_hour`,`exchange`);

--
-- Indexes for table `bid_response_log`
--
ALTER TABLE `bid_response_log`
  ADD PRIMARY KEY (`uniqkey`);

--
-- Indexes for table `campaign`
--
ALTER TABLE `campaign`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `campaign_click_log`
--
ALTER TABLE `campaign_click_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `campaign_filter`
--
ALTER TABLE `campaign_filter`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `campaign_id` (`campaign_id`);

--
-- Indexes for table `campaign_show_log`
--
ALTER TABLE `campaign_show_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `country`
--
ALTER TABLE `country`
  ADD PRIMARY KEY (`alpha2`);

--
-- Indexes for table `country_region`
--
ALTER TABLE `country_region`
  ADD PRIMARY KEY (`country_alpha2`,`code`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `my_traffic`
--
ALTER TABLE `my_traffic`
  ADD PRIMARY KEY (`campaign_id`,`platform_traffic_id`);

--
-- Indexes for table `nurl_result`
--
ALTER TABLE `nurl_result`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `platform`
--
ALTER TABLE `platform`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `platform_traffic`
--
ALTER TABLE `platform_traffic`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `preset`
--
ALTER TABLE `preset`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `third_creative`
--
ALTER TABLE `third_creative`
  ADD PRIMARY KEY (`id`),
  ADD KEY `campaign_id` (`campaign_id`);

--
-- Indexes for table `third_inspired`
--
ALTER TABLE `third_inspired`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `traffic_control`
--
ALTER TABLE `traffic_control`
  ADD PRIMARY KEY (`id`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `campaign`
--
ALTER TABLE `campaign`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- 使用表AUTO_INCREMENT `campaign_click_log`
--
ALTER TABLE `campaign_click_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `campaign_filter`
--
ALTER TABLE `campaign_filter`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- 使用表AUTO_INCREMENT `campaign_show_log`
--
ALTER TABLE `campaign_show_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `media`
--
ALTER TABLE `media`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- 使用表AUTO_INCREMENT `nurl_result`
--
ALTER TABLE `nurl_result`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=159373;
--
-- 使用表AUTO_INCREMENT `platform`
--
ALTER TABLE `platform`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- 使用表AUTO_INCREMENT `platform_traffic`
--
ALTER TABLE `platform_traffic`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `preset`
--
ALTER TABLE `preset`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- 使用表AUTO_INCREMENT `third_creative`
--
ALTER TABLE `third_creative`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- 使用表AUTO_INCREMENT `third_inspired`
--
ALTER TABLE `third_inspired`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `traffic_control`
--
ALTER TABLE `traffic_control`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
