List of towns in the UK Cities and Postcodes in the UK including England, Ireland, Scotland and Wales Towns and Cities

Preview
CREATE TABLE `cities` (
`city_id` int(11) NOT NULL auto_increment,
`city_name` varchar(200) NOT NULL,
PRIMARY KEY  (`city_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;


INSERT INTO `cities` (`id` , `city_name`)
VALUES
(1, 'Abingdon'),
(2, 'Accrington'),
(3, 'Acton'),
(4, 'Adlington'),
(5, 'Alcester'),
(6, 'Aldeburgh'),
(7, 'Aldershot'),
(8, 'Aldridge'),
(9, 'Alford'),
(10, 'Alfreton'),
(11, 'Allendale'),
(12, 'Alnwick'),
(13, 'Alsager'),
(14, 'Alston'),
(15, 'Alton'),
(16, 'Altrincham'),
(17, 'Amble'),
(18, 'Amersham'),
(19, 'Amesbury'),
(20, 'Ampthill'),
(21, 'Andover'),
(22, 'Appleby-in-Westmorland'),
(23, 'Arlesey'),
(24, 'Arundel'),
(25, 'Ashbourne'),
(26, 'Ashburton'),
(27, 'Ashby-de-la-Zouch'),
(28, 'Ashford'),
(29, 'Ashington'),
(30, 'Ashton-in-Makerfield'),
(31, 'Ashton-under-Lyne'),
(32, 'Askern'),
(33, 'Aspatria'),
(34, 'Atherstone'),
(35, 'Attleborough'),
(36, 'Axbridge'),
(37, 'Axminster'),
(38, 'Aylesbury'),
(39, 'Aylsham'),
(40, 'Bacup'),
(41, 'Bakewell'),
(42, 'Baldock'),
(43, 'Banbury'),
(44, 'Barking'),
(45, 'Barnard Castle'),
(46, 'Barnet'),
(47, 'Barnoldswick'),
(48, 'Barnsley'),
(49, 'Barnstaple'),
(50, 'Barrow-in-Furness'),
(51, 'Barton-upon-Humber'),
(52, 'Basildon'),
(53, 'Basingstoke'),
(54, 'Bath'),
(55, 'Batley'),
(56, 'Battle'),
(57, 'Bawtry'),
(58, 'Beaconsfield'),
(59, 'Beaminster'),
(60, 'Bebington'),
(61, 'Beccles'),
(62, 'Bedale'),
(63, 'Bedford'),
(64, 'Bedlington'),
(65, 'Bedworth'),
(66, 'Beeston'),
(67, 'Belper'),
(68, 'Bentham'),
(69, 'Berkhamsted'),
(70, 'Berwick-upon-Tweed'),
(71, 'Beverley'),
(72, 'Bewdley'),
(73, 'Bexhill-on-Sea'),
(74, 'Bicester'),
(75, 'Biddulph'),
(76, 'Bideford'),
(77, 'Biggleswade'),
(78, 'Billericay'),
(79, 'Bilston'),
(80, 'Bingham'),
(81, 'Bingley'),
(82, 'Birkenhead'),
(83, 'Birmingham'),
(84, 'Bishop Auckland'),
(85, 'Bishop\'s Castle'),
(86, 'Bishop\'s Stortford'),
(87, 'Bishop\'s Waltham'),
(88, 'Blackburn'),
(89, 'Blackheath'),
(90, 'Blackpool'),
(91, 'Blandford Forum'),
(92, 'Bletchley'),
(93, 'Bloxwich'),
(94, 'Blyth'),
(95, 'Bodmin'),
(96, 'Bognor Regis'),
(97, 'Bollington'),
(98, 'Bolsover'),
(99, 'Bolton'),
(100, 'Bootle'),
(101, 'Borehamwood'),
(102, 'Boroughbridge'),
(103, 'Boston'),
(104, 'Bottesford'),
(105, 'Bourne'),
(106, 'Bournemouth'),
(107, 'Brackley'),
(108, 'Bracknell'),
(109, 'Bradford'),
(110, 'Bradford on Avon'),
(111, 'Brading'),
(112, 'Bradley Stoke'),
(113, 'Bradninch'),
(114, 'Braintree'),
(115, 'Brentford'),
(116, 'Brentwood'),
(117, 'Bridgnorth'),
(118, 'Bridg
To view the full dump, please login
SQL database dumps

UK towns and cities

Navigation

Popular databases
