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

Preview
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- --------------------------------------------------------

--
-- Table structure for table `uk_postcodes`
--

CREATE TABLE IF NOT EXISTS `uk_postcodes` (
  `postcode` varchar(5) NOT NULL,
  `eastings` int(11) NOT NULL DEFAULT '0',
  `northings` int(11) NOT NULL DEFAULT '0',
  `latitude` decimal(12,5) NOT NULL DEFAULT '0.00000',
  `longitude` decimal(12,5) NOT NULL DEFAULT '0.00000',
  `town` varchar(255) DEFAULT NULL,
  `region` varchar(255) DEFAULT NULL,
  `country` varchar(3) NOT NULL,
  `country_string` varchar(16) NOT NULL,
  PRIMARY KEY (`postcode`),
  KEY `x` (`eastings`,`northings`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='DanGibbs.co.uk Free UK Postcode Database';

--
-- Dumping data for table `uk_postcodes`
--

INSERT INTO `uk_postcodes` (`postcode`, `eastings`, `northings`, `latitude`, `longitude`, `town`, `region`, `country`, `country_string`) VALUES
('AB10', 392900, 804900, '57.13514', '-2.11731', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland'),
('AB11', 394500, 805300, '57.13875', '-2.09089', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland'),
('AB12', 393300, 801100, '57.10100', '-2.11060', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland'),
('AB13', 385600, 801900, '57.10801', '-2.23776', 'Milltimber', 'Aberdeen City', 'SCT', 'Scotland'),
('AB14', 383600, 801100, '57.10076', '-2.27073', 'Peterculter', 'Aberdeen City', 'SCT', 'Scotland'),
('AB15', 390000, 805300, '57.13868', '-2.16525', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland'),
('AB16', 390600, 807800, '57.16115', '-2.15543', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland'),
('AB21', 387900, 813200, '57.20960', '-2.20033', 'Aberdeen Airport', 'Aberdeen City', 'SCT', 'Scotland'),
('AB22', 392800, 810700, '57.18724', '-2.11913', 'Bridge Of Don', 'Aberdeen City', 'SCT', 'Scotland'),
('AB23', 394700, 813500, '57.21242', '-2.08776', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland'),
('AB25', 393200, 806900, '57.15311', '-2.11241', 'Aberdeen', 'Aberdeen City', 'SCT', 'Scotland'),
('AB30', 370900, 772900, '56.84678', '-2.47712', 'Laurencekirk', 'Aberdeenshire', 'SCT', 'Scotland'),
('AB31', 368100, 798300, '57.07479', '-2.52623', 'Banchory', 'Aberdeenshire', 'SCT', 'Scotland'),
('AB32', 380800, 807200, '57.15545', '-2.31742', 'Westhill', 'Aberdeenshire', 'SCT', 'Scotland'),
('AB33', 355200, 815100, '57.22464', '-2.74203', 'Alford', 'Aberdeenshire', 'SCT', 'Scotland'),
('AB34', 350800, 800600, '57.09393', '-2.81204', 'Aboyne', 'Aberdeenshire', 'SCT', 'Scotl
To view the full dump, please login
SQL database dumps

UK towns, cities and postcodes

Navigation

Popular databases
