Tutorial

Scenario

You are interested in finding out about the number of Males and Females who live in private rented accommodation and are in bad health for a range of age groups, and live in all wards of the Local Authority Amber Valley from the 2011 Census.

To start click 2011 Census data

Not all census data are available at all geographical levels, you have a choice to pick Geography or Topics first

  • Pick Geography

Geography step

In this step we can pick the areas for which you want data by using the + and - buttons to expand or collapse nested areas.

Geography types containing large numbers of areas (Wards and Electoral Divisions within the England, for example) can be chosen, but not expanded to avoid displaying huge lists. Individual areas for these geography types can be displayed by expanding within higher level geography types (Local Authorities, for example).

We would like all wards in the Local Authority of Amber Valley.

  • Expand Local Authorities (404 areas)
  • Expand Amber Valley
  • Tick Wards and Electoral Divisions (23 areas)
  • and tick Amber Valley

Geographies

Scroll to the bottom and:

Click Add
A summary of your selections will now be displayed, click Next

preview geographies

Topics step

Census data comes in predefined topic combinations. These can be found in the grid.

InFuse: Topics

On the left hand side of the screen you can filter the list. Notice that some Topics are greyed out, this is because not all data are available for all countries / geographical levels. Only Topics available at Ward level for Amber Valley are displayed.

On the left hand side of the screen you can filter the list.

  • Click General Health (notice that the amount of combinations have reduced to 17 topic combinations)
  • Click Age (the combinations have reduced further)
  • Click Sex
  • Click Tenure

You are now presented with one topic combination.
Click Select for the Age | General health | Sex | Tenure | Usual resident population combination

select topic combination

You will now see another screen giving you the definitions of the topics you have selected
Click Next

Topic descriptions

 

Categories step

In this step you pick the categories to make up your combination:

  • Age: pick all possible age categories
  • General Health: Pick Bad or very bad health
  • Sex: Pick Male and Female
  • Tenure: Pick Private rented or living rent-free

Categories

Click Add
A summary of your selections will now be displayed, click Next

preview categories

 

 

Step 4

You can now see a summary of your selections along with a File reference (which can be changed)
Click Get the data

Preview selections

An orange Download your data box will appear, click it and you are given the choice to open/save the zipped file as normal

Download data

 

Results

The output comes in a Zip file format, and will be named with a date stamp followed by the file reference (e.g.: 220167594459282_AGE_GENHEA_SEX_TENURE_UNIT_URESPOP.zip)
The zip file consists of three files:
Zip file

  • Citation File in rtf format, simply tells you how to cite the data.
  • Data file in csv format. This contains the data you have chosen. For example, you can see that Column L contains data for: 25 to 49 years old | Males | Bad or very bad health | Living in private rented or living rent free

Data file

  • Meta file: This file gives you further information about the data you have chosen. It includes full definitions for the components of your topic combination.

 

InFuse is part of the UK Data Service Census Support