Database Details
Postcodes of UK
Postcode Database UK
Details (Data of: 2024)
The UK postcode database includes all British Outward 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 ZIPCodeSoft, 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
Regions | 6 |
Counties | 132 |
Postaltowns | 1,475 |
Places | 31,700 |
Unique Postcodes | 3,062 |
Geocoded locations | 100 % |
Number of records | 34,869 |
Available Formats:
Comma-separated values (CSV) ~300 KB ZIP compressed
Easy to import into all popular database management systems:
MySQL
MS SQL
Oracle
Postgre SQL
Microsoft Access
DB Structure
countrycode | varchar(2) |
postcode | varchar(8) |
place | varchar(48) |
postal town | varchar(48) |
region1 | varchar(48) |
region2 | varchar(48) |
latitude | decimal(13, 9) |
longitude | decimal(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 British postcodes
All these scripts are available for our database customers for free download. (PHP / ASP)
More information about the programming...
Data Sample
countrycode;postalcode;place;postal town;region1;region2;latitude;longitude
GB;LS1;Leeds;Leeds;England;West Yorkshire;53.798399970;-1.546150570
GB;LS10;Beeston Park;Leeds;England;West Yorkshire;53.749558420;-1.556845830
GB;LS10;Belle Isle;Leeds;England;West Yorkshire;53.759211360;-1.530755560
GB;LS10;Hunslet;Leeds;England;West Yorkshire;53.776301410;-1.533424600
GB;LS10;Hunslet Business Park;Leeds;England;West Yorkshire;53.781404020;-1.525229590
GB;LS10;Leeds;Leeds;England;West Yorkshire;53.740690780;-1.544943310
GB;LS10;Middleton;Leeds;England;West Yorkshire;53.749879310;-1.548526110
GB;LS11;Beeston;Leeds;England;West Yorkshire;53.772569720;-1.567070390
GB;LS11;Holbeck;Leeds;England;West Yorkshire;53.793280970;-1.549790680
GB;LS11;Leeds;Leeds;England;West Yorkshire;53.768896020;-1.580943110
GB;LS12;Armley;Leeds;England;West Yorkshire;53.797092450;-1.592616360
GB;LS12;Beeston;Leeds;England;West Yorkshire;53.772296020;-1.567062410
GB;LS12;Farnley;Leeds;England;West Yorkshire;53.787427250;-1.613203440
GB;LS12;Leeds;Leeds;England;West Yorkshire;53.789192910;-1.593598450
GB;LS12;Lower Wortley;Leeds;England;West Yorkshire;53.785186160;-1.576192440
GB;LS12;New Farnley;Leeds;England;West Yorkshire;53.775367730;-1.620762560
GB;LS12;New Wortley;Leeds;England;West Yorkshire;53.792209100;-1.575107340
GB;LS13;Bramley;Leeds;England;West Yorkshire;53.801137490;-1.634497310
GB;LS13;Leeds;Leeds;England;West Yorkshire;53.820755690;-1.654610290
GB;LS13;Rodley;Leeds;England;West Yorkshire;53.823562010;-1.662687560
GB;LS14;Leeds;Leeds;England;West Yorkshire;53.812228390;-1.470303310
GB;LS14;Potterton;Leeds;England;West Yorkshire;53.851615090;-1.392853010
GB;LS14;Scarcroft;Leeds;England;West Yorkshire;53.866835350;-1.458485920
GB;LS14;Seacroft;Leeds;England;West Yorkshire;53.819023340;-1.460475020
GB;LS14;Thorner;Leeds;England;West Yorkshire;53.858965750;-1.426088170