REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('KN', 'Saint Kitts and Nevis', 'Saint Kitts and Nevis', 'saint-kitts-and-nevis', '+1-869', 'XCD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6575114, 'KN', 'Trinity Palmetto Point', 1, 'trinity-palmetto-point'),
(6575164, 'KN', 'Middle Island', 1, 'middle-island'),
(6575165, 'KN', 'Saint Thomas Lowland', 1, 'saint-thomas-lowland'),
(6575168, 'KN', 'Saint Peter Basseterre', 1, 'saint-peter-basseterre'),
(6575171, 'KN', 'Saint Paul Charlestown', 1, 'saint-paul-charlestown'),
(6575172, 'KN', 'Saint Paul Capesterre', 1, 'saint-paul-capesterre'),
(6575173, 'KN', 'Saint Mary Cayon', 1, 'saint-mary-cayon'),
(6575175, 'KN', 'Saint John Figtree', 1, 'saint-john-figtree'),
(6575176, 'KN', 'Saint John Capesterre', 1, 'saint-john-capesterre'),
(6575177, 'KN', 'Saint James Windwa', 1, 'saint-james-windwa'),
(6575179, 'KN', 'Saint George Gingerland', 1, 'saint-george-gingerland'),
(6575180, 'KN', 'Saint George Basseterre', 1, 'saint-george-basseterre'),
(6575183, 'KN', 'Saint Anne Sandy Point', 1, 'saint-anne-sandy-point'),
(6575476, 'KN', 'Christ Church Nichola Town', 1, 'christ-church-nichola-town');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(6575076, 6575179, 'KN', 'Zion', 1, 'zion', 17.14157, -62.56109),
(6575078, 6575179, 'KN', 'Zetlands', 1, 'zetlands', 17.13856, -62.57557),
(6575081, 6575164, 'KN', 'Wingfield Manor', 1, 'wingfield-manor', 17.33333, -62.78333),
(6575090, 6575177, 'KN', 'Whitehall', 1, 'whitehall', 17.18055, -62.55834),
(6575091, 6575172, 'KN', 'Whitegate', 1, 'whitegate', 17.41667, -62.81667),
(6575097, 6575165, 'KN', 'Westbury', 1, 'westbury', 17.1825, -62.60725),
(6575099, 6575179, 'KN', 'Webb’s Ground', 1, 'webb-s-ground', 17.14516, -62.56057),
(6575106, 6575165, 'KN', 'Vaughans', 1, 'vaughans', 17.16365, -62.62451),
(6575109, 6575168, 'KN', 'Upper Conaree', 1, 'upper-conaree', 17.31503, -62.70697),
(6575115, 6575114, 'KN', 'Trinity', 1, 'trinity', 17.30037, -62.77584),
(6575116, 6575172, 'KN', 'Trants', 1, 'trants', 17.38333, -62.85),
(6575124, 6575179, 'KN', 'Taylors Pasture', 1, 'taylors-pasture', 17.13027, -62.57459),
(6575126, 6575176, 'KN', 'Tabernacle', 1, 'tabernacle', 17.3866, -62.77386),
(6575129, 6575165, 'KN', 'Stuart’s', 1, 'stuart-s', 17.15787, -62.6149),
(6575130, 6575179, 'KN', 'Stonyhill', 1, 'stonyhill', 17.14313, -62.56675),
(6575136, 6575168, 'KN', 'Stapleton', 1, 'stapleton', 17.32692, -62.73069),
(6575149, 6575179, 'KN', 'Sherriffs', 1, 'sherriffs', 17.12202, -62.55894),
(6575155, 6575177, 'KN', 'Scarborough', 1, 'scarborough', 17.19364, -62.5799),
(6575156, 6575183, 'KN', 'Sandy Point Town', 1, 'sandy-point-town', 17.35908, -62.84858),
(6575167, 6575168, 'KN', 'Saint Peter’s', 1, 'saint-peter-s', 17.31607, -62.72902),
(6575170, 6575172, 'KN', 'Saint Paul’s', 1, 'saint-paul-s', 17.40605, -62.83562),
(6575186, 6575176, 'KN', 'Sadlers', 1, 'sadlers', 17.40454, -62.79296),
(6575191, 6575164, 'KN', 'Romneys', 1, 'romneys', 17.33333, -62.78333),
(6575195, 6575179, 'KN', 'Rices', 1, 'rices', 17.12828, -62.56245),
(6575197, 6575177, 'KN', 'Rawlins', 1, 'rawlins', 17.19522, -62.58288),
(6575198, 6575179, 'KN', 'Rawlins', 1, 'rawlins', 17.14389, -62.57176),
(6575207, 6575175, 'KN', 'Pond Hill', 1, 'pond-hill', 17.12815, -62.58196),
(6575216, 6575476, 'KN', 'Phillips', 1, 'phillips', 17.36609, -62.76058),
(6575219, 6575175, 'KN', 'Pembroke', 1, 'pembroke', 17.11591, -62.60006),
(6575222, 6575176, 'KN', 'Parson’s Ground', 1, 'parson-s-ground', 17.40945, -62.80515),
(6575224, 6575168, 'KN', 'Parry’s', 1, 'parry-s', 17.32339, -62.72977),
(6575233, 6575173, 'KN', 'Ottley’s', 1, 'ottley-s', 17.36259, -62.7433),
(6575234, 6575114, 'KN', 'Ottley’s', 1, 'ottley-s', 17.30503, -62.77634),
(6575235, 6575172, 'KN', 'Ortons', 1, 'ortons', 17.38333, -62.83333),
(6575240, 6575164, 'KN', 'Old Road Town', 1, 'old-road-town', 17.32215, -62.80337),
(6575244, 6575168, 'KN', 'Ogee’s', 1, 'ogee-s', 17.33009, -62.73312),
(6575251, 6575476, 'KN', 'Nicola Town', 1, 'nicola-town', 17.37956, -62.75318),
(6575254, 6575172, 'KN', 'Newton Ground', 1, 'newton-ground', 17.38761, -62.85197),
(6575257, 6575179, 'KN', 'New River', 1, 'new-river', 17.14526, -62.55266),
(6575261, 6575177, 'KN', 'Newcastle', 1, 'newcastle', 17.2, -62.58333),
(6575274, 6575177, 'KN', 'Mount Lily', 1, 'mount-lily', 17.1863, -62.58434),
(6575283, 6575175, 'KN', 'Montpelier', 1, 'montpelier', 17.11667, -62.58333),
(6575284, 6575168, 'KN', 'Monkey Hill', 1, 'monkey-hill', 17.32327, -62.72914),
(6575288, 6575476, 'KN', 'Molineux', 1, 'molineux', 17.36988, -62.75506),
(6575292, 6575164, 'KN', 'Middle Island', 1, 'middle-island', 17.3259, -62.81055),
(6575294, 6575179, 'KN', 'Maynards Ground', 1, 'maynards-ground', 17.12805, -62.57247),
(6575296, 6575179, 'KN', 'Market Shop', 1, 'market-shop', 17.13218, -62.57267),
(6575298, 6575168, 'KN', 'Mardenbrough', 1, 'mardenbrough', 17.31667, -62.71667),
(6575300, 6575476, 'KN', 'Mansion', 1, 'mansion', 17.38271, -62.75747),
(6575301, 6575177, 'KN', 'Mannings', 1, 'mannings', 17.16518, -62.54899),
(6575306, 6575177, 'KN', 'Maddens', 1, 'maddens', 17.18333, -62.53333),
(6575309, 6575176, 'KN', 'Lucas', 1, 'lucas', 17.3, -62.7),
(6575310, 6575175, 'KN', 'Low Ground Settlement', 1, 'low-ground-settlement', 17.11735, -62.60399),
(6575316, 6575173, 'KN', 'Lodge', 1, 'lodge', 17.36397, -62.74747),
(6575322, 6575180, 'KN', 'Limekiln', 1, 'limekiln', 17.28333, -62.73333),
(6575331, 6575180, 'KN', 'La Guérite', 1, 'la-guerite', 17.3, -62.71667),
(6575332, 6575168, 'KN', 'Kittitian Village', 1, 'kittitian-village', 17.29082, -62.68687),
(6575334, 6575180, 'KN', 'Kit Stoddart', 1, 'kit-stoddart', 17.29879, -62.72207),
(6575336, 6575173, 'KN', 'Key', 1, 'key', 17.34213, -62.71416),
(6575341, 6575168, 'KN', 'John England Village', 1, 'john-england-village', 17.32097, -62.72901),
(6575344, 6575165, 'KN', 'Jessup', 1, 'jessup', 17.16209, -62.62061),
(6575346, 6575173, 'KN', 'Jack in the Box', 1, 'jack-in-the-box', 17.35, -62.73333),
(6575350, 6575179, 'KN', 'Hull Ground', 1, 'hull-ground', 17.14137, -62.57334),
(6575353, 6575176, 'KN', 'Houstons', 1, 'houstons', 17.38333, -62.78333),
(6575356, 6575179, 'KN', 'Holmes Hill', 1, 'holmes-hill', 17.11919, -62.55814),
(6575361, 6575177, 'KN', 'Hick’s', 1, 'hick-s', 17.18434, -62.55963),
(6575363, 6575179, 'KN', 'Hichmans', 1, 'hichmans', 17.13772, -62.55443),
(6575366, 6575179, 'KN', 'Hermitage', 1, 'hermitage', 17.13289, -62.58126),
(6575367, 6575173, 'KN', 'Hermitage', 1, 'hermitage', 17.36667, -62.71667),
(6575371, 6575172, 'KN', 'Heldens', 1, 'heldens', 17.40552, -62.83678),
(6575377, 6575179, 'KN', 'Harris', 1, 'harris', 17.1463, -62.55874),
(6575378, 6575176, 'KN', 'Harris', 1, 'harris', 17.40275, -62.78747),
(6575380, 6575179, 'KN', 'Hardtimes', 1, 'hardtimes', 17.13333, -62.55),
(6575384, 6575164, 'KN', 'Half Way Tree', 1, 'half-way-tree', 17.33294, -62.82472),
(6575394, 6575168, 'KN', 'Greatheeds', 1, 'greatheeds', 17.31667, -62.7),
(6575400, 6575168, 'KN', 'Golden Rock', 1, 'golden-rock', 17.31667, -62.71667),
(6575403, 6575179, 'KN', 'Gingerland', 1, 'gingerland', 17.13517, -62.56928),
(6575405, 6575176, 'KN', 'Geagans', 1, 'geagans', 17.38333, -62.78333),
(6575417, 6575177, 'KN', 'Fountain', 1, 'fountain', 17.18126, -62.59155),
(6575419, 6575179, 'KN', 'Fothergill', 1, 'fothergill', 17.15, -62.55),
(6575422, 6575183, 'KN', 'Fig Tree', 1, 'fig-tree', 17.36735, -62.85755),
(6575423, 6575175, 'KN', 'Fig Tree', 1, 'fig-tree', 17.12623, -62.60265),
(6575424, 6575179, 'KN', 'Fenton Hill', 1, 'fenton-hill', 17.13895, -62.56486),
(6575438, 6575168, 'KN', 'Douglas', 1, 'douglas', 17.31667, -62.71667),
(6575441, 6575176, 'KN', 'Dieppe Bay Town', 1, 'dieppe-bay-town', 17.41473, -62.8139),
(6575446, 6575173, 'KN', 'Dalzells', 1, 'dalzells', 17.35, -62.7),
(6575448, 6575179, 'KN', 'Crook’s Ground', 1, 'crook-s-ground', 17.12875, -62.56793),
(6575452, 6575183, 'KN', 'Craddocks', 1, 'craddocks', 17.14354, -62.62309),
(6575456, 6575175, 'KN', 'Cox', 1, 'cox', 17.12101, -62.58387),
(6575458, 6575165, 'KN', 'Cotton Ground', 1, 'cotton-ground', 17.16667, -62.61667),
(6575465, 6575175, 'KN', 'Cole Hill', 1, 'cole-hill', 17.12733, -62.58797),
(6575468, 6575172, 'KN', 'Cliftons', 1, 'cliftons', 17.4, -62.8),
(6575469, 6575165, 'KN', 'Cliftons', 1, 'cliftons', 17.18333, -62.6),
(6575475, 6575175, 'KN', 'Church Ground', 1, 'church-ground', 17.13266, -62.59953),
(6575478, 6575179, 'KN', 'Chicken Stone', 1, 'chicken-stone', 17.13178, -62.57963),
(6575479, 6575171, 'KN', 'Charlestown', 1, 'charlestown', 17.13333, -62.61667),
(6575483, 6575114, 'KN', 'Challengers', 1, 'challengers', 17.30395, -62.78487),
(6575487, 6575173, 'KN', 'Cayon', 1, 'cayon', 17.35, -62.73333),
(6575492, 6575168, 'KN', 'Canada', 1, 'canada', 17.33333, -62.7),
(6575493, 6575177, 'KN', 'Camps', 1, 'camps', 17.19696, -62.57637),
(6575504, 6575177, 'KN', 'Butlers', 1, 'butlers', 17.16654, -62.55084),
(6575508, 6575183, 'KN', 'Burts', 1, 'burts', 17.36667, -62.81667),
(6575510, 6575177, 'KN', 'Burnaby', 1, 'burnaby', 17.19623, -62.57269),
(6575512, 6575179, 'KN', 'Buck’s Hill', 1, 'buck-s-hill', 17.12625, -62.56403),
(6575514, 6575180, 'KN', 'Brumaire', 1, 'brumaire', 17.3, -62.73333),
(6575515, 6575175, 'KN', 'Brown Pasture', 1, 'brown-pasture', 17.13229, -62.5933),
(6575516, 6575175, 'KN', 'Brown Hill', 1, 'brown-hill', 17.12142, -62.60203),
(6575518, 6575176, 'KN', 'Brownes', 1, 'brownes', 17.4, -62.8),
(6575527, 6575177, 'KN', 'Brick Kiln', 1, 'brick-kiln', 17.17532, -62.55345),
(6575529, 6575176, 'KN', 'Brambles', 1, 'brambles', 17.38333, -62.76667),
(6575531, 6575114, 'KN', 'Boyd’s', 1, 'boyd-s', 17.29779, -62.77021),
(6575533, 6575476, 'KN', 'Bourryau', 1, 'bourryau', 17.38333, -62.73333),
(6575544, 6575175, 'KN', 'Beaumont', 1, 'beaumont', 17.12437, -62.58131),
(6575546, 6575168, 'KN', 'Bayford’s', 1, 'bayford-s', 17.33433, -62.74871),
(6575549, 6575175, 'KN', 'Bath', 1, 'bath', 17.12986, -62.62713),
(6575551, 6575180, 'KN', 'Basseterre', 1, 'basseterre', 17.2955, -62.72499),
(6575552, 6575165, 'KN', 'Barnes Ghaut', 1, 'barnes-ghaut', 17.16779, -62.61087),
(6575553, 6575177, 'KN', 'Barnabys Village', 1, 'barnabys-village', 17.2, -62.55),
(6575558, 6575179, 'KN', 'Bachelors Hall', 1, 'bachelors-hall', 17.13333, -62.51667),
(14883252, 6575175, 'KN', 'Beach Road', 1, 'beach-road', 17.13014, -62.58785),
(14883259, 6575177, 'KN', 'Potwork Settlement', 1, 'potwork-settlement', 17.19373, -62.56744),
(14883260, 6575177, 'KN', 'Nisbett Settlement', 1, 'nisbett-settlement', 17.20376, -62.58157);