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

User data cart

(This customised collection of data was created by one of our users, using the Data cart)

License

The datasets used by this data cart are licensed under the following licences:

Download
Cart contents as spreadsheet CSV
Share

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

https://statistics.gov.scot/carts/0d2326ea-b3b4-4049-967f-fdb39f025d5e
Columns (dataset slices): 2
House Sales (1 column) Add 1 to data cart
measure type = Count, Reference Period = 2003 Add 1 to data cart
Fire (1 column) Add 1 to data cart
measure type = Count, Reference Period = 2012, Indicator (fire) = Number Of All Fires Add 1 to data cart
Rows (features): 32
Add all 32 to data cart
Council Areas (32 features)
Dundee City Add 1 to data cart
North Ayrshire Add 1 to data cart
Fife Add 1 to data cart
Perth and Kinross Add 1 to data cart
West Lothian Add 1 to data cart
Scottish Borders Add 1 to data cart
Falkirk Add 1 to data cart
Highland Add 1 to data cart
Moray Add 1 to data cart
City of Edinburgh Add 1 to data cart
East Ayrshire Add 1 to data cart
Dumfries and Galloway Add 1 to data cart
West Dunbartonshire Add 1 to data cart
Angus Add 1 to data cart
Stirling Add 1 to data cart
Clackmannanshire Add 1 to data cart
Orkney Islands Add 1 to data cart
Shetland Islands Add 1 to data cart
East Lothian Add 1 to data cart
Aberdeen City Add 1 to data cart
South Ayrshire Add 1 to data cart
South Lanarkshire Add 1 to data cart
North Lanarkshire Add 1 to data cart
Aberdeenshire Add 1 to data cart
Comhairle nan Eilean Siar Add 1 to data cart
East Renfrewshire Add 1 to data cart
East Dunbartonshire Add 1 to data cart
Glasgow City Add 1 to data cart
Renfrewshire Add 1 to data cart
Inverclyde Add 1 to data cart
Argyll and Bute Add 1 to data cart
Midlothian 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.