--
-- Host: localhost    Database: Quickadclassified
-- ------------------------------------------------------


--
-- Dumping data for table `<<prefix>>subadmin1`
--

INSERT INTO `<<prefix>>subadmin1` VALUES (3611,'TZ.19','TZ','Kagera','Kagera',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3612,'TZ.25','TZ','Zanzibar Urban/West','Zanzibar Urban/West',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3613,'TZ.22','TZ','Zanzibar North','Zanzibar North',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3614,'TZ.21','TZ','Zanzibar Central/South','Zanzibar Central/South',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3615,'TZ.18','TZ','Tanga','Tanga',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3616,'TZ.17','TZ','Tabora','Tabora',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3617,'TZ.16','TZ','Singida','Singida',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3618,'TZ.15','TZ','Shinyanga','Shinyanga',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3619,'TZ.24','TZ','Rukwa','Rukwa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3620,'TZ.02','TZ','Pwani','Pwani',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3621,'TZ.20','TZ','Pemba South','Pemba South',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3622,'TZ.13','TZ','Pemba North','Pemba North',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3623,'TZ.12','TZ','Mwanza','Mwanza',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3624,'TZ.10','TZ','Morogoro','Morogoro',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3625,'TZ.09','TZ','Mbeya','Mbeya',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3626,'TZ.08','TZ','Mara','Mara',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3627,'TZ.07','TZ','Lindi','Lindi',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3628,'TZ.06','TZ','Kilimanjaro','Kilimanjaro',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3629,'TZ.05','TZ','Kigoma','Kigoma',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3630,'TZ.04','TZ','Iringa','Iringa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3631,'TZ.03','TZ','Dodoma','Dodoma',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3632,'TZ.23','TZ','Dar es Salaam','Dar es Salaam',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3633,'TZ.26','TZ','Arusha','Arusha',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3634,'TZ.27','TZ','Manyara','Manyara',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3635,'TZ.14','TZ','Ruvuma','Ruvuma',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3636,'TZ.11','TZ','Mtwara','Mtwara',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3637,'TZ.31','TZ','Simiyu','Simiyu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3638,'TZ.28','TZ','Geita','Geita',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3639,'TZ.29','TZ','Katavi','Katavi',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3640,'TZ.30','TZ','Njombe','Njombe',1);

--
-- Dumping data for table `<<prefix>>subadmin2`
--

INSERT INTO `<<prefix>>subadmin2` VALUES (38779,'TZ.13.5401','TZ','TZ.13','Wete District','Wete District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38780,'TZ.17.1404','TZ','TZ.17','Urambo','Urambo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38781,'TZ.10.0504','TZ','TZ.10','Ulanga','Ulanga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38782,'TZ.12.1901','TZ','TZ.12','Ukerewe District','Ukerewe District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38783,'TZ.23.0703','TZ','TZ.23','Temeke','Temeke',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38784,'TZ.08.2001','TZ','TZ.08','Tarime','Tarime',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38785,'TZ.18.0404','TZ','TZ.18','Tanga','Tanga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38786,'TZ.17.1406','TZ','TZ.17','Tabora Urban','Tabora Urban',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38787,'TZ.24.1502','TZ','TZ.24','Sumbawanga','Sumbawanga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38788,'TZ.16.1302','TZ','TZ.16','Singida Rural District','Singida Rural District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38789,'TZ.15.1701','TZ','TZ.15','Shinyanga Urban','Shinyanga Urban',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38790,'TZ.08.2002','TZ','TZ.08','Serengeti','Serengeti',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38791,'TZ.12.1905','TZ','TZ.12','Sengerema','Sengerema',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38792,'TZ.06.0303','TZ','TZ.06','Same','Same',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38793,'TZ.09.1204','TZ','TZ.09','Rungwe','Rungwe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38794,'TZ.02.0605','TZ','TZ.02','Rufiji','Rufiji',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38795,'TZ.06.0301','TZ','TZ.06','Rombo District','Rombo District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38796,'TZ.18.0405','TZ','TZ.18','Pangani','Pangani',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38797,'TZ.17.1401','TZ','TZ.17','Nzega','Nzega',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38798,'TZ.24.1503','TZ','TZ.24','Nkasi','Nkasi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38799,'TZ.30.2204','TZ','TZ.30','Njombe District Council','Njombe District Council',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38800,'TZ.26.0205','TZ','TZ.26','Ngorongoro','Ngorongoro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38801,'TZ.19.1805','TZ','TZ.19','Ngara','Ngara',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38802,'TZ.06.0302','TZ','TZ.06','Mwanga','Mwanga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38803,'TZ.08.2003','TZ','TZ.08','Musoma','Musoma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38804,'TZ.19.1803','TZ','TZ.19','Muleba','Muleba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38805,'TZ.18.0403','TZ','TZ.18','Muheza District','Muheza District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38806,'TZ.04.1102','TZ','TZ.04','Mufindi','Mufindi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38807,'TZ.03.0102','TZ','TZ.03','Mpwapwa','Mpwapwa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38808,'TZ.29.2302','TZ','TZ.29','Mpanda','Mpanda',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38809,'TZ.10.0505','TZ','TZ.10','Morogoro Urban','Morogoro Urban',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38810,'TZ.26.0201','TZ','TZ.26','Monduli District','Monduli District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38811,'TZ.20.5502','TZ','TZ.20','Mkoani District','Mkoani District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38812,'TZ.27.2103','TZ','TZ.27','Mbulu','Mbulu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38813,'TZ.09.1206','TZ','TZ.09','Mbozi','Mbozi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38814,'TZ.09.1202','TZ','TZ.09','Mbeya','Mbeya',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38815,'TZ.31.2404','TZ','TZ.31','Maswa District','Maswa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38816,'TZ.16.1303','TZ','TZ.16','Manyoni','Manyoni',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38817,'TZ.30.2203','TZ','TZ.30','Makete','Makete',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38818,'TZ.12.1902','TZ','TZ.12','Magu','Magu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38819,'TZ.02.0606','TZ','TZ.02','Mafia','Mafia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38820,'TZ.18.0401','TZ','TZ.18','Lushoto','Lushoto',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38821,'TZ.07.0804','TZ','TZ.07','Liwale','Liwale',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38822,'TZ.09.1203','TZ','TZ.09','Kyela','Kyela',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38823,'TZ.12.1904','TZ','TZ.12','Kwimba District','Kwimba District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38824,'TZ.18.0402','TZ','TZ.18','Korogwe District','Korogwe District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38825,'TZ.03.0101','TZ','TZ.03','Kondoa','Kondoa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38826,'TZ.13.5402','TZ','TZ.13','Micheweni','Micheweni',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38827,'TZ.27.2105','TZ','TZ.27','Kiteto','Kiteto',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38828,'TZ.02.0603','TZ','TZ.02','Kisarawe','Kisarawe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38829,'TZ.23.0701','TZ','TZ.23','Kinondoni','Kinondoni',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38830,'TZ.07.0801','TZ','TZ.07','Kilwa','Kilwa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38831,'TZ.10.0501','TZ','TZ.10','Kilosa','Kilosa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38832,'TZ.10.0503','TZ','TZ.10','Kilombero','Kilombero',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38833,'TZ.05.1601','TZ','TZ.05','Kibondo','Kibondo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38834,'TZ.05.1602','TZ','TZ.05','Kasulu','Kasulu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38835,'TZ.19.1801','TZ','TZ.19','Karagwe','Karagwe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38836,'TZ.15.1704','TZ','TZ.15','Kahama Rural District','Kahama Rural District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38837,'TZ.04.1101','TZ','TZ.04','Iringa Rural District','Iringa Rural District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38838,'TZ.16.1301','TZ','TZ.16','Iramba','Iramba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38839,'TZ.09.1205','TZ','TZ.09','Ileje','Ileje',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38840,'TZ.23.0702','TZ','TZ.23','Ilala','Ilala',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38841,'TZ.17.1402','TZ','TZ.17','Igunga','Igunga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38842,'TZ.18.0406','TZ','TZ.18','Handeni','Handeni',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38843,'TZ.27.2102','TZ','TZ.27','Hanang District','Hanang District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38844,'TZ.06.0305','TZ','TZ.06','Hai','Hai',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38845,'TZ.28.2501','TZ','TZ.28','Geita','Geita',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38846,'TZ.09.1201','TZ','TZ.09','Chunya','Chunya',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38847,'TZ.20.5501','TZ','TZ.20','Chake Chake District','Chake Chake District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38848,'TZ.08.2004','TZ','TZ.08','Bunda','Bunda',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38849,'TZ.19.1802','TZ','TZ.19','Bukoba','Bukoba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38850,'TZ.19.1804','TZ','TZ.19','Biharamulo District','Biharamulo District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38851,'TZ.31.2401','TZ','TZ.31','Bariadi','Bariadi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38852,'TZ.02.0601','TZ','TZ.02','Bagamoyo','Bagamoyo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38853,'TZ.26.0202','TZ','TZ.26','Meru','Meru',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38854,'TZ.14.1001','TZ','TZ.14','Tunduru','Tunduru',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38855,'TZ.14.1002','TZ','TZ.14','Songea','Songea',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38856,'TZ.11.0902','TZ','TZ.11','Newala','Newala',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38857,'TZ.07.0803','TZ','TZ.07','Nachingwea','Nachingwea',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38858,'TZ.11.0901','TZ','TZ.11','Mtwara','Mtwara',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38859,'TZ.14.1003','TZ','TZ.14','Mbinga','Mbinga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38860,'TZ.11.0903','TZ','TZ.11','Masasi','Masasi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38861,'TZ.30.2205','TZ','TZ.30','Ludewa','Ludewa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38862,'TZ.07.0806','TZ','TZ.07','Lindi Urban','Lindi Urban',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38863,'TZ.03.0104','TZ','TZ.03','Chamwino','Chamwino',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38864,'TZ.03.0106','TZ','TZ.03','Bahi District','Bahi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38865,'TZ.15.1702','TZ','TZ.15','Kishapu District','Kishapu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38866,'TZ.05.1603','TZ','TZ.05','Kigoma Rural','Kigoma Rural',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38867,'TZ.31.2403','TZ','TZ.31','Meatu','Meatu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38868,'TZ.12.1907','TZ','TZ.12','Misungwi district','Misungwi district',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38869,'TZ.04.1104','TZ','TZ.04','Kilolo District','Kilolo District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38870,'TZ.17.1403','TZ','TZ.17','Uyui District','Uyui District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38871,'TZ.09.1207','TZ','TZ.09','Mbarali district','Mbarali district',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38872,'TZ.02.0602','TZ','TZ.02','Kibaha District','Kibaha District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38873,'TZ.03.0103','TZ','TZ.03','Kongwa','Kongwa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38874,'TZ.26.0206','TZ','TZ.26','Arusha District','Arusha District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38875,'TZ.27.2101','TZ','TZ.27','Babati District','Babati District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38876,'TZ.27.2104','TZ','TZ.27','Simanjiro','Simanjiro',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38877,'TZ.07.0802','TZ','TZ.07','Lindi Rural','Lindi Rural',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38878,'TZ.07.0805','TZ','TZ.07','Ruangwa','Ruangwa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38879,'TZ.10.0502','TZ','TZ.10','Morogoro Rural','Morogoro Rural',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38880,'TZ.15.1703','TZ','TZ.15','Shinyanga Rural','Shinyanga Rural',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38881,'TZ.14.1005','TZ','TZ.14','Namtumbo','Namtumbo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38882,'TZ.04.1103','TZ','TZ.04','Iringa Urban District','Iringa Urban District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38883,'TZ.03.0105','TZ','TZ.03','Dodoma Urban District','Dodoma Urban District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38884,'TZ.16.1304','TZ','TZ.16','Singida Urban District','Singida Urban District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38885,'TZ.06.0304','TZ','TZ.06','Moshi Rural District','Moshi Rural District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38886,'TZ.02.0604','TZ','TZ.02','Mkuranga','Mkuranga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38887,'TZ.12.1906','TZ','TZ.12','Ilemela District','Ilemela District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38888,'TZ.06.0306','TZ','TZ.06','Moshi Urban District','Moshi Urban District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38889,'TZ.28.2504','TZ','TZ.28','Bukombe District','Bukombe District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38890,'TZ.10.0506','TZ','TZ.10','Mvomero District','Mvomero District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38891,'TZ.26.0207','TZ','TZ.26','Longido District','Longido District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38892,'TZ.11.0906','TZ','TZ.11','Nanyumbu District','Nanyumbu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38893,'TZ.17.1405','TZ','TZ.17','Sikonge District','Sikonge District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38894,'TZ.26.0204','TZ','TZ.26','Karatu District','Karatu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38895,'TZ.18.0407','TZ','TZ.18','Kilindi District','Kilindi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38896,'TZ.11.0904','TZ','TZ.11','Tandahimba','Tandahimba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38897,'TZ.12.1903','TZ','TZ.12','Nyamagana District','Nyamagana District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38898,'TZ.28.2505','TZ','TZ.28','Chato District','Chato District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38899,'TZ.24.1504','TZ','TZ.24','Sumbawanga Urban','Sumbawanga Urban',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38900,'TZ.05.1605','TZ','TZ.05','Uvinza District','Uvinza District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38901,'TZ.05.1607','TZ','TZ.05','Kakonko District','Kakonko District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38902,'TZ.26.0203','TZ','TZ.26','Arusha City','Arusha City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38903,'TZ.03.0107','TZ','TZ.03','Chemba','Chemba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38904,'TZ.28.2503','TZ','TZ.28','Mbogwe','Mbogwe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38905,'TZ.28.2502','TZ','TZ.28','Nyang’hwale','Nyang\'hwale',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38906,'TZ.04.1105','TZ','TZ.04','Mafinga Town Council','Mafinga Town Council',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38907,'TZ.19.1806','TZ','TZ.19','Bukoba Municipal','Bukoba Municipal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38908,'TZ.19.1808','TZ','TZ.19','Kyerwa','Kyerwa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38909,'TZ.19.1807','TZ','TZ.19','Missenyi','Missenyi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38910,'TZ.29.2303','TZ','TZ.29','Mlele','Mlele',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38911,'TZ.29.2301','TZ','TZ.29','Mpanda Town','Mpanda Town',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38912,'TZ.05.1606','TZ','TZ.05','Buhigwe','Buhigwe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38913,'TZ.05.1608','TZ','TZ.05','Kasulu Town','Kasulu Town',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38914,'TZ.05.1604','TZ','TZ.05','Kigoma Ujiji Municipal','Kigoma Ujiji Municipal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38915,'TZ.06.0307','TZ','TZ.06','Siha','Siha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38916,'TZ.27.2106','TZ','TZ.27','Babati Town','Babati Town',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38917,'TZ.08.2007','TZ','TZ.08','Butiama','Butiama',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38918,'TZ.08.2005','TZ','TZ.08','Musoma Municipal','Musoma Municipal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38919,'TZ.08.2006','TZ','TZ.08','Rorya','Rorya',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38920,'TZ.09.1208','TZ','TZ.09','Mbeya City','Mbeya City',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38921,'TZ.09.1209','TZ','TZ.09','Momba','Momba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38922,'TZ.09.1210','TZ','TZ.09','Tunduma','Tunduma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38923,'TZ.10.0507','TZ','TZ.10','Gairo','Gairo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38924,'TZ.11.0907','TZ','TZ.11','Masasi Town','Masasi Town',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38925,'TZ.30.2206','TZ','TZ.30','Makambako Town','Makambako Town',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38926,'TZ.30.2201','TZ','TZ.30','Njombe Town','Njombe Town',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38927,'TZ.30.2202','TZ','TZ.30','Wanging’ombe','Wanging\'ombe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38928,'TZ.02.0607','TZ','TZ.02','Kibaha Town','Kibaha Town',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38929,'TZ.24.1501','TZ','TZ.24','Kalambo','Kalambo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38930,'TZ.14.1006','TZ','TZ.14','Nyasa','Nyasa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38931,'TZ.14.1004','TZ','TZ.14','Songea Municipal','Songea Municipal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38932,'TZ.15.1705','TZ','TZ.15','Kahama Town','Kahama Town',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38933,'TZ.31.2405','TZ','TZ.31','Busega','Busega',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38934,'TZ.31.2402','TZ','TZ.31','Itilima','Itilima',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38935,'TZ.16.1305','TZ','TZ.16','Ikungi','Ikungi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38936,'TZ.16.1306','TZ','TZ.16','Mkalama','Mkalama',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38937,'TZ.17.1407','TZ','TZ.17','Kaliua','Kaliua',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38938,'TZ.18.0410','TZ','TZ.18','Handeni Town','Handeni Town',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38939,'TZ.18.0409','TZ','TZ.18','Korogwe Town','Korogwe Town',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38940,'TZ.18.0408','TZ','TZ.18','Mkinga','Mkinga',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38941,'TZ.21.5201','TZ','TZ.21','Kati','Kati',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38942,'TZ.25.5301','TZ','TZ.25','Magharibi','Magharibi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38943,'TZ.22.5101','TZ','TZ.22','Kaskazini A','Kaskazini A',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38944,'TZ.22.5102','TZ','TZ.22','Kaskazini B','Kaskazini B',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38945,'TZ.21.5202','TZ','TZ.21','Kusini','Kusini',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38946,'TZ.25.5302','TZ','TZ.25','Mjini','Mjini',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (38947,'TZ.11.0905','TZ','TZ.11','Mtwara Urban','Mtwara Urban',1);

--
-- Dumping data for table `<<prefix>>cities`
--

INSERT INTO `<<prefix>>cities` VALUES (148730,'TZ','Zanzibar','Zanzibar',-6.16394,39.1979,'P','PPLA','TZ.25','TZ.25.5302',403658,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (148842,'TZ','Wete','Wete',-5.05589,39.7294,'P','PPLA','TZ.13','TZ.13.5401',26450,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (148942,'TZ','Vwawa','Vwawa',-9.11667,32.9333,'P','PPL','TZ.09','TZ.09.1206',40145,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (148987,'TZ','Vikindu','Vikindu',-7.00667,39.2985,'P','PPL','TZ.02','TZ.02.0604',23307,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149027,'TZ','Uyovu','Uyovu',-3.28333,31.5258,'P','PPL','TZ.28','TZ.28.2504',60849,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149050,'TZ','Uvinza','Uvinza',-5.10361,30.3911,'P','PPL','TZ.05','TZ.05.1605',24650,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149070,'TZ','Utete','Utete',-7.98598,38.7579,'P','PPL','TZ.02','TZ.02.0605',11888,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149114,'TZ','Usoke','Usoke',-5.16667,32.35,'P','PPL','TZ.17','TZ.17.1404',7295,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149129,'TZ','Ushirombo','Ushirombo',-3.49194,31.9639,'P','PPL','TZ.28','TZ.28.2504',95052,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149132,'TZ','Usevia','Usevia',-7.1,31.2333,'P','PPL','TZ.29','TZ.29.2303',17742,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149151,'TZ','Usagara','Usagara',-2.68333,33,'P','PPL','TZ.12','TZ.12.1907',15514,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149155,'TZ','Usa River','Usa River',-3.36667,36.85,'P','PPL','TZ.26','TZ.26.0202',18726,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149172,'TZ','Urambo','Urambo',-5.06667,32.05,'P','PPL','TZ.17','TZ.17.1404',23724,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149239,'TZ','Ulenje','Ulenje',-8.93333,33.6833,'P','PPL','TZ.09','TZ.09.1202',12219,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149402,'TZ','Tunduma','Tunduma',-9.3,32.7667,'P','PPL','TZ.09','TZ.09.1210',36556,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149418,'TZ','Tumbi','Tumbi',-5.06667,32.7333,'P','PPL','TZ.17','TZ.17.1406',32900,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149437,'TZ','Tukuyu','Tukuyu',-9.25,33.65,'P','PPL','TZ.09','TZ.09.1204',28398,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149512,'TZ','Tinde','Tinde',-3.88333,33.2,'P','PPL','TZ.15','TZ.15.1703',22082,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149581,'TZ','Tarime','Tarime',-1.35,34.3667,'P','PPL','TZ.08','TZ.08.2001',33094,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149606,'TZ','Tanga','Tanga',-5.06893,39.0988,'P','PPLA','TZ.18','TZ.18.0404',224876,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149658,'TZ','Tabora','Tabora',-5.01622,32.8266,'P','PPLA','TZ.17','TZ.17.1406',145292,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149703,'TZ','Sumbawanga','Sumbawanga',-7.96667,31.6167,'P','PPLA','TZ.24','TZ.24.1504',89161,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149768,'TZ','Soni','Soni',-4.85,38.3667,'P','PPL','TZ.18','TZ.18.0401',12402,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149775,'TZ','Songwa','Songwa',-3.51667,33.5167,'P','PPL','TZ.15','TZ.15.1702',23618,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149792,'TZ','Somanda','Somanda',-3.36667,33.95,'P','PPL','TZ.31','TZ.31.2404',33932,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149812,'TZ','Sokoni','Sokoni',-6.43333,39.55,'P','PPL','TZ.21','TZ.21.5202',25821,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149854,'TZ','Sirari','Sirari',-1.25367,34.476,'P','PPL','TZ.08','TZ.08.2001',24317,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149879,'TZ','Singida','Singida',-4.81629,34.7436,'P','PPLA','TZ.16','TZ.16.1304',62432,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (149929,'TZ','Sikonge','Sikonge',-5.63333,32.7667,'P','PPL','TZ.17','TZ.17.1405',27113,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (150006,'TZ','Shinyanga','Shinyanga',-3.66393,33.4212,'P','PPLA','TZ.15','TZ.15.1701',107362,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (150037,'TZ','Shelui','Shelui',-4.36667,34.2,'P','PPL','TZ.16','TZ.16.1301',24817,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (150099,'TZ','Sepuka','Sepuka',-4.75,34.5333,'P','PPL','TZ.16','TZ.16.1305',25657,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (150276,'TZ','Same','Same',-4.06667,37.7333,'P','PPL','TZ.06','TZ.06.0303',17455,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (150436,'TZ','Rulenge','Rulenge',-2.7175,30.6325,'P','PPL','TZ.19','TZ.19.1805',22069,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (150453,'TZ','Rujewa','Rujewa',-8.7,34.3833,'P','PPL','TZ.09','TZ.09.1207',29228,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (150634,'TZ','Puma','Puma',-5,34.7333,'P','PPL','TZ.16','TZ.16.1305',17092,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (150689,'TZ','Poli','Poli',-3.33333,36.8,'P','PPL','TZ.26','TZ.26.0202',9568,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (150793,'TZ','Pangani','Pangani',-5.42526,38.9747,'P','PPL','TZ.18','TZ.18.0405',8343,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (150885,'TZ','Old Shinyanga','Old Shinyanga',-3.55,33.4,'P','PPL','TZ.15','TZ.15.1701',23747,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (150930,'TZ','Nzega','Nzega',-4.21667,33.1833,'P','PPL','TZ.17','TZ.17.1401',26584,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151062,'TZ','Nyanguge','Nyanguge',-2.55,33.2,'P','PPL','TZ.12','TZ.12.1902',10746,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151108,'TZ','Nyamuswa','Nyamuswa',-1.9,34.0167,'P','PPL','TZ.08','TZ.08.2004',16507,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151211,'TZ','Nyalikungu','Nyalikungu',-3.18333,33.7833,'P','PPL','TZ.31','TZ.31.2404',24648,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151262,'TZ','Nyakahanga','Nyakahanga',-1.60333,31.1414,'P','PPL','TZ.19','TZ.19.1801',14611,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151266,'TZ','Nyakabindi','Nyakabindi',-2.63333,33.9833,'P','PPL','TZ.31','TZ.31.2401',18428,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151363,'TZ','Nsunga','Nsunga',-1.14389,31.3947,'P','PPL','TZ.19','TZ.19.1807',20049,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151373,'TZ','Nshamba','Nshamba',-1.79833,31.5511,'P','PPL','TZ.19','TZ.19.1803',19815,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151424,'TZ','Nkove','Nkove',-7.95,30.85,'P','PPL','TZ.24','TZ.24.1503',5389,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151445,'TZ','Nkoaranga','Nkoaranga',-3.33333,36.8,'P','PPL','TZ.26','TZ.26.0202',14738,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151479,'TZ','Njombe','Njombe',-9.33333,34.7667,'P','PPLA','TZ.30','TZ.30.2201',46724,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151567,'TZ','Nguruka','Nguruka',-5.10917,31.0419,'P','PPL','TZ.05','TZ.05.1605',39135,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151599,'TZ','Ngudu','Ngudu',-2.96667,33.3333,'P','PPL','TZ.12','TZ.12.1904',22658,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151610,'TZ','Ngorongoro','Ngorongoro',-3.23973,35.4875,'P','PPL','TZ.26','TZ.26.0205',10836,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151678,'TZ','Ngerengere','Ngerengere',-6.75,38.1167,'P','PPL','TZ.10','TZ.10.0502',17181,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151711,'TZ','Ngara','Ngara',-2.51222,30.6558,'P','PPL','TZ.19','TZ.19.1805',16890,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151775,'TZ','Ndungu','Ndungu',-4.36667,38.05,'P','PPL','TZ.06','TZ.06.0303',14545,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151872,'TZ','Ndago','Ndago',-4.6,34.35,'P','PPL','TZ.16','TZ.16.1301',13012,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151920,'TZ','Nansio','Nansio',-2.13333,33.05,'P','PPL','TZ.08',NULL,6437,'Africa/Dar_es_Salaam',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151929,'TZ','Nangwa','Nangwa',-4.46667,35.45,'P','PPL','TZ.27','TZ.27.2102',18595,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151986,'TZ','Namanyere','Namanyere',-7.51667,31.05,'P','PPL','TZ.24','TZ.24.1503',28218,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (151988,'TZ','Namanga','Namanga',-2.55116,36.7838,'P','PPL','TZ.26','TZ.26.0207',12048,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152009,'TZ','Nakatunguru','Nakatunguru',-2.11667,33.0667,'P','PPL','TZ.08',NULL,6064,'Africa/Dar_es_Salaam',1,'2011-03-05 23:00:00','2011-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152042,'TZ','Naberera','Naberera',-4.2,36.9333,'P','PPL','TZ.27','TZ.27.2104',13499,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152169,'TZ','Mwembe','Mwembe',-4.15,37.85,'P','PPL','TZ.06','TZ.06.0303',9032,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152183,'TZ','Mwaya','Mwaya',-9.55,33.95,'P','PPL','TZ.09','TZ.09.1203',7558,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152224,'TZ','Mwanza','Mwanza',-2.51667,32.9,'P','PPLA','TZ.12','TZ.12.1903',436801,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152265,'TZ','Mwanga','Mwanga',-4.8,38.2,'P','PPL','TZ.18','TZ.18.0402',12846,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152376,'TZ','Mwadui','Mwadui',-3.55,33.6,'P','PPL','TZ.15','TZ.15.1702',23296,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152403,'TZ','Mvomero','Mvomero',-6.25,38.6667,'P','PPL','TZ.02','TZ.02.0601',31324,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152451,'TZ','Musoma','Musoma',-1.5,33.8,'P','PPLA','TZ.08','TZ.08.2005',121119,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152497,'TZ','Muriti','Muriti',-1.98333,32.9167,'P','PPL','TZ.08',NULL,20254,'Africa/Dar_es_Salaam',1,'2011-03-05 23:00:00','2011-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152546,'TZ','Mungaa','Mungaa',-4.96667,34.8833,'P','PPL','TZ.16','TZ.16.1305',16715,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152570,'TZ','Muleba','Muleba',-1.83972,31.6544,'P','PPL','TZ.19','TZ.19.1803',11555,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152632,'TZ','Muheza','Muheza',-5.16667,38.7833,'P','PPL','TZ.18','TZ.18.0403',17000,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152663,'TZ','Mugumu','Mugumu',-1.85,34.7,'P','PPL','TZ.08','TZ.08.2002',18431,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152689,'TZ','Mugango','Mugango',-1.68333,33.7,'P','PPL','TZ.08','TZ.08.2003',10550,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152718,'TZ','Mtwango','Mtwango',-9.01667,34.8,'P','PPL','TZ.30','TZ.30.2204',19040,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152743,'TZ','Mto wa Mbu','Mto wa Mbu',-3.35,35.85,'P','PPL','TZ.26','TZ.26.0201',17754,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152781,'TZ','Mtinko','Mtinko',-4.55,34.85,'P','PPL','TZ.16','TZ.16.1302',26725,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152793,'TZ','Mtimbira','Mtimbira',-8.78333,36.35,'P','PPL','TZ.10','TZ.10.0504',11122,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152877,'TZ','Mtambile','Mtambile',-5.38333,39.7,'P','PPL','TZ.20','TZ.20.5502',6797,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (152933,'TZ','Msowero','Msowero',-6.53333,37.2,'P','PPL','TZ.10','TZ.10.0501',17861,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153046,'TZ','Msanga','Msanga',-6.05,36.0333,'P','PPL','TZ.03','TZ.03.0104',5527,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153094,'TZ','Mpwapwa','Mpwapwa',-6.35,36.4833,'P','PPL','TZ.03','TZ.03.0102',19806,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153176,'TZ','Mpanda','Mpanda',-6.34379,31.0695,'P','PPLA','TZ.29','TZ.29.2301',73338,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153209,'TZ','Moshi','Moshi',-3.35,37.3333,'P','PPLA','TZ.06','TZ.06.0306',156959,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153220,'TZ','Morogoro','Morogoro',-6.82102,37.6612,'P','PPLA','TZ.10','TZ.10.0505',250902,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153247,'TZ','Monduli','Monduli',-3.3,36.45,'P','PPL','TZ.26','TZ.26.0201',5694,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153352,'TZ','Mlowo','Mlowo',-9,32.9833,'P','PPL','TZ.09','TZ.09.1206',18737,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153384,'TZ','Mlimba','Mlimba',-8.8,35.8167,'P','PPL','TZ.10','TZ.10.0503',34970,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153408,'TZ','Mlangali','Mlangali',-9.78333,34.5167,'P','PPL','TZ.30','TZ.30.2205',15168,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153412,'TZ','Mlandizi','Mlandizi',-6.7,38.7333,'P','PPL','TZ.02','TZ.02.0602',29394,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153423,'TZ','Mlalo','Mlalo',-4.93333,38.9333,'P','PPL','TZ.18','TZ.18.0408',15576,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153482,'TZ','Mkuranga','Mkuranga',-7.11799,39.2078,'P','PPL','TZ.02','TZ.02.0604',28037,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153585,'TZ','Mkokotoni','Mkokotoni',-5.87506,39.2552,'P','PPLA','TZ.22','TZ.22.5101',2572,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153709,'TZ','Mwandiga','Mwandiga',-4.83,29.6581,'P','PPL','TZ.05','TZ.05.1603',16822,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153759,'TZ','Misungwi','Misungwi',-2.85,33.0833,'P','PPL','TZ.12','TZ.12.1907',35530,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153772,'TZ','Misasi','Misasi',-3,33.0833,'P','PPL','TZ.12','TZ.12.1907',14170,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153871,'TZ','Mikumi','Mikumi',-7.40409,36.9831,'P','PPL','TZ.10','TZ.10.0501',16780,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (153955,'TZ','Micheweni','Micheweni',-4.96667,39.8333,'P','PPL','TZ.13','TZ.13.5402',9838,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154002,'TZ','Mhango','Mhango',-3.28333,32.85,'P','PPL','TZ.15','TZ.15.1703',21553,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154097,'TZ','Mgandu','Mgandu',-5.95,34.1333,'P','PPL','TZ.16','TZ.16.1303',23718,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154313,'TZ','Mbulu','Mbulu',-3.85,35.5333,'P','PPL','TZ.27','TZ.27.2103',13430,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154321,'TZ','Mbuguni','Mbuguni',-3.56667,36.95,'P','PPL','TZ.26','TZ.26.0202',16442,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154380,'TZ','Mbeya','Mbeya',-8.9,33.45,'P','PPLA','TZ.09','TZ.09.1208',291649,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154470,'TZ','Mazinde','Mazinde',-4.8,38.2167,'P','PPL','TZ.18','TZ.18.0402',20534,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154566,'TZ','Matui','Matui',-4.8,38.25,'P','PPL','TZ.18','TZ.18.0401',20241,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154576,'TZ','Matonga','Matonga',-2.38333,34.0833,'P','PPL','TZ.31','TZ.31.2401',11828,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154635,'TZ','Matamba','Matamba',-8.98333,33.9667,'P','PPL','TZ.30','TZ.30.2203',10642,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154638,'TZ','Matai','Matai',-8.3,31.5167,'P','PPL','TZ.24','TZ.24.1501',24070,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154648,'TZ','Maswa','Maswa',-2.68333,33.9833,'P','PPL','TZ.31','TZ.31.2401',22025,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154654,'TZ','Masumbwe','Masumbwe',-3.63333,32.1833,'P','PPL','TZ.28','TZ.28.2503',34780,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154666,'TZ','Masoko','Masoko',-9.33333,33.75,'P','PPL','TZ.09','TZ.09.1204',12720,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154780,'TZ','Maramba','Maramba',-5.05,38.6167,'P','PPL','TZ.18','TZ.18.0403',26531,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154915,'TZ','Maneromango','Maneromango',-7.1988,38.7848,'P','PPL','TZ.02','TZ.02.0603',9402,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (154995,'TZ','Malya','Malya',-2.98333,33.5167,'P','PPL','TZ.12','TZ.12.1904',12627,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155016,'TZ','Malinyi','Malinyi',-8.93333,36.1333,'P','PPL','TZ.10','TZ.10.0504',27041,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155052,'TZ','Malangali','Malangali',-8.56667,34.85,'P','PPL','TZ.04','TZ.04.1102',7112,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155056,'TZ','Malampaka','Malampaka',-3.13333,33.5333,'P','PPL','TZ.31','TZ.31.2404',16916,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155076,'TZ','Makuyuni','Makuyuni',-4.73333,38.1,'P','PPL','TZ.18','TZ.18.0402',15516,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155093,'TZ','Makungu','Makungu',-8.73333,35.2833,'P','PPL','TZ.04','TZ.04.1102',10291,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155101,'TZ','Makumbako','Makumbako',-8.85,34.8333,'P','PPL','TZ.30','TZ.30.2206',53003,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155187,'TZ','Makanya','Makanya',-4.36667,37.8333,'P','PPL','TZ.06','TZ.06.0303',9505,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155244,'TZ','Majengo','Majengo',-5.15,38.9833,'P','PPL','TZ.18','TZ.18.0404',9874,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155263,'TZ','Mahonda','Mahonda',-6.45,39.4667,'P','PPL','TZ.21','TZ.21.5202',5569,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155274,'TZ','Mahenge','Mahenge',-8.68333,36.7167,'P','PPL','TZ.10','TZ.10.0504',7768,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155285,'TZ','Mahanje','Mahanje',-9.93333,35.3333,'P','PPL','TZ.14','TZ.14.1002',15009,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155307,'TZ','Kihangara','Kihangara',-2.58333,33.35,'P','PPL','TZ.12','TZ.12.1902',19082,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155310,'TZ','Magugu','Magugu',-4.01667,35.7667,'P','PPL','TZ.27','TZ.27.2101',26131,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155321,'TZ','Magomeni','Magomeni',-6.8,39.25,'P','PPLX','TZ.23','TZ.23.0701',19086,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155322,'TZ','Magomeni','Magomeni',-5.23333,38.1167,'P','PPL','TZ.18','TZ.18.0406',8944,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155334,'TZ','Magole','Magole',-6.37697,37.3737,'P','PPL','TZ.10','TZ.10.0501',18753,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155405,'TZ','Mafinga','Mafinga',-7.25,35.0667,'P','PPL','TZ.04','TZ.04.1101',34958,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155514,'TZ','Mabamba','Mabamba',-3.59833,30.5019,'P','PPL','TZ.05','TZ.05.1601',14140,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155515,'TZ','Mabama','Mabama',-5.13333,32.5333,'P','PPL','TZ.17','TZ.17.1403',15320,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155569,'TZ','Lushoto','Lushoto',-4.78333,38.2833,'P','PPL','TZ.18','TZ.18.0401',24197,'Africa/Dar_es_Salaam',1,'2017-08-27 23:00:00','2017-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155584,'TZ','Lupiro','Lupiro',-8.38333,36.6667,'P','PPL','TZ.10','TZ.10.0504',11430,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155743,'TZ','Lugoba','Lugoba',-6.45,38.3333,'P','PPL','TZ.02','TZ.02.0601',16902,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155848,'TZ','Longido','Longido',-2.73319,36.6977,'P','PPLA2','TZ.26','TZ.26.0207',9403,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (155921,'TZ','Liwale','Liwale',-9.76667,37.9333,'P','PPL','TZ.07','TZ.07.0804',19296,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156025,'TZ','Lembeni','Lembeni',-3.78333,37.6167,'P','PPL','TZ.06','TZ.06.0302',16008,'Africa/Dar_es_Salaam',1,'2016-10-06 23:00:00','2016-10-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156080,'TZ','Lalago','Lalago',-3.45,33.95,'P','PPL','TZ.31','TZ.31.2404',22551,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156098,'TZ','Laela','Laela',-8.56667,32.05,'P','PPL','TZ.24','TZ.24.1502',19185,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156111,'TZ','Kyela','Kyela',-9.58333,33.85,'P','PPL','TZ.09','TZ.09.1203',30684,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156124,'TZ','Kyaka','Kyaka',-1.25222,31.4203,'P','PPL','TZ.19','TZ.19.1807',13810,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156312,'TZ','Kwakoa','Kwakoa',-3.76667,37.7167,'P','PPL','TZ.06','TZ.06.0302',7514,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156493,'TZ','Kongwa','Kongwa',-6.2,36.4167,'P','PPL','TZ.03','TZ.03.0103',11840,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156510,'TZ','Kondoa','Kondoa',-4.9,35.7833,'P','PPL','TZ.03','TZ.03.0101',23518,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156513,'TZ','Konde','Konde',-4.95,39.75,'P','PPL','TZ.13','TZ.13.5402',9530,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156589,'TZ','Koani','Koani',-6.13333,39.2833,'P','PPLA','TZ.21','TZ.21.5201',2211,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156627,'TZ','Kiwira','Kiwira',-9.17307,33.5415,'P','PPL','TZ.09','TZ.09.1204',21342,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156918,'TZ','Kisiwani','Kisiwani',-4.13333,37.95,'P','PPL','TZ.06','TZ.06.0303',7126,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156963,'TZ','Kishapu','Kishapu',-3.61667,33.8667,'P','PPL','TZ.15','TZ.15.1702',16371,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156974,'TZ','Kisesa','Kisesa',-3.08333,34.15,'P','PPL','TZ.31','TZ.31.2403',29804,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (156996,'TZ','Kisarawe','Kisarawe',-6.9,39.0667,'P','PPL','TZ.02','TZ.02.0603',12507,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157014,'TZ','Kisanga','Kisanga',-7.43622,37.7034,'P','PPL','TZ.10','TZ.10.0502',10978,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157107,'TZ','Kirando','Kirando',-7.41667,30.6,'P','PPL','TZ.24','TZ.24.1503',33111,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157198,'TZ','Kiomboi','Kiomboi',-4.26667,34.3667,'P','PPL','TZ.16','TZ.16.1301',23519,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157247,'TZ','Kintinku','Kintinku',-5.88333,35.2333,'P','PPL','TZ.16','TZ.16.1303',7906,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157268,'TZ','Kingori','Kingori',-3.28333,36.9833,'P','PPL','TZ.26','TZ.26.0202',22839,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157366,'TZ','Kimamba','Kimamba',-6.78333,37.1333,'P','PPL','TZ.10','TZ.10.0501',11235,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157403,'TZ','Kilosa','Kilosa',-6.83333,36.9833,'P','PPL','TZ.10','TZ.10.0501',91889,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157429,'TZ','Kilindoni','Kilindoni',-7.91446,39.662,'P','PPL','TZ.02','TZ.02.0606',12409,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157448,'TZ','Kilimatinde','Kilimatinde',-5.85,34.95,'P','PPL','TZ.16','TZ.16.1303',5975,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157653,'TZ','Kihurio','Kihurio',-4.46667,38.0667,'P','PPL','TZ.06','TZ.06.0303',8377,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157738,'TZ','Kigoma','Kigoma',-4.87694,29.6267,'P','PPLA','TZ.05','TZ.05.1604',164268,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157826,'TZ','Kidodi','Kidodi',-7.60361,37.0044,'P','PPL','TZ.10','TZ.10.0501',35953,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157863,'TZ','Kidatu','Kidatu',-7.69916,36.9572,'P','PPL','TZ.10','TZ.10.0503',37542,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157960,'TZ','Kibondo','Kibondo',-3.58639,30.7203,'P','PPL','TZ.05','TZ.05.1601',28666,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (157977,'TZ','Kibiti','Kibiti',-7.72178,38.9375,'P','PPL','TZ.02','TZ.02.0605',30163,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158006,'TZ','Kibaya','Kibaya',-5.3,36.5667,'P','PPL','TZ.27','TZ.27.2105',5028,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158016,'TZ','Kibara','Kibara',-2.15,33.45,'P','PPL','TZ.08','TZ.08.2004',17211,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158024,'TZ','Kibakwe','Kibakwe',-6.71667,36.3667,'P','PPL','TZ.03','TZ.03.0102',19526,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158027,'TZ','Kibaha','Kibaha',-6.76667,38.9167,'P','PPLA','TZ.02','TZ.02.0607',23651,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158151,'TZ','Katumba','Katumba',-9.23333,33.6167,'P','PPL','TZ.09','TZ.09.1204',108558,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158160,'TZ','Katoro','Katoro',-3.02028,31.8958,'P','PPL','TZ.28','TZ.28.2505',49691,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158161,'TZ','Katoro','Katoro',-1.39972,31.5003,'P','PPL','TZ.19','TZ.19.1802',11925,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158179,'TZ','Katerero','Katerero',-1.4,31.7333,'P','PPL','TZ.19','TZ.19.1802',18430,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158214,'TZ','Kasulu','Kasulu',-4.57667,30.1025,'P','PPL','TZ.05','TZ.05.1608',37349,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158289,'TZ','Kasamwa','Kasamwa',-2.85,32.4333,'P','PPL','TZ.28','TZ.28.2501',27681,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158321,'TZ','Karema','Karema',-6.82052,30.4389,'P','PPL','TZ.29','TZ.29.2302',12630,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158324,'TZ','Kiratu','Kiratu',-3.33333,35.6667,'P','PPL','TZ.26','TZ.26.0204',19803,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158422,'TZ','Kandete','Kandete',-9.15,33.8,'P','PPL','TZ.09','TZ.09.1204',10318,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158492,'TZ','Kamachumu','Kamachumu',-1.61861,31.62,'P','PPL','TZ.19','TZ.19.1803',15701,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158514,'TZ','Kaliua','Kaliua',-5.06056,31.7936,'P','PPL','TZ.17','TZ.17.1407',12362,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158563,'TZ','Kakonko','Kakonko',-3.28278,30.9642,'P','PPL','TZ.05','TZ.05.1607',24688,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158597,'TZ','Kahama','Kahama',-3.83333,32.6,'P','PPL','TZ.15','TZ.15.1705',36014,'Africa/Dar_es_Salaam',1,'2017-06-16 23:00:00','2017-06-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158684,'TZ','Kabanga','Kabanga',-2.63861,30.4678,'P','PPL','TZ.19','TZ.19.1805',19421,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158825,'TZ','Izazi','Izazi',-7.2,35.7333,'P','PPL','TZ.04','TZ.04.1101',18010,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158876,'TZ','Itumba','Itumba',-9.4,33.1833,'P','PPL','TZ.09','TZ.09.1205',13438,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158904,'TZ','Itigi','Itigi',-5.7,34.4833,'P','PPL','TZ.16','TZ.16.1303',19711,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (158974,'TZ','Issenye','Issenye',-2,34.3333,'P','PPL','TZ.08','TZ.08.2002',7778,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159045,'TZ','Isaka','Isaka',-3.9,32.9333,'P','PPL','TZ.15','TZ.15.1704',21094,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159071,'TZ','Iringa','Iringa',-7.76667,35.7,'P','PPLA','TZ.04','TZ.04.1103',111820,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159107,'TZ','Ipinda','Ipinda',-9.48333,33.9,'P','PPL','TZ.09','TZ.09.1203',17775,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159134,'TZ','Inyonga','Inyonga',-6.71667,32.0667,'P','PPL','TZ.29','TZ.29.2303',11790,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159179,'TZ','Ilula','Ilula',-7.6766,36.0366,'P','PPL','TZ.04','TZ.04.1104',29193,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159186,'TZ','Ilongero','Ilongero',-4.66667,34.8667,'P','PPL','TZ.16','TZ.16.1302',17342,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159218,'TZ','Ilembula','Ilembula',-8.9,34.5833,'P','PPL','TZ.30','TZ.30.2202',18870,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159242,'TZ','Ikwiriri','Ikwiriri',-7.95618,38.9716,'P','PPL','TZ.02','TZ.02.0605',13071,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159267,'TZ','Ikungi','Ikungi',-5.13333,34.7667,'P','PPL','TZ.16','TZ.16.1305',19692,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159380,'TZ','Igurusi','Igurusi',-8.85,33.85,'P','PPL','TZ.09',NULL,24895,'Africa/Dar_es_Salaam',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159382,'TZ','Igurubi','Igurubi',-4,33.7,'P','PPL','TZ.17','TZ.17.1402',10083,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159386,'TZ','Igunga','Igunga',-4.28333,33.8833,'P','PPL','TZ.17','TZ.17.1402',35644,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159398,'TZ','Igugunu','Igugunu',-4.56667,34.6333,'P','PPL','TZ.16','TZ.16.1306',22810,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159492,'TZ','Ifakara','Ifakara',-8.13333,36.6833,'P','PPL','TZ.10','TZ.10.0503',49528,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159647,'TZ','Hedaru','Hedaru',-4.5,37.9,'P','PPL','TZ.06','TZ.06.0303',20231,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159908,'TZ','Geita','Geita',-2.86667,32.1667,'P','PPLA','TZ.28','TZ.28.2501',40000,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159909,'TZ','Geiro','Geiro',-6.15,36.8667,'P','PPL','TZ.10','TZ.10.0507',37909,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (159951,'TZ','Galappo','Galappo',-4.26667,35.85,'P','PPL','TZ.27','TZ.27.2101',18528,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160073,'TZ','Endasak','Endasak',-4.41667,35.5167,'P','PPL','TZ.27','TZ.27.2102',14576,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160141,'TZ','Dunda','Dunda',-8.11667,34.25,'P','PPL','TZ.09','TZ.09.1207',14080,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160172,'TZ','Dongobesh','Dongobesh',-4.06667,35.3833,'P','PPL','TZ.27','TZ.27.2103',18864,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160196,'TZ','Dodoma','Dodoma',-6.17221,35.7395,'P','PPLC','TZ.03','TZ.03.0105',180541,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160263,'TZ','Dar es Salaam','Dar es Salaam',-6.82349,39.2695,'P','PPLA','TZ.23','TZ.23.0702',2698652,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160266,'TZ','Dareda','Dareda',-4.21667,35.55,'P','PPL','TZ.27','TZ.27.2101',19876,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160464,'TZ','Chimala','Chimala',-8.85637,34.0239,'P','PPL','TZ.09','TZ.09.1207',24817,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160552,'TZ','Chato','Chato',-2.63778,31.7669,'P','PPL','TZ.28','TZ.28.2505',27776,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160592,'TZ','Chanika','Chanika',-5.41667,38.0167,'P','PPL','TZ.18','TZ.18.0410',30905,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160660,'TZ','Chalinze','Chalinze',-6.63784,38.354,'P','PPL','TZ.02','TZ.02.0601',34335,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160670,'TZ','Chala','Chala',-7.58333,31.2667,'P','PPL','TZ.24','TZ.24.1503',22624,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160677,'TZ','Chake Chake','Chake Chake',-5.24586,39.7666,'P','PPLA','TZ.20','TZ.20.5501',21686,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160798,'TZ','Butiama','Butiama',-1.76667,33.9667,'P','PPL','TZ.08','TZ.08.2007',16376,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160833,'TZ','Buseresere','Buseresere',-3.02361,31.8747,'P','PPL','TZ.28','TZ.28.2505',52870,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160877,'TZ','Bungu','Bungu',-7.63369,39.0582,'P','PPL','TZ.02','TZ.02.0605',27873,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160892,'TZ','Bunda','Bunda',-2.05,33.8667,'P','PPL','TZ.08','TZ.08.2004',50944,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160961,'TZ','Bukoba','Bukoba',-1.33167,31.8122,'P','PPLA','TZ.19','TZ.19.1806',70628,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (160971,'TZ','Bukene','Bukene',-4.23333,32.8833,'P','PPL','TZ.17','TZ.17.1401',7444,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (161022,'TZ','Bugene','Bugene',-1.59111,31.1403,'P','PPL','TZ.19','TZ.19.1801',10609,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (161023,'TZ','Bugarama','Bugarama',-2.87056,30.5281,'P','PPL','TZ.19','TZ.19.1805',32494,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (161154,'TZ','Biharamulo','Biharamulo',-2.63194,31.3089,'P','PPL','TZ.19','TZ.19.1804',34038,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (161197,'TZ','Basotu','Basotu',-4.36667,35.0833,'P','PPL','TZ.27','TZ.27.2102',20937,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (161204,'TZ','Bashanet','Bashanet',-4.23333,35.4167,'P','PPL','TZ.27','TZ.27.2101',19087,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (161218,'TZ','Bariadi','Bariadi',-2.8,33.9833,'P','PPLA3','TZ.31','TZ.31.2401',33865,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (161290,'TZ','Bagamoyo','Bagamoyo',-6.44222,38.9042,'P','PPL','TZ.02','TZ.02.0601',82426,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (161312,'TZ','Babati','Babati',-4.21667,35.75,'P','PPLA','TZ.27','TZ.27.2106',34291,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (161325,'TZ','Arusha','Arusha',-3.36667,36.6833,'P','PPLA','TZ.26','TZ.26.0203',341136,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877384,'TZ','Tingi','Tingi',-11.3,35.0333,'P','PPL','TZ.14','TZ.14.1006',16315,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877391,'TZ','Tandahimba','Tandahimba',-10.75,39.6333,'P','PPL','TZ.11','TZ.11.0904',17041,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877401,'TZ','Songea','Songea',-10.6833,35.65,'P','PPLA','TZ.14','TZ.14.1004',126449,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877433,'TZ','Ruangwa','Ruangwa',-10.0667,38.9333,'P','PPL','TZ.07','TZ.07.0805',11095,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877471,'TZ','Nyangao','Nyangao',-10.3333,39.2833,'P','PPL','TZ.07','TZ.07.0802',16343,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877532,'TZ','Newala Kisimani','Newala Kisimani',-10.95,39.2833,'P','PPL','TZ.11','TZ.11.0902',38099,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877581,'TZ','Nanyamba','Nanyamba',-10.6833,39.8333,'P','PPL','TZ.11','TZ.11.0901',19555,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877588,'TZ','Nanhyanga','Nanhyanga',-10.8,39.55,'P','PPL','TZ.11','TZ.11.0904',13519,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877597,'TZ','Nangomba','Nangomba',-10.9,38.5,'P','PPL','TZ.11','TZ.11.0906',23028,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877605,'TZ','Nanganga','Nanganga',-10.3833,39.15,'P','PPL','TZ.11',NULL,17468,'Africa/Dar_es_Salaam',1,'2011-03-05 23:00:00','2011-03-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877631,'TZ','Namikupa','Namikupa',-10.8333,39.6,'P','PPL','TZ.11','TZ.11.0904',11733,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877670,'TZ','Namalenga','Namalenga',-10.95,39.1,'P','PPL','TZ.11','TZ.11.0903',11204,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877702,'TZ','Nachingwea','Nachingwea',-10.3725,38.7625,'P','PPL','TZ.07','TZ.07.0803',18058,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877747,'TZ','Mtwara','Mtwara',-10.2667,40.1833,'P','PPLA','TZ.11','TZ.11.0905',96602,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877784,'TZ','Mtama','Mtama',-10.3,39.3667,'P','PPL','TZ.07','TZ.07.0802',11928,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877925,'TZ','Mingoyo','Mingoyo',-10.1053,39.6186,'P','PPL','TZ.07','TZ.07.0806',10480,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (877998,'TZ','Mbinga','Mbinga',-10.9333,35.0167,'P','PPL','TZ.14','TZ.14.1003',25192,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878006,'TZ','Mbekenyera','Mbekenyera',-10,38.9833,'P','PPL','TZ.07','TZ.07.0805',11794,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878023,'TZ','Mbamba Bay','Mbamba Bay',-11.2833,34.7667,'P','PPL','TZ.14',NULL,8997,'Africa/Dar_es_Salaam',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878041,'TZ','Matiri','Matiri',-10.75,34.9,'P','PPL','TZ.14','TZ.14.1003',18830,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878054,'TZ','Masuguru','Masuguru',-11.3667,38.4167,'P','PPL','TZ.11','TZ.11.0906',7946,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878058,'TZ','Masasi','Masasi',-10.7167,38.8,'P','PPL','TZ.11','TZ.11.0907',36032,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878073,'TZ','Maposeni','Maposeni',-10.5833,35.4,'P','PPL','TZ.14','TZ.14.1002',19472,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878087,'TZ','Manda','Manda',-10.4667,34.5833,'P','PPL','TZ.30',NULL,8393,'Africa/Dar_es_Salaam',1,'2013-04-02 23:00:00','2013-04-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878121,'TZ','Mahuta','Mahuta',-10.8667,39.45,'P','PPL','TZ.11','TZ.11.0904',13548,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878141,'TZ','Madimba','Madimba',-10.4,40.3333,'P','PPL','TZ.11','TZ.11.0901',12507,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878184,'TZ','Lulindi','Lulindi',-10.8167,39.1333,'P','PPL','TZ.11','TZ.11.0903',7807,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878195,'TZ','Lukuledi','Lukuledi',-10.5667,38.8,'P','PPL','TZ.11','TZ.11.0903',29699,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878223,'TZ','Luchingu','Luchingu',-10.9,39.3333,'P','PPL','TZ.11','TZ.11.0902',25145,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878242,'TZ','Liuli','Liuli',-11.0833,34.6333,'P','PPL','TZ.14',NULL,13119,'Africa/Dar_es_Salaam',1,'2013-04-02 23:00:00','2013-04-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878281,'TZ','Lindi','Lindi',-9.99709,39.7165,'P','PPLA','TZ.07','TZ.07.0806',41912,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878362,'TZ','Kitangari','Kitangari',-10.65,39.3333,'P','PPL','TZ.11','TZ.11.0902',10956,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878367,'TZ','Kitama','Kitama',-10.7167,39.7333,'P','PPL','TZ.11','TZ.11.0901',16232,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878400,'TZ','Kigonsera','Kigonsera',-10.8,35.05,'P','PPL','TZ.14','TZ.14.1003',22155,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (878455,'TZ','Chiungutwa','Chiungutwa',-10.8833,38.9833,'P','PPL','TZ.11','TZ.11.0903',12764,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6640202,'TZ','Merelani','Merelani',-3.56182,36.979,'P','PPL','TZ.26',NULL,50000,'Africa/Dar_es_Salaam',1,'2008-02-02 23:00:00','2008-02-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7284275,'TZ','Nungwi','Nungwi',-5.72651,39.2987,'P','PPL','TZ.22','TZ.22.5101',8000,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (9063978,'TZ','Kisasa','Kisasa',-6.17526,35.7927,'P','PPL','TZ.03','TZ.03.0105',10000,'Africa/Dar_es_Salaam',1,'2016-07-25 23:00:00','2016-07-25 23:00:00');


