The very latest UK Postcodes as well as historic postcodes, linked to a series of flat Comma Separated Variable (CSV) files that open in Excel, Access and other applications capable of importing delimited text data (we're happy to supply in other formats as needed).
This product file consists of
:
-
List of every current UK Postcode
-
List of retired UK Postcodes
-
Postcode to County (Traditional)
-
Postcode to Country (Administrative)
-
Postcode to County (Administrative)
-
Postcode to Region (Administrative)
-
Postcode to District (Administrative)
-
Postcode to Electoral Ward (Administrative)
-
Postcode to Health Authority Area
-
Postcode to Westminster / English, Welsh Assembly and Scottish Constituencies
-
Postcode to Member of Parliament / Assembly (MP) Name for a Constituency
-
Postcode to Political Party for MP
-
Postcode to Grid References / Coordinates / Latitudes Longitudes
-
Postcode to Travel to Work Areas
-
Postcode to National Parks
More about the Postcode Files...
Traditional County Name
The Traditional County is the county name most recognised by the public even if the counties do not technically exist anymore – for example Middlesex. This county field is most useful for public facing website applications where users are requested to select a County for an address etc.
Administrative Country, County, Wards, Districts, Boroughs and Regions
Postcode to Country: Country Code & Country Name supplied for England, Scotland, Wales and Northern Ireland
Postcode to County: Administrative County Name
Postcode to Region: Government Office Region Name
Postcode to District: Local Authority official District Name. English Districts (metropolitan and non - metropolitan), London boroughs and unitary authorities average around 23 electoral wards/divisions each, Northern Irish districts around 22, Scottish council areas around 11 and Welsh unitary authorities about 40.
Postcode to Ward: Also known as Electoral Divisions in Wales and Isle of Wight: An administrative division of a city or borough that typically elects and is represented by a councillor or councillors. Wards are found in Scotland, Northern Ireland and England.
Postcode to Boroughs: A town or district which is an administrative unit, in particular. A town (as distinct from a city) with a corporation and privileges granted by a royal charter and who as a town sends representatives to Parliament. There are 32 actual boroughs, with a status similar to metropolitan districts, and also the City of London, which is a City Corporation and has a number of additional roles. Boroughs are further subdivided into electoral wards.
Postcode to Unitary Authorities: A unitary authority is a type of local authority that has a single tier and is responsible for all local government functions within its area or performs additional functions which elsewhere in the relevant country are usually performed by national government or a higher level of sub-national government
Health Areas
This database is widely used in Health Service applications for matching patient or staff records to the relevant health authority information and for statistical analysis of national health information. The data contains the codes and names for the Primary Care areas in England, Local Health Boards (LHBs) in Wales, Community Health Partnerships (CHPs) in Scotland and the Local Commissioning Group (LHG) in Northern Ireland. There are no codes or names for the Channel Islands.
Westminster / English, Welsh Assembly and Scottish Constituencies
A full database of over 2.5 million UK Postcodes with their respective Parliamentary Constituencies and the MP Name and Party Name for each area. The file includes NI, Welsh, English and Scottish Constituencies / Assemblies.
Grid References / Coordinates / Latitude Longitude
The definitive Postcode database which includes all Postcodes for the United Kingdom (England, Scotland, Wales and Northern Ireland) with their respective 6 figure OSGB grid references and Longitude and Latitude.
Travel to Work Areas
Travel to work areas were produced for the purpose of conducting labour market analysis and planning and are defined as areas where the majority of resident population also work within the same area.
National Parks
There are over 28,000 Postcodes falling within one of the 15 National Parks of the United Kingdom. If a Postcode isn't in the database, it doesn't fall within a National Park area.
Fields
Field |
File Name |
Example Content |
Postcode |
Postcode |
OX4 1SL |
Sector |
Postcode |
OX4 1 |
District |
Postcode |
OX4 |
Area |
Postcode |
OX |
Country Code |
Administrative |
E92000001 |
Country Name |
Administrative |
England |
Region Code |
Administrative |
E12000008 |
Region Name |
Administrative |
South East |
County Code |
Administrative |
E10000025 |
County Name |
Administrative |
Oxfordshire |
District Code |
Administrative |
E07000178 |
District Name |
Administrative |
Oxford |
Ward
Code |
Administrative |
E05006555 |
Ward
Name |
Administrative |
Iffley Fields |
Traditional County |
County |
BERKSHIRE |
PCO
Code |
Health |
E16000135 |
PCO Name |
Health |
Oxfordshire |
Health Authority
Code |
Health |
E18000009 |
Health Authority
Name |
Health |
South Central |
Pan SHA Code |
Health |
E19000002 |
Pan SHA Name |
Health |
Southern Programme for IT (SPFiT) |
Westminster
Constituency Code |
Parliament |
E14000873 |
Westminster
Constituency Name |
Parliament |
Oxford East |
Westminster MP |
Parliament |
Smith, Andrew |
Westminster Party |
Parliament |
Labour |
Scottish
Constituency |
Parliament |
Not a Scottish Constituency postcode |
Welsh Assembly |
Parliament |
Not a Welsh Assembly postcode |
PQI |
Grid References |
1 |
X_Coord |
Grid References |
452606 |
Y_Coord |
Grid References |
205091 |
Lon |
Grid References |
-1.238014 |
Lat |
Grid References |
51.741594 |
Travel To Work
Area |
Travel To Work |
Oxford |
National Park |
National Parks |
Not in a National Park |
Coverage
The Postcode Database covers the United Kingdom.
Supply Format
The data is supplied as a series of Comma Separated Variable (CSV) delimited text files, using double quotes by default. This field format will open very easily using almost any software application including but not limited to Excel, Word, Notepad, Access, SQL etc. Due to the size of some files, older versions of Excel (pre 2010) may not fully open the files supplied as these older versions of Excel limit any opened file size to the first 65,000 rows / records.
Delivery
The Postcode Database data is by default emailed at the time of order using a secure download link delivery method. If you require the data supplied in another format then we will be more than happy to accommodate you where reasonable to do so at no extra cost.
Licensing
The Postcode Database list is licensed annually for each user that has access to it.
Updates
The file is updated every three months and free updates will be made available to you so long as your licence remains current.