text: -- phpMyAdmin SQL Dump
  -- version 4.7.4
  -- https://www.phpmyadmin.net/
  --
  -- Servidor: localhost
  -- Tiempo de generación: 04-12-2018 a las 19:11:26
  -- Versión del servidor: 10.1.29-MariaDB
  -- Versión de PHP: 7.2.0
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  CREATE DATABASE Delfin;
  USE Delfin;
  
  
  /*!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 */;
  
  --
  -- Base de datos: `delfin`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `autores`
  --
  
  CREATE TABLE `Autores` (
    `idAutores` int(11) NOT NULL,
    `Nombre` varchar(45) DEFAULT NULL,
    `ApPaterno` varchar(45) DEFAULT NULL,
    `ApMaterno` varchar(45) DEFAULT NULL,
    `idInvestigacion` int(11) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `countries`
  --
  
  CREATE TABLE `Countries` (
    `id` smallint(5) UNSIGNED NOT NULL,
    `name` varchar(255) NOT NULL,
    `code` varchar(10) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Volcado de datos para la tabla `countries`
  --
  
  INSERT INTO `Countries` (`id`, `name`, `code`) VALUES
  (1, 'Andorra', 'ad'),
  (2, 'United Arab Emirates', 'ae'),
  (3, 'Afghanistan', 'af'),
  (4, 'Antigua and Barbuda', 'ag'),
  (5, 'Anguilla', 'ai'),
  (6, 'Albania', 'al'),
  (7, 'Armenia', 'am'),
  (8, 'Netherlands Antilles', 'an'),
  (9, 'Angola', 'ao'),
  (10, 'Argentina', 'ar'),
  (11, 'Austria', 'at'),
  (12, 'Australia', 'au'),
  (13, 'Aruba', 'aw'),
  (14, 'Azerbaijan', 'az'),
  (15, 'Bosnia and Herzegovina', 'ba'),
  (16, 'Barbados', 'bb'),
  (17, 'Bangladesh', 'bd'),
  (18, 'Belgium', 'be'),
  (19, 'Burkina Faso', 'bf'),
  (20, 'Bulgaria', 'bg'),
  (21, 'Bahrain', 'bh'),
  (22, 'Burundi', 'bi'),
  (23, 'Benin', 'bj'),
  (24, 'Bermuda', 'bm'),
  (25, 'Brunei Darussalam', 'bn'),
  (26, 'Bolivia', 'bo'),
  (27, 'Brazil', 'br'),
  (28, 'Bahamas', 'bs'),
  (29, 'Bhutan', 'bt'),
  (30, 'Botswana', 'bw'),
  (31, 'Belarus', 'by'),
  (32, 'Belize', 'bz'),
  (33, 'Canada', 'ca'),
  (34, 'Cocos (Keeling) Islands', 'cc'),
  (35, 'Democratic Republic of the Congo', 'cd'),
  (36, 'Central African Republic', 'cf'),
  (37, 'Congo', 'cg'),
  (38, 'Switzerland', 'ch'),
  (39, 'Cote D\'Ivoire (Ivory Coast)', 'ci'),
  (40, 'Cook Islands', 'ck'),
  (41, 'Chile', 'cl'),
  (42, 'Cameroon', 'cm'),
  (43, 'China', 'cn'),
  (44, 'Colombia', 'co'),
  (45, 'Costa Rica', 'cr'),
  (46, 'Cuba', 'cu'),
  (47, 'Cape Verde', 'cv'),
  (48, 'Christmas Island', 'cx'),
  (49, 'Cyprus', 'cy'),
  (50, 'Czech Republic', 'cz'),
  (51, 'Germany', 'de'),
  (52, 'Djibouti', 'dj'),
  (53, 'Denmark', 'dk'),
  (54, 'Dominica', 'dm'),
  (55, 'Dominican Republic', 'do'),
  (56, 'Algeria', 'dz'),
  (57, 'Ecuador', 'ec'),
  (58, 'Estonia', 'ee'),
  (59, 'Egypt', 'eg'),
  (60, 'Western Sahara', 'eh'),
  (61, 'Eritrea', 'er'),
  (62, 'Spain', 'es'),
  (63, 'Ethiopia', 'et'),
  (64, 'Finland', 'fi'),
  (65, 'Fiji', 'fj'),
  (66, 'Falkland Islands (Malvinas)', 'fk'),
  (67, 'Federated States of Micronesia', 'fm'),
  (68, 'Faroe Islands', 'fo'),
  (69, 'France', 'fr'),
  (70, 'Gabon', 'ga'),
  (71, 'Great Britain (UK)', 'gb'),
  (72, 'Grenada', 'gd'),
  (73, 'Georgia', 'ge'),
  (74, 'French Guiana', 'gf'),
  (75, 'NULL', 'gg'),
  (76, 'Ghana', 'gh'),
  (77, 'Gibraltar', 'gi'),
  (78, 'Greenland', 'gl'),
  (79, 'Gambia', 'gm'),
  (80, 'Guinea', 'gn'),
  (81, 'Guadeloupe', 'gp'),
  (82, 'Equatorial Guinea', 'gq'),
  (83, 'Greece', 'gr'),
  (84, 'S. Georgia and S. Sandwich Islands', 'gs'),
  (85, 'Guatemala', 'gt'),
  (86, 'Guinea-Bissau', 'gw'),
  (87, 'Guyana', 'gy'),
  (88, 'Hong Kong', 'hk'),
  (89, 'Honduras', 'hn'),
  (90, 'Croatia (Hrvatska)', 'hr'),
  (91, 'Haiti', 'ht'),
  (92, 'Hungary', 'hu'),
  (93, 'Indonesia', 'id'),
  (94, 'Ireland', 'ie'),
  (95, 'Israel', 'il'),
  (96, 'India', 'in'),
  (97, 'Iraq', 'iq'),
  (98, 'Iran', 'ir'),
  (99, 'Iceland', 'is'),
  (100, 'Italy', 'it'),
  (101, 'Jamaica', 'jm'),
  (102, 'Jordan', 'jo'),
  (103, 'Japan', 'jp'),
  (104, 'Kenya', 'ke'),
  (105, 'Kyrgyzstan', 'kg'),
  (106, 'Cambodia', 'kh'),
  (107, 'Kiribati', 'ki'),
  (108, 'Comoros', 'km'),
  (109, 'Saint Kitts and Nevis', 'kn'),
  (110, 'Korea (North)', 'kp'),
  (111, 'Korea (South)', 'kr'),
  (112, 'Kuwait', 'kw'),
  (113, 'Cayman Islands', 'ky'),
  (114, 'Kazakhstan', 'kz'),
  (115, 'Laos', 'la'),
  (116, 'Lebanon', 'lb'),
  (117, 'Saint Lucia', 'lc'),
  (118, 'Liechtenstein', 'li'),
  (119, 'Sri Lanka', 'lk'),
  (120, 'Liberia', 'lr'),
  (121, 'Lesotho', 'ls'),
  (122, 'Lithuania', 'lt'),
  (123, 'Luxembourg', 'lu'),
  (124, 'Latvia', 'lv'),
  (125, 'Libya', 'ly'),
  (126, 'Morocco', 'ma'),
  (127, 'Monaco', 'mc'),
  (128, 'Moldova', 'md'),
  (129, 'Madagascar', 'mg'),
  (130, 'Marshall Islands', 'mh'),
  (131, 'Macedonia', 'mk'),
  (132, 'Mali', 'ml'),
  (133, 'Myanmar', 'mm'),
  (134, 'Mongolia', 'mn'),
  (135, 'Macao', 'mo'),
  (136, 'Northern Mariana Islands', 'mp'),
  (137, 'Martinique', 'mq'),
  (138, 'Mauritania', 'mr'),
  (139, 'Montserrat', 'ms'),
  (140, 'Malta', 'mt'),
  (141, 'Mauritius', 'mu'),
  (142, 'Maldives', 'mv'),
  (143, 'Malawi', 'mw'),
  (144, 'Mexico', 'mx'),
  (145, 'Malaysia', 'my'),
  (146, 'Mozambique', 'mz'),
  (147, 'Namibia', 'na'),
  (148, 'New Caledonia', 'nc'),
  (149, 'Niger', 'ne'),
  (150, 'Norfolk Island', 'nf'),
  (151, 'Nigeria', 'ng'),
  (152, 'Nicaragua', 'ni'),
  (153, 'Netherlands', 'nl'),
  (154, 'Norway', 'no'),
  (155, 'Nepal', 'np'),
  (156, 'Nauru', 'nr'),
  (157, 'Niue', 'nu'),
  (158, 'New Zealand (Aotearoa)', 'nz'),
  (159, 'Oman', 'om'),
  (160, 'Panama', 'pa'),
  (161, 'Peru', 'pe'),
  (162, 'French Polynesia', 'pf'),
  (163, 'Papua New Guinea', 'pg'),
  (164, 'Philippines', 'ph'),
  (165, 'Pakistan', 'pk'),
  (166, 'Poland', 'pl'),
  (167, 'Saint Pierre and Miquelon', 'pm'),
  (168, 'Pitcairn', 'pn'),
  (169, 'Palestinian Territory', 'ps'),
  (170, 'Portugal', 'pt'),
  (171, 'Palau', 'pw'),
  (172, 'Paraguay', 'py'),
  (173, 'Qatar', 'qa'),
  (174, 'Reunion', 're'),
  (175, 'Romania', 'ro'),
  (176, 'Russian Federation', 'ru'),
  (177, 'Rwanda', 'rw'),
  (178, 'Saudi Arabia', 'sa'),
  (179, 'Solomon Islands', 'sb'),
  (180, 'Seychelles', 'sc'),
  (181, 'Sudan', 'sd'),
  (182, 'Sweden', 'se'),
  (183, 'Singapore', 'sg'),
  (184, 'Saint Helena', 'sh'),
  (185, 'Slovenia', 'si'),
  (186, 'Svalbard and Jan Mayen', 'sj'),
  (187, 'Slovakia', 'sk'),
  (188, 'Sierra Leone', 'sl'),
  (189, 'San Marino', 'sm'),
  (190, 'Senegal', 'sn'),
  (191, 'Somalia', 'so'),
  (192, 'Suriname', 'sr'),
  (193, 'Sao Tome and Principe', 'st'),
  (194, 'El Salvador', 'sv'),
  (195, 'Syria', 'sy'),
  (196, 'Swaziland', 'sz'),
  (197, 'Turks and Caicos Islands', 'tc'),
  (198, 'Chad', 'td'),
  (199, 'French Southern Territories', 'tf'),
  (200, 'Togo', 'tg'),
  (201, 'Thailand', 'th'),
  (202, 'Tajikistan', 'tj'),
  (203, 'Tokelau', 'tk'),
  (204, 'Turkmenistan', 'tm'),
  (205, 'Tunisia', 'tn'),
  (206, 'Tonga', 'to'),
  (207, 'Turkey', 'tr'),
  (208, 'Trinidad and Tobago', 'tt'),
  (209, 'Tuvalu', 'tv'),
  (210, 'Taiwan', 'tw'),
  (211, 'Tanzania', 'tz'),
  (212, 'Ukraine', 'ua'),
  (213, 'Uganda', 'ug'),
  (214, 'Uruguay', 'uy'),
  (215, 'Uzbekistan', 'uz'),
  (216, 'Saint Vincent and the Grenadines', 'vc'),
  (217, 'Venezuela', 've'),
  (218, 'Virgin Islands (British)', 'vg'),
  (219, 'Virgin Islands (U.S.)', 'vi'),
  (220, 'Viet Nam', 'vn'),
  (221, 'Vanuatu', 'vu'),
  (222, 'Wallis and Futuna', 'wf'),
  (223, 'Samoa', 'ws'),
  (224, 'Yemen', 'ye'),
  (225, 'Mayotte', 'yt'),
  (226, 'South Africa', 'za'),
  (227, 'Zambia', 'zm'),
  (228, 'Zaire (former)', 'zr'),
  (229, 'Zimbabwe', 'zw'),
  (230, 'United States of America', 'us');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `educacion`
  --
  
  CREATE TABLE `Educacion` (
    `idEducacion` int(11) NOT NULL,
    `idUsuario` int(11) DEFAULT NULL,
    `idInstitucion` int(11) DEFAULT NULL,
    `Egreso` date DEFAULT NULL,
    `Grado` varchar(45) DEFAULT NULL,
    `Carrera` varchar(45) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `infoacademica`
  --
  
  CREATE TABLE `Infoacademica` (
    `id` int(11) NOT NULL,
    `idUsuario` int(11) NOT NULL,
    `Grado` varchar(15) NOT NULL,
    `cuerpoAcademico` varchar(150) DEFAULT NULL,
    `consolidacionCA` varchar(45) DEFAULT NULL,
    `perfilPROMEP` varchar(45) DEFAULT NULL,
    `nivelSNI` varchar(45) DEFAULT NULL,
    `areaConocimiento` varchar(100) DEFAULT NULL,
    `UAcademica` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `infoacademica`
  --
  
  INSERT INTO `Infoacademica` (`id`, `idUsuario`, `Grado`, `cuerpoAcademico`, `consolidacionCA`, `perfilPROMEP`, `nivelSNI`, `areaConocimiento`, `UAcademica`) VALUES
  (1, 2, 'Dr.', 'Tecnología de información y comunicaciones aplicadas a la ingeniería de software y sistemas de información', 'Consolidado', 'Con Perfil Deseable', 'Candidato', 'Área IV: Humanidades y Ciencias de la Conducta', 'Computación');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `institucion`
  --
  
  CREATE TABLE `Institucion` (
    `idInstitucion` int(11) NOT NULL,
    `Nombre` varchar(60) DEFAULT NULL,
    `idPais` int(11) NOT NULL,
    `Pais` varchar(255) NOT NULL,
    `idEst` varchar(255) NOT NULL,
    `Estado` varchar(255) NOT NULL,
    `cp` varchar(10) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `institucion`
  --
  
  INSERT INTO `Institucion` (`idInstitucion`, `Nombre`, `idPais`, `Pais`, `idEst`, `Estado`, `cp`) VALUES
  (1, 'Universidad politécnica de Sinaloa', 144, 'Mexico', '2440', 'Sinaloa', '82150');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `investigaciones`
  --
  
  CREATE TABLE `Investigaciones` (
    `idInvestigaciones` int(11) NOT NULL,
    `idUsuario` int(11) DEFAULT NULL,
    `Hash` varchar(255) DEFAULT NULL,
    `Fecha` date DEFAULT NULL,
    `Titulo` varchar(100) DEFAULT NULL,
    `DOI` varchar(255) DEFAULT NULL,
    `Tema` varchar(255) DEFAULT NULL,
    `Tipo` varchar(45) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `investigaciones`
  --
  
  INSERT INTO `Investigaciones` (`idInvestigaciones`, `idUsuario`, `Hash`, `Fecha`, `Titulo`, `DOI`, `Tema`, `Tipo`) VALUES
  (1, 2, 'null.pdf', '2007-11-30', 'Investigación 1', 'null', 'Caracoles', 'No sé'),
  (2, 2, 'null2.pdf', '2007-11-30', 'Investigación 2', 'null 2', 'No sé', 'No sé x2 '),
  (3, 2, 'CyLBzJjVABEDnF8KK0L7LKUS.pdf', '2018-11-22', 'Nueva', 'null', 'Informática', 'Capítulo');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `mantenimiento`
  --
  
  CREATE TABLE `Mantenimiento` (
    `NombreRed` varchar(60) DEFAULT NULL,
    `NombreMesa` varchar(45) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `noticias`
  --
  
  CREATE TABLE `Noticias` (
    `idNoticias` int(11) NOT NULL,
    `idUsuarios` int(11) DEFAULT NULL,
    `Titulo` varchar(60) DEFAULT NULL,
    `Descripcion` longtext,
    `Fecha` date DEFAULT NULL,
    `img` varchar(40) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `noticias`
  --
  
  INSERT INTO `Noticias` (`idNoticias`, `idUsuarios`, `Titulo`, `Descripcion`, `Fecha`, `img`) VALUES
  (2, 2, 'Noticia 2', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.', '2018-11-05', 'Prueba'),
  (3, 2, 'Noticia 3 ', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.', '2018-11-05', 'Prueba'),
  (4, 2, 'Noticia 4', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.', '2018-11-05', 'Prueba'),
  (5, 2, 'Noticia 5', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.', '2018-11-05', 'Prueba'),
  (6, 2, 'Noticia 6', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Laudantium veniam exercitationem expedita laborum at voluptate. Labore, voluptates totam at aut nemo deserunt rem magni pariatur quos perspiciatis atque eveniet unde.', '2018-11-05', 'Prueba'),
  (19, 2, 'Noticia de prueba', '<h2>Noticia de prueba</h2><p><strong>Noticia </strong>de <i>prueba </i><a href=\"https://www.google.com.mx/\">Noticia de prueba</a></p><ul><li><strong>Noticia de prueba</strong></li><li>Noticia de prueba</li><li><i>Noticia de prueba</i></li></ul><p>&nbsp;</p><ol><li><strong>Noticia de prueba</strong></li><li>Noticia de prueba</li><li><i>Noticia de prueba</i></li></ol><figure class=\"table\"><table><tbody><tr><td>Noticia</td><td>de</td><td>prueba</td></tr><tr><td>Noticia</td><td>de</td><td>prueba</td></tr></tbody></table></figure>', '2018-11-16', 'SEBqWMLhzVujsThqsOHK7bOJ.jpeg'),
  (20, 2, 'Noticia shida', '<p>Hola esta es una imagen</p><p><img src=\"data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAYEBAUEBAYFBQUGBgYHCQ4JCQgICRINDQoOFRIWFhUSFBQXGiEcFxgfGRQUHScdHyIjJSUlFhwpLCgkKyEkJST/2wBDAQYGBgkICREJCREkGBQYJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCQkJCT/wgARCAEsASwDASIAAhEBAxEB/8QAGwABAAMBAQEBAAAAAAAAAAAAAAQFBgMCAQf/xAAaAQEAAwEBAQAAAAAAAAAAAAAAAwQFAgEG/9oADAMBAAIQAxAAAAH0J/mQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABU+Scau/9UPpJPaku7uA8+s77xK85vnW3P0H7QX9nDePeX86m9ONNW2tsqba3goczEcWrW0xfqHT/QHLra+fB4AAAAAArbKv5m2Hehs8n6vMyqqy0/mveU1eTSfolDYcsf6fJajOaPZ+WcZEuJdcvcfI+nyVhJjbfyXyHIzMWl+m5fWYijte51Xaa3yIdQgQpv5rK80v0BmLj2nPCEADxgd7l4Ne+2WNnxaf59os98lg/QKGpmwx/pVRYwvm/oKGd9+7/wA5Ntauyy9H0M7UZ6/oNrA9fLTT7FXzmdV44uYTxqsrNjB1UA/Nfn1z9G+fRJuM8RbydB03FKo+aP3Vs5ThrvsN/pFs58kn5nkf0H8/l8+cuzvnlfU3mPrYWX5v05r/AKdZZ+5yLclCUdGXQXlHsYN9c19NrQbCNk+cVrV4zaYuzkB1RA/NfmnqudyuffKf78WB+syZkPKvBXnq9FmtjZg4RoNPxJrMh319vj8cqf32nlrfjba5MjfErzrZwZsPLnoOcuN53vIfP7oYOs/Kdpie54Dryi0P2LOe+Nz57yJaQDn0EOp0RJiL628c29V7ymkzdfvEl1dTSs7zx806NDWz6ehs136HQ52zB+lfOEDrO9Ssr6r353exnXc+gpdxXwSYvN3+cpzaKTFlbXyLKavKcW43Htxq7e5+/Puj8oDwAAABw7j7oKHb09/ursd3Y2kS58FZkt/198+UV9X1bObpruTX3LO2/NNpofPW+X0WDryVlNLiVvdHJjSdj5ZlNXlI7cbj241dvc/fn3R+UB4AAAAPfntvp4fWr9LU86rnU2dPIy3Ln3a9cfrrFDJz8vbUNaw0OH2dnKyWs7fLtShx11S05KblceUEiZE66GH0y2iic2KDlpeUOhZ9ove3h9B1GAAAAt6rXcXp3r6g2odbdwXudrdfMivZrYQ6rzmupbrQV9OqjaL82vYf6pwk0PPGZ9c+vuUFvLAAAAAAAAH0tNLBtK/0PCArqmpou+fmyR2X3j1lrRMTuslU1Iq3kVbWg+ce+rg+cbqMRD346F/5YPeQAAAAAAAFnWT+LWnlxpMG9kfmppY7MrhOxPUGi0eG1ffPyvp6mhu7qqlXVjJ/L/1SBMsVqXLW1XHW9i5hAAAAAAAAAPPqNW0Nlcfn2hh29DwiS5eIsnu9841F9yikyUfQx8vUjarEytfO1cGdR+w53xz6SYgTUgAAAAAAAAAOXOS8782EDjBoaa0wXWLQ/Q/eItObOjQ5ksebk3j3zhmLzL88xfRb+aAAAAAAAAAAAAAePYj+ZTifjY1/OrqaywwXWG/qsyWc36LWOAAAAAAAAAAAAAAAB85dhw7nnoe+AAAAAAAAAAAAAAAAAAAAAAAAAAAf/8QAMRAAAgIBAwIDCAAHAQEAAAAAAgMBBAAFERIQEwYUISAiMDEyMzRAFRYjJEFQcDVC/9oACAEBAAEFAv8AuFjUxHEXmplTRcHQigYbqagxeqLKYneOhmKxZqixlOpKZPWxaXXz+Lete4ux+lqbJBBeH+Savh/Fr8lqPTVWTv2y7eaW6ZjpqRyb40CzK7FN9WdNbJo6cW22ZEyJLPuL/QvqltdJQacevnqvTU/yV0kBXsaFWENK+90r1xnUsYIGFJXbXk/Lw5EZ2w38QJX5elO9X9Bt5KS0+3Dq4vF+fxRJEBiwc1P8nS5v8dbK0FfSY97IjeYrMjAguL1sOCrmEYz7elouuswDAjxAm8otOn+19lV1DvhHOwfPPDTeFrWW9nTyjNKmeGa0vgyPlq//AJ+hL5VsqR73sH6ECZsZoul3dPuEHMtfoWNQFVBlGl7SrTk4rV5xV5Dfbb9vT0Q061Ya1nxBb8zX/wDmCaOK1CwnNR1JV9aWCxWpjzoaEO1GY2mp9X+ekYf16YO78/xM7ZqUb1/gqsuTitXKMRdTYnq37emVpkEU+yDaAlmoVISrNslcYsmoJOvOGNGv1xW37lT6v89Iw/r0ofQfU8f9m3HKt8PwxTFuOpxzEBCNslYTgAKyBxcpGJzxPyBPsbZK4xbn180ix5lZvUkvO1s87WxZiwT+vTR2r2NbirY/mDeP5jicX/Wq/D0ev5TTettsjKUxCeC15N+vEsWm4q14YWWWdLuVM39ic0ZXaVrYxLgnt5IxM6ZH9kf11DEK+oTyudKDh8oyNmew3TQnGUGhkjIz0oV/NXG+g9UD5m5l2CfKw/qeZ8sYHDAy1pNO3lnwwwcfVfVnfK6+68DJc3AO1PYMZylYJdb55Fk4C9+SMe5iXkoJnlPsyETh14OG6aucZp7Rzw6IJtnaUxnSyfBWlp4rxzATJ3e4rKoyFbJmBgtSTEi5ViLPh+lYynotWoLdKGcdUcjoz7lb7HS9+SP0ZHy+DIROdqMge3KnA4cdEvsCMAJcsv05fK6juzU0yRItdtC6s2XV7kd7OyUMa2FHTf5iv0u8ZQydgyt9jpe/JH6Mj5fElfqFmwvNOXynoxc4XPPfsqnQj7+W2Ag/PyfTTAkKnTU3bk8/eyt9jpe/JH6Mj5fFAJYaQgAssiGUNVuOu5wHICInpbqBbAdLsLmtpM8r+pP87pdhtqm04WthyZSXN2VvsdL35I/RkfL4unp3nE2FwfKmo+93LjLSl4LAKMu6mcOj3sXf2dlnw6JypcJVqrdhsHwWv6srnsqCic7kZcnewP0YLI233+IIyZV1wEP+21TE53QxBs5yhpkpcjZn5bJ3rsAkSoohf2+l1nce0O5gJgM8sO8BOQvO3ONrQ3AriAjTAS4Tgjx+JQV6hGwzEFBCK8ZWTYw9MKJObKJ0szdazUKJLOJkZqJl8h4jV3BKDGwfBRlkRtH6gxylK+MdJCJw05CigpVOyK4Jy1qsLIdXfE1zTZG6DGVA0uwVqI2zUme78y/Voq3JUZYPgsLvoty2+xbmYr+VPJrkgaTzi70mdounyYP6sRvKl9tYxtFt8LkVobiq/LO3YVgHJdHL7qpZITWKZUuunuKct45ZLYXFzP8AVoq5GEblllrRbX8nbxdRq51C3/DU6frQXWY68hEyylcJNEVZrrezS0hZN1LLrPSPUv1a9ztZXmDXjYCYbXUwlWB219pla8OV95tskFvTJxmlWZYBrBo16FeoZlxG6foPy/VnK15Ej8+hqgsKrE4SQZilCkNUGdq3Pnc2U3SJ5s6WSyyXNv60ntKGBDFuicGzOC4C9hixaEVJSLqJ2Q1N06avRtSsXTx7Mj1L9eVxOcTHAtMDAvb4u5GDawTEvY1HR/Os0mhNBDi4hcPioY2j9mYiclWe+OA6RwLhxitSxdpbPYsluVsuTv3ZGJztzGciHIZirjV4GqBxXdQzCLed+Zf6CVxOcCHOeQUTncKBj0/0e2+SqMEZ3/4L/8QAMBEAAgIBAgQFAwIHAQAAAAAAAQIAAxEEEgUQITETMjNBcSAwUSJAFBUjQlBSYdH/2gAIAQMBAT8B/wA9VX4jhImgrVdmJq6PBs2zT0+K4Sfy2nGJfSanKGaWjxn2w8Mq24ltZrcoZodKLm/V2Es4dUR+noYRg4+xRvDgoJXdur8Qia1nd97DE4Z60x0zicR9czQC0Wb61zHZgm4LNSLPEJsGCZwk4DGMwxNQMWt8830H+pj6exO4+jha5ziPUwMvq8VCk0Gm8EsWh8s4wmAjThPTTLy455EM0JxX8zeZrfVJ+l6UfuJZw9z6UHBjjq00WjOnz1jFlOYzbuSuV7TWodRWF/E4auygA/kzInG/Ik0qHYoEalsTWjqDzTUo3vzoXpnle2OgiUBhlzNRpzVg+0zyAzKq2RNnfrP+TiWqW0BB7TS21s4Cfj/yZmptretQO/0Jcy9jF1zCaDWC4bT35M2TmadqXUEnrOJ6pHwie0rTecRdGr9FjKUbaYlzZ6wvl9s1Hqt8zhnqn4g94e/1A4miZ/Byx7w9JiYzNM4V/wBXaJqNPUCQZbb4jlvzKR/cZV3JPvNR6rfM4Z6p+IPeHv8AUoycCKu1Qsr0lT4I6w6FN2GPQTUUCogA95ZQEQbBNSgGCJiX2LVUN3vBxCvcZbtZi00liVPug1ydY4X2+rQ1bn3fjkGKnKyriNi+frH3auz+mJ/EW6dMXLmam82HMUZOJxa7dbsHt9vT1eGgE09KlcuI9KZwp5aG7YpC942pyjeIOSMEBc+0dizFj9rRqGtAPJNRgY7fEstLeaVAv0lPD6yuQes1KujlHijE4hZspCfn7fDba67d1kbaeqdedTbGzKbkDbiek1VwstyOWvt32nHt0+4ljIcqZXxJh5xmV6miz3x8zwz3HLEss8NS/wCwq1NlXkMq4tnpaJXZRb5DOKNsxX+yzCxbv+9//8QAKhEAAQQABAUEAgMAAAAAAAAAAgABAxEEEBIhEzAxMlEFICJBFEBQUnH/2gAIAQIBAT8B/niemtPiPu1GeprRFTWuKSEra0ZaWtNiLdC9takPSyaV+SXTdFA7FpUQsI0pu1NJ8tLEou1Yk42HSZUhMLrUojAh+D2sSOrZRg+r/EPTO/bMWlrdBMBJnpYhychroo9pGvysDJckgr1Led8vSO4kbbrQyDp7imEe5fnN4U2IaSmQMBjSANOUkIH3MoYGjkc2+16hvOVLQXhek95IyrqmmFD7sQVllhwvd0+J3qNBJqzd6a0dFJxFv1WDw/Ddz8o2OvlkGrU99Pa7WsTDpfU2QDpakOEaK3FYaJ23dTzNENuo8QT7kr1MjgGrZV8bUXYyn7eSYDxNvpVlaxEAyjRJ4X2EWTBpFTltpZSeFF2Mp+3kPk+IJurUixgD9qCbijqZYqPj1usKRdrq1TySPX0vxSpBbNSkZyZcN01+43zOACTaYhpaBN/i6jBmRPTWsGFBq88sntTTODoJdTW2WJpt3UWIHicNmym3oW+0zU1cqR6G8uHvaGIWe2bdG7CpJX6O2yhAO8WTvajbVLfjl4kCIaFRO/Q85Q1i7KN5Gl4btsgChygGhvzzHFn6p4P6vSfiD1a00wvladr2/QOMT7mRYSux0RSh3MsOWv5fps1fu//EADwQAAIBAgQDBQcBBgUFAAAAAAECAAMREBIhMSJBURMgYXGBBCMwMkBSkWIzQnKhscEUQ1Bw4SQ0gpLw/9oACAEBAAY/Av8AfArSGY9Zqc69DM6bY3Y2E4AXlnUpLjHM5sJZFL+O0swyHucWp6CfstPOWGjdD9FYfvG0RqVTjtqG2l/aX9Ej+zA3Q7YpT5bztLcN7XwakeWoxFIcuUDZkB+0z3tMr48pY/um2Lsqlz8xt0wuNCIrdRf6HTddYjDmowqVOSAD1tj6T/D9mDT6GPUDVFCi9o38OK1WF+HT+LAioAV53hIFgzXHlgZXPPSXyLfraLVyjPmteU/ocpJJ8JUqg+7pbg7xxScXVc5zDlNc/wCJmU3Bw9IV9sUC3ym+pnuQvZke8PMSocLCX0E4iCZYEWl8G8p/0Vgw+a50tAtXLn55doprtT7AnhCf3g8z3uGoL9D8JiOmDUjtUX+cqnmwyfnCoOQOFE9Uwq+n9ZXPU4HunzjUxuVNvxM9RVyMuU2aK3TeUloAHKSTcxBVAD5jt3+CofKe9p38VmjgHodO+3lGZhdRKdemSMp2lJaIYi9202hhyOVHgZrxjxlLgKOkVlYMLcpWH6bzzcwiN3W84T0XA4X6H4XBUInvEB8RLIeLoe4/lKdMfM+sIYBrzg4TGarT9e5mpVGU+BmT2lBVU6HkYaBfLxcObmI0but5yo3pH/EMbyvH8r/ErV6i3HyCcBsJZRhqi/iZkUAwX1wogfIW17/A5t0he1jsZapURL9TP29P8z/uKX/tMykMDzEbzl+plSllU2aXHZDwMt2a/mL+pPiUgdyM59e4FU2i59WtrM23nPn/AJQ03C1F5iX9mqlP0tqJ7yiSv3LqO9b1iX+2HLpeXIlP1/rG84gPSVD1xp3Oojefd0uk0s3lLEEY0qP3Nr5S3cHS9/TDhbb93rLMNtTM29TmIGGxF8LvRAb7l0Mv7NVD/pbQy1akyeYwVeW5l1NoGuLicQ9cFUWwyaR4+FhaXPfsQG85pdJw2aPVr8BC2W4mVXBxPjpDUO7bYHtHA8Occ01y2sM3PCmDvlwuTYTTM0ynmPlaXVTSb9EIsahbdmnumt4GXZdOowbzi4tH8sB8QMNxrLqfTBaQgUcpwkDzEz5ctTw1BjgJfiG3rO0r2AGuWNUR1NMk2RhylOoy5Cy3t0mS9rQIdLzN+/yH2xXO/PEhtocFxaP5YD4t1NpvmHjDWbc43J9ZewY/hpUp8ViLHNodehiAuOzJF7i2mBLtvsOccIuUBb354Lfnrj2Y9Zl8D/TBcXj+WA+MEHOACKG+VAarekRM4dajagjYYbS4xytow2MfZrrYWMzVyLfaI5oVmRUORQNtPCLVrAZj05xmPKFzzhPgcFxaP5YD43aegwre0OdHbIunKdtQpL2x0uBaBBsg/nFu28uGFsMlI8KHXxgK7HUTL/l7YXo1ing2sWmuyiwi0+upw9DgoxYx/jhRzgA2EKhgrMLLcxVqUmVF1uNYChu14+UHUWvMtrDrKVEMcu5w/wAz8w0VYgj7ukvuOoi33tiTNRpNjL2M2muHEDeFcu+8vYn4xqHyGFiLicLFfDcQ5qYJ+6nv+IT7NVzW5bNLOai+czNrlXA1EF0OvlLjQiCtqg5wipRZU5MNdIGXYi4hMJ+mAHOKg5dzaAO106MNR6ywbMOj6wlaYQnexmSiAxHMzUIRM/ZqG8RKqUbB2WwiUHouqltT4ectMvp9Oah5bS83tfScScPVNROFge4+U2O15oUP/kJ2lVD4CIxPzHKcby0v1+ltAuHEGyjTQX/+/wCZmotZutM/2lqjK3iOEzgftB0acSlTgySyrk/rDrsZ2zKEycRbaZqTq48DhbrCev02c7LjfsnZd81M8Q9JY1Fz9fkacVXtU5Zt4CnGzmyq0FE0mp1PyMLM+vQT5sr/AIh4ybwUV07U29JTycNuNrdMGPpPL6bIU4eszjY4cS3gLU7+J1/5ltfMcUU2PZBbKw213lX2k/wL/eWUgM0zW4xv+rA0mNyu3lMrqGHQiM1GnkLbwmAev1C09Utprj0gO5E4l1O9pkW1vAWiNNGIA1M0pU8raiO3ZqoAtcYhZb0+n2gLTgecQvN+4UbYzKvF4zL8tjuZS9m9mfIx42bnHp1gpyC+cYM8J+o6TSbmaj8TR7eBmo/E0Pc7VauV7WsRcRg5U1GNzaGW6/WaYaEicmmv85v3MvSBen1+hmonSfNceM4gb9Jo9vOFjGfqf9C0mowsGOv+i6TX/Yb/xAArEAEAAgECBQMEAwEBAQAAAAABABEhMUEQUWFxgZGhsUDB0fAgMOHxUHD/2gAIAQEAAT8h/wDt6gW4J3AjofmVhtxPhhZLXtxTkDVZgEemCEuoLsgAgjucVgS3Z5wRSAHNzbPX+AuSumtP0v4mSX6KgLVkdprIy609K0jW42zfLHeAXbtZxpB0X6zdPir5cGQs8TjfIhMN1l2FLsbJUiHTUvMbPeI9ONeVENkb1DTqLGdJ76E4raVOc0hGHpwdUxV5/wDTjkTplDIa5LefeJjDmEwdocv6zxqpF9o/y/Tg9ymGmoDQkTqbODpukp9H8Znx5LmAiuvVKZdule/0LwD1DdSuTpz2SuZfFAhYcy5WAAtEnANepjT8TCe9TKVchsHSdkgcEILWNBUOukpOwJmP9TnLoBN64On5P4hteogB1G5LPdd/LpcQQVyj3b14lx8g9/5YAHYP9Ta4Eky3d1gdHHmM/Fwz6Cj2fFxLWOS4CcDPK1O9/wCzMPSKu38EFQ0Q8H+8CX3CXmpfDWAGaClb7H7rV7xwSykU3PiCtAPFiHyqZBw7XjFff+eik5snpB0B4HtMH3wv5+7/ABK8RqurMnC3XjclAKXSDHywzbzIYE3QuYd/r3lJKkRyU9fEbFBlXFC/4Zlw858H2nSRqe0hr7HHd3nvE/YzMsut4QI28wnZW/b7/wBWgVyuz0mGN7LLBd1VP8PdfiYSEt0/SO9TzWSpdL6TpCu3WDu7ZgYiIjb0nhyREpas1D4l/wDidGz7whVotz2kNfY47u898nkBDtck9l/eGkWtNT2J+/uf9lZB1bz1ftLftLK0CIdQYOiB5iV4LFhKIqLU1Egsu09wY+Wa8dYljunafeMHpLl2Ic5fCCwMuYLEOhYjhB5JlgZYSxnvE7yWWyiWqwxgN0biJVL1fiP9Bp/ZQqvPcvwTVvi0latMMRuDzmp0DdaSkWeoo0s6m34ZaNP1HX5l+hP0DTzKfwpU0HSlvMoNf+ovkkXEtyyojT8k94j9U5aTrmv24gLAVCGaDr+O7b1JkiPql0RyTjh6wPkfa4qzi/4ZNnM7OFLxY290uKKxHptFPe91cHfrNIdDhaKn6m/mX5T9R0fad7+wPZ0ZRnKI+CZQERpBVViNQoUtNNOBQIzV7ZiqV1ZQWyr3nwviAomQK9eBgkPPaMust/y2au0qgOQmQLdMkydHprGwclWr/nzLLYwde3HAtcEpls9nC/gvqXiXgJWtQ36acNMcL4OjBqsqQ6wTFZzUakYWrdY9NIHusj45S+VfdJYL844O9Ay0ntfvx+H8T275OHtv6tmrtDJasKx2+UADvfccNofWERQKIWF53BlY1jL/AKvtEpb03EwQI54nzFMdYk25M3KMrO95EuZ9fovWVlya7Vzj7Vbttr/ETob3HG8qammXw1qLbbPa/fj8P4nt3ycPbf27gJQnuEcdlx+/ukuo2mGnnBGT0NMqQCGtqeT7wcFpqaDY/ECFBZzoKs9yABRgJXS1AWoDtgCbtp41muZpoW8dM3X7JinmPq4e1+/H4XxPbvk4e2/u1BFUJijacnhnbR758TNNbqk09CWHmZLrLWPbjdDYepAUCsNTJzlNQNzXvBa7kT3OxzD/AFWkVQdZppC5riq5+pGHh7X78fh/E9u+Th7b+6wRr/pDBMJIcwP24sjj1lCxrRfWkQAPS6HOWPKXd7cMZWY5zbtEXVjZ0lU29Jde/B8OduhnZ133uHPR+0SlXVC45uJyP0OAuDpNCYj1mJta+JfT2PnhQDZiAFjf9msAqmgQ0Sy+olGalxGKxenaFfK7yI2laltFWD3bxbBIXOrZrVrUVyPS/E0U/I13GJXB1myX6Zv04aTk8YJo0dlRWyzmxT0OU6Kxd1RHrKJENyBVJubwwa2g6Qfapz1r/ZYFpCg65jgSajvP1NnJ+1SyZbb1bm/9QOupfB++Jf0jWWI2cDl1z4J/Xat8MsosTaIIHnbfbpMkFb+VtU2j/WZOYw2ojbqsqD6Vc6VRD0xxP2meZGbFo7jC9E7jkVqmOHJ6euvrcL0vVxiIMEHSlk5aqoXOtIF9+0XJIq1AF6ELA64Y0gABQYCV0MaByz9NVDGPdNTwgLfPORu+lyuwp0eiCeM34JeueFfLFFtcfhD70xZrrZXqm0vMPiHiTLQLldyZfM0v0ohDK4IRexnqyjJdUZLSF5+KhXxIME1ZeMT+Zt/y/rCgpNvL14ExuRxeGF19f4mcF5fP/JREsQ0xz2nUhN3CllSW6iBRX0tiHI7yo6Zi0LyiKsZa81vX020iWtvgYPGjGJgsBQ8xMGFjBuuI3ICmba68Et46haTOm27q+00G6YqoQEyWawy/EeU57dYbetHCsToUngfTN3tVNYMy6PC04umNPxB7MbBw8nyuZJatUp+fUg45vK8ztiVi63v9k03QLal0MKxyc+/DU1FMMH/W0Qp4aorjpynS2UW+qGrurn6bVM5gANHrBBY2cEbG3bWKc1apBLoLLB884SEFwB8IjbCj++I2TrEEeixoPk1jHaojfu9OOmd2XOy/Z9Oj3hEGoJlg8MDodRNJo8n+BA3CiNFt3MIqlYe5+9Iru0AtbHq/EEjjRptdE058Mm0aTOe306XrNGjcrmE9bM2m8HyT80aLv8DS9BWivclsYbprYlu3cE60UoD6rVC4G6pzSyKeis1Cj0YBhp6ppp9YI6N8aCHKg5+u1cjmcIRXhtFylyoykQLgXLCeYEup/wCDdC7R1S4MxLQGK1RhVwUDl/4aNRcRqqHzWGn/AMG//9oADAMBAAIAAwAAABD77777777777777777777777777777777777777777777777777777777777776g/3nL67XSCDz7777776qne3LSYj47F775bHb74NnDFTi349q1z75NIJlvw/h4V3rjyLNz75Y53EGeB4DepcagICH7741KFMRS2MLk0N6sNT777771mdUlOelpRSsNT77777uJhWQAPRBst2bX77777F7ZSuXwM/7777777776JsmUlpq3T777777777g20tzfXDX77777777764wa3Oef3z777777777640Kj7lBb377777777777774kisf777777777777777763/AO++++++++++++++8++++++++++++//EACoRAQACAQEFCQEBAQEAAAAAAAEAESExUWFxobEQMEGBkcHR4fAgQPFQ/9oACAEDAQE/EP8A3mA8WN8o6rr9eUtjpqcI15V9IBib23n45TMxXSUd6NXhNCI7b/HKawAxF9iOw7y3ncZFqdxmWTMVklalRu8OC9k6D7RtZCvgHSAmEw1+1lqC7PGGT5FMJvd7ym36Sob3XtDX1psw3Z/hidWPeW2sRgGtI6kuivXMzVbIYZqJ0feaB4r1ezJGtsZ68Uqp2QcRn+mkLFmzxjQ0vD7g1wrpLOcs1SV2asgRoVZ8RMPTqM30V8ZiNlX+9Yim2XbWfuvbodOMG8kJU9rsVCS0C9kH1Vo9i4iAgpOo3xtmLjXnbfSWr4zvbBazZLR669o1PA6DZBYopBpvJYZYzQFaqWOKyepLwWZKabJU+CJXN1GmBGoAGREQaAXxfrrOZdZzjqTXx+xNb+kVkelNsXsPl6RYXGEjMDN7a1BX+WVx6xFClX6wbdAhfEqPrfQxOZdZzjqTXx+xNb+lLWYQGgVBFW3aecQKIH/fVlxAy8rqX8la413s2+dYAbIKeIXw1eWING6ornM4VavrLkcJUCtHdvxCZWf6znTq7LoU7pggHfr6w3ayjy/MRaDSx6zD1BofcpootA83X27oLwQvHdXjEbKdH998IR1Xfg8n5CJTUfXBh5FYmPj77NAcXNVBb7ryzOMSmmUeSPFdR+Yva9vzFC2suzNsr9USK69H8RBmUpq+R992masY4x5+m7PZRBDwkH5jDnnFh4cHlAtolW0YPLXn3lsA7piiHo+p8TGF2z5Rr1DdETWVu4GxDHHw5xVbe+uo9anT00lLL3nx/wAmLpdjrzmAt3l9vf8AxCNIxbv/AG//xAApEQEAAgECBAUFAQEAAAAAAAABABEhMUEQUWGRIDBxobFAgcHR8FDx/9oACAECAQE/EP8AetoFeRAMy6jNcIuBDYElMJp0O5zBsvyAKIqrNwgW64BFRnrNKKAJ0uLuAc4aoByiAMuu6Oz4F+A9iIJQ56y5cpW6r7Yh6cPmIw6J+vxNT2D4OGB9CAh5TI1vBVPDcRpVGzGPrCaKN5RhglVBvho49d+8T5wyfmBrLwfBOs7QoLyICuGKG038a4LRcxHAglNHlXX3hJNyXwNltG44ar8Sxqir7T9wDx1xX3lQHB5PBUpVH1gYCtEETFwKt5ltiuWb6HrLqqoCzZjFgY1C3nsT4ml6x0IaeNFhX5P6IW0gwrkhLbbg8AHaVByjg1GIoGhj4nsT4ml6x0IaeJUWwN3Vi6NZ5beukFbFwKLEADUPtuSonppFJUGX8f8AY0zeV/KSqRxx6E8VRXBBKZqgQ7YQfaukJphvyTJNfLWLgkprnr/f2YWvHTPBMRoGC1W98LjVKGQ0PKFlpBEsibneVHdUuHYj2kwEKS95cxLR6D3fL735T0HhbOossR6qxfry2iSWi2Zlrl38wmhcMy3uPeHbHM/UapaesEcktVTH5/59voBtSKrrm5hKONVj6MMD63//xAAsEAEAAQMCBgICAgMBAQEAAAABEQAhMUFREGFxgZGhsfDB0TBAIFDh8WBw/9oACAEBAAE/EP8A9vRIASqwFB5BMTbh/wAHWhKSzJJ8HxWEzEcrUTR4it+VwBTe8DZd0n1U3dYLV1sJ4oMDSJIm48cyHlgpGONUjpIvopWEQJK/DuUIkmOI8MpuEbuxS9H20ViElsr0cP8ASSlDQ5FTvBTO5naBLIT3DSyQLX15oW6B3qRLpzxZ5hI8SNhITVME9IfNeB/sjPdF+CSgE+hYTpMPd4nzEAS8lraCrl3hXJUEmhr8ix0Ak7ZpEykHJIdrnjgsE0AyQEoJg5SEFIiQiWho9pgZEq0MW7aSf6M25oC4JEOzPalDFiNkPCPZviBPgXk4tawH7ahoCbw2U56tIIiKYviBAjAstN6k20PTiJ26GIEfMcDv2xJ3l6b1ltsuWC9ge/DlQn1SoozF1Lnz8UpKi/8AQigEKAEJRHfB0rfAfij8f0bRcbwbKoTUEuGFiWiMRO7o0V5EBuAz2io4c4TPZoDqSqzwIhmH5aNDcu4boYDMDfWlqbvSbBAXDKMC9KZhMS/VX8cHwugDWnl1JrXisUpdMFMB7KiI5u1OS+6cxw5/n2oLJiuVi9eTQFp+QmQl8iOtEACYkJaFzI3JyxX2qJfn/KKVNW9tDnt/E+0dfAUoGpUlK3dVqFlaiwmHtWZYZi7YjyVCMWEXvTkEE2UZ+Cs1EcGLcNfhShtQ0qTUKJJ0y2XeFCg2PKWgKlcu0IwpTKytSBMmGrJQAcpqGAeLA5x0LKROSXwEjW4O9NcM8tQue/moBCaRkEJzrT1bY5UK46f5ooJ6ntWqNQ1SXlnyVHpf1Gz2WhEERHCf5fS7qAXcbD/wnyUKEJjBcgOSRczQgsTKUBKNPgpKZT+ymKiKIoYmOrUMM9DLHIX8zSA2LCgYF8jIZq2rAZmMSUZUovIL4oY3N+KG5CeDXrfmvpOfH5FfVbtSEWaOqD90M52ApyZj4a9Q+a0Xewh+at4+HZ/iFSDf+ytUZrwvqbPqiwaGTg+PDwBcE8Pq91DGSGmomXoDxUuZjEgwQn2aXX6k/wAn21HJiFrp2M3cNRQesUonHxTLN+9jQA51ZvWLPel+rATBDcJW5FCSb7LRAswBm09KnYMEmEb/AJr1vzX0m7x+dX0W7UDDInoK/JSaF4uj6x80BlGOt34oDl8HZPw/kWBGD1XTZD3aARkgzMbw0RImWLvV1ofzhNG3xEQJ4oADoCIGrWoIQrFa761cu26BIr0XtyoQWh+/dKnX39/dco7ff1SFyDz+/upQieSTQCg89xS0lG72rUxkBokHTqI1EWVUiW5LV8XILGdYxhpVBLIKdRakvonaCyZr6jepKHxxB+KsYCGVg2NgqdMLSJF7Mnw1DiyNYVFwh6saww/xhbnDXSPMHsUqiysvE33J4nYPmnHxlDMrp2mKTI31tfKtQVEkfFPnM1a0d+ZZrVKp4QNh1KdtRu3W4dlCWbVM39/f3XL797VOvv7+6AlBOlOq0JxdT6x2qFWDieqiwows1iY+Wm83UjK0BwBYUfdbtLJJKVF1fzSO5F9w8XzS2AurHpKJOw9Esf4pK1Y/7/upcL1fwfxNMhvKh8PFpsO5R+FQwIFAGgfTisCqAZqeCC6xoHex34ZZFDQLY6ukPbNMQlRkYus3WDvQElSEDW5HPJprcikunogk8O501bqWXQ03nuBByB7KZ52DwM9C0ai/Op5JgHJf3jvU8aWYw9qiNnqCKag8YmxOe3CFwFAzJU5Uoq7tEwgQxsK9L46LQrJ0tOBUGEA3RSyS5PP/ABSbJW929lKNlU0qoW70v7qRg++PB/E1ZdKAT3Zi0BKIYpgNmk3Yc6cb9R7zPqat/J0C/l+DgXglA8QfLBSBxONmiW5Oqm9N2W7RJJCnIpMdp4Ha2VQBSY4acPaNDAv06puMjv0pAWSxn1cjtFE/IEFppCIdL87FbCu+Qye6ETDU9pjvFMAziiREljAvXsPlx9P4+Nb1nx/DmsmVvZQQSGHEVM8MJdDMNOEIlG7snBgGFcaLdewFGuHI0CnQE3IJtZE6z2al0AJotJgixqw5609rnERIuKWk81ixZAyl5eINqL84aEpCCQJc5rU3FIBie9FY9AS7DRnuYvZq/uIDdag6gVGYEMtgt1QD5bMSEhjNaF7578bT1xSxg8xT38Eh0J/FIiSrK17D5cfT+PjW9Z8fyqSEkkadKRTSQY+c+6v2h0k3jvREJQli9FJIEEJikjgWkAclbdZaiyxPSQYtrgZzih04GuQkUME9eWp32MuUJJqhBcllKBCAgDAVPzkiRxYwXNUq2f2ZskaWLBPOlUpVWVXNKRQwdmx5Ae/HG0RF6fL4qdT7h924ew+XH6vLxres+P5sSOlsavYqMoADkWK5sny1B6yRW1OkyQMMCXAmSSmAKEoJ1aCgF5Fp3jfnUTm0KZHu398R9xEErtGo7U+2QUkvCQiw0AUSb55FgOk1JS44AQyyKy4Ci8atCEEaLDyxStw+iGSh8uX4pZOSE6cL2Hy4+n8fGt6z4/ma5T7er8eaAQFgigRkUqSoWzDL3dqekQJAQlSwtjF3emmlrMWD4mPNSseQkm4dChb8CNTDwiuJCyy8vDnVrBmOoknpr0aaUpMUefZdNCO9SYhEpFLBGSfZUehpyIPimhJtGxg81bbFtSRIlgjvOBWiK/doRRtmbVaxekq9AAyeijYJI12tozFR8UGTlUQQ3P5DdkgogrPnO/3ellSLDUQl7ZtehcAebjDCN4eVXkAxBG5DfNX0Dhxcis7oVHw+FLdEZrD98w2EmxGKkPJkiKdI1byrPhQ7OUxXZHku4bLS455gXWLneKbWepbwngoFWA1pp6YeVQTBGFoT60wWZEM2qDoJmOKAFAICIgpQwrQL1iwHJp0CILbG1ZWZjL10lSU3IfFN/M1FZ9AfyYSMzfV/HdqOOblAUiByDmOaIuwiBPwQRqofpJAJuy7ebTVZCFOlgslmW9ko0zgJTEwNxts1NyUQIoAtrn3wVygDKmRNp1oBYEIUa02sWylGr3a7X5UldIuiILdlE61EVpSIEjfk0rESJ2iX1Sd456q0G2n9Ua4QObWDKBd9V71jg+ivNheuj3oa29lx1Lz4KRpSETt1cRGtnvU5dDS2x1G6pFi8eW6ImN9in8I4a7AZ6z5oDqtOuyNOPJYreIMSymHlUK8iQmzfRiY5xWpX8g4SJhGcuKDkIAQAaVL5kdzd9BUbHf8Ax/W+ZAll7HzVl9bKhEWtvEodAu1OdggoNBDH21DlyNcDs34AIANngzyXFCQJk5LUsuew9IpGiIK+6tDkmXTenKgBgbABgC0BiOOV5KlQZQ9ZfqKMp1SdNP6pUywDVagTW8NTL5rkmX61Fc9gHlSsWA6KrLVeUfV38BSoXE0GMoEKevWssdgI7P8Aqog8gkz2NWeE4GlGZGT4qYf1GTqx2FAUjZTkBnuqVI5gXCZGgzgxRlv0xOsYeEGMLv0PpTJL9sweqAhYCD+rsSEtX+j8Vfha5U2iwWAle1DY6oJbpQQLCSQL0DQlIlaYyzsrRukBkntlYP8Awp+OapcoTAHsoUV0AolgwjGid+BhbJbrIsd6NFhgpbRW75pYNxkIRMfLUGxXsB53VARlmjIaYnMQtCoG8PD8pFtvy+KF3Q9v/P60+IF1uTybPqlXblIjBbXnPAAcu65e4/KSj+ymRF4mNGo8qnVFtlOqEDmBzrUWvWzFtEZMUUtlnI2IQi2YW2aHL5U7dYW0480vmcBh07gzuX0Zp+QzLKtHZ+axk/RuzRBKIJBUAqCWYIoNeFuulTDkvasfmnDIy7/1lMNClADGSoIw/MUYEmoycIlNSxOo1pFgmCNkbXIk5WKaliFSWwjDkyU5VSTEstiGZ0ozi8tlhPlXLTtgcm0uDrR5yPHDiwMPpKFMpXaoYuHFAOz/AMvzUPM2HTL3Pn+uURyt0peK5xrpShLOkD4qNAOg/qoAHpL/AIQuVDGR0TmVt0BhNLbB8tGcPv0DYQXuQ9lRxcsCECI7MbUbaUwIEpkgrRim1HIZFZbGKSgmMt3L/XAQBNmrxNcsUslCbfqnRAGljw4oAG+qh8P7o8Cdoe7UWYnWke1AyhtMPj/BlZmYpwCRlvCjtSZFzaQQShYORlqBGPJP/JqynCjcL/MVJuYl6/2gYPqqZLrZpcgWuanDfYajLRr+Q/VQYrYw8l6CIrykeqNkhuPGFmwl6v8AyoVbJ6s/rx/exjO5Zpjw2zUyETdI91FKh290nGOd7zSIqYEEzzH91iAZzu05qe0TL5FahETpNv8AQIJCSc6xxOiix9j9UvIHlZrBnRzQ6gba9sUIuBH+jKgxzKvCPbJQ5zG6b/8A0x/oP//Z\"></p>', '2018-12-04', 'IkdlRVhLIi9yynvZAyGyN4rM.jpg');
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `recuperacion`
  --
  
  CREATE TABLE `Recuperacion` (
    `idUsuario` int(11) NOT NULL,
    `Token` varchar(45) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `regions`
  --
  
  CREATE TABLE `Regions` (
    `id` int(11) UNSIGNED NOT NULL,
    `name` varchar(255) NOT NULL,
    `code` varchar(10) NOT NULL,
    `country_id` smallint(5) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
  
  --
  -- Volcado de datos para la tabla `regions`
  --
  
  INSERT INTO `Regions` (`id`, `name`, `code`, `country_id`) VALUES
  (1, 'Sant Julia de Loria', '06', 1),
  (2, 'Andorra la Vella', '07', 1),
  (3, 'La Massana', '04', 1),
  (4, 'Ordino', '05', 1),
  (5, 'Canillo', '02', 1),
  (6, 'Encamp', '03', 1),
  (7, 'Escaldes-Engordany', '08', 1),
  (8, 'Fujairah', '04', 2),
  (9, 'Abu Dhabi', '01', 2),
  (10, 'Dubai', '03', 2),
  (11, 'Ras Al Khaimah', '05', 2),
  (12, 'Umm Al Quwain', '07', 2),
  (13, 'Sharjah', '06', 2),
  (14, 'Ajman', '02', 2),
  (15, 'Paktika', '29', 3),
  (16, 'Farah', '06', 3),
  (17, 'Helmand', '10', 3),
  (18, 'Kondoz', '24', 3),
  (19, 'Bamian', '05', 3),
  (20, 'Ghowr', '09', 3),
  (21, 'Laghman', '35', 3),
  (22, '', '22', 3),
  (23, 'Ghazni', '08', 3),
  (24, 'Vardak', '27', 3),
  (25, 'Oruzgan', '39', 3),
  (26, 'Zabol', '28', 3),
  (27, 'Badghis', '02', 3),
  (28, 'Badakhshan', '01', 3),
  (29, 'Faryab', '07', 3),
  (30, 'Takhar', '26', 3),
  (31, 'Lowgar', '17', 3),
  (32, 'Herat', '11', 3),
  (33, 'Daykondi', '41', 3),
  (34, 'Sar-e Pol', '33', 3),
  (35, 'Balkh', '30', 3),
  (36, 'Kabol', '13', 3),
  (37, 'Nimruz', '19', 3),
  (38, 'Kandahar', '23', 3),
  (39, 'Khowst', '37', 3),
  (40, '', '20', 3),
  (41, 'Kapisa', '14', 3),
  (42, 'Nangarhar', '18', 3),
  (43, 'Samangan', '32', 3),
  (44, 'Paktia', '36', 3),
  (45, 'Baghlan', '03', 3),
  (46, 'Jowzjan', '31', 3),
  (47, 'Konar', '34', 3),
  (48, 'Nurestan', '38', 3),
  (49, '', '16', 3),
  (50, '', '21', 3),
  (51, '', '15', 3),
  (52, 'Panjshir', '42', 3),
  (53, 'Saint John', '04', 4),
  (54, 'Saint Paul', '06', 4),
  (55, 'Saint George', '03', 4),
  (56, 'Saint Peter', '07', 4),
  (57, 'Saint Mary', '05', 4),
  (58, 'Barbuda', '01', 4),
  (59, 'Saint Philip', '08', 4),
  (60, '', '00', 5),
  (61, 'Vlore', '51', 6),
  (62, 'Korce', '46', 6),
  (63, 'Shkoder', '49', 6),
  (64, 'Durres', '42', 6),
  (65, 'Elbasan', '43', 6),
  (66, 'Kukes', '47', 6),
  (67, 'Fier', '44', 6),
  (68, 'Berat', '40', 6),
  (69, 'Gjirokaster', '45', 6),
  (70, 'Tirane', '50', 6),
  (71, 'Lezhe', '48', 6),
  (72, 'Diber', '41', 6),
  (73, 'Aragatsotn', '01', 7),
  (74, 'Ararat', '02', 7),
  (75, 'Kotayk\'', '05', 7),
  (76, 'Tavush', '09', 7),
  (77, 'Syunik\'', '08', 7),
  (78, 'Geghark\'unik\'', '04', 7),
  (79, 'Vayots\' Dzor', '10', 7),
  (80, 'Lorri', '06', 7),
  (81, 'Armavir', '03', 7),
  (82, 'Yerevan', '11', 7),
  (83, 'Shirak', '07', 7),
  (84, '', '00', 8),
  (85, 'Benguela', '01', 9),
  (86, 'Uige', '15', 9),
  (87, 'Bengo', '19', 9),
  (88, 'Cuanza Norte', '05', 9),
  (89, 'Malanje', '12', 9),
  (90, 'Cuanza Sul', '06', 9),
  (91, 'Huambo', '08', 9),
  (92, 'Moxico', '14', 9),
  (93, 'Cuando Cubango', '04', 9),
  (94, 'Bie', '02', 9),
  (95, 'Huila', '09', 9),
  (96, 'Lunda Sul', '18', 9),
  (97, '', '10', 9),
  (98, 'Zaire', '16', 9),
  (99, 'Cunene', '07', 9),
  (100, 'Lunda Norte', '17', 9),
  (101, 'Namibe', '13', 9),
  (102, 'Cabinda', '03', 9),
  (103, 'Buenos Aires', '01', 10),
  (104, 'Cordoba', '05', 10),
  (105, 'Entre Rios', '08', 10),
  (106, 'Salta', '17', 10),
  (107, 'Jujuy', '10', 10),
  (108, 'La Pampa', '11', 10),
  (109, 'Mendoza', '13', 10),
  (110, 'Misiones', '14', 10),
  (111, 'Santa Cruz', '20', 10),
  (112, 'Santa Fe', '21', 10),
  (113, 'Tucuman', '24', 10),
  (114, 'Corrientes', '06', 10),
  (115, 'San Juan', '18', 10),
  (116, 'Santiago del Estero', '22', 10),
  (117, 'Catamarca', '02', 10),
  (118, 'Neuquen', '15', 10),
  (119, 'Distrito Federal', '07', 10),
  (120, 'La Rioja', '12', 10),
  (121, 'Rio Negro', '16', 10),
  (122, 'Chubut', '04', 10),
  (123, 'San Luis', '19', 10),
  (124, 'Tierra del Fuego', '23', 10),
  (125, 'Formosa', '09', 10),
  (126, 'Chaco', '03', 10),
  (127, 'Niederosterreich', '03', 11),
  (128, 'Salzburg', '05', 11),
  (129, 'Oberosterreich', '04', 11),
  (130, 'Tirol', '07', 11),
  (131, 'Karnten', '02', 11),
  (132, 'Steiermark', '06', 11),
  (133, 'Vorarlberg', '08', 11),
  (134, 'Wien', '09', 11),
  (135, 'Burgenland', '01', 11),
  (136, 'New South Wales', '02', 12),
  (137, 'Tasmania', '06', 12),
  (138, 'Western Australia', '08', 12),
  (139, 'Queensland', '04', 12),
  (140, 'Victoria', '07', 12),
  (141, 'South Australia', '05', 12),
  (142, 'Northern Territory', '03', 12),
  (143, 'Australian Capital Territory', '01', 12),
  (144, '', '00', 12),
  (145, '', '00', 13),
  (146, 'Neftcala', '36', 14),
  (147, 'Xanlar', '62', 14),
  (148, 'Yevlax', '68', 14),
  (149, 'Agdas', '04', 14),
  (150, 'Sabirabad', '46', 14),
  (151, 'Yardimli', '66', 14),
  (152, 'Calilabad', '15', 14),
  (153, 'Saatli', '45', 14),
  (154, 'Saki', '47', 14),
  (155, 'Kurdamir', '27', 14),
  (156, 'Qazax', '40', 14),
  (157, 'Tovuz', '58', 14),
  (158, 'Samkir', '51', 14),
  (159, 'Agdam', '03', 14),
  (160, 'Qubadli', '43', 14),
  (161, 'Oguz', '37', 14),
  (162, 'Lacin', '28', 14),
  (163, 'Kalbacar', '26', 14),
  (164, 'Haciqabul', '23', 14),
  (165, 'Bilasuvar', '13', 14),
  (166, 'Balakan', '10', 14),
  (167, 'Naxcivan', '35', 14),
  (168, 'Qabala', '38', 14),
  (169, 'Agcabadi', '02', 14),
  (170, 'Samaxi', '50', 14),
  (171, 'Davaci', '17', 14),
  (172, 'Quba', '42', 14),
  (173, 'Qusar', '44', 14),
  (174, 'Imisli', '24', 14),
  (175, 'Abseron', '01', 14),
  (176, 'Xacmaz', '60', 14),
  (177, 'Cabrayil', '14', 14),
  (178, 'Ismayilli', '25', 14),
  (179, 'Goranboy', '21', 14),
  (180, 'Fuzuli', '18', 14),
  (181, 'Baki', '09', 14),
  (182, 'Beylaqan', '12', 14),
  (183, 'Daskasan', '16', 14),
  (184, 'Masalli', '32', 14),
  (185, 'Zaqatala', '70', 14),
  (186, 'Lankaran', '29', 14),
  (187, 'Lerik', '31', 14),
  (188, 'Ali Bayramli', '07', 14),
  (189, 'Qax', '39', 14),
  (190, 'Samux', '52', 14),
  (191, 'Zardab', '71', 14),
  (192, 'Gadabay', '19', 14),
  (193, 'Ucar', '59', 14),
  (194, 'Barda', '11', 14),
  (195, 'Siyazan', '53', 14),
  (196, 'Xocavand', '65', 14),
  (197, 'Zangilan', '69', 14),
  (198, 'Xizi', '63', 14),
  (199, 'Yevlax', '67', 14),
  (200, 'Agsu', '06', 14),
  (201, 'Qobustan', '41', 14),
  (202, 'Goycay', '22', 14),
  (203, 'Astara', '08', 14),
  (204, 'Xocali', '64', 14),
  (205, 'Xankandi', '61', 14),
  (206, 'Tartar', '57', 14),
  (207, 'Agstafa', '05', 14),
  (208, 'Salyan', '49', 14),
  (209, 'Susa', '55', 14),
  (210, 'Ganca', '20', 14),
  (211, 'Sumqayit', '54', 14),
  (212, 'Saki', '48', 14),
  (213, 'Naftalan', '34', 14),
  (214, 'Lankaran', '30', 14),
  (215, 'Mingacevir', '33', 14),
  (216, 'Susa', '56', 14),
  (217, 'Republika Srpska', '02', 15),
  (218, 'Federation of Bosnia and Herzegovina', '01', 15),
  (219, '', 'BD', 15),
  (220, 'Saint Joseph', '06', 16),
  (221, 'Saint Lucy', '07', 16),
  (222, 'Saint Thomas', '11', 16),
  (223, 'Saint James', '04', 16),
  (224, 'Saint John', '05', 16),
  (225, 'Saint Peter', '09', 16),
  (226, 'Christ Church', '01', 16),
  (227, 'Saint George', '03', 16),
  (228, 'Saint Michael', '08', 16),
  (229, 'Saint Andrew', '02', 16),
  (230, 'Saint Philip', '10', 16),
  (231, 'Khulna', '82', 17),
  (232, 'Rajshahi', '83', 17),
  (233, 'Dhaka', '81', 17),
  (234, '', '80', 17),
  (235, 'Barisal', '85', 17),
  (236, 'Sylhet', '86', 17),
  (237, 'Chittagong', '84', 17),
  (238, 'Oost-Vlaanderen', '08', 18),
  (239, 'West-Vlaanderen', '09', 18),
  (240, '', '02', 18),
  (241, 'Limburg', '05', 18),
  (242, 'Antwerpen', '01', 18),
  (243, 'Luxembourg', '06', 18),
  (244, 'Hainaut', '03', 18),
  (245, 'Liege', '04', 18),
  (246, 'Namur', '07', 18),
  (247, 'Brussels Hoofdstedelijk Gewest', '11', 18),
  (248, 'Vlaams-Brabant', '12', 18),
  (249, 'Brabant Wallon', '10', 18),
  (250, '', '38', 19),
  (251, 'Mouhoun', '63', 19),
  (252, 'Bam', '15', 19),
  (253, '', '37', 19),
  (254, '', '16', 19),
  (255, '', '24', 19),
  (256, '', '32', 19),
  (257, 'Tapoa', '42', 19),
  (258, 'Soum', '40', 19),
  (259, 'Leraba', '61', 19),
  (260, 'Noumbiel', '67', 19),
  (261, '', '30', 19),
  (262, 'Gnagna', '21', 19),
  (263, '', '31', 19),
  (264, '', '22', 19),
  (265, 'Yatenga', '76', 19),
  (266, 'Banwa', '46', 19),
  (267, 'Poni', '69', 19),
  (268, 'Loroum', '62', 19),
  (269, 'Kouritenga', '28', 19),
  (270, 'Tuy', '74', 19),
  (271, 'Kossi', '58', 19),
  (272, 'Passore', '34', 19),
  (273, 'Kenedougou', '54', 19),
  (274, 'Bale', '45', 19),
  (275, 'Bougouriba', '48', 19),
  (276, 'Houet', '51', 19),
  (277, 'Gourma', '50', 19),
  (278, 'Namentenga', '64', 19),
  (279, 'Sanmatenga', '70', 19),
  (280, '', '18', 19),
  (281, 'Ioba', '52', 19),
  (282, 'Ganzourgou', '20', 19),
  (283, 'Naouri', '65', 19),
  (284, 'Boulkiemde', '19', 19),
  (285, 'Zoundweogo', '44', 19),
  (286, 'Zondoma', '78', 19),
  (287, '', '39', 19),
  (288, '', '43', 19),
  (289, 'Komoe', '55', 19),
  (290, 'Yagha', '75', 19),
  (291, 'Komondjari', '56', 19),
  (292, 'Sourou', '73', 19),
  (293, 'Nayala', '66', 19),
  (294, 'Sissili', '72', 19),
  (295, 'Sanguie', '36', 19),
  (296, 'Oudalan', '33', 19),
  (297, 'Koulpelogo', '59', 19),
  (298, 'Ziro', '77', 19),
  (299, 'Kourweogo', '60', 19),
  (300, 'Oubritenga', '68', 19),
  (301, 'Seno', '71', 19),
  (302, 'Bazega', '47', 19),
  (303, 'Kadiogo', '53', 19),
  (304, 'Kompienga', '57', 19),
  (305, 'Boulgou', '49', 19),
  (306, 'Lovech', '46', 20),
  (307, 'Varna', '61', 20),
  (308, 'Burgas', '39', 20),
  (309, 'Razgrad', '52', 20),
  (310, 'Plovdiv', '51', 20),
  (311, 'Khaskovo', '43', 20),
  (312, 'Sofiya', '58', 20),
  (313, 'Silistra', '55', 20),
  (314, 'Vidin', '63', 20),
  (315, 'Montana', '47', 20),
  (316, 'Mikhaylovgrad', '33', 20),
  (317, 'Grad Sofiya', '42', 20),
  (318, 'Turgovishte', '60', 20),
  (319, 'Kurdzhali', '44', 20),
  (320, 'Dobrich', '40', 20),
  (321, 'Shumen', '54', 20),
  (322, 'Blagoevgrad', '38', 20),
  (323, 'Smolyan', '57', 20),
  (324, 'Stara Zagora', '59', 20),
  (325, 'Pazardzhik', '48', 20),
  (326, 'Ruse', '53', 20),
  (327, 'Vratsa', '64', 20),
  (328, 'Pleven', '50', 20),
  (329, 'Pernik', '49', 20),
  (330, 'Kyustendil', '45', 20),
  (331, 'Yambol', '65', 20),
  (332, 'Gabrovo', '41', 20),
  (333, 'Sliven', '56', 20),
  (334, 'Veliko Turnovo', '62', 20),
  (335, 'Jidd Hafs', '05', 21),
  (336, '', '03', 21),
  (337, 'Al Mintaqah ash Shamaliyah', '10', 21),
  (338, '', '07', 21),
  (339, 'Al Manamah', '02', 21),
  (340, 'Sitrah', '06', 21),
  (341, 'Al Mintaqah al Gharbiyah', '08', 21),
  (342, 'Mintaqat Juzur Hawar', '09', 21),
  (343, 'Al Hadd', '01', 21),
  (344, 'Al Mintaqah al Wusta', '11', 21),
  (345, 'Ar Rifa', '13', 21),
  (346, 'Madinat', '12', 21),
  (347, 'Karuzi', '14', 22),
  (348, 'Ruyigi', '21', 22),
  (349, 'Bubanza', '09', 22),
  (350, 'Bururi', '10', 22),
  (351, 'Makamba', '17', 22),
  (352, 'Kayanza', '15', 22),
  (353, '', '05', 22),
  (354, 'Rutana', '20', 22),
  (355, 'Muyinga', '18', 22),
  (356, 'Cibitoke', '12', 22),
  (357, 'Gitega', '13', 22),
  (358, 'Cankuzo', '11', 22),
  (359, 'Bujumbura', '02', 22),
  (360, 'Ngozi', '19', 22),
  (361, 'Kirundo', '16', 22),
  (362, 'Plateau', '17', 23),
  (363, 'Collines', '11', 23),
  (364, '', '04', 23),
  (365, '', '01', 23),
  (366, 'Oueme', '16', 23),
  (367, 'Zou', '18', 23),
  (368, '', '05', 23),
  (369, '', '02', 23),
  (370, 'Atlanyique', '09', 23),
  (371, 'Borgou', '10', 23),
  (372, 'Mono', '15', 23),
  (373, '', '03', 23),
  (374, 'Kouffo', '12', 23),
  (375, 'Donga', '13', 23),
  (376, 'Littoral', '14', 23),
  (377, 'Alibori', '07', 23),
  (378, 'Atakora', '08', 23),
  (379, 'Devonshire', '01', 24),
  (380, 'Paget', '04', 24),
  (381, 'Saint George\'s', '07', 24),
  (382, 'Smiths', '09', 24),
  (383, 'Hamilton', '03', 24),
  (384, 'Warwick', '11', 24),
  (385, 'Sandys', '08', 24),
  (386, 'Saint George', '06', 24),
  (387, 'Hamilton', '02', 24),
  (388, '', '00', 25),
  (389, 'Santa Cruz', '08', 26),
  (390, 'Pando', '06', 26),
  (391, 'Tarija', '09', 26),
  (392, 'La Paz', '04', 26),
  (393, 'Oruro', '05', 26),
  (394, 'Cochabamba', '02', 26),
  (395, 'Potosi', '07', 26),
  (396, 'Chuquisaca', '01', 26),
  (397, 'El Beni', '03', 26),
  (398, 'Santa Catarina', '26', 27),
  (399, 'Mato Grosso do Sul', '11', 27),
  (400, 'Rio Grande do Sul', '23', 27),
  (401, 'Espirito Santo', '08', 27),
  (402, 'Bahia', '05', 27),
  (403, 'Rondonia', '24', 27),
  (404, 'Minas Gerais', '15', 27),
  (405, 'Paraiba', '17', 27),
  (406, 'Amapa', '03', 27),
  (407, 'Amazonas', '04', 27),
  (408, 'Para', '16', 27),
  (409, 'Ceara', '06', 27),
  (410, 'Rio de Janeiro', '21', 27),
  (411, 'Goias', '29', 27),
  (412, 'Sao Paulo', '27', 27),
  (413, 'Parana', '18', 27),
  (414, 'Rio Grande do Norte', '22', 27),
  (415, 'Acre', '01', 27),
  (416, 'Piaui', '20', 27),
  (417, 'Pernambuco', '30', 27),
  (418, 'Mato Grosso', '14', 27),
  (419, 'Maranhao', '13', 27),
  (420, 'Tocantins', '31', 27),
  (421, 'Roraima', '25', 27),
  (422, 'Alagoas', '02', 27),
  (423, 'Sergipe', '28', 27),
  (424, 'Distrito Federal', '07', 27),
  (425, 'Acklins and Crooked Islands', '24', 28),
  (426, 'Mayaguana', '16', 28),
  (427, 'Long Island', '15', 28),
  (428, 'New Providence', '23', 28),
  (429, 'Exuma', '10', 28),
  (430, 'Bimini', '05', 28),
  (431, 'Governor\'s Harbour', '27', 28),
  (432, 'San Salvador and Rum Cay', '35', 28),
  (433, 'Fresh Creek', '26', 28),
  (434, 'Cat Island', '06', 28),
  (435, 'Nichollstown and Berry Islands', '32', 28),
  (436, 'Kemps Bay', '30', 28),
  (437, 'Freeport', '25', 28),
  (438, 'Rock Sound', '33', 28),
  (439, 'Harbour Island', '22', 28),
  (440, 'High Rock', '29', 28),
  (441, 'Green Turtle Cay', '28', 28),
  (442, 'Marsh Harbour', '31', 28),
  (443, 'Ragged Island', '18', 28),
  (444, 'Sandy Point', '34', 28),
  (445, 'Inagua', '13', 28),
  (446, 'Wangdi Phodrang', '22', 29),
  (447, 'Paro', '13', 29),
  (448, 'Daga', '08', 29),
  (449, 'Mongar', '12', 29),
  (450, 'Shemgang', '18', 29),
  (451, 'Thimphu', '20', 29),
  (452, 'Tashigang', '19', 29),
  (453, 'Chirang', '07', 29),
  (454, 'Geylegphug', '09', 29),
  (455, 'Samdrup', '17', 29),
  (456, 'Bumthang', '05', 29),
  (457, 'Samchi', '16', 29),
  (458, 'Tongsa', '21', 29),
  (459, 'Chhukha', '06', 29),
  (460, 'Pemagatsel', '14', 29),
  (461, 'Ha', '10', 29),
  (462, 'Punakha', '15', 29),
  (463, 'Lhuntshi', '11', 29),
  (464, 'Central', '01', 30),
  (465, 'South-East', '09', 30),
  (466, 'North-East', '08', 30),
  (467, 'North-West', '11', 30),
  (468, 'Ghanzi', '03', 30),
  (469, 'Kweneng', '06', 30),
  (470, 'Kgalagadi', '04', 30),
  (471, '', '00', 30),
  (472, 'Southern', '10', 30),
  (473, 'Kgatleng', '05', 30),
  (474, 'Homyel\'skaya Voblasts\'', '02', 31),
  (475, 'Minsk', '04', 31),
  (476, 'Brestskaya Voblasts\'', '01', 31),
  (477, 'Hrodzyenskaya Voblasts\'', '03', 31),
  (478, 'Mahilyowskaya Voblasts\'', '06', 31),
  (479, 'Vitsyebskaya Voblasts\'', '07', 31),
  (480, 'Toledo', '06', 32),
  (481, 'Cayo', '02', 32),
  (482, 'Stann Creek', '05', 32),
  (483, 'Corozal', '03', 32),
  (484, 'Orange Walk', '04', 32),
  (485, 'Belize', '01', 32),
  (486, '', '02', 33),
  (487, '', '11', 33),
  (488, '', '10', 33),
  (489, '', '01', 33),
  (490, '', '05', 33),
  (491, '', '08', 33),
  (492, '', '07', 33),
  (493, '', '12', 33),
  (494, '', '13', 33),
  (495, '', '14', 33),
  (496, '', '09', 33),
  (497, '', '04', 33),
  (498, '', '03', 33),
  (499, '', '00', 34),
  (500, 'Equateur', '02', 35),
  (501, 'Orientale', '09', 35),
  (502, '', '00', 35),
  (503, 'Nord-Kivu', '11', 35),
  (504, '', '07', 35),
  (505, 'Maniema', '10', 35),
  (506, 'Bandundu', '01', 35),
  (507, '', '03', 35),
  (508, 'Katanga', '05', 35),
  (509, 'Sud-Kivu', '12', 35),
  (510, 'Bas-Congo', '08', 35),
  (511, 'Kasai-Oriental', '04', 35),
  (512, 'Kinshasa', '06', 35),
  (513, 'Nana-Mambere', '09', 36),
  (514, 'Ouaka', '11', 36),
  (515, 'Haute-Kotto', '03', 36),
  (516, 'Sangha-Mbaere', '16', 36),
  (517, 'Bamingui-Bangoran', '01', 36),
  (518, 'Mbomou', '08', 36),
  (519, 'Basse-Kotto', '02', 36),
  (520, 'Kemo', '06', 36),
  (521, 'Haut-Mbomou', '05', 36),
  (522, 'Ouham-Pende', '13', 36),
  (523, 'Ouham', '12', 36),
  (524, 'Ombella-Mpoko', '17', 36),
  (525, 'Cuvette-Ouest', '14', 36),
  (526, 'Mambere-Kadei', '04', 36),
  (527, 'Lobaye', '07', 36),
  (528, '', '00', 36),
  (529, 'Nana-Grebizi', '15', 36),
  (530, 'Bangui', '18', 36),
  (531, '', '03', 37),
  (532, 'Plateaux', '08', 37),
  (533, 'Pool', '11', 37),
  (534, 'Sangha', '10', 37),
  (535, 'Lekoumou', '05', 37),
  (536, 'Likouala', '06', 37),
  (537, 'Kouilou', '04', 37),
  (538, 'Niari', '07', 37),
  (539, 'Bouenza', '01', 37),
  (540, 'Brazzaville', '12', 37),
  (541, 'Cuvette-Ouest', '14', 37),
  (542, 'Cuvette', '13', 37),
  (543, 'Thurgau', '19', 38),
  (544, 'Aargau', '01', 38),
  (545, 'Bern', '05', 38),
  (546, 'Zurich', '25', 38),
  (547, 'Fribourg', '06', 38),
  (548, 'Ausser-Rhoden', '02', 38),
  (549, 'Valais', '22', 38),
  (550, 'Uri', '21', 38),
  (551, 'Graubunden', '09', 38),
  (552, 'Ticino', '20', 38),
  (553, 'Luzern', '11', 38),
  (554, 'Obwalden', '14', 38),
  (555, 'Solothurn', '18', 38),
  (556, 'Basel-Stadt', '04', 38),
  (557, 'Inner-Rhoden', '10', 38),
  (558, 'Zug', '24', 38),
  (559, 'Vaud', '23', 38),
  (560, 'Jura', '26', 38),
  (561, 'Basel-Landschaft', '03', 38),
  (562, 'Schwyz', '17', 38),
  (563, 'Sankt Gallen', '15', 38),
  (564, 'Schaffhausen', '16', 38),
  (565, 'Glarus', '08', 38),
  (566, 'Geneve', '07', 38),
  (567, 'Neuchatel', '12', 38),
  (568, 'Nidwalden', '13', 38),
  (569, '', '00', 38),
  (570, '', '39', 39),
  (571, '', '61', 39),
  (572, '', '58', 39),
  (573, '', '62', 39),
  (574, '', '67', 39),
  (575, '', '16', 39),
  (576, '', '30', 39),
  (577, '', '05', 39),
  (578, '', '59', 39),
  (579, 'Vallee du Bandama', '90', 39),
  (580, '', '37', 39),
  (581, 'N\'zi-Comoe', '86', 39),
  (582, '', '06', 39),
  (583, '', '20', 39),
  (584, '', '42', 39),
  (585, 'Moyen-Comoe', '85', 39),
  (586, '', '64', 39),
  (587, 'Lagunes', '82', 39),
  (588, 'Zanzan', '92', 39),
  (589, 'Sud-Comoe', '89', 39),
  (590, 'Lacs', '81', 39),
  (591, '', '18', 39),
  (592, '', '63', 39),
  (593, '', '54', 39),
  (594, '', '68', 39),
  (595, '', '66', 39),
  (596, '', '70', 39),
  (597, '', '51', 39),
  (598, 'Fromager', '79', 39),
  (599, '', '25', 39),
  (600, 'Agneby', '74', 39),
  (601, 'Bas-Sassandra', '76', 39),
  (602, '', '03', 39),
  (603, 'Marahoue', '83', 39),
  (604, '', '17', 39),
  (605, '', '11', 39),
  (606, '', '41', 39),
  (607, '', '26', 39),
  (608, 'Bafing', '75', 39),
  (609, '', '47', 39),
  (610, '', '46', 39),
  (611, '', '23', 39),
  (612, '', '21', 39),
  (613, '', '14', 39),
  (614, 'Savanes', '87', 39),
  (615, '', '07', 39),
  (616, '', '69', 39),
  (617, '', '52', 39),
  (618, '', '12', 39),
  (619, 'Sud-Bandama', '88', 39),
  (620, 'Haut-Sassandra', '80', 39),
  (621, 'Moyen-Cavally', '84', 39),
  (622, 'Dix-Huit Montagnes', '78', 39),
  (623, 'Denguele', '77', 39),
  (624, 'Worodougou', '91', 39),
  (625, '', '00', 40),
  (626, 'Bio-Bio', '06', 41),
  (627, 'Maule', '11', 41),
  (628, 'Los Lagos', '09', 41),
  (629, 'Tarapaca', '13', 41),
  (630, 'Valparaiso', '01', 41),
  (631, 'Atacama', '05', 41),
  (632, 'Coquimbo', '07', 41),
  (633, 'Libertador General Bernardo O\'Higgins', '08', 41),
  (634, 'Antofagasta', '03', 41),
  (635, 'Araucania', '04', 41),
  (636, 'Aisen del General Carlos Ibanez del Campo', '02', 41),
  (637, 'Region Metropolitana', '12', 41),
  (638, 'Magallanes y de la Antartica Chilena', '10', 41),
  (639, 'Est', '04', 42),
  (640, 'Adamaoua', '10', 42),
  (641, 'Centre', '11', 42),
  (642, 'Sud', '14', 42),
  (643, 'Nord-Ouest', '07', 42),
  (644, 'Extreme-Nord', '12', 42),
  (645, 'Sud-Ouest', '09', 42),
  (646, 'Littoral', '05', 42),
  (647, 'Nord', '13', 42),
  (648, 'Ouest', '08', 42),
  (649, 'Sichuan', '32', 43),
  (650, 'Xinjiang', '13', 43),
  (651, 'Nei Mongol', '20', 43),
  (652, 'Yunnan', '29', 43),
  (653, 'Guizhou', '18', 43),
  (654, 'Heilongjiang', '08', 43),
  (655, 'Shandong', '25', 43),
  (656, 'Liaoning', '19', 43),
  (657, 'Shaanxi', '26', 43),
  (658, 'Qinghai', '06', 43),
  (659, 'Gansu', '15', 43),
  (660, 'Jiangsu', '04', 43),
  (661, 'Fujian', '07', 43),
  (662, 'Hunan', '11', 43),
  (663, 'Jiangxi', '03', 43),
  (664, 'Guangxi', '16', 43),
  (665, 'Zhejiang', '02', 43),
  (666, 'Hebei', '10', 43),
  (667, 'Hubei', '12', 43),
  (668, 'Anhui', '01', 43),
  (669, 'Tianjin', '28', 43),
  (670, 'Hainan', '31', 43),
  (671, 'Guangdong', '30', 43),
  (672, 'Xizang', '14', 43),
  (673, 'Jilin', '05', 43),
  (674, 'Chongqing', '33', 43),
  (675, 'Beijing', '22', 43),
  (676, 'Shanxi', '24', 43),
  (677, 'Shanghai', '23', 43),
  (678, 'Henan', '09', 43),
  (679, 'Ningxia', '21', 43),
  (680, 'Cundinamarca', '33', 44),
  (681, 'Norte de Santander', '21', 44),
  (682, 'Narino', '20', 44),
  (683, '', '18', 44),
  (684, 'Risaralda', '24', 44),
  (685, 'Antioquia', '02', 44),
  (686, 'Amazonas', '01', 44),
  (687, 'La Guajira', '17', 44),
  (688, 'Choco', '11', 44),
  (689, 'Cauca', '09', 44),
  (690, 'Valle del Cauca', '29', 44),
  (691, 'Arauca', '03', 44),
  (692, 'Meta', '19', 44),
  (693, 'Caqueta', '08', 44),
  (694, 'Casanare', '32', 44),
  (695, 'Vaupes', '30', 44),
  (696, 'Tolima', '28', 44),
  (697, 'Huila', '16', 44),
  (698, '', '05', 44),
  (699, 'Atlantico', '04', 44),
  (700, 'Cordoba', '12', 44),
  (701, 'Santander', '26', 44),
  (702, 'Cesar', '10', 44),
  (703, 'Sucre', '27', 44),
  (704, '', '06', 44),
  (705, 'Putumayo', '22', 44),
  (706, '', '07', 44),
  (707, 'Guaviare', '14', 44),
  (708, 'San Andres y Providencia', '25', 44),
  (709, 'Vichada', '31', 44),
  (710, 'Quindio', '23', 44),
  (711, 'Guainia', '15', 44),
  (712, 'Distrito Especial', '34', 44),
  (713, 'Guanacaste', '03', 45),
  (714, 'Limon', '06', 45),
  (715, 'Puntarenas', '07', 45),
  (716, 'Alajuela', '01', 45),
  (717, 'Heredia', '04', 45),
  (718, 'San Jose', '08', 45),
  (719, 'Cartago', '02', 45),
  (720, 'Cienfuegos', '08', 46),
  (721, 'La Habana', '11', 46),
  (722, 'Santiago de Cuba', '15', 46),
  (723, 'Camaguey', '05', 46),
  (724, 'Ciudad de la Habana', '02', 46),
  (725, 'Villa Clara', '16', 46),
  (726, 'Pinar del Rio', '01', 46),
  (727, 'Matanzas', '03', 46),
  (728, 'Guantanamo', '10', 46),
  (729, 'Las Tunas', '13', 46),
  (730, 'Ciego de Avila', '07', 46),
  (731, 'Sancti Spiritus', '14', 46),
  (732, 'Holguin', '12', 46),
  (733, 'Granma', '09', 46),
  (734, 'Isla de la Juventud', '04', 46),
  (735, 'Sao Domingos', '17', 47),
  (736, '', '00', 47),
  (737, '', '00', 48),
  (738, 'Limassol', '05', 49),
  (739, 'Nicosia', '04', 49),
  (740, 'Paphos', '06', 49),
  (741, 'Famagusta', '01', 49),
  (742, 'Larnaca', '03', 49),
  (743, 'Kyrenia', '02', 49),
  (744, 'Karlovarsky kraj', '81', 50),
  (745, 'Pardubicky kraj', '86', 50),
  (746, '', '30', 50),
  (747, 'Jihomoravsky kraj', '78', 50),
  (748, 'Jihocesky kraj', '79', 50),
  (749, 'Olomoucky kraj', '84', 50),
  (750, 'Moravskoslezsky kraj', '85', 50),
  (751, '', '70', 50),
  (752, 'Kralovehradecky kraj', '82', 50),
  (753, 'Ustecky kraj', '89', 50),
  (754, 'Stredocesky kraj', '88', 50),
  (755, 'Vysocina', '80', 50),
  (756, 'Plzensky kraj', '87', 50),
  (757, '', '33', 50),
  (758, '', '21', 50),
  (759, '', '20', 50),
  (760, 'Zlinsky kraj', '90', 50),
  (761, 'Hlavni mesto Praha', '52', 50),
  (762, '', '45', 50),
  (763, 'Liberecky kraj', '83', 50),
  (764, '', '23', 50),
  (765, '', '41', 50),
  (766, '', '61', 50),
  (767, '', '36', 50),
  (768, '', '39', 50),
  (769, '', '37', 50),
  (770, '', '73', 50),
  (771, '', '00', 50),
  (772, '', '24', 50),
  (773, 'Nordrhein-Westfalen', '07', 51),
  (774, 'Baden-Wurttemberg', '01', 51),
  (775, 'Bayern', '02', 51),
  (776, 'Rheinland-Pfalz', '08', 51),
  (777, 'Niedersachsen', '06', 51),
  (778, 'Schleswig-Holstein', '10', 51),
  (779, 'Brandenburg', '11', 51),
  (780, 'Sachsen-Anhalt', '14', 51),
  (781, 'Sachsen', '13', 51),
  (782, 'Thuringen', '15', 51),
  (783, 'Hessen', '05', 51),
  (784, 'Mecklenburg-Vorpommern', '12', 51),
  (785, 'Hamburg', '04', 51),
  (786, 'Berlin', '16', 51),
  (787, 'Saarland', '09', 51),
  (788, 'Bremen', '03', 51),
  (789, 'Ali Sabieh', '01', 52),
  (790, 'Tadjoura', '05', 52),
  (791, '', '02', 52),
  (792, 'Obock', '04', 52),
  (793, '', '03', 52),
  (794, 'Arta', '08', 52),
  (795, 'Dikhil', '06', 52),
  (796, 'Syddanmark', '21', 53),
  (797, 'Midtjylland', '18', 53),
  (798, 'Nordjylland', '19', 53),
  (799, 'Sjelland', '20', 53),
  (800, 'Hovedstaden', '17', 53),
  (801, 'Saint Andrew', '02', 54),
  (802, 'Saint David', '03', 54),
  (803, 'Saint Joseph', '06', 54),
  (804, 'Saint George', '04', 54),
  (805, 'Saint Patrick', '09', 54),
  (806, 'Saint Peter', '11', 54),
  (807, 'Saint John', '05', 54),
  (808, 'Saint Mark', '08', 54),
  (809, 'Saint Paul', '10', 54),
  (810, 'Saint Luke', '07', 54),
  (811, 'Sanchez Ramirez', '21', 55),
  (812, 'Espaillat', '08', 55),
  (813, 'Duarte', '06', 55),
  (814, 'Samana', '20', 55),
  (815, 'Maria Trinidad Sanchez', '14', 55),
  (816, 'La Romana', '12', 55),
  (817, 'Azua', '01', 55),
  (818, 'San Cristobal', '33', 55),
  (819, 'El Seibo', '28', 55),
  (820, 'Monte Plata', '32', 55),
  (821, 'Distrito Nacional', '05', 55),
  (822, 'Elias Pina', '11', 55),
  (823, 'Santiago', '25', 55),
  (824, 'Santiago Rodriguez', '26', 55),
  (825, 'Peravia', '17', 55),
  (826, 'Monte Cristi', '15', 55),
  (827, 'Salcedo', '19', 55),
  (828, 'Puerto Plata', '18', 55),
  (829, 'San Pedro De Macoris', '24', 55),
  (830, 'Pedernales', '16', 55),
  (831, 'Independencia', '09', 55),
  (832, 'La Vega', '30', 55),
  (833, 'Dajabon', '04', 55),
  (834, 'Hato Mayor', '29', 55),
  (835, 'Barahona', '03', 55),
  (836, 'San Juan', '23', 55),
  (837, 'La Altagracia', '10', 55),
  (838, 'Valverde', '27', 55),
  (839, 'Baoruco', '02', 55),
  (840, 'Monsenor Nouel', '31', 55),
  (841, 'Ain Temouchent', '36', 56),
  (842, 'Oran', '09', 56),
  (843, 'Medea', '06', 56),
  (844, 'Chlef', '41', 56),
  (845, 'Bechar', '38', 56),
  (846, 'Tamanghasset', '53', 56),
  (847, 'Bejaia', '18', 56),
  (848, 'Tizi Ouzou', '14', 56),
  (849, 'Boumerdes', '40', 56),
  (850, 'Ain Defla', '35', 56),
  (851, 'Annaba', '37', 56),
  (852, 'Setif', '12', 56),
  (853, 'Relizane', '51', 56),
  (854, 'Mascara', '26', 56),
  (855, 'Mostaganem', '07', 56),
  (856, 'Tiaret', '13', 56),
  (857, 'Bordj Bou Arreridj', '39', 56),
  (858, 'Tipaza', '55', 56),
  (859, '', '00', 56),
  (860, 'Bouira', '21', 56),
  (861, 'Tissemsilt', '56', 56),
  (862, 'Jijel', '24', 56),
  (863, 'Saida', '10', 56),
  (864, 'Illizi', '46', 56),
  (865, 'Tlemcen', '15', 56),
  (866, 'Adrar', '34', 56),
  (867, 'Laghouat', '25', 56),
  (868, 'Constantine', '04', 56),
  (869, 'Khenchela', '47', 56),
  (870, 'Batna', '03', 56),
  (871, 'Alger', '01', 56),
  (872, 'M\'sila', '27', 56),
  (873, 'Skikda', '31', 56),
  (874, 'Oum el Bouaghi', '29', 56),
  (875, 'Naama', '49', 56),
  (876, 'Sidi Bel Abbes', '30', 56),
  (877, 'Mila', '48', 56),
  (878, 'Ouargla', '50', 56),
  (879, 'Djelfa', '22', 56),
  (880, 'El Bayadh', '42', 56),
  (881, 'Souk Ahras', '52', 56),
  (882, 'El Oued', '43', 56),
  (883, 'Blida', '20', 56),
  (884, 'Biskra', '19', 56),
  (885, 'Tebessa', '33', 56),
  (886, 'Guelma', '23', 56),
  (887, 'Tindouf', '54', 56),
  (888, 'Ghardaia', '45', 56),
  (889, 'Manabi', '14', 57),
  (890, 'Zamora-Chinchipe', '20', 57),
  (891, 'Morona-Santiago', '15', 57),
  (892, 'El Oro', '08', 57),
  (893, 'Azuay', '02', 57),
  (894, 'Sucumbios', '22', 57),
  (895, 'Guayas', '10', 57),
  (896, 'Los Rios', '13', 57),
  (897, 'Loja', '12', 57),
  (898, 'Chimborazo', '06', 57),
  (899, 'Tungurahua', '19', 57),
  (900, 'Esmeraldas', '09', 57),
  (901, 'Pichincha', '18', 57),
  (902, 'Imbabura', '11', 57),
  (903, 'Cotopaxi', '07', 57),
  (904, 'Carchi', '05', 57),
  (905, 'Napo', '23', 57),
  (906, 'Canar', '04', 57),
  (907, 'Pastaza', '17', 57),
  (908, 'Orellana', '24', 57),
  (909, 'Bolivar', '03', 57),
  (910, 'Galapagos', '01', 57),
  (911, 'Harjumaa', '01', 58),
  (912, 'Tartumaa', '18', 58),
  (913, 'Hiiumaa', '02', 58),
  (914, 'Raplamaa', '13', 58),
  (915, 'Valgamaa', '19', 58),
  (916, 'Laanemaa', '07', 58),
  (917, 'Polvamaa', '12', 58),
  (918, 'Parnumaa', '11', 58),
  (919, 'Laane-Virumaa', '08', 58),
  (920, 'Jarvamaa', '04', 58),
  (921, 'Viljandimaa', '20', 58),
  (922, 'Saaremaa', '14', 58),
  (923, 'Jogevamaa', '05', 58),
  (924, 'Ida-Virumaa', '03', 58),
  (925, 'Vorumaa', '21', 58),
  (926, 'Ash Sharqiyah', '14', 59),
  (927, 'Al Gharbiyah', '05', 59),
  (928, 'Ad Daqahliyah', '01', 59),
  (929, 'Al Jizah', '08', 59),
  (930, 'Al Minya', '10', 59),
  (931, 'Kafr ash Shaykh', '21', 59),
  (932, 'Al Buhayrah', '03', 59),
  (933, 'Qina', '23', 59),
  (934, 'Al Qahirah', '11', 59),
  (935, 'Al Iskandariyah', '06', 59),
  (936, 'Al Fayyum', '04', 59),
  (937, 'Asyut', '17', 59),
  (938, 'Al Minufiyah', '09', 59),
  (939, 'Bani Suwayf', '18', 59),
  (940, 'Al Qalyubiyah', '12', 59),
  (941, 'Aswan', '16', 59),
  (942, 'Shamal Sina\'', '27', 59),
  (943, 'Suhaj', '24', 59),
  (944, 'Janub Sina\'', '26', 59),
  (945, 'Al Bahr al Ahmar', '02', 59),
  (946, 'Al Isma\'iliyah', '07', 59),
  (947, 'Dumyat', '20', 59),
  (948, 'Matruh', '22', 59),
  (949, 'As Suways', '15', 59),
  (950, 'Al Wadi al Jadid', '13', 59),
  (951, 'Bur Sa\'id', '19', 59),
  (952, '', '00', 60),
  (953, '', '00', 61),
  (954, 'Aragon', '52', 62),
  (955, 'Galicia', '58', 62),
  (956, 'Castilla y Leon', '55', 62),
  (957, 'Extremadura', '57', 62),
  (958, 'Pais Vasco', '59', 62),
  (959, 'Cantabria', '39', 62),
  (960, 'Navarra', '32', 62),
  (961, 'Asturias', '34', 62),
  (962, 'La Rioja', '27', 62),
  (963, 'Castilla-La Mancha', '54', 62),
  (964, 'Murcia', '31', 62),
  (965, 'Andalucia', '51', 62),
  (966, 'Comunidad Valenciana', '60', 62),
  (967, 'Catalonia', '56', 62),
  (968, 'Canarias', '53', 62),
  (969, 'Madrid', '29', 62),
  (970, 'Islas Baleares', '07', 62),
  (971, '', '12', 63),
  (972, '', '08', 63),
  (973, '', '14', 63),
  (974, '', '10', 63),
  (975, '', '13', 63),
  (976, '', '01', 63),
  (977, '', '02', 63),
  (978, '', '11', 63),
  (979, '', '06', 63),
  (980, '', '09', 63),
  (981, '', '05', 63),
  (982, '', '07', 63),
  (983, '', '03', 63),
  (984, 'Oulu', '08', 64),
  (985, 'Western Finland', '15', 64),
  (986, 'Lapland', '06', 64),
  (987, 'Eastern Finland', '14', 64),
  (988, 'Southern Finland', '13', 64),
  (989, 'Aland', '01', 64),
  (990, '', '02', 64),
  (991, '', '00', 65),
  (992, 'Northern', '03', 65),
  (993, 'Western', '05', 65),
  (994, 'Central', '01', 65),
  (995, 'Eastern', '02', 65),
  (996, '', '00', 66),
  (997, 'Yap', '04', 67),
  (998, 'Pohnpei', '02', 67),
  (999, 'Chuuk', '03', 67),
  (1000, 'Kosrae', '01', 67),
  (1001, '', '00', 68),
  (1002, 'Aquitaine', '97', 69),
  (1003, 'Nord-Pas-de-Calais', 'B4', 69),
  (1004, 'Lorraine', 'B2', 69),
  (1005, 'Haute-Normandie', 'A7', 69),
  (1006, 'Picardie', 'B6', 69),
  (1007, 'Franche-Comte', 'A6', 69),
  (1008, 'Pays de la Loire', 'B5', 69),
  (1009, 'Champagne-Ardenne', 'A4', 69),
  (1010, 'Centre', 'A3', 69),
  (1011, 'Languedoc-Roussillon', 'A9', 69),
  (1012, 'Poitou-Charentes', 'B7', 69),
  (1013, 'Rhone-Alpes', 'B9', 69),
  (1014, 'Basse-Normandie', '99', 69),
  (1015, 'Ile-de-France', 'A8', 69),
  (1016, 'Bourgogne', 'A1', 69),
  (1017, 'Auvergne', '98', 69),
  (1018, 'Provence-Alpes-Cote d\'Azur', 'B8', 69),
  (1019, 'Corse', 'A5', 69),
  (1020, 'Alsace', 'C1', 69),
  (1021, 'Bretagne', 'A2', 69),
  (1022, 'Midi-Pyrenees', 'B3', 69),
  (1023, 'Limousin', 'B1', 69),
  (1024, 'Estuaire', '01', 70),
  (1025, 'Woleu-Ntem', '09', 70),
  (1026, 'Moyen-Ogooue', '03', 70),
  (1027, 'Ogooue-Maritime', '08', 70),
  (1028, 'Ogooue-Lolo', '07', 70),
  (1029, 'Ogooue-Ivindo', '06', 70),
  (1030, 'Haut-Ogooue', '02', 70),
  (1031, 'Ngounie', '04', 70),
  (1032, 'Nyanga', '05', 70),
  (1033, 'Worcestershire', 'Q4', 71),
  (1034, 'Hampshire', 'F2', 71),
  (1035, 'Herefordshire', 'F7', 71),
  (1036, 'Essex', 'E4', 71),
  (1037, 'Powys', 'Y8', 71),
  (1038, 'Monmouthshire', 'Y4', 71),
  (1039, 'Scottish Borders', 'T9', 71),
  (1040, 'Cumbria', 'C9', 71),
  (1041, 'Devon', 'D4', 71),
  (1042, 'Staffordshire', 'M9', 71),
  (1043, 'Dorset', 'D6', 71),
  (1044, 'Hertford', 'F8', 71),
  (1045, 'Cambridgeshire', 'C3', 71),
  (1046, 'Lancashire', 'H2', 71),
  (1047, 'Conwy', 'X8', 71),
  (1048, 'Ceredigion', 'X6', 71),
  (1049, 'Rhondda Cynon Taff', 'Y9', 71),
  (1050, 'Highland', 'V3', 71),
  (1051, 'Perth and Kinross', 'W1', 71),
  (1052, 'Caerphilly', 'X4', 71),
  (1053, 'Blaenau Gwent', 'X2', 71),
  (1054, 'Merthyr Tydfil', 'Y3', 71),
  (1055, 'Pembrokeshire', 'Y7', 71),
  (1056, 'Aberdeenshire', 'T6', 71),
  (1057, 'Gwynedd', 'Y2', 71),
  (1058, 'Aberdeen City', 'T5', 71),
  (1059, 'Fife', 'V1', 71),
  (1060, 'Neath Port Talbot', 'Y5', 71),
  (1061, 'Isle of Anglesey', 'X1', 71),
  (1062, 'Wokingham', 'Q2', 71),
  (1063, 'York', 'Q5', 71),
  (1064, 'Stirling', 'W6', 71),
  (1065, 'Carmarthenshire', 'X7', 71),
  (1066, 'Bridgend', 'X3', 71),
  (1067, 'East Lothian', 'U6', 71),
  (1068, 'Angus', 'T7', 71),
  (1069, 'Moray', 'V6', 71),
  (1070, 'Torfaen', 'Z2', 71),
  (1071, 'Swansea', 'Z1', 71),
  (1072, 'Vale of Glamorgan', 'Z3', 71),
  (1073, 'Oxfordshire', 'K2', 71),
  (1074, 'Surrey', 'N7', 71),
  (1075, 'South Lanarkshire', 'W5', 71),
  (1076, 'Leicestershire', 'H5', 71),
  (1077, 'Wigan', 'P7', 71),
  (1078, 'Northamptonshire', 'J1', 71),
  (1079, 'Lincolnshire', 'H7', 71),
  (1080, 'Argyll and Bute', 'T8', 71),
  (1081, 'Northumberland', 'J6', 71),
  (1082, 'Norfolk', 'I9', 71),
  (1083, 'Solihull', 'M2', 71),
  (1084, 'Wrexham', 'Z4', 71),
  (1085, 'Cheshire', 'C5', 71),
  (1086, 'Shropshire', 'L6', 71),
  (1087, 'Banbridge', 'R2', 71),
  (1088, 'South Gloucestershire', 'M6', 71),
  (1089, 'West Lothian', 'W9', 71),
  (1090, '', '17', 71),
  (1091, 'Kent', 'G5', 71),
  (1092, 'Leeds', 'H3', 71),
  (1093, 'Somerset', 'M3', 71),
  (1094, 'Gloucestershire', 'E6', 71),
  (1095, 'Buckinghamshire', 'B9', 71),
  (1096, 'Coleraine', 'R6', 71),
  (1097, 'Craigavon', 'R8', 71),
  (1098, 'Antrim', 'Q6', 71),
  (1099, 'Limavady', 'S4', 71),
  (1100, 'Armagh', 'Q8', 71),
  (1101, 'Ballymena', 'Q9', 71),
  (1102, 'North Yorkshire', 'J7', 71),
  (1103, 'Sefton', 'L8', 71),
  (1104, 'Warwickshire', 'P3', 71),
  (1105, 'Derry', 'S6', 71),
  (1106, 'Eilean Siar', 'W8', 71),
  (1107, 'North Lanarkshire', 'V8', 71),
  (1108, 'Falkirk', 'U9', 71),
  (1109, 'Shetland Islands', 'W3', 71),
  (1110, 'Wiltshire', 'P8', 71),
  (1111, 'Durham', 'D8', 71),
  (1112, 'Darlington', 'D1', 71),
  (1113, 'Suffolk', 'N5', 71),
  (1114, 'Derbyshire', 'D3', 71),
  (1115, 'Walsall', 'O8', 71),
  (1116, 'Rotherham', 'L3', 71),
  (1117, 'West Dunbartonshire', 'W7', 71),
  (1118, 'East Sussex', 'E2', 71),
  (1119, 'Coventry', 'C7', 71),
  (1120, 'Derby', 'D2', 71),
  (1121, 'Southend-on-Sea', 'M5', 71),
  (1122, 'Clackmannanshire', 'U1', 71),
  (1123, 'Kirklees', 'G8', 71),
  (1124, 'St. Helens', 'N1', 71),
  (1125, 'Omagh', 'T3', 71),
  (1126, 'Cornwall', 'C6', 71),
  (1127, 'North Lincolnshire', 'J3', 71),
  (1128, 'Newry and Mourne', 'S9', 71),
  (1129, 'South Ayrshire', 'W4', 71),
  (1130, 'Isle of Wight', 'G2', 71),
  (1131, '', '43', 71),
  (1132, 'Dumfries and Galloway', 'U2', 71),
  (1133, 'Bedfordshire', 'A5', 71),
  (1134, 'Down', 'R9', 71),
  (1135, 'Dungannon', 'S1', 71),
  (1136, 'Renfrewshire', 'W2', 71),
  (1137, 'Leicester', 'H4', 71),
  (1138, 'Glasgow City', 'V2', 71),
  (1139, 'West Sussex', 'P6', 71),
  (1140, 'Warrington', 'P2', 71),
  (1141, 'Cookstown', 'R7', 71),
  (1142, 'North Ayrshire', 'V7', 71),
  (1143, 'Barnsley', 'A3', 71),
  (1144, 'Strabane', 'T4', 71),
  (1145, 'Doncaster', 'D5', 71),
  (1146, 'Ballymoney', 'R1', 71),
  (1147, 'Fermanagh', 'S2', 71),
  (1148, '', '87', 71),
  (1149, 'Nottingham', 'J8', 71),
  (1150, '', '03', 71),
  (1151, 'Tameside', 'O1', 71),
  (1152, 'Rutland', 'L4', 71),
  (1153, 'Nottinghamshire', 'J9', 71),
  (1154, 'Midlothian', 'V5', 71),
  (1155, 'East Ayrshire', 'U4', 71),
  (1156, 'Stoke-on-Trent', 'N4', 71),
  (1157, 'Bristol', 'B7', 71),
  (1158, 'Flintshire', 'Y1', 71),
  (1159, 'Blackburn with Darwen', 'A8', 71),
  (1160, 'Moyle', 'S8', 71),
  (1161, 'Carrickfergus', 'R4', 71),
  (1162, 'Castlereagh', 'R5', 71),
  (1163, 'Larne', 'S3', 71),
  (1164, 'Belfast', 'R3', 71),
  (1165, 'Magherafelt', 'S7', 71),
  (1166, 'North Down', 'T2', 71),
  (1167, 'North Somerset', 'J4', 71),
  (1168, 'East Renfrewshire', 'U7', 71),
  (1169, 'Newport', 'Y6', 71),
  (1170, 'Bath and North East Somerset', 'A4', 71),
  (1171, '', '45', 71),
  (1172, '', '37', 71),
  (1173, 'Newham', 'I8', 71),
  (1174, '', '90', 71),
  (1175, 'Denbighshire', 'X9', 71),
  (1176, 'East Riding of Yorkshire', 'E1', 71),
  (1177, 'Bexley', 'A6', 71),
  (1178, 'Bromley', 'B8', 71),
  (1179, 'Bradford', 'B4', 71),
  (1180, 'Bracknell Forest', 'B3', 71),
  (1181, 'Cardiff', 'X5', 71),
  (1182, 'Birmingham', 'A7', 71),
  (1183, 'Orkney', 'V9', 71),
  (1184, 'East Dunbartonshire', 'U5', 71),
  (1185, 'Blackpool', 'A9', 71),
  (1186, 'Southampton', 'M4', 71),
  (1187, 'Newcastle upon Tyne', 'I7', 71),
  (1188, 'Bolton', 'B1', 71),
  (1189, 'Redcar and Cleveland', 'K9', 71),
  (1190, 'Bournemouth', 'B2', 71),
  (1191, 'Swindon', 'N9', 71),
  (1192, 'Stockport', 'N2', 71),
  (1193, 'Windsor and Maidenhead', 'P9', 71),
  (1194, 'Inverclyde', 'V4', 71),
  (1195, 'Medway', 'I3', 71),
  (1196, 'Milton Keynes', 'I6', 71),
  (1197, 'Dundee City', 'U3', 71),
  (1198, 'Telford and Wrekin', 'O2', 71),
  (1199, 'Reading', 'K7', 71),
  (1200, 'Bury', 'C1', 71),
  (1201, 'Wolverhampton', 'Q3', 71),
  (1202, 'Southwark', 'M8', 71),
  (1203, 'Camden', 'C4', 71),
  (1204, 'Slough', 'M1', 71),
  (1205, 'Middlesbrough', 'I5', 71),
  (1206, 'Stockton-on-Tees', 'N3', 71),
  (1207, 'Newtownabbey', 'T1', 71),
  (1208, 'Lisburn', 'S5', 71),
  (1209, '', '28', 71),
  (1210, 'Lewisham', 'H6', 71),
  (1211, 'West Berkshire', 'P4', 71),
  (1212, 'Manchester', 'I2', 71),
  (1213, 'Westminster', 'P5', 71),
  (1214, 'Ards', 'Q7', 71),
  (1215, 'Plymouth', 'K4', 71),
  (1216, 'Croydon', 'C8', 71),
  (1217, 'Barking and Dagenham', 'A1', 71),
  (1218, 'Hartlepool', 'F5', 71),
  (1219, 'Sheffield', 'L9', 71),
  (1220, 'Oldham', 'K1', 71),
  (1221, 'Knowsley', 'G9', 71),
  (1222, 'Liverpool', 'H8', 71),
  (1223, 'Dudley', 'D7', 71),
  (1224, 'Gateshead', 'E5', 71),
  (1225, 'Ealing', 'D9', 71),
  (1226, 'Edinburgh', 'U8', 71),
  (1227, 'Enfield', 'E3', 71),
  (1228, 'Calderdale', 'C2', 71),
  (1229, 'Halton', 'E9', 71),
  (1230, 'North Tyneside', 'J5', 71),
  (1231, 'Thurrock', 'O3', 71),
  (1232, 'North East Lincolnshire', 'J2', 71),
  (1233, 'Wirral', 'Q1', 71),
  (1234, 'Hackney', 'E8', 71),
  (1235, 'Hammersmith and Fulham', 'F1', 71),
  (1236, 'Havering', 'F6', 71),
  (1237, 'Harrow', 'F4', 71),
  (1238, 'Barnet', 'A2', 71),
  (1239, 'Hounslow', 'G1', 71),
  (1240, 'Brighton and Hove', 'B6', 71),
  (1241, 'Kingston upon Hull', 'G6', 71),
  (1242, 'Redbridge', 'K8', 71),
  (1243, 'Islington', 'G3', 71),
  (1244, 'Kensington and Chelsea', 'G4', 71),
  (1245, 'Kingston upon Thames', 'G7', 71),
  (1246, 'Lambeth', 'H1', 71),
  (1247, 'London', 'H9', 71),
  (1248, 'Luton', 'I1', 71),
  (1249, 'Sunderland', 'N6', 71),
  (1250, 'Merton', 'I4', 71),
  (1251, 'Sandwell', 'L7', 71),
  (1252, 'Salford', 'L5', 71),
  (1253, 'Peterborough', 'K3', 71),
  (1254, 'Poole', 'K5', 71),
  (1255, 'Tower Hamlets', 'O5', 71),
  (1256, 'Portsmouth', 'K6', 71),
  (1257, 'Rochdale', 'L2', 71),
  (1258, 'Greenwich', 'E7', 71),
  (1259, 'South Tyneside', 'M7', 71),
  (1260, 'Trafford', 'O6', 71),
  (1261, 'Sutton', 'N8', 71),
  (1262, 'Torbay', 'O4', 71),
  (1263, 'Richmond upon Thames', 'L1', 71),
  (1264, 'Hillingdon', 'F9', 71),
  (1265, 'Wakefield', 'O7', 71),
  (1266, 'Waltham Forest', 'O9', 71),
  (1267, 'Wandsworth', 'P1', 71),
  (1268, 'Brent', 'B5', 71),
  (1269, 'Haringey', 'F3', 71),
  (1270, 'Saint Andrew', '01', 72),
  (1271, 'Saint George', '03', 72),
  (1272, 'Saint David', '02', 72),
  (1273, 'Saint Patrick', '06', 72),
  (1274, 'Saint Mark', '05', 72),
  (1275, 'Saint John', '04', 72),
  (1276, 'Abkhazia', '02', 73),
  (1277, 'Ninotsmindis Raioni', '39', 73),
  (1278, 'P\'ot\'i', '42', 73),
  (1279, 'Ambrolauris Raioni', '09', 73),
  (1280, 'Abashis Raioni', '01', 73),
  (1281, 'Akhalts\'ikhis Raioni', '07', 73),
  (1282, 'Zestap\'onis Raioni', '62', 73),
  (1283, 'Tsalenjikhis Raioni', '58', 73),
  (1284, 'Marneulis Raioni', '35', 73),
  (1285, 'Goris Raioni', '22', 73),
  (1286, 'K\'arelis Raioni', '25', 73),
  (1287, 'Khashuris Raioni', '28', 73),
  (1288, 'Kaspis Raioni', '26', 73),
  (1289, 'Ajaria', '04', 73),
  (1290, 'Mts\'khet\'is Raioni', '38', 73),
  (1291, 'Ch\'okhatauris Raioni', '16', 73),
  (1292, 'Akhalk\'alak\'is Raioni', '06', 73),
  (1293, 'Samtrediis Raioni', '48', 73),
  (1294, 'Tqibuli', '56', 73),
  (1295, 'Dushet\'is Raioni', '19', 73),
  (1296, 'Onis Raioni', '40', 73),
  (1297, 'Lentekhis Raioni', '34', 73),
  (1298, 'Martvilis Raioni', '36', 73),
  (1299, 'K\'ut\'aisi', '31', 73),
  (1300, 'Akhalgoris Raioni', '05', 73),
  (1301, 'Aspindzis Raioni', '10', 73),
  (1302, 'Akhmetis Raioni', '08', 73),
  (1303, 'Lagodekhis Raioni', '32', 73),
  (1304, 'Zugdidis Raioni', '64', 73),
  (1305, 'Borjomis Raioni', '13', 73),
  (1306, 'T\'ianet\'is Raioni', '55', 73),
  (1307, 'Khobis Raioni', '29', 73),
  (1308, 'Kharagaulis Raioni', '27', 73),
  (1309, 'Vanis Raioni', '61', 73),
  (1310, 'T\'elavis Raioni', '52', 73),
  (1311, 'Tsalkis Raioni', '59', 73),
  (1312, 'Qazbegis Raioni', '43', 73),
  (1313, 'Sagarejos Raioni', '47', 73),
  (1314, 'T\'et\'ritsqaros Raioni', '54', 73),
  (1315, 'Dedop\'listsqaros Raioni', '17', 73),
  (1316, 'Javis Raioni', '24', 73),
  (1317, 'Ch\'khorotsqus Raioni', '15', 73),
  (1318, 'Tsqaltubo', '60', 73),
  (1319, 'Rust\'avi', '45', 73),
  (1320, 'T\'bilisi', '51', 73),
  (1321, 'Baghdat\'is Raioni', '11', 73),
  (1322, 'Lanch\'khut\'is Raioni', '33', 73),
  (1323, 'Chiat\'ura', '14', 73),
  (1324, 'Ts\'ageris Raioni', '57', 73),
  (1325, '', '00', 74),
  (1326, '', '00', 75),
  (1327, 'Central', '04', 76),
  (1328, 'Western', '09', 76),
  (1329, 'Ashanti', '02', 76),
  (1330, 'Upper East', '10', 76),
  (1331, 'Volta', '08', 76),
  (1332, 'Brong-Ahafo', '03', 76),
  (1333, 'Northern', '06', 76),
  (1334, 'Greater Accra', '01', 76),
  (1335, 'Upper West', '11', 76),
  (1336, 'Eastern', '05', 76),
  (1337, '', '00', 77),
  (1338, 'Vestgronland', '03', 78),
  (1339, 'Nordgronland', '01', 78),
  (1340, 'Ostgronland', '02', 78),
  (1341, 'Central River', '03', 79),
  (1342, 'Western', '05', 79),
  (1343, 'North Bank', '07', 79),
  (1344, 'Upper River', '04', 79),
  (1345, 'Lower River', '02', 79),
  (1346, 'Banjul', '01', 79),
  (1347, 'Kouroussa', '19', 80),
  (1348, 'Beyla', '01', 80),
  (1349, 'Koundara', '18', 80),
  (1350, 'Dinguiraye', '07', 80),
  (1351, 'Mali', '22', 80),
  (1352, 'Macenta', '21', 80),
  (1353, '', '26', 80),
  (1354, '', '24', 80),
  (1355, 'Kissidougou', '17', 80),
  (1356, 'Forecariah', '10', 80),
  (1357, 'Pita', '25', 80),
  (1358, '', '14', 80),
  (1359, '', '20', 80),
  (1360, '', '08', 80),
  (1361, 'Dabola', '05', 80),
  (1362, 'Boke', '03', 80),
  (1363, 'Mamou', '23', 80),
  (1364, 'Faranah', '09', 80),
  (1365, 'Telimele', '27', 80),
  (1366, 'Boffa', '02', 80),
  (1367, 'Gueckedou', '13', 80),
  (1368, 'Kindia', '16', 80),
  (1369, 'Fria', '11', 80),
  (1370, 'Tougue', '28', 80),
  (1371, 'Yomou', '29', 80),
  (1372, 'Gaoual', '12', 80),
  (1373, 'Kerouane', '15', 80),
  (1374, 'Dalaba', '06', 80),
  (1375, 'Conakry', '04', 80),
  (1376, 'Coyah', '30', 80),
  (1377, 'Dubreka', '31', 80),
  (1378, 'Kankan', '32', 80),
  (1379, 'Koubia', '33', 80),
  (1380, 'Labe', '34', 80),
  (1381, 'Lelouma', '35', 80),
  (1382, 'Lola', '36', 80),
  (1383, 'Mandiana', '37', 80),
  (1384, 'Nzerekore', '38', 80),
  (1385, 'Siguiri', '39', 80),
  (1386, '', '00', 81),
  (1387, 'Centro Sur', '06', 82),
  (1388, 'Wele-Nzas', '09', 82),
  (1389, 'Kie-Ntem', '07', 82),
  (1390, 'Litoral', '08', 82),
  (1391, 'Annobon', '03', 82),
  (1392, 'Bioko Norte', '04', 82),
  (1393, 'Bioko Sur', '05', 82),
  (1394, '', '00', 82),
  (1395, 'Kilkis', '06', 83),
  (1396, 'Larisa', '21', 83),
  (1397, 'Attiki', '35', 83),
  (1398, 'Trikala', '22', 83),
  (1399, 'Preveza', '19', 83),
  (1400, 'Kerkira', '25', 83),
  (1401, 'Ioannina', '17', 83),
  (1402, 'Pella', '07', 83),
  (1403, 'Thessaloniki', '13', 83),
  (1404, 'Voiotia', '33', 83),
  (1405, 'Kikladhes', '49', 83),
  (1406, 'Kavala', '14', 83),
  (1407, 'Argolis', '36', 83),
  (1408, 'Rethimni', '44', 83),
  (1409, 'Serrai', '05', 83),
  (1410, 'Lakonia', '42', 83),
  (1411, 'Iraklion', '45', 83),
  (1412, 'Lasithi', '46', 83),
  (1413, 'Rodhopi', '02', 83),
  (1414, 'Drama', '04', 83),
  (1415, 'Messinia', '40', 83),
  (1416, 'Evvoia', '34', 83),
  (1417, 'Akhaia', '38', 83),
  (1418, 'Magnisia', '24', 83),
  (1419, 'Khania', '43', 83),
  (1420, 'Kardhitsa', '23', 83),
  (1421, 'Evros', '01', 83),
  (1422, 'Arkadhia', '41', 83),
  (1423, 'Aitolia kai Akarnania', '31', 83),
  (1424, 'Kozani', '11', 83),
  (1425, 'Thesprotia', '18', 83),
  (1426, 'Lesvos', '51', 83),
  (1427, 'Dhodhekanisos', '47', 83),
  (1428, 'Kefallinia', '27', 83),
  (1429, 'Khios', '50', 83),
  (1430, 'Arta', '20', 83),
  (1431, 'Grevena', '10', 83),
  (1432, 'Zakinthos', '28', 83),
  (1433, 'Evritania', '30', 83),
  (1434, 'Fthiotis', '29', 83),
  (1435, 'Kastoria', '09', 83),
  (1436, 'Samos', '48', 83),
  (1437, 'Imathia', '12', 83),
  (1438, 'Florina', '08', 83),
  (1439, 'Pieria', '16', 83),
  (1440, 'Levkas', '26', 83),
  (1441, 'Fokis', '32', 83),
  (1442, 'Ilia', '39', 83),
  (1443, 'Korinthia', '37', 83),
  (1444, 'Xanthi', '03', 83),
  (1445, 'Khalkidhiki', '15', 83),
  (1446, '', '00', 83),
  (1447, '', '00', 84),
  (1448, 'Izabal', '09', 85),
  (1449, 'Alta Verapaz', '01', 85),
  (1450, 'Retalhuleu', '15', 85),
  (1451, 'El Progreso', '05', 85),
  (1452, 'Guatemala', '07', 85),
  (1453, 'Jutiapa', '11', 85),
  (1454, 'Chimaltenango', '03', 85),
  (1455, 'Chiquimula', '04', 85),
  (1456, 'Zacapa', '22', 85),
  (1457, 'Jalapa', '10', 85),
  (1458, 'San Marcos', '17', 85),
  (1459, 'Quiche', '14', 85),
  (1460, 'Huehuetenango', '08', 85),
  (1461, 'Quetzaltenango', '13', 85),
  (1462, 'Baja Verapaz', '02', 85),
  (1463, 'Santa Rosa', '18', 85),
  (1464, 'Solola', '19', 85),
  (1465, 'Peten', '12', 85),
  (1466, 'Escuintla', '06', 85),
  (1467, 'Sacatepequez', '16', 85),
  (1468, 'Totonicapan', '21', 85),
  (1469, 'Suchitepequez', '20', 85),
  (1470, 'Cacheu', '06', 86),
  (1471, 'Biombo', '12', 86),
  (1472, 'Oio', '04', 86),
  (1473, 'Bissau', '11', 86),
  (1474, 'Bafata', '01', 86),
  (1475, 'Tombali', '07', 86),
  (1476, 'Gabu', '10', 86),
  (1477, 'Bolama', '05', 86),
  (1478, 'Quinara', '02', 86),
  (1479, 'Mahaica-Berbice', '15', 87),
  (1480, 'Upper Takutu-Upper Essequibo', '19', 87),
  (1481, 'Barima-Waini', '10', 87),
  (1482, 'Pomeroon-Supenaam', '16', 87),
  (1483, 'Demerara-Mahaica', '12', 87),
  (1484, 'Cuyuni-Mazaruni', '11', 87),
  (1485, 'East Berbice-Corentyne', '13', 87),
  (1486, 'Essequibo Islands-West Demerara', '14', 87),
  (1487, 'Potaro-Siparuni', '17', 87),
  (1488, 'Upper Demerara-Berbice', '18', 87),
  (1489, '', '00', 88),
  (1490, 'Colon', '03', 89),
  (1491, 'Choluteca', '02', 89),
  (1492, 'Comayagua', '04', 89),
  (1493, 'Valle', '17', 89),
  (1494, 'Santa Barbara', '16', 89),
  (1495, 'Francisco Morazan', '08', 89),
  (1496, 'El Paraiso', '07', 89),
  (1497, 'Lempira', '13', 89),
  (1498, 'Copan', '05', 89),
  (1499, 'Olancho', '15', 89),
  (1500, 'Cortes', '06', 89),
  (1501, 'Yoro', '18', 89),
  (1502, 'Atlantida', '01', 89),
  (1503, 'Intibuca', '10', 89),
  (1504, 'La Paz', '12', 89),
  (1505, 'Ocotepeque', '14', 89),
  (1506, 'Gracias a Dios', '09', 89),
  (1507, 'Islas de la Bahia', '11', 89),
  (1508, 'Primorsko-Goranska', '12', 90),
  (1509, 'Splitsko-Dalmatinska', '15', 90),
  (1510, 'Istarska', '04', 90),
  (1511, 'Osjecko-Baranjska', '10', 90),
  (1512, 'Viroviticko-Podravska', '17', 90),
  (1513, 'Grad Zagreb', '21', 90),
  (1514, 'Sisacko-Moslavacka', '14', 90),
  (1515, 'Licko-Senjska', '08', 90),
  (1516, 'Brodsko-Posavska', '02', 90),
  (1517, 'Dubrovacko-Neretvanska', '03', 90),
  (1518, 'Pozesko-Slavonska', '11', 90),
  (1519, 'Zagrebacka', '20', 90),
  (1520, 'Bjelovarsko-Bilogorska', '01', 90),
  (1521, 'Varazdinska', '16', 90),
  (1522, 'Vukovarsko-Srijemska', '18', 90),
  (1523, 'Krapinsko-Zagorska', '07', 90),
  (1524, 'Koprivnicko-Krizevacka', '06', 90),
  (1525, 'Karlovacka', '05', 90),
  (1526, 'Sibensko-Kninska', '13', 90),
  (1527, 'Medimurska', '09', 90),
  (1528, '', '00', 90),
  (1529, 'Sud', '12', 91),
  (1530, 'Centre', '07', 91),
  (1531, '', '08', 91),
  (1532, 'Ouest', '11', 91),
  (1533, 'Nord', '09', 91),
  (1534, 'Nord-Ouest', '03', 91),
  (1535, 'Nord-Est', '10', 91),
  (1536, 'Sud-Est', '13', 91),
  (1537, 'Artibonite', '06', 91),
  (1538, 'Komarom-Esztergom', '12', 92),
  (1539, 'Fejer', '08', 92),
  (1540, 'Jasz-Nagykun-Szolnok', '20', 92),
  (1541, 'Baranya', '02', 92),
  (1542, 'Szabolcs-Szatmar-Bereg', '18', 92),
  (1543, 'Heves', '11', 92),
  (1544, 'Borsod-Abauj-Zemplen', '04', 92),
  (1545, 'Gyor-Moson-Sopron', '09', 92),
  (1546, 'Pest', '16', 92),
  (1547, 'Veszprem', '23', 92),
  (1548, 'Bacs-Kiskun', '01', 92),
  (1549, 'Vas', '22', 92),
  (1550, 'Hajdu-Bihar', '10', 92),
  (1551, 'Zala', '24', 92),
  (1552, 'Somogy', '17', 92),
  (1553, 'Tolna', '21', 92),
  (1554, 'Nograd', '14', 92),
  (1555, 'Budapest', '05', 92),
  (1556, 'Miskolc', '13', 92),
  (1557, 'Csongrad', '06', 92),
  (1558, 'Debrecen', '07', 92),
  (1559, 'Bekes', '03', 92),
  (1560, 'Szeged', '19', 92),
  (1561, 'Pecs', '15', 92),
  (1562, 'Gyor', '25', 92),
  (1563, 'Jawa Timur', '08', 93),
  (1564, '', '09', 93),
  (1565, 'Sulawesi Tenggara', '22', 93),
  (1566, '', '25', 93),
  (1567, 'Nusa Tenggara Timur', '18', 93),
  (1568, 'Sulawesi Utara', '31', 93),
  (1569, 'Sumatera Barat', '24', 93),
  (1570, 'Aceh', '01', 93),
  (1571, 'Sulawesi Tengah', '21', 93),
  (1572, '', '16', 93),
  (1573, '', '20', 93),
  (1574, '', '23', 93),
  (1575, 'Jawa Tengah', '07', 93),
  (1576, 'Jawa Barat', '30', 93),
  (1577, 'Bali', '02', 93),
  (1578, '', '00', 93),
  (1579, 'Banten', '33', 93),
  (1580, 'Sumatera Utara', '26', 93),
  (1581, 'Kalimantan Timur', '14', 93),
  (1582, 'Lampung', '15', 93),
  (1583, 'Nusa Tenggara Barat', '17', 93),
  (1584, 'Kalimantan Barat', '11', 93),
  (1585, 'Kalimantan Tengah', '13', 93),
  (1586, '', '19', 93),
  (1587, 'Bengkulu', '03', 93),
  (1588, 'Jambi', '05', 93),
  (1589, 'Kalimantan Selatan', '12', 93),
  (1590, 'Yogyakarta', '10', 93),
  (1591, 'Jakarta Raya', '04', 93),
  (1592, '', '06', 93),
  (1593, 'Maluku', '28', 93),
  (1594, 'Galway', '10', 94),
  (1595, 'Cork', '04', 94),
  (1596, 'Kerry', '11', 94),
  (1597, 'Limerick', '16', 94),
  (1598, 'Longford', '18', 94),
  (1599, 'Laois', '15', 94),
  (1600, 'Waterford', '27', 94),
  (1601, 'Mayo', '20', 94),
  (1602, 'Sligo', '25', 94),
  (1603, 'Kildare', '12', 94),
  (1604, 'Dublin', '07', 94),
  (1605, 'Wicklow', '31', 94),
  (1606, 'Cavan', '02', 94),
  (1607, 'Kilkenny', '13', 94),
  (1608, 'Wexford', '30', 94),
  (1609, 'Carlow', '01', 94),
  (1610, 'Offaly', '23', 94),
  (1611, 'Monaghan', '22', 94),
  (1612, 'Leitrim', '14', 94),
  (1613, 'Clare', '03', 94),
  (1614, 'Donegal', '06', 94),
  (1615, 'Louth', '19', 94),
  (1616, 'Roscommon', '24', 94),
  (1617, 'Tipperary', '26', 94),
  (1618, 'Westmeath', '29', 94),
  (1619, 'Meath', '21', 94),
  (1620, 'HaZafon', '03', 95),
  (1621, 'HaDarom', '01', 95),
  (1622, 'HaMerkaz', '02', 95),
  (1623, 'Yerushalayim', '06', 95),
  (1624, 'Tel Aviv', '05', 95),
  (1625, 'Hefa', '04', 95),
  (1626, '', '00', 0),
  (1627, 'West Bengal', '28', 96),
  (1628, 'Uttar Pradesh', '36', 96),
  (1629, 'Punjab', '23', 96),
  (1630, 'Madhya Pradesh', '35', 96),
  (1631, 'Karnataka', '19', 96),
  (1632, 'Maharashtra', '16', 96),
  (1633, 'Haryana', '10', 96),
  (1634, 'Uttarakhand', '39', 96),
  (1635, 'Andhra Pradesh', '02', 96),
  (1636, 'Tripura', '26', 96),
  (1637, 'Tamil Nadu', '25', 96),
  (1638, 'Jammu and Kashmir', '12', 96),
  (1639, 'Andaman and Nicobar Islands', '01', 96),
  (1640, 'Assam', '03', 96),
  (1641, 'Chhattisgarh', '37', 96),
  (1642, 'Rajasthan', '24', 96),
  (1643, 'Goa', '33', 96),
  (1644, 'Puducherry', '22', 96),
  (1645, 'Gujarat', '09', 96),
  (1646, 'Kerala', '13', 96),
  (1647, 'Arunachal Pradesh', '30', 96),
  (1648, 'Orissa', '21', 96),
  (1649, 'Himachal Pradesh', '11', 96),
  (1650, 'Bihar', '34', 96),
  (1651, 'Meghalaya', '18', 96),
  (1652, 'Nagaland', '20', 96),
  (1653, 'Manipur', '17', 96),
  (1654, 'Mizoram', '31', 96),
  (1655, 'Jharkhand', '38', 96),
  (1656, '', '27', 96),
  (1657, 'Delhi', '07', 96),
  (1658, 'Dadra and Nagar Haveli', '06', 96),
  (1659, '', '15', 96),
  (1660, 'Daman and Diu', '32', 96),
  (1661, 'Sikkim', '29', 96),
  (1662, 'Chandigarh', '05', 96),
  (1663, 'Lakshadweep', '14', 96),
  (1664, 'As Sulaymaniyah', '05', 97),
  (1665, 'Dhi Qar', '09', 97),
  (1666, 'Maysan', '14', 97),
  (1667, 'Diyala', '10', 97),
  (1668, 'Baghdad', '07', 97),
  (1669, 'Wasit', '16', 97),
  (1670, 'Salah ad Din', '18', 97),
  (1671, 'Al Qadisiyah', '04', 97),
  (1672, 'Babil', '06', 97),
  (1673, 'Karbala\'', '12', 97),
  (1674, 'An Najaf', '17', 97),
  (1675, 'Al Muthanna', '03', 97),
  (1676, 'Al Anbar', '01', 97),
  (1677, 'Dahuk', '08', 97),
  (1678, 'Ninawa', '15', 97),
  (1679, 'Arbil', '11', 97),
  (1680, 'Al Basrah', '02', 97),
  (1681, 'At Ta\'mim', '13', 97),
  (1682, 'Zanjan', '27', 98),
  (1683, 'Azarbayjan-e Bakhtari', '01', 98),
  (1684, 'Yazd', '31', 98),
  (1685, 'Khuzestan', '15', 98),
  (1686, 'Esfahan', '28', 98),
  (1687, 'Ardabil', '32', 98),
  (1688, 'Tehran', '26', 98),
  (1689, 'East Azarbaijan', '33', 98),
  (1690, 'Bushehr', '22', 98),
  (1691, 'Hormozgan', '11', 98),
  (1692, 'Mazandaran', '17', 98),
  (1693, 'Kerman', '29', 98),
  (1694, 'Fars', '07', 98),
  (1695, 'Kohkiluyeh va Buyer Ahmadi', '05', 98),
  (1696, 'Khorasan', '30', 98),
  (1697, 'Sistan va Baluchestan', '04', 98),
  (1698, 'Chahar Mahall va Bakhtiari', '03', 98),
  (1699, 'Kerman', '12', 98),
  (1700, 'Mazandaran', '35', 98),
  (1701, 'Qazvin', '38', 98),
  (1702, 'Zanjan', '36', 98),
  (1703, 'Markazi', '24', 98),
  (1704, 'Markazi', '19', 98),
  (1705, 'Lorestan', '23', 98),
  (1706, 'Markazi', '34', 98),
  (1707, 'Khorasan-e Razavi', '42', 98),
  (1708, 'Hamadan', '09', 98),
  (1709, 'Semnan', '25', 98),
  (1710, 'Gilan', '08', 98),
  (1711, 'Kordestan', '16', 98),
  (1712, 'Bakhtaran', '13', 98),
  (1713, 'Ilam', '10', 98),
  (1714, 'Semnan Province', '18', 98),
  (1715, 'Golestan', '37', 98),
  (1716, 'Qom', '39', 98),
  (1717, '', '02', 98),
  (1718, 'Zanjan', '21', 98),
  (1719, '', '00', 98),
  (1720, 'Skagafjardarsysla', '28', 99),
  (1721, 'Borgarfjardarsysla', '07', 99),
  (1722, 'Myrasysla', '17', 99),
  (1723, 'Rangarvallasysla', '23', 99),
  (1724, 'Eyjafjardarsysla', '09', 99),
  (1725, 'Kjosarsysla', '15', 99),
  (1726, 'Vestur-Isafjardarsysla', '36', 99),
  (1727, '', '19', 99),
  (1728, 'Strandasysla', '30', 99),
  (1729, 'Gullbringusysla', '10', 99),
  (1730, 'Austur-Hunavatnssysla', '05', 99),
  (1731, 'Austur-Skaftafellssysla', '06', 99),
  (1732, 'Nordur-Mulasysla', '20', 99),
  (1733, 'Sudur-Mulasysla', '31', 99),
  (1734, 'Vestur-Bardastrandarsysla', '34', 99),
  (1735, 'Snafellsnes- og Hnappadalssysla', '29', 99),
  (1736, 'Arnessysla', '03', 99),
  (1737, 'Vestur-Hunavatnssysla', '35', 99),
  (1738, 'Sudur-Tingeyjarsysla', '32', 99),
  (1739, '', '08', 99),
  (1740, 'Vestur-Skaftafellssysla', '37', 99),
  (1741, '', '04', 99),
  (1742, 'Nordur-Tingeyjarsysla', '21', 99),
  (1743, 'Toscana', '16', 100),
  (1744, 'Veneto', '20', 100),
  (1745, 'Campania', '04', 100),
  (1746, 'Marche', '10', 100),
  (1747, 'Piemonte', '12', 100),
  (1748, 'Lombardia', '09', 100),
  (1749, 'Sardegna', '14', 100),
  (1750, 'Abruzzi', '01', 100),
  (1751, 'Emilia-Romagna', '05', 100),
  (1752, 'Trentino-Alto Adige', '17', 100),
  (1753, 'Umbria', '18', 100),
  (1754, 'Basilicata', '02', 100),
  (1755, 'Puglia', '13', 100),
  (1756, 'Sicilia', '15', 100),
  (1757, 'Lazio', '07', 100),
  (1758, 'Liguria', '08', 100),
  (1759, 'Calabria', '03', 100),
  (1760, 'Molise', '11', 100),
  (1761, 'Friuli-Venezia Giulia', '06', 100),
  (1762, 'Valle d\'Aosta', '19', 100),
  (1763, '', '00', 100),
  (1764, 'Saint Ann', '09', 101),
  (1765, 'Saint Elizabeth', '11', 101),
  (1766, 'Hanover', '02', 101),
  (1767, 'Westmoreland', '16', 101),
  (1768, 'Trelawny', '15', 101),
  (1769, 'Manchester', '04', 101),
  (1770, 'Saint James', '12', 101),
  (1771, 'Saint Andrew', '08', 101),
  (1772, 'Saint Thomas', '14', 101),
  (1773, 'Saint Mary', '13', 101),
  (1774, 'Portland', '07', 101),
  (1775, 'Clarendon', '01', 101),
  (1776, 'Saint Catherine', '10', 101),
  (1777, 'Kingston', '17', 101),
  (1778, '', '11', 102),
  (1779, 'At Tafilah', '12', 102),
  (1780, '', '07', 102),
  (1781, '', '14', 102),
  (1782, 'Al Karak', '09', 102),
  (1783, '', '13', 102),
  (1784, 'Al Balqa\'', '02', 102);
  INSERT INTO `regions` (`id`, `name`, `code`, `country_id`) VALUES
  (1785, '', '10', 102),
  (1786, 'Amman', '16', 102),
  (1787, 'Al Aqabah', '21', 102),
  (1788, 'Okinawa', '47', 103),
  (1789, 'Nagasaki', '27', 103),
  (1790, 'Hokkaido', '12', 103),
  (1791, 'Tokushima', '39', 103),
  (1792, 'Mie', '23', 103),
  (1793, 'Kanagawa', '19', 103),
  (1794, 'Chiba', '04', 103),
  (1795, 'Hyogo', '13', 103),
  (1796, 'Yamaguchi', '45', 103),
  (1797, 'Aomori', '03', 103),
  (1798, 'Miyazaki', '25', 103),
  (1799, 'Shizuoka', '37', 103),
  (1800, 'Shimane', '36', 103),
  (1801, 'Fukushima', '08', 103),
  (1802, 'Okayama', '31', 103),
  (1803, 'Shiga', '35', 103),
  (1804, 'Kagoshima', '18', 103),
  (1805, 'Hiroshima', '11', 103),
  (1806, 'Tottori', '41', 103),
  (1807, 'Akita', '02', 103),
  (1808, 'Nagano', '26', 103),
  (1809, 'Fukui', '06', 103),
  (1810, 'Saitama', '34', 103),
  (1811, 'Wakayama', '43', 103),
  (1812, 'Kochi', '20', 103),
  (1813, 'Iwate', '16', 103),
  (1814, 'Miyagi', '24', 103),
  (1815, 'Niigata', '29', 103),
  (1816, 'Gumma', '10', 103),
  (1817, 'Aichi', '01', 103),
  (1818, 'Toyama', '42', 103),
  (1819, 'Kumamoto', '21', 103),
  (1820, 'Kagawa', '17', 103),
  (1821, 'Ehime', '05', 103),
  (1822, 'Tokyo', '40', 103),
  (1823, 'Fukuoka', '07', 103),
  (1824, 'Tochigi', '38', 103),
  (1825, 'Yamagata', '44', 103),
  (1826, 'Saga', '33', 103),
  (1827, 'Oita', '30', 103),
  (1828, 'Gifu', '09', 103),
  (1829, 'Ishikawa', '15', 103),
  (1830, 'Nara', '28', 103),
  (1831, 'Ibaraki', '14', 103),
  (1832, 'Kyoto', '22', 103),
  (1833, 'Yamanashi', '46', 103),
  (1834, 'Osaka', '32', 103),
  (1835, 'Coast', '02', 104),
  (1836, 'Nyanza', '07', 104),
  (1837, 'Rift Valley', '08', 104),
  (1838, 'Western', '09', 104),
  (1839, 'North-Eastern', '06', 104),
  (1840, 'Eastern', '03', 104),
  (1841, 'Nairobi Area', '05', 104),
  (1842, 'Central', '01', 104),
  (1843, 'Jalal-Abad', '03', 105),
  (1844, 'Naryn', '04', 105),
  (1845, 'Osh', '05', 105),
  (1846, 'Chuy', '02', 105),
  (1847, 'Ysyk-Kol', '07', 105),
  (1848, 'Bishkek', '01', 105),
  (1849, 'Talas', '06', 105),
  (1850, 'Batken', '09', 105),
  (1851, '', '00', 105),
  (1852, 'Siem Reap', '16', 106),
  (1853, 'Kracheh', '09', 106),
  (1854, 'Kampong Thum', '05', 106),
  (1855, 'Kampong Chhnang', '03', 106),
  (1856, '', '20', 106),
  (1857, 'Kampong Cham', '02', 106),
  (1858, 'Kampong Speu', '04', 106),
  (1859, 'Takeo', '19', 106),
  (1860, 'Batdambang', '01', 106),
  (1861, 'Prey Veng', '14', 106),
  (1862, 'Ratanakiri Kiri', '15', 106),
  (1863, 'Svay Rieng', '18', 106),
  (1864, 'Koh Kong', '08', 106),
  (1865, 'Pursat', '12', 106),
  (1866, 'Phnum Penh', '11', 106),
  (1867, 'Mondulkiri', '10', 106),
  (1868, 'Stung Treng', '17', 106),
  (1869, 'Kampot', '06', 106),
  (1870, 'Banteay Meanchey', '25', 106),
  (1871, 'Preah Vihear', '13', 106),
  (1872, 'Kandal', '07', 106),
  (1873, '', '00', 107),
  (1874, 'Anjouan', '01', 108),
  (1875, 'Moheli', '03', 108),
  (1876, 'Grande Comore', '02', 108),
  (1877, 'Saint George Gingerland', '04', 109),
  (1878, 'Saint James Windward', '05', 109),
  (1879, 'Saint Thomas Lowland', '12', 109),
  (1880, 'Saint George Basseterre', '03', 109),
  (1881, 'Saint John Figtree', '07', 109),
  (1882, 'Saint Peter Basseterre', '11', 109),
  (1883, 'Saint John Capisterre', '06', 109),
  (1884, 'Christ Church Nichola Town', '01', 109),
  (1885, 'Trinity Palmetto Point', '15', 109),
  (1886, 'Saint Anne Sandy Point', '02', 109),
  (1887, 'Saint Mary Cayon', '08', 109),
  (1888, 'Saint Thomas Middle Island', '13', 109),
  (1889, 'Saint Paul Capisterre', '09', 109),
  (1890, 'P\'yongan-namdo', '15', 110),
  (1891, 'P\'yongan-bukto', '11', 110),
  (1892, 'P\'yongyang-si', '12', 110),
  (1893, 'Kangwon-do', '09', 110),
  (1894, 'Hwanghae-bukto', '07', 110),
  (1895, 'Hamgyong-namdo', '03', 110),
  (1896, 'Chagang-do', '01', 110),
  (1897, 'Hamgyong-bukto', '17', 110),
  (1898, 'Hwanghae-namdo', '06', 110),
  (1899, 'Namp\'o-si', '14', 110),
  (1900, 'Kaesong-si', '08', 110),
  (1901, 'Yanggang-do', '13', 110),
  (1902, 'Najin Sonbong-si', '18', 110),
  (1903, 'Ch\'ungch\'ong-bukto', '05', 111),
  (1904, 'Kangwon-do', '06', 111),
  (1905, 'Ch\'ungch\'ong-namdo', '17', 111),
  (1906, 'Kyongsang-bukto', '14', 111),
  (1907, 'Cholla-namdo', '16', 111),
  (1908, 'Kyonggi-do', '13', 111),
  (1909, 'Cheju-do', '01', 111),
  (1910, 'Cholla-bukto', '03', 111),
  (1911, 'Seoul-t\'ukpyolsi', '11', 111),
  (1912, 'Kyongsang-namdo', '20', 111),
  (1913, 'Taegu-jikhalsi', '15', 111),
  (1914, 'Pusan-jikhalsi', '10', 111),
  (1915, 'Kwangju-jikhalsi', '18', 111),
  (1916, 'Ulsan-gwangyoksi', '21', 111),
  (1917, 'Inch\'on-jikhalsi', '12', 111),
  (1918, 'Taejon-jikhalsi', '19', 111),
  (1919, 'Al Kuwayt', '02', 112),
  (1920, 'Al Jahra', '05', 112),
  (1921, '', '04', 112),
  (1922, '', '00', 113),
  (1923, 'Almaty', '01', 114),
  (1924, 'South Kazakhstan', '10', 114),
  (1925, 'North Kazakhstan', '16', 114),
  (1926, 'Pavlodar', '11', 114),
  (1927, 'Qaraghandy', '12', 114),
  (1928, 'Qyzylorda', '14', 114),
  (1929, 'East Kazakhstan', '15', 114),
  (1930, 'Aqmola', '03', 114),
  (1931, 'Aqtobe', '04', 114),
  (1932, 'Qostanay', '13', 114),
  (1933, 'West Kazakhstan', '07', 114),
  (1934, 'Atyrau', '06', 114),
  (1935, 'Zhambyl', '17', 114),
  (1936, 'Astana', '05', 114),
  (1937, 'Mangghystau', '09', 114),
  (1938, 'Almaty City', '02', 114),
  (1939, 'Bayqonyr', '08', 114),
  (1940, '', '00', 114),
  (1941, 'Savannakhet', '10', 115),
  (1942, 'Phongsali', '08', 115),
  (1943, 'Saravan', '09', 115),
  (1944, '', '18', 115),
  (1945, '', '20', 115),
  (1946, 'Houaphan', '03', 115),
  (1947, 'Attapu', '01', 115),
  (1948, '', '06', 115),
  (1949, 'Champasak', '02', 115),
  (1950, 'Louangphrabang', '17', 115),
  (1951, 'Oudomxai', '07', 115),
  (1952, '', '16', 115),
  (1953, '', '15', 115),
  (1954, '', '21', 115),
  (1955, 'Xiangkhoang', '14', 115),
  (1956, 'Vientiane', '11', 115),
  (1957, '', '25', 115),
  (1958, '', '22', 115),
  (1959, '', '19', 115),
  (1960, 'Xaignabouri', '13', 115),
  (1961, 'Khammouan', '04', 115),
  (1962, '', '26', 115),
  (1963, '', '27', 115),
  (1964, '', '23', 115),
  (1965, '', '24', 115),
  (1966, 'Liban-Nord', '03', 116),
  (1967, 'Al Janub', '02', 116),
  (1968, 'Beyrouth', '04', 116),
  (1969, 'Mont-Liban', '05', 116),
  (1970, 'Beqaa', '01', 116),
  (1971, 'Liban-Sud', '06', 116),
  (1972, 'Micoud', '08', 117),
  (1973, 'Laborie', '07', 117),
  (1974, 'Dennery', '05', 117),
  (1975, 'Anse-la-Raye', '01', 117),
  (1976, 'Vieux-Fort', '10', 117),
  (1977, 'Castries', '03', 117),
  (1978, 'Soufriere', '09', 117),
  (1979, 'Gros-Islet', '06', 117),
  (1980, 'Choiseul', '04', 117),
  (1981, 'Dauphin', '02', 117),
  (1982, 'Praslin', '11', 117),
  (1983, 'Balzers', '01', 118),
  (1984, 'Gamprin', '03', 118),
  (1985, 'Planken', '05', 118),
  (1986, 'Vaduz', '11', 118),
  (1987, 'Eschen', '02', 118),
  (1988, 'Triesenberg', '10', 118),
  (1989, 'Schellenberg', '08', 118),
  (1990, 'Mauren', '04', 118),
  (1991, 'Ruggell', '06', 118),
  (1992, 'Schaan', '07', 118),
  (1993, 'Triesen', '09', 118),
  (1994, 'North Western', '32', 119),
  (1995, 'Southern', '34', 119),
  (1996, 'Central', '29', 119),
  (1997, 'Sabaragamuwa', '33', 119),
  (1998, 'North Central', '30', 119),
  (1999, '', '31', 119),
  (2000, 'Western', '36', 119),
  (2001, 'Uva', '35', 119),
  (2002, 'Nimba', '09', 120),
  (2003, 'Grand Bassa', '11', 120),
  (2004, 'Lofa', '05', 120),
  (2005, 'Bong', '01', 120),
  (2006, '', '02', 120),
  (2007, 'Montserrado', '14', 120),
  (2008, '', '15', 120),
  (2009, 'Margibi', '17', 120),
  (2010, '', '08', 120),
  (2011, 'Sino', '10', 120),
  (2012, 'River Cess', '18', 120),
  (2013, 'Grand Cape Mount', '12', 120),
  (2014, '', '16', 120),
  (2015, 'Maryland', '13', 120),
  (2016, 'Grand Cape Mount', '04', 120),
  (2017, 'Gbarpolu', '21', 120),
  (2018, 'River Gee', '22', 120),
  (2019, 'Grand Gedeh', '19', 120),
  (2020, 'Lofa', '20', 120),
  (2021, 'Maseru', '14', 121),
  (2022, 'Quthing', '18', 121),
  (2023, 'Mafeteng', '13', 121),
  (2024, 'Berea', '10', 121),
  (2025, 'Mohales Hoek', '15', 121),
  (2026, 'Thaba-Tseka', '19', 121),
  (2027, 'Butha-Buthe', '11', 121),
  (2028, 'Leribe', '12', 121),
  (2029, 'Qachas Nek', '17', 121),
  (2030, 'Mokhotlong', '16', 121),
  (2031, '', '03', 121),
  (2032, 'Panevezio Apskritis', '60', 122),
  (2033, 'Telsiu Apskritis', '63', 122),
  (2034, 'Klaipedos Apskritis', '58', 122),
  (2035, 'Vilniaus Apskritis', '65', 122),
  (2036, 'Siauliu Apskritis', '61', 122),
  (2037, 'Taurages Apskritis', '62', 122),
  (2038, 'Marijampoles Apskritis', '59', 122),
  (2039, '', '40', 122),
  (2040, 'Utenos Apskritis', '64', 122),
  (2041, 'Alytaus Apskritis', '56', 122),
  (2042, 'Kauno Apskritis', '57', 122),
  (2043, 'Luxembourg', '03', 123),
  (2044, 'Grevenmacher', '02', 123),
  (2045, 'Diekirch', '01', 123),
  (2046, 'Madonas', '20', 124),
  (2047, 'Kuldigas', '15', 124),
  (2048, 'Daugavpils', '07', 124),
  (2049, 'Tukuma', '29', 124),
  (2050, 'Ventspils', '33', 124),
  (2051, 'Dobeles', '08', 124),
  (2052, 'Liepajas', '17', 124),
  (2053, 'Balvu', '03', 124),
  (2054, 'Saldus', '27', 124),
  (2055, 'Bauskas', '04', 124),
  (2056, 'Limbazu', '18', 124),
  (2057, 'Ludzas', '19', 124),
  (2058, 'Cesu', '05', 124),
  (2059, 'Jekabpils', '10', 124),
  (2060, 'Aluksnes', '02', 124),
  (2061, 'Rezeknes', '24', 124),
  (2062, 'Rigas', '26', 124),
  (2063, 'Ogres', '21', 124),
  (2064, 'Kraslavas', '14', 124),
  (2065, 'Gulbenes', '09', 124),
  (2066, 'Riga', '25', 124),
  (2067, 'Preilu', '22', 124),
  (2068, 'Aizkraukles', '01', 124),
  (2069, 'Talsu', '28', 124),
  (2070, 'Jelgavas', '12', 124),
  (2071, 'Valkas', '30', 124),
  (2072, 'Valmieras', '31', 124),
  (2073, 'Liepaja', '16', 124),
  (2074, 'Ventspils', '32', 124),
  (2075, 'Daugavpils', '06', 124),
  (2076, 'Rezekne', '23', 124),
  (2077, 'Yafran', '62', 125),
  (2078, 'Tarabulus', '61', 125),
  (2079, 'An Nuqat al Khams', '51', 125),
  (2080, 'Al Aziziyah', '03', 125),
  (2081, 'Az Zawiyah', '53', 125),
  (2082, 'Misratah', '58', 125),
  (2083, 'Gharyan', '57', 125),
  (2084, 'Tubruq', '42', 125),
  (2085, 'Tarhunah', '41', 125),
  (2086, '', '09', 125),
  (2087, 'Ash Shati\'', '13', 125),
  (2088, 'Ajdabiya', '47', 125),
  (2089, 'Murzuq', '30', 125),
  (2090, 'Al Jabal al Akhdar', '49', 125),
  (2091, '', '36', 125),
  (2092, '', '43', 125),
  (2093, 'Ghadamis', '56', 125),
  (2094, '', '11', 125),
  (2095, '', '02', 125),
  (2096, 'Awbari', '52', 125),
  (2097, 'Al Khums', '50', 125),
  (2098, '', '06', 125),
  (2099, 'Al Kufrah', '08', 125),
  (2100, '', '04', 125),
  (2101, '', '24', 125),
  (2102, 'Al Fatih', '48', 125),
  (2103, 'Banghazi', '54', 125),
  (2104, 'Zlitan', '45', 125),
  (2105, 'Al Jufrah', '05', 125),
  (2106, '', '18', 125),
  (2107, '', '31', 125),
  (2108, 'Sawfajjin', '59', 125),
  (2109, '', '25', 125),
  (2110, 'Darnah', '55', 125),
  (2111, 'Sabha', '34', 125),
  (2112, '', '29', 125),
  (2113, '', '23', 125),
  (2114, '', '19', 125),
  (2115, '', '27', 125),
  (2116, 'Surt', '60', 125),
  (2117, '', '10', 125),
  (2118, '', '32', 125),
  (2119, '', '33', 125),
  (2120, '', '26', 125),
  (2121, '', '35', 125),
  (2122, '', '08', 126),
  (2123, '', '02', 126),
  (2124, '', '22', 126),
  (2125, '', '40', 126),
  (2126, '', '19', 126),
  (2127, '', '32', 126),
  (2128, '', '41', 126),
  (2129, '', '21', 126),
  (2130, '', '38', 126),
  (2131, '', '17', 126),
  (2132, '', '39', 126),
  (2133, '', '30', 126),
  (2134, '', '27', 126),
  (2135, '', '10', 126),
  (2136, '', '03', 126),
  (2137, '', '15', 126),
  (2138, '', '25', 126),
  (2139, '', '01', 126),
  (2140, '', '36', 126),
  (2141, '', '33', 126),
  (2142, '', '37', 126),
  (2143, '', '12', 126),
  (2144, '', '11', 126),
  (2145, '', '09', 126),
  (2146, '', '06', 126),
  (2147, '', '24', 126),
  (2148, '', '18', 126),
  (2149, '', '07', 126),
  (2150, '', '29', 126),
  (2151, '', '05', 126),
  (2152, '', '13', 126),
  (2153, '', '14', 126),
  (2154, '', '42', 126),
  (2155, '', '20', 126),
  (2156, '', '23', 126),
  (2157, '', '04', 126),
  (2158, '', '26', 126),
  (2159, '', '16', 126),
  (2160, '', '34', 126),
  (2161, '', '43', 126),
  (2162, '', '35', 126),
  (2163, '', '00', 127),
  (2164, '', '52', 128),
  (2165, '', '47', 128),
  (2166, 'Gagauzia', '51', 128),
  (2167, '', '55', 128),
  (2168, '', '49', 128),
  (2169, '', '56', 128),
  (2170, '', '46', 128),
  (2171, '', '48', 128),
  (2172, '', '54', 128),
  (2173, '', '50', 128),
  (2174, '', '53', 128),
  (2175, 'Antananarivo', '05', 129),
  (2176, 'Mahajanga', '03', 129),
  (2177, 'Toliara', '06', 129),
  (2178, 'Fianarantsoa', '02', 129),
  (2179, 'Antsiranana', '01', 129),
  (2180, 'Toamasina', '04', 129),
  (2181, '', '00', 130),
  (2182, 'Petrovec', '79', 131),
  (2183, 'Bogovinje', '10', 131),
  (2184, 'Lozovo', '60', 131),
  (2185, 'Rostusa', '88', 131),
  (2186, 'Staro Nagoricane', '97', 131),
  (2187, 'Gevgelija', '33', 131),
  (2188, 'Srbinovo', '94', 131),
  (2189, 'Orasac', '75', 131),
  (2190, 'Valandovo', 'A8', 131),
  (2191, 'Ilinden', '36', 131),
  (2192, 'Ohrid', '74', 131),
  (2193, 'Sveti Nikole', 'A4', 131),
  (2194, 'Lipkovo', '59', 131),
  (2195, 'Zitose', 'C4', 131),
  (2196, 'Studenicani', 'A2', 131),
  (2197, 'Krivogastani', '53', 131),
  (2198, 'Radovis', '84', 131),
  (2199, 'Dobrusevo', '26', 131),
  (2200, 'Rankovce', '85', 131),
  (2201, 'Topolcani', 'A7', 131),
  (2202, 'Kriva Palanka', '52', 131),
  (2203, 'Zajas', 'C1', 131),
  (2204, 'Vitoliste', 'B5', 131),
  (2205, 'Debar', '21', 131),
  (2206, 'Bosilovo', '11', 131),
  (2207, 'Dzepciste', '31', 131),
  (2208, 'Vasilevo', 'A9', 131),
  (2209, 'Star Dojran', '96', 131),
  (2210, 'Saraj', '90', 131),
  (2211, 'Aracinovo', '01', 131),
  (2212, 'Oslomej', '77', 131),
  (2213, 'Miravci', '66', 131),
  (2214, 'Belcista', '03', 131),
  (2215, 'Karbinci', '40', 131),
  (2216, 'Krusevo', '54', 131),
  (2217, 'Kondovo', '48', 131),
  (2218, 'Resen', '86', 131),
  (2219, 'Lukovo', '61', 131),
  (2220, 'Vranestica', 'B6', 131),
  (2221, 'Negotino-Polosko', '70', 131),
  (2222, 'Stip', '98', 131),
  (2223, 'Sopotnica', '93', 131),
  (2224, 'Orizari', '76', 131),
  (2225, 'Veles', 'B1', 131),
  (2226, 'Bac', '02', 131),
  (2227, 'Zelenikovo', 'C2', 131),
  (2228, 'Novo Selo', '72', 131),
  (2229, 'Strumica', 'A1', 131),
  (2230, 'Mavrovi Anovi', '64', 131),
  (2231, 'Novaci', '71', 131),
  (2232, 'Gostivar', '34', 131),
  (2233, 'Cucer-Sandevo', '20', 131),
  (2234, 'Demir Kapija', '25', 131),
  (2235, 'Oblesevo', '73', 131),
  (2236, 'Caska', '15', 131),
  (2237, 'Murtino', '68', 131),
  (2238, 'Demir Hisar', '24', 131),
  (2239, 'Probistip', '83', 131),
  (2240, 'Makedonski Brod', '63', 131),
  (2241, 'Karpos', '41', 131),
  (2242, 'Bistrica', '05', 131),
  (2243, 'Sopiste', '92', 131),
  (2244, 'Kumanovo', '57', 131),
  (2245, 'Kavadarci', '42', 131),
  (2246, 'Prilep', '82', 131),
  (2247, 'Kocani', '46', 131),
  (2248, 'Samokov', '89', 131),
  (2249, 'Klecevce', '45', 131),
  (2250, 'Dolneni', '28', 131),
  (2251, 'Dolna Banjica', '27', 131),
  (2252, 'Vratnica', 'B8', 131),
  (2253, 'Mogila', '67', 131),
  (2254, 'Berovo', '04', 131),
  (2255, 'Brvenica', '12', 131),
  (2256, 'Makedonska Kamenica', '62', 131),
  (2257, 'Sipkovica', '91', 131),
  (2258, 'Delogozdi', '23', 131),
  (2259, 'Delcevo', '22', 131),
  (2260, 'Vinica', 'B4', 131),
  (2261, 'Bogomila', '09', 131),
  (2262, 'Bitola', '06', 131),
  (2263, 'Blatec', '07', 131),
  (2264, 'Cegrane', '16', 131),
  (2265, 'Kratovo', '51', 131),
  (2266, 'Bogdanci', '08', 131),
  (2267, 'Konopiste', '49', 131),
  (2268, 'Zelino', 'C3', 131),
  (2269, 'Labunista', '58', 131),
  (2270, 'Suto Orizari', 'A3', 131),
  (2271, 'Tearce', 'A5', 131),
  (2272, 'Vrutok', 'B9', 131),
  (2273, 'Staravina', '95', 131),
  (2274, 'Negotino', '69', 131),
  (2275, 'Drugovo', '30', 131),
  (2276, 'Zletovo', 'C5', 131),
  (2277, 'Pehcevo', '78', 131),
  (2278, 'Cesinovo', '19', 131),
  (2279, 'Capari', '14', 131),
  (2280, 'Kukurecani', '56', 131),
  (2281, 'Vrapciste', 'B7', 131),
  (2282, 'Rosoman', '87', 131),
  (2283, 'Velesta', 'B2', 131),
  (2284, 'Konce', '47', 131),
  (2285, 'Gradsko', '35', 131),
  (2286, 'Kosel', '50', 131),
  (2287, 'Kisela Voda', '44', 131),
  (2288, 'Jegunovce', '38', 131),
  (2289, 'Plasnica', '80', 131),
  (2290, 'Kamenjane', '39', 131),
  (2291, 'Izvor', '37', 131),
  (2292, 'Struga', '99', 131),
  (2293, 'Podares', '81', 131),
  (2294, 'Tetovo', 'A6', 131),
  (2295, 'Meseista', '65', 131),
  (2296, 'Vevcani', 'B3', 131),
  (2297, 'Zrnovci', 'C6', 131),
  (2298, 'Kicevo', '43', 131),
  (2299, 'Kuklis', '55', 131),
  (2300, 'Koulikoro', '07', 132),
  (2301, 'Mopti', '04', 132),
  (2302, 'Kayes', '03', 132),
  (2303, '', '02', 132),
  (2304, '', '00', 132),
  (2305, 'Tombouctou', '08', 132),
  (2306, 'Segou', '05', 132),
  (2307, 'Sikasso', '06', 132),
  (2308, 'Bamako', '01', 132),
  (2309, 'Gao', '09', 132),
  (2310, 'Kidal', '10', 132),
  (2311, 'Pegu', '09', 133),
  (2312, 'Mon State', '13', 133),
  (2313, 'Kachin State', '04', 133),
  (2314, 'Rakhine State', '01', 133),
  (2315, 'Yangon', '17', 133),
  (2316, 'Irrawaddy', '03', 133),
  (2317, 'Tenasserim', '12', 133),
  (2318, 'Karan State', '05', 133),
  (2319, 'Sagaing', '10', 133),
  (2320, 'Magwe', '07', 133),
  (2321, 'Chin State', '02', 133),
  (2322, 'Shan State', '11', 133),
  (2323, 'Mandalay', '08', 133),
  (2324, '', '15', 133),
  (2325, '', '16', 133),
  (2326, 'Kayah State', '06', 133),
  (2327, '', '22', 133),
  (2328, 'Dornogovi', '07', 134),
  (2329, 'Omnogovi', '14', 134),
  (2330, 'Dundgovi', '08', 134),
  (2331, 'Dzavhan', '09', 134),
  (2332, 'Tov', '18', 134),
  (2333, 'Suhbaatar', '17', 134),
  (2334, 'Bulgan', '21', 134),
  (2335, 'Arhangay', '01', 134),
  (2336, 'Govisumber', '24', 134),
  (2337, 'Hentiy', '11', 134),
  (2338, 'Bayan-Olgiy', '03', 134),
  (2339, 'Dornod', '06', 134),
  (2340, 'Hovsgol', '13', 134),
  (2341, 'Govi-Altay', '10', 134),
  (2342, 'Hovd', '12', 134),
  (2343, 'Selenge', '16', 134),
  (2344, 'Bayanhongor', '02', 134),
  (2345, 'Ulaanbaatar', '20', 134),
  (2346, 'Ovorhangay', '15', 134),
  (2347, 'Uvs', '19', 134),
  (2348, 'Darhan-Uul', '23', 134),
  (2349, 'Orhon', '25', 134),
  (2350, 'Ilhas', '01', 135),
  (2351, '', '18', 136),
  (2352, '', '12', 136),
  (2353, '', '15', 136),
  (2354, '', '19', 136),
  (2355, '', '16', 136),
  (2356, '', '23', 136),
  (2357, '', '14', 136),
  (2358, '', '13', 136),
  (2359, '', '17', 136),
  (2360, '', '20', 136),
  (2361, '', '00', 136),
  (2362, '', '00', 137),
  (2363, 'Brakna', '05', 138),
  (2364, 'Hodh Ech Chargui', '01', 138),
  (2365, 'Gorgol', '04', 138),
  (2366, 'Assaba', '03', 138),
  (2367, 'Guidimaka', '10', 138),
  (2368, 'Adrar', '07', 138),
  (2369, 'Hodh El Gharbi', '02', 138),
  (2370, 'Tiris Zemmour', '11', 138),
  (2371, 'Inchiri', '12', 138),
  (2372, 'Trarza', '06', 138),
  (2373, 'Dakhlet Nouadhibou', '08', 138),
  (2374, '', '00', 138),
  (2375, 'Tagant', '09', 138),
  (2376, 'Saint Anthony', '01', 139),
  (2377, 'Saint Peter', '03', 139),
  (2378, 'Saint Georges', '02', 139),
  (2379, '', '00', 140),
  (2380, 'Port Louis', '18', 141),
  (2381, 'Black River', '12', 141),
  (2382, 'Moka', '15', 141),
  (2383, 'Riviere du Rempart', '19', 141),
  (2384, 'Pamplemousses', '16', 141),
  (2385, 'Rodrigues', '23', 141),
  (2386, 'Grand Port', '14', 141),
  (2387, 'Flacq', '13', 141),
  (2388, 'Plaines Wilhems', '17', 141),
  (2389, 'Savanne', '20', 141),
  (2390, '', '00', 141),
  (2391, '', '26', 142),
  (2392, 'Seenu', '01', 142),
  (2393, 'Maale', '40', 142),
  (2394, 'Nkhotakota', '18', 143),
  (2395, 'Rumphi', '21', 143),
  (2396, 'Mzimba', '15', 143),
  (2397, 'Lilongwe', '11', 143),
  (2398, 'Ntchisi', '20', 143),
  (2399, 'Salima', '22', 143),
  (2400, 'Mchinji', '13', 143),
  (2401, 'Chitipa', '04', 143),
  (2402, 'Ntcheu', '16', 143),
  (2403, 'Dowa', '07', 143),
  (2404, 'Kasungu', '09', 143),
  (2405, 'Zomba', '23', 143),
  (2406, 'Nsanje', '19', 143),
  (2407, 'Chikwawa', '02', 143),
  (2408, 'Thyolo', '05', 143),
  (2409, 'Dedza', '06', 143),
  (2410, 'Balaka', '26', 143),
  (2411, 'Mangochi', '12', 143),
  (2412, 'Machinga', '28', 143),
  (2413, 'Nkhata Bay', '17', 143),
  (2414, 'Chiradzulu', '03', 143),
  (2415, 'Blantyre', '24', 143),
  (2416, 'Karonga', '08', 143),
  (2417, 'Phalombe', '30', 143),
  (2418, 'Mwanza', '25', 143),
  (2419, 'Mulanje', '29', 143),
  (2420, 'Michoacan de Ocampo', '16', 144),
  (2421, 'Chihuahua', '06', 144),
  (2422, 'Veracruz-Llave', '30', 144),
  (2423, 'Yucatan', '31', 144),
  (2424, 'Quintana Roo', '23', 144),
  (2425, 'Sonora', '26', 144),
  (2426, 'Tlaxcala', '29', 144),
  (2427, 'Chiapas', '05', 144),
  (2428, 'Coahuila de Zaragoza', '07', 144),
  (2429, 'Durango', '10', 144),
  (2430, 'Guanajuato', '11', 144),
  (2431, 'Nuevo Leon', '19', 144),
  (2432, 'Oaxaca', '20', 144),
  (2433, 'Tabasco', '27', 144),
  (2434, 'Tamaulipas', '28', 144),
  (2435, 'Guerrero', '12', 144),
  (2436, 'Baja California', '02', 144),
  (2437, 'Campeche', '04', 144),
  (2438, 'Nayarit', '18', 144),
  (2439, 'Puebla', '21', 144),
  (2440, 'Sinaloa', '25', 144),
  (2441, 'Aguascalientes', '01', 144),
  (2442, 'San Luis Potosi', '24', 144),
  (2443, 'Zacatecas', '32', 144),
  (2444, 'Mexico', '15', 144),
  (2445, 'Jalisco', '14', 144),
  (2446, 'Hidalgo', '13', 144),
  (2447, 'Morelos', '17', 144),
  (2448, 'Colima', '08', 144),
  (2449, 'Queretaro de Arteaga', '22', 144),
  (2450, 'Baja California Sur', '03', 144),
  (2451, 'Distrito Federal', '09', 144),
  (2452, 'Sarawak', '11', 145),
  (2453, 'Sabah', '16', 145),
  (2454, 'Melaka', '04', 145),
  (2455, 'Perlis', '08', 145),
  (2456, 'Negeri Sembilan', '05', 145),
  (2457, 'Kedah', '02', 145),
  (2458, 'Johor', '01', 145),
  (2459, 'Perak', '07', 145),
  (2460, 'Pulau Pinang', '09', 145),
  (2461, 'Terengganu', '13', 145),
  (2462, 'Kelantan', '03', 145),
  (2463, 'Pahang', '06', 145),
  (2464, 'Kuala Lumpur', '14', 145),
  (2465, 'Selangor', '12', 145),
  (2466, 'Labuan', '15', 145),
  (2467, 'Maputo', '04', 146),
  (2468, 'Nampula', '06', 146),
  (2469, 'Zambezia', '09', 146),
  (2470, 'Niassa', '07', 146),
  (2471, 'Cabo Delgado', '01', 146),
  (2472, 'Gaza', '02', 146),
  (2473, 'Inhambane', '03', 146),
  (2474, 'Manica', '10', 146),
  (2475, 'Tete', '08', 146),
  (2476, 'Sofala', '05', 146),
  (2477, '', '00', 146),
  (2478, 'Hardap', '30', 147),
  (2479, 'Otjozondjupa', '39', 147),
  (2480, '', '40', 147),
  (2481, 'Karas', '31', 147),
  (2482, 'Omusati', '36', 147),
  (2483, 'Oshana', '37', 147),
  (2484, 'Kunene', '32', 147),
  (2485, 'Erongo', '29', 147),
  (2486, 'Oshikoto', '38', 147),
  (2487, 'Omaheke', '35', 147),
  (2488, 'Caprivi', '28', 147),
  (2489, 'Okavango', '34', 147),
  (2490, 'Ohangwena', '33', 147),
  (2491, 'Windhoek', '21', 147),
  (2492, '', '00', 148),
  (2493, 'Niamey', '05', 149),
  (2494, 'Diffa', '02', 149),
  (2495, '', '09', 149),
  (2496, 'Tahoua', '06', 149),
  (2497, 'Agadez', '01', 149),
  (2498, 'Zinder', '07', 149),
  (2499, 'Dosso', '03', 149),
  (2500, 'Maradi', '04', 149),
  (2501, 'Niamey', '08', 149),
  (2502, '', '00', 150),
  (2503, '', '10', 151),
  (2504, 'Benue', '26', 151),
  (2505, 'Nassarawa', '56', 151),
  (2506, 'Kaduna', '23', 151),
  (2507, 'Oyo', '32', 151),
  (2508, 'Adamawa', '35', 151),
  (2509, 'Osun', '42', 151),
  (2510, 'Borno', '27', 151),
  (2511, 'Bauchi', '46', 151),
  (2512, '', '12', 151),
  (2513, 'Ogun', '16', 151),
  (2514, 'Anambra', '25', 151),
  (2515, 'Yobe', '44', 151),
  (2516, 'Lagos', '05', 151),
  (2517, 'Delta', '36', 151),
  (2518, 'Enugu', '47', 151),
  (2519, 'Federal Capital Territory', '11', 151),
  (2520, 'Kogi', '41', 151),
  (2521, 'Taraba', '43', 151),
  (2522, 'Akwa Ibom', '21', 151),
  (2523, 'Ebonyi', '53', 151),
  (2524, '', '18', 151),
  (2525, 'Imo', '28', 151),
  (2526, 'Jigawa', '39', 151),
  (2527, '', '17', 151),
  (2528, 'Kwara', '30', 151),
  (2529, 'Abia', '45', 151),
  (2530, 'Gombe', '55', 151),
  (2531, 'Cross River', '22', 151),
  (2532, 'Katsina', '24', 151),
  (2533, 'Sokoto', '51', 151),
  (2534, 'Niger', '31', 151),
  (2535, 'Zamfara', '57', 151),
  (2536, 'Edo', '37', 151),
  (2537, '', '34', 151),
  (2538, 'Kano', '29', 151),
  (2539, 'Kebbi', '40', 151),
  (2540, 'Ekiti', '54', 151),
  (2541, 'Bayelsa', '52', 151),
  (2542, 'Plateau', '49', 151),
  (2543, 'Ondo', '48', 151),
  (2544, 'Rivers', '50', 151),
  (2545, '', '00', 151),
  (2546, '', '20', 151),
  (2547, 'Leon', '08', 152),
  (2548, 'Chontales', '04', 152),
  (2549, 'Managua', '10', 152),
  (2550, 'Autonoma Atlantico Norte', '17', 152),
  (2551, 'Granada', '06', 152),
  (2552, 'Matagalpa', '12', 152),
  (2553, 'Boaco', '01', 152),
  (2554, 'Carazo', '02', 152),
  (2555, 'Chinandega', '03', 152),
  (2556, 'Rio San Juan', '14', 152),
  (2557, 'Rivas', '15', 152),
  (2558, 'Masaya', '11', 152),
  (2559, 'Jinotega', '07', 152),
  (2560, 'Nueva Segovia', '13', 152),
  (2561, 'Region Autonoma Atlantico Sur', '18', 152),
  (2562, 'Madriz', '09', 152),
  (2563, 'Esteli', '05', 152),
  (2564, 'Drenthe', '01', 153),
  (2565, 'Zuid-Holland', '11', 153),
  (2566, 'Overijssel', '15', 153),
  (2567, 'Noord-Holland', '07', 153),
  (2568, 'Zeeland', '10', 153),
  (2569, 'Limburg', '05', 153),
  (2570, 'Noord-Brabant', '06', 153),
  (2571, 'Gelderland', '03', 153),
  (2572, 'Friesland', '02', 153),
  (2573, 'Groningen', '04', 153),
  (2574, 'Utrecht', '09', 153),
  (2575, 'Flevoland', '16', 153),
  (2576, 'Nordland', '09', 154),
  (2577, 'Sor-Trondelag', '16', 154),
  (2578, 'Troms', '18', 154),
  (2579, 'Vestfold', '20', 154),
  (2580, 'Hedmark', '06', 154),
  (2581, 'Hordaland', '07', 154),
  (2582, 'Vest-Agder', '19', 154),
  (2583, 'More og Romsdal', '08', 154),
  (2584, 'Telemark', '17', 154),
  (2585, 'Buskerud', '04', 154),
  (2586, 'Rogaland', '14', 154),
  (2587, 'Aust-Agder', '02', 154),
  (2588, 'Oppland', '11', 154),
  (2589, 'Sogn og Fjordane', '15', 154),
  (2590, 'Akershus', '01', 154),
  (2591, 'Nord-Trondelag', '10', 154),
  (2592, 'Ostfold', '13', 154),
  (2593, 'Finnmark', '05', 154),
  (2594, 'Oslo', '12', 154),
  (2595, '', '00', 155),
  (2596, '', '00', 156),
  (2597, '', '00', 157),
  (2598, 'Wellington', 'G2', 158),
  (2599, 'West Coast', 'G3', 158),
  (2600, 'Canterbury', 'E9', 158),
  (2601, 'Otago', 'F7', 158),
  (2602, 'Auckland', 'E7', 158),
  (2603, 'Gisborne', 'F1', 158),
  (2604, 'Hawke\'s Bay', 'F2', 158),
  (2605, 'Taranaki', 'F9', 158),
  (2606, 'Marlborough', 'F4', 158),
  (2607, 'Nelson', 'F5', 158),
  (2608, 'Waikato', 'G1', 158),
  (2609, 'Southland', 'F8', 158),
  (2610, '', '85', 158),
  (2611, 'Bay of Plenty', 'E8', 158),
  (2612, '', '00', 158),
  (2613, 'Manawatu-Wanganui', 'F3', 158),
  (2614, 'Al Batinah', '02', 159),
  (2615, 'Az Zahirah', '05', 159),
  (2616, 'Ash Sharqiyah', '04', 159),
  (2617, 'Masqat', '06', 159),
  (2618, 'Musandam', '07', 159),
  (2619, 'Zufar', '08', 159),
  (2620, '', '00', 159),
  (2621, 'Los Santos', '07', 160),
  (2622, 'Darien', '05', 160),
  (2623, 'Chiriqui', '02', 160),
  (2624, 'Colon', '04', 160),
  (2625, 'Veraguas', '10', 160),
  (2626, 'San Blas', '09', 160),
  (2627, 'Bocas del Toro', '01', 160),
  (2628, 'Herrera', '06', 160),
  (2629, 'Panama', '08', 160),
  (2630, 'Cocle', '03', 160),
  (2631, 'Ancash', '02', 161),
  (2632, 'Apurimac', '03', 161),
  (2633, 'Arequipa', '04', 161),
  (2634, 'Ica', '11', 161),
  (2635, 'Cusco', '08', 161),
  (2636, 'Lambayeque', '14', 161),
  (2637, 'Ucayali', '25', 161),
  (2638, 'La Libertad', '13', 161),
  (2639, 'Ayacucho', '05', 161),
  (2640, 'Lima', '15', 161),
  (2641, 'Puno', '21', 161),
  (2642, 'Junin', '12', 161),
  (2643, 'Tumbes', '24', 161),
  (2644, 'Tacna', '23', 161),
  (2645, 'Cajamarca', '06', 161),
  (2646, 'Huancavelica', '09', 161),
  (2647, 'Moquegua', '18', 161),
  (2648, 'Amazonas', '01', 161),
  (2649, 'Huanuco', '10', 161),
  (2650, 'San Martin', '22', 161),
  (2651, 'Piura', '20', 161),
  (2652, 'Loreto', '16', 161),
  (2653, 'Pasco', '19', 161),
  (2654, 'Madre de Dios', '17', 161),
  (2655, 'Callao', '07', 161),
  (2656, '', '00', 162),
  (2657, 'Eastern Highlands', '09', 163),
  (2658, 'Madang', '12', 163),
  (2659, 'Milne Bay', '03', 163),
  (2660, 'Western', '06', 163),
  (2661, 'Central', '01', 163),
  (2662, 'Sandaun', '18', 163),
  (2663, 'East Sepik', '11', 163),
  (2664, 'West New Britain', '17', 163),
  (2665, 'Southern Highlands', '05', 163),
  (2666, 'Northern', '04', 163),
  (2667, 'Gulf', '02', 163),
  (2668, 'Western Highlands', '16', 163),
  (2669, 'Morobe', '14', 163),
  (2670, 'Chimbu', '08', 163),
  (2671, 'East New Britain', '10', 163),
  (2672, 'North Solomons', '07', 163),
  (2673, 'Enga', '19', 163),
  (2674, 'Manus', '13', 163),
  (2675, 'New Ireland', '15', 163),
  (2676, 'National Capital', '20', 163),
  (2677, 'Pangasinan', '51', 164),
  (2678, 'Cebu', '21', 164),
  (2679, 'Samar', '55', 164),
  (2680, 'Camarines Sur', '16', 164),
  (2681, 'Iloilo', '30', 164),
  (2682, 'Ilocos Norte', '28', 164),
  (2683, 'Antique', '06', 164),
  (2684, 'Bohol', '11', 164),
  (2685, 'Cagayan', '14', 164),
  (2686, 'Eastern Samar', '23', 164),
  (2687, 'Davao', '24', 164),
  (2688, 'Leyte', '37', 164),
  (2689, 'Masbate', '39', 164),
  (2690, 'Negros Occidental', '45', 164),
  (2691, 'Nueva Vizcaya', '48', 164),
  (2692, 'Romblon', '54', 164),
  (2693, 'South Cotabato', '70', 164),
  (2694, 'Ilocos Sur', '29', 164),
  (2695, 'Quezon', 'H2', 164),
  (2696, 'Lanao del Norte', '34', 164),
  (2697, 'North Cotabato', '57', 164),
  (2698, 'Surigao del Sur', '62', 164),
  (2699, 'Iligan', 'C8', 164),
  (2700, 'Southern Leyte', '59', 164),
  (2701, 'Tarlac', '63', 164),
  (2702, 'Bukidnon', '12', 164),
  (2703, 'Mindoro Occidental', '40', 164),
  (2704, 'Palawan', '49', 164),
  (2705, 'Abra', '01', 164),
  (2706, 'Bulacan', '13', 164),
  (2707, 'Capiz', '18', 164),
  (2708, 'Nueva Ecija', '47', 164),
  (2709, 'Sorsogon', '58', 164),
  (2710, 'Benguet', '10', 164),
  (2711, 'Northern Samar', '67', 164),
  (2712, 'Quirino', '68', 164),
  (2713, 'Isabela', '31', 164),
  (2714, 'Kalinga-Apayao', '32', 164),
  (2715, 'Mountain', '44', 164),
  (2716, 'Albay', '05', 164),
  (2717, 'Batangas', '09', 164),
  (2718, 'Catanduanes', '19', 164),
  (2719, 'Negros Oriental', '46', 164),
  (2720, 'Ifugao', '27', 164),
  (2721, 'Misamis Oriental', '43', 164),
  (2722, 'Laguna', '33', 164),
  (2723, 'Zamboanga del Sur', '66', 164),
  (2724, 'Camiguin', '17', 164),
  (2725, 'Negros Occidental', 'H3', 164),
  (2726, 'Bataan', '07', 164),
  (2727, 'Lanao del Sur', '35', 164),
  (2728, 'Basilan', '22', 164),
  (2729, 'La Union', '36', 164),
  (2730, 'Camarines Norte', '15', 164),
  (2731, 'Caloocan', 'B4', 164),
  (2732, 'Legaspi', 'D5', 164),
  (2733, 'Calbayog', 'B3', 164),
  (2734, 'Agusan del Norte', '02', 164),
  (2735, 'Pampanga', '50', 164),
  (2736, 'Mindoro Oriental', '41', 164),
  (2737, '', 'K8', 164),
  (2738, 'Sulu', '60', 164),
  (2739, 'Cebu City', 'B7', 164),
  (2740, 'Roxas', 'F3', 164),
  (2741, 'Misamis Occidental', '42', 164),
  (2742, 'Aklan', '04', 164),
  (2743, 'Maguindanao', '56', 164),
  (2744, 'Dumaguete', 'C5', 164),
  (2745, 'Surigao del Norte', '61', 164),
  (2746, 'Ormoc', 'E4', 164),
  (2747, 'Davao del Sur', '25', 164),
  (2748, 'Zambales', '64', 164),
  (2749, 'Agusan del Sur', '03', 164),
  (2750, '', 'K4', 164),
  (2751, 'Lapu-Lapu', 'D4', 164),
  (2752, 'Marinduque', '38', 164),
  (2753, 'Rizal', '53', 164),
  (2754, 'Butuan', 'A8', 164),
  (2755, 'Cagayan de Oro', 'B2', 164),
  (2756, 'Pasay', 'E9', 164),
  (2757, 'Sultan Kudarat', '71', 164),
  (2758, 'Davao City', 'C3', 164),
  (2759, 'Cavite', '20', 164),
  (2760, 'Iloilo City', 'C9', 164),
  (2761, 'Silay', 'F8', 164),
  (2762, 'Pagadian', 'E7', 164),
  (2763, 'Trece Martires', 'G6', 164),
  (2764, 'Quezon City', 'F2', 164),
  (2765, 'Siquijor', '69', 164),
  (2766, 'Cotabato', 'B8', 164),
  (2767, 'Angeles', 'A1', 164),
  (2768, 'Toledo', 'G5', 164),
  (2769, 'San Carlos', 'F4', 164),
  (2770, 'Lipa', 'D6', 164),
  (2771, 'Davao Oriental', '26', 164),
  (2772, 'Tacloban', 'G1', 164),
  (2773, 'Tawitawi', '72', 164),
  (2774, '', 'H5', 164),
  (2775, 'Zamboanga del Norte', '65', 164),
  (2776, 'Zamboanga', 'G7', 164),
  (2777, 'Bacolod', 'A2', 164),
  (2778, 'Marawi', 'E1', 164),
  (2779, 'Aurora', 'G8', 164),
  (2780, 'Ozamis', 'E6', 164),
  (2781, 'Danao', 'C1', 164),
  (2782, 'Bago', 'A3', 164),
  (2783, 'Cabanatuan', 'A9', 164),
  (2784, '', 'L8', 164),
  (2785, 'Baguio', 'A4', 164),
  (2786, 'Tangub', 'G4', 164),
  (2787, 'Naga', 'E2', 164),
  (2788, 'Olongapo', 'E3', 164),
  (2789, 'San Pablo', 'F7', 164),
  (2790, 'Oroquieta', 'E5', 164),
  (2791, 'Manila', 'D9', 164),
  (2792, 'San Juan', 'M6', 164),
  (2793, 'General Santos', 'C6', 164),
  (2794, 'Dapitan', 'C2', 164),
  (2795, 'Canlaon', 'B5', 164),
  (2796, 'Dagupan', 'B9', 164),
  (2797, '', 'K9', 164),
  (2798, 'Batanes', '08', 164),
  (2799, 'Batangas City', 'A7', 164),
  (2800, 'Dipolog', 'C4', 164),
  (2801, '', 'N6', 164),
  (2802, 'Tagbilaran', 'G3', 164),
  (2803, 'Cadiz', 'B1', 164),
  (2804, 'Mandaue', 'D8', 164),
  (2805, 'Cavite City', 'B6', 164),
  (2806, 'Tagaytay', 'G2', 164),
  (2807, 'Gingoog', 'C7', 164),
  (2808, 'Iriga', 'D1', 164),
  (2809, 'Paranaque', 'L7', 164),
  (2810, '', 'O7', 164),
  (2811, 'La Carlota', 'D2', 164),
  (2812, 'Laoag', 'D3', 164),
  (2813, 'Lucena', 'D7', 164),
  (2814, 'Malaybalay', 'K6', 164),
  (2815, 'Palayan', 'E8', 164),
  (2816, 'Puerto Princesa', 'F1', 164),
  (2817, 'Surigao', 'F9', 164),
  (2818, 'Punjab', '04', 165),
  (2819, 'Sindh', '05', 165),
  (2820, 'Balochistan', '02', 165),
  (2821, 'North-West Frontier', '03', 165),
  (2822, 'Northern Areas', '07', 165),
  (2823, 'Federally Administered Tribal Areas', '01', 165),
  (2824, 'Azad Kashmir', '06', 165),
  (2825, 'Islamabad', '08', 165),
  (2826, '', '47', 166),
  (2827, '', '45', 166),
  (2828, '', '70', 166),
  (2829, '', '39', 166),
  (2830, '', '27', 166),
  (2831, '', '49', 166),
  (2832, '', '61', 166),
  (2833, 'Zachodniopomorskie', '87', 166),
  (2834, '', '24', 166),
  (2835, 'Swietokrzyskie', '84', 166),
  (2836, '', '63', 166),
  (2837, '', '36', 166),
  (2838, '', '37', 166),
  (2839, '', '64', 166),
  (2840, '', '68', 166),
  (2841, '', '25', 166),
  (2842, '', '26', 166),
  (2843, '', '29', 166),
  (2844, '', '43', 166),
  (2845, '', '51', 166),
  (2846, '', '52', 166),
  (2847, '', '55', 166),
  (2848, '', '57', 166),
  (2849, '', '58', 166),
  (2850, '', '59', 166),
  (2851, '', '67', 166),
  (2852, '', '35', 166),
  (2853, '', '54', 166),
  (2854, '', '28', 166),
  (2855, '', '71', 166),
  (2856, '', '30', 166),
  (2857, '', '50', 166),
  (2858, '', '53', 166),
  (2859, '', '48', 166),
  (2860, '', '34', 166),
  (2861, '', '56', 166),
  (2862, '', '66', 166),
  (2863, '', '23', 166),
  (2864, 'Lodzkie', '74', 166),
  (2865, '', '44', 166),
  (2866, 'Warminsko-Mazurskie', '85', 166),
  (2867, '', '32', 166),
  (2868, '', '69', 166),
  (2869, '', '31', 166),
  (2870, '', '60', 166),
  (2871, '', '33', 166),
  (2872, 'Malopolskie', '77', 166),
  (2873, '', '46', 166),
  (2874, 'Mazowieckie', '78', 166),
  (2875, '', '65', 166),
  (2876, 'Podlaskie', '81', 166),
  (2877, '', '40', 166),
  (2878, '', '41', 166),
  (2879, '', '42', 166),
  (2880, 'Podkarpackie', '80', 166),
  (2881, 'Lubuskie', '76', 166),
  (2882, 'Dolnoslaskie', '72', 166),
  (2883, 'Lubelskie', '75', 166),
  (2884, 'Pomorskie', '82', 166),
  (2885, 'Kujawsko-Pomorskie', '73', 166),
  (2886, 'Wielkopolskie', '86', 166),
  (2887, 'Slaskie', '83', 166),
  (2888, 'Opolskie', '79', 166),
  (2889, '', '38', 166),
  (2890, '', '00', 167),
  (2891, '', '00', 168),
  (2892, '', '00', 169),
  (2893, 'Braga', '04', 170),
  (2894, 'Vila Real', '21', 170),
  (2895, 'Santarem', '18', 170),
  (2896, 'Leiria', '13', 170),
  (2897, 'Lisboa', '14', 170),
  (2898, 'Braganca', '05', 170),
  (2899, 'Viana do Castelo', '20', 170),
  (2900, 'Portalegre', '16', 170),
  (2901, 'Setubal', '19', 170),
  (2902, 'Azores', '23', 170),
  (2903, 'Viseu', '22', 170),
  (2904, 'Porto', '17', 170),
  (2905, 'Aveiro', '02', 170),
  (2906, 'Castelo Branco', '06', 170),
  (2907, 'Faro', '09', 170),
  (2908, 'Coimbra', '07', 170),
  (2909, 'Madeira', '10', 170),
  (2910, 'Beja', '03', 170),
  (2911, 'Guarda', '11', 170),
  (2912, 'Evora', '08', 170),
  (2913, '', '00', 171),
  (2914, 'Cordillera', '08', 172),
  (2915, 'Alto Parana', '01', 172),
  (2916, 'Caazapa', '05', 172),
  (2917, 'Boqueron', '24', 172),
  (2918, 'Paraguari', '15', 172),
  (2919, 'Amambay', '02', 172),
  (2920, 'Alto Paraguay', '23', 172),
  (2921, 'Canindeyu', '19', 172),
  (2922, 'Concepcion', '07', 172),
  (2923, 'Misiones', '12', 172),
  (2924, 'Caaguazu', '04', 172),
  (2925, 'Neembucu', '13', 172),
  (2926, 'Itapua', '11', 172),
  (2927, 'Central', '06', 172),
  (2928, 'San Pedro', '17', 172),
  (2929, 'Presidente Hayes', '16', 172),
  (2930, 'Guaira', '10', 172),
  (2931, 'Madinat ach Shamal', '08', 173),
  (2932, 'Ad Dawhah', '01', 173),
  (2933, 'Umm Salal', '09', 173),
  (2934, 'Al Khawr', '04', 173),
  (2935, 'Al Jumaliyah', '03', 173),
  (2936, 'Al Wakrah Municipality', '05', 173),
  (2937, '', '00', 174),
  (2938, 'Ilfov', '43', 175),
  (2939, 'Giurgiu', '42', 175),
  (2940, 'Bihor', '05', 175),
  (2941, 'Caras-Severin', '12', 175),
  (2942, 'Mehedinti', '26', 175),
  (2943, 'Vaslui', '38', 175),
  (2944, 'Tulcea', '37', 175),
  (2945, 'Constanta', '14', 175),
  (2946, 'Mures', '27', 175),
  (2947, 'Harghita', '20', 175),
  (2948, 'Alba', '01', 175),
  (2949, 'Arad', '02', 175),
  (2950, 'Hunedoara', '21', 175),
  (2951, 'Satu Mare', '32', 175),
  (2952, 'Sibiu', '33', 175),
  (2953, 'Maramures', '25', 175),
  (2954, 'Brasov', '09', 175),
  (2955, 'Cluj', '13', 175),
  (2956, 'Teleorman', '35', 175),
  (2957, 'Dambovita', '16', 175),
  (2958, 'Dolj', '17', 175),
  (2959, 'Suceava', '34', 175),
  (2960, 'Botosani', '07', 175),
  (2961, 'Iasi', '23', 175),
  (2962, 'Arges', '03', 175),
  (2963, 'Buzau', '11', 175),
  (2964, 'Timis', '36', 175),
  (2965, 'Neamt', '28', 175),
  (2966, 'Bacau', '04', 175),
  (2967, 'Braila', '08', 175),
  (2968, 'Salaj', '31', 175),
  (2969, 'Covasna', '15', 175),
  (2970, 'Bistrita-Nasaud', '06', 175),
  (2971, 'Calarasi', '41', 175),
  (2972, 'Gorj', '19', 175),
  (2973, 'Ialomita', '22', 175),
  (2974, 'Olt', '29', 175),
  (2975, 'Valcea', '39', 175),
  (2976, 'Prahova', '30', 175),
  (2977, 'Vrancea', '40', 175),
  (2978, 'Bucuresti', '10', 175),
  (2979, 'Galati', '18', 175),
  (2980, '\"Vojvodina\"', '02', 0),
  (2981, '\"Kosovo\"', '01', 0),
  (2982, '', '12', 0),
  (2983, 'Moskva', '47', 176),
  (2984, 'Karelia', '28', 176),
  (2985, 'Sakha', '63', 176),
  (2986, '', 'CI', 176),
  (2987, 'Altaisky krai', '04', 176),
  (2988, 'Ivanovo', '21', 176),
  (2989, 'Kostroma', '37', 176),
  (2990, 'Nizhegorod', '51', 176),
  (2991, 'Tver\'', '77', 176),
  (2992, 'Vladimir', '83', 176),
  (2993, 'Perm\'', '58', 176),
  (2994, 'Adygeya', '01', 176),
  (2995, 'Chita', '14', 176),
  (2996, 'Taymyr', '74', 176),
  (2997, 'Kemerovo', '29', 176),
  (2998, 'Udmurt', '80', 176),
  (2999, 'Khakass', '31', 176),
  (3000, 'Vologda', '85', 176),
  (3001, 'Omsk', '54', 176),
  (3002, 'Orenburg', '55', 176),
  (3003, 'Irkutsk', '20', 176),
  (3004, 'Krasnoyarsk', '39', 176),
  (3005, 'Sverdlovsk', '71', 176),
  (3006, 'Tambovskaya oblast', '72', 176),
  (3007, 'Arkhangel\'sk', '06', 176),
  (3008, 'Novosibirsk', '53', 176),
  (3009, 'Ryazan\'', '62', 176),
  (3010, 'Tula', '76', 176),
  (3011, 'Rostov', '61', 176),
  (3012, 'Yaroslavl\'', '88', 176),
  (3013, 'Tatarstan', '73', 176),
  (3014, 'Tyumen\'', '78', 176),
  (3015, 'Penza', '57', 176),
  (3016, 'Saratov', '67', 176),
  (3017, 'Chuvashia', '16', 176),
  (3018, 'Komi', '34', 176),
  (3019, 'Bryansk', '10', 176),
  (3020, 'Samara', '65', 176),
  (3021, '', '82', 176),
  (3022, 'Mariy-El', '45', 176),
  (3023, 'Leningrad', '42', 176),
  (3024, 'Kirov', '33', 176),
  (3025, 'Gorno-Altay', '03', 176),
  (3026, 'Dagestan', '17', 176),
  (3027, 'Kabardin-Balkar', '22', 176),
  (3028, 'Amur', '05', 176),
  (3029, 'North Ossetia', '68', 176),
  (3030, 'Karachay-Cherkess', '27', 176),
  (3031, 'Krasnodar', '38', 176),
  (3032, 'Lipetsk', '43', 176),
  (3033, 'Smolensk', '69', 176),
  (3034, 'Kaliningrad', '23', 176),
  (3035, 'Bashkortostan', '08', 176),
  (3036, 'Chelyabinsk', '13', 176),
  (3037, 'Ul\'yanovsk', '81', 176),
  (3038, 'Stavropol\'', '70', 176),
  (3039, 'Kurgan', '40', 176),
  (3040, 'Astrakhan\'', '07', 176),
  (3041, 'Volgograd', '84', 176),
  (3042, 'Kalmyk', '24', 176),
  (3043, 'Kaluga', '25', 176),
  (3044, 'Magadan', '44', 176),
  (3045, 'Pskov', '60', 176),
  (3046, 'Orel', '56', 176),
  (3047, 'Primor\'ye', '59', 176),
  (3048, 'Belgorod', '09', 176),
  (3049, 'Buryat', '11', 176),
  (3050, 'Tomsk', '75', 176),
  (3051, 'Murmansk', '49', 176),
  (3052, '', '35', 176),
  (3053, 'Sakhalin', '64', 176),
  (3054, 'Voronezh', '86', 176),
  (3055, 'Novgorod', '52', 176),
  (3056, 'Mordovia', '46', 176),
  (3057, 'Kamchatka', '26', 176),
  (3058, 'Khabarovsk', '30', 176),
  (3059, 'Koryak', '36', 176),
  (3060, 'Chukot', '15', 176),
  (3061, 'Khanty-Mansiy', '32', 176),
  (3062, 'Kursk', '41', 176),
  (3063, 'Aginsky Buryatsky AO', '02', 176),
  (3064, 'Tuva', '79', 176),
  (3065, 'Nenets', '50', 176),
  (3066, 'Evenk', '18', 176),
  (3067, 'Yevrey', '89', 176),
  (3068, '', 'JA', 176),
  (3069, 'Yamal-Nenets', '87', 176),
  (3070, 'Saint Petersburg City', '66', 176),
  (3071, 'Moscow City', '48', 176),
  (3072, 'Kigali', '09', 177),
  (3073, 'Butare', '01', 177),
  (3074, '', '03', 177),
  (3075, '', '05', 177),
  (3076, '', '02', 177),
  (3077, 'Kibungo', '07', 177),
  (3078, '', '10', 177),
  (3079, '', '04', 177),
  (3080, 'Gitarama', '06', 177),
  (3081, '', '08', 177),
  (3082, 'Makkah', '14', 178),
  (3083, 'Ar Riyad', '10', 178),
  (3084, 'Ha\'il', '13', 178),
  (3085, 'Al Hudud ash Shamaliyah', '15', 178),
  (3086, 'Jizan', '17', 178),
  (3087, 'Ash Sharqiyah', '06', 178),
  (3088, 'Al Madinah', '05', 178),
  (3089, 'Al Qasim', '08', 178),
  (3090, 'Al Bahah', '02', 178),
  (3091, 'Tabuk', '19', 178),
  (3092, 'Al Jawf', '20', 178),
  (3093, '', '00', 178),
  (3094, 'Makira', '08', 179),
  (3095, '', '00', 179),
  (3096, 'Beau Vallon', '08', 180),
  (3097, '', '00', 180),
  (3098, 'Bahr al Ghazal', '32', 181),
  (3099, '', '26', 181),
  (3100, 'River Nile', '53', 181),
  (3101, 'Darfur', '33', 181),
  (3102, 'Kurdufan', '34', 181),
  (3103, 'Al Wusta', '27', 181),
  (3104, 'Ash Shamaliyah', '30', 181),
  (3105, 'Ash Sharqiyah', '31', 181),
  (3106, 'Al Istiwa\'iyah', '28', 181),
  (3107, '', '38', 181),
  (3108, '', '37', 181),
  (3109, '', '51', 181),
  (3110, 'Al Khartum', '29', 181),
  (3111, '', '42', 181),
  (3112, '', '47', 181),
  (3113, 'Northern Darfur', '55', 181),
  (3114, '', '48', 181),
  (3115, '', '56', 181),
  (3116, '', '39', 181),
  (3117, '', '36', 181),
  (3118, '', '54', 181),
  (3119, 'Central Equatoria State', '44', 181),
  (3120, 'Al Wahadah State', '40', 181),
  (3121, 'Kassala', '52', 181),
  (3122, '', '43', 181),
  (3123, '', '57', 181),
  (3124, 'Southern Kordofan', '50', 181),
  (3125, '', '', 181),
  (3126, 'Upper Nile', '35', 181),
  (3127, 'Southern Darfur', '49', 181),
  (3128, '', '41', 181),
  (3129, '', '58', 181),
  (3130, '', '59', 181),
  (3131, '', '46', 181),
  (3132, '', '45', 181),
  (3133, 'Vasternorrlands Lan', '24', 182),
  (3134, 'Vastra Gotaland', '28', 182),
  (3135, 'Norrbottens Lan', '14', 182),
  (3136, 'Vasterbottens Lan', '23', 182),
  (3137, 'Skane Lan', '27', 182),
  (3138, 'Kalmar Lan', '09', 182),
  (3139, 'Jamtlands Lan', '07', 182),
  (3140, 'Kronobergs Lan', '12', 182),
  (3141, 'Ostergotlands Lan', '16', 182),
  (3142, 'Stockholms Lan', '26', 182),
  (3143, 'Dalarnas Lan', '10', 182),
  (3144, 'Blekinge Lan', '02', 182),
  (3145, 'Gavleborgs Lan', '03', 182),
  (3146, 'Sodermanlands Lan', '18', 182),
  (3147, 'Vastmanlands Lan', '25', 182),
  (3148, 'Varmlands Lan', '22', 182),
  (3149, 'Hallands Lan', '06', 182),
  (3150, 'Orebro Lan', '15', 182),
  (3151, 'Uppsala Lan', '21', 182),
  (3152, 'Jonkopings Lan', '08', 182),
  (3153, 'Gotlands Lan', '05', 182),
  (3154, '', '00', 183),
  (3155, '', '00', 184),
  (3156, 'Bohinj Commune', '04', 185),
  (3157, 'Brezovica Commune', '09', 185),
  (3158, '', '00', 185),
  (3159, '', '00', 186),
  (3160, 'Kosice', '03', 187),
  (3161, 'Banska Bystrica', '01', 187),
  (3162, 'Nitra', '04', 187),
  (3163, 'Trnava', '07', 187),
  (3164, 'Presov', '05', 187),
  (3165, 'Zilina', '08', 187),
  (3166, 'Bratislava', '02', 187),
  (3167, 'Trencin', '06', 187),
  (3168, '', '00', 187),
  (3169, 'Western Area', '04', 188),
  (3170, 'Northern', '02', 188),
  (3171, 'Eastern', '01', 188),
  (3172, 'Southern', '03', 188),
  (3173, 'Acquaviva', '01', 189),
  (3174, 'Chiesanuova', '02', 189),
  (3175, 'San Marino', '07', 189),
  (3176, 'Serravalle', '09', 189),
  (3177, 'Dakar', '01', 190),
  (3178, '', '04', 190),
  (3179, 'Diourbel', '03', 190),
  (3180, '', '08', 190),
  (3181, 'Kolda', '11', 190),
  (3182, 'Ziguinchor', '12', 190),
  (3183, 'Thies', '07', 190),
  (3184, 'Fatick', '09', 190),
  (3185, 'Kaolack', '10', 190),
  (3186, 'Tambacounda', '05', 190),
  (3187, 'Louga', '13', 190),
  (3188, 'Matam', '15', 190),
  (3189, 'Saint-Louis', '14', 190),
  (3190, '', '', 190),
  (3191, 'Bay', '04', 191),
  (3192, 'Shabeellaha Hoose', '14', 191),
  (3193, 'Bakool', '01', 191),
  (3194, 'Hiiraan', '07', 191),
  (3195, 'Gedo', '06', 191),
  (3196, 'Bari', '03', 191),
  (3197, 'Galguduud', '05', 191),
  (3198, 'Mudug', '10', 191),
  (3199, 'Woqooyi Galbeed', '16', 191),
  (3200, 'Jubbada Dhexe', '08', 191),
  (3201, 'Shabeellaha Dhexe', '13', 191),
  (3202, 'Jubbada Hoose', '09', 191),
  (3203, '', '15', 191),
  (3204, 'Nugaal', '11', 191),
  (3205, 'Sanaag', '12', 191),
  (3206, 'Banaadir', '02', 191),
  (3207, '', '17', 191),
  (3208, 'Brokopondo', '10', 192),
  (3209, 'Sipaliwini', '18', 192),
  (3210, 'Marowijne', '13', 192),
  (3211, 'Para', '15', 192),
  (3212, 'Commewijne', '11', 192),
  (3213, 'Saramacca', '17', 192),
  (3214, 'Nickerie', '14', 192),
  (3215, 'Coronie', '12', 192),
  (3216, 'Wanica', '19', 192),
  (3217, 'Paramaribo', '16', 192),
  (3218, 'Sao Tome', '02', 193),
  (3219, 'Principe', '01', 193),
  (3220, 'Sonsonate', '13', 194),
  (3221, 'Morazan', '08', 194),
  (3222, 'San Vicente', '12', 194),
  (3223, 'La Union', '07', 194),
  (3224, 'San Salvador', '10', 194),
  (3225, 'Chalatenango', '03', 194),
  (3226, 'La Libertad', '05', 194),
  (3227, 'Cabanas', '02', 194),
  (3228, 'Cuscatlan', '04', 194),
  (3229, 'Usulutan', '14', 194),
  (3230, 'Ahuachapan', '01', 194),
  (3231, 'Santa Ana', '11', 194),
  (3232, 'San Miguel', '09', 194),
  (3233, 'La Paz', '06', 194),
  (3234, 'Al Hasakah', '01', 195),
  (3235, 'Ar Raqqah', '04', 195),
  (3236, 'Tartus', '14', 195),
  (3237, 'Rif Dimashq', '08', 195),
  (3238, 'Hims', '11', 195),
  (3239, 'Idlib', '12', 195),
  (3240, 'Hamah', '10', 195),
  (3241, 'Halab', '09', 195),
  (3242, 'Al Qunaytirah', '03', 195),
  (3243, 'Dar', '06', 195),
  (3244, 'As Suwayda\'', '05', 195),
  (3245, 'Al Ladhiqiyah', '02', 195),
  (3246, 'Dayr az Zawr', '07', 195),
  (3247, 'Dimashq', '13', 195),
  (3248, 'Lubombo', '02', 196),
  (3249, 'Hhohho', '01', 196),
  (3250, 'Manzini', '03', 196),
  (3251, 'Shiselweni', '04', 196),
  (3252, '', '00', 197),
  (3253, 'Ouaddai', '12', 198),
  (3254, 'Biltine', '02', 198),
  (3255, 'Batha', '01', 198),
  (3256, 'Mayo-Kebbi', '10', 198),
  (3257, 'Chari-Baguirmi', '04', 198),
  (3258, 'Guera', '05', 198),
  (3259, 'Salamat', '13', 198),
  (3260, 'Kanem', '06', 198),
  (3261, 'Logone Occidental', '08', 198),
  (3262, 'Lac', '07', 198),
  (3263, 'Borkou-Ennedi-Tibesti', '03', 198),
  (3264, 'Tandjile', '14', 198),
  (3265, 'Moyen-Chari', '11', 198),
  (3266, 'Logone Oriental', '09', 198),
  (3267, '', '00', 199),
  (3268, 'Plateaux', '25', 200),
  (3269, '', '13', 200),
  (3270, '', '04', 200),
  (3271, '', '18', 200),
  (3272, '', '03', 200),
  (3273, '', '09', 200),
  (3274, '', '02', 200),
  (3275, '', '01', 200),
  (3276, '', '10', 200),
  (3277, '', '16', 200),
  (3278, '', '17', 200),
  (3279, '', '21', 200),
  (3280, '', '08', 200),
  (3281, 'Kara', '23', 200),
  (3282, '', '19', 200),
  (3283, '', '07', 200),
  (3284, '', '14', 200),
  (3285, '', '12', 200),
  (3286, '', '00', 200),
  (3287, '', '05', 200),
  (3288, '', '11', 200),
  (3289, 'Savanes', '26', 200),
  (3290, 'Centrale', '22', 200),
  (3291, '', '06', 200),
  (3292, 'Maritime', '24', 200),
  (3293, 'Trat', '49', 201),
  (3294, 'Chiang Mai', '02', 201),
  (3295, 'Nan', '04', 201),
  (3296, 'Prachin Buri', '45', 201),
  (3297, 'Krabi', '63', 201),
  (3298, 'Sakon Nakhon', '20', 201),
  (3299, 'Nakhon Phanom', '73', 201),
  (3300, 'Amnat Charoen', '77', 201),
  (3301, 'Samut Songkhram', '54', 201),
  (3302, 'Nakhon Sawan', '16', 201),
  (3303, 'Kanchanaburi', '50', 201),
  (3304, 'Ubon Ratchathani', '71', 201),
  (3305, 'Chumphon', '58', 201),
  (3306, 'Chachoengsao', '44', 201),
  (3307, 'Sa Kaeo', '80', 201),
  (3308, 'Roi Et', '25', 201),
  (3309, 'Narathiwat', '31', 201),
  (3310, 'Pattani', '69', 201),
  (3311, 'Chaiyaphum', '26', 201),
  (3312, 'Kalasin', '23', 201),
  (3313, 'Chon Buri', '46', 201),
  (3314, 'Sukhothai', '09', 201),
  (3315, 'Surat Thani', '60', 201),
  (3316, '', '19', 201),
  (3317, 'Phra Nakhon Si Ayutthaya', '36', 201),
  (3318, 'Nonthaburi', '38', 201),
  (3319, 'Samut Prakan', '42', 201),
  (3320, 'Ang Thong', '35', 201),
  (3321, 'Krung Thep', '40', 201),
  (3322, 'Phitsanulok', '12', 201),
  (3323, 'Nakhon Pathom', '53', 201),
  (3324, 'Phichit', '13', 201),
  (3325, 'Ratchaburi', '52', 201),
  (3326, 'Suphan Buri', '51', 201),
  (3327, 'Sing Buri', '33', 201),
  (3328, 'Prachuap Khiri Khan', '57', 201),
  (3329, 'Lamphun', '05', 201),
  (3330, 'Rayong', '47', 201),
  (3331, 'Ubon Ratchathani', '75', 201),
  (3332, 'Chai Nat', '32', 201),
  (3333, 'Buriram', '28', 201),
  (3334, 'Phetchaburi', '56', 201),
  (3335, 'Tak', '08', 201),
  (3336, 'Phayao', '41', 201),
  (3337, 'Lop Buri', '34', 201),
  (3338, 'Saraburi', '37', 201),
  (3339, 'Nakhon Nayok', '43', 201),
  (3340, 'Yala', '70', 201),
  (3341, 'Nakhon Ratchasima', '27', 201),
  (3342, 'Samut Sakhon', '55', 201),
  (3343, 'Khon Kaen', '22', 201),
  (3344, 'Uthai Thani', '15', 201),
  (3345, 'Nong Khai', '17', 201),
  (3346, 'Maha Sarakham', '24', 201),
  (3347, 'Lampang', '06', 201),
  (3348, 'Songkhla', '68', 201),
  (3349, 'Nakhon Si Thammarat', '64', 201),
  (3350, 'Loei', '18', 201),
  (3351, 'Chiang Rai', '03', 201),
  (3352, 'Surin', '29', 201),
  (3353, 'Phetchabun', '14', 201),
  (3354, 'Phrae', '07', 201),
  (3355, 'Phangnga', '61', 201),
  (3356, 'Uttaradit', '10', 201),
  (3357, 'Sisaket', '30', 201),
  (3358, 'Trang', '65', 201),
  (3359, 'Kamphaeng Phet', '11', 201),
  (3360, 'Phuket', '62', 201),
  (3361, 'Mukdahan', '78', 201),
  (3362, 'Yasothon', '72', 201),
  (3363, 'Phatthalung', '66', 201),
  (3364, 'Pathum Thani', '39', 201),
  (3365, 'Chanthaburi', '48', 201),
  (3366, 'Mae Hong Son', '01', 201),
  (3367, 'Ranong', '59', 201),
  (3368, 'Udon Thani', '76', 201),
  (3369, 'Satun', '67', 201),
  (3370, 'Nong Bua Lamphu', '79', 201),
  (3371, 'Nakhon Phanom', '21', 201),
  (3372, 'Khatlon', '02', 202),
  (3373, 'Sughd', '03', 202),
  (3374, 'Kuhistoni Badakhshon', '01', 202),
  (3375, '', '00', 203),
  (3376, 'Lebap', '04', 204),
  (3377, 'Balkan', '02', 204),
  (3378, 'Ahal', '01', 204),
  (3379, '', '00', 204),
  (3380, 'Mary', '05', 204),
  (3381, 'Dashoguz', '03', 204),
  (3382, 'Madanin', '28', 205),
  (3383, 'El Kef', '14', 205),
  (3384, 'Tozeur', '35', 205),
  (3385, 'Sousse', '23', 205),
  (3386, 'Gabes', '29', 205),
  (3387, 'Sfax', '32', 205),
  (3388, 'Bizerte', '18', 205),
  (3389, 'Al Munastir', '16', 205),
  (3390, 'Nabeul', '19', 205),
  (3391, 'Kasserine', '02', 205),
  (3392, 'Tataouine', '34', 205),
  (3393, 'Sidi Bou Zid', '33', 205),
  (3394, 'Al Mahdia', '15', 205),
  (3395, 'Jendouba', '06', 205),
  (3396, 'Ben Arous', '27', 205),
  (3397, 'Kairouan', '03', 205),
  (3398, 'Zaghouan', '37', 205),
  (3399, 'Kebili', '31', 205),
  (3400, 'Bajah', '17', 205),
  (3401, '', '30', 205),
  (3402, 'Siliana', '22', 205),
  (3403, '', '26', 205),
  (3404, 'Tunis', '36', 205),
  (3405, 'Tongatapu', '02', 206),
  (3406, 'Ha', '01', 206),
  (3407, 'Vava', '03', 206),
  (3408, 'Amasya', '05', 207),
  (3409, 'Hatay', '31', 207),
  (3410, 'Diyarbakir', '21', 207),
  (3411, 'Adana', '81', 207),
  (3412, 'Bolu', '14', 207),
  (3413, 'Ankara', '68', 207),
  (3414, 'Konya', '71', 207),
  (3415, 'Bilecik', '11', 207),
  (3416, 'Izmir', '35', 207),
  (3417, 'Tokat', '60', 207),
  (3418, 'Edirne', '22', 207),
  (3419, 'Kirsehir', '40', 207),
  (3420, 'Van', '65', 207),
  (3421, 'Kastamonu', '37', 207),
  (3422, 'Sivas', '58', 207),
  (3423, 'Denizli', '20', 207),
  (3424, 'Kutahya', '43', 207),
  (3425, 'Bingol', '12', 207),
  (3426, 'Kahramanmaras', '46', 207),
  (3427, 'Sanliurfa', '63', 207),
  (3428, 'Agri', '04', 207),
  (3429, 'Eskisehir', '26', 207),
  (3430, 'Malatya', '44', 207),
  (3431, 'Adiyaman', '02', 207),
  (3432, 'Giresun', '28', 207),
  (3433, 'Mus', '49', 207),
  (3434, 'Corum', '19', 207),
  (3435, 'Erzurum', '25', 207),
  (3436, 'Mersin', '32', 207),
  (3437, 'Aydin', '09', 207),
  (3438, 'Nevsehir', '50', 207),
  (3439, 'Manisa', '45', 207),
  (3440, 'Canakkale', '17', 207),
  (3441, 'Ordu', '52', 207),
  (3442, 'Yozgat', '66', 207),
  (3443, 'Tunceli', '62', 207),
  (3444, 'Mardin', '72', 207),
  (3445, 'Sinop', '57', 207),
  (3446, 'Antalya', '07', 207),
  (3447, 'Erzincan', '24', 207),
  (3448, 'Artvin', '08', 207),
  (3449, 'Sakarya', '54', 207),
  (3450, 'Afyonkarahisar', '03', 207),
  (3451, 'Bursa', '16', 207),
  (3452, 'Trabzon', '61', 207),
  (3453, 'Tekirdag', '59', 207),
  (3454, 'Kilis', '90', 207),
  (3455, 'Gaziantep', '83', 207),
  (3456, 'Sirnak', '80', 207),
  (3457, 'Balikesir', '10', 207),
  (3458, 'Elazig', '23', 207),
  (3459, 'Ardahan', '86', 207),
  (3460, 'Batman', '76', 207),
  (3461, 'Kayseri', '38', 207),
  (3462, 'Kocaeli', '41', 207),
  (3463, 'Samsun', '55', 207),
  (3464, 'Isparta', '33', 207),
  (3465, 'Mugla', '48', 207),
  (3466, 'Bitlis', '13', 207),
  (3467, 'Rize', '53', 207),
  (3468, 'Hakkari', '70', 207),
  (3469, 'Istanbul', '34', 207),
  (3470, 'Karaman', '78', 207),
  (3471, 'Igdir', '88', 207),
  (3472, 'Nigde', '73', 207),
  (3473, 'Usak', '64', 207),
  (3474, 'Siirt', '74', 207),
  (3475, 'Kirklareli', '39', 207),
  (3476, 'Burdur', '15', 207),
  (3477, 'Gumushane', '69', 207),
  (3478, 'Osmaniye', '91', 207),
  (3479, 'Yalova', '92', 207),
  (3480, 'Kars', '84', 207),
  (3481, 'Tobago', '11', 208),
  (3482, 'Caroni', '02', 208),
  (3483, 'Saint David', '07', 208),
  (3484, 'Arima', '01', 208),
  (3485, 'Saint George', '08', 208),
  (3486, 'Saint Patrick', '09', 208),
  (3487, 'Victoria', '12', 208),
  (3488, 'Nariva', '04', 208),
  (3489, 'Port-of-Spain', '05', 208),
  (3490, 'Saint Andrew', '06', 208),
  (3491, 'Mayaro', '03', 208),
  (3492, 'San Fernando', '10', 208),
  (3493, '', '00', 209),
  (3494, 'T\'ai-wan', '04', 210),
  (3495, 'T\'ai-pei', '03', 210),
  (3496, 'Fu-chien', '01', 210),
  (3497, 'Kao-hsiung', '02', 210),
  (3498, '', '00', 211),
  (3499, 'Tabora', '17', 211),
  (3500, 'Manyara', '27', 211),
  (3501, 'Mtwara', '11', 211),
  (3502, 'Lindi', '07', 211),
  (3503, 'Ruvuma', '14', 211),
  (3504, 'Iringa', '04', 211),
  (3505, 'Tanga', '18', 211),
  (3506, 'Pemba South', '20', 211),
  (3507, 'Kagera', '19', 211),
  (3508, 'Arusha', '26', 211),
  (3509, 'Mwanza', '12', 211),
  (3510, 'Kilimanjaro', '06', 211),
  (3511, 'Pwani', '02', 211),
  (3512, 'Zanzibar Central', '21', 211),
  (3513, 'Dodoma', '03', 211),
  (3514, 'Shinyanga', '15', 211),
  (3515, 'Zanzibar Urban', '25', 211),
  (3516, 'Pemba North', '13', 211),
  (3517, 'Mara', '08', 211),
  (3518, 'Dar es Salaam', '23', 211),
  (3519, 'Zanzibar North', '22', 211),
  (3520, 'Mbeya', '09', 211),
  (3521, 'Singida', '16', 211),
  (3522, 'Kigoma', '05', 211),
  (3523, 'Morogoro', '10', 211),
  (3524, 'Rukwa', '24', 211),
  (3525, 'Krym', '11', 212),
  (3526, 'Odes\'ka Oblast\'', '17', 212),
  (3527, 'Kharkivs\'ka Oblast\'', '07', 212),
  (3528, 'Poltavs\'ka Oblast\'', '18', 212),
  (3529, 'Kyyivs\'ka Oblast\'', '13', 212),
  (3530, 'Zakarpats\'ka Oblast\'', '25', 212),
  (3531, 'Sums\'ka Oblast\'', '21', 212),
  (3532, 'Donets\'ka Oblast\'', '05', 212),
  (3533, 'Khersons\'ka Oblast\'', '08', 212),
  (3534, 'L\'vivs\'ka Oblast\'', '15', 212),
  (3535, 'Cherkas\'ka Oblast\'', '01', 212),
  (3536, 'Vinnyts\'ka Oblast\'', '23', 212),
  (3537, 'Rivnens\'ka Oblast\'', '19', 212),
  (3538, 'Khmel\'nyts\'ka Oblast\'', '09', 212);
  INSERT INTO `regions` (`id`, `name`, `code`, `country_id`) VALUES
  (3539, 'Chernihivs\'ka Oblast\'', '02', 212),
  (3540, 'Dnipropetrovs\'ka Oblast\'', '04', 212),
  (3541, 'Mykolayivs\'ka Oblast\'', '16', 212),
  (3542, 'Ternopil\'s\'ka Oblast\'', '22', 212),
  (3543, 'Zhytomyrs\'ka Oblast\'', '27', 212),
  (3544, 'Chernivets\'ka Oblast\'', '03', 212),
  (3545, 'Luhans\'ka Oblast\'', '14', 212),
  (3546, 'Sevastopol\'', '20', 212),
  (3547, 'Kirovohrads\'ka Oblast\'', '10', 212),
  (3548, 'Ivano-Frankivs\'ka Oblast\'', '06', 212),
  (3549, 'Zaporiz\'ka Oblast\'', '26', 212),
  (3550, 'Volyns\'ka Oblast\'', '24', 212),
  (3551, '', '00', 212),
  (3552, 'Nebbi', '58', 213),
  (3553, 'Katakwi', '69', 213),
  (3554, 'Lira', '47', 213),
  (3555, 'Apac', '26', 213),
  (3556, 'Kaberamaido', '80', 213),
  (3557, 'Arua', '77', 213),
  (3558, 'Soroti', '95', 213),
  (3559, 'Tororo', '76', 213),
  (3560, 'Gulu', '30', 213),
  (3561, 'Pallisa', '60', 213),
  (3562, 'Pader', '92', 213),
  (3563, 'Kumi', '46', 213),
  (3564, 'Adjumani', '65', 213),
  (3565, 'Kotido', '45', 213),
  (3566, 'Kitgum', '84', 213),
  (3567, 'Masindi', '50', 213),
  (3568, 'Mbarara', '52', 213),
  (3569, '', '34', 213),
  (3570, 'Bundibugyo', '28', 213),
  (3571, 'Nakapiripirit', '91', 213),
  (3572, 'Moroto', '88', 213),
  (3573, 'Moyo', '72', 213),
  (3574, 'Mbale', '87', 213),
  (3575, 'Yumbe', '97', 213),
  (3576, 'Kapchorwa', '39', 213),
  (3577, 'Nakasongola', '73', 213),
  (3578, 'Mubende', '56', 213),
  (3579, 'Kisoro', '43', 213),
  (3580, 'Iganga', '78', 213),
  (3581, 'Kayunga', '83', 213),
  (3582, 'Mukono', '90', 213),
  (3583, 'Mpigi', '89', 213),
  (3584, 'Kamuli', '38', 213),
  (3585, 'Luwero', '70', 213),
  (3586, 'Masaka', '71', 213),
  (3587, 'Rakai', '61', 213),
  (3588, 'Kalangala', '36', 213),
  (3589, 'Kibale', '41', 213),
  (3590, 'Bugiri', '66', 213),
  (3591, 'Wakiso', '96', 213),
  (3592, 'Kiboga', '42', 213),
  (3593, 'Kampala', '37', 213),
  (3594, 'Mayuge', '86', 213),
  (3595, 'Kyenjojo', '85', 213),
  (3596, 'Rukungiri', '93', 213),
  (3597, 'Bushenyi', '29', 213),
  (3598, 'Hoima', '31', 213),
  (3599, 'Kamwenge', '81', 213),
  (3600, 'Kabarole', '79', 213),
  (3601, 'Sironko', '94', 213),
  (3602, 'Kasese', '40', 213),
  (3603, 'Sembabule', '74', 213),
  (3604, '', '62', 213),
  (3605, 'Jinja', '33', 213),
  (3606, 'Busia', '67', 213),
  (3607, 'Ntungamo', '59', 213),
  (3608, 'Kanungu', '82', 213),
  (3609, '', '35', 213),
  (3610, 'Alabama', 'AL', 230),
  (3611, 'Alaska', 'AK', 230),
  (3612, 'American Samoa', 'AS', 230),
  (3613, 'Arizona', 'AZ', 230),
  (3614, 'Arkansas', 'AR', 230),
  (3615, 'California', 'CA', 230),
  (3616, 'Colorado', 'CO', 230),
  (3617, 'Connecticut', 'CT', 230),
  (3618, 'Delaware', 'DE', 230),
  (3619, 'District of Columbia', 'DC', 230),
  (3620, 'Florida', 'FL', 230),
  (3621, 'Georgia', 'GA', 230),
  (3622, 'Guam', 'GU', 230),
  (3623, 'Hawaii', 'HI', 230),
  (3624, 'Idaho', 'ID', 230),
  (3625, 'Illinois', 'IL', 230),
  (3626, 'Indiana', 'IN', 230),
  (3627, 'Iowa', 'IA', 230),
  (3628, 'Kansas', 'KS', 230),
  (3629, 'Kentucky', 'KY', 230),
  (3630, 'Louisiana', 'LA', 230),
  (3631, 'Maine', 'ME', 230),
  (3632, 'Marshall Islands', 'MH', 230),
  (3633, 'Maryland', 'MD', 230),
  (3634, 'Massachusetts', 'MA', 230),
  (3635, 'Michigan', 'MI', 230),
  (3636, 'Federated States of Micronesia', 'FM', 230),
  (3637, 'Minnesota', 'MN', 230),
  (3638, 'Mississippi', 'MS', 230),
  (3639, 'Missouri', 'MO', 230),
  (3640, 'Montana', 'MT', 230),
  (3641, 'Nebraska', 'NE', 230),
  (3642, 'Nevada', 'NV', 230),
  (3643, 'New Hampshire', 'NH', 230),
  (3644, 'New Jersey', 'NJ', 230),
  (3645, 'New Mexico', 'NM', 230),
  (3646, 'New York', 'NY', 230),
  (3647, 'North Carolina', 'NC', 230),
  (3648, 'North Dakota', 'ND', 230),
  (3649, 'Northern Mariana Islands', 'MP', 230),
  (3650, 'Ohio', 'OH', 230),
  (3651, 'Oklahoma', 'OK', 230),
  (3652, 'Oregon', 'OR', 230),
  (3653, 'Palau', 'PW', 230),
  (3654, 'Pennsylvania', 'PA', 230),
  (3655, 'Puerto Rico', 'PR', 230),
  (3656, 'Rhode Island', 'RI', 230),
  (3657, 'South Carolina', 'SC', 230),
  (3658, 'South Dakota', 'SD', 230),
  (3659, 'Tennessee', 'TN', 230),
  (3660, 'Texas', 'TX', 230),
  (3661, 'Utah', 'UT', 230),
  (3662, 'Vermont', 'VT', 230),
  (3663, 'Virgin Islands', 'VI', 230),
  (3664, 'Virginia', 'VA', 230),
  (3665, 'Washington', 'WA', 230),
  (3666, 'West Virginia', 'WV', 230),
  (3667, 'Wisconsin', 'WI', 230),
  (3668, 'Wyoming', 'WY', 230),
  (3669, 'Rocha', '14', 214),
  (3670, 'Florida', '07', 214),
  (3671, 'Montevideo', '10', 214),
  (3672, 'Rivera', '13', 214),
  (3673, 'Cerro Largo', '03', 214),
  (3674, 'Tacuarembo', '18', 214),
  (3675, 'Lavalleja', '08', 214),
  (3676, 'Treinta y Tres', '19', 214),
  (3677, 'Soriano', '17', 214),
  (3678, 'Durazno', '05', 214),
  (3679, 'Canelones', '02', 214),
  (3680, 'Flores', '06', 214),
  (3681, 'Maldonado', '09', 214),
  (3682, 'Salto', '15', 214),
  (3683, 'Rio Negro', '12', 214),
  (3684, 'Artigas', '01', 214),
  (3685, 'Paysandu', '11', 214),
  (3686, 'Colonia', '04', 214),
  (3687, 'San Jose', '16', 214),
  (3688, 'Khorazm', '05', 215),
  (3689, 'Qashqadaryo', '08', 215),
  (3690, 'Samarqand', '10', 215),
  (3691, 'Andijon', '01', 215),
  (3692, 'Jizzax', '15', 215),
  (3693, 'Toshkent', '14', 215),
  (3694, 'Surkhondaryo', '12', 215),
  (3695, 'Qoraqalpoghiston', '09', 215),
  (3696, 'Nawoiy', '07', 215),
  (3697, '', '16', 215),
  (3698, 'Namangan', '06', 215),
  (3699, 'Farghona', '03', 215),
  (3700, 'Bukhoro', '02', 215),
  (3701, 'Toshkent', '13', 215),
  (3702, '', '00', 215),
  (3703, 'Charlotte', '01', 216),
  (3704, 'Saint George', '04', 216),
  (3705, 'Grenadines', '06', 216),
  (3706, 'Saint Patrick', '05', 216),
  (3707, 'Saint Andrew', '02', 216),
  (3708, 'Saint David', '03', 216),
  (3709, 'Falcon', '11', 217),
  (3710, 'Apure', '03', 217),
  (3711, 'Bolivar', '06', 217),
  (3712, 'Tachira', '20', 217),
  (3713, 'Miranda', '15', 217),
  (3714, 'Guarico', '12', 217),
  (3715, 'Anzoategui', '02', 217),
  (3716, 'Nueva Esparta', '17', 217),
  (3717, 'Portuguesa', '18', 217),
  (3718, 'Sucre', '19', 217),
  (3719, 'Barinas', '05', 217),
  (3720, 'Lara', '13', 217),
  (3721, 'Zulia', '23', 217),
  (3722, 'Merida', '14', 217),
  (3723, 'Carabobo', '07', 217),
  (3724, 'Cojedes', '08', 217),
  (3725, 'Aragua', '04', 217),
  (3726, 'Yaracuy', '22', 217),
  (3727, 'Amazonas', '01', 217),
  (3728, 'Monagas', '16', 217),
  (3729, 'Trujillo', '21', 217),
  (3730, 'Vargas', '26', 217),
  (3731, '', '99', 217),
  (3732, 'Delta Amacuro', '09', 217),
  (3733, 'Distrito Federal', '25', 217),
  (3734, 'Dependencias Federales', '24', 217),
  (3735, '', '00', 218),
  (3736, '', '00', 219),
  (3737, '', '36', 220),
  (3738, '', '29', 220),
  (3739, '', '04', 220),
  (3740, '', '22', 220),
  (3741, '', '07', 220),
  (3742, 'Thanh Hoa', '34', 220),
  (3743, '', '11', 220),
  (3744, '', '15', 220),
  (3745, 'Quang Nam', '84', 220),
  (3746, 'Son La', '32', 220),
  (3747, '', '06', 220),
  (3748, '', '19', 220),
  (3749, '', '38', 220),
  (3750, '', '26', 220),
  (3751, 'Tay Ninh', '33', 220),
  (3752, '', '27', 220),
  (3753, 'Thai Binh', '35', 220),
  (3754, 'Kien Giang', '21', 220),
  (3755, 'Dong Thap', '09', 220),
  (3756, '', '10', 220),
  (3757, '', '31', 220),
  (3758, '', '41', 220),
  (3759, '', '28', 220),
  (3760, '', '12', 220),
  (3761, 'Soc Trang', '65', 220),
  (3762, '', '16', 220),
  (3763, '', '14', 220),
  (3764, 'Ben Tre', '03', 220),
  (3765, 'Ho Chi Minh', '20', 220),
  (3766, 'Tra Vinh', '67', 220),
  (3767, 'Hai Phong', '13', 220),
  (3768, 'Cao Bang', '05', 220),
  (3769, 'An Giang', '01', 220),
  (3770, '', '02', 220),
  (3771, '', '40', 220),
  (3772, 'Nghe An', '58', 220),
  (3773, 'Gia Lai', '49', 220),
  (3774, 'Lam Dong', '23', 220),
  (3775, 'Binh Dinh', '46', 220),
  (3776, 'Binh Phuoc', '76', 220),
  (3777, 'Lang Son', '39', 220),
  (3778, 'Tien Giang', '37', 220),
  (3779, 'Long An', '24', 220),
  (3780, 'Ninh Thuan', '60', 220),
  (3781, 'Quang Ninh', '30', 220),
  (3782, 'Bac Lieu', '73', 220),
  (3783, 'Ca Mau', '77', 220),
  (3784, '', '25', 220),
  (3785, '', '48', 220),
  (3786, 'Binh Duong', '75', 220),
  (3787, 'Binh Thuan', '47', 220),
  (3788, 'Vinh Long', '69', 220),
  (3789, 'Dong Nai', '43', 220),
  (3790, '', '17', 220),
  (3791, 'Bac Kan', '72', 220),
  (3792, 'Bac Giang', '71', 220),
  (3793, 'Thua Thien-Hue', '66', 220),
  (3794, 'Bac Ninh', '74', 220),
  (3795, 'Ha Giang', '50', 220),
  (3796, 'Tuyen Quang', '68', 220),
  (3797, 'Thai Nguyen', '85', 220),
  (3798, 'Da Nang', '78', 220),
  (3799, 'Khanh Hoa', '54', 220),
  (3800, 'Ba Ria-Vung Tau', '45', 220),
  (3801, 'Quang Ngai', '63', 220),
  (3802, '', '56', 220),
  (3803, 'Ha Nam', '80', 220),
  (3804, 'Phu Yen', '61', 220),
  (3805, 'Quang Binh', '62', 220),
  (3806, 'Phu Tho', '83', 220),
  (3807, 'Quang Tri', '64', 220),
  (3808, 'Ha Tinh', '52', 220),
  (3809, 'Kon Tum', '55', 220),
  (3810, '', '51', 220),
  (3811, 'Yen Bai', '70', 220),
  (3812, 'Ninh Binh', '59', 220),
  (3813, 'Nam Dinh', '82', 220),
  (3814, 'Hai Duong', '79', 220),
  (3815, 'Ha Noi', '44', 220),
  (3816, 'Hoa Binh', '53', 220),
  (3817, 'Hung Yen', '81', 220),
  (3818, 'Vinh Phuc', '86', 220),
  (3819, 'Sanma', '13', 221),
  (3820, 'Aoba', '06', 221),
  (3821, 'Shepherd', '14', 221),
  (3822, 'Malakula', '10', 221),
  (3823, 'Pentecote', '12', 221),
  (3824, 'Torba', '07', 221),
  (3825, 'Efate', '08', 221),
  (3826, 'Tafea', '15', 221),
  (3827, 'Ambrym', '05', 221),
  (3828, 'Epi', '09', 221),
  (3829, 'Paama', '11', 221),
  (3830, '', '00', 222),
  (3831, '', '00', 223),
  (3832, 'Lahij', '06', 224),
  (3833, 'Sa\'dah', '15', 224),
  (3834, 'Al Hudaydah', '08', 224),
  (3835, 'Ma\'rib', '14', 224),
  (3836, 'Al Bayda\'', '07', 224),
  (3837, 'Dhamar', '11', 224),
  (3838, 'San\'a\'', '16', 224),
  (3839, 'Al Mahrah', '03', 224),
  (3840, 'Hadramawt', '04', 224),
  (3841, 'Taizz', '17', 224),
  (3842, 'Hajjah', '12', 224),
  (3843, 'Abyan', '01', 224),
  (3844, 'Ibb', '13', 224),
  (3845, 'Adan', '02', 224),
  (3846, 'Al Mahwit', '10', 224),
  (3847, 'Al Jawf', '09', 224),
  (3848, '', '00', 224),
  (3849, '', '00', 225),
  (3850, 'Western Cape', '11', 226),
  (3851, 'Eastern Cape', '05', 226),
  (3852, 'Mpumalanga', '07', 226),
  (3853, 'Free State', '03', 226),
  (3854, 'North-West', '10', 226),
  (3855, 'Limpopo', '09', 226),
  (3856, 'KwaZulu-Natal', '02', 226),
  (3857, 'North-Western Province', '01', 226),
  (3858, 'Gauteng', '06', 226),
  (3859, 'Northern Cape', '08', 226),
  (3860, '', '04', 226),
  (3861, 'Southern', '07', 227),
  (3862, 'North-Western', '06', 227),
  (3863, 'Northern', '05', 227),
  (3864, 'Western', '01', 227),
  (3865, 'Eastern', '03', 227),
  (3866, 'Copperbelt', '08', 227),
  (3867, 'Luapula', '04', 227),
  (3868, 'Central', '02', 227),
  (3869, 'Lusaka', '09', 227),
  (3870, '', '02', 228),
  (3871, '', '09', 228),
  (3872, '', '00', 228),
  (3873, '', '11', 228),
  (3874, '', '07', 228),
  (3875, '', '10', 228),
  (3876, '', '01', 228),
  (3877, '', '03', 228),
  (3878, '', '05', 228),
  (3879, '', '12', 228),
  (3880, '', '08', 228),
  (3881, '', '04', 228),
  (3882, '', '06', 228),
  (3883, 'Matabeleland North', '06', 229),
  (3884, 'Mashonaland East', '04', 229),
  (3885, 'Mashonaland Central', '03', 229),
  (3886, 'Matabeleland South', '07', 229),
  (3887, '', '00', 229),
  (3888, 'Masvingo', '08', 229);
  
  -- --------------------------------------------------------
  
  --
  -- Estructura de tabla para la tabla `usuarios`
  --
  
  CREATE TABLE `Usuarios` (
    `idUsuarios` int(11) NOT NULL,
    `Nombre` varchar(45) DEFAULT NULL,
    `ApPaterno` varchar(45) DEFAULT NULL,
    `ApMaterno` varchar(45) DEFAULT NULL,
    `Correo` varchar(45) DEFAULT NULL,
    `Password` varchar(60) DEFAULT NULL,
    `Privilegio` int(11) DEFAULT NULL COMMENT '1. Administrador 2. Usuario',
    `Pais` varchar(45) DEFAULT NULL,
    `Img` varchar(45) DEFAULT NULL,
    `Nacimiento` date DEFAULT NULL,
    `Telefono` varchar(15) DEFAULT NULL,
    `Sexo` varchar(10) DEFAULT NULL,
    `idInstitucion` int(11) NOT NULL,
    `Status` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Volcado de datos para la tabla `usuarios`
  --
  
  INSERT INTO `Usuarios` (`idUsuarios`, `Nombre`, `ApPaterno`, `ApMaterno`, `Correo`, `Password`, `Privilegio`, `Pais`, `Img`, `Nacimiento`, `Telefono`, `Sexo`, `idInstitucion`, `Status`) VALUES
  (1, 'Andrés Vinicio', 'Martínez', 'López', '2016030004@upsin.edu.mx', '202cb962ac59075b964b07152d234b70', 1, 'Mazatlán', 'null', '0000-00-00', 'null', '1998-11-30', 0, 1),
  (2, 'Rodolfo', 'Ostos', 'Robles', 'cba', 'caf1a3dfb505ffed0d024130f58c5cfa', 2, 'Mazatlán', 'null', '1998-11-30', '9812345', '2018-11-14', 1, 1);
  
  --
  -- Índices para tablas volcadas
  --
  
  --
  -- Indices de la tabla `autores`
  --
  ALTER TABLE `Autores`
    ADD PRIMARY KEY (`idAutores`),
    ADD KEY `Investigacion_idx` (`idInvestigacion`);
  
  --
  -- Indices de la tabla `countries`
  --
  ALTER TABLE `Countries`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `name` (`name`);
  
  --
  -- Indices de la tabla `educacion`
  --
  ALTER TABLE `Educacion`
    ADD PRIMARY KEY (`idEducacion`),
    ADD KEY `Usuario_idx` (`idUsuario`),
    ADD KEY `Institucion_idx` (`idInstitucion`);
  
  --
  -- Indices de la tabla `infoacademica`
  --
  ALTER TABLE `Infoacademica`
    ADD KEY `infoacademica_ibfk_1` (`idUsuario`);
  
  --
  -- Indices de la tabla `institucion`
  --
  ALTER TABLE `Institucion`
    ADD PRIMARY KEY (`idInstitucion`);
  
  --
  -- Indices de la tabla `investigaciones`
  --
  ALTER TABLE `Investigaciones`
    ADD PRIMARY KEY (`idInvestigaciones`),
    ADD KEY `Investigador_idx` (`idUsuario`);
  
  --
  -- Indices de la tabla `noticias`
  --
  ALTER TABLE `Noticias`
    ADD PRIMARY KEY (`idNoticias`),
    ADD KEY `AutorNoticia_idx` (`idUsuarios`);
  
  --
  -- Indices de la tabla `regions`
  --
  ALTER TABLE `Regions`
    ADD PRIMARY KEY (`id`),
    ADD KEY `country_name` (`country_id`,`name`);
  
  --
  -- Indices de la tabla `usuarios`
  --
  ALTER TABLE `Usuarios`
    ADD PRIMARY KEY (`idUsuarios`),
    ADD KEY `idInstitucion` (`idInstitucion`);
  
  --
  -- AUTO_INCREMENT de las tablas volcadas
  --
  
  --
  -- AUTO_INCREMENT de la tabla `autores`
  --
  ALTER TABLE `Autores`
    MODIFY `idAutores` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `countries`
  --
  ALTER TABLE `Countries`
    MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=231;
  
  --
  -- AUTO_INCREMENT de la tabla `educacion`
  --
  ALTER TABLE `Educacion`
    MODIFY `idEducacion` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de la tabla `institucion`
  --
  ALTER TABLE `Institucion`
    MODIFY `idInstitucion` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT de la tabla `investigaciones`
  --
  ALTER TABLE `Investigaciones`
    MODIFY `idInvestigaciones` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT de la tabla `noticias`
  --
  ALTER TABLE `Noticias`
    MODIFY `idNoticias` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
  
  --
  -- AUTO_INCREMENT de la tabla `regions`
  --
  ALTER TABLE `Regions`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3889;
  
  --
  -- AUTO_INCREMENT de la tabla `usuarios`
  --
  ALTER TABLE `Usuarios`
    MODIFY `idUsuarios` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- Restricciones para tablas volcadas
  --
  
  --
  -- Filtros para la tabla `autores`
  --
  ALTER TABLE `Autores`
    ADD CONSTRAINT `Investigacion` FOREIGN KEY (`idInvestigacion`) REFERENCES `investigaciones` (`idInvestigaciones`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Filtros para la tabla `educacion`
  --
  ALTER TABLE `Educacion`
    ADD CONSTRAINT `Institucion` FOREIGN KEY (`idInstitucion`) REFERENCES `institucion` (`idInstitucion`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    ADD CONSTRAINT `Usuario` FOREIGN KEY (`idUsuario`) REFERENCES `usuarios` (`idUsuarios`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Filtros para la tabla `infoacademica`
  --
  ALTER TABLE `Infoacademica`
    ADD CONSTRAINT `infoacademica_ibfk_1` FOREIGN KEY (`idUsuario`) REFERENCES `usuarios` (`idUsuarios`);
  
  --
  -- Filtros para la tabla `investigaciones`
  --
  ALTER TABLE `Investigaciones`
    ADD CONSTRAINT `Investigador` FOREIGN KEY (`idUsuario`) REFERENCES `usuarios` (`idUsuarios`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  
  --
  -- Filtros para la tabla `noticias`
  --
  ALTER TABLE `Noticias`
    ADD CONSTRAINT `AutorNoticia` FOREIGN KEY (`idUsuarios`) REFERENCES `usuarios` (`idUsuarios`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  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 */;
  