-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 07, 2021 at 11:16 PM
-- Server version: 10.5.8-MariaDB
-- PHP Version: 8.0.1

SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `wilayah_bps_ori`
--

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

--
-- Table structure for table `negara`
--

DROP TABLE IF EXISTS `negara`;
CREATE TABLE IF NOT EXISTS `negara` (
  `kode_negara` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_negara` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alpha_2` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alpha_3` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iso_3166_2` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_region` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `intermediate_region` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region_code` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_region_code` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `intermediate_region_code` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`kode_negara`),
  KEY `negara_nama_negara_index` (`nama_negara`),
  KEY `negara_alpha_2_index` (`alpha_2`),
  KEY `negara_alpha_3_index` (`alpha_3`),
  KEY `negara_iso_3166_2_index` (`iso_3166_2`),
  KEY `negara_region_index` (`region`),
  KEY `negara_sub_region_index` (`sub_region`),
  KEY `negara_intermediate_region_index` (`intermediate_region`),
  KEY `negara_region_code_index` (`region_code`),
  KEY `negara_sub_region_code_index` (`sub_region_code`),
  KEY `negara_intermediate_region_code_index` (`intermediate_region_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `negara`
--

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
