--
-- Host: localhost    Database: laraclassified
-- ------------------------------------------------------


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

INSERT INTO `<<prefix>>subadmin1` VALUES (467,'CA.01','CA','Alberta','Alberta',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (468,'CA.02','CA','British Columbia','British Columbia',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (469,'CA.03','CA','Manitoba','Manitoba',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (470,'CA.04','CA','New Brunswick','New Brunswick',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (471,'CA.13','CA','Northwest Territories','Northwest Territories',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (472,'CA.07','CA','Nova Scotia','Nova Scotia',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (473,'CA.14','CA','Nunavut','Nunavut',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (474,'CA.08','CA','Ontario','Ontario',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (475,'CA.09','CA','Prince Edward Island','Prince Edward Island',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (476,'CA.10','CA','Quebec','Quebec',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (477,'CA.11','CA','Saskatchewan','Saskatchewan',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (478,'CA.12','CA','Yukon','Yukon',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (479,'CA.05','CA','Newfoundland and Labrador','Newfoundland and Labrador',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (8479,'CA.10.08','CA','CA.10','Abitibi-Témiscamingue','Abitibi-Temiscamingue',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8480,'CA.04.1306','CA','CA.04','Albert County','Albert County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8481,'CA.03.5883398','CA','CA.03','Alexander','Alexander',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8482,'CA.08.3557','CA','CA.08','Algoma','Algoma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8483,'CA.03.5884145','CA','CA.03','Alonsa','Alonsa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8484,'CA.07.1205','CA','CA.07','Annapolis County','Annapolis County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8485,'CA.07.1214','CA','CA.07','Antigonish County','Antigonish County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8486,'CA.03.5886869','CA','CA.03','Argyle','Argyle',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8487,'CA.03.5887047','CA','CA.03','Armstrong','Armstrong',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8488,'CA.01.4810016','CA','CA.01','Beaver County','Beaver County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8489,'CA.01.4819049','CA','CA.01','Birch Hills County','Birch Hills County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8490,'CA.08.3529','CA','CA.08','Brant','Brant',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8491,'CA.01.4811032','CA','CA.01','Brazeau County','Brazeau County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8492,'CA.03.5909350','CA','CA.03','Brokenhead','Brokenhead',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8493,'CA.08.3541','CA','CA.08','Bruce County','Bruce County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8494,'CA.07.5915565','CA','CA.07','Cape Breton County','Cape Breton County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8495,'CA.02.5917','CA','CA.02','Capital Regional District','Capital Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8496,'CA.01.4803001','CA','CA.01','Cardston County','Cardston County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8497,'CA.02.5941','CA','CA.02','Cariboo Regional District','Cariboo Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8498,'CA.04.1311','CA','CA.04','Carleton County','Carleton County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8499,'CA.03.5917773','CA','CA.03','Cartier','Cartier',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8500,'CA.02.5945','CA','CA.02','Central Coast Regional District','Central Coast Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8501,'CA.04.1302','CA','CA.04','Charlotte County','Charlotte County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8502,'CA.08.3536','CA','CA.08','Chatham-Kent','Chatham-Kent',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8503,'CA.01.4809002','CA','CA.01','Clearwater County','Clearwater County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8504,'CA.08.3556','CA','CA.08','Cochrane District','Cochrane District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8505,'CA.07.1210','CA','CA.07','Colchester','Colchester',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8506,'CA.03.5925083','CA','CA.03','Coldwell','Coldwell',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8507,'CA.02.5939','CA','CA.02','Columbia-Shuswap Regional District','Columbia-Shuswap Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8508,'CA.03.5928075','CA','CA.03','Cornwallis','Cornwallis',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8509,'CA.10.09','CA','CA.10','Côte-Nord','Cote-Nord',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8510,'CA.01.4813044','CA','CA.01','County of Athabasca No. 12','County of Athabasca No. 12',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8511,'CA.01.4813018','CA','CA.01','County of Barrhead No. 11','County of Barrhead No. 11',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8512,'CA.01.4810001','CA','CA.01','County of Camrose No. 22','County of Camrose No. 22',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8513,'CA.01.4801008','CA','CA.01','County of Forty Mile No. 8','County of Forty Mile No. 8',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8514,'CA.01.4819006','CA','CA.01','County of Grande Prairie No. 1','County of Grande Prairie No. 1',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8515,'CA.01.4802011','CA','CA.01','County of Lethbridge No. 26','County of Lethbridge No. 26',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8516,'CA.01.4810026','CA','CA.01','County of Minburn No. 27','County of Minburn No. 27',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8517,'CA.01.4802031','CA','CA.01','County of Newell No. 4','County of Newell No. 4',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8518,'CA.01.4807011','CA','CA.01','County of Paintearth No. 18','County of Paintearth No. 18',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8519,'CA.01.4807019','CA','CA.01','County of Stettler No. 6','County of Stettler No. 6',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8520,'CA.01.4812014','CA','CA.01','County of St. Paul No. 19','County of St. Paul No. 19',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8521,'CA.01.4813036','CA','CA.01','County of Thorhild No. 7','County of Thorhild No. 7',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8522,'CA.01.4810048','CA','CA.01','County of Two Hills No. 21','County of Two Hills No. 21',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8523,'CA.01.4810036','CA','CA.01','County of Vermilion River No. 24','County of Vermilion River No. 24',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8524,'CA.01.4802001','CA','CA.01','County of Warner No. 5','County of Warner No. 5',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8525,'CA.01.4811001','CA','CA.01','County of Wetaskiwin No. 10','County of Wetaskiwin No. 10',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8526,'CA.02.5919','CA','CA.02','Cowichan Valley Regional District','Cowichan Valley Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8527,'CA.07.1211','CA','CA.07','Cumberland County','Cumberland County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8528,'CA.01.4801003','CA','CA.01','Cypress County','Cypress County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8529,'CA.03.5935342','CA','CA.03','Dauphin','Dauphin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8530,'CA.03.5938127','CA','CA.03','De Salaberry','De Salaberry',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8531,'CA.07.5939237','CA','CA.07','Digby County','Digby County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8532,'CA.08.3522','CA','CA.08','Dufferin County','Dufferin County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8533,'CA.03.5943543','CA','CA.03','Dufferin','Dufferin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8534,'CA.08.3518','CA','CA.08','Durham','Durham',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8535,'CA.03.5946153','CA','CA.03','East St. Paul','East St. Paul',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8536,'CA.08.3534','CA','CA.08','Elgin County','Elgin County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8537,'CA.03.5948173','CA','CA.03','Elton','Elton',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8538,'CA.08.3537','CA','CA.08','Essex County','Essex County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8539,'CA.10.05','CA','CA.10','Estrie','Estrie',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8540,'CA.03.5953379','CA','CA.03','Fisher','Fisher',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8541,'CA.01.4807031','CA','CA.01','Flagstaff County','Flagstaff County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8542,'CA.02.5909','CA','CA.02','Fraser Valley Regional District','Fraser Valley Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8543,'CA.08.3510','CA','CA.08','Frontenac County','Frontenac County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8544,'CA.03.5961416','CA','CA.03','Gimli','Gimli',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8545,'CA.03.5964094','CA','CA.03','Grahamdale','Grahamdale',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8546,'CA.02.5915','CA','CA.02','Greater Vancouver Regional District','Greater Vancouver Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8547,'CA.08.3542','CA','CA.08','Grey County','Grey County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8548,'CA.03.5966926','CA','CA.03','Grey','Grey',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8549,'CA.07.5968620','CA','CA.07','Guysborough County','Guysborough County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8550,'CA.08.3528','CA','CA.08','Haldimand County','Haldimand County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8551,'CA.08.3546','CA','CA.08','Haliburton County','Haliburton County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8552,'CA.07.5969424','CA','CA.07','Halifax County','Halifax County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8553,'CA.08.3524','CA','CA.08','Halton','Halton',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8554,'CA.08.3525','CA','CA.08','Hamilton','Hamilton',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8555,'CA.03.5970302','CA','CA.03','Hanover','Hanover',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8556,'CA.08.3512','CA','CA.08','Hastings County','Hastings County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8557,'CA.03.5972962','CA','CA.03','Headingley','Headingley',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8558,'CA.08.3540','CA','CA.08','Huron County','Huron County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8559,'CA.01.4815037','CA','CA.01','Improvement District No. 12','Improvement District No. 12',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8560,'CA.01.4810068','CA','CA.01','Improvement District No. 13','Improvement District No. 13',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8561,'CA.01.4816051','CA','CA.01','Improvement District No. 24','Improvement District No. 24',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8562,'CA.01.4814028','CA','CA.01','Improvement District No. 25','Improvement District No. 25',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8563,'CA.01.4803003','CA','CA.01','Improvement District No. 4','Improvement District No. 4',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8564,'CA.01.4815032','CA','CA.01','Improvement District No. 9','Improvement District No. 9',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8565,'CA.07.1215','CA','CA.07','Inverness County','Inverness County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8566,'CA.01.4815033','CA','CA.01','Jasper','Jasper',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8567,'CA.01.4815013','CA','CA.01','Kananaskis Improvement District','Kananaskis Improvement District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8568,'CA.08.3516','CA','CA.08','Kawartha Lakes','Kawartha Lakes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8569,'CA.03.5990627','CA','CA.03','Kelsey','Kelsey',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8570,'CA.08.3560','CA','CA.08','Kenora District','Kenora District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8571,'CA.04.1308','CA','CA.04','Kent County','Kent County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8572,'CA.09.1101','CA','CA.09','Kings County','Kings County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8573,'CA.07.1207','CA','CA.07','Kings County','Kings County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8574,'CA.04.1305','CA','CA.04','Kings County','Kings County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8575,'CA.01.4805041','CA','CA.01','Kneehill County','Kneehill County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8576,'CA.03.6014442','CA','CA.03','Lac du Bonnet','Lac du Bonnet',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8577,'CA.01.4808022','CA','CA.01','Lacombe County','Lacombe County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8578,'CA.01.4813001','CA','CA.01','Lac Ste. Anne County','Lac Ste. Anne County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8579,'CA.08.3538','CA','CA.08','Lambton County','Lambton County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8580,'CA.01.4810058','CA','CA.01','Lamont County','Lamont County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8581,'CA.08.3509','CA','CA.08','Lanark County','Lanark County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8582,'CA.10.14','CA','CA.10','Lanaudière','Lanaudiere',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8583,'CA.10.15','CA','CA.10','Laurentides','Laurentides',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8584,'CA.10.13','CA','CA.10','Laval','Laval',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8585,'CA.01.4811012','CA','CA.01','Leduc County','Leduc County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8586,'CA.08.3511','CA','CA.08','Lennox and Addington County','Lennox and Addington County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8587,'CA.07.6062070','CA','CA.07','Lunenburg County','Lunenburg County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8588,'CA.03.6062676','CA','CA.03','Macdonald','Macdonald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8589,'CA.08.3551','CA','CA.08','Manitoulin District','Manitoulin District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8590,'CA.10.04','CA','CA.10','Mauricie','Mauricie',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8591,'CA.08.3539','CA','CA.08','Middlesex County','Middlesex County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8592,'CA.10.6074643','CA','CA.10','Minganie','Minganie',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8593,'CA.03.6076808','CA','CA.03','Montcalm','Montcalm',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8594,'CA.10.16','CA','CA.10','Montérégie','Monteregie',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8595,'CA.10.06','CA','CA.10','Montréal','Montreal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8596,'CA.03.6078726','CA','CA.03','Morris','Morris',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8597,'CA.03.6079284','CA','CA.03','Mossey River','Mossey River',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8598,'CA.01.4806028','CA','CA.01','Mountain View County','Mountain View County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8599,'CA.01.4804001','CA','CA.01','Municipal District of Acadia No. 34','Municipal District of Acadia No. 34',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8600,'CA.01.4815015','CA','CA.01','Municipal District of Bighorn No. 8','Municipal District of Bighorn No. 8',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8601,'CA.01.4817027','CA','CA.01','Municipal District of Big Lakes No. 125','Municipal District of Big Lakes No. 125',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8602,'CA.01.4812004','CA','CA.01','Municipal District of Bonnyville No. 87','Municipal District of Bonnyville No. 87',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8603,'CA.01.4817062','CA','CA.01','Municipal District of Clear Hills No. 21','Municipal District of Clear Hills No. 21',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8604,'CA.01.4819066','CA','CA.01','Municipal District of Fairview No. 136','Municipal District of Fairview No. 136',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8605,'CA.01.4806001','CA','CA.01','Municipal District of Foothills No. 31','Municipal District of Foothills No. 31',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8606,'CA.01.4818015','CA','CA.01','Municipal District of Greenview No. 16','Municipal District of Greenview No. 16',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8607,'CA.01.4817033','CA','CA.01','Municipal District of Lesser Slave River No. 124','Municipal District of Lesser Slave River No. 124',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8608,'CA.01.4817076','CA','CA.01','Municipal District of Northern Lights No. 22','Municipal District of Northern Lights No. 22',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8609,'CA.01.4817031','CA','CA.01','Municipal District of Opportunity No. 17','Municipal District of Opportunity No. 17',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8610,'CA.01.4819071','CA','CA.01','Municipal District of Peace No. 135','Municipal District of Peace No. 135',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8611,'CA.01.4803011','CA','CA.01','Municipal District of Pincher Creek No. 9','Municipal District of Pincher Creek No. 9',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8612,'CA.01.4807001','CA','CA.01','Municipal District of Provost No. 52','Municipal District of Provost No. 52',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8613,'CA.01.4815045','CA','CA.01','Municipal District of Ranchland No. 66','Municipal District of Ranchland No. 66',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8614,'CA.01.4806014','CA','CA.01','Municipal District of Rocky View No. 44','Municipal District of Rocky View No. 44',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8615,'CA.01.4819041','CA','CA.01','Municipal District of Smoky River No. 130','Municipal District of Smoky River No. 130',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8616,'CA.01.4819054','CA','CA.01','Municipal District of Spirit River No. 133','Municipal District of Spirit River No. 133',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8617,'CA.01.4802021','CA','CA.01','Municipal District of Taber','Municipal District of Taber',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8618,'CA.01.4807049','CA','CA.01','Municipal District of Wainwright No. 61','Municipal District of Wainwright No. 61',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8619,'CA.01.4813028','CA','CA.01','Municipal District of Westlock No. 92','Municipal District of Westlock No. 92',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8620,'CA.01.4803018','CA','CA.01','Municipal District of Willow Creek No. 26','Municipal District of Willow Creek No. 26',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8621,'CA.08.3544','CA','CA.08','District Municipality of Muskoka','District Municipality of Muskoka',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8622,'CA.08.3526','CA','CA.08','Regional Municipality of Niagara','Regional Municipality of Niagara',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8623,'CA.08.3548','CA','CA.08','Nipissing District','Nipissing District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8624,'CA.01.4817026','CA','CA.01','Northern Sunrise County','Northern Sunrise County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8625,'CA.04.1309','CA','CA.04','Northumberland County','Northumberland County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8626,'CA.08.3514','CA','CA.08','Northumberland County','Northumberland County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8627,'CA.10.07','CA','CA.10','Outaouais','Outaouais',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8628,'CA.08.3532','CA','CA.08','Oxford County','Oxford County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8629,'CA.01.4811034','CA','CA.01','Parkland County','Parkland County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8630,'CA.08.3549','CA','CA.08','Parry Sound District','Parry Sound District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8631,'CA.02.5955','CA','CA.02','Peace River Regional District','Peace River Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8632,'CA.08.3521','CA','CA.08','Peel','Peel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8633,'CA.08.3531','CA','CA.08','Perth County','Perth County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8634,'CA.08.3515','CA','CA.08','Peterborough County','Peterborough County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8635,'CA.07.1212','CA','CA.07','Pictou County','Pictou County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8636,'CA.03.6105291','CA','CA.03','Piney','Piney',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8637,'CA.03.6105529','CA','CA.03','Pipestone','Pipestone',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8638,'CA.01.4808038','CA','CA.01','Ponoka County','Ponoka County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8639,'CA.03.6111530','CA','CA.03','Portage la Prairie','Portage la Prairie',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8640,'CA.02.5927','CA','CA.02','Powell River Regional District','Powell River Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8641,'CA.09.1103','CA','CA.09','Prince County','Prince County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8642,'CA.08.3513','CA','CA.08','Prince Edward County','Prince Edward County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8643,'CA.09.1102','CA','CA.09','Queens County','Queens County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8644,'CA.07.6115099','CA','CA.07','Queens County','Queens County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8645,'CA.04.1304','CA','CA.04','Queens County','Queens County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8646,'CA.08.3559','CA','CA.08','Rainy River District','Rainy River District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8647,'CA.01.4808001','CA','CA.01','Red Deer County','Red Deer County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8648,'CA.02.5923','CA','CA.02','Regional District of Alberni-Clayoquot','Regional District of Alberni-Clayoquot',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8649,'CA.02.5951','CA','CA.02','Regional District of Bulkley-Nechako','Regional District of Bulkley-Nechako',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8650,'CA.02.5903','CA','CA.02','Regional District of Central Kootenay','Regional District of Central Kootenay',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8651,'CA.02.5935','CA','CA.02','Regional District of Central Okanagan','Regional District of Central Okanagan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8652,'CA.02.5901','CA','CA.02','Regional District of East Kootenay','Regional District of East Kootenay',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8653,'CA.02.5953','CA','CA.02','Regional District of Fraser-Fort George','Regional District of Fraser-Fort George',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8654,'CA.02.5949','CA','CA.02','Regional District of Kitimat-Stikine','Regional District of Kitimat-Stikine',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8655,'CA.02.5905','CA','CA.02','Regional District of Kootenay-Boundary','Regional District of Kootenay-Boundary',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8656,'CA.02.5943','CA','CA.02','Regional District of Mount Waddington','Regional District of Mount Waddington',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8657,'CA.02.5921','CA','CA.02','Regional District of Nanaimo','Regional District of Nanaimo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8658,'CA.02.5937','CA','CA.02','Regional District of North Okanagan','Regional District of North Okanagan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8659,'CA.02.5907','CA','CA.02','Regional District of Okanagan-Similkameen','Regional District of Okanagan-Similkameen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8660,'CA.08.3547','CA','CA.08','Renfrew County','Renfrew County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8661,'CA.03.6121677','CA','CA.03','Reynolds','Reynolds',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8662,'CA.07.1216','CA','CA.07','Richmond County','Richmond County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8663,'CA.03.6122576','CA','CA.03','Ritchot','Ritchot',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8664,'CA.03.6126541','CA','CA.03','Rockwood','Rockwood',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8665,'CA.03.6127181','CA','CA.03','Roland','Roland',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8666,'CA.03.6127585','CA','CA.03','Rosedale','Rosedale',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8667,'CA.01.4819059','CA','CA.01','Saddle Hills County','Saddle Hills County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8668,'CA.10.02','CA','CA.10','Saguenay/Lac-Saint-Jean','Saguenay/Lac-Saint-Jean',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8669,'CA.04.1301','CA','CA.04','Saint John County','Saint John County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8670,'CA.07.6145888','CA','CA.07','Shelburne County','Shelburne County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8671,'CA.03.6147482','CA','CA.03','Sifton','Sifton',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8672,'CA.08.3543','CA','CA.08','Simcoe County','Simcoe County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8673,'CA.02.5947','CA','CA.02','Skeena-Queen Charlotte Regional District','Skeena-Queen Charlotte Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8674,'CA.01.4812022','CA','CA.01','Smoky Lake County','Smoky Lake County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8675,'CA.01.4804004','CA','CA.01','Special Area No. 2','Special Area No. 2',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8676,'CA.01.4804012','CA','CA.01','Special Area No. 3','Special Area No. 3',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8677,'CA.01.4804020','CA','CA.01','Special Area No. 4','Special Area No. 4',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8678,'CA.01.4817095','CA','CA.01','Mackenzie County','Mackenzie County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8679,'CA.03.6154185','CA','CA.03','Springfield','Springfield',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8680,'CA.02.5931','CA','CA.02','Squamish-Lillooet Regional District','Squamish-Lillooet Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8681,'CA.03.6155131','CA','CA.03','St. Andrews','St. Andrews',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8682,'CA.03.6155186','CA','CA.03','Stanley','Stanley',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8683,'CA.01.4805031','CA','CA.01','Starland County','Starland County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8684,'CA.03.6155764','CA','CA.03','St. Clements','St. Clements',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8685,'CA.03.6155865','CA','CA.03','Ste. Anne','Ste. Anne',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8686,'CA.03.6156971','CA','CA.03','St. Laurent','St. Laurent',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8687,'CA.01.4811052','CA','CA.01','Strathcona County','Strathcona County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8688,'CA.03.6158376','CA','CA.03','Stuartburn','Stuartburn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8689,'CA.01.4811059','CA','CA.01','Sturgeon County','Sturgeon County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8690,'CA.08.3552','CA','CA.08','Sudbury','Sudbury',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8691,'CA.08.3553','CA','CA.08','Sudbury','Sudbury',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8692,'CA.04.1303','CA','CA.04','Sunbury County','Sunbury County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8693,'CA.02.5929','CA','CA.02','Sunshine Coast Regional District','Sunshine Coast Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8694,'CA.03.6165405','CA','CA.03','Thompson','Thompson',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8695,'CA.02.5933','CA','CA.02','Thompson-Nicola Regional District','Thompson-Nicola Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8696,'CA.08.3558','CA','CA.08','Thunder Bay District','Thunder Bay District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8697,'CA.08.3554','CA','CA.08','Timiskaming District','Timiskaming District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8698,'CA.08.3507','CA','CA.08','United Counties of Leeds and Grenville','United Counties of Leeds and Grenville',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8699,'CA.08.3502','CA','CA.08','Comtés unis de Prescott et Russell','Comtes unis de Prescott et Russell',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8700,'CA.08.3501','CA','CA.08','United Counties of Stormont, Dundas and Glengarry','United Counties of Stormont, Dundas and Glengarry',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8701,'CA.07.1218','CA','CA.07','Victoria County','Victoria County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8702,'CA.03.6174040','CA','CA.03','Victoria','Victoria',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8703,'CA.01.4805001','CA','CA.01','Vulcan County','Vulcan County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8704,'CA.08.3530','CA','CA.08','Regional Municipality of Waterloo','Regional Municipality of Waterloo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8705,'CA.08.3523','CA','CA.08','Wellington County','Wellington County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8706,'CA.04.1307','CA','CA.04','Westmorland County','Westmorland County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8707,'CA.03.6179507','CA','CA.03','West St. Paul','West St. Paul',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8708,'CA.01.4805012','CA','CA.01','Wheatland County','Wheatland County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8709,'CA.03.6180469','CA','CA.03','Whitehead','Whitehead',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8710,'CA.03.6180732','CA','CA.03','Whitemouth','Whitemouth',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8711,'CA.01.4816037','CA','CA.01','Wood Buffalo','Wood Buffalo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8712,'CA.03.6184198','CA','CA.03','Woodlands','Woodlands',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8713,'CA.01.4813029','CA','CA.01','Woodlands County','Woodlands County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8714,'CA.07.6185218','CA','CA.07','Yarmouth County','Yarmouth County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8715,'CA.01.4814003','CA','CA.01','Yellowhead County','Yellowhead County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8716,'CA.04.1310','CA','CA.04','York County','York County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8717,'CA.08.3519','CA','CA.08','York','York',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8718,'CA.10.01','CA','CA.10','Bas-Saint-Laurent','Bas-Saint-Laurent',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8719,'CA.10.03','CA','CA.10','Capitale-Nationale','Capitale-Nationale',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8720,'CA.10.10','CA','CA.10','Nord-du-Québec','Nord-du-Quebec',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8721,'CA.10.11','CA','CA.10','Gaspésie-Îles-de-la-Madeleine','Gaspesie-Iles-de-la-Madeleine',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8722,'CA.10.12','CA','CA.10','Chaudière-Appalaches','Chaudiere-Appalaches',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8723,'CA.04.1314','CA','CA.04','Restigouche','Restigouche',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8724,'CA.08.3520','CA','CA.08','Toronto county','Toronto county',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8725,'CA.10.17','CA','CA.10','Centre-du-Québec','Centre-du-Quebec',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8726,'CA.08.3506','CA','CA.08','Ottawa','Ottawa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8727,'CA.02.5926','CA','CA.02','Comox Valley Regional District','Comox Valley Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8728,'CA.02.5959','CA','CA.02','Northern Rockies Regional Municipality','Northern Rockies Regional Municipality',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8729,'CA.02.5957','CA','CA.02','Stikine Region','Stikine Region',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8730,'CA.02.5924','CA','CA.02','Strathcona Regional District','Strathcona Regional District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8731,'CA.04.1315','CA','CA.04','Gloucester County','Gloucester County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8732,'CA.04.1313','CA','CA.04','Madawaska County','Madawaska County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8733,'CA.04.1312','CA','CA.04','Victoria County','Victoria County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8734,'CA.03.11153049','CA','CA.03','Rural Municipality of Yellowhead','Rural Municipality of Yellowhead',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8735,'CA.01.4812037','CA','CA.01','Lac la Biche County','Lac la Biche County',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8736,'CA.01.4815007','CA','CA.01','Crowsnest Pass','Crowsnest Pass',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8737,'CA.01.4806016','CA','CA.01','Calgary','Calgary',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8738,'CA.01.4811061','CA','CA.01','Edmonton','Edmonton',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8739,'CA.01.4801006','CA','CA.01','Medicine Hat','Medicine Hat',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8740,'CA.01.4802012','CA','CA.01','Lethbridge','Lethbridge',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8741,'CA.01.4811007','CA','CA.01','Norris Beach','Norris Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8742,'CA.01.4811062','CA','CA.01','St. Albert','St. Albert',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8743,'CA.01.4803021','CA','CA.01','Granum','Granum',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8744,'CA.01.4813031','CA','CA.01','Westlock','Westlock',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8745,'CA.01.4814024','CA','CA.01','Edson','Edson',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8746,'CA.01.4813046','CA','CA.01','Boyle','Boyle',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8747,'CA.01.4806021','CA','CA.01','Airdrie','Airdrie',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8748,'CA.01.4802019','CA','CA.01','Coaldale','Coaldale',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8749,'CA.01.4813014','CA','CA.01','Onoway','Onoway',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8750,'CA.01.4806022','CA','CA.01','Irricana','Irricana',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8751,'CA.01.4806026','CA','CA.01','Crossfield','Crossfield',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8752,'CA.01.4812016','CA','CA.01','Elk Point','Elk Point',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8753,'CA.01.4810039','CA','CA.01','Lloydminster (Part)','Lloydminster (Part)',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8754,'CA.01.4807004','CA','CA.01','Czar','Czar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8755,'CA.01.4810011','CA','CA.01','Camrose','Camrose',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8756,'CA.01.4808031','CA','CA.01','Lacombe','Lacombe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8757,'CA.01.4811016','CA','CA.01','Leduc','Leduc',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8758,'CA.01.4811049','CA','CA.01','Spruce Grove','Spruce Grove',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8759,'CA.01.4802034','CA','CA.01','Brooks','Brooks',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8760,'CA.01.4806034','CA','CA.01','Olds','Olds',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8761,'CA.01.4812018','CA','CA.01','St. Paul','St. Paul',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8762,'CA.01.4810022','CA','CA.01','Viking','Viking',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8763,'CA.01.4811056','CA','CA.01','Fort Saskatchewan','Fort Saskatchewan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8764,'CA.01.4819012','CA','CA.01','Grande Prairie','Grande Prairie',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8765,'CA.01.4802029','CA','CA.01','Vauxhall','Vauxhall',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8766,'CA.01.4808011','CA','CA.01','Red Deer','Red Deer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8767,'CA.01.4811011','CA','CA.01','Millet','Millet',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8768,'CA.01.4806017','CA','CA.01','Chestermere','Chestermere',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8769,'CA.01.4811002','CA','CA.01','Wetaskiwin','Wetaskiwin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8770,'CA.01.4811013','CA','CA.01','Beaumont','Beaumont',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8771,'CA.01.4805049','CA','CA.01','Trochu','Trochu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8772,'CA.01.4803016','CA','CA.01','Cowley','Cowley',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8773,'CA.01.4812002','CA','CA.01','Cold Lake','Cold Lake',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8774,'CA.01.4813002','CA','CA.01','Mayerthorpe','Mayerthorpe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8775,'CA.01.4817024','CA','CA.01','Swan Hills','Swan Hills',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8776,'CA.01.4805048','CA','CA.01','Three Hills','Three Hills',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8777,'CA.01.4810028','CA','CA.01','Vegreville','Vegreville',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8778,'CA.01.4807012','CA','CA.01','Coronation','Coronation',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8779,'CA.01.4811065','CA','CA.01','Redwater','Redwater',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8780,'CA.01.4811066','CA','CA.01','Bon Accord','Bon Accord',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8781,'CA.01.4810052','CA','CA.01','Two Hills','Two Hills',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8782,'CA.01.4819046','CA','CA.01','Falher','Falher',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8783,'CA.01.4802018','CA','CA.01','Picture Butte','Picture Butte',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8784,'CA.01.4815023','CA','CA.01','Canmore','Canmore',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8785,'CA.01.4811048','CA','CA.01','Stony Plain','Stony Plain',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8786,'CA.01.4803026','CA','CA.01','Nanton','Nanton',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8787,'CA.01.4808012','CA','CA.01','Sylvan Lake','Sylvan Lake',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8788,'CA.01.4808024','CA','CA.01','Eckville','Eckville',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8789,'CA.01.4808026','CA','CA.01','Bentley','Bentley',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8790,'CA.01.4808029','CA','CA.01','Blackfalds','Blackfalds',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8791,'CA.01.4814019','CA','CA.01','Hinton','Hinton',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8792,'CA.01.4803024','CA','CA.01','Stavely','Stavely',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8793,'CA.01.4806032','CA','CA.01','Didsbury','Didsbury',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8794,'CA.01.4813015','CA','CA.01','South View','South View',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8795,'CA.01.4803019','CA','CA.01','Fort Macleod','Fort Macleod',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8796,'CA.01.4803022','CA','CA.01','Claresholm','Claresholm',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8797,'CA.01.4806029','CA','CA.01','Carstairs','Carstairs',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8798,'CA.01.4811064','CA','CA.01','Gibbons','Gibbons',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8799,'CA.01.4807026','CA','CA.01','Stettler','Stettler',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8800,'CA.01.4804014','CA','CA.01','Oyen','Oyen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8801,'CA.01.4801014','CA','CA.01','Bow Island','Bow Island',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8802,'CA.01.4805018','CA','CA.01','Strathmore','Strathmore',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8803,'CA.01.4813019','CA','CA.01','Barrhead','Barrhead',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8804,'CA.01.4813033','CA','CA.01','Larkspur','Larkspur',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8805,'CA.01.4801018','CA','CA.01','Redcliff','Redcliff',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8806,'CA.01.4802013','CA','CA.01','Coalhurst','Coalhurst',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8807,'CA.01.4810019','CA','CA.01','Ryley','Ryley',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8808,'CA.01.4810018','CA','CA.01','Tofield','Tofield',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8809,'CA.01.4819009','CA','CA.01','Beaverlodge','Beaverlodge',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8810,'CA.01.4806019','CA','CA.01','Cochrane','Cochrane',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8811,'CA.01.4805034','CA','CA.01','Delia','Delia',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8812,'CA.01.4805006','CA','CA.01','Vulcan','Vulcan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8813,'CA.01.4807002','CA','CA.01','Provost','Provost',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8814,'CA.01.4805036','CA','CA.01','Munson','Munson',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8815,'CA.01.4810066','CA','CA.01','Bruderheim','Bruderheim',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8816,'CA.01.4802036','CA','CA.01','Duchess','Duchess',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8817,'CA.01.4810056','CA','CA.01','Willingdon','Willingdon',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8818,'CA.01.4807014','CA','CA.01','Castor','Castor',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8819,'CA.01.4819011','CA','CA.01','Wembley','Wembley',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8820,'CA.01.4805026','CA','CA.01','Drumheller','Drumheller',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8821,'CA.01.4812029','CA','CA.01','Smoky Lake','Smoky Lake',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8822,'CA.01.4810002','CA','CA.01','Bashaw','Bashaw',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8823,'CA.01.4805038','CA','CA.01','Morrin','Morrin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8824,'CA.01.4811018','CA','CA.01','Devon','Devon',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8825,'CA.01.4811019','CA','CA.01','Calmar','Calmar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8826,'CA.01.4802004','CA','CA.01','Milk River','Milk River',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8827,'CA.01.4811031','CA','CA.01','Drayton Valley','Drayton Valley',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8828,'CA.01.4810042','CA','CA.01','Vermilion','Vermilion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8829,'CA.01.4807016','CA','CA.01','Halkirk','Halkirk',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8830,'CA.01.4808044','CA','CA.01','Rimbey','Rimbey',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8831,'CA.01.4813030','CA','CA.01','Whitecourt','Whitecourt',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8832,'CA.01.4802008','CA','CA.01','Raymond','Raymond',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8833,'CA.01.4818018','CA','CA.01','Valleyview','Valleyview',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8834,'CA.01.4810061','CA','CA.01','Mundare','Mundare',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8835,'CA.01.4810064','CA','CA.01','Lamont','Lamont',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8836,'CA.01.4808042','CA','CA.01','Parkland Beach','Parkland Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8837,'CA.01.4802022','CA','CA.01','Taber','Taber',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8838,'CA.01.4808039','CA','CA.01','Ponoka','Ponoka',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8839,'CA.01.4807021','CA','CA.01','Big Valley','Big Valley',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8840,'CA.01.4811068','CA','CA.01','Morinville','Morinville',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8841,'CA.01.4811069','CA','CA.01','Legal','Legal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8842,'CA.01.4817021','CA','CA.01','High Prairie','High Prairie',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8843,'CA.01.4806031','CA','CA.01','Cremona','Cremona',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8844,'CA.01.4815035','CA','CA.01','Banff','Banff',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8845,'CA.01.4818002','CA','CA.01','Fox Creek','Fox Creek',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8846,'CA.01.4818005','CA','CA.01','Grande Cache','Grande Cache',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8847,'CA.01.4813048','CA','CA.01','Athabasca','Athabasca',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8848,'CA.01.4817029','CA','CA.01','Slave Lake','Slave Lake',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8849,'CA.01.4817078','CA','CA.01','Manning','Manning',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8850,'CA.01.4817093','CA','CA.01','High Level','High Level',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8851,'CA.01.4817097','CA','CA.01','Rainbow Lake','Rainbow Lake',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8852,'CA.01.4819014','CA','CA.01','Sexsmith','Sexsmith',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8853,'CA.01.4819068','CA','CA.01','Fairview','Fairview',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8854,'CA.01.4819074','CA','CA.01','Grimshaw','Grimshaw',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8855,'CA.01.4808006','CA','CA.01','Bowden','Bowden',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8856,'CA.01.4804011','CA','CA.01','Hanna','Hanna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8857,'CA.01.4811024','CA','CA.01','Warburg','Warburg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8858,'CA.01.4806036','CA','CA.01','Sundre','Sundre',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8859,'CA.01.4819038','CA','CA.01','Peace River','Peace River',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8860,'CA.01.4819042','CA','CA.01','McLennan','McLennan',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8861,'CA.01.4819058','CA','CA.01','Spirit River','Spirit River',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8862,'CA.01.4805011','CA','CA.01','Arrowwood','Arrowwood',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8863,'CA.01.4808008','CA','CA.01','Innisfail','Innisfail',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8864,'CA.01.4808009','CA','CA.01','Penhold','Penhold',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8865,'CA.01.4806006','CA','CA.01','High River','High River',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8866,'CA.01.4812009','CA','CA.01','Bonnyville','Bonnyville',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8867,'CA.01.4803004','CA','CA.01','Cardston','Cardston',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8868,'CA.01.4803014','CA','CA.01','Pincher Creek','Pincher Creek',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8869,'CA.01.4802039','CA','CA.01','Bassano','Bassano',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8870,'CA.01.4803002','CA','CA.01','Magrath','Magrath',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8871,'CA.01.4806009','CA','CA.01','Turner Valley','Turner Valley',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8872,'CA.01.4806011','CA','CA.01','Black Diamond','Black Diamond',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8873,'CA.01.4808028','CA','CA.01','Gull Lake','Gull Lake',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8874,'CA.01.4813011','CA','CA.01','Sunset Point','Sunset Point',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8875,'CA.01.4806012','CA','CA.01','Okotoks','Okotoks',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8876,'CA.01.4807044','CA','CA.01','Sedgewick','Sedgewick',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8877,'CA.01.4813003','CA','CA.01','Nakamun Park','Nakamun Park',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8878,'CA.01.4813010','CA','CA.01','Silver Sands','Silver Sands',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8879,'CA.01.4812011','CA','CA.01','Bonnyville Beach','Bonnyville Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8880,'CA.01.4813057','CA','CA.01','West Baptiste','West Baptiste',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8881,'CA.01.4809015','CA','CA.01','Rocky Mountain House','Rocky Mountain House',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8882,'CA.01.4807039','CA','CA.01','Daysland','Daysland',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8883,'CA.01.4807042','CA','CA.01','Killam','Killam',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8884,'CA.01.4811003','CA','CA.01','Argentia Beach','Argentia Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8885,'CA.01.4807048','CA','CA.01','Hardisty','Hardisty',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8886,'CA.01.4807054','CA','CA.01','Wainwright','Wainwright',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8887,'CA.01.4813008','CA','CA.01','Ross Haven','Ross Haven',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8888,'CA.01.4813061','CA','CA.01','Whispering Hills','Whispering Hills',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8889,'CA.01.4813009','CA','CA.01','Castle Island','Castle Island',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8890,'CA.01.4808027','CA','CA.01','Sunbreaker Cove','Sunbreaker Cove',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8891,'CA.01.4807028','CA','CA.01','Rochon Sands','Rochon Sands',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8892,'CA.01.4811008','CA','CA.01','Ma-Me-O Beach','Ma-Me-O Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8893,'CA.01.4811009','CA','CA.01','Silver Beach','Silver Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8894,'CA.01.4813013','CA','CA.01','Birch Cove','Birch Cove',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8895,'CA.01.4812020','CA','CA.01','Horseshoe Bay','Horseshoe Bay',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8896,'CA.01.4811038','CA','CA.01','Seba Beach','Seba Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8897,'CA.01.4811039','CA','CA.01','Betula Beach','Betula Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8898,'CA.01.4802038','CA','CA.01','Rosemary','Rosemary',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8899,'CA.01.4811041','CA','CA.01','Point Alison','Point Alison',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8900,'CA.01.4807027','CA','CA.01','White Sands','White Sands',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8901,'CA.01.4815027','CA','CA.01','Ghost Lake','Ghost Lake',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8902,'CA.01.4808013','CA','CA.01','Norglenwold','Norglenwold',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8903,'CA.01.4808023','CA','CA.01','Birchcliff','Birchcliff',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8904,'CA.01.4808025','CA','CA.01','Half Moon Bay','Half Moon Bay',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8905,'CA.01.4813055','CA','CA.01','South Baptiste','South Baptiste',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8906,'CA.01.4813007','CA','CA.01','Yellowstone','Yellowstone',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8907,'CA.01.4813005','CA','CA.01','Val Quentin','Val Quentin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8908,'CA.01.4813006','CA','CA.01','West Cove','West Cove',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8909,'CA.01.4811042','CA','CA.01','Lakeview','Lakeview',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8910,'CA.01.4802014','CA','CA.01','Nobleford','Nobleford',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8911,'CA.01.4811044','CA','CA.01','Kapasiwin','Kapasiwin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8912,'CA.01.4813016','CA','CA.01','Sandy Beach','Sandy Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8913,'CA.01.4811023','CA','CA.01','Golden Days','Golden Days',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8914,'CA.01.4805002','CA','CA.01','Carmangay','Carmangay',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8915,'CA.01.4813017','CA','CA.01','Sunrise Beach','Sunrise Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8916,'CA.01.4811020','CA','CA.01','Sundance Beach','Sundance Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8917,'CA.01.4813045','CA','CA.01','Mewatha Beach','Mewatha Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8918,'CA.01.4811005','CA','CA.01','Poplar Bay','Poplar Bay',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8919,'CA.01.4811006','CA','CA.01','Crystal Springs','Crystal Springs',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8920,'CA.01.4811022','CA','CA.01','Itaska Beach','Itaska Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8921,'CA.01.4815030','CA','CA.01','Waiparous','Waiparous',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8922,'CA.01.4802002','CA','CA.01','Coutts','Coutts',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8923,'CA.01.4813047','CA','CA.01','Sunset Beach','Sunset Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8924,'CA.01.4813049','CA','CA.01','Island Lake','Island Lake',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8925,'CA.01.4813051','CA','CA.01','Island Lake South','Island Lake South',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8926,'CA.01.4813053','CA','CA.01','Bondiss','Bondiss',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8927,'CA.01.4807029','CA','CA.01','Donalda','Donalda',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8928,'CA.01.4808005','CA','CA.01','Jarvis Bay','Jarvis Bay',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8929,'CA.01.4812013','CA','CA.01','Pelican Narrows','Pelican Narrows',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8930,'CA.01.4811004','CA','CA.01','Grandview','Grandview',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8931,'CA.01.4809005','CA','CA.01','Burnstick Lake','Burnstick Lake',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8932,'CA.01.4805022','CA','CA.01','Rockyford','Rockyford',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8933,'CA.01.4805042','CA','CA.01','Carbon','Carbon',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8934,'CA.01.4805044','CA','CA.01','Acme','Acme',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8935,'CA.01.4805046','CA','CA.01','Linden','Linden',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8936,'CA.01.4807006','CA','CA.01','Hughenden','Hughenden',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8937,'CA.01.4812024','CA','CA.01','Vilna','Vilna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8938,'CA.01.4812026','CA','CA.01','Waskatenau','Waskatenau',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8939,'CA.01.4810051','CA','CA.01','Myrnam','Myrnam',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8940,'CA.01.4810009','CA','CA.01','Bawlf','Bawlf',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8941,'CA.01.4802016','CA','CA.01','Barons','Barons',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8942,'CA.01.4807046','CA','CA.01','Lougheed','Lougheed',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8943,'CA.01.4805019','CA','CA.01','Hussar','Hussar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8944,'CA.01.4813012','CA','CA.01','Alberta Beach','Alberta Beach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8945,'CA.01.4806024','CA','CA.01','Beiseker','Beiseker',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8946,'CA.01.4810031','CA','CA.01','Innisfree','Innisfree',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8947,'CA.01.4812012','CA','CA.01','Glendon','Glendon',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8948,'CA.01.4811045','CA','CA.01','Wabamun','Wabamun',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8949,'CA.01.4807008','CA','CA.01','Amisk','Amisk',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8950,'CA.01.4807032','CA','CA.01','Alliance','Alliance',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8951,'CA.01.4801009','CA','CA.01','Foremost','Foremost',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8952,'CA.01.4810034','CA','CA.01','Mannville','Mannville',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8953,'CA.01.4810038','CA','CA.01','Paradise Valley','Paradise Valley',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8954,'CA.01.4802009','CA','CA.01','Stirling','Stirling',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8955,'CA.01.4804016','CA','CA.01','Cereal','Cereal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8956,'CA.01.4804019','CA','CA.01','Youngstown','Youngstown',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8957,'CA.01.4804021','CA','CA.01','Veteran','Veteran',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8958,'CA.01.4804022','CA','CA.01','Consort','Consort',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8959,'CA.01.4805004','CA','CA.01','Champion','Champion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8960,'CA.01.4805021','CA','CA.01','Standard','Standard',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8961,'CA.01.4805008','CA','CA.01','Lomond','Lomond',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8962,'CA.01.4805009','CA','CA.01','Milo','Milo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8963,'CA.01.4807022','CA','CA.01','Gadsby','Gadsby',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8964,'CA.01.4807024','CA','CA.01','Botha','Botha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8965,'CA.01.4810003','CA','CA.01','Rosalind','Rosalind',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8966,'CA.01.4810004','CA','CA.01','Ferintosh','Ferintosh',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8967,'CA.01.4810006','CA','CA.01','Edberg','Edberg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8968,'CA.01.4810012','CA','CA.01','Bittern Lake','Bittern Lake',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8969,'CA.01.4810014','CA','CA.01','Hay Lakes','Hay Lakes',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8970,'CA.01.4811026','CA','CA.01','Breton','Breton',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8971,'CA.01.4802006','CA','CA.01','Warner','Warner',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8972,'CA.01.4811021','CA','CA.01','Thorsby','Thorsby',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8973,'CA.01.4808032','CA','CA.01','Clive','Clive',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8974,'CA.01.4802023','CA','CA.01','Barnwell','Barnwell',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8975,'CA.01.4808034','CA','CA.01','Alix','Alix',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8976,'CA.01.4810046','CA','CA.01','Dewberry','Dewberry',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8977,'CA.01.4810021','CA','CA.01','Holden','Holden',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8978,'CA.01.4810041','CA','CA.01','Kitscoty','Kitscoty',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8979,'CA.01.4810044','CA','CA.01','Marwayne','Marwayne',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8980,'CA.01.4811046','CA','CA.01','Spring Lake','Spring Lake',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8981,'CA.01.4810059','CA','CA.01','Andrew','Andrew',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8982,'CA.01.4810062','CA','CA.01','Chipman','Chipman',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8983,'CA.01.4813032','CA','CA.01','Clyde','Clyde',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8984,'CA.01.4819048','CA','CA.01','Girouxville','Girouxville',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8985,'CA.01.4819072','CA','CA.01','Berwyn','Berwyn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8986,'CA.01.4819008','CA','CA.01','Hythe','Hythe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8987,'CA.01.4819044','CA','CA.01','Donnelly','Donnelly',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8988,'CA.01.4819056','CA','CA.01','Rycroft','Rycroft',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8989,'CA.01.4808002','CA','CA.01','Elnora','Elnora',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8990,'CA.01.4808004','CA','CA.01','Delburne','Delburne',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8991,'CA.01.4804006','CA','CA.01','Empress','Empress',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8992,'CA.01.4817039','CA','CA.01','Nampa','Nampa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8993,'CA.01.4817064','CA','CA.01','Hines Creek','Hines Creek',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8994,'CA.01.4806008','CA','CA.01','Longview','Longview',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8995,'CA.01.4803006','CA','CA.01','Glenwood','Glenwood',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8996,'CA.01.4803008','CA','CA.01','Hill Spring','Hill Spring',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8997,'CA.01.4809010','CA','CA.01','Caroline','Caroline',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8998,'CA.01.4807036','CA','CA.01','Forestburg','Forestburg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8999,'CA.01.4807038','CA','CA.01','Heisler','Heisler',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9000,'CA.01.4807051','CA','CA.01','Chauvin','Chauvin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9001,'CA.01.4807052','CA','CA.01','Edgerton','Edgerton',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9002,'CA.01.4807056','CA','CA.01','Irma','Irma',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (9003,'CA.01.4812038','CA','CA.01','Improvement District No. 349','Improvement District No. 349',1);

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

INSERT INTO `<<prefix>>cities` VALUES (5881791,'CA','Abbotsford','Abbotsford',49.058,-122.253,'P','PPL','CA.02','CA.02.5957659',151683,'America/Vancouver',1,'2013-04-21 23:00:00','2013-04-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5882142,'CA','Acton Vale','Acton Vale',45.6501,-72.5658,'P','PPL','CA.10','CA.10.16',5135,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5882799,'CA','Airdrie','Airdrie',51.3001,-114.035,'P','PPL','CA.01',NULL,24673,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5882873,'CA','Ajax','Ajax',43.8501,-79.0329,'P','PPL','CA.08',NULL,90167,'America/Toronto',1,'2011-12-29 23:00:00','2011-12-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5884083,'CA','Alma','Alma',48.5501,-71.6491,'P','PPL','CA.10','CA.10.02',29526,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5884467,'CA','Amherst','Amherst',45.8335,-64.1987,'P','PPL','CA.07',NULL,9336,'America/Halifax',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5884473,'CA','Amherstburg','Amherstburg',42.1168,-83.0499,'P','PPL','CA.08',NULL,11459,'America/Toronto',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5884588,'CA','Amos','Amos',48.5669,-78.1162,'P','PPL','CA.10','CA.10.08',17918,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5885280,'CA','Angus','Angus',44.3168,-79.8829,'P','PPLL','CA.08',NULL,10269,'America/Toronto',1,'2006-01-26 23:00:00','2006-01-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5885383,'CA','Anmore','Anmore',49.3164,-122.853,'P','PPL','CA.02','CA.02.5915',126456,'America/Vancouver',1,'2013-08-27 23:00:00','2013-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5886182,'CA','Antigonish','Antigonish',45.6169,-61.9986,'P','PPL','CA.07',NULL,5003,'America/Halifax',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5887214,'CA','Arnprior','Arnprior',45.4334,-76.3494,'P','PPL','CA.08',NULL,9607,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5887470,'CA','Asbestos','Asbestos',45.7668,-71.9324,'P','PPL','CA.10','CA.10.05',7190,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5888716,'CA','Aylmer','Aylmer',42.7668,-80.983,'P','PPL','CA.08',NULL,7527,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5889745,'CA','Baie-Comeau','Baie-Comeau',49.2168,-68.1489,'P','PPL','CA.10','CA.10.09',29808,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5892532,'CA','Banff','Banff',51.1762,-115.57,'P','PPL','CA.01',NULL,7502,'America/Edmonton',1,'2010-06-23 23:00:00','2010-06-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5894171,'CA','Barrie','Barrie',44.4001,-79.6663,'P','PPL','CA.08',NULL,182041,'America/Toronto',1,'2013-09-21 23:00:00','2013-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5895424,'CA','Bay Roberts','Bay Roberts',47.5999,-53.2648,'P','PPL','CA.05',NULL,13737,'America/St_Johns',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5895650,'CA','Beaconsfield','Beaconsfield',45.4334,-73.8659,'P','PPL','CA.10','CA.10.06',19194,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5896495,'CA','Beauharnois','Beauharnois',45.3134,-73.8725,'P','PPL','CA.10','CA.10.16',11918,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5896522,'CA','Beaumont','Beaumont',53.3501,-113.419,'P','PPL','CA.01',NULL,7366,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5897209,'CA','Bécancour','Becancour',46.3334,-72.4324,'P','PPL','CA.10','CA.10.17',11134,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5897884,'CA','Belleville','Belleville',44.1668,-77.3828,'P','PPL','CA.08','CA.08.3512',49454,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5898070,'CA','Bells Corners','Bells Corners',45.3159,-75.8301,'P','PPL','CA.08',NULL,9977,'America/Toronto',1,'2010-03-17 23:00:00','2010-03-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5898138,'CA','Beloeil','Beloeil',45.5684,-73.2057,'P','PPL','CA.10','CA.10.16',18927,'America/Toronto',1,'2017-01-30 23:00:00','2017-01-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5901272,'CA','Binbrook','Binbrook',43.1213,-79.811,'P','PPLX','CA.08','CA.08.3525',8796,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5903510,'CA','Blainville','Blainville',45.6668,-73.8825,'P','PPL','CA.10','CA.10.15',46493,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5904501,'CA','Bluewater','Bluewater',43.4668,-81.5998,'P','PPL','CA.08',NULL,7044,'America/Toronto',1,'2013-05-04 23:00:00','2013-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5905132,'CA','Boisbriand','Boisbriand',45.6168,-73.8325,'P','PPL','CA.10','CA.10.15',26483,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5905152,'CA','Bois-des-Filion','Bois-des-Filion',45.6668,-73.7492,'P','PPL','CA.10','CA.10.13',8383,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5905616,'CA','Bonnyville','Bonnyville',54.2668,-110.735,'P','PPL','CA.01',NULL,6003,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5906267,'CA','Boucherville','Boucherville',45.591,-73.4361,'P','PPL','CA.10','CA.10.16',39062,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5907092,'CA','Bracebridge','Bracebridge',45.0334,-79.3163,'P','PPL','CA.08',NULL,8238,'America/Toronto',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5907364,'CA','Brampton','Brampton',43.6834,-79.7663,'P','PPL','CA.08',NULL,433806,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5907896,'CA','Brandon','Brandon',49.8469,-99.9531,'P','PPL','CA.03',NULL,26234,'America/Winnipeg',1,'2010-01-28 23:00:00','2010-01-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5907983,'CA','Brant','Brant',43.1334,-80.3497,'P','PPL','CA.08',NULL,34415,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5907990,'CA','Brantford','Brantford',43.1334,-80.2664,'P','PPL','CA.08',NULL,87759,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5908723,'CA','Bridgewater','Bridgewater',44.3786,-64.5188,'P','PPL','CA.07',NULL,8070,'America/Halifax',1,'2015-06-25 23:00:00','2015-06-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5909294,'CA','Brockville','Brockville',44.5913,-75.687,'P','PPL','CA.08',NULL,23886,'America/Toronto',1,'2013-05-15 23:00:00','2013-05-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5909403,'CA','Bromont','Bromont',45.3168,-72.6491,'P','PPL','CA.10','CA.10.16',6049,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5909514,'CA','Brooks','Brooks',50.5834,-111.885,'P','PPL','CA.01',NULL,12744,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5909629,'CA','Brossard','Brossard',45.4501,-73.4658,'P','PPL','CA.10','CA.10.16',69575,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5909969,'CA','Brownsburg-Chatham','Brownsburg-Chatham',45.6834,-74.4159,'P','PPL','CA.10','CA.10.15',6664,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5911592,'CA','Burlington','Burlington',43.3862,-79.8371,'P','PPL','CA.08',NULL,164415,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5911606,'CA','Burnaby','Burnaby',49.2664,-122.953,'P','PPL','CA.02',NULL,202799,'America/Vancouver',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5913490,'CA','Calgary','Calgary',51.0501,-114.085,'P','PPL','CA.01',NULL,1019942,'America/Edmonton',1,'2015-04-23 23:00:00','2015-04-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5913695,'CA','Cambridge','Cambridge',43.3601,-80.3127,'P','PPL','CA.08',NULL,120372,'America/Toronto',1,'2010-04-27 23:00:00','2010-04-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5913934,'CA','Camlachie','Camlachie',43.036,-82.1616,'P','PPL','CA.08',NULL,7506,'America/Toronto',1,'2011-11-26 23:00:00','2011-11-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5914132,'CA','Campbell River','Campbell River',50.0163,-125.245,'P','PPL','CA.02',NULL,33430,'America/Vancouver',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5914653,'CA','Camrose','Camrose',53.0168,-112.835,'P','PPL','CA.01',NULL,15686,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5914826,'CA','Candiac','Candiac',45.3834,-73.5159,'P','PPL','CA.10','CA.10.16',15947,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5914894,'CA','Canmore','Canmore',51.0834,-115.352,'P','PPL','CA.01',NULL,12288,'America/Edmonton',1,'2015-07-07 23:00:00','2015-07-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5916722,'CA','Carbonear','Carbonear',47.7332,-53.2148,'P','PPL','CA.05',NULL,6814,'America/St_Johns',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5917117,'CA','Carignan','Carignan',45.4501,-73.2992,'P','PPL','CA.10','CA.10.16',7426,'America/Toronto',1,'2016-04-12 23:00:00','2016-04-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5917158,'CA','Carleton Place','Carleton Place',45.1334,-76.1494,'P','PPL','CA.08',NULL,9743,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5918118,'CA','Castlegar','Castlegar',49.2998,-117.669,'P','PPL','CA.02',NULL,8715,'America/Vancouver',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5919566,'CA','Chambly','Chambly',45.4501,-73.2825,'P','PPL','CA.10','CA.10.16',22608,'America/Toronto',1,'2016-04-12 23:00:00','2016-04-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5920089,'CA','Charlemagne','Charlemagne',45.7168,-73.4825,'P','PPL','CA.10','CA.10.14',5594,'America/Toronto',1,'2010-09-22 23:00:00','2010-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5920288,'CA','Charlottetown','Charlottetown',46.239,-63.1341,'P','PPLA','CA.09','CA.09.1102',42402,'America/Halifax',1,'2016-04-01 23:00:00','2016-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5920433,'CA','Châteauguay','Chateauguay',45.3834,-73.7492,'P','PPL','CA.10','CA.10.16',42786,'America/Toronto',1,'2017-01-31 23:00:00','2017-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5920457,'CA','Chatham','Chatham',42.4122,-82.1849,'P','PPL','CA.08','CA.08.3536',43550,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5921147,'CA','Chibougamau','Chibougamau',49.9168,-74.3659,'P','PPL','CA.10','CA.10.10',7563,'America/Toronto',1,'2016-04-11 23:00:00','2016-04-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5921356,'CA','Chilliwack','Chilliwack',49.1664,-121.953,'P','PPLA2','CA.02','CA.02.5909',77000,'America/Vancouver',1,'2013-07-26 23:00:00','2013-07-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5923101,'CA','Clarence-Rockland','Clarence-Rockland',45.5501,-75.291,'P','PPL','CA.08',NULL,20790,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5924417,'CA','Coaldale','Coaldale',49.7167,-112.619,'P','PPL','CA.01',NULL,6317,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5924500,'CA','Coaticook','Coaticook',45.1334,-71.7991,'P','PPL','CA.10','CA.10.05',7021,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5924579,'CA','Cobourg','Cobourg',43.9598,-78.1652,'P','PPL','CA.08',NULL,18099,'America/Toronto',1,'2013-11-01 23:00:00','2013-11-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5924618,'CA','Cochrane','Cochrane',51.1834,-114.469,'P','PPL','CA.01',NULL,16365,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5925024,'CA','Cold Lake','Cold Lake',54.4652,-110.182,'P','PPL','CA.01',NULL,11595,'America/Edmonton',1,'2013-09-21 23:00:00','2013-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5925975,'CA','Collingwood','Collingwood',44.4834,-80.2164,'P','PPL','CA.08',NULL,15809,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5926268,'CA','Colwood','Colwood',48.4329,-123.486,'P','PPL','CA.02',NULL,14687,'America/Vancouver',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5926511,'CA','Conception Bay South','Conception Bay South',47.4999,-52.9981,'P','PPL','CA.05',NULL,17087,'America/St_Johns',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5926526,'CA','Concord','Concord',43.8001,-79.4829,'P','PPL','CA.08',NULL,8255,'America/Toronto',1,'2012-02-29 23:00:00','2012-02-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5927689,'CA','Coquitlam','Coquitlam',49.283,-122.753,'P','PPL','CA.02',NULL,114565,'America/Vancouver',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5927969,'CA','Corner Brook','Corner Brook',48.95,-57.952,'P','PPL','CA.05',NULL,18693,'America/St_Johns',1,'2013-08-09 23:00:00','2013-08-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5928065,'CA','Cornwall','Cornwall',45.0181,-74.7281,'P','PPL','CA.08',NULL,48821,'America/Toronto',1,'2009-07-30 23:00:00','2009-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5928488,'CA','Côte-Saint-Luc','Cote-Saint-Luc',45.4654,-73.6658,'P','PPL','CA.10','CA.10.06',31395,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5930890,'CA','Courtenay','Courtenay',49.6866,-124.994,'P','PPL','CA.02',NULL,32793,'America/Vancouver',1,'2013-10-26 23:00:00','2013-10-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5931074,'CA','Cowansville','Cowansville',45.2001,-72.7491,'P','PPL','CA.10','CA.10.16',10887,'America/Toronto',1,'2017-01-31 23:00:00','2017-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5931800,'CA','Cranbrook','Cranbrook',49.4999,-115.769,'P','PPL','CA.02',NULL,18610,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5935277,'CA','Dartmouth','Dartmouth',44.6713,-63.5772,'P','PPL','CA.07',NULL,101343,'America/Halifax',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5935341,'CA','Dauphin','Dauphin',51.1494,-100.05,'P','PPL','CA.03',NULL,8418,'America/Winnipeg',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5935804,'CA','Dawson Creek','Dawson Creek',55.7598,-120.24,'P','PPL','CA.02','CA.02.5955',10802,'America/Dawson_Creek',1,'2015-01-08 23:00:00','2015-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5937612,'CA','Delson','Delson',45.3668,-73.5492,'P','PPL','CA.10','CA.10.16',7322,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5937615,'CA','Delta','Delta',49.144,-122.907,'P','PPL','CA.02',NULL,101668,'America/Vancouver',1,'2010-02-26 23:00:00','2010-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5938513,'CA','Deux-Montagnes','Deux-Montagnes',45.5345,-73.9017,'P','PPL','CA.10','CA.10.15',17402,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5938801,'CA','Devon','Devon',53.3668,-113.735,'P','PPL','CA.01',NULL,5225,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5939219,'CA','Dieppe','Dieppe',46.0784,-64.6873,'P','PPL','CA.04',NULL,18565,'America/Moncton',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5940934,'CA','Dolbeau-Mistassini','Dolbeau-Mistassini',48.8786,-72.2314,'P','PPL','CA.10','CA.10.02',12916,'America/Toronto',1,'2016-02-23 23:00:00','2016-02-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5940956,'CA','Dollard-Des Ormeaux','Dollard-Des Ormeaux',45.4945,-73.8242,'P','PPL','CA.10',NULL,48930,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5941761,'CA','Dorchester','Dorchester',42.9834,-81.0664,'P','PPL','CA.08',NULL,9329,'America/Toronto',1,'2013-07-16 23:00:00','2013-07-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5941925,'CA','Dorval','Dorval',45.4473,-73.7533,'P','PPL','CA.10','CA.10.06',18088,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5942547,'CA','Drayton Valley','Drayton Valley',53.2168,-114.985,'P','PPL','CA.01',NULL,6099,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5942845,'CA','Drummondville','Drummondville',45.8834,-72.4824,'P','PPL','CA.10','CA.10.17',59489,'America/Toronto',1,'2016-04-11 23:00:00','2016-04-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5942913,'CA','Dryden','Dryden',49.7833,-92.7503,'P','PPL','CA.08',NULL,8195,'America/Winnipeg',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5943865,'CA','Duncan','Duncan',48.7829,-123.703,'P','PPL','CA.02',NULL,22199,'America/Vancouver',1,'2013-07-20 23:00:00','2013-07-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5946768,'CA','Edmonton','Edmonton',53.5501,-113.469,'P','PPLA','CA.01',NULL,712391,'America/Edmonton',1,'2010-07-23 23:00:00','2010-07-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5946820,'CA','Edson','Edson',53.5835,-116.436,'P','PPL','CA.01',NULL,7975,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5947866,'CA','Elliot Lake','Elliot Lake',46.3834,-82.6331,'P','PPL','CA.08',NULL,12508,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5949568,'CA','Estevan','Estevan',49.1334,-102.984,'P','PPL','CA.11',NULL,9904,'America/Regina',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5950267,'CA','Etobicoke','Etobicoke',43.6542,-79.5671,'P','PPL','CA.08',NULL,347948,'America/Toronto',1,'2012-02-21 23:00:00','2012-02-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5951289,'CA','Fall River','Fall River',44.8168,-63.6154,'P','PPL','CA.07',NULL,11526,'America/Halifax',1,'2017-11-25 23:00:00','2017-11-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5951644,'CA','Farnham','Farnham',45.2834,-72.9824,'P','PPL','CA.10','CA.10.16',6061,'America/Toronto',1,'2017-01-31 23:00:00','2017-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5952370,'CA','Fernie','Fernie',49.5,-115.069,'P','PPL','CA.02',NULL,5019,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5954718,'CA','Flin Flon','Flin Flon',54.767,-101.874,'P','PPL','CA.03',NULL,6002,'America/Winnipeg',1,'2016-04-22 23:00:00','2016-04-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5955815,'CA','Fort Erie','Fort Erie',42.9001,-78.9329,'P','PPL','CA.08',NULL,15953,'America/Toronto',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5955826,'CA','Fort Frances','Fort Frances',48.6167,-93.4003,'P','PPL','CA.08','CA.08.3559',7931,'America/Winnipeg',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5955895,'CA','Fort McMurray','Fort McMurray',56.7268,-111.381,'P','PPL','CA.01',NULL,76000,'America/Edmonton',1,'2011-10-07 23:00:00','2011-10-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5955948,'CA','Fort Saskatchewan','Fort Saskatchewan',53.7168,-113.219,'P','PPL','CA.01',NULL,14957,'America/Edmonton',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5955960,'CA','Fort St. John','Fort St. John',56.2499,-120.853,'P','PPL','CA.02',NULL,17402,'America/Dawson_Creek',1,'2013-10-05 23:00:00','2013-10-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5957776,'CA','Fredericton','Fredericton',45.9454,-66.6656,'P','PPLA','CA.04',NULL,52337,'America/Moncton',1,'2010-07-28 23:00:00','2010-07-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5959326,'CA','Gananoque','Gananoque',44.3334,-76.1661,'P','PPL','CA.08',NULL,5458,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5959878,'CA','Gaspé','Gaspe',48.8334,-64.4819,'P','PPL','CA.10','CA.10.11',14819,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5959974,'CA','Gatineau','Gatineau',45.4772,-75.7016,'P','PPL','CA.10','CA.10.07',242124,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5960971,'CA','Gibsons','Gibsons',49.3954,-123.506,'P','PPL','CA.02','CA.02.5929',6821,'America/Vancouver',1,'2013-09-22 23:00:00','2013-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5961564,'CA','Glace Bay','Glace Bay',46.1969,-59.957,'P','PPL','CA.07',NULL,19968,'America/Glace_Bay',1,'2008-08-27 23:00:00','2008-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5962442,'CA','Goderich','Goderich',43.7417,-81.7134,'P','PPL','CA.08','CA.08.3540',8032,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5964215,'CA','Granby','Granby',45.4001,-72.7324,'P','PPL','CA.10','CA.10.16',53979,'America/Toronto',1,'2017-01-31 23:00:00','2017-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5964347,'CA','Grande Prairie','Grande Prairie',55.1667,-118.803,'P','PPL','CA.01',NULL,41462,'America/Edmonton',1,'2016-04-16 23:00:00','2016-04-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5964378,'CA','Grand Falls-Windsor','Grand Falls-Windsor',48.9332,-55.6649,'P','PPL','CA.05',NULL,12076,'America/St_Johns',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5964700,'CA','Greater Sudbury','Greater Sudbury',46.49,-80.99,'P','PPL','CA.08',NULL,157857,'America/Toronto',1,'2014-05-11 23:00:00','2014-05-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5965546,'CA','Gravenhurst','Gravenhurst',44.9168,-79.3663,'P','PPL','CA.08',NULL,5839,'America/Toronto',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5965812,'CA','Greater Napanee','Greater Napanee',44.2501,-76.9494,'P','PPL','CA.08',NULL,15132,'America/Toronto',1,'2010-04-05 23:00:00','2010-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5966689,'CA','Greenwood','Greenwood',44.9741,-64.9317,'P','PPL','CA.07',NULL,6915,'America/Halifax',1,'2015-06-25 23:00:00','2015-06-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5967629,'CA','Guelph','Guelph',43.5459,-80.256,'P','PPL','CA.08','CA.08.3523',115760,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5969782,'CA','Hamilton','Hamilton',43.2501,-79.8496,'P','PPL','CA.08',NULL,519949,'America/Toronto',1,'2013-02-15 23:00:00','2013-02-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5970014,'CA','Hampstead','Hampstead',45.4806,-73.6631,'P','PPL','CA.10','CA.10.06',6996,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5970063,'CA','Hanceville','Hanceville',51.9192,-123.045,'P','PPLL','CA.02',NULL,10000,'America/Vancouver',1,'2013-05-04 23:00:00','2013-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5970301,'CA','Hanover','Hanover',44.1501,-81.033,'P','PPL','CA.08',NULL,7255,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5970458,'CA','Happy Valley-Goose Bay','Happy Valley-Goose Bay',53.3038,-60.3258,'P','PPL','CA.05',NULL,7572,'America/Goose_Bay',1,'2016-04-01 23:00:00','2016-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5972360,'CA','Hawkesbury','Hawkesbury',45.6001,-74.616,'P','PPL','CA.08',NULL,12283,'America/Toronto',1,'2016-05-04 23:00:00','2016-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5975038,'CA','High River','High River',50.5834,-113.869,'P','PPL','CA.01',NULL,9826,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5975503,'CA','Hinton','Hinton',53.4001,-117.586,'P','PPL','CA.01',NULL,9889,'America/Edmonton',1,'2013-09-21 23:00:00','2013-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5978126,'CA','Hudson','Hudson',45.4501,-74.1492,'P','PPL','CA.10','CA.10.16',5088,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5978765,'CA','Huntsville','Huntsville',45.3334,-79.2163,'P','PPL','CA.08',NULL,19579,'America/Toronto',1,'2009-05-18 23:00:00','2009-05-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5978831,'CA','Huron East','Huron East',43.6168,-81.2998,'P','PPL','CA.08',NULL,9264,'America/Toronto',1,'2013-05-04 23:00:00','2013-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5983175,'CA','Ingersoll','Ingersoll',43.0334,-80.883,'P','PPL','CA.08',NULL,11874,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5983433,'CA','Innisfil','Innisfil',44.3001,-79.6496,'P','PPL','CA.08',NULL,7345,'America/Toronto',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5983720,'CA','Iqaluit','Iqaluit',63.747,-68.5173,'P','PPLA','CA.14',NULL,6124,'America/Iqaluit',1,'2016-04-16 23:00:00','2016-04-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5987650,'CA','Joliette','Joliette',46.0164,-73.4236,'P','PPL','CA.10','CA.10.14',34772,'America/Toronto',1,'2016-06-19 23:00:00','2016-06-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5989045,'CA','Kamloops','Kamloops',50.6665,-120.319,'P','PPL','CA.02',NULL,68714,'America/Vancouver',1,'2010-01-28 23:00:00','2010-01-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5989403,'CA','Kapuskasing','Kapuskasing',49.4169,-82.4331,'P','PPL','CA.08','CA.08.3556',9240,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5990579,'CA','Kelowna','Kelowna',49.8831,-119.486,'P','PPL','CA.02',NULL,125109,'America/Vancouver',1,'2011-02-18 23:00:00','2011-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5991055,'CA','Kenora','Kenora',49.7674,-94.4899,'P','PPL','CA.08','CA.08.3560',15096,'America/Winnipeg',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5991148,'CA','Kentville','Kentville',45.0771,-64.496,'P','PPL','CA.07','CA.07.1207',12636,'America/Halifax',1,'2014-08-30 23:00:00','2014-08-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5991370,'CA','Keswick','Keswick',44.2501,-79.4663,'P','PPLX','CA.08',NULL,21000,'America/Toronto',1,'2010-08-22 23:00:00','2010-08-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5992059,'CA','Kimberley','Kimberley',49.6707,-115.978,'P','PPL','CA.02','CA.02.5901',6513,'America/Edmonton',1,'2014-02-07 23:00:00','2014-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5992144,'CA','Kincardine','Kincardine',44.1834,-81.6331,'P','PPL','CA.08',NULL,6725,'America/Toronto',1,'2015-11-08 23:00:00','2015-11-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5992500,'CA','Kingston','Kingston',44.2298,-76.481,'P','PPL','CA.08',NULL,114195,'America/Toronto',1,'2014-05-10 23:00:00','2014-05-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5992830,'CA','Kirkland','Kirkland',45.4501,-73.8659,'P','PPL','CA.10','CA.10.06',20491,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5992836,'CA','Kirkland Lake','Kirkland Lake',48.1446,-80.0377,'P','PPL','CA.08',NULL,7775,'America/Toronto',1,'2012-01-06 23:00:00','2012-01-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5992996,'CA','Kitchener','Kitchener',43.4254,-80.5112,'P','PPLA2','CA.08','CA.08.3530',233700,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5993072,'CA','Kitimat','Kitimat',54.0524,-128.653,'P','PPL','CA.02',NULL,8987,'America/Vancouver',1,'2010-05-26 23:00:00','2010-05-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (5994839,'CA','Labrador City','Labrador City',52.9463,-66.9114,'P','PPL','CA.05',NULL,10313,'America/Goose_Bay',1,'2008-09-16 23:00:00','2008-09-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6002133,'CA','Lac-Brome','Lac-Brome',45.2168,-72.5158,'P','PPL','CA.10','CA.10.16',5629,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6024829,'CA','Lachute','Lachute',45.6501,-74.3325,'P','PPL','CA.10','CA.10.15',9562,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6035615,'CA','Lacombe','Lacombe',52.4668,-113.735,'P','PPL','CA.01',NULL,10059,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6047817,'CA','Ladysmith','Ladysmith',48.9902,-123.817,'P','PPL','CA.02','CA.02.5919',8740,'America/Vancouver',1,'2014-02-07 23:00:00','2014-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6049024,'CA','Lambton Shores','Lambton Shores',43.1668,-81.9331,'P','PPL','CA.08',NULL,10656,'America/Toronto',1,'2013-05-04 23:00:00','2013-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6049388,'CA','Langford','Langford',48.4496,-123.503,'P','PPL','CA.02',NULL,22459,'America/Vancouver',1,'2014-02-07 23:00:00','2014-02-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6049429,'CA','Langley','Langley',49.1011,-122.659,'P','PPL','CA.02',NULL,23606,'America/Vancouver',1,'2013-05-31 23:00:00','2013-05-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6049430,'CA','Langley','Langley',49.083,-122.586,'P','PPL','CA.02',NULL,93726,'America/Vancouver',1,'2011-02-18 23:00:00','2011-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6049863,'CA','La Prairie','La Prairie',45.4168,-73.4992,'P','PPL','CA.10','CA.10.16',21763,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6050194,'CA','La Sarre','La Sarre',48.8002,-79.1996,'P','PPL','CA.10','CA.10.08',7206,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6050263,'CA','L\'Assomption','L\'Assomption',45.8232,-73.4294,'P','PPL','CA.10','CA.10.14',16738,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6050416,'CA','La Tuque','La Tuque',47.4334,-72.7824,'P','PPLX','CA.10','CA.10.04',9503,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6050610,'CA','Laval','Laval',45.57,-73.692,'P','PPL','CA.10','CA.10.13',376845,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6050650,'CA','Lavaltrie','Lavaltrie',45.8834,-73.2824,'P','PPL','CA.10','CA.10.14',8762,'America/Toronto',1,'2016-04-11 23:00:00','2016-04-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6051562,'CA','Leduc','Leduc',53.2668,-113.552,'P','PPL','CA.01',NULL,15561,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6052788,'CA','Les Coteaux','Les Coteaux',45.2834,-74.2325,'P','PPL','CA.10','CA.10.16',10622,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6053154,'CA','Lethbridge','Lethbridge',49.7,-112.819,'P','PPL','CA.01',NULL,70617,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6053877,'CA','L\'Île-Perrot','L\'Ile-Perrot',45.3834,-73.9492,'P','PPL','CA.10','CA.10.16',9927,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6058024,'CA','Lloydminster','Lloydminster',53.2835,-110.002,'P','PPL','CA.11',NULL,15910,'America/Edmonton',1,'2018-01-13 23:00:00','2018-01-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6058560,'CA','London','London',42.9834,-81.233,'P','PPL','CA.08',NULL,346765,'America/Toronto',1,'2012-08-18 23:00:00','2012-08-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6059891,'CA','Longueuil','Longueuil',45.5312,-73.5181,'P','PPL','CA.10','CA.10.16',229330,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6060407,'CA','Lorraine','Lorraine',45.6834,-73.7825,'P','PPL','CA.10','CA.10.14',9613,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6060839,'CA','Louiseville','Louiseville',46.2559,-72.9415,'P','PPL','CA.10','CA.10.04',5819,'America/Toronto',1,'2016-02-23 23:00:00','2016-02-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6062163,'CA','Lutes Mountain','Lutes Mountain',46.1354,-64.905,'P','PPL','CA.04',NULL,16311,'America/Moncton',1,'2016-06-28 23:00:00','2016-06-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6064180,'CA','Magog','Magog',45.2668,-72.1491,'P','PPL','CA.10','CA.10.05',15550,'America/Toronto',1,'2016-05-15 23:00:00','2016-05-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6065686,'CA','Maple Ridge','Maple Ridge',49.2194,-122.602,'P','PPL','CA.02',NULL,70000,'America/Vancouver',1,'2010-02-26 23:00:00','2010-02-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6066350,'CA','Marieville','Marieville',45.4334,-73.1658,'P','PPL','CA.10','CA.10.16',5600,'America/Toronto',1,'2016-04-12 23:00:00','2016-04-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6066513,'CA','Markham','Markham',43.8668,-79.2663,'P','PPL','CA.08',NULL,261573,'America/Toronto',1,'2011-12-29 23:00:00','2011-12-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6067494,'CA','Mascouche','Mascouche',45.7496,-73.5996,'P','PPL','CA.10','CA.10.14',34626,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6071618,'CA','Medicine Hat','Medicine Hat',50.0393,-110.677,'P','PPL','CA.01',NULL,63138,'America/Edmonton',1,'2016-04-01 23:00:00','2016-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6071876,'CA','Melfort','Melfort',52.8667,-104.618,'P','PPL','CA.11',NULL,5410,'America/Regina',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6072206,'CA','Mercier','Mercier',45.3168,-73.7492,'P','PPL','CA.10','CA.10.16',10121,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6072350,'CA','Merritt','Merritt',50.1123,-120.794,'P','PPL','CA.02',NULL,7179,'America/Vancouver',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6073363,'CA','Midland','Midland',44.7501,-79.883,'P','PPL','CA.08',NULL,31502,'America/Toronto',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6074377,'CA','Milton','Milton',43.5168,-79.8829,'P','PPLA2','CA.08','CA.08.3524',84362,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6075061,'CA','Mirabel','Mirabel',45.6501,-74.0825,'P','PPL','CA.10','CA.10.15',34626,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6075081,'CA','Miramichi','Miramichi',47.0289,-65.5019,'P','PPL','CA.04','CA.04.1309',18129,'America/Moncton',1,'2013-08-09 23:00:00','2013-08-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6075357,'CA','Mississauga','Mississauga',43.5789,-79.6583,'P','PPL','CA.08',NULL,668549,'America/Toronto',1,'2012-06-30 23:00:00','2012-06-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6076211,'CA','Moncton','Moncton',46.0945,-64.7965,'P','PPL','CA.04','CA.04.1307',87467,'America/Moncton',1,'2015-08-28 23:00:00','2015-08-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6077128,'CA','Mont-Laurier','Mont-Laurier',46.5501,-75.4993,'P','PPL','CA.10','CA.10.15',13405,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6077243,'CA','Montréal','Montreal',45.5088,-73.5878,'P','PPLA2','CA.10','CA.10.06',1600000,'America/Toronto',1,'2015-09-04 23:00:00','2015-09-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6077265,'CA','Montréal-Ouest','Montreal-Ouest',45.4529,-73.6492,'P','PPL','CA.10',NULL,5184,'America/Toronto',1,'2010-09-22 23:00:00','2010-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6077315,'CA','Mont-Royal','Mont-Royal',45.5168,-73.6492,'P','PPL','CA.10','CA.10.06',18933,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6077340,'CA','Mont-Saint-Hilaire','Mont-Saint-Hilaire',45.5652,-73.1868,'P','PPL','CA.10','CA.10.16',15720,'America/Toronto',1,'2017-01-30 23:00:00','2017-01-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6077445,'CA','Mont-Tremblant','Mont-Tremblant',46.2127,-74.5844,'P','PPL','CA.10','CA.10.15',8892,'America/Toronto',1,'2013-08-16 23:00:00','2013-08-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6078112,'CA','Moose Jaw','Moose Jaw',50.4001,-105.534,'P','PPL','CA.11',NULL,32166,'America/Regina',1,'2013-09-21 23:00:00','2013-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6078447,'CA','Morden','Morden',49.1919,-98.1014,'P','PPL','CA.03',NULL,6395,'America/Winnipeg',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6078636,'CA','Morinville','Morinville',53.8001,-113.652,'P','PPL','CA.01',NULL,8108,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6082231,'CA','Mount Pearl','Mount Pearl',47.5166,-52.7813,'P','PPL','CA.05',NULL,24671,'America/St_Johns',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6085772,'CA','Nanaimo','Nanaimo',49.1664,-123.94,'P','PPL','CA.02',NULL,84905,'America/Vancouver',1,'2013-06-22 23:00:00','2013-06-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6086871,'CA','Nelson','Nelson',49.4999,-117.286,'P','PPL','CA.02',NULL,9813,'America/Vancouver',1,'2012-02-19 23:00:00','2012-02-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6087029,'CA','Nepean','Nepean',45.3521,-75.7398,'P','PPL','CA.08',NULL,180000,'America/Toronto',1,'2017-11-13 23:00:00','2017-11-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6087579,'CA','New Glasgow','New Glasgow',45.5834,-62.6486,'P','PPL','CA.07',NULL,20322,'America/Halifax',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6087701,'CA','Newmarket','Newmarket',44.0501,-79.4663,'P','PPL','CA.08',NULL,74295,'America/Toronto',1,'2011-12-29 23:00:00','2011-12-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6087844,'CA','New Westminster','New Westminster',49.2068,-122.911,'P','PPL','CA.02',NULL,58549,'America/Vancouver',1,'2014-02-08 23:00:00','2014-02-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6087892,'CA','Niagara Falls','Niagara Falls',43.1001,-79.0663,'P','PPL','CA.08',NULL,82000,'America/Toronto',1,'2009-06-06 23:00:00','2009-06-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6088132,'CA','Nicolet','Nicolet',46.2168,-72.6158,'P','PPL','CA.10','CA.10.17',5257,'America/Toronto',1,'2016-02-22 23:00:00','2016-02-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6089125,'CA','Norfolk County','Norfolk County',42.8334,-80.383,'P','PPL','CA.08',NULL,60847,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6089404,'CA','North Battleford','North Battleford',52.7797,-108.297,'P','PPL','CA.11',NULL,19440,'America/Regina',1,'2013-10-05 23:00:00','2013-10-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6089426,'CA','North Bay','North Bay',46.3168,-79.4663,'P','PPL','CA.08','CA.08.3548',50170,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6089661,'CA','North Cowichan','North Cowichan',48.8413,-123.686,'P','PPL','CA.02',NULL,32272,'America/Vancouver',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6090405,'CA','North Perth','North Perth',43.7251,-80.9672,'P','PPL','CA.08',NULL,12254,'America/Toronto',1,'2013-05-04 23:00:00','2013-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6090579,'CA','North Saanich','North Saanich',48.6663,-123.419,'P','PPL','CA.02',NULL,11089,'America/Vancouver',1,'2013-05-04 23:00:00','2013-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6090785,'CA','North Vancouver','North Vancouver',49.3164,-123.069,'P','PPL','CA.02','CA.02.5909',48000,'America/Vancouver',1,'2013-08-27 23:00:00','2013-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6091104,'CA','North York','North York',43.7668,-79.4163,'P','PPL','CA.08',NULL,636000,'America/Toronto',1,'2011-12-06 23:00:00','2011-12-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6091314,'CA','Notre-Dame-de-Grâce','Notre-Dame-de-Grace',45.4767,-73.6143,'P','PPLX','CA.10','CA.10.06',67000,'America/Toronto',1,'2017-11-28 23:00:00','2017-11-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6091369,'CA','Notre-Dame-de-l\'Île-Perrot','Notre-Dame-de-l\'Ile-Perrot',45.3668,-73.9325,'P','PPL','CA.10','CA.10.16',9885,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6091422,'CA','Notre-Dame-des-Prairies','Notre-Dame-des-Prairies',46.0501,-73.4324,'P','PPL','CA.10','CA.10.14',8230,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6091919,'CA','Oak Bay','Oak Bay',48.4496,-123.303,'P','PPL','CA.02',NULL,18015,'America/Vancouver',1,'2013-05-04 23:00:00','2013-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6092122,'CA','Oakville','Oakville',43.4501,-79.6829,'P','PPL','CA.08',NULL,165697,'America/Toronto',1,'2012-01-14 23:00:00','2012-01-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6093010,'CA','Okotoks','Okotoks',50.7289,-113.983,'P','PPL','CA.01',NULL,14826,'America/Edmonton',1,'2009-03-24 23:00:00','2009-03-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6093347,'CA','Olds','Olds',51.7834,-114.102,'P','PPL','CA.01',NULL,6947,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6094201,'CA','Orangeville','Orangeville',43.9168,-80.0997,'P','PPL','CA.08',NULL,32640,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6094325,'CA','Orillia','Orillia',44.6087,-79.4207,'P','PPL','CA.08',NULL,30178,'America/Toronto',1,'2009-07-30 23:00:00','2009-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6094407,'CA','Oromocto','Oromocto',45.8351,-66.4792,'P','PPL','CA.04',NULL,8998,'America/Moncton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6094578,'CA','Oshawa','Oshawa',43.9001,-78.8496,'P','PPL','CA.08',NULL,247989,'America/Toronto',1,'2013-09-21 23:00:00','2013-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6094817,'CA','Ottawa','Ottawa',45.4112,-75.6981,'P','PPLC','CA.08',NULL,812129,'America/Toronto',1,'2016-01-19 23:00:00','2016-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6094884,'CA','Otterburn Park','Otterburn Park',45.5334,-73.2159,'P','PPL','CA.10','CA.10.16',8464,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6095645,'CA','Owen Sound','Owen Sound',44.5672,-80.9435,'P','PPL','CA.08',NULL,22625,'America/Toronto',1,'2009-07-30 23:00:00','2009-07-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6098642,'CA','Parksville','Parksville',49.3195,-124.316,'P','PPL','CA.02','CA.02.5921',12000,'America/Vancouver',1,'2016-08-31 23:00:00','2016-08-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6098747,'CA','Parry Sound','Parry Sound',45.3473,-80.0353,'P','PPL','CA.08','CA.08.3549',6469,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6100069,'CA','Peace River','Peace River',56.2371,-117.292,'P','PPL','CA.01',NULL,5340,'America/Edmonton',1,'2016-07-01 23:00:00','2016-07-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6100832,'CA','Pembroke','Pembroke',45.8168,-77.1162,'P','PPL','CA.08',NULL,15551,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6101141,'CA','Penticton','Penticton',49.4806,-119.586,'P','PPL','CA.02',NULL,37721,'America/Vancouver',1,'2017-12-23 23:00:00','2017-12-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6101546,'CA','Perth','Perth',44.9001,-76.2494,'P','PPL','CA.08',NULL,6481,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6101606,'CA','Petawawa','Petawawa',45.8945,-77.2801,'P','PPL','CA.08',NULL,15988,'America/Toronto',1,'2013-10-25 23:00:00','2013-10-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6101645,'CA','Peterborough','Peterborough',44.3001,-78.3162,'P','PPL','CA.08',NULL,75877,'America/Toronto',1,'2016-07-01 23:00:00','2016-07-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6103581,'CA','Petrolia','Petrolia',42.8668,-82.1498,'P','PPL','CA.08',NULL,5453,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6104111,'CA','Pickering','Pickering',43.9001,-79.1329,'P','PPL','CA.08',NULL,87838,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6104876,'CA','Pincourt','Pincourt',45.3834,-73.9825,'P','PPL','CA.10','CA.10.16',11197,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6105815,'CA','Pitt Meadows','Pitt Meadows',49.2212,-122.69,'P','PPL','CA.02',NULL,17410,'America/Vancouver',1,'2010-04-14 23:00:00','2010-04-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6107272,'CA','Pointe-Calumet','Pointe-Calumet',45.5001,-73.9659,'P','PPL','CA.10','CA.10.15',6396,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6107325,'CA','Pointe-Claire','Pointe-Claire',45.4487,-73.8167,'P','PPL','CA.10','CA.10.06',30161,'America/Toronto',1,'2010-09-22 23:00:00','2010-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6109273,'CA','Ponoka','Ponoka',52.6768,-113.581,'P','PPL','CA.01',NULL,6656,'America/Edmonton',1,'2010-12-15 23:00:00','2010-12-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6110611,'CA','Pont Rouge','Pont Rouge',48.8833,-72.0825,'P','PPL','CA.10','CA.10.02',7518,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6111529,'CA','Portage la Prairie','Portage la Prairie',49.9728,-98.2926,'P','PPL','CA.03',NULL,12957,'America/Winnipeg',1,'2013-09-21 23:00:00','2013-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6111632,'CA','Port Alberni','Port Alberni',49.2413,-124.803,'P','PPL','CA.02',NULL,21282,'America/Vancouver',1,'2017-11-08 23:00:00','2017-11-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6111696,'CA','Port-Cartier','Port-Cartier',50.0334,-66.8654,'P','PPL','CA.10','CA.10.09',5851,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6111704,'CA','Port Colborne','Port Colborne',42.9001,-79.2329,'P','PPL','CA.08',NULL,18599,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6111962,'CA','Port Moody','Port Moody',49.283,-122.853,'P','PPL','CA.02',NULL,27512,'America/Vancouver',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6112608,'CA','Powell River','Powell River',49.8328,-124.524,'P','PPL','CA.02','CA.02.5927',12779,'America/Vancouver',1,'2016-04-22 23:00:00','2016-04-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6113198,'CA','Prévost','Prevost',45.8668,-74.0825,'P','PPL','CA.10','CA.10.15',10132,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6113335,'CA','Prince Albert','Prince Albert',53.2001,-105.768,'P','PPL','CA.11',NULL,34609,'America/Regina',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6113355,'CA','Prince Edward','Prince Edward',44.0001,-77.2495,'P','PPL','CA.08',NULL,25496,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6113365,'CA','Prince George','Prince George',53.9166,-122.753,'P','PPL','CA.02',NULL,65558,'America/Vancouver',1,'2010-01-28 23:00:00','2010-01-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6113406,'CA','Prince Rupert','Prince Rupert',54.3151,-130.321,'P','PPL','CA.02','CA.02.5947',14708,'America/Vancouver',1,'2017-12-30 23:00:00','2017-12-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6113466,'CA','Princeville','Princeville',45.7668,-61.2985,'P','PPL','CA.07',NULL,5571,'America/Halifax',1,'2010-09-22 23:00:00','2010-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6115187,'CA','Quesnel','Quesnel',52.9784,-122.493,'P','PPL','CA.02',NULL,13788,'America/Vancouver',1,'2017-12-31 23:00:00','2017-12-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6115355,'CA','Quinte West','Quinte West',44.1834,-77.5662,'P','PPL','CA.08',NULL,42697,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6117611,'CA','Rawdon','Rawdon',46.0501,-73.7159,'P','PPL','CA.10','CA.10.14',10400,'America/Toronto',1,'2016-04-12 23:00:00','2016-04-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6117731,'CA','Rayside-Balfour','Rayside-Balfour',46.6087,-81.2076,'P','PPL','CA.08',NULL,16050,'America/Toronto',1,'2013-07-19 23:00:00','2013-07-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6118158,'CA','Red Deer','Red Deer',52.2668,-113.802,'P','PPL','CA.01',NULL,73593,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6119109,'CA','Regina','Regina',50.4501,-104.618,'P','PPLA','CA.11',NULL,176183,'America/Regina',1,'2010-07-28 23:00:00','2010-07-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6119448,'CA','Renfrew','Renfrew',45.4668,-76.6827,'P','PPL','CA.08',NULL,8018,'America/Toronto',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6119518,'CA','Repentigny','Repentigny',45.7422,-73.4501,'P','PPL','CA.10','CA.10.14',76237,'America/Toronto',1,'2016-04-11 23:00:00','2016-04-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6121621,'CA','Revelstoke','Revelstoke',50.9971,-118.195,'P','PPL','CA.02','CA.02.5939',7533,'America/Vancouver',1,'2016-04-01 23:00:00','2016-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6122037,'CA','Richelieu','Richelieu',45.4434,-73.246,'P','PPL','CA.10','CA.10.16',5208,'America/Toronto',1,'2010-09-22 23:00:00','2010-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6122085,'CA','Richmond','Richmond',49.17,-123.137,'P','PPL','CA.02',NULL,182000,'America/Vancouver',1,'2010-01-28 23:00:00','2010-01-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6122091,'CA','Richmond Hill','Richmond Hill',43.8711,-79.4372,'P','PPL','CA.08','CA.08.3519',185541,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6125653,'CA','Roberval','Roberval',48.5168,-72.2324,'P','PPL','CA.10','CA.10.02',9287,'America/Toronto',1,'2016-04-11 23:00:00','2016-04-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6126305,'CA','Rock Forest','Rock Forest',45.357,-71.9968,'P','PPLX','CA.10','CA.10.05',35500,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6126749,'CA','Rocky Mountain House','Rocky Mountain House',52.3668,-114.919,'P','PPL','CA.01',NULL,6527,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6127681,'CA','Rosemère','Rosemere',45.6334,-73.7992,'P','PPL','CA.10','CA.10.15',14173,'America/Toronto',1,'2010-09-22 23:00:00','2010-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6128577,'CA','Rouyn-Noranda','Rouyn-Noranda',48.2366,-79.0231,'P','PPL','CA.10','CA.10.08',24023,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137063,'CA','Sackville','Sackville',45.9188,-64.3846,'P','PPL','CA.04',NULL,5411,'America/Moncton',1,'2010-06-07 23:00:00','2010-06-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137270,'CA','Saguenay','Saguenay',48.4168,-71.0657,'P','PPL','CA.10','CA.10.02',143692,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137489,'CA','Saint-Basile-le-Grand','Saint-Basile-le-Grand',45.5334,-73.2825,'P','PPL','CA.10','CA.10.16',15605,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137540,'CA','Saint-Bruno-de-Montarville','Saint-Bruno-de-Montarville',45.5334,-73.3492,'P','PPL','CA.10',NULL,24388,'America/Toronto',1,'2010-09-22 23:00:00','2010-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137633,'CA','Saint-Constant','Saint-Constant',45.3668,-73.5659,'P','PPL','CA.10','CA.10.16',23957,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137696,'CA','Sainte-Adèle','Sainte-Adele',45.9501,-74.1325,'P','PPL','CA.10','CA.10.15',10634,'America/Toronto',1,'2016-04-11 23:00:00','2016-04-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137702,'CA','Sainte-Agathe-des-Monts','Sainte-Agathe-des-Monts',46.0501,-74.2825,'P','PPL','CA.10','CA.10.15',5706,'America/Toronto',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137733,'CA','Sainte-Anne-de-Bellevue','Sainte-Anne-de-Bellevue',45.4062,-73.9456,'P','PPL','CA.10',NULL,5197,'America/Toronto',1,'2010-09-22 23:00:00','2010-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137749,'CA','Sainte-Anne-des-Monts','Sainte-Anne-des-Monts',49.124,-66.4924,'P','PPL','CA.10','CA.10.11',5602,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137753,'CA','Sainte-Anne-des-Plaines','Sainte-Anne-des-Plaines',45.7647,-73.8116,'P','PPL','CA.10','CA.10.15',10680,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137780,'CA','Sainte-Catherine','Sainte-Catherine',45.4001,-73.5825,'P','PPL','CA.10','CA.10.16',16762,'America/Toronto',1,'2017-01-31 23:00:00','2017-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137781,'CA','Sainte-Catherine','Sainte-Catherine',46.3184,-72.5663,'P','PPL','CA.10','CA.10.04',16211,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6137941,'CA','Sainte-Julie','Sainte-Julie',45.5834,-73.3325,'P','PPL','CA.10','CA.10.16',29019,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138032,'CA','Sainte-Marthe-sur-le-Lac','Sainte-Marthe-sur-le-Lac',45.5334,-73.9325,'P','PPL','CA.10','CA.10.15',11311,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138121,'CA','Sainte-Thérèse','Sainte-Therese',45.6392,-73.8276,'P','PPL','CA.10','CA.10.15',25224,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138175,'CA','Saint-Eustache','Saint-Eustache',45.565,-73.9055,'P','PPL','CA.10','CA.10.15',42062,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138201,'CA','Saint-Félicien','Saint-Felicien',48.6501,-72.4491,'P','PPL','CA.10','CA.10.02',8088,'America/Toronto',1,'2016-04-12 23:00:00','2016-04-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138210,'CA','Saint-Félix-de-Valois','Saint-Felix-de-Valois',46.1698,-73.4252,'P','PPL','CA.10','CA.10.14',6029,'America/Toronto',1,'2017-01-31 23:00:00','2017-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138352,'CA','Saint-Hippolyte','Saint-Hippolyte',45.9334,-74.0159,'P','PPL','CA.10','CA.10.15',8083,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138374,'CA','Saint-Hyacinthe','Saint-Hyacinthe',45.6308,-72.957,'P','PPL','CA.10','CA.10.16',50326,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138495,'CA','Saint-Jean-sur-Richelieu','Saint-Jean-sur-Richelieu',45.3071,-73.2626,'P','PPL','CA.10','CA.10.16',71613,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138501,'CA','Saint-Jérôme','Saint-Jerome',45.7804,-74.0036,'P','PPL','CA.10','CA.10.15',54948,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138517,'CA','Saint John','Saint John',45.2727,-66.0677,'P','PPL','CA.04','CA.04.1301',87857,'America/Moncton',1,'2016-04-01 23:00:00','2016-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138573,'CA','Saint-Joseph-du-Lac','Saint-Joseph-du-Lac',45.5334,-73.9992,'P','PPL','CA.10','CA.10.15',6195,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138610,'CA','Saint-Laurent','Saint-Laurent',45.5001,-73.6658,'P','PPLX','CA.10','CA.10.06',77391,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138617,'CA','Saint-Lazare','Saint-Lazare',45.4001,-74.1326,'P','PPL','CA.10','CA.10.16',17016,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138625,'CA','Saint-Léonard','Saint-Leonard',45.5877,-73.595,'P','PPLX','CA.10','CA.10.06',73423,'America/Toronto',1,'2013-07-17 23:00:00','2013-07-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138643,'CA','Saint-Lin-Laurentides','Saint-Lin-Laurentides',45.8501,-73.7659,'P','PPL','CA.10','CA.10.14',14159,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138916,'CA','Saint-Pie','Saint-Pie',45.5028,-72.9089,'P','PPLA3','CA.10','CA.10.16',5438,'America/Toronto',1,'2016-06-30 23:00:00','2016-06-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6138980,'CA','Saint-Raymond','Saint-Raymond',45.467,-73.6095,'P','PPL','CA.10',NULL,9273,'America/Toronto',1,'2013-07-14 23:00:00','2013-07-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6139045,'CA','Saint-Sauveur','Saint-Sauveur',45.8869,-74.1794,'P','PPL','CA.10','CA.10.15',9191,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6139216,'CA','Saint-Zotique','Saint-Zotique',45.2501,-74.2492,'P','PPL','CA.10','CA.10.16',6773,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6139289,'CA','Salaberry-de-Valleyfield','Salaberry-de-Valleyfield',45.2501,-74.1325,'P','PPL','CA.10','CA.10.16',38662,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6139416,'CA','Salmon Arm','Salmon Arm',50.6998,-119.302,'P','PPL','CA.02',NULL,16205,'America/Vancouver',1,'2008-05-12 23:00:00','2008-05-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6141190,'CA','Sarnia','Sarnia',42.9787,-82.4041,'P','PPL','CA.08','CA.08.3538',82998,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6141256,'CA','Saskatoon','Saskatoon',52.1324,-106.669,'P','PPL','CA.11',NULL,198958,'America/Regina',1,'2016-04-01 23:00:00','2016-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6141439,'CA','Sault Ste. Marie','Sault Ste. Marie',46.5168,-84.3333,'P','PPLA2','CA.08','CA.08.3557',74948,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6143367,'CA','Sechelt','Sechelt',49.4751,-123.759,'P','PPL','CA.02','CA.02.5929',5977,'America/Vancouver',1,'2013-09-22 23:00:00','2013-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6144054,'CA','Selkirk','Selkirk',50.1436,-96.8845,'P','PPL','CA.03',NULL,9653,'America/Winnipeg',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6144312,'CA','Sept-Îles','Sept-Iles',50.2001,-66.3821,'P','PPL','CA.10','CA.10.09',22582,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6145489,'CA','Shawinigan','Shawinigan',46.5667,-72.7491,'P','PPLA3','CA.10','CA.10.04',49161,'America/Toronto',1,'2016-11-12 23:00:00','2016-11-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6146143,'CA','Sherbrooke','Sherbrooke',45.4001,-71.8991,'P','PPL','CA.10','CA.10.05',129447,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6146279,'CA','Sherwood Park','Sherwood Park',53.5168,-113.319,'P','PPL','CA.01',NULL,55063,'America/Edmonton',1,'2007-02-12 23:00:00','2007-02-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6147962,'CA','Simcoe','Simcoe',42.8334,-80.2997,'P','PPL','CA.08',NULL,13922,'America/Toronto',1,'2017-12-12 23:00:00','2017-12-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6149374,'CA','Slave Lake','Slave Lake',55.2834,-114.769,'P','PPL','CA.01',NULL,7661,'America/Edmonton',1,'2016-04-01 23:00:00','2016-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6149996,'CA','Smithers','Smithers',54.7804,-127.174,'P','PPL','CA.02',NULL,5438,'America/Vancouver',1,'2016-04-01 23:00:00','2016-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6150174,'CA','Smiths Falls','Smiths Falls',44.9045,-76.0233,'P','PPL','CA.08','CA.08.3509',10553,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6151264,'CA','Sooke','Sooke',48.3746,-123.728,'P','PPL','CA.02',NULL,6145,'America/Vancouver',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6152244,'CA','South Huron','South Huron',43.3168,-81.5165,'P','PPL','CA.08',NULL,9982,'America/Toronto',1,'2013-05-04 23:00:00','2013-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6154383,'CA','Spruce Grove','Spruce Grove',53.5334,-113.919,'P','PPL','CA.01',NULL,17767,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6155033,'CA','St. Albert','St. Albert',53.6334,-113.635,'P','PPL','CA.01',NULL,57719,'America/Edmonton',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6155721,'CA','St. Catharines','St. Catharines',43.1713,-79.2427,'P','PPL','CA.08','CA.08.3526',131989,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6156102,'CA','Steinbach','Steinbach',49.5258,-96.6845,'P','PPL','CA.03',NULL,9607,'America/Winnipeg',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6156244,'CA','Stephenville','Stephenville',48.55,-58.5818,'P','PPL','CA.05',NULL,6278,'America/St_Johns',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6156307,'CA','Stettler','Stettler',52.3168,-112.719,'P','PPL','CA.01',NULL,5494,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6157536,'CA','Stony Plain','Stony Plain',53.5334,-114.002,'P','PPL','CA.01',NULL,8939,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6157977,'CA','Stratford','Stratford',43.3668,-80.9497,'P','PPL','CA.08',NULL,30233,'America/Toronto',1,'2010-01-28 23:00:00','2010-01-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6158023,'CA','Strathmore','Strathmore',51.0501,-113.385,'P','PPL','CA.01',NULL,10009,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6158357,'CA','St. Thomas','St. Thomas',42.7736,-81.1804,'P','PPL','CA.08',NULL,36110,'America/Toronto',1,'2013-10-05 23:00:00','2013-10-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6159232,'CA','Summerland','Summerland',49.5998,-119.669,'P','PPL','CA.02',NULL,6292,'America/Vancouver',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6159244,'CA','Summerside','Summerside',46.3959,-63.7876,'P','PPL','CA.09','CA.09.1103',14808,'America/Halifax',1,'2016-04-01 23:00:00','2016-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6159905,'CA','Surrey','Surrey',49.1063,-122.825,'P','PPL','CA.02',NULL,394976,'America/Vancouver',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6160603,'CA','Swift Current','Swift Current',50.2834,-107.801,'P','PPL','CA.11',NULL,14703,'America/Swift_Current',1,'2016-04-01 23:00:00','2016-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6160806,'CA','Sylvan Lake','Sylvan Lake',52.311,-114.084,'P','PPL','CA.01','CA.01.4808012',10518,'America/Edmonton',1,'2018-01-15 23:00:00','2018-01-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6160919,'CA','Taber','Taber',49.787,-112.146,'P','PPL','CA.01',NULL,8163,'America/Edmonton',1,'2012-07-23 23:00:00','2012-07-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6162659,'CA','Temiskaming Shores','Temiskaming Shores',47.4938,-79.7153,'P','PPL','CA.08',NULL,10442,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6162949,'CA','Terrace','Terrace',54.5163,-128.603,'P','PPL','CA.02',NULL,19443,'America/Vancouver',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6163012,'CA','Terrebonne','Terrebonne',45.7,-73.6473,'P','PPL','CA.10','CA.10.14',94703,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6164499,'CA','The Pas','The Pas',53.8251,-101.254,'P','PPL','CA.03',NULL,6055,'America/Winnipeg',1,'2013-09-22 23:00:00','2013-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6165406,'CA','Thompson','Thompson',55.7435,-97.8558,'P','PPL','CA.03',NULL,12467,'America/Winnipeg',1,'2016-04-01 23:00:00','2016-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6165719,'CA','Thorold','Thorold',43.1168,-79.1996,'P','PPL','CA.08',NULL,18224,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6166142,'CA','Thunder Bay','Thunder Bay',48.382,-89.2502,'P','PPL','CA.08','CA.08.3558',99334,'America/Thunder_Bay',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6166739,'CA','Timmins','Timmins',48.4669,-81.3331,'P','PPL','CA.08',NULL,42997,'America/Toronto',1,'2017-11-11 23:00:00','2017-11-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6167865,'CA','Toronto','Toronto',43.7001,-79.4163,'P','PPLA','CA.08',NULL,2600000,'America/Toronto',1,'2015-04-23 23:00:00','2015-04-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6168326,'CA','Trail','Trail',49.0998,-117.702,'P','PPL','CA.02',NULL,9707,'America/Vancouver',1,'2018-01-02 23:00:00','2018-01-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6169141,'CA','Trois-Rivières','Trois-Rivieres',46.3451,-72.5477,'P','PPL','CA.10','CA.10.04',119693,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6169587,'CA','Truro','Truro',45.3669,-63.2654,'P','PPL','CA.07',NULL,20650,'America/Halifax',1,'2006-01-21 23:00:00','2006-01-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6172932,'CA','Uxbridge','Uxbridge',44.1001,-79.1163,'P','PPL','CA.08',NULL,11531,'America/Toronto',1,'2014-12-31 23:00:00','2014-12-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6173012,'CA','Val-des-Monts','Val-des-Monts',45.6501,-75.666,'P','PPL','CA.10','CA.10.07',9539,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6173017,'CA','Val-d\'Or','Val-d\'Or',48.0974,-77.7974,'P','PPL','CA.10','CA.10.08',31123,'America/Toronto',1,'2015-09-05 23:00:00','2015-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6173331,'CA','Vancouver','Vancouver',49.2497,-123.119,'P','PPL','CA.02',NULL,600000,'America/Vancouver',1,'2016-07-17 23:00:00','2016-07-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6173508,'CA','Varennes','Varennes',45.6834,-73.4325,'P','PPL','CA.10','CA.10.16',20950,'America/Toronto',1,'2017-01-31 23:00:00','2017-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6173570,'CA','Vaudreuil-Dorion','Vaudreuil-Dorion',45.4001,-74.0325,'P','PPL','CA.10','CA.10.16',25789,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6173577,'CA','Vaughan','Vaughan',43.8361,-79.4983,'P','PPL','CA.08',NULL,238866,'America/Toronto',1,'2011-12-06 23:00:00','2011-12-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6173635,'CA','Vegreville','Vegreville',53.5001,-112.052,'P','PPL','CA.01',NULL,5678,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6173864,'CA','Vernon','Vernon',50.2673,-119.273,'P','PPL','CA.02','CA.02.5937',47274,'America/Vancouver',1,'2015-01-10 23:00:00','2015-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6174041,'CA','Victoria','Victoria',48.4329,-123.369,'P','PPLA','CA.02',NULL,289625,'America/Vancouver',1,'2015-06-03 23:00:00','2015-06-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6174151,'CA','Victoriaville','Victoriaville',46.0501,-71.9658,'P','PPL','CA.10','CA.10.17',34426,'America/Toronto',1,'2016-04-11 23:00:00','2016-04-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6175059,'CA','Wainwright','Wainwright',52.8348,-110.853,'P','PPL','CA.01',NULL,5380,'America/Edmonton',1,'2016-12-10 23:00:00','2016-12-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6176421,'CA','Wasaga Beach','Wasaga Beach',44.5168,-80.0164,'P','PPL','CA.08',NULL,7567,'America/Toronto',1,'2010-03-10 23:00:00','2010-03-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6176823,'CA','Waterloo','Waterloo',43.4668,-80.5164,'P','PPL','CA.08',NULL,97475,'America/Toronto',1,'2010-01-28 23:00:00','2010-01-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6177869,'CA','Welland','Welland',42.9834,-79.2496,'P','PPL','CA.08',NULL,50331,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6178582,'CA','West End','West End',49.2833,-123.133,'P','PPL','CA.02',NULL,44560,'America/Vancouver',1,'2013-09-08 23:00:00','2013-09-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6179138,'CA','Westlock','Westlock',54.1502,-113.869,'P','PPL','CA.01',NULL,5067,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6179226,'CA','Westmount','Westmount',45.4834,-73.5992,'P','PPL','CA.10',NULL,20494,'America/Toronto',1,'2010-09-22 23:00:00','2010-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6179602,'CA','Wetaskiwin','Wetaskiwin',52.9668,-113.369,'P','PPL','CA.01',NULL,11302,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6179652,'CA','Weyburn','Weyburn',49.6668,-103.851,'P','PPL','CA.11',NULL,9362,'America/Regina',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6180144,'CA','Whistler','Whistler',50.1164,-122.969,'P','PPL','CA.02',NULL,10600,'America/Vancouver',1,'2015-05-22 23:00:00','2015-05-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6180285,'CA','Whitecourt','Whitecourt',54.1502,-115.685,'P','PPL','CA.01',NULL,8763,'America/Edmonton',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6180550,'CA','Whitehorse','Whitehorse',60.7161,-135.054,'P','PPLA','CA.12',NULL,23272,'America/Whitehorse',1,'2010-07-28 23:00:00','2010-07-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6180961,'CA','White Rock','White Rock',49.0164,-122.803,'P','PPL','CA.02','CA.02.5915',66450,'America/Vancouver',1,'2013-08-27 23:00:00','2013-08-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6182212,'CA','Williams Lake','Williams Lake',52.1415,-122.145,'P','PPL','CA.02','CA.02.5941',14168,'America/Vancouver',1,'2017-12-22 23:00:00','2017-12-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6182959,'CA','Windsor','Windsor',45.5668,-71.9991,'P','PPL','CA.10','CA.10.05',5408,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6182962,'CA','Windsor','Windsor',42.3001,-83.0165,'P','PPL','CA.08',NULL,278013,'America/Toronto',1,'2012-05-03 23:00:00','2012-05-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6183204,'CA','Winkler','Winkler',49.1817,-97.941,'P','PPL','CA.03',NULL,8270,'America/Winnipeg',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6183235,'CA','Winnipeg','Winnipeg',49.8844,-97.147,'P','PPLA','CA.03',NULL,632063,'America/Winnipeg',1,'2013-09-22 23:00:00','2013-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6184365,'CA','Woodstock','Woodstock',43.1334,-80.7497,'P','PPLA2','CA.08','CA.08.3532',33892,'America/Toronto',1,'2018-01-19 23:00:00','2018-01-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6185217,'CA','Yarmouth','Yarmouth',43.8335,-66.1156,'P','PPL','CA.07',NULL,7500,'America/Halifax',1,'2008-04-10 23:00:00','2008-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6185377,'CA','Yellowknife','Yellowknife',62.4541,-114.372,'P','PPLA','CA.13',NULL,15865,'America/Yellowknife',1,'2016-04-01 23:00:00','2016-04-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6185607,'CA','Yorkton','Yorkton',51.2167,-102.468,'P','PPL','CA.11',NULL,15669,'America/Regina',1,'2013-10-05 23:00:00','2013-10-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6295855,'CA','Beauceville','Beauceville',46.2178,-70.7787,'P','PPL','CA.10','CA.10.12',6226,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6324729,'CA','Halifax','Halifax',44.6453,-63.5724,'P','PPLA','CA.07',NULL,359111,'America/Halifax',1,'2014-07-17 23:00:00','2014-07-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6324733,'CA','St. John\'s','St. John\'s',47.5649,-52.7093,'P','PPLA','CA.05',NULL,99182,'America/St_Johns',1,'2014-07-20 23:00:00','2014-07-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6325494,'CA','Québec','Quebec',46.8123,-71.2145,'P','PPLA','CA.10',NULL,528595,'America/Toronto',1,'2014-11-05 23:00:00','2014-11-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6325521,'CA','Lévis','Levis',46.8033,-71.1779,'P','PPL','CA.10','CA.10.12',126396,'America/Blanc-Sablon',1,'2015-09-03 23:00:00','2015-09-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6325529,'CA','Montmagny','Montmagny',46.9804,-70.5549,'P','PPL','CA.10','CA.10.12',11724,'America/Toronto',1,'2017-04-02 23:00:00','2017-04-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6354895,'CA','Rimouski','Rimouski',48.4488,-68.524,'P','PPL','CA.10','CA.10.01',42240,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6354897,'CA','Rivière-du-Loup','Riviere-du-Loup',47.827,-69.5424,'P','PPL','CA.10','CA.10.01',18586,'America/Toronto',1,'2013-08-23 23:00:00','2013-08-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6354908,'CA','Sydney','Sydney',46.1351,-60.1831,'P','PPL','CA.07','CA.07.CAPE BRETON CO',105968,'America/Glace_Bay',1,'2016-04-16 23:00:00','2016-04-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6534203,'CA','L\'Ancienne-Lorette','L\'Ancienne-Lorette',46.7939,-71.3519,'P','PPL','CA.10',NULL,16516,'America/Toronto',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6545023,'CA','Edmundston','Edmundston',47.3737,-68.3251,'P','PPL','CA.04',NULL,16643,'America/Moncton',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6620953,'CA','Saint-Georges','Saint-Georges',46.1135,-70.6653,'P','PPL','CA.10','CA.10.12',31173,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6639619,'CA','Sainte Catherine de la Jacques Cartier','Sainte Catherine de la Jacques Cartier',46.8524,-71.6206,'P','PPL','CA.10','CA.10.03',5021,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6690232,'CA','Baie-Saint-Paul','Baie-Saint-Paul',47.4411,-70.4986,'P','PPL','CA.10','CA.10.03',7288,'America/Toronto',1,'2016-04-11 23:00:00','2016-04-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6696258,'CA','Campbellton','Campbellton',48.0075,-66.6727,'P','PPL','CA.04','CA.04.11',7384,'America/Moncton',1,'2010-09-21 23:00:00','2010-09-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6696259,'CA','Bathurst','Bathurst',47.6181,-65.6511,'P','PPL','CA.04',NULL,12714,'America/Moncton',1,'2013-07-14 23:00:00','2013-07-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6696260,'CA','Matane','Matane',48.8286,-67.522,'P','PPL','CA.10','CA.10.01',14812,'America/Toronto',1,'2016-04-11 23:00:00','2016-04-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6942553,'CA','Paris','Paris',43.2,-80.3833,'P','PPL','CA.08',NULL,11177,'America/Toronto',1,'2009-06-24 23:00:00','2009-06-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6943488,'CA','Amqui','Amqui',48.4638,-67.4313,'P','PPL','CA.10','CA.10.01',6261,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6943811,'CA','Chandler','Chandler',48.3493,-64.6793,'P','PPL','CA.10','CA.10.11',7914,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6943827,'CA','Thetford-Mines','Thetford-Mines',46.0937,-71.3054,'P','PPL','CA.10','CA.10.12',25704,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6944113,'CA','Mont-Joli','Mont-Joli',48.5839,-68.1921,'P','PPL','CA.10','CA.10.01',6568,'America/Toronto',1,'2013-08-16 23:00:00','2013-08-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6945986,'CA','La Malbaie','La Malbaie',47.654,-70.1527,'P','PPL','CA.10','CA.10.03',8959,'America/Toronto',1,'2013-08-16 23:00:00','2013-08-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6945989,'CA','Sainte-Marie','Sainte-Marie',46.434,-71.0117,'P','PPL','CA.10','CA.10.12',11584,'America/Toronto',1,'2010-09-22 23:00:00','2010-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6945991,'CA','Plessisville','Plessisville',46.2186,-71.762,'P','PPL','CA.10','CA.10.04',6677,'America/Toronto',1,'2010-09-22 23:00:00','2010-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6948711,'CA','Scarborough','Scarborough',43.7722,-79.2567,'P','PPL','CA.08',NULL,600000,'America/Toronto',1,'2015-01-30 23:00:00','2015-01-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7280414,'CA','Cole Harbour','Cole Harbour',44.6724,-63.4751,'P','PPLX','CA.07',NULL,20000,'America/Halifax',1,'2010-03-04 23:00:00','2010-03-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7281931,'CA','Okanagan','Okanagan',50.3639,-119.35,'P','PPLQ','CA.02',NULL,297601,'America/Vancouver',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7281936,'CA','West Kelowna','West Kelowna',49.8625,-119.583,'P','PPL','CA.02',NULL,28793,'America/Vancouver',1,'2011-02-18 23:00:00','2011-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7303783,'CA','Sydney Mines','Sydney Mines',46.2367,-60.2177,'P','PPL','CA.07',NULL,7312,'America/Glace_Bay',1,'2010-07-17 23:00:00','2010-07-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7303786,'CA','Jonquière','Jonquiere',48.4165,-71.2488,'P','PPLX','CA.10','CA.10.02',54842,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7535681,'CA','Saint-Augustin-de-Desmaures','Saint-Augustin-de-Desmaures',46.7406,-71.4513,'P','PPL','CA.10','CA.10.03',17281,'America/Toronto',1,'2010-09-22 23:00:00','2010-09-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7535690,'CA','Donnacona','Donnacona',46.6804,-71.7239,'P','PPL','CA.10','CA.10.03',5564,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7602078,'CA','Ladner','Ladner',49.0894,-123.082,'P','PPL','CA.02',NULL,200000,'America/Vancouver',1,'2010-11-14 23:00:00','2010-11-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7669012,'CA','Walnut Grove','Walnut Grove',49.1647,-122.64,'P','PPLX','CA.02',NULL,25683,'America/Vancouver',1,'2011-02-18 23:00:00','2011-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7669018,'CA','Aldergrove','Aldergrove',49.058,-122.471,'P','PPLX','CA.02',NULL,12363,'America/Vancouver',1,'2011-02-18 23:00:00','2011-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7870925,'CA','East York','East York',43.6905,-79.3279,'P','PPL','CA.08',NULL,115365,'America/Toronto',1,'2016-07-05 23:00:00','2016-07-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8285452,'CA','Ancaster','Ancaster',43.2181,-79.9872,'P','PPL','CA.08',NULL,33232,'America/Toronto',1,'2012-05-06 23:00:00','2012-05-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8354533,'CA','Shannon','Shannon',46.8803,-71.5146,'P','PPL','CA.10','CA.10.03',5086,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8354586,'CA','Saint-Henri','Saint-Henri',46.6931,-71.0693,'P','PPL','CA.10','CA.10.12',5023,'America/Toronto',1,'2013-07-14 23:00:00','2013-07-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8379100,'CA','Pont-Rouge','Pont-Rouge',46.7547,-71.6957,'P','PPL','CA.10','CA.10.03',8723,'America/Toronto',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8379101,'CA','Princeville','Princeville',46.1716,-71.8746,'P','PPL','CA.10','CA.10.17',5693,'America/Toronto',1,'2016-02-22 23:00:00','2016-02-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8533869,'CA','West Vancouver','West Vancouver',49.3667,-123.167,'P','PPLL','CA.02',NULL,42694,'America/Vancouver',1,'2013-06-04 23:00:00','2013-06-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8558534,'CA','Willowdale','Willowdale',43.7667,-79.3991,'P','PPLL','CA.08',NULL,79440,'America/Toronto',1,'2013-07-07 23:00:00','2013-07-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (10287505,'CA','Lower Sackville','Lower Sackville',44.776,-63.6786,'P','PPL','CA.07',NULL,21379,'America/Halifax',1,'2016-10-17 23:00:00','2016-10-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (10627796,'CA','le Plateau','le Plateau',45.4351,-75.7803,'P','PPL','CA.10','CA.10.07',15000,'America/Toronto',1,'2015-08-17 23:00:00','2015-08-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11203927,'CA','Wild Rose','Wild Rose',53.4708,-113.381,'P','PPLX','CA.01',NULL,8031,'America/Edmonton',1,'2018-01-08 23:00:00','2018-01-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (11203928,'CA','Silver Berry','Silver Berry',53.4579,-113.382,'P','PPLX','CA.01',NULL,8089,'America/Edmonton',1,'2018-01-08 23:00:00','2018-01-08 23:00:00');


