UK postcode districts SQL Database Dump for MySQL, Microsoft Access and Oracle

Preview
-- 
-- Table structure for table `postal_districts`
-- 

CREATE TABLE `postal_districts` (
  `id` int(11) NOT NULL auto_increment,
  `area` varchar(200) NOT NULL,
  `post_town` varchar(200) NOT NULL,
  `districts` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1642 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1642 ;

-- 
-- Dumping data for table `postal_districts`
-- 

INSERT INTO `postal_districts` (`id`, `area`, `post_town`, `districts`) VALUES (1, 'AB', 'Aberdeen', 'AB10, AB11, AB12, AB13 (part), AB15, AB16, AB21, AB22, AB23, AB24, AB25'),
(2, 'AB', 'Milltimber', 'AB13 (part)'),
(3, 'AB', 'Peterculter', 'AB14'),
(4, 'AB', 'Laurencekirk', 'AB30'),
(5, 'AB', 'Banchory', 'AB31'),
(6, 'AB', 'Westhill', 'AB32'),
(7, 'AB', 'Alford', 'AB33'),
(8, 'AB', 'Aboyne', 'AB34'),
(9, 'AB', 'Ballater', 'AB35'),
(10, 'AB', 'Strathdon', 'AB36'),
(11, 'AB', 'Ballindalloch', 'AB37'),
(12, 'AB', 'Aberlour', 'AB38'),
(13, 'AB', 'Stonehaven', 'AB39'),
(14, 'AB', 'Ellon', 'AB41'),
(15, 'AB', 'Peterhead', 'AB42'),
(16, 'AB', 'Fraserburgh', 'AB43'),
(17, 'AB', 'Macduff', 'AB44'),
(18, 'AB', 'Banff', 'AB45'),
(19, 'AB', 'Inverurie', 'AB51'),
(20, 'AB', 'Insch', 'AB52'),
(21, 'AB', 'Turriff', 'AB53'),
(22, 'AB', 'Huntly', 'AB54'),
(23, 'AB', 'Keith', 'AB55'),
(24, 'AB', 'Buckie', 'AB56'),
(25, 'AL', 'St. Albans', 'AL1, AL2, AL3, AL4'),
(26, 'AL', 'Harpenden', 'AL5'),
(27, 'AL', 'Welwyn', 'AL6'),
(28, 'AL', 'Welwyn Garden City', 'AL7, AL8'),
(29, 'AL', 'Hatfield', 'AL9, AL10'),
(30, 'B', 'Birmingham', 'B1, B2, B3, B4, B5, B6, B7, B8, B9, B10, B11, B12, B13, B14, B15, B16, B17, B18, B19, B20, B21, B22, B23, B24, B25, B26, B27, B28, B29, B30, B31, B32, B33, B34, B35, B36, B37, B38, B40, B42, B43, B44, B45, B46, B47, B48'),
(31, 'B', 'Alcester', 'B49, B50'),
(32, 'B', 'Bromsgrove', 'B60, B61'),
(33, 'B', 'Halesowen', 'B62, B63'),
(34, 'B', 'Cradley Heath', 'B64'),
(35, 'B', 'Rowley Regis', 'B65'),
(36, 'B', 'Smethwick', 'B66, B67'),
(37, 'B', 'Oldbury', 'B68, B69'),
(38, 'B', 'West Bromwich', 'B70, B71'),
(39, 'B', 'Sutton Coldfield', 'B72, B73, B74, B75, B76'),
(40, 'B', 'Tamworth', 'B77, B78, B79'),
(41, 'B', 'Studley', 'B80'),
(42, 'B', 'Solihull', 'B90, B91, B92, B93, B94, B95'),
(43, 'B', 'Redditch', 'B96, B97, B98'),
(44, 'BA', 'Bath', 'BA1, BA2'),
(45, 'BA', 'Radstock', 'BA3'),
(46, 'BA', 'Shepton Mallet', 'BA4'),
(47, 'BA', 'Wells', 'BA5'),
(48, 'BA', 'Glastonbury', 'BA6'),
(49, 'BA', 'Castle Cary', 'BA7'),
(50, 'BA', 'Templecombe', 'BA8'),
(51, 'BA', 'Winc
To view the full dump, please login
SQL database dumps

UK postcode districts

Navigation

Popular databases
