The All-in-one Postcode Database

Download a free sample
Tried and tested with…
MySQL SQL Server PostgreSQL MongoDB SQLite Access PHPMyAdmin Open Office

Linked location data, designed for developers

Our data is designed to be simple, clean and consistent – with complete location data all in one file so you or your developers don't spend hours coding laborious lookups, mappings or conversions. Every record contains mappings to local town, county, country, local goverment area and region, plus accurate latitude–longitude and easting–northing coordinates and population counts. See the full database specifications.

Formatted for fast and easy use

Every download contains a range of common data formats, so you can get to work quickly and easily with the software of your choice. The formats included are:

  • SQL – Import scripts for standards-compliant databases including MySQL, PostgreSQL, SQL Server and SQLite.
  • CSV – Straightforward CSV format, suitable for nearly all spreadsheet applications, GIS systems and programming languages.
  • XLS – Formatted specifically for Microsoft Excel (97 or later).

Reliable, comprehensive and up-to-date

You can have complete confidence in the quality and accuracy of our data. We use the latest official open data from Government sources only. It undergoes a complete refresh every quarter (the last refresh was on the ) and the data is fully tested before each release. Download a sample to try on your computer.

Open licensing

Our data is produced using open data released under the Open Government Licence. This means we can offer the data with very permissive and flexible licence terms, including:

  • You can use the data throughout your organisation – there is no cap on the number of users.
  • You can use the data on multiple computers, databases and devices.
  • The data is yours permanently – there are no expiry times or recurring renewal charges.

Please see the terms of use for complete licensing information.

Relied on by UK businesses to power their websites and internal systems

It's perfect for:

“I'm extremely impressed with the accuracy of your data and it is just what we were looking for. Everything's super accurate.”

– Richard Borchard @ equimine.com

“When was it last updated?” and other FAQs

How will I get the data?

Immediately after purchase you'll be taken to a webpage with a permanent link to download your data. We'll also email you a copy of the download link (along with a formal receipt) so you've always got access to the data.

Does the database contain all postcodes?

Yes. It lists all 1,759,069 postcodes currently in use in Great Britain, with no gaps in the data. Historical and obsolete postcodes are not listed. Location information is provided for all geographic postcodes – including local town, county, country, easting-northing and latitude-longitude coordinates.

When was it last updated?

The last update was made on the . This release was a full quarterly refresh which introduced 4679 new postcodes and removed 2986 recently obsolete records.

Can I download a different sample?

Yes. If the standard sample data doesn't give you what you need please contact us to request a custom sample.