-- MySQL dump 10.13  Distrib 5.7.34, for osx10.12 (x86_64)
--
-- Host: 127.0.0.1    Database: laraclassifier
-- ------------------------------------------------------
-- Server version	5.7.34

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping data for table `__PREFIX__subadmin1`
--

/*!40000 ALTER TABLE `__PREFIX__subadmin1` DISABLE KEYS */;
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.71','MG','{\"en\":\"Diana\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.72','MG','{\"en\":\"Sava\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.42','MG','{\"en\":\"Sofia\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.32','MG','{\"en\":\"Analanjirofo\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.41','MG','{\"en\":\"Boeny\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.43','MG','{\"en\":\"Betsiboka\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.33','MG','{\"en\":\"Alaotra Mangoro\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.44','MG','{\"en\":\"Melaky\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.14','MG','{\"en\":\"Bongolava\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.12','MG','{\"en\":\"Vakinankaratra\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.13','MG','{\"en\":\"Itasy\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.11','MG','{\"en\":\"Analamanga\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.31','MG','{\"en\":\"Atsinanana\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.54','MG','{\"en\":\"Menabe\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.22','MG','{\"en\":\"Amoron\'i Mania\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.21','MG','{\"en\":\"Upper Matsiatra\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.23','MG','{\"en\":\"Vatovavy Fitovinany\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.24','MG','{\"en\":\"Ihorombe\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.25','MG','{\"en\":\"Atsimo-Atsinanana\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.53','MG','{\"en\":\"Anosy\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.52','MG','{\"en\":\"Androy\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MG.51','MG','{\"en\":\"Atsimo-Andrefana\"}',1);
/*!40000 ALTER TABLE `__PREFIX__subadmin1` ENABLE KEYS */;

--
-- Dumping data for table `__PREFIX__subadmin2`
--

/*!40000 ALTER TABLE `__PREFIX__subadmin2` DISABLE KEYS */;
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.33.33313','MG','MG.33','{\"en\":\"Ambatondrazaka District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.33.33312','MG','MG.33','{\"en\":\"Amparafaravola District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.31.31306','MG','MG.31','{\"en\":\"Brickaville\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11117','MG','MG.11','{\"en\":\"Antananarivo-Atsimondrano\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11106','MG','MG.11','{\"en\":\"Manjakandriana\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.33.33314','MG','MG.33','{\"en\":\"Moramanga District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.21.21201','MG','MG.21','{\"en\":\"Fianarantsoa I\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.21.21208','MG','MG.21','{\"en\":\"Ambohimahasoa\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.22.22203','MG','MG.22','{\"en\":\"Ambositra District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.12.12118','MG','MG.12','{\"en\":\"Antsirabe II\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.12.12108','MG','MG.12','{\"en\":\"Antsirabe I District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.12.12114','MG','MG.12','{\"en\":\"Antanifotsy\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.12.12110','MG','MG.12','{\"en\":\"Ambatolampy\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.42.42413','MG','MG.42','{\"en\":\"Antsohihy\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.42.42412','MG','MG.42','{\"en\":\"Befandriana Nord\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.42.42410','MG','MG.42','{\"en\":\"Mandritsara\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.31.31301','MG','MG.31','{\"en\":\"Toamasina I\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.31.31310','MG','MG.31','{\"en\":\"Toamasina II\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.72.72712','MG','MG.72','{\"en\":\"Andapa District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.41.41406','MG','MG.41','{\"en\":\"Marovoay District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.32.32315','MG','MG.32','{\"en\":\"Vavatenina District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.32.32303','MG','MG.32','{\"en\":\"Maroantsetra District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.32.32304','MG','MG.32','{\"en\":\"Mananara Nord District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.53.53517','MG','MG.53','{\"en\":\"Betroka District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.25.25213','MG','MG.25','{\"en\":\"Farafangana District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.25.25214','MG','MG.25','{\"en\":\"Vangaindrano District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.53.53519','MG','MG.53','{\"en\":\"Amboasary District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.51.51504','MG','MG.51','{\"en\":\"Morombe District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.42.42414','MG','MG.42','{\"en\":\"Bealanana District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.51.51505','MG','MG.51','{\"en\":\"Ankazoabo District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.12.12109','MG','MG.12','{\"en\":\"Betafo District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.54.54511','MG','MG.54','{\"en\":\"Miandrivazo District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.51.51520','MG','MG.51','{\"en\":\"Toliara II District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.51.51501','MG','MG.51','{\"en\":\"Toliara I District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.33.33316','MG','MG.33','{\"en\":\"Andilamena District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.33.33317','MG','MG.33','{\"en\":\"Anosibe An\'ala District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.22.22202','MG','MG.22','{\"en\":\"Ambatofinandrahana District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.22.22204','MG','MG.22','{\"en\":\"Fandriana District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.22.22223','MG','MG.22','{\"en\":\"Manandriana District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.54.54508','MG','MG.54','{\"en\":\"Morondava District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.54.54509','MG','MG.54','{\"en\":\"Mahabo District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.54.54502','MG','MG.54','{\"en\":\"Manja District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.51.51503','MG','MG.51','{\"en\":\"Beroroha District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11104','MG','MG.11','{\"en\":\"Ankazobe District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11103','MG','MG.11','{\"en\":\"Ambohidratrimo District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11115','MG','MG.11','{\"en\":\"Andramasina District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.51.51512','MG','MG.51','{\"en\":\"Sakaraha District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.51.51507','MG','MG.51','{\"en\":\"Ampanihy District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.51.51506','MG','MG.51','{\"en\":\"Betioky District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.52.52516','MG','MG.52','{\"en\":\"Ambovombe District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.52.52513','MG','MG.52','{\"en\":\"Beloha District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.52.52518','MG','MG.52','{\"en\":\"Bekily District\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.71.71715','MG','MG.71','{\"en\":\"Antsiranana I\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.71.71713','MG','MG.71','{\"en\":\"Antsiranana II\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.51.51521','MG','MG.51','{\"en\":\"Benenitra\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.52.52514','MG','MG.52','{\"en\":\"Tsihombe\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.53.53515','MG','MG.53','{\"en\":\"Taolagnaro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11107','MG','MG.11','{\"en\":\"Anjozorobe\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.12.12116','MG','MG.12','{\"en\":\"Faratsiho\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.14.14111','MG','MG.14','{\"en\":\"Tsiroanomandidy\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.14.14119','MG','MG.14','{\"en\":\"Fenoarivobe\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.13.13105','MG','MG.13','{\"en\":\"Arivonimamo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.13.13112','MG','MG.13','{\"en\":\"Miarinarivo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.13.13113','MG','MG.13','{\"en\":\"Soavinandriana\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.21.21205','MG','MG.21','{\"en\":\"Ambalavao\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.21.21219','MG','MG.21','{\"en\":\"Ikalamavony\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.23.23211','MG','MG.23','{\"en\":\"Ikongo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.23.23210','MG','MG.23','{\"en\":\"Manakara\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.41.41415','MG','MG.41','{\"en\":\"Mahajanga II\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.41.41401','MG','MG.41','{\"en\":\"Mahajanga I\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.43.43404','MG','MG.43','{\"en\":\"Maevatanana\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.43.43408','MG','MG.43','{\"en\":\"Tsaratanana\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.44.44421','MG','MG.44','{\"en\":\"Maintirano\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.44.44417','MG','MG.44','{\"en\":\"Ambatomainty\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.32.32302','MG','MG.32','{\"en\":\"Nosy Boraha\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.72.72711','MG','MG.72','{\"en\":\"Sambava\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.71.71718','MG','MG.71','{\"en\":\"Nosy Be\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.71.71717','MG','MG.71','{\"en\":\"Ambilobe\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.72.72710','MG','MG.72','{\"en\":\"Antalaha\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.31.31308','MG','MG.31','{\"en\":\"Mahanoro\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.31.31309','MG','MG.31','{\"en\":\"Marolambo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.31.31311','MG','MG.31','{\"en\":\"Antanambao Manampontsy\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.32.32305','MG','MG.32','{\"en\":\"Fenerive Est\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.32.32318','MG','MG.32','{\"en\":\"Soanierana Ivongo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11101006','MG','MG.11','{\"en\":\"6e Arrondissement\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.24.24221','MG','MG.24','{\"en\":\"Iakora\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.25.25215','MG','MG.25','{\"en\":\"Midongy-Atsimo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.54.54510','MG','MG.54','{\"en\":\"Belo Sur Tsiribihina\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.71.71719','MG','MG.71','{\"en\":\"Ambanja\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11102','MG','MG.11','{\"en\":\"Antananarivo Avaradrano\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.25.25217','MG','MG.25','{\"en\":\"Vondrozo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.25.25222','MG','MG.25','{\"en\":\"Befotaka\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.72.72716','MG','MG.72','{\"en\":\"Vohemar\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11101001','MG','MG.11','{\"en\":\"1er Arrondissement\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11101002','MG','MG.11','{\"en\":\"2e Arrondissement\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11101003','MG','MG.11','{\"en\":\"3e Arrondissement\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11101004','MG','MG.11','{\"en\":\"4e Arrondissement\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.11.11101005','MG','MG.11','{\"en\":\"5e Arrondissement\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.12.12120','MG','MG.12','{\"en\":\"Mandoto\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.21.21220','MG','MG.21','{\"en\":\"Lalangina\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.21.21224','MG','MG.21','{\"en\":\"Vohibato\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.21.21225','MG','MG.21','{\"en\":\"Isandra\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.23.23206','MG','MG.23','{\"en\":\"Ifanadiana\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.23.23207','MG','MG.23','{\"en\":\"Nosy-Varika\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.23.23209','MG','MG.23','{\"en\":\"Mananjary\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.24.24216','MG','MG.24','{\"en\":\"Ihosy\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.23.23212','MG','MG.23','{\"en\":\"Vohipeno\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.41.41403','MG','MG.41','{\"en\":\"Soalala\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.41.41405','MG','MG.41','{\"en\":\"Ambato Boeni\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.41.41407','MG','MG.41','{\"en\":\"Mitsinjo\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.42.42409','MG','MG.42','{\"en\":\"Port-Berge (Boriziny-Vaovao)\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.42.42411','MG','MG.42','{\"en\":\"Analalava\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.42.42423','MG','MG.42','{\"en\":\"Mampikony\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.43.43416','MG','MG.43','{\"en\":\"Kandreho\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.44.44402','MG','MG.44','{\"en\":\"Besalampy\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.44.44420','MG','MG.44','{\"en\":\"Antsalova\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.44.44422','MG','MG.44','{\"en\":\"Morafenobe\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.31.31307','MG','MG.31','{\"en\":\"Vatomandry\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MG.24.24218','MG','MG.24','{\"en\":\"Ivohibe\"}',1);
/*!40000 ALTER TABLE `__PREFIX__subadmin2` ENABLE KEYS */;

--
-- Dumping data for table `__PREFIX__cities`
--

/*!40000 ALTER TABLE `__PREFIX__cities` DISABLE KEYS */;
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Toamasina\"}',49.40,-18.15,'P','PPLA','MG.31',NULL,206373,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Vondrozo\"}',47.28,-22.82,'P','PPL','MG.25','MG.25.25217',19949,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Vohipaho\"}',47.50,-23.55,'P','PPL','MG.25','MG.25.25214',27000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Vohimanitra\"}',47.70,-21.70,'P','PPL','MG.23','MG.23.23210',6000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Vohibinany\"}',49.03,-17.35,'P','PPL','MG.31',NULL,25311,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Vavatenina\"}',49.20,-17.47,'P','PPL','MG.32','MG.32.32315',36916,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Vangaindrano\"}',47.60,-23.35,'P','PPL','MG.25','MG.25.25214',23523,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Tsiroanomandidy\"}',46.05,-18.77,'P','PPLA','MG.14',NULL,27060,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Tsiombe\"}',45.48,-25.30,'P','PPL','MG.52','MG.52.52514',29825,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Tsaratanana\"}',47.65,-16.80,'P','PPL','MG.43','MG.43.43408',16761,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Tranovaho\"}',44.97,-25.30,'P','PPL','MG.52','MG.52.52513',13000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Toliara\"}',43.67,-23.35,'P','PPLA','MG.51','MG.51.8299677',115319,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Tôlanaro\"}',46.98,-25.03,'P','PPLA','MG.53',NULL,45141,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Soavinandriana\"}',46.73,-19.17,'P','PPL','MG.13','MG.13.13113',40453,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Soanindrariny\"}',47.23,-19.90,'P','PPL','MG.12','MG.12.12118',21000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Soanierana Ivongo\"}',49.58,-16.92,'P','PPL','MG.32','MG.32.32318',39271,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Sitampiky\"}',46.10,-16.67,'P','PPL','MG.41','MG.41.41405',21000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Sambava\"}',50.17,-14.27,'P','PPLA','MG.72',NULL,31522,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Sambaina\"}',47.78,-18.90,'P','PPL','MG.11','MG.11.11106',7000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Sakaraha\"}',44.53,-22.90,'P','PPL','MG.51','MG.51.51512',21826,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Sahavato\"}',48.33,-20.60,'P','PPL','MG.23','MG.23.23207',28000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Sahatavy\"}',49.00,-17.45,'P','PPL','MG.32','MG.32.32315',10000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Sadjoavato\"}',49.35,-12.62,'P','PPL','MG.71','MG.71.71713',7600,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Sadabe\"}',47.70,-18.63,'P','PPL','MG.11','MG.11.11106',17000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ranohira\"}',45.40,-22.48,'P','PPL','MG.24','MG.24.24216',6000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Nosy Varika\"}',48.53,-20.58,'P','PPL','MG.23','MG.23.23207',37152,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Morondava\"}',44.32,-20.29,'P','PPLA','MG.54',NULL,36803,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Moramanga\"}',48.23,-18.95,'P','PPL','MG.33','MG.33.33314',29212,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Miarinarivo\"}',46.91,-18.96,'P','PPLA','MG.13',NULL,0,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Miandrivazo\"}',45.46,-19.53,'P','PPL','MG.54','MG.54.54511',20631,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Miandrarivo\"}',46.75,-19.43,'P','PPL','MG.12','MG.12.12116',27000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Miadanandriana\"}',47.78,-19.03,'P','PPL','MG.11','MG.11.11106',10000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Merikanjaka\"}',47.85,-19.13,'P','PPL','MG.11','MG.11.11106',8000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Marovoay\"}',46.64,-16.11,'P','PPL','MG.41','MG.41.41406',31253,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Marolambo\"}',48.12,-20.05,'P','PPL','MG.31','MG.31.31309',26160,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Maroantsetra\"}',49.74,-15.44,'P','PPL','MG.32','MG.32.32303',23859,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Mantasoa\"}',47.83,-19.02,'P','PPL','MG.11','MG.11.11106',10000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Manjakandriana\"}',47.80,-18.92,'P','PPL','MG.11','MG.11.11106',31840,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Manato\"}',47.48,-22.40,'P','PPL','MG.25','MG.25.25217',7000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Mananjary\"}',48.34,-21.23,'P','PPL','MG.23','MG.23.23209',27686,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Mananara\"}',49.77,-16.17,'P','PPL','MG.32','MG.32.32304',41209,'Indian/Antananarivo',1,'2018-09-27 23:00:00','2018-09-27 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Manakara\"}',48.01,-22.15,'P','PPLA','MG.23',NULL,35499,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Maintirano\"}',44.03,-18.06,'P','PPLA','MG.44',NULL,16000,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Mahavelona\"}',49.51,-17.68,'P','PPL','MG.31','MG.31.31310',7987,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Mahanoro\"}',48.80,-19.90,'P','PPL','MG.31','MG.31.31308',39879,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Mahajanga\"}',46.32,-15.72,'P','PPLA','MG.41','MG.41.11072817',154657,'Indian/Antananarivo',1,'2019-09-04 23:00:00','2019-09-04 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Mahabe\"}',45.33,-17.08,'P','PPL','MG.44','MG.44.44402',10000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Maevatanana\"}',46.83,-16.95,'P','PPLA','MG.43',NULL,24000,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Kopoky\"}',45.20,-25.20,'P','PPL','MG.52','MG.52.52513',15000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ikongo\"}',47.43,-21.88,'P','PPL','MG.23','MG.23.23211',32374,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ikalamavony\"}',46.58,-21.15,'P','PPL','MG.21','MG.21.21219',15601,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ihosy\"}',46.13,-22.40,'P','PPLA','MG.24',NULL,16990,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ifatsy\"}',47.75,-22.40,'P','PPL','MG.23','MG.23.23212',15000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ifanadiana\"}',47.63,-21.30,'P','PPL','MG.23','MG.23.23206',17543,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Fianarantsoa\"}',47.09,-21.45,'P','PPLA','MG.21',NULL,167227,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Fenoarivo Be\"}',46.57,-18.43,'P','PPL','MG.14','MG.14.14119',19605,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Fenoarivo Atsinanana\"}',49.41,-17.38,'P','PPLA','MG.32',NULL,21036,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Faratsiho\"}',46.95,-19.40,'P','PPL','MG.12','MG.12.12116',37563,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Farafangana\"}',47.83,-22.82,'P','PPLA','MG.25','MG.25.8299290',24764,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Fandriana\"}',47.38,-20.23,'P','PPL','MG.22','MG.22.22204',31437,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Fandrandava\"}',47.25,-21.52,'P','PPL','MG.21','MG.21.21220',9000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Betioky\"}',44.38,-23.72,'P','PPL','MG.51','MG.51.51506',31102,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Beteza\"}',45.12,-24.45,'P','PPL','MG.52','MG.52.52518',7000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Betafo\"}',46.85,-19.83,'P','PPL','MG.12','MG.12.12109',29785,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Beroroha\"}',45.17,-21.67,'P','PPL','MG.51','MG.51.51503',18632,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Bemaitso\"}',48.50,-17.07,'P','PPL','MG.33','MG.33.33316',8000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Belo sur Tsiribihina\"}',44.55,-19.70,'P','PPL','MG.54','MG.54.54510',23900,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Beloha\"}',45.05,-25.17,'P','PPL','MG.52','MG.52.52513',23021,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Behompy\"}',43.85,-23.25,'P','PPL','MG.51','MG.51.51520',7000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Bealanana\"}',48.75,-14.54,'P','PPL','MG.42','MG.42.42414',16948,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Arivonimamo\"}',47.18,-19.02,'P','PPL','MG.13','MG.13.13105',21982,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Antsohimbondrona\"}',48.85,-13.08,'P','PPL','MG.71','MG.71.71717',32080,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Antsohihy\"}',47.99,-14.88,'P','PPLA','MG.42',NULL,21290,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Antsiranana\"}',49.29,-12.32,'P','PPLA','MG.71',NULL,82937,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Antsirabe Afovoany\"}',48.97,-15.95,'P','PPL','MG.42','MG.42.42410',13000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Antsirabe\"}',47.03,-19.87,'P','PPLA','MG.12',NULL,186253,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Antanifotsy\"}',47.32,-19.65,'P','PPL','MG.12','MG.12.12114',70626,'Indian/Antananarivo',1,'2018-09-27 23:00:00','2018-09-27 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Antananarivo\"}',47.54,-18.91,'P','PPLC','MG.11',NULL,1391433,'Indian/Antananarivo',1,'2021-02-23 23:00:00','2021-02-23 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Antalaha\"}',50.28,-14.90,'P','PPL','MG.72','MG.72.72710',34112,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Antakotako\"}',49.80,-15.32,'P','PPL','MG.32','MG.32.32303',11000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ankazondandy\"}',47.78,-18.70,'P','PPL','MG.11','MG.11.11106',16000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ankazobe\"}',47.12,-18.32,'P','PPL','MG.11','MG.11.11104',15722,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ankazoabo\"}',44.52,-22.28,'P','PPL','MG.51','MG.51.51505',25961,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Anjozorobe\"}',47.87,-18.40,'P','PPL','MG.11','MG.11.11107',19027,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Anjepy\"}',47.72,-18.85,'P','PPL','MG.11','MG.11.11106',6000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Hell-Ville\"}',48.27,-13.40,'P','PPL','MG.71','MG.71.71718',22680,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Andilamena\"}',48.57,-17.01,'P','PPLA2','MG.33','MG.33.8335145',19750,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Andovoranto\"}',49.11,-18.95,'P','PPL','MG.31','MG.31.31306',10429,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Andapa\"}',49.65,-14.65,'P','PPL','MG.72','MG.72.72712',20798,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ampasimanolotra\"}',49.07,-18.82,'P','PPL','MG.31','MG.31.31306',21000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Amparafaravola\"}',48.22,-17.59,'P','PPLA2','MG.33','MG.33.7670894',51519,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ampanihy\"}',44.75,-24.69,'P','PPLA2','MG.51','MG.51.51507',25686,'Indian/Antananarivo',1,'2018-09-27 23:00:00','2018-09-27 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ampahana\"}',50.22,-14.75,'P','PPL','MG.72','MG.72.72710',25000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambovombe\"}',46.09,-25.18,'P','PPLA','MG.52',NULL,66818,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambositra\"}',47.24,-20.53,'P','PPLA','MG.22',NULL,30353,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambohitseheno\"}',47.80,-18.78,'P','PPL','MG.11','MG.11.11106',6000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambohitrolomahitsy\"}',47.68,-18.70,'P','PPL','MG.11','MG.11.11106',17000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambohitrandriamanitra\"}',47.78,-19.08,'P','PPL','MG.11','MG.11.11106',8000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambodivoara\"}',49.98,-14.33,'P','PPL','MG.72','MG.72.72711',10000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambodifotatra\"}',49.85,-16.98,'P','PPL','MG.32',NULL,11830,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Amboasary\"}',46.38,-25.03,'P','PPL','MG.53','MG.53.53519',36082,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Amboanjo\"}',47.85,-22.00,'P','PPL','MG.23','MG.23.23210',17000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambilobe\"}',49.05,-13.20,'P','PPLA2','MG.71','MG.71.11427437',56000,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambatondrazaka\"}',48.42,-17.83,'P','PPLA','MG.33',NULL,43134,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambatolampy\"}',47.42,-19.38,'P','PPL','MG.12','MG.12.12110',28461,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambatofinandrahana\"}',46.80,-20.55,'P','PPLA2','MG.22','MG.22.8335147',25997,'Indian/Antananarivo',1,'2018-09-06 23:00:00','2018-09-06 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambato Boeny\"}',46.72,-16.47,'P','PPL','MG.41','MG.41.41405',22529,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambarakaraka\"}',48.87,-13.50,'P','PPL','MG.71','MG.71.71717',16114,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambanja\"}',48.45,-13.67,'P','PPL','MG.71','MG.71.71719',30621,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Ambalavao\"}',46.93,-21.83,'P','PPL','MG.21','MG.21.21205',28027,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
INSERT INTO `__PREFIX__cities` (`country_code`, `name`, `longitude`, `latitude`, `feature_class`, `feature_code`, `subadmin1_code`, `subadmin2_code`, `population`, `time_zone`, `active`, `created_at`, `updated_at`) VALUES ('MG','{\"en\":\"Alarobia\"}',47.73,-18.97,'P','PPL','MG.11','MG.11.11106',16000,'Indian/Antananarivo',1,'2018-09-09 23:00:00','2018-09-09 23:00:00');
/*!40000 ALTER TABLE `__PREFIX__cities` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed
