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] A saved data cart

Midlothian LA 2001 Data Zones

A data cart containing all 112 2001 Data Zones within Midlothian Local Authority. (This customised collection of data was created by one of our users, using the Data cart)

Download
Cart contents as spreadsheet CSV
Share

This cart has a permalink which can be bookmarked or shared via social media, email etc

http://statistics.gov.scot/carts/408e799e-103a-4daa-a3dd-5665a26ac449
Columns (dataset slices): 0
Rows (features): 112
2001 Data Zones (112 features)
S01004150 Add 1 to data cart
S01004177 Add 1 to data cart
S01004199 Add 1 to data cart
S01004134 Add 1 to data cart
S01004212 Add 1 to data cart
S01004178 Add 1 to data cart
S01004180 Add 1 to data cart
S01004208 Add 1 to data cart
S01004218 Add 1 to data cart
S01004162 Add 1 to data cart
S01004217 Add 1 to data cart
S01004147 Add 1 to data cart
S01004186 Add 1 to data cart
S01004148 Add 1 to data cart
S01004214 Add 1 to data cart
S01004153 Add 1 to data cart
S01004138 Add 1 to data cart
S01004164 Add 1 to data cart
S01004220 Add 1 to data cart
S01004219 Add 1 to data cart
S01004136 Add 1 to data cart
S01004225 Add 1 to data cart
S01004183 Add 1 to data cart
S01004228 Add 1 to data cart
S01004146 Add 1 to data cart
S01004151 Add 1 to data cart
S01004128 Add 1 to data cart
S01004169 Add 1 to data cart
S01004174 Add 1 to data cart
S01004192 Add 1 to data cart
S01004163 Add 1 to data cart
S01004159 Add 1 to data cart
S01004211 Add 1 to data cart
S01004188 Add 1 to data cart
S01004221 Add 1 to data cart
S01004144 Add 1 to data cart
S01004229 Add 1 to data cart
S01004195 Add 1 to data cart
S01004141 Add 1 to data cart
S01004191 Add 1 to data cart
S01004168 Add 1 to data cart
S01004125 Add 1 to data cart
S01004185 Add 1 to data cart
S01004143 Add 1 to data cart
S01004176 Add 1 to data cart
S01004145 Add 1 to data cart
S01004210 Add 1 to data cart
S01004124 Add 1 to data cart
S01004171 Add 1 to data cart
S01004226 Add 1 to data cart
S01004202 Add 1 to data cart
S01004200 Add 1 to data cart
S01004154 Add 1 to data cart
S01004216 Add 1 to data cart
S01004209 Add 1 to data cart
S01004173 Add 1 to data cart
S01004232 Add 1 to data cart
S01004155 Add 1 to data cart
S01004166 Add 1 to data cart
S01004175 Add 1 to data cart
S01004196 Add 1 to data cart
S01004121 Add 1 to data cart
S01004204 Add 1 to data cart
S01004152 Add 1 to data cart
S01004158 Add 1 to data cart
S01004181 Add 1 to data cart
S01004198 Add 1 to data cart
S01004130 Add 1 to data cart
S01004224 Add 1 to data cart
S01004189 Add 1 to data cart
S01004135 Add 1 to data cart
S01004157 Add 1 to data cart
S01004140 Add 1 to data cart
S01004187 Add 1 to data cart
S01004201 Add 1 to data cart
S01004222 Add 1 to data cart
S01004149 Add 1 to data cart
S01004129 Add 1 to data cart
S01004137 Add 1 to data cart
S01004230 Add 1 to data cart
S01004172 Add 1 to data cart
S01004142 Add 1 to data cart
S01004131 Add 1 to data cart
S01004133 Add 1 to data cart
S01004231 Add 1 to data cart
S01004123 Add 1 to data cart
S01004139 Add 1 to data cart
S01004182 Add 1 to data cart
S01004206 Add 1 to data cart
S01004179 Add 1 to data cart
S01004194 Add 1 to data cart
S01004161 Add 1 to data cart
S01004223 Add 1 to data cart
S01004193 Add 1 to data cart
S01004167 Add 1 to data cart
S01004156 Add 1 to data cart
S01004126 Add 1 to data cart
S01004227 Add 1 to data cart
S01004184 Add 1 to data cart
S01004197 Add 1 to data cart
S01004190 Add 1 to data cart
S01004203 Add 1 to data cart
S01004122 Add 1 to data cart
S01004165 Add 1 to data cart
S01004205 Add 1 to data cart
S01004127 Add 1 to data cart
S01004170 Add 1 to data cart
S01004215 Add 1 to data cart
S01004132 Add 1 to data cart
S01004207 Add 1 to data cart
S01004213 Add 1 to data cart
S01004160 Add 1 to 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.