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] 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 tool)

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

Welcome to the data cart tool, a powerful and easy-to-use way to make your own custom selections 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 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 geographic areas. Files can be downloaded in the regular way - the data cart is for linked datasets and for geographies.

Think of filling your cart as building up a spreadsheet: you'll need to add both rows and columns. What you'll end up with is a spreadsheet which cross references statistics (columns) against geographical areas (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.
  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 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 spreadsheet are geographical resources. Adding these is just as straightforward.

  1. Navigate to a geographic area of interest (tip: try the option 'Explore > By area') in the menu at the top of the page.
  2. Notice the buttons with a cart icon and a 'plus' symbol. Roll over a button to preview what it will do: for your convenience, you can add geographies in bulk, or individually.
  3. Click the icon and observe that the areas selected have been added to your cart.

Now you can add data and areas to your cart, you know everything you need to make your own custom spreadsheets.

Getting the most from the cart

Once you've saved your 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 cart' buttons on the saved cart view.

Pro tip: because you can add all the geographies and all the data separately and with a single click, one use for 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 cart
The cart requires you to have enabled JavaScript and local storage in your browser. There should be a link to the cart at the bottom 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 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 spreadsheet
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 each dataset and geography you use.