Hi , I stuck all the countries above together plus added Italy with their regions and have also found UK somewhere here so with this list you can add USA , UK , SPAIN , FRANCE , ITALY with their country names , if someone will add german speaking countries Germany , Austria , Switzerland and Canada + Australia i would be glad to have it too
Here 507 cities(5 countries) :
CREATE TABLE `cities` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`ascii_name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `cities` (`id`, `name`, `ascii_name`) VALUES
(-1, 'City, Country', 'City, Country'),
(1, 'Abilene, Texas', 'Abilene, Texas'),
(2, 'Akron, Ohio', 'Akron, Ohio'),
(3, 'Albuquerque, New Mexico', 'Albuquerque, New Mexico'),
(4, 'Alexandria, Virginia', 'Alexandria, Virginia'),
(5, 'Allentown, Pennsylvania', 'Allentown, Pennsylvania'),
(6, 'Amarillo, Texas', 'Amarillo, Texas'),
(7, 'Anaheim, California', 'Anaheim, California'),
(8, 'Anchorage municipality, Alaska', 'Anchorage municipality, Alaska'),
(9, 'Ann Arbor, Michigan', 'Ann Arbor, Michigan'),
(10, 'Arlington CDP, Virginia', 'Arlington CDP, Virginia'),
(11, 'Arlington, Texas', 'Arlington, Texas'),
(12, 'Arvada, Colorado', 'Arvada, Colorado'),
(13, 'Athens, Georgia', 'Athens, Georgia'),
(14, 'Atlanta, Georgia', 'Atlanta, Georgia'),
(15, 'Augusta, Georgia', 'Augusta, Georgia'),
(16, 'Aurora, Colorado', 'Aurora, Colorado'),
(17, 'Aurora, Illinois', 'Aurora, Illinois'),
(18, 'Austin, Texas', 'Austin, Texas'),
(19, 'Bakersfield, California', 'Bakersfield, California'),
(20, 'Baltimore, Maryland', 'Baltimore, Maryland'),
(21, 'Baton Rouge, Louisiana', 'Baton Rouge, Louisiana'),
(22, 'Beaumont, Texas', 'Beaumont, Texas'),
(23, 'Bellevue, Washington', 'Bellevue, Washington'),
(24, 'Berkeley, California', 'Berkeley, California'),
(25, 'Billings, Montana', 'Billings, Montana'),
(26, 'Birmingham, Alabama', 'Birmingham, Alabama'),
(27, 'Boise, Idaho', 'Boise, Idaho'),
(28, 'Boston, Massachusetts', 'Boston, Massachusetts'),
(29, 'Bridgeport, Connecticut', 'Bridgeport, Connecticut'),
(30, 'Brownsville, Texas', 'Brownsville, Texas'),
(31, 'Buffalo, New York', 'Buffalo, New York'),
(32, 'Burbank, California', 'Burbank, California'),
(33, 'Cambridge, Massachusetts', 'Cambridge, Massachusetts'),
(34, 'Cape Coral, Florida', 'Cape Coral, Florida'),
(35, 'Carrollton, Texas', 'Carrollton, Texas'),
(36, 'Cary town, North Carolina', 'Cary town, North Carolina'),
(37, 'Cedar Rapids, Iowa', 'Cedar Rapids, Iowa'),
(38, 'Chandler, Arizona', 'Chandler, Arizona'),
(39, 'Charleston, South Carolina', 'Charleston, South Carolina'),
(40, 'Charlotte, North Carolina', 'Charlotte, North Carolina'),
(41, 'Chattanooga, Tennessee', 'Chattanooga, Tennessee'),
(42, 'Chesapeake, Virginia', 'Chesapeake, Virginia'),
(43, 'Chicago, Illinois', 'Chicago, Illinois'),
(44, 'Chula Vista, California', 'Chula Vista, California'),
(45, 'Cincinnati, Ohio', 'Cincinnati, Ohio'),
(46, 'Clarksville, Tennessee', 'Clarksville, Tennessee'),
(47, 'Clearwater, Florida', 'Clearwater, Florida'),
(48, 'Cleveland, Ohio', 'Cleveland, Ohio'),
(49, 'Colorado Springs, Colorado', 'Colorado Springs, Colorado'),
(50, 'Columbia, South Carolina', 'Columbia, South Carolina'),
(51, 'Columbus, Georgia', 'Columbus, Georgia'),
(52, 'Columbus, Ohio', 'Columbus, Ohio'),
(53, 'Concord, California', 'Concord, California'),
(54, 'Coral Springs, Florida', 'Coral Springs, Florida'),
(55, 'Corona, California', 'Corona, California'),
(56, 'Corpus Christi, Texas', 'Corpus Christi, Texas'),
(57, 'Costa Mesa, California', 'Costa Mesa, California'),
(58, 'Dallas, Texas', 'Dallas, Texas'),
(59, 'Daly, California', 'Daly, California'),
(60, 'Dayton, Ohio', 'Dayton, Ohio'),
(61, 'Denton, Texas', 'Denton, Texas'),
(62, 'Denver, Colorado', 'Denver, Colorado'),
(63, 'Des Moines, Iowa', 'Des Moines, Iowa'),
(64, 'Detroit, Michigan', 'Detroit, Michigan'),
(65, 'Downey, California', 'Downey, California'),
(66, 'Durham, North Carolina', 'Durham, North Carolina'),
(67, 'El Monte, California', 'El Monte, California'),
(68, 'El Paso, Texas', 'El Paso, Texas'),
(69, 'Elgin, Illinois', 'Elgin, Illinois'),
(70, 'Elizabeth, New Jersey', 'Elizabeth, New Jersey'),
(71, 'Elk Grove, California', 'Elk Grove, California'),
(72, 'Erie, Pennsylvania', 'Erie, Pennsylvania'),
(73, 'Escondido, California', 'Escondido, California'),
(74, 'Eugene, Oregon', 'Eugene, Oregon'),
(75, 'Evansville, Indiana', 'Evansville, Indiana'),
(76, 'Fairfield, California', 'Fairfield, California'),
(77, 'Fayetteville, North Carolina', 'Fayetteville, North Carolina'),
(78, 'Flint, Michigan', 'Flint, Michigan'),
(79, 'Fontana, California', 'Fontana, California'),
(80, 'Fort Collins, Colorado', 'Fort Collins, Colorado'),
(81, 'Fort Lauderdale, Florida', 'Fort Lauderdale, Florida'),
(82, 'Fort Wayne, Indiana', 'Fort Wayne, Indiana'),
(83, 'Fort Worth, Texas', 'Fort Worth, Texas'),
(84, 'Fremont, California', 'Fremont, California'),
(85, 'Fresno, California', 'Fresno, California'),
(86, 'Fullerton, California', 'Fullerton, California'),
(87, 'Gainesville, Florida', 'Gainesville, Florida'),
(88, 'Garden Grove, California', 'Garden Grove, California'),
(89, 'Garland, Texas', 'Garland, Texas'),
(90, 'Gilbert town, Arizona', 'Gilbert town, Arizona'),
(91, 'Glendale, Arizona', 'Glendale, Arizona'),
(92, 'Glendale, California', 'Glendale, California'),
(93, 'Grand Prairie, Texas', 'Grand Prairie, Texas'),
(94, 'Grand Rapids, Michigan', 'Grand Rapids, Michigan'),
(95, 'Green Bay, Wisconsin', 'Green Bay, Wisconsin'),
(96, 'Greensboro, North Carolina', 'Greensboro, North Carolina'),
(97, 'Hampton, Virginia', 'Hampton, Virginia'),
(98, 'Hartford, Connecticut', 'Hartford, Connecticut'),
(99, 'Hayward, California', 'Hayward, California'),
(100, 'Henderson, Nevada', 'Henderson, Nevada'),
(101, 'Hialeah, Florida', 'Hialeah, Florida'),
(102, 'High Point, North Carolina', 'High Point, North Carolina'),
(103, 'Hollywood, Florida', 'Hollywood, Florida'),
(104, 'Honolulu CDP, Hawaii', 'Honolulu CDP, Hawaii'),
(105, 'Houston, Texas', 'Houston, Texas'),
(106, 'Huntington Beach, California', 'Huntington Beach, California'),
(107, 'Huntsville, Alabama', 'Huntsville, Alabama'),
(108, 'Independence, Missouri', 'Independence, Missouri'),
(109, 'Indianapolis (balance), Indiana', 'Indianapolis (balance), Indiana'),
(110, 'Inglewood, California', 'Inglewood, California'),
(111, 'Irvine, California', 'Irvine, California'),
(112, 'Irving, Texas', 'Irving, Texas'),
(113, 'Jackson, Mississippi', 'Jackson, Mississippi'),
(114, 'Jacksonville, Florida', 'Jacksonville, Florida'),
(115, 'Jersey, New Jersey', 'Jersey, New Jersey'),
(116, 'Joliet, Illinois', 'Joliet, Illinois'),
(117, 'Kansas, Kansas', 'Kansas, Kansas'),
(118, 'Kansas, Missouri', 'Kansas, Missouri'),
(119, 'Killeen, Texas', 'Killeen, Texas'),
(120, 'Knoxville, Tennessee', 'Knoxville, Tennessee'),
(121, 'Lafayette, Louisiana', 'Lafayette, Louisiana'),
(122, 'Lakewood, Colorado', 'Lakewood, Colorado'),
(123, 'Lancaster, California', 'Lancaster, California'),
(124, 'Lansing, Michigan', 'Lansing, Michigan'),
(125, 'Laredo, Texas', 'Laredo, Texas'),
(126, 'Las Vegas, Nevada', 'Las Vegas, Nevada'),
(127, 'Lexington, Kentucky', 'Lexington, Kentucky'),
(128, 'Lincoln, Nebraska', 'Lincoln, Nebraska'),
(129, 'Little Rock, Arkansas', 'Little Rock, Arkansas'),
(130, 'Long Beach, California', 'Long Beach, California'),
(131, 'Los Angeles, California', 'Los Angeles, California'),
(132, 'Louisville, Kentucky', 'Louisville, Kentucky'),
(133, 'Lowell, Massachusetts', 'Lowell, Massachusetts'),
(134, 'Lubbock, Texas', 'Lubbock, Texas'),
(135, 'Madison, Wisconsin', 'Madison, Wisconsin'),
(136, 'Manchester, New Hampshire', 'Manchester, New Hampshire'),
(137, 'McAllen, Texas', 'McAllen, Texas'),
(138, 'McKinney, Texas', 'McKinney, Texas'),
(139, 'Memphis, Tennessee', 'Memphis, Tennessee'),
(140, 'Mesa, Arizona', 'Mesa, Arizona'),
(141, 'Mesquite, Texas', 'Mesquite, Texas'),
(142, 'Miami, Florida', 'Miami, Florida'),
(143, 'Midland, Texas', 'Midland, Texas'),
(144, 'Milwaukee, Wisconsin', 'Milwaukee, Wisconsin'),
(145, 'Minneapolis, Minnesota', 'Minneapolis, Minnesota'),
(146, 'Miramar, Florida', 'Miramar, Florida'),
(147, 'Mobile, Alabama', 'Mobile, Alabama'),
(148, 'Modesto, California', 'Modesto, California'),
(149, 'Montgomery, Alabama', 'Montgomery, Alabama'),
(150, 'Moreno Valley, California', 'Moreno Valley, California'),
(151, 'Naperville, Illinois', 'Naperville, Illinois'),
(152, 'Nashville, Tennessee', 'Nashville, Tennessee'),
(153, 'New Haven, Connecticut', 'New Haven, Connecticut'),
(154, 'New Orleans, Louisiana', 'New Orleans, Louisiana'),
(155, 'New York, New York', 'New York, New York'),
(156, 'Newark, New Jersey', 'Newark, New Jersey'),
(157, 'Newport News, Virginia', 'Newport News, Virginia'),
(158, 'Norfolk, Virginia', 'Norfolk, Virginia'),
(159, 'Norman, Oklahoma', 'Norman, Oklahoma'),
(160, 'North Las Vegas, Nevada', 'North Las Vegas, Nevada'),
(161, 'Norwalk, California', 'Norwalk, California'),
(162, 'Oakland, California', 'Oakland, California'),
(163, 'Oceanside, California', 'Oceanside, California'),
(164, 'Oklahoma, Oklahoma', 'Oklahoma, Oklahoma'),
(165, 'Olathe, Kansas', 'Olathe, Kansas'),
(166, 'Omaha, Nebraska', 'Omaha, Nebraska'),
(167, 'Ontario, California', 'Ontario, California'),
(168, 'Orange, California', 'Orange, California'),
(169, 'Orlando, Florida', 'Orlando, Florida'),
(170, 'Overland Park, Kansas', 'Overland Park, Kansas'),
(171, 'Oxnard, California', 'Oxnard, California'),
(172, 'Palm Bay, Florida', 'Palm Bay, Florida'),
(173, 'Palmdale, California', 'Palmdale, California'),
(174, 'Pasadena, California', 'Pasadena, California'),
(175, 'Pasadena, Texas', 'Pasadena, Texas'),
(176, 'Paterson, New Jersey', 'Paterson, New Jersey'),
(177, 'Pembroke Pines, Florida', 'Pembroke Pines, Florida'),
(178, 'Peoria, Arizona', 'Peoria, Arizona'),
(179, 'Peoria, Illinois', 'Peoria, Illinois'),
(180, 'Philadelphia, Pennsylvania', 'Philadelphia, Pennsylvania'),
(181, 'Phoenix, Arizona', 'Phoenix, Arizona'),
(182, 'Pittsburgh, Pennsylvania', 'Pittsburgh, Pennsylvania'),
(183, 'Plano, Texas', 'Plano, Texas'),
(184, 'Pomona, California', 'Pomona, California'),
(185, 'Pompano Beach, Florida', 'Pompano Beach, Florida'),
(186, 'Port St. Lucie, Florida', 'Port St. Lucie, Florida'),
(187, 'Portland, Oregon', 'Portland, Oregon'),
(188, 'Portsmouth, Virginia', 'Portsmouth, Virginia'),
(189, 'Providence, Rhode Island', 'Providence, Rhode Island'),
(190, 'Provo, Utah', 'Provo, Utah'),
(191, 'Pueblo, Colorado', 'Pueblo, Colorado'),
(192, 'Raleigh, North Carolina', 'Raleigh, North Carolina'),
(193, 'Rancho Cucamonga, California', 'Rancho Cucamonga, California'),
(194, 'Reno, Nevada', 'Reno, Nevada'),
(195, 'Richmond, California', 'Richmond, California'),
(196, 'Richmond, Virginia', 'Richmond, Virginia'),
(197, 'Riverside, California', 'Riverside, California'),
(198, 'Rochester, New York', 'Rochester, New York'),
(199, 'Rockford, Illinois', 'Rockford, Illinois'),
(200, 'Roseville, California', 'Roseville, California'),
(201, 'Sacramento, California', 'Sacramento, California'),
(202, 'Salem, Oregon', 'Salem, Oregon'),
(203, 'Salinas, California', 'Salinas, California'),
(204, 'Salt Lake, Utah', 'Salt Lake, Utah'),
(205, 'San Antonio, Texas', 'San Antonio, Texas'),
(206, 'San Bernardino, California', 'San Bernardino, California'),
(207, 'San Buenaventura (Ventura), California', 'San Buenaventura (Ventura), California'),
(208, 'San Diego, California', 'San Diego, California'),
(209, 'San Francisco, California', 'San Francisco, California'),
(210, 'San Jose, California', 'San Jose, California'),
(211, 'Santa Ana, California', 'Santa Ana, California'),
(212, 'Santa Clara, California', 'Santa Clara, California'),
(213, 'Santa Clarita, California', 'Santa Clarita, California'),
(214, 'Santa Rosa, California', 'Santa Rosa, California'),
(215, 'Savannah, Georgia', 'Savannah, Georgia'),
(216, 'Scottsdale, Arizona', 'Scottsdale, Arizona'),
(217, 'Seattle, Washington', 'Seattle, Washington'),
(218, 'Shreveport, Louisiana', 'Shreveport, Louisiana'),
(219, 'Simi Valley, California', 'Simi Valley, California'),
(220, 'Sioux Falls, South Dakota', 'Sioux Falls, South Dakota'),
(221, 'South Bend, Indiana', 'South Bend, Indiana'),
(222, 'Spokane, Washington', 'Spokane, Washington'),
(223, 'Springfield, Illinois', 'Springfield, Illinois'),
(224, 'Springfield, Massachusetts', 'Springfield, Massachusetts'),
(225, 'Springfield, Missouri', 'Springfield, Missouri'),
(226, 'St. Louis, Missouri', 'St. Louis, Missouri'),
(227, 'St. Paul, Minnesota', 'St. Paul, Minnesota'),
(228, 'St. Petersburg, Florida', 'St. Petersburg, Florida'),
(229, 'Stamford, Connecticut', 'Stamford, Connecticut'),
(230, 'Sterling Heights, Michigan', 'Sterling Heights, Michigan'),
(231, 'Stockton, California', 'Stockton, California'),
(232, 'Sunnyvale, California', 'Sunnyvale, California'),
(233, 'Syracuse, New York', 'Syracuse, New York'),
(234, 'Tacoma, Washington', 'Tacoma, Washington'),
(235, 'Tallahassee, Florida', 'Tallahassee, Florida'),
(236, 'Tampa, Florida', 'Tampa, Florida'),
(237, 'Tempe, Arizona', 'Tempe, Arizona'),
(238, 'Thornton, Colorado', 'Thornton, Colorado'),
(239, 'Thousand Oaks, California', 'Thousand Oaks, California'),
(240, 'Toledo, Ohio', 'Toledo, Ohio'),
(241, 'Topeka, Kansas', 'Topeka, Kansas'),
(242, 'Torrance, California', 'Torrance, California'),
(243, 'Tucson, Arizona', 'Tucson, Arizona'),
(244, 'Tulsa, Oklahoma', 'Tulsa, Oklahoma'),
(245, 'Vallejo, California', 'Vallejo, California'),
(246, 'Vancouver, Washington', 'Vancouver, Washington'),
(247, 'Victorville, California', 'Victorville, California'),
(248, 'Virginia Beach, Virginia', 'Virginia Beach, Virginia'),
(249, 'Visalia, California', 'Visalia, California'),
(250, 'Waco, Texas', 'Waco, Texas'),
(251, 'Warren, Michigan', 'Warren, Michigan'),
(252, 'Washington, District of Columbia', 'Washington, District of Columbia'),
(253, 'Waterbury, Connecticut', 'Waterbury, Connecticut'),
(254, 'West Covina, California', 'West Covina, California'),
(255, 'West Jordan, Utah', 'West Jordan, Utah'),
(256, 'West Valley, Utah', 'West Valley, Utah'),
(257, 'Westminster, Colorado', 'Westminster, Colorado'),
(258, 'Wichita, Kansas', 'Wichita, Kansas'),
(259, 'Wichita Falls, Texas', 'Wichita Falls, Texas'),
(260, 'Winston-Salem, North Carolina', 'Winston-Salem, North Carolina'),
(261, 'Worcester, Massachusetts', 'Worcester, Massachusetts'),
(262, 'Yonkers, New York', 'Yonkers, New York'),
(263, 'Álava, España', 'Álava, España'),
(264, 'Albacete, España', 'Albacete, España'),
(265, 'Alicante, España', 'Alicante, España'),
(266, 'Almeria, España', 'Almeria, España'),
(267, 'Asturias, España', 'Asturias, España'),
(268, 'Ávila, España', 'Ávila, España'),
(269, 'Badajoz, España', 'Badajoz, España'),
(270, 'Barcelona, España', 'Barcelona, España'),
(271, 'Burgos, España', 'Burgos, España'),
(272, 'Cáceres, España', 'Cáceres, España'),
(273, 'Cádiz, España', 'Cádiz, España'),
(274, 'Cantabria, España', 'Cantabria, España'),
(275, 'Castellòn, España', 'Castellòn, España'),
(276, 'Ciudad Real, España', 'Ciudad Real, España'),
(277, 'Córdoba, España', 'Córdoba, España'),
(278, 'La Coruña, España', 'La Coruña, España'),
(279, 'Cuenca, España', 'Cuenca, España'),
(280, 'Gerona, España', 'Gerona, España'),
(281, 'Granada, España', 'Granada, España'),
(282, 'Guadalajara, España', 'Guadalajara, España'),
(283, 'Guipúzcoa, España', 'Guipúzcoa, España'),
(284, 'Huelva, España', 'Huelva, España'),
(285, 'Huesca, España', 'Huesca, España'),
(286, 'Islas Baleares, España', 'Islas Baleares, España'),
(287, 'Jaén, España', 'Jaén, España'),
(288, 'León, España', 'León, España'),
(289, 'Lérida, España', 'Lérida, España'),
(290, 'Lugo, España', 'Lugo, España'),
(291, 'Madrid, España', 'Madrid, España'),
(292, 'Málaga, España', 'Málaga, España'),
(293, 'Murcia, España', 'Murcia, España'),
(294, 'Navarra, España', 'Navarra, España'),
(295, 'Orense, España', 'Orense, España'),
(296, 'Palencia, España', 'Palencia, España'),
(297, 'Las Palmas, España', 'Las Palmas, España'),
(298, 'Pontevedra, España', 'Pontevedra, España'),
(299, 'La Rioja, España', 'La Rioja, España'),
(300, 'Salamanca, España', 'Salamanca, España'),
(301, 'Segovia, España', 'Segovia, España'),
(302, 'Sevilla, España', 'Sevilla, España'),
(303, 'Soria, España', 'Soria, España'),
(304, 'Tarragona, España', 'Tarragona, España'),
(305, 'Santa Cruz de Tenerife, España', 'Santa Cruz de Tenerife, España'),
(306, 'Teruel, España', 'Teruel, España'),
(307, 'Toledo, España', 'Toledo, España'),
(308, 'Valencia, España', 'Valencia, España'),
(309, 'Valladolid, España', 'Valladolid, España'),
(310, 'Vizcaya, España', 'Vizcaya, España'),
(311, 'Zamora, España', 'Zamora, España'),
(312, 'Zaragoza, España', 'Zaragoza, España'),
(313, 'Paris, France', 'Paris, France'),
(314, 'Marseille, France', 'Marseille, France'),
(315, 'Lyon, France', 'Lyon, France'),
(316, 'Toulouse, France', 'Toulouse, France'),
(317, 'Nice, France', 'Nice, France'),
(318, 'Nantes, France', 'Nantes, France'),
(319, 'Strasbourg, France', 'Strasbourg, France'),
(320, 'Montpellier, France', 'Montpellier, France'),
(321, 'Bordeaux, France', 'Bordeaux, France'),
(322, 'Lille, France', 'Lille, France'),
(323, 'Rennes, France', 'Rennes, France'),
(324, 'Reims, France', 'Reims, France'),
(325, 'Le Havre, France', 'Le Havre, France'),
(326, 'Saint-Etienne, France', 'Saint-Etienne, France'),
(327, 'Toulon, France', 'Toulon, France'),
(328, 'Grenoble, France', 'Grenoble, France'),
(329, 'Angers, France', 'Angers, France'),
(330, 'Dijon, France', ' Dijon, France'),
(331, 'Brest, France', 'Brest, France'),
(332, 'Nimes, France', 'Nimes, France'),
(333, 'Le Mans, France', 'Le Mans, France'),
(334, 'Aix-en-Provence, France', 'Aix-en-Provence, France'),
(335, 'Clermont-Ferrand, France', 'Clermont-Ferrand, France'),
(336, 'Saint-Denis de la Réunion, France', 'Saint-Denis, France'),
(337, 'Amiens, France', 'Amiens, France'),
(338, 'Tours, France', 'Tours, France'),
(339, 'Bath, UK', 'Bath, UK'),
(340, 'Birmingham, UK', 'Birmingham, UK'),
(341, 'Bournemouth, UK', 'Bournemouth, UK'),
(342, 'Bradford, UK', 'Bradford, UK'),
(343, 'Brighton and Hove, UK', 'Brighton and Hove, UK'),
(344, 'Bristol, UK', 'Bristol, UK'),
(345, 'Cambridge, UK', 'Cambridge, UK'),
(346, 'Canterbury, UK', 'Canterbury, UK'),
(347, 'Carlisle, UK', 'Carlisle, UK'),
(348, 'Chester, UK', 'Chester, UK'),
(349, 'Chichester, UK', 'Chichester, UK'),
(350, 'Coventry, UK', 'Coventry, UK'),
(351, 'Derby, UK', 'Derby, UK'),
(352, 'Dudley, UK', 'Dudley, UK'),
(353, 'Durham, UK', 'Durham, UK'),
(354, 'Exeter, UK', 'Exeter, UK'),
(355, 'Gloucester, UK', 'Gloucester, UK'),
(356, 'Hereford, UK', 'Hereford, UK'),
(357, 'Huddersfield, UK', 'Huddersfield, UK'),
(358, 'Kingston upon Hull, UK', 'Kingston upon Hull, UK'),
(359, 'Lancaster, UK', 'Lancaster, UK'),
(360, 'Leeds, UK', 'Leeds, UK'),
(361, 'Leicester, UK', 'Leicester, UK'),
(362, 'Lichfield, UK', 'Lichfield, UK'),
(363, 'Lincoln, UK', 'Lincoln, UK'),
(364, 'Liverpool, UK', 'Liverpool, UK'),
(365, 'London, UK', 'London, UK'),
(366, 'Luton, UK', 'Luton, UK'),
(367, 'Manchester, UK', 'Manchester, UK'),
(368, 'Milton Keynes, UK', 'Milton Keynes, UK'),
(369, 'Newcastle upon Tyne, UK', 'Newcastle upon Tyne, UK'),
(370, 'Northampton, UK', 'Northampton, UK'),
(371, 'Norwich, UK', 'Norwich, UK'),
(372, 'Nottingham, UK', 'Nottingham, UK'),
(373, 'Oxford, UK', 'Oxford, UK'),
(374, 'Peterborough, UK', 'Peterborough, UK'),
(375, 'Plymouth, UK', 'Plymouth, UK'),
(376, 'Portsmouth, UK', 'Portsmouth, UK'),
(377, 'Preston, UK', 'Preston, UK'),
(378, 'Reading, UK', 'Reading, UK'),
(379, 'Ripon, UK', 'Ripon, UK'),
(380, 'Salford, UK', 'Salford, UK'),
(381, 'Salisbury, UK', 'Salisbury, UK'),
(382, 'Swindon, UK', 'Swindon, UK'),
(383, 'Oradea, UK', 'Oradea, UK'),
(384, 'Sheffield, UK', 'Sheffield, UK'),
(385, 'Southampton, UK', 'Southampton, UK'),
(386, 'Southend-on-Sea, UK', 'Southend-on-Sea, UK'),
(387, 'St Albans, UK', 'St Albans, UK'),
(388, 'Stoke-on-Trent, UK', 'Stoke-on-Trent, UK'),
(389, 'Sunderland, UK', 'Sunderland, UK'),
(390, 'Truro, UK', 'Truro, UK'),
(391, 'Wakefield, UK', 'Wakefield, UK'),
(392, 'Walsall, UK', 'Walsall, UK'),
(393, 'Wells, UK', 'Wells, UK'),
(394, 'Westminster, UK', 'Westminster, UK'),
(395, 'Winchester, UK', 'Winchester, UK'),
(396, 'Wolverhampton, UK', 'Wolverhampton, UK'),
(397, 'Worcester, UK', 'Worcester, UK'),
(398, 'York, UK', 'York, UK'),
(399, 'Chieti (CH), Abruzzo, Italy','Chieti (CH), Abruzzo, Italy'),
(400, 'Aquila (AQ), Abruzzo, Italy','Aquila (AQ), Abruzzo, Italy'),
(401, 'Pescara (PE), Abruzzo, Italy','Pescara (PE), Abruzzo, Italy'),
(402, 'Teramo (TE), Abruzzo, Italy','Teramo (TE), Abruzzo, Italy'),
(403, 'Bari (BA), Puglia, Italy','Bari (BA), Puglia, Italy'),
(404, 'Barletta (BT), Puglia, Italy','Barletta (BT), Puglia, Italy'),
(405, 'Brindisi (BR), Puglia, Italy','Brindisi (BR), Puglia, Italy'),
(406, 'Foggia (FG), Puglia, Italy','Foggia (FG), Puglia, Italy'),
(407, 'Lecce (LE), Puglia, Italy','Lecce (LE), Puglia, Italy'),
(408, 'Taranto (TA), Puglia, Italy','Taranto (TA), Puglia, Italy'),
(409, 'Matera (MT), Basilicata, Italy','Matera (MT), Basilicata, Italy'),
(410, 'Potenza (PZ), Basilicata, Italy','Potenza (PZ), Basilicata, Italy'),
(411, 'Catanzaro (CZ), Calabria, Italy','Catanzaro (CZ), Calabria, Italy'),
(412, 'Cosenza (CS), Calabria, Italy','Cosenza (CS), Calabria, Italy'),
(413, 'Crotone (KR), Calabria, Italy','Crotone (KR), Calabria, Italy'),
(414, 'Reggio Calabria (RC), Calabria, Italy','Reggio Calabria (RC), Calabria, Italy'),
(415, 'Vibo Valentia (VV), Calabria, Italy','Vibo Valentia (VV), Calabria, Italy'),
(416, 'Avellino (AV), Campania, Italy','Avellino (AV), Campania, Italy'),
(417, 'Benevento (BN), Campania, Italy','Benevento (BN), Campania, Italy'),
(418, 'Caserta (CE), Campania, Italy','Caserta (CE), Campania, Italy'),
(419, 'Naples (Napoli) (NA), Campania, Italy','Naples (Napoli) (NA), Campania, Italy'),
(420, 'Salerno (SA), Campania, Italy','Salerno (SA), Campania, Italy'),
(421, 'Bologna (BO), Emilia-Romagna, Italy','Bologna (BO), Emilia-Romagna, Italy'),
(422, 'Ferrara (FE), Emilia-Romagna, Italy','Ferrara (FE), Emilia-Romagna, Italy'),
(423, 'Forlì-Cesena (FC), Emilia-Romagna, Italy','Forlì-Cesena (FC), Emilia-Romagna, Italy'),
(424, 'Modena (MO), Emilia-Romagna, Italy','Modena (MO), Emilia-Romagna, Italy'),
(425, 'Parma (PR), Emilia-Romagna, Italy','Parma (PR), Emilia-Romagna, Italy'),
(426, 'Piacenza (PC), Emilia-Romagna, Italy','Piacenza (PC), Emilia-Romagna, Italy'),
(427, 'Ravenna (RA), Emilia-Romagna, Italy','Ravenna (RA), Emilia-Romagna, Italy'),
(428, 'Reggio Emilia (RE), Emilia-Romagna, Italy','Reggio Emilia (RE), Emilia-Romagna, Italy'),
(429, 'Rimini (RN), Emilia-Romagna, Italy','Rimini (RN), Emilia-Romagna, Italy'),
(430, 'Gorizia (GO), Friuli-Venezia, Italy','Gorizia (GO), Friuli-Venezia, Italy'),
(431, 'Pordenone (PN), Friuli-Venezia, Italy','Pordenone (PN), Friuli-Venezia, Italy'),
(432, 'Trieste (TS), Friuli-Venezia, Italy','Trieste (TS), Friuli-Venezia, Italy'),
(433, 'Udine (UD), Friuli-Venezia, Italy','Udine (UD), Friuli-Venezia, Italy'),
(434, 'Frosinone (FR), Lazio, Italy','Frosinone (FR), Lazio, Italy'),
(435, 'Latina (LT), Lazio, Italy','Latina (LT), Lazio, Italy'),
(436, 'Rieti (RI), Lazio, Italy','Rieti (RI), Lazio, Italy'),
(437, 'Rome (Roma) (RM), Lazio, Italy','Rome (Roma) (RM), Lazio, Italy'),
(438, 'Viterbo (VT), Lazio, Italy','Viterbo (VT), Lazio, Italy'),
(439, 'Genoa (Genova) (GE), Liguria, Italy','Genoa (Genova) (GE), Liguria, Italy'),
(440, 'Imperia (IM), Liguria, Italy','Imperia (IM), Liguria, Italy'),
(441, 'La Spezia (SP), Liguria, Italy','La Spezia (SP), Liguria, Italy'),
(442, 'Savona (SV), Liguria, Italy','Savona (SV), Liguria, Italy'),
(443, 'Bergamo (BG), Lombardia, Italy','Bergamo (BG), Lombardia, Italy'),
(444, 'Brescia (BS), Lombardia, Italy','Brescia (BS), Lombardia, Italy'),
(445, 'Como (CO), Lombardia, Italy','Como (CO), Lombardia, Italy'),
(446, 'Cremona (CR), Lombardia, Italy','Cremona (CR), Lombardia, Italy'),
(447, 'Lecco (LC), Lombardia, Italy','Lecco (LC), Lombardia, Italy'),
(448, 'Lodi (LO), Lombardia, Italy','Lodi (LO), Lombardia, Italy'),
(449, 'Mantua (Mantova) (MN), Lombardia, Italy','Mantua (Mantova) (MN), Lombardia, Italy'),
(450, 'Milan (Milano) (MI), Lombardia, Italy','Milan (Milano) (MI), Lombardia, Italy'),
(451, 'Monza and Brianza (MB), Lombardia, Italy','Monza and Brianza (MB), Lombardia, Italy'),
(452, 'Pavia (PV), Lombardia, Italy','Pavia (PV), Lombardia, Italy'),
(453, 'Sondrio (SO), Lombardia, Italy','Sondrio (SO), Lombardia, Italy'),
(454, 'Varese (VA), Lombardia, Italy','Varese (VA), Lombardia, Italy'),
(455, 'Ancona (AN), Marche, Italy','Ancona (AN), Marche, Italy'),
(456, 'Ascoli Piceno (AP), Marche, Italy','Ascoli Piceno (AP), Marche, Italy'),
(457, 'Fermo (FM), Marche, Italy','Fermo (FM), Marche, Italy'),
(458, 'Macerata (MC), Marche, Italy','Macerata (MC), Marche, Italy'),
(459, 'Pesaro and Urbino (PU), Marche, Italy','Pesaro and Urbino (PU), Marche, Italy'),
(460, 'Campobasso (CB), Molise, Italy','Campobasso (CB), Molise, Italy'),
(461, 'Isernia (IS), Molise, Italy','Isernia (IS), Molise, Italy'),
(462, 'Alessandria (AL), Piemonte, Italy','Alessandria (AL), Piemonte, Italy'),
(463, 'Asti (AT), Piemonte, Italy','Asti (AT), Piemonte, Italy'),
(464, 'Biella (BI), Piemonte, Italy','Biella (BI), Piemonte, Italy'),
(465, 'Cuneo (CN), Piemonte, Italy','Cuneo (CN), Piemonte, Italy'),
(466, 'Novara (NO), Piemonte, Italy','Novara (NO), Piemonte, Italy'),
(467, 'Turin (Torino) (TO), Piemonte, Italy','Turin (Torino) (TO), Piemonte, Italy'),
(468, 'Verbano-Cusio-Ossola (VB), Piemonte, Italy','Verbano-Cusio-Ossola (VB), Piemonte, Italy'),
(469, 'Vercelli (VC), Piemonte, Italy','Vercelli (VC), Piemonte, Italy'),
(470, 'Cagliari (CA), Sardinia, Italy','Cagliari (CA), Sardinia, Italy'),
(471, 'Carbonia-Iglesias (CI), Sardinia, Italy','Carbonia-Iglesias (CI), Sardinia, Italy'),
(472, 'Medio Campidano (VS), Sardinia, Italy','Medio Campidano (VS), Sardinia, Italy'),
(473, 'Nuoro (NU), Sardinia, Italy','Nuoro (NU), Sardinia, Italy'),
(474, 'Ogliastra (OG), Sardinia, Italy','Ogliastra (OG), Sardinia, Italy'),
(475, 'Olbia-Tempio (OT), Sardinia, Italy','Olbia-Tempio (OT), Sardinia, Italy'),
(476, 'Oristano (OR), Sardinia, Italy','Oristano (OR), Sardinia, Italy'),
(477, 'Sassari (SS), Sardinia, Italy','Sassari (SS), Sardinia, Italy'),
(478, 'Agrigento (AG), Sicily, Italy','Agrigento (AG), Sicily, Italy'),
(479, 'Caltanissetta (CL), Sicily, Italy','Caltanissetta (CL), Sicily, Italy'),
(480, 'Catania (CT), Sicily, Italy','Catania (CT), Sicily, Italy'),
(481, 'Enna (EN), Sicily, Italy','Enna (EN), Sicily, Italy'),
(482, 'Messina (ME), Sicily, Italy','Messina (ME), Sicily, Italy'),
(483, 'Palermo (PA), Sicily, Italy','Palermo (PA), Sicily, Italy'),
(484, 'Ragusa (RG), Sicily, Italy','Ragusa (RG), Sicily, Italy'),
(485, 'Syracuse (Siracusa) (SR), Sicily, Italy','Syracuse (Siracusa) (SR), Sicily, Italy'),
(486, 'Trapani (TP), Sicily, Italy','Trapani (TP), Sicily, Italy'),
(487, 'Bolzano-Bozen (BZ), Trentino-Alto Adige, Italy','Bolzano-Bozen (BZ), Trentino-Alto Adige, Italy'),
(488, 'Trento (Trentino) (TN), Trentino-Alto Adige, Italy','Trento (Trentino) (TN), Trentino-Alto Adige, Italy'),
(489, 'Arezzo (AR), Tuscany, Italy','Arezzo (AR), Tuscany, Italy'),
(490, 'Florence (Firenze) (FI), Tuscany, Italy','Florence (Firenze) (FI), Tuscany, Italy'),
(491, 'Grosseto (GR), Tuscany, Italy','Grosseto (GR), Tuscany, Italy'),
(492, 'Leghorn (Livorno) (LI), Tuscany, Italy','Leghorn (Livorno) (LI), Tuscany, Italy'),
(493, 'Lucca (LU), Tuscany, Italy','Lucca (LU), Tuscany, Italy'),
(494, 'Massa-Carrara (MS), Tuscany, Italy','Massa-Carrara (MS), Tuscany, Italy'),
(495, 'Pisa (PI), Tuscany, Italy','Pisa (PI), Tuscany, Italy'),
(496, 'Pistoia (PT), Tuscany, Italy','Pistoia (PT), Tuscany, Italy'),
(497, 'Prato (PO), Tuscany, Italy','Prato (PO), Tuscany, Italy'),
(498, 'Siena (SI), Tuscany, Italy','Siena (SI), Tuscany, Italy'),
(499, 'Perugia (PG), Umbria, Italy','Perugia (PG), Umbria, Italy'),
(500, 'Terni (TR), Umbria, Italy','Terni (TR), Umbria, Italy'),
(501, 'Belluno (BL), Veneto, Italy','Belluno (BL), Veneto, Italy'),
(502, 'Padova (PD), Veneto, Italy','Padova (PD), Veneto, Italy'),
(503, 'Rovigo (RO), Veneto, Italy','Rovigo (RO), Veneto, Italy'),
(504, 'Treviso (TV), Veneto, Italy','Treviso (TV), Veneto, Italy'),
(505, 'Venice (Venezia) (VE), Veneto, Italy','Venice (Venezia) (VE), Veneto, Italy'),
(506, 'Verona (VR), Veneto, Italy','Verona (VR), Veneto, Italy'),
(507, 'Vicenza (VI), Veneto, Italy','Vicenza (VI), Veneto, Italy');