When was the data last updated?

The last data update was on the 16th October, 2023.

Does it include all places in the UK?

Yes. The data contains all cities, towns, villages, hamlets and suburban areas in the UK, as recognised by Ordnance Survey. It covers England, Scotland, Wales and Northern Ireland in full, and for convenience also includes towns and villages in the Isle of Man. Historical settlements are not included.

How will I receive the data?

Immediately after buying the data you'll be given a unique download link, which you can use to download a zip file containing the full database to your computer.

We'll also send you an email containing a receipt for your purchase and a copy of the download link. If you choose to pay by credit/debit card, this email will be sent to the address you provide during checkout. If you choose to pay with PayPal, the email will be sent to the primary address associated with your PayPal account.

Who else uses your data?

Our data has been downloaded and used by thousands of customers since we launched 12 years ago, from major national companies (like Accenture, Lloyds Banking and Hays Recruitment), through to boutique web development, design and marketing agencies across the UK.

Can I get a different sample?

Yes. If our sample data doesn't give you the assurances you need, please feel free to contact us for a custom sample extract.

---

Are future updates included?

If you purchase the 'Subscription' package, then data updates are included for a period of 1 year after your purchase. At the end of this period, you can choose to renew your subscription (and continue receiving updates) or not.

If you purchase the 'Solo' package, then data updates are not included.

When will I receive updates?

Updates are performed four times per year at the start of January, April, July and October. After each update we’ll send you an email containing a download link for the new data.

Can I change the email address my updates are sent to?

Yes, that’s no problem. Simply send us a message to let us know your new email address, and we'll update our records.

---

How do I buy the data?

You can purchase the data online with credit card, debit card or PayPal by clicking here and then selecting the package that you want (either the 'Subscription' package with updates included, or the 'Solo' package without updates).

I'm not from the UK. Can I pay with different currency?

We accept payment by credit card, debit card or PayPal from almost anywhere in the world – including the United States, Canada, Australia and all EU countries. The appropriate amount in your local currency will be billed to your card or PayPal account based on the current interbank exchange rates.

Are my card details secure?

Yes. All credit and debit card payments are processed securely by Stripe, one of the world's largest and most trusted online payment services. Payments take place over a secure, encrypted connection and we do not permanently store or record your card details.

Do you provide a charity discount?

Yes. If you’re buying on behalf of a registered charity or non-profit organisation, please contact us and we will be pleased to give you a 25% discount.

Can I pay offline by purchase order or bank transfer?

If you can’t pay online by credit card or PayPal, we are happy to accept payment via purchase orders, UK bank transfers, or international bank transfers via Wise. Please message us to discuss your requirements and we will arrange the next steps with you.

---

Can I use the data commercially?

Yes. The data can be used for commercial and business purposes, on an ongoing basis, with no time limits, renewal fees, or limits on the number of users or devices. Please see the terms of use page for the full terms.

Can I use the data in software or websites?

Yes. Using the data in a software application or website (e.g. for location searches) is permitted, provided that you do not make the data available for users to download in bulk.

Can I use the data for academic research work?

Yes. Using the data for academic research is permitted.

What restrictions on use are there?

It is not permitted to publicly distribute the data (for example, by sharing links to it on the internet), or to directly resell the data as a standalone product. Please see the terms of use page for the full terms.

---

What character-encoding does the data use?

All files use UTF-8 for character encoding.

What is the SQL code for creating a table for the data?

The following code can be used to create a table for the data in all ANSI-compliant SQL databases:

CREATE TABLE uk_towns (
  id int NOT NULL, 
  name varchar(46), 
  county varchar(32), 
  country varchar(16), 
  grid_reference varchar(8), 
  easting int, 
  northing int, 
  latitude numeric(8, 5), 
  longitude numeric(8, 5), 
  elevation int, 
  postcode_sector varchar(6), 
  local_government_area varchar(44), 
  nuts_region varchar(24), 
  type varchar(13), 
  PRIMARY KEY (id)
)

Is the Welsh version of place names included?

When a place is also known by an official Welsh or Gaelic name, this is provided after the English language name in the data. For example Cardiff / Caerdydd and Wrexham / Wrecsam. The English language name is always given first, followed by a forward slash character and then the Welsh or Gaelic name.

How large is the data?

The data is contained in an 8.2MB zip file, which contains the data in CSV, Excel and SQL format. When decompressed, the file sizes are:

Format	File name	File size
CSV	uk-towns.csv	6.2MB
Excel	uk-towns.xlsx	4.5MB
SQL	uk-towns.sql	7.1MB