add cart choropleth column cross cube error file folder geo help home lock obs poi rdf remove search slice spreadsheet success table unlock warning

[this is a data cart tool] Your data cart in progress

Your data cart

Using the data cart tool

Welcome to the data cart tool, a powerful and easy-to-use way to make your own data carts and combinations of our data. If you've ever shopped online, you'll be comfortable with how it works:

  1. Browse around the site, finding the data and places you're interested in.
  2. Click the 'add to data cart' button to store items you want to keep
  3. Edit, refine and organise your selections
  4. When you're ready, save the cart to download all your data in one simple file to use in your favourite spreadsheet programme, GIS system, or stats package.
Getting started

You'll find three kinds of data on this site: files, linked datasets and atlas 'features' (these are things related to a place: geographic areas or organisations). Files can be downloaded in the regular way - the data cart tool is for linked datasets and for atlas features.

Building up a data cart you'll need to add both rows and columns. What you'll end up with is a spreadsheet which cross references statistics (columns) against places (rows).

The columns are slices of linked data. It's easy to add these to your cart as follows:

  1. Navigate to the dataset you're interested in in the Data section of the site.
  2. Choose values for the dataset dimensions to focus in on the precise data you need. Keep going until you have narrowed your view down to a 2 dimensional spreadsheet view.
  3. Click the header of any column, and notice the pop-up menu. Select 'add column to data cart'.
  4. Congratulations, you've just added your first column of data!

Notice that you can add multiple columns of data from the same spreadsheet view, or you can navigate to other spreadsheet views of the same dataset and add columns of those, _or_ you can navigate to any other dataset and add columns from its spreadsheets. This is the power of the cart: to bring together data from anywhere across the site.

The rows in your data cart are areas or organisations. Adding these is just as straightforward: use the 'Add to Cart' buttons in the Atlas section

Now you can add data and areas to your saved data cart, you know everything you need to build your own custom downloads.

Getting the most from the data cart tool

Once you've saved your data cart, you'll see that it changes in several ways:

  • You can download its contents in CSV format, to open in your favourite spreadsheet application.
  • It has a permalink. You can bookmark this link to come back to your cart anytime, as well as sharing it with colleagues or on social media.
  • It is no longer editable. This is to ensure that the permalink always works. If you want to carry on adding to your cart, you can load the contents of this (or any) saved cart into your live cart simply by clicking the 'add to data cart' buttons on the saved data cart view.

Pro tip: because you can add all the rows and all the columns separately and with a single click, one use for data carts is to save, for example, a 'geographical areas only' cart with regions you frequently work with. Bookmark this, and then in future whenever you need to load up the areas, they're only a click away.

Troubleshooting

I can't find the data cart tool
The tool requires you to have enabled JavaScript and local storage in your browser. There should be a link to the tool at the top of every page, and as the first item in the 'tools' menu. If these are missing it's likely that JavaScript or local storage isn't set up correctly.

My work from yesterday has disappeared
Your data cart is emptied when you close your browser, or if your session is inactive for a long period of time. Remember to save your cart before closing your browser.

There are gaps in my data cart
We don't hold data for every possible combination of geography and statistics - for instance, particular information may not be available at all geographic levels. Your cart output shows everything that we have in our datastore, but it's very likely that you may see 'gaps' where no data were available.

What's the licence?
This is an important question, and one which you must consider if you plan to re-use the data. Most but not all of the data on this site are provided under open licences, but the cart allows you to combine data in many ways, and it is your responsibility to verify the licence of the data you use.