-- 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 ('MA.01','MA','{\"en\":\"Tanger-Tetouan-Al Hoceima\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MA.02','MA','{\"en\":\"Oriental\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MA.03','MA','{\"en\":\"Fès-Meknès\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MA.04','MA','{\"en\":\"Rabat-Salé-Kénitra\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MA.05','MA','{\"en\":\"Béni Mellal-Khénifra\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MA.06','MA','{\"en\":\"Casablanca-Settat\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MA.07','MA','{\"en\":\"Marrakesh-Safi\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MA.08','MA','{\"en\":\"Drâa-Tafilalet\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MA.09','MA','{\"en\":\"Souss-Massa\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MA.10','MA','{\"en\":\"Guelmim-Oued Noun\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MA.11','MA','{\"en\":\"Laâyoune-Sakia El Hamra\"}',1);
INSERT INTO `__PREFIX__subadmin1` (`code`, `country_code`, `name`, `active`) VALUES ('MA.12','MA','{\"en\":\"Dakhla-Oued Ed-Dahab\"}',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 ('MA.09.581','MA','MA.09','{\"en\":\"Tiznit\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.01.571','MA','MA.01','{\"en\":\"Tetouan\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.03.561','MA','MA.03','{\"en\":\"Taza\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.09.551','MA','MA.09','{\"en\":\"Tata\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.09.541','MA','MA.09','{\"en\":\"Taroudannt\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.03.531','MA','MA.03','{\"en\":\"Taounate\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.10.521','MA','MA.10','{\"en\":\"Tan-Tan\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.01.511','MA','MA.01','{\"en\":\"Tanger-Assilah\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.04.481','MA','MA.04','{\"en\":\"Sidi-Kacem\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.06.461','MA','MA.06','{\"en\":\"Settat Province\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.04.441','MA','MA.04','{\"en\":\"Sale\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.07.431','MA','MA.07','{\"en\":\"Safi\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.04.421','MA','MA.04','{\"en\":\"Rabat\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.02.411','MA','MA.02','{\"en\":\"Oujda-Angad\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.08.401','MA','MA.08','{\"en\":\"Ouarzazate\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.02.381','MA','MA.02','{\"en\":\"Nador\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.01.331','MA','MA.01','{\"en\":\"Larache\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.11.321','MA','MA.11','{\"en\":\"Laayoune\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.05.311','MA','MA.05','{\"en\":\"Khouribga Province\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.05.301','MA','MA.05','{\"en\":\"Khenifra\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.04.291','MA','MA.04','{\"en\":\"Khemisset\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.04.281','MA','MA.04','{\"en\":\"Kenitra Province\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.09.273','MA','MA.09','{\"en\":\"Inezgane-Ait Melloul\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.03.271','MA','MA.03','{\"en\":\"Ifrane\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.10.261','MA','MA.10','{\"en\":\"Guelmim\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.02.251','MA','MA.02','{\"en\":\"Figuig\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.07.211','MA','MA.07','{\"en\":\"Essaouira\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.08.201','MA','MA.08','{\"en\":\"Errachidia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.07.191','MA','MA.07','{\"en\":\"Kelaa-Des-Sraghna\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.06.181','MA','MA.06','{\"en\":\"El-Jadida\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.01.151','MA','MA.01','{\"en\":\"Chefchaouen Province\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.03.131','MA','MA.03','{\"en\":\"Boulemane\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.06.111','MA','MA.06','{\"en\":\"Benslimane\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.05.091','MA','MA.05','{\"en\":\"Beni-Mellal\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.05.081','MA','MA.05','{\"en\":\"Azilal Province\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.01.051','MA','MA.01','{\"en\":\"Al-Hoceima\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.09.001','MA','MA.09','{\"en\":\"Agadir-Ida-ou-Tnan\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.04.501','MA','MA.04','{\"en\":\"Skhirate-Temara\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.10.071','MA','MA.10','{\"en\":\"Assa-Zag\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.11.221','MA','MA.11','{\"en\":\"Es-Semara\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.03.061','MA','MA.03','{\"en\":\"Meknes\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.07.161','MA','MA.07','{\"en\":\"Chichaoua\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.07.351','MA','MA.07','{\"en\":\"Marrakech\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.03.451','MA','MA.03','{\"en\":\"Sefrou\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.02.113','MA','MA.02','{\"en\":\"Berkane\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.02.275','MA','MA.02','{\"en\":\"Jerada\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.02.533','MA','MA.02','{\"en\":\"Taourirt\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.11.121','MA','MA.11','{\"en\":\"Boujdour\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.09.163','MA','MA.09','{\"en\":\"Chtouka-Ait-Baha\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.07.041','MA','MA.07','{\"en\":\"Al-Haouz\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.01.227','MA','MA.01','{\"en\":\"Fahs-Anjra\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.06.141','MA','MA.06','{\"en\":\"Casablanca\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.03.591','MA','MA.03','{\"en\":\"Moulay-Yacoub\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.03.171','MA','MA.03','{\"en\":\"El-Hajeb\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.12.066','MA','MA.12','{\"en\":\"Aousserd\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.12.391','MA','MA.12','{\"en\":\"Oued-Ed-Dahab\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.06.385','MA','MA.06','{\"en\":\"Nouaceur\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.03.231','MA','MA.03','{\"en\":\"Fes\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.06.371','MA','MA.06','{\"en\":\"Mohammedia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.08.587','MA','MA.08','{\"en\":\"Zagora\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.06.355','MA','MA.06','{\"en\":\"Mediouna\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.02.265','MA','MA.02','{\"en\":\"Guercif Province\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.06.117','MA','MA.06','{\"en\":\"Berrechid Province\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.02.167','MA','MA.02','{\"en\":\"Driouch Province\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.08.577','MA','MA.08','{\"en\":\"Tinghir Province\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.01.405','MA','MA.01','{\"en\":\"Ouezzane Province\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.01.573','MA','MA.01','{\"en\":\"M\'Diq-Fnideq\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.04.491','MA','MA.04','{\"en\":\"Sidi Slimane\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.06.467','MA','MA.06','{\"en\":\"Sidi Bennour\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.07.585','MA','MA.07','{\"en\":\"Youssoufia\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.08.363','MA','MA.08','{\"en\":\"Midelt\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.07.427','MA','MA.07','{\"en\":\"Rehamna\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.11.537','MA','MA.11','{\"en\":\"Tarfaya\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.10.473','MA','MA.10','{\"en\":\"Sidi Ifni\"}',1);
INSERT INTO `__PREFIX__subadmin2` (`code`, `country_code`, `subadmin1_code`, `name`, `active`) VALUES ('MA.05.255','MA','MA.05','{\"en\":\"Fquih Ben Salah Province\"}',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 ('MA','{\"en\":\"Smara\"}',-11.67,26.74,'P','PPL','MA.11','MA.11.221',42056,'Africa/Casablanca',1,'2017-07-07 23:00:00','2017-07-07 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 ('MA','{\"en\":\"Setti Fatma\"}',-7.68,31.23,'P','PPL','MA.07','MA.07.041',22283,'Africa/Casablanca',1,'2021-07-16 23:00:00','2021-07-16 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 ('MA','{\"en\":\"Zaïo\"}',-2.73,34.94,'P','PPLA3','MA.02','MA.02.381',30008,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 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 ('MA','{\"en\":\"Zagora\"}',-5.84,30.33,'P','PPLA3','MA.08','MA.08.587',35154,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Zag\"}',-9.29,28.02,'P','PPL','MA.10','MA.10.071',7751,'Africa/Casablanca',1,'2019-09-30 23:00:00','2019-09-30 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 ('MA','{\"en\":\"Youssoufia\"}',-8.53,32.25,'P','PPLA3','MA.07','MA.07.431',64910,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Tiznit\"}',-9.73,29.70,'P','PPLA3','MA.09','MA.09.581',55092,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Tirhanimîne\"}',-3.95,35.24,'P','PPL','MA.01','MA.01.051',55827,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 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 ('MA','{\"en\":\"Tinghir\"}',-5.53,31.51,'P','PPLA2','MA.08','MA.08.577',36795,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 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 ('MA','{\"en\":\"Tiflet\"}',-6.31,33.89,'P','PPLA3','MA.04','MA.04.291',70010,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Tétouan\"}',-5.37,35.58,'P','PPLA2','MA.01','MA.01.571',326261,'Africa/Casablanca',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 ('MA','{\"en\":\"Temara\"}',-6.91,33.93,'P','PPLA3','MA.04','MA.04.501',313510,'Africa/Casablanca',1,'2017-12-05 23:00:00','2017-12-05 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 ('MA','{\"en\":\"Taza\"}',-4.01,34.21,'P','PPLA2','MA.03','MA.03.561',141890,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Taroudant\"}',-8.88,30.47,'P','PPLA3','MA.09','MA.09.541',71133,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Targuist\"}',-4.32,34.94,'P','PPLA3','MA.01','MA.01.051',11560,'Africa/Casablanca',1,'2018-05-20 23:00:00','2018-05-20 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 ('MA','{\"en\":\"Tarfaya\"}',-12.93,27.94,'P','PPL','MA.11','MA.11.537',5615,'Africa/Casablanca',1,'2018-02-15 23:00:00','2018-02-15 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 ('MA','{\"en\":\"Taourirt\"}',-2.90,34.41,'P','PPLA3','MA.02','MA.02.533',82518,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 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 ('MA','{\"en\":\"Taounate\"}',-4.64,34.54,'P','PPLA3','MA.03','MA.03.531',32802,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Tan-Tan\"}',-11.10,28.44,'P','PPLA2','MA.10','MA.10.521',61924,'Africa/Casablanca',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 ('MA','{\"en\":\"Tangier\"}',-5.80,35.77,'P','PPLA','MA.01','MA.01.511',688356,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Tahla\"}',-4.42,34.05,'P','PPLA3','MA.03','MA.03.561',25761,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 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 ('MA','{\"en\":\"Souq Larb’a al Gharb\"}',-6.00,34.69,'P','PPLA3','MA.04','MA.04.281',44059,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 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 ('MA','{\"en\":\"Sidi Yahia El Gharb\"}',-6.30,34.30,'P','PPLA3','MA.04','MA.04.491',32202,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 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 ('MA','{\"en\":\"Sidi Slimane\"}',-5.93,34.26,'P','PPLA3','MA.04','MA.04.281',79437,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Sidi Qacem\"}',-5.71,34.22,'P','PPL','MA.04','MA.04.481',74755,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 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 ('MA','{\"en\":\"Sidi Ifni\"}',-10.17,29.38,'P','PPLA3','MA.09','MA.09.581',20000,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Sidi Bennour\"}',-8.43,32.65,'P','PPLA3','MA.06','MA.06.181',40044,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Settat\"}',-7.62,33.00,'P','PPLA2','MA.06','MA.06.461',119082,'Africa/Casablanca',1,'2016-11-02 23:00:00','2016-11-02 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 ('MA','{\"en\":\"Sefrou\"}',-4.83,33.83,'P','PPLA3','MA.03','MA.03.451',65150,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Sale\"}',-6.80,34.05,'P','PPL','MA.04','MA.04.441',903485,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 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 ('MA','{\"en\":\"Safi\"}',-9.24,32.30,'P','PPLA2','MA.07','MA.07.431',288163,'Africa/Casablanca',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 ('MA','{\"en\":\"Reçani\"}',-4.27,31.28,'P','PPL','MA.08','MA.08.201',20469,'Africa/Casablanca',1,'2021-07-17 23:00:00','2021-07-17 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 ('MA','{\"en\":\"Rabat\"}',-6.83,34.01,'P','PPLC','MA.04','MA.04.421',1655753,'Africa/Casablanca',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 ('MA','{\"en\":\"Oulmes\"}',-6.00,33.43,'P','PPLA3','MA.04','MA.04.291',19014,'Africa/Casablanca',1,'2020-01-10 23:00:00','2020-01-10 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 ('MA','{\"en\":\"Oulad Teïma\"}',-9.21,30.39,'P','PPL','MA.09','MA.09.541',66832,'Africa/Casablanca',1,'2020-06-10 23:00:00','2020-06-10 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 ('MA','{\"en\":\"Oujda-Angad\"}',-1.91,34.68,'P','PPLA','MA.02','MA.02.411',405253,'Africa/Casablanca',1,'2019-12-03 23:00:00','2019-12-03 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 ('MA','{\"en\":\"Oued Zem\"}',-6.57,32.86,'P','PPLA3','MA.05','MA.05.311',84910,'Africa/Casablanca',1,'2019-03-13 23:00:00','2019-03-13 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 ('MA','{\"en\":\"Ouezzane\"}',-5.58,34.80,'P','PPLA2','MA.01','MA.01.405',58684,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 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 ('MA','{\"en\":\"Ouarzazat\"}',-6.89,30.92,'P','PPLA2','MA.08','MA.08.401',57245,'Africa/Casablanca',1,'2018-04-24 23:00:00','2018-04-24 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 ('MA','{\"en\":\"Oualidia\"}',-9.03,32.73,'P','PPL','MA.06','MA.06.181',5826,'Africa/Casablanca',1,'2018-08-14 23:00:00','2018-08-14 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 ('MA','{\"en\":\"Zawyat an Nwaçer\"}',-7.62,33.38,'P','PPL','MA.06','MA.06.385',12696,'Africa/Casablanca',1,'2021-07-16 23:00:00','2021-07-16 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 ('MA','{\"en\":\"Nador\"}',-2.93,35.17,'P','PPLA3','MA.02','MA.02.381',129260,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Al Aaroui\"}',-3.01,35.01,'P','PPL','MA.02','MA.02.381',36021,'Africa/Casablanca',1,'2021-07-15 23:00:00','2021-07-15 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 ('MA','{\"en\":\"Mohammedia\"}',-7.38,33.69,'P','PPLA3','MA.06','MA.06.371',187708,'Africa/Casablanca',1,'2018-12-20 23:00:00','2018-12-20 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 ('MA','{\"en\":\"Midelt\"}',-4.75,32.69,'P','PPLA3','MA.05','MA.05.301',45159,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Midar\"}',-3.53,34.94,'P','PPLA3','MA.02','MA.02.381',10229,'Africa/Casablanca',1,'2018-05-20 23:00:00','2018-05-20 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 ('MA','{\"en\":\"Meknès\"}',-5.55,33.89,'P','PPLA2','MA.03','MA.03.061',545705,'Africa/Casablanca',1,'2017-01-31 23:00:00','2017-01-31 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 ('MA','{\"en\":\"Mechraa Bel Ksiri\"}',-5.96,34.57,'P','PPLA3','MA.04','MA.04.481',27802,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 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 ('MA','{\"en\":\"Martil\"}',-5.28,35.62,'P','PPLA3','MA.01','MA.01.571',39738,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Marrakesh\"}',-8.00,31.63,'P','PPLA','MA.07','MA.07.351',839296,'Africa/Casablanca',1,'2016-11-02 23:00:00','2016-11-02 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 ('MA','{\"en\":\"Ifrane\"}',-6.35,31.70,'P','PPL','MA.05','MA.05.081',13000,'Africa/Casablanca',1,'2021-07-16 23:00:00','2021-07-16 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 ('MA','{\"en\":\"Larache\"}',-6.16,35.19,'P','PPLA3','MA.01','MA.01.331',109294,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Ksar El Kebir\"}',-5.90,35.00,'P','PPL','MA.01','MA.01.331',108753,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 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 ('MA','{\"en\":\"Khouribga\"}',-6.91,32.88,'P','PPLA3','MA.05','MA.05.311',167673,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Khenifra\"}',-5.66,32.93,'P','PPLA3','MA.05','MA.05.301',73906,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Kenitra\"}',-6.58,34.26,'P','PPLA','MA.04','MA.04.281',366570,'Africa/Casablanca',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 ('MA','{\"en\":\"Kasba Tadla\"}',-6.27,32.60,'P','PPLA3','MA.05','MA.05.091',41199,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Jerada\"}',-2.16,34.31,'P','PPLA3','MA.02','MA.02.275',43696,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Ifrane\"}',-5.11,33.53,'P','PPLA3','MA.03','MA.03.271',73782,'Africa/Casablanca',1,'2018-05-17 23:00:00','2018-05-17 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 ('MA','{\"en\":\"Guercif\"}',-3.35,34.23,'P','PPLA3','MA.03','MA.03.561',57544,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Guelmim\"}',-10.06,28.99,'P','PPLA','MA.10','MA.10.261',98229,'Africa/Casablanca',1,'2019-12-03 23:00:00','2019-12-03 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 ('MA','{\"en\":\"Fnidek\"}',-5.36,35.85,'P','PPL','MA.01','MA.01.571',53559,'Africa/Casablanca',1,'2018-08-05 23:00:00','2018-08-05 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 ('MA','{\"en\":\"Al Fqih Ben Çalah\"}',-6.69,32.50,'P','PPL','MA.05','MA.05.255',84072,'Africa/Casablanca',1,'2020-06-10 23:00:00','2020-06-10 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 ('MA','{\"en\":\"Figuig (Centre)\"}',-1.23,32.11,'P','PPL','MA.02','MA.02.251',12516,'Africa/Casablanca',1,'2021-07-14 23:00:00','2021-07-14 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 ('MA','{\"en\":\"Fès al Bali\"}',-4.95,34.07,'P','PPLX','MA.03','MA.03.231',156000,'Africa/Casablanca',1,'2020-06-10 23:00:00','2020-06-10 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 ('MA','{\"en\":\"Fès\"}',-5.00,34.03,'P','PPLA','MA.03','MA.03.231',964891,'Africa/Casablanca',1,'2020-06-10 23:00:00','2020-06-10 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 ('MA','{\"en\":\"Essaouira\"}',-9.77,31.51,'P','PPLA3','MA.07','MA.07.211',70634,'Africa/Casablanca',1,'2020-01-23 23:00:00','2020-01-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 ('MA','{\"en\":\"Arfoud\"}',-4.23,31.44,'P','PPL','MA.08','MA.08.201',23637,'Africa/Casablanca',1,'2019-10-20 23:00:00','2019-10-20 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 ('MA','{\"en\":\"Kelaat Mgouna\"}',-6.13,31.25,'P','PPL','MA.08','MA.08.577',14190,'Africa/Casablanca',1,'2018-06-13 23:00:00','2018-06-13 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 ('MA','{\"en\":\"El Jadid\"}',-8.51,33.26,'P','PPL','MA.06','MA.06.181',147549,'Africa/Casablanca',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 ('MA','{\"en\":\"El Hajeb\"}',-5.37,33.69,'P','PPLA3','MA.03','MA.03.171',28126,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"El Aïoun\"}',-2.51,34.58,'P','PPL','MA.02','MA.02.533',35196,'Africa/Casablanca',1,'2021-07-15 23:00:00','2021-07-15 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 ('MA','{\"en\":\"Imzouren\"}',-3.85,35.15,'P','PPLA3','MA.01','MA.01.051',40000,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 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 ('MA','{\"en\":\"Chefchaouen\"}',-5.26,35.17,'P','PPLA2','MA.01','MA.01.151',36280,'Africa/Casablanca',1,'2021-10-28 23:00:00','2021-10-28 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 ('MA','{\"en\":\"Casablanca\"}',-7.61,33.59,'P','PPLA','MA.06','MA.06.141',3144909,'Africa/Casablanca',1,'2021-11-28 23:00:00','2021-11-28 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 ('MA','{\"en\":\"Bouznika\"}',-7.16,33.79,'P','PPLA3','MA.06','MA.06.111',27283,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Bouarfa\"}',-1.96,32.53,'P','PPLA3','MA.02','MA.02.251',28846,'Africa/Casablanca',1,'2019-08-12 23:00:00','2019-08-12 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 ('MA','{\"en\":\"Berkane\"}',-2.32,34.92,'P','PPLA3','MA.02','MA.02.113',80721,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Beni Mellal\"}',-6.35,32.34,'P','PPLA','MA.05','MA.05.091',166399,'Africa/Casablanca',1,'2017-02-02 23:00:00','2017-02-02 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 ('MA','{\"en\":\"Berrechid\"}',-7.59,33.27,'P','PPLA3','MA.06','MA.06.461',93954,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Azrou\"}',-5.22,33.43,'P','PPLA3','MA.03','MA.03.271',48249,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Azemmour\"}',-8.34,33.29,'P','PPLA3','MA.06','MA.06.181',37140,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Asilah\"}',-6.03,35.47,'P','PPL','MA.01','MA.01.511',28861,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 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 ('MA','{\"en\":\"Khemisset\"}',-6.07,33.82,'P','PPLA3','MA.04','MA.04.291',106991,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Al Hoceïma\"}',-3.94,35.25,'P','PPLA2','MA.01','MA.01.051',395644,'Africa/Casablanca',1,'2016-11-02 23:00:00','2016-11-02 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 ('MA','{\"en\":\"Aïn Leuh\"}',-5.34,33.29,'P','PPL','MA.03','MA.03.271',5278,'Africa/Casablanca',1,'2021-07-15 23:00:00','2021-07-15 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 ('MA','{\"en\":\"Aïn Beni Mathar\"}',-2.03,34.01,'P','PPL','MA.02','MA.02.275',16289,'Africa/Casablanca',1,'2018-08-14 23:00:00','2018-08-14 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 ('MA','{\"en\":\"Ahfir\"}',-2.10,34.95,'P','PPLA3','MA.02','MA.02.113',19611,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Agadir\"}',-9.60,30.42,'P','PPLA','MA.09','MA.09.001',698310,'Africa/Casablanca',1,'2019-05-08 23:00:00','2019-05-08 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 ('MA','{\"en\":\"Skhirate\"}',-7.03,33.85,'P','PPLA3','MA.04','MA.04.501',44850,'Africa/Casablanca',1,'2016-11-28 23:00:00','2016-11-28 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 ('MA','{\"en\":\"Mhamid\"}',-5.72,29.82,'P','PPL','MA.08','MA.08.587',10000,'Africa/Casablanca',1,'2021-07-17 23:00:00','2021-07-17 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 ('MA','{\"en\":\"Taghazout\"}',-9.71,30.54,'P','PPLA3','MA.09','MA.09.001',5233,'Africa/Casablanca',1,'2020-01-16 23:00:00','2020-01-16 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 ('MA','{\"en\":\"Boujniba\"}',-6.77,32.90,'P','PPL','MA.05','MA.05.311',15041,'Africa/Casablanca',1,'2016-11-01 23:00:00','2016-11-01 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 ('MA','{\"en\":\"Errachidia\"}',-4.43,31.93,'P','PPLA3','MA.08','MA.08.201',92374,'Africa/Casablanca',1,'2017-12-05 23:00:00','2017-12-05 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 ('MA','{\"en\":\"Dakhla\"}',-9.55,30.41,'P','PPLX','MA.09','MA.09.001',55618,'Africa/Casablanca',1,'2021-08-08 23:00:00','2021-08-08 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 ('MA','{\"en\":\"Gueltat Zemmour\"}',-12.37,25.14,'P','PPL','MA.11','MA.11.121',6740,'Africa/Casablanca',1,'2016-11-03 23:00:00','2016-11-03 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 ('MA','{\"en\":\"Salé Al Jadida\"}',-6.74,34.00,'P','PPL','MA.04','MA.04.441',200000,'Africa/Casablanca',1,'2021-07-16 23:00:00','2021-07-16 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 ('MA','{\"en\":\"Cap Negro II\"}',-5.29,35.66,'P','PPL','MA.01',NULL,10000,'Africa/Casablanca',1,'2018-08-08 23:00:00','2018-08-08 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 ('MA','{\"en\":\"Bni Bouayach\"}',-3.84,35.11,'P','PPL','MA.01','MA.01.051',18271,'Africa/Casablanca',1,'2021-07-14 23:00:00','2021-07-14 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
