-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jun 14, 2025 at 03:17 AM
-- Server version: 10.11.10-MariaDB-log
-- PHP Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;


-- --------------------------------------------------------

--
-- Table structure for table `tblDistrict`
--

CREATE TABLE `tblDistrict` (
  `id` int(11) NOT NULL COMMENT 'Primary Key',
  `County` char(24) NOT NULL COMMENT 'County Name',
  `District` char(26) NOT NULL COMMENT 'District Name'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Registration Districts Within Counties';

--
-- Dumping data for table `tblDistrict`
--

INSERT INTO `tblDistrict` (`id`, `County`, `District`) VALUES
(1, 'Bedfordshire', 'Ampthill'),
(2, 'Bedfordshire', 'Bedford'),
(3, 'Bedfordshire', 'Biggleswade'),
(4, 'Bedfordshire', 'Hitchin'),
(5, 'Bedfordshire', 'Leighton Buzzard'),
(6, 'Bedfordshire', 'Luton'),
(7, 'Bedfordshire', 'St.Neots'),
(8, 'Bedfordshire', 'Wellingborough'),
(9, 'Bedfordshire', 'Woburn'),
(10, 'Berkshire', 'Abingdon'),
(11, 'Berkshire', 'Basingstoke'),
(12, 'Berkshire', 'Bradfield'),
(13, 'Berkshire', 'Cookham'),
(14, 'Berkshire', 'Easthampstead'),
(15, 'Berkshire', 'Faringdon'),
(16, 'Berkshire', 'Henley'),
(17, 'Berkshire', 'Highworth'),
(18, 'Berkshire', 'Hungerford'),
(19, 'Berkshire', 'Maidenhead'),
(20, 'Berkshire', 'Newbury'),
(21, 'Berkshire', 'Oxford'),
(22, 'Berkshire', 'Reading'),
(23, 'Berkshire', 'Stow on the Wold'),
(24, 'Berkshire', 'Wallingford'),
(25, 'Berkshire', 'Wantage'),
(26, 'Berkshire', 'Windsor'),
(27, 'Berkshire', 'Witney'),
(28, 'Berkshire', 'Wokingham'),
(29, 'Buckinghamshire', 'Amersham'),
(30, 'Buckinghamshire', 'Aylesbury'),
(31, 'Buckinghamshire', 'Berkhampstead'),
(32, 'Buckinghamshire', 'Bicester'),
(33, 'Buckinghamshire', 'Brackley'),
(34, 'Buckinghamshire', 'Buckingham'),
(35, 'Buckinghamshire', 'Eton'),
(36, 'Buckinghamshire', 'Headington'),
(37, 'Buckinghamshire', 'Henley'),
(38, 'Buckinghamshire', 'Leighton Buzzard'),
(39, 'Buckinghamshire', 'Newport Pagnell'),
(40, 'Buckinghamshire', 'Potterspury'),
(41, 'Buckinghamshire', 'Thame'),
(42, 'Buckinghamshire', 'Winslow'),
(43, 'Buckinghamshire', 'Wycombe'),
(44, 'Cambridgeshire', 'Cambridge'),
(45, 'Cambridgeshire', 'Caxton'),
(46, 'Cambridgeshire', 'Chesterton'),
(47, 'Cambridgeshire', 'Downham'),
(48, 'Cambridgeshire', 'Ely'),
(49, 'Cambridgeshire', 'Linton'),
(50, 'Cambridgeshire', 'Newmarket'),
(51, 'Cambridgeshire', 'North Witchford'),
(52, 'Cambridgeshire', 'Peterborough'),
(53, 'Cambridgeshire', 'Risbridge'),
(54, 'Cambridgeshire', 'Royston'),
(55, 'Cambridgeshire', 'St.Ives'),
(56, 'Cambridgeshire', 'St.Neots'),
(57, 'Cambridgeshire', 'Whittlesey'),
(58, 'Cambridgeshire', 'Wisbech'),
(59, 'Cheshire', 'Altrincham'),
(60, 'Cheshire', 'Ashton & Oldham'),
(61, 'Cheshire', 'Ashton under Lyne'),
(62, 'Cheshire', 'Birkenhead'),
(63, 'Cheshire', 'Bucklow'),
(64, 'Cheshire', 'Chester'),
(65, 'Cheshire', 'Congleton'),
(66, 'Cheshire', 'Great Boughton'),
(67, 'Cheshire', 'Heyfield'),
(68, 'Cheshire', 'High Peak'),
(69, 'Cheshire', 'Macclesfield'),
(70, 'Cheshire', 'Market Drayton'),
(71, 'Cheshire', 'Nantwich'),
(72, 'Cheshire', 'Northwich'),
(73, 'Cheshire', 'Runcorn'),
(74, 'Cheshire', 'Stockport'),
(75, 'Cheshire', 'Wallasey'),
(76, 'Cheshire', 'Whitchurch'),
(77, 'Cheshire', 'Wirral'),
(78, 'Cheshire', 'Wrexham'),
(79, 'Cornwall', 'Bodmin'),
(80, 'Cornwall', 'Camelford'),
(81, 'Cornwall', 'Falmouth'),
(82, 'Cornwall', 'Helston'),
(83, 'Cornwall', 'Holsworthy'),
(84, 'Cornwall', 'Isles of Scilly'),
(85, 'Cornwall', 'Launceston'),
(86, 'Cornwall', 'Liskeard'),
(87, 'Cornwall', 'Penzance'),
(88, 'Cornwall', 'Redruth'),
(89, 'Cornwall', 'St.Austell'),
(90, 'Cornwall', 'St.Columb'),
(91, 'Cornwall', 'St.Germans'),
(92, 'Cornwall', 'Scilly Islands'),
(93, 'Cornwall', 'Stratton'),
(94, 'Cornwall', 'Tavistock'),
(95, 'Cornwall', 'Truro'),
(96, 'Cumberland', 'Alston'),
(97, 'Cumberland', 'Bootle'),
(98, 'Cumberland', 'Brampton'),
(99, 'Cumberland', 'Carlisle'),
(100, 'Cumberland', 'Cockermouth'),
(101, 'Cumberland', 'Longtown'),
(102, 'Cumberland', 'Millom'),
(103, 'Cumberland', 'Penrith'),
(104, 'Cumberland', 'Whiteheaven'),
(105, 'Cumberland', 'Wigton'),
(106, 'Derbyshire', 'Ashbourne'),
(107, 'Derbyshire', 'Ashby de la Zouch'),
(108, 'Derbyshire', 'Bakewell'),
(109, 'Derbyshire', 'Basford'),
(110, 'Derbyshire', 'Belper'),
(111, 'Derbyshire', 'Burton upon Trent'),
(112, 'Derbyshire', 'Chapel en le Frith'),
(113, 'Derbyshire', 'Chesterfield'),
(114, 'Derbyshire', 'Derby'),
(115, 'Derbyshire', 'Ecclesall Bierlow'),
(116, 'Derbyshire', 'Glossop'),
(117, 'Derbyshire', 'Hayfield'),
(118, 'Derbyshire', 'High Peak'),
(119, 'Derbyshire', 'Mansfield'),
(120, 'Derbyshire', 'Matlock'),
(121, 'Derbyshire', 'Repton'),
(122, 'Derbyshire', 'Rotherham'),
(123, 'Derbyshire', 'Shardlow'),
(124, 'Derbyshire', 'Tamworth'),
(125, 'Derbyshire', 'Uttoxeter'),
(126, 'Derbyshire', 'Worksop'),
(127, 'Devon', 'Axminster'),
(128, 'Devon', 'Barnstaple'),
(129, 'Devon', 'Bideford'),
(130, 'Devon', 'Chard'),
(131, 'Devon', 'Crediton'),
(132, 'Devon', 'Devonport'),
(133, 'Devon', 'Dulverton'),
(134, 'Devon', 'East Stonehouse'),
(135, 'Devon', 'Exeter'),
(136, 'Devon', 'Holsworthy'),
(137, 'Devon', 'Honiton'),
(138, 'Devon', 'Kingsbridge'),
(139, 'Devon', 'Launceston'),
(140, 'Devon', 'Newton Abbot'),
(141, 'Devon', 'Okehampton'),
(142, 'Devon', 'Plymouth'),
(143, 'Devon', 'Plympton St.Mary'),
(144, 'Devon', 'St.Germans'),
(145, 'Devon', 'St.Thomas'),
(146, 'Devon', 'South Molton'),
(147, 'Devon', 'Stoke Damerel'),
(148, 'Devon', 'Taunton'),
(149, 'Devon', 'Tavistock'),
(150, 'Devon', 'Tiverton'),
(151, 'Devon', 'Torrington'),
(152, 'Devon', 'Totnes'),
(153, 'Devon', 'Wellington'),
(154, 'Dorset', 'Axminster'),
(155, 'Dorset', 'Beaminster'),
(156, 'Dorset', 'Blandford'),
(157, 'Dorset', 'Bridport'),
(158, 'Dorset', 'Cerne'),
(159, 'Dorset', 'Chard'),
(160, 'Dorset', 'Dorchester'),
(161, 'Dorset', 'Mere'),
(162, 'Dorset', 'Poole'),
(163, 'Dorset', 'Shaftesbury'),
(164, 'Dorset', 'Sherborne'),
(165, 'Dorset', 'Sturminster'),
(166, 'Dorset', 'Wareham'),
(167, 'Dorset', 'Weymouth'),
(168, 'Dorset', 'Wimborne'),
(169, 'Dorset', 'Wincanton'),
(170, 'Durham', 'Auckland'),
(171, 'Durham', 'Belford'),
(172, 'Durham', 'Berwick'),
(173, 'Durham', 'Chester le Street'),
(174, 'Durham', 'Darlington'),
(175, 'Durham', 'Durham'),
(176, 'Durham', 'Easington'),
(177, 'Durham', 'Easingwold'),
(178, 'Durham', 'Gateshead'),
(179, 'Durham', 'Hartlepool'),
(180, 'Durham', 'Houghton le Spring'),
(181, 'Durham', 'Lanchester'),
(182, 'Durham', 'Morpeth'),
(183, 'Durham', 'Sedgefield'),
(184, 'Durham', 'South Shields'),
(185, 'Durham', 'Stockton'),
(186, 'Durham', 'Sunderland'),
(187, 'Durham', 'Teesdale'),
(188, 'Durham', 'Weardale'),
(189, 'Essex', 'Billericay'),
(190, 'Essex', 'Bishps Stortford'),
(191, 'Essex', 'Braintree'),
(192, 'Essex', 'Chelmsford'),
(193, 'Essex', 'Colchester'),
(194, 'Essex', 'Dunmow'),
(195, 'Essex', 'Edmonton'),
(196, 'Essex', 'Epping'),
(197, 'Essex', 'Halstead'),
(198, 'Essex', 'Lexden'),
(199, 'Essex', 'Linton'),
(200, 'Essex', 'Maldon'),
(201, 'Essex', 'Ongar'),
(202, 'Essex', 'Orsett'),
(203, 'Essex', 'Risbridge'),
(204, 'Essex', 'Rochford'),
(205, 'Essex', 'Romford'),
(206, 'Essex', 'Royston'),
(207, 'Essex', 'Saffron Walden'),
(208, 'Essex', 'Sudbury'),
(209, 'Essex', 'Tendring'),
(210, 'Essex', 'West Ham'),
(211, 'Essex', 'Witham'),
(212, 'Gloucestershire', 'Banbury'),
(213, 'Gloucestershire', 'Barton Regis'),
(214, 'Gloucestershire', 'Bedminster'),
(215, 'Gloucestershire', 'Bristol'),
(216, 'Gloucestershire', 'Cheltenham'),
(217, 'Gloucestershire', 'Chepstow'),
(218, 'Gloucestershire', 'Chipping Norton'),
(219, 'Gloucestershire', 'Chipping Sodbury'),
(220, 'Gloucestershire', 'Cirencester'),
(221, 'Gloucestershire', 'Clifton'),
(222, 'Gloucestershire', 'Dursley'),
(223, 'Gloucestershire', 'Evesham'),
(224, 'Gloucestershire', 'Faringdon'),
(225, 'Gloucestershire', 'Gloucester'),
(226, 'Gloucestershire', 'Keynsham'),
(227, 'Gloucestershire', 'Malmesbury'),
(228, 'Gloucestershire', 'Monmouth'),
(229, 'Gloucestershire', 'Newent'),
(230, 'Gloucestershire', 'Northleach'),
(231, 'Gloucestershire', 'Ross'),
(232, 'Gloucestershire', 'Shipston on Stour'),
(233, 'Gloucestershire', 'Stow on the Wold'),
(234, 'Gloucestershire', 'Stratford on Avon'),
(235, 'Gloucestershire', 'Stroud'),
(236, 'Gloucestershire', 'Tetbury'),
(237, 'Gloucestershire', 'Tewkesbury'),
(238, 'Gloucestershire', 'Thornbury'),
(239, 'Gloucestershire', 'Westbury on Severn'),
(240, 'Gloucestershire', 'Wheatenhurst'),
(241, 'Gloucestershire', 'Winchcomb'),
(242, 'Gloucestershire', 'Witney'),
(243, 'Hampshire', 'Alresford'),
(244, 'Hampshire', 'Alton'),
(245, 'Hampshire', 'Alverstoke'),
(246, 'Hampshire', 'Andover'),
(247, 'Hampshire', 'Basingstoke'),
(248, 'Hampshire', 'Bradfield'),
(249, 'Hampshire', 'Catherington'),
(250, 'Hampshire', 'Christchurch'),
(251, 'Hampshire', 'Droxford'),
(252, 'Hampshire', 'Fareham'),
(253, 'Hampshire', 'Farnborough'),
(254, 'Hampshire', 'Farnham'),
(255, 'Hampshire', 'Fordingbridge'),
(256, 'Hampshire', 'Hartley Wintney'),
(257, 'Hampshire', 'Havant'),
(258, 'Hampshire', 'Hursley'),
(259, 'Hampshire', 'Hungerford'),
(260, 'Hampshire', 'Isle of Wight'),
(261, 'Hampshire', 'Kingsclere'),
(262, 'Hampshire', 'Lymington'),
(263, 'Hampshire', 'Midhurst'),
(264, 'Hampshire', 'Newbury'),
(265, 'Hampshire', 'New Forest'),
(266, 'Hampshire', 'Petersfield'),
(267, 'Hampshire', 'Portsea Island'),
(268, 'Hampshire', 'Portsmouth'),
(269, 'Hampshire', 'Ringwood'),
(270, 'Hampshire', 'Romsey'),
(271, 'Hampshire', 'Southampton'),
(272, 'Hampshire', 'South Stoneham'),
(273, 'Hampshire', 'Stockbridge'),
(274, 'Hampshire', 'Whitchurch'),
(275, 'Hampshire', 'Winchester'),
(276, 'Herefordshire', 'Abergavenny'),
(277, 'Herefordshire', 'Bromyard'),
(278, 'Herefordshire', 'Cleobury Mortimer'),
(279, 'Herefordshire', 'Dore'),
(280, 'Herefordshire', 'Hay'),
(281, 'Herefordshire', 'Hereford'),
(282, 'Herefordshire', 'Kington'),
(283, 'Herefordshire', 'Knighton'),
(284, 'Herefordshire', 'Ledbury'),
(285, 'Herefordshire', 'Leominster'),
(286, 'Herefordshire', 'Ludlow'),
(287, 'Herefordshire', 'Monmouth'),
(288, 'Herefordshire', 'Newent'),
(289, 'Herefordshire', 'Presteigne'),
(290, 'Herefordshire', 'Ross'),
(291, 'Herefordshire', 'Tenbury'),
(292, 'Herefordshire', 'Weobley'),
(293, 'Hertfordshire', 'Amersham'),
(294, 'Hertfordshire', 'Barnet'),
(295, 'Hertfordshire', 'Berkhamstead'),
(296, 'Hertfordshire', 'Biggleswade'),
(297, 'Hertfordshire', 'Bishops Stortford'),
(298, 'Hertfordshire', 'Buntingford'),
(299, 'Hertfordshire', 'Edmonton'),
(300, 'Hertfordshire', 'Hatfield'),
(301, 'Hertfordshire', 'Hemel Hempstead'),
(302, 'Hertfordshire', 'Hertford'),
(303, 'Hertfordshire', 'Hitchin'),
(304, 'Hertfordshire', 'Luton'),
(305, 'Hertfordshire', 'Royston'),
(306, 'Hertfordshire', 'St.Albans'),
(307, 'Hertfordshire', 'Ware'),
(308, 'Hertfordshire', 'Watford'),
(309, 'Huntingdonshire', 'Caxton'),
(310, 'Huntingdonshire', 'Huntingdon'),
(311, 'Huntingdonshire', 'Oundle'),
(312, 'Huntingdonshire', 'St.Ives'),
(313, 'Huntingdonshire', 'St.Neots'),
(314, 'Huntingdonshire', 'Stamford'),
(315, 'Huntingdonshire', 'Thrapston'),
(316, 'Kent', 'Blean'),
(317, 'Kent', 'Bridge'),
(318, 'Kent', 'Bromley'),
(319, 'Kent', 'Canterbury'),
(320, 'Kent', 'Cranbrook'),
(321, 'Kent', 'Croydon'),
(322, 'Kent', 'Dartford'),
(323, 'Kent', 'Dover'),
(324, 'Kent', 'East Ashford'),
(325, 'Kent', 'Eastry'),
(326, 'Kent', 'Elham'),
(327, 'Kent', 'Faversham'),
(328, 'Kent', 'Gravesend'),
(329, 'Kent', 'Greenwich'),
(330, 'Kent', 'Hollingbourne'),
(331, 'Kent', 'Hoo'),
(332, 'Kent', 'Lewisham'),
(333, 'Kent', 'Maidstone'),
(334, 'Kent', 'Malling'),
(335, 'Kent', 'Medway'),
(336, 'Kent', 'Milton'),
(337, 'Kent', 'North Aylesford'),
(338, 'Kent', 'Romney Marsh'),
(339, 'Kent', 'Rye'),
(340, 'Kent', 'Sevenoaks'),
(341, 'Kent', 'Sheppey'),
(342, 'Kent', 'Sidcup'),
(343, 'Kent', 'Strood'),
(344, 'Kent', 'Tenterden'),
(345, 'Kent', 'Thanet'),
(346, 'Kent', 'Ticehurst'),
(347, 'Kent', 'Tonbridge'),
(348, 'Kent', 'West Ashford'),
(349, 'Kent', 'Woolwich'),
(350, 'Lancashire', 'Ashton & Oldham'),
(351, 'Lancashire', 'Ashton under Lyne'),
(352, 'Lancashire', 'Barrow in Furness'),
(353, 'Lancashire', 'Barton upon Irwell'),
(354, 'Lancashire', 'Barton, Worsley & Flixton'),
(355, 'Lancashire', 'Blackburn'),
(356, 'Lancashire', 'Bolton'),
(357, 'Lancashire', 'Burnley'),
(358, 'Lancashire', 'Bury'),
(359, 'Lancashire', 'Chorley'),
(360, 'Lancashire', 'Chorlton'),
(361, 'Lancashire', 'Clitheroe'),
(362, 'Lancashire', 'Fylde'),
(363, 'Lancashire', 'Garstang'),
(364, 'Lancashire', 'Haslingden'),
(365, 'Lancashire', 'Kendal'),
(366, 'Lancashire', 'Lancaster'),
(367, 'Lancashire', 'Leigh'),
(368, 'Lancashire', 'Liverpool'),
(369, 'Lancashire', 'Lunesdale'),
(370, 'Lancashire', 'Manchester'),
(371, 'Lancashire', 'Oldham'),
(372, 'Lancashire', 'Ormskirk'),
(373, 'Lancashire', 'Prescot'),
(374, 'Lancashire', 'Preston'),
(375, 'Lancashire', 'Prestwich'),
(376, 'Lancashire', 'Rochdale'),
(377, 'Lancashire', 'Saddleworth'),
(378, 'Lancashire', 'Salford'),
(379, 'Lancashire', 'Stockport'),
(380, 'Lancashire', 'Todmorden'),
(381, 'Lancashire', 'Toxteth Park'),
(382, 'Lancashire', 'Ulveston'),
(383, 'Lancashire', 'Warrington'),
(384, 'Lancashire', 'West Derby'),
(385, 'Lancashire', 'Wigan'),
(386, 'Lancashire', 'Worsley'),
(387, 'Leicestershire', 'Ashby de la Zouch'),
(388, 'Leicestershire', 'Atherstone'),
(389, 'Leicestershire', 'Barrow upon Soar'),
(390, 'Leicestershire', 'Billesdon'),
(391, 'Leicestershire', 'Bingham'),
(392, 'Leicestershire', 'Blaby'),
(393, 'Leicestershire', 'Grantham'),
(394, 'Leicestershire', 'Hinckley'),
(395, 'Leicestershire', 'Leicester'),
(396, 'Leicestershire', 'Loughborough'),
(397, 'Leicestershire', 'Lutterworth'),
(398, 'Leicestershire', 'Market Bosworth'),
(399, 'Leicestershire', 'Market Harborough'),
(400, 'Leicestershire', 'Melton Mowbray'),
(401, 'Leicestershire', 'Nuneaton'),
(402, 'Leicestershire', 'Oakham'),
(403, 'Leicestershire', 'Rugby'),
(404, 'Leicestershire', 'Shardlow'),
(405, 'Leicestershire', 'Uppingham'),
(406, 'Lincolnshire', 'Boston'),
(407, 'Lincolnshire', 'Bourne'),
(408, 'Lincolnshire', 'Caister'),
(409, 'Lincolnshire', 'Doncaster'),
(410, 'Lincolnshire', 'Gainsborough'),
(411, 'Lincolnshire', 'Glanford Brigg'),
(412, 'Lincolnshire', 'Goole'),
(413, 'Lincolnshire', 'Grantham'),
(414, 'Lincolnshire', 'Grimsby'),
(415, 'Lincolnshire', 'Holbeach'),
(416, 'Lincolnshire', 'Horncastle'),
(417, 'Lincolnshire', 'Lincoln'),
(418, 'Lincolnshire', 'Louth'),
(419, 'Lincolnshire', 'Newark'),
(420, 'Lincolnshire', 'Peterborough'),
(421, 'Lincolnshire', 'Sleaford'),
(422, 'Lincolnshire', 'Spalding'),
(423, 'Lincolnshire', 'Spilsby'),
(424, 'Lincolnshire', 'Stamford'),
(425, 'Lincolnshire', 'Thorne'),
(426, 'London', 'Bethnal Green'),
(427, 'London', 'Bishopsgate'),
(428, 'London', 'Camberwell'),
(429, 'London', 'Chelsea'),
(430, 'London', 'East London'),
(431, 'London', 'Farringdon'),
(432, 'London', 'Fulham'),
(433, 'London', 'Greenwich'),
(434, 'London', 'Hackney'),
(435, 'London', 'Hampstead'),
(436, 'London', 'Holborn'),
(437, 'London', 'Islington'),
(438, 'London', 'Kensington'),
(439, 'London', 'Lambeth'),
(440, 'London', 'Lewisham'),
(441, 'London', 'London City'),
(442, 'London', 'Marylebone'),
(443, 'London', 'Mile End Old Town'),
(444, 'London', 'Paddington'),
(445, 'London', 'Pancras'),
(446, 'London', 'Poplar'),
(447, 'London', 'St.George Hanover Square'),
(448, 'London', 'St.George in the East'),
(449, 'London', 'St.Giles'),
(450, 'London', 'St.Martin'),
(451, 'London', 'St.Marylebone'),
(452, 'London', 'St.Olave (Bermondsey)'),
(453, 'London', 'St.Olave Southwark'),
(454, 'London', 'St.Pancras'),
(455, 'London', 'St.Saviour Southwark'),
(456, 'London', 'Shoreditch'),
(457, 'London', 'Southwark'),
(458, 'London', 'Stepney'),
(459, 'London', 'Strand'),
(460, 'London', 'Wandsworth'),
(461, 'London', 'West London'),
(462, 'London', 'Westminster'),
(463, 'London', 'Whitechapel'),
(464, 'London', 'Woolwich'),
(465, 'Middlesex', 'Barnet'),
(466, 'Middlesex', 'Bethnal Green'),
(467, 'Middlesex', 'Bishopsgate'),
(468, 'Middlesex', 'Brentford'),
(469, 'Middlesex', 'Chelsea'),
(470, 'Middlesex', 'Clerkenwell'),
(471, 'Middlesex', 'East London'),
(472, 'Middlesex', 'Edmonton'),
(473, 'Middlesex', 'Fulham'),
(474, 'Middlesex', 'Hackney'),
(475, 'Middlesex', 'Hampstead'),
(476, 'Middlesex', 'Hendon'),
(477, 'Middlesex', 'Holborn'),
(478, 'Middlesex', 'Islington'),
(479, 'Middlesex', 'Kensington'),
(480, 'Middlesex', 'Kingston'),
(481, 'Middlesex', 'London City'),
(482, 'Middlesex', 'Marylebone'),
(483, 'Middlesex', 'Mile End Old Town'),
(484, 'Middlesex', 'Pancras'),
(485, 'Middlesex', 'Poplar'),
(486, 'Middlesex', 'St.George Hanover Square'),
(487, 'Middlesex', 'St.George in the East'),
(488, 'Middlesex', 'St.Giles'),
(489, 'Middlesex', 'St.James Westminster'),
(490, 'Middlesex', 'St.Luke'),
(491, 'Middlesex', 'St.Martin in the Fields'),
(492, 'Middlesex', 'Shoreditch'),
(493, 'Middlesex', 'Staines'),
(494, 'Middlesex', 'Stepney'),
(495, 'Middlesex', 'Strand'),
(496, 'Middlesex', 'Uxbridge'),
(497, 'Middlesex', 'Westminster'),
(498, 'Middlesex', 'Westminster St.Margaret'),
(499, 'Middlesex', 'Whitechapel'),
(500, 'Middlesex', 'Willesden'),
(501, 'Norfolk', 'Aylsham'),
(502, 'Norfolk', 'Blofield'),
(503, 'Norfolk', 'Depwade'),
(504, 'Norfolk', 'Docking'),
(505, 'Norfolk', 'Downham'),
(506, 'Norfolk', 'Ely'),
(507, 'Norfolk', 'Erpingham'),
(508, 'Norfolk', 'Flegg'),
(509, 'Norfolk', 'Forehoe'),
(510, 'Norfolk', 'Freebridge Lynn'),
(511, 'Norfolk', 'Guiltcross'),
(512, 'Norfolk', 'Henstead'),
(513, 'Norfolk', 'Holbeach'),
(514, 'Norfolk', 'Hoxne'),
(515, 'Norfolk', 'Kings Lynn'),
(516, 'Norfolk', 'Loddon'),
(517, 'Norfolk', 'Mitford'),
(518, 'Norfolk', 'Mutford'),
(519, 'Norfolk', 'Norwich'),
(520, 'Norfolk', 'St.Faiths'),
(521, 'Norfolk', 'Smallburgh'),
(522, 'Norfolk', 'Swaffham'),
(523, 'Norfolk', 'Thetford'),
(524, 'Norfolk', 'Walsingham'),
(525, 'Norfolk', 'Wayland'),
(526, 'Norfolk', 'Wisbech'),
(527, 'Norfolk', 'Yarmouth'),
(528, 'Northamptonshire', 'Banbury'),
(529, 'Northamptonshire', 'Brackley'),
(530, 'Northamptonshire', 'Brixworth'),
(531, 'Northamptonshire', 'Daventry'),
(532, 'Northamptonshire', 'Hardingstone'),
(533, 'Northamptonshire', 'Kettering'),
(534, 'Northamptonshire', 'Lutterworth'),
(535, 'Northamptonshire', 'Market Harborough'),
(536, 'Northamptonshire', 'Newport Pagnell'),
(537, 'Northamptonshire', 'Northampton'),
(538, 'Northamptonshire', 'Oundle'),
(539, 'Northamptonshire', 'Peterborough'),
(540, 'Northamptonshire', 'Potterspury'),
(541, 'Northamptonshire', 'Rugby'),
(542, 'Northamptonshire', 'Southam'),
(543, 'Northamptonshire', 'Stamford'),
(544, 'Northamptonshire', 'Thrapston'),
(545, 'Northamptonshire', 'Towcester'),
(546, 'Northamptonshire', 'Uppingham'),
(547, 'Northamptonshire', 'Wellingborough'),
(548, 'Northumberland', 'Alnwick'),
(549, 'Northumberland', 'Belford'),
(550, 'Northumberland', 'Bellingham'),
(551, 'Northumberland', 'Berwick'),
(552, 'Northumberland', 'Castle Ward'),
(553, 'Northumberland', 'Glendale'),
(554, 'Northumberland', 'Haltwhistle'),
(555, 'Northumberland', 'Hexham'),
(556, 'Northumberland', 'Morpeth'),
(557, 'Northumberland', 'Newcastle upon Tyne'),
(558, 'Northumberland', 'Alnwick'),
(559, 'Northumberland', 'Rothbury'),
(560, 'Northumberland', 'Tynemouth'),
(561, 'Nottinghamshire', 'Basford'),
(562, 'Nottinghamshire', 'Bingham'),
(563, 'Nottinghamshire', 'Doncaster'),
(564, 'Nottinghamshire', 'East Retford'),
(565, 'Nottinghamshire', 'Gainsborough'),
(566, 'Nottinghamshire', 'Loughborough'),
(567, 'Nottinghamshire', 'Mansfield'),
(568, 'Nottinghamshire', 'Melton Mowbray'),
(569, 'Nottinghamshire', 'Newark'),
(570, 'Nottinghamshire', 'Nottingham'),
(571, 'Nottinghamshire', 'Radford'),
(572, 'Nottinghamshire', 'Shardlow'),
(573, 'Nottinghamshire', 'Southwell'),
(574, 'Nottinghamshire', 'Worksop'),
(575, 'Oxfordshire', 'Abingdon'),
(576, 'Oxfordshire', 'Banbury'),
(577, 'Oxfordshire', 'Bicester'),
(578, 'Oxfordshire', 'Brackley'),
(579, 'Oxfordshire', 'Bradfield'),
(580, 'Oxfordshire', 'Buckingham'),
(581, 'Oxfordshire', 'Chipping Norton'),
(582, 'Oxfordshire', 'Faringdon'),
(583, 'Oxfordshire', 'Headington'),
(584, 'Oxfordshire', 'Henley'),
(585, 'Oxfordshire', 'Oxford'),
(586, 'Oxfordshire', 'Thame'),
(587, 'Oxfordshire', 'Wallingford'),
(588, 'Oxfordshire', 'Wantage'),
(589, 'Oxfordshire', 'Witney'),
(590, 'Oxfordshire', 'Woodstock'),
(591, 'Oxfordshire', 'Wycombe'),
(592, 'Rutland', 'Oakham'),
(593, 'Rutland', 'Stamford'),
(594, 'Rutland', 'Uppingham'),
(595, 'Shropshire', 'Atcham'),
(596, 'Shropshire', 'Bridgnorth'),
(597, 'Shropshire', 'Bromsgrove'),
(598, 'Shropshire', 'Church Stretton'),
(599, 'Shropshire', 'Cleobury Mortimer'),
(600, 'Shropshire', 'Clun'),
(601, 'Shropshire', 'Ellesmere'),
(602, 'Shropshire', 'Forden'),
(603, 'Shropshire', 'Kidderminster'),
(604, 'Shropshire', 'Knighton'),
(605, 'Shropshire', 'Ludlow'),
(606, 'Shropshire', 'Madeley'),
(607, 'Shropshire', 'Market Drayton'),
(608, 'Shropshire', 'Montgomery'),
(609, 'Shropshire', 'Newport'),
(610, 'Shropshire', 'Oswestry'),
(611, 'Shropshire', 'Seisdon'),
(612, 'Shropshire', 'Shifnal'),
(613, 'Shropshire', 'Shrewsbury'),
(614, 'Shropshire', 'Stourbridge'),
(615, 'Shropshire', 'Tenbury'),
(616, 'Shropshire', 'Wellington'),
(617, 'Shropshire', 'Wem'),
(618, 'Shropshire', 'West Bromwich'),
(619, 'Shropshire', 'Whitchurch'),
(620, 'Shropshire', 'Wolverhampton'),
(621, 'Somerset', 'Axbridge'),
(622, 'Somerset', 'Bath'),
(623, 'Somerset', 'Beaminster'),
(624, 'Somerset', 'Bedminster'),
(625, 'Somerset', 'Bradford on Avon'),
(626, 'Somerset', 'Bridgwater'),
(627, 'Somerset', 'Chard'),
(628, 'Somerset', 'Clutton'),
(629, 'Somerset', 'Dulverton'),
(630, 'Somerset', 'Frome'),
(631, 'Somerset', 'Keynsham'),
(632, 'Somerset', 'Langport'),
(633, 'Somerset', 'Long Ashton'),
(634, 'Somerset', 'Mere'),
(635, 'Somerset', 'Shepton Mallet'),
(636, 'Somerset', 'Sherborne'),
(637, 'Somerset', 'Somerset'),
(638, 'Somerset', 'Taunton'),
(639, 'Somerset', 'Tiverton'),
(640, 'Somerset', 'Wellington'),
(641, 'Somerset', 'Wells'),
(642, 'Somerset', 'Weston super Mere'),
(643, 'Somerset', 'Williton'),
(644, 'Somerset', 'Wincanton'),
(645, 'Somerset', 'Yeovil'),
(646, 'Staffordshire', 'Ashbourne'),
(647, 'Staffordshire', 'Bromsgrove'),
(648, 'Staffordshire', 'Burton upon Trent'),
(649, 'Staffordshire', 'Cannock'),
(650, 'Staffordshire', 'Cheadle'),
(651, 'Staffordshire', 'Congleton'),
(652, 'Staffordshire', 'Dudley'),
(653, 'Staffordshire', 'Kidderminster'),
(654, 'Staffordshire', 'Kings Norton'),
(655, 'Staffordshire', 'Leek'),
(656, 'Staffordshire', 'Lichfield'),
(657, 'Staffordshire', 'Market Drayton'),
(658, 'Staffordshire', 'Newcastle under Lyme'),
(659, 'Staffordshire', 'Newport'),
(660, 'Staffordshire', 'Penkridge'),
(661, 'Staffordshire', 'Rowley Regis'),
(662, 'Staffordshire', 'Seisdon'),
(663, 'Staffordshire', 'Shifnal'),
(664, 'Staffordshire', 'Stafford'),
(665, 'Staffordshire', 'Stoke upon Trent'),
(666, 'Staffordshire', 'Stone'),
(667, 'Staffordshire', 'Stourbridge'),
(668, 'Staffordshire', 'Tamworth'),
(669, 'Staffordshire', 'Uttoxeter'),
(670, 'Staffordshire', 'Walsall'),
(671, 'Staffordshire', 'West Bromwich'),
(672, 'Staffordshire', 'Wolstanton'),
(673, 'Staffordshire', 'Wolverhampton'),
(674, 'Suffolk', 'Blything'),
(675, 'Suffolk', 'Bosmere'),
(676, 'Suffolk', 'Bury St.Edmunds'),
(677, 'Suffolk', 'Cosford'),
(678, 'Suffolk', 'Deben'),
(679, 'Suffolk', 'Depwade'),
(680, 'Suffolk', 'Hartismere'),
(681, 'Suffolk', 'Hoxne'),
(682, 'Suffolk', 'Ipswich'),
(683, 'Suffolk', 'Mildenhall'),
(684, 'Suffolk', 'Mutford'),
(685, 'Suffolk', 'Newmarket'),
(686, 'Suffolk', 'Plomesgate'),
(687, 'Suffolk', 'Risbridge'),
(688, 'Suffolk', 'Samford'),
(689, 'Suffolk', 'Stow'),
(690, 'Suffolk', 'Sudbury'),
(691, 'Suffolk', 'Suffolk'),
(692, 'Suffolk', 'Thetford'),
(693, 'Suffolk', 'Thingoe'),
(694, 'Suffolk', 'Wainford'),
(695, 'Suffolk', 'Woodbridge'),
(696, 'Surrey', 'Bermondsey'),
(697, 'Surrey', 'Camberwell'),
(698, 'Surrey', 'Chertsey'),
(699, 'Surrey', 'Croydon'),
(700, 'Surrey', 'Dorking'),
(701, 'Surrey', 'East Grinstead'),
(702, 'Surrey', 'Epsom'),
(703, 'Surrey', 'Farnborough'),
(704, 'Surrey', 'Farnham'),
(705, 'Surrey', 'Godstone'),
(706, 'Surrey', 'Guildford'),
(707, 'Surrey', 'Hambleton'),
(708, 'Surrey', 'Kingston'),
(709, 'Surrey', 'Lambeth'),
(710, 'Surrey', 'Newington'),
(711, 'Surrey', 'Reigate'),
(712, 'Surrey', 'Richmond'),
(713, 'Surrey', 'Rotherhithe'),
(714, 'Surrey', 'St.George Southwark'),
(715, 'Surrey', 'St.Olave Southwark'),
(716, 'Surrey', 'St.Saviour Southwark'),
(717, 'Surrey', 'South East Surrey'),
(718, 'Surrey', 'Wandsworth'),
(719, 'Surrey', 'Windsor'),
(720, 'Sussex', 'Battle'),
(721, 'Sussex', 'Brighton'),
(722, 'Sussex', 'Chailey'),
(723, 'Sussex', 'Chichester'),
(724, 'Sussex', 'Cranbrook'),
(725, 'Sussex', 'Cuckfield'),
(726, 'Sussex', 'Eastbourne'),
(727, 'Sussex', 'East Grinstead'),
(728, 'Sussex', 'East Preston'),
(729, 'Sussex', 'Farnborough'),
(730, 'Sussex', 'Farnham'),
(731, 'Sussex', 'Hailsham'),
(732, 'Sussex', 'Hambledon'),
(733, 'Sussex', 'Hastings'),
(734, 'Sussex', 'Horsham'),
(735, 'Sussex', 'Lewes'),
(736, 'Sussex', 'Midhurst'),
(737, 'Sussex', 'Newhaven'),
(738, 'Sussex', 'Petersfield'),
(739, 'Sussex', 'Petworth'),
(740, 'Sussex', 'Rye'),
(741, 'Sussex', 'Steyning'),
(742, 'Sussex', 'Thakeham'),
(743, 'Sussex', 'Ticehurst'),
(744, 'Sussex', 'Tonbridge'),
(745, 'Sussex', 'Uckfield'),
(746, 'Sussex', 'Westbourne'),
(747, 'Sussex', 'West Firle'),
(748, 'Sussex', 'Westhampnett'),
(749, 'Sussex', 'Worthing'),
(750, 'Warwickshire', 'Alcester'),
(751, 'Warwickshire', 'Aston'),
(752, 'Warwickshire', 'Atherstone'),
(753, 'Warwickshire', 'Banbury'),
(754, 'Warwickshire', 'Birmingham'),
(755, 'Warwickshire', 'Bromsgrove'),
(756, 'Warwickshire', 'Chipping Norton'),
(757, 'Warwickshire', 'Coventry'),
(758, 'Warwickshire', 'Foleshill'),
(759, 'Warwickshire', 'Hinckley'),
(760, 'Warwickshire', 'Kings Norton'),
(761, 'Warwickshire', 'Lutterworth'),
(762, 'Warwickshire', 'Meriden'),
(763, 'Warwickshire', 'Nuneaton'),
(764, 'Warwickshire', 'Rugby'),
(765, 'Warwickshire', 'Shipston on Stour'),
(766, 'Warwickshire', 'Solihull'),
(767, 'Warwickshire', 'Southam'),
(768, 'Warwickshire', 'Stourbridge'),
(769, 'Warwickshire', 'Stratford on Avon'),
(770, 'Warwickshire', 'Tamworth'),
(771, 'Warwickshire', 'Warwick'),
(772, 'Westmorland', 'East Ward'),
(773, 'Westmorland', 'Kendal'),
(774, 'Westmorland', 'West Ward'),
(775, 'Wiltshire', 'Alderbury'),
(776, 'Wiltshire', 'Amesbury'),
(777, 'Wiltshire', 'Andover'),
(778, 'Wiltshire', 'Bradford on Avon'),
(779, 'Wiltshire', 'Calne'),
(780, 'Wiltshire', 'Cirencester'),
(781, 'Wiltshire', 'Cricklade'),
(782, 'Wiltshire', 'Devizes'),
(783, 'Wiltshire', 'Dursley'),
(784, 'Wiltshire', 'Faringdon'),
(785, 'Wiltshire', 'Fordingbridge'),
(786, 'Wiltshire', 'Highworth'),
(787, 'Wiltshire', 'Hungerford'),
(788, 'Wiltshire', 'Malmesbury'),
(789, 'Wiltshire', 'Marlborough'),
(790, 'Wiltshire', 'Melksham'),
(791, 'Wiltshire', 'Mere'),
(792, 'Wiltshire', 'New Forest'),
(793, 'Wiltshire', 'Pewsey'),
(794, 'Wiltshire', 'Romsey'),
(795, 'Wiltshire', 'Salisbury'),
(796, 'Wiltshire', 'Stockbridge'),
(797, 'Wiltshire', 'Swindon'),
(798, 'Wiltshire', 'Tetbury'),
(799, 'Wiltshire', 'Tisbury'),
(800, 'Wiltshire', 'Trowbridge'),
(801, 'Wiltshire', 'Westbury'),
(802, 'Wiltshire', 'Wilton'),
(803, 'Wiltshire', 'Wokingham'),
(804, 'Worcestershire', 'Alcester'),
(805, 'Worcestershire', 'Bromsgrove'),
(806, 'Worcestershire', 'Bromyard'),
(807, 'Worcestershire', 'Cleobury Mortimer'),
(808, 'Worcestershire', 'Droitwich'),
(809, 'Worcestershire', 'Dudley'),
(810, 'Worcestershire', 'Evesham'),
(811, 'Worcestershire', 'Kidderminster'),
(812, 'Worcestershire', 'Kings Norton'),
(813, 'Worcestershire', 'Ledbury'),
(814, 'Worcestershire', 'Martley'),
(815, 'Worcestershire', 'Pershore'),
(816, 'Worcestershire', 'Shipston on Stour'),
(817, 'Worcestershire', 'Solihull'),
(818, 'Worcestershire', 'Stourbridge'),
(819, 'Worcestershire', 'Stow on the Wold'),
(820, 'Worcestershire', 'Stratford on Avon'),
(821, 'Worcestershire', 'Tenbury'),
(822, 'Worcestershire', 'Tewkesbury'),
(823, 'Worcestershire', 'Upton on Severn'),
(824, 'Worcestershire', 'West Bromwich'),
(825, 'Worcestershire', 'Winchcomb'),
(826, 'Worcestershire', 'Worcester'),
(827, 'Yorkshire - East Riding', 'Beverley'),
(828, 'Yorkshire - East Riding', 'Bridlington'),
(829, 'Yorkshire - East Riding', 'Driffield'),
(830, 'Yorkshire - East Riding', 'Howden'),
(831, 'Yorkshire - East Riding', 'Hull'),
(832, 'Yorkshire - East Riding', 'Malton'),
(833, 'Yorkshire - East Riding', 'Patrington'),
(834, 'Yorkshire - East Riding', 'Pocklington'),
(835, 'Yorkshire - East Riding', 'Scarborough'),
(836, 'Yorkshire - East Riding', 'Sculcoates'),
(837, 'Yorkshire - East Riding', 'Selby'),
(838, 'Yorkshire - East Riding', 'Skirlaugh'),
(839, 'Yorkshire - East Riding', 'York'),
(840, 'Yorkshire - North Riding', 'Askrigg'),
(841, 'Yorkshire - North Riding', 'Aysgarth'),
(842, 'Yorkshire - North Riding', 'Bedale'),
(843, 'Yorkshire - North Riding', 'Darlington'),
(844, 'Yorkshire - North Riding', 'Easingwold'),
(845, 'Yorkshire - North Riding', 'Great Ouseburn'),
(846, 'Yorkshire - North Riding', 'Guisborough'),
(847, 'Yorkshire - North Riding', 'Helmsley'),
(848, 'Yorkshire - North Riding', 'Leyburn'),
(849, 'Yorkshire - North Riding', 'Malton'),
(850, 'Yorkshire - North Riding', 'Middlesbrough'),
(851, 'Yorkshire - North Riding', 'Northallerton'),
(852, 'Yorkshire - North Riding', 'Pickering'),
(853, 'Yorkshire - North Riding', 'Reeth'),
(854, 'Yorkshire - North Riding', 'Richmond'),
(855, 'Yorkshire - North Riding', 'Ripon'),
(856, 'Yorkshire - North Riding', 'Scarborough'),
(857, 'Yorkshire - North Riding', 'Stockton'),
(858, 'Yorkshire - North Riding', 'Stokesley'),
(859, 'Yorkshire - North Riding', 'Teesdale'),
(860, 'Yorkshire - North Riding', 'Thirsk'),
(861, 'Yorkshire - North Riding', 'Whitby'),
(862, 'Yorkshire - North Riding', 'York'),
(863, 'Yorkshire - West Riding', 'Barnsley'),
(864, 'Yorkshire - West Riding', 'Bradford'),
(865, 'Yorkshire - West Riding', 'Bramham'),
(866, 'Yorkshire - West Riding', 'Bramley'),
(867, 'Yorkshire - West Riding', 'Burnley'),
(868, 'Yorkshire - West Riding', 'Castleford'),
(869, 'Yorkshire - West Riding', 'Clitheroe'),
(870, 'Yorkshire - West Riding', 'Dewsbury'),
(871, 'Yorkshire - West Riding', 'Doncaster'),
(872, 'Yorkshire - West Riding', 'Ecclesall Bierlow'),
(873, 'Yorkshire - West Riding', 'Ecclesfield'),
(874, 'Yorkshire - West Riding', 'Goole'),
(875, 'Yorkshire - West Riding', 'Great Ouseburn'),
(876, 'Yorkshire - West Riding', 'Halifax'),
(877, 'Yorkshire - West Riding', 'Hemsworth'),
(878, 'Yorkshire - West Riding', 'Holbeck'),
(879, 'Yorkshire - West Riding', 'Huddersfield'),
(880, 'Yorkshire - West Riding', 'Hunslet'),
(881, 'Yorkshire - West Riding', 'Keighley'),
(882, 'Yorkshire - West Riding', 'Kirkdeighton'),
(883, 'Yorkshire - West Riding', 'Kirkstall'),
(884, 'Yorkshire - West Riding', 'Knaresborough'),
(885, 'Yorkshire - West Riding', 'Leeds'),
(886, 'Yorkshire - West Riding', 'North Bierley'),
(887, 'Yorkshire - West Riding', 'Otley'),
(888, 'Yorkshire - West Riding', 'Pateley Bridge'),
(889, 'Yorkshire - West Riding', 'Penistone'),
(890, 'Yorkshire - West Riding', 'Pontefract'),
(891, 'Yorkshire - West Riding', 'Ripon'),
(892, 'Yorkshire - West Riding', 'Rotherham'),
(893, 'Yorkshire - West Riding', 'Saddleworth'),
(894, 'Yorkshire - West Riding', 'Sedbergh'),
(895, 'Yorkshire - West Riding', 'Selby'),
(896, 'Yorkshire - West Riding', 'Settle'),
(897, 'Yorkshire - West Riding', 'Sheffield'),
(898, 'Yorkshire - West Riding', 'Skipton'),
(899, 'Yorkshire - West Riding', 'Tadcaster'),
(900, 'Yorkshire - West Riding', 'Thorne'),
(901, 'Yorkshire - West Riding', 'Todmorden'),
(902, 'Yorkshire - West Riding', 'Wakefield'),
(903, 'Yorkshire - West Riding', 'Wetherby'),
(904, 'Yorkshire - West Riding', 'Wharfedale'),
(905, 'Yorkshire - West Riding', 'Worksop'),
(906, 'Yorkshire - West Riding', 'Wortley'),
(907, 'Yorkshire - West Riding', 'York'),
(908, 'Anglesey', 'Anglesey'),
(909, 'Anglesey', 'Bangor'),
(910, 'Anglesey', 'Carnarvon'),
(911, 'Anglesey', 'Holyhead'),
(912, 'Brecknockshire', 'Bedwellty'),
(913, 'Brecknockshire', 'Brecknock'),
(914, 'Brecknockshire', 'Builth'),
(915, 'Brecknockshire', 'Crickhowell'),
(916, 'Brecknockshire', 'Hay'),
(917, 'Brecknockshire', 'Llandovery'),
(918, 'Brecknockshire', 'Merthyr Tydfil'),
(919, 'Brecknockshire', 'Neath'),
(920, 'Brecknockshire', 'Pontardawe'),
(921, 'Brecknockshire', 'Rhayader'),
(922, 'Caernarvonshire', 'Bangor'),
(923, 'Caernarvonshire', 'Carnarvon'),
(924, 'Caernarvonshire', 'Conway'),
(925, 'Caernarvonshire', 'Ffestiniog'),
(926, 'Caernarvonshire', 'Llanrwst'),
(927, 'Caernarvonshire', 'Pwllheli'),
(928, 'Cardiganshire', 'Aberayron'),
(929, 'Cardiganshire', 'Aberystwyth'),
(930, 'Cardiganshire', 'Cardigan'),
(931, 'Cardiganshire', 'Lampeter'),
(932, 'Cardiganshire', 'Machynlleth'),
(933, 'Cardiganshire', 'Newcastle in Emlyn'),
(934, 'Cardiganshire', 'Tregaron'),
(935, 'Carmarthenshire', 'Carmarthen'),
(936, 'Carmarthenshire', 'Lampeter'),
(937, 'Carmarthenshire', 'Llandilofawr'),
(938, 'Carmarthenshire', 'Llandovery'),
(939, 'Carmarthenshire', 'Llanelly'),
(940, 'Carmarthenshire', 'Narberth'),
(941, 'Carmarthenshire', 'Newcastle in Emlyn'),
(942, 'Denbighshire', 'Conway'),
(943, 'Denbighshire', 'Conwen'),
(944, 'Denbighshire', 'Llanfyllin'),
(945, 'Denbighshire', 'Llanrwst'),
(946, 'Denbighshire', 'Oswestry'),
(947, 'Denbighshire', 'Ruthin'),
(948, 'Denbighshire', 'St.Asaph'),
(949, 'Denbighshire', 'Wrexham'),
(950, 'Flintshire', 'Chester'),
(951, 'Flintshire', 'Ellesmere'),
(952, 'Flintshire', 'Great Boughton'),
(953, 'Flintshire', 'Hawarden'),
(954, 'Flintshire', 'Holywell'),
(955, 'Flintshire', 'St.Asaph'),
(956, 'Flintshire', 'Whitchurch'),
(957, 'Flintshire', 'Wrexham'),
(958, 'Glamorganshire', 'Bridgend'),
(959, 'Glamorganshire', 'Cardiff'),
(960, 'Glamorganshire', 'Gower'),
(961, 'Glamorganshire', 'Llanelly'),
(962, 'Glamorganshire', 'Merthyr Tydfil'),
(963, 'Glamorganshire', 'Neath'),
(964, 'Glamorganshire', 'Newport'),
(965, 'Glamorganshire', 'Pontardawe'),
(966, 'Glamorganshire', 'Pontypridd'),
(967, 'Glamorganshire', 'Swansea'),
(968, 'Merionethshire', 'Bala'),
(969, 'Merionethshire', 'Corwen'),
(970, 'Merionethshire', 'Dolgelly'),
(971, 'Merionethshire', 'Ffestiniog'),
(972, 'Merionethshire', 'Machynlleth'),
(973, 'Monmouthshire', 'Abergavenny'),
(974, 'Monmouthshire', 'Bedwellty'),
(975, 'Monmouthshire', 'Cardiff'),
(976, 'Monmouthshire', 'Chepstow'),
(977, 'Monmouthshire', 'Crickhowell'),
(978, 'Monmouthshire', 'Dore'),
(979, 'Monmouthshire', 'Hereford'),
(980, 'Monmouthshire', 'Monmouth'),
(981, 'Monmouthshire', 'Newport'),
(982, 'Monmouthshire', 'Pontypool'),
(983, 'Montgomeryshire', 'Atcham'),
(984, 'Montgomeryshire', 'Clun'),
(985, 'Montgomeryshire', 'Dolgelly'),
(986, 'Montgomeryshire', 'Forden'),
(987, 'Montgomeryshire', 'Llanfyllin'),
(988, 'Montgomeryshire', 'Machynlleth'),
(989, 'Montgomeryshire', 'Montgomery'),
(990, 'Montgomeryshire', 'Newtown'),
(991, 'Montgomeryshire', 'Welshpool'),
(992, 'Pembrokeshire', 'Cardigan'),
(993, 'Pembrokeshire', 'Haverfordwest'),
(994, 'Pembrokeshire', 'Narberth'),
(995, 'Pembrokeshire', 'Newcastle in Emlyn'),
(996, 'Pembrokeshire', 'Pembroke'),
(997, 'Radnorshire', 'Builth'),
(998, 'Radnorshire', 'Hay'),
(999, 'Radnorshire', 'Kington'),
(1000, 'Radnorshire', 'Knighton'),
(1001, 'Radnorshire', 'Presteigne'),
(1002, 'Radnorshire', 'Rhayader');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tblDistrict`
--
ALTER TABLE `tblDistrict`
  ADD PRIMARY KEY (`id`),
  ADD KEY `District` (`District`),
  ADD KEY `County` (`County`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
