Database Details

Postcodes of UK

Postcode Database UK

Single License ?

£199 Includes free lifetime updates!

Enterprise License ?

£399 Includes free lifetime updates!

Redistribution License ?

£1999 Includes free lifetime updates!

Postcode Database UK

Details (Data of: 2024)

The UK postcode database includes all British postcodes, as well as the corresponding city, region, and latitude/longitude. Includes the data of England, Northern Ireland, Channel Islands, Isle of Man and Scotland and Wales.

The postcode data does change from time to time.

Buy your postcode database at PostcodeWorld.co.uk, and we will keep your postcode data up-to-date. Just pay a one-off price! No further costs! Unlimited in time. Unprecedented!

Database content

Regions14
Counties132
Posttowns1,475
Postcode Sectors11,267
Unique Postcodes1,896,548
Geocoded locations100 %
Number of records1,896,548

Available Formats:

Comma-separated values (CSV) ~20 MB ZIP compressed


Easy to import into all popular database management systems:

MySQL

MS SQL

Oracle

Postgre SQL

Microsoft Access

DB Structure

countrycodevarchar(2)
postcodevarchar(9)
postal townvarchar(48)
districtvarchar(48)
countyvarchar(48)
regionvarchar(48)
latitudedecimal(13, 9)
longitudedecimal(13, 9)

Delivery

Online Download

Programming

Having a database of localities with their latitudes and longitudes enables you to locate the closest locations to a set point (or within a radius of X miles/km).

To help you implement a postcode radius/distance search, we offer free access to sample code in scripting and programming languages like ASP and PHP.

To achieve the highest accuracy, the formulas in our example scripts take the earth's curvature into consideration.

Check out a working example of how to calculate all British postcodes within a given radius

Check out a working example of how to calculate road / beeline distance between 2 UK postcodes

All these scripts are available for our database customers for free download. (PHP / ASP)

More information about the programming...

Data Sample

countrycode;postcode;postal town;district;county;region;latitude;longitude
UK;L9 9JP;Liverpool;Liverpool;Merseyside;North West England;53.46275544;-2.94478620
UK;L9 9JQ;Liverpool;Liverpool;Merseyside;North West England;53.46193478;-2.95309728
UK;L9 9WN;Liverpool;Liverpool;Merseyside;North West England;53.46272561;-2.94478456
UK;L9 9WP;Liverpool;Liverpool;Merseyside;North West England;53.46258455;-2.94462602
UK;L9 9WQ;Liverpool;Liverpool;Merseyside;North West England;53.46855412;-2.94456099
UK;L9 9WR;Liverpool;Liverpool;Merseyside;North West England;53.46854754;-2.94456063
UK;L9 9WS;Liverpool;Liverpool;Merseyside;North West England;53.46277126;-2.94478707
UK;L9 9WT;Liverpool;Liverpool;Merseyside;North West England;53.46298341;-2.94616184
UK;L9 9WU;Liverpool;Liverpool;Merseyside;North West England;53.46272743;-2.94478466
UK;L9 9WX;Liverpool;Liverpool;Merseyside;North West England;53.47375180;-2.93352168
UK;L9 9WZ;Liverpool;Liverpool;Merseyside;North West England;53.47376800;-2.93352257
UK;L9 9XA;Liverpool;Liverpool;Merseyside;North West England;53.46853958;-2.94456019
UK;LA1 1AA;Lancaster;Lancaster;Lancashire;North West England;54.04801563;-2.80243477
UK;LA1 1AB;Lancaster;Lancaster;Lancashire;North West England;54.04789804;-2.80295077
UK;LA1 1AD;Lancaster;Lancaster;Lancashire;North West England;54.05392056;-2.80574192
UK;LA1 1AE;Lancaster;Lancaster;Lancashire;North West England;54.04677106;-2.80270093
UK;LA1 1AF;Lancaster;Lancaster;Lancashire;North West England;54.04670923;-2.79533667
UK;LA1 1AG;Lancaster;Lancaster;Lancashire;North West England;54.04673620;-2.79533806
UK;LA1 1AH;Lancaster;Lancaster;Lancashire;North West England;54.05131918;-2.80136701
UK;LA1 1AJ;Lancaster;Lancaster;Lancashire;North West England;54.04817772;-2.80284983
UK;LA1 1AL;Lancaster;Lancaster;Lancashire;North West England;54.04791894;-2.79977482
UK;LA1 1AN;Lancaster;Lancaster;Lancashire;North West England;54.04517115;-2.79967631
UK;LA1 1AQ;Lancaster;Lancaster;Lancashire;North West England;54.04494717;-2.79895400
UK;LA1 1AR;Lancaster;Lancaster;Lancashire;North West England;54.04493690;-2.79895346
UK;LA1 1AT;Lancaster;Lancaster;Lancashire;North West England;54.04612409;-2.79501962
UK;LA1 1AU;Lancaster;Lancaster;Lancashire;North West England;54.04562925;-2.79575963
UK;LA1 1AY;Lancaster;Lancaster;Lancashire;North West England;54.05159145;-2.80024222
UK;LA1 1AZ;Lancaster;Lancaster;Lancashire;North West England;54.04412892;-2.80090844
UK;LA1 1BB;Lancaster;Lancaster;Lancashire;North West England;54.05456612;-2.79182085
UK;LA1 1BE;Lancaster;Lancaster;Lancashire;North West England;54.04718045;-2.80451151
UK;LA1 1BJ;Lancaster;Lancaster;Lancashire;North West England;54.04593229;-2.79626980
UK;LA1 1BL;Lancaster;Lancaster;Lancashire;North West England;54.05125350;-2.80083204
UK;LA1 1BN;Lancaster;Lancaster;Lancashire;North West England;54.05079409;-2.80051729
UK;LA1 1BP;Lancaster;Lancaster;Lancashire;North West England;54.05098371;-2.80035230<

Other products

From £599
From £999
Free