2011 Census Flow data in SASPAC

04/02/2016

All 2011 Origin/Destination Census flow tables have been released by ONS and are available through a small software update.

In total there are 147 ‘Public’ and ‘Safeguarded’ flow tables available for users to access through SASPAC on their desktop.

Public SASPAC System files are downloadable from here.

Safeguarded System files may be downloaded from the UK Data Service website but require users’ to agree to additional t&cs via a ‘Safeguarded licence’ provided by the UK Data Archive  – see here (.pdf) for guidance on how to do this.

A release note with update instructions can be found here, whilst the latest SASPAC System files can be found here. Please contact the helpdesk if you have any issues with this update.


New 2011 Census Datazones for Scotland now in SASPAC

21/11/2014

NRS have recently published the new 2011 Census Data zones and Intermediate zones areas – previously Census data has been published for 2001 DZ/IZ on a best-fit basis. The 2011 lookup tables are available to download from the NRS websiteDownload SASPAC Installer

These zones have been created by aggregating 2011 Census Output Areas (on an exact-fit basis). The SASPAC team have created Key Statistics, Quick Statistics and Local Characteristic datasets for these new zones and the System files are now available for download from our data page or a direct link to the System files is here (743MB .zip).

Data has been generated using SASPAC’s rezoning facility – remember you can create your own custom areas and all the steps are explained in Module 4b. When viewing these new geographies in SASPAC the zones will appear as flat trees (i.e not grouped by LAs), we are currently updating the software to incorporate these hierarchies and a software release will be available shortly.


Incorrect 2011 Workplace flows

19/11/2014

Following users’ concerns over unusual flows in the 2011 Workplace tables released at the end of July (i.e. flows between LAs with large distances between them), ONS have investigated the issue and discovered errors in the coded workplace addresses. There is no plan to re-release these tables but a quality report (pdf) is now available which explains the issues and areas effected.


ONS corrections

22/08/2014

2011 Census: Workday Population Statistics for Middle Layer Super Output Areas (MSOAs) and Output Areas in England and Wales (Part 2)

A production error was discovered in table WD1101EW. The workday populations for eight Output Areas were incorrect – with some cells containing inconsistent counts for age or sex categories that did not sum to the total population. The eight Output Areas affected were: E00015045, E00023289, E00049002, E00159643, E00172150, E00170915, E00172167, E00174876 (across LB of Kingston and Wandsworth, Warwick, and Coventry) . Correcting the figures for these areas has resulted in changes to the figures for five Middle Layer Super Output Areas (MSOAs).

The SASPAC team have corrected these System files and updated the Workday tables for MSOAs in England and OA in West Midlands and London. The new System files may be downloaded from here.


Census Flow data update

13/08/2014

ONS have recently announced further details on how to access the 2011 Origin-Destination (OD) datasets. The safeguarded tables are now expected to be released via the UK Data Service available in September. To support this, SASPAC have been working with ONS to make these tables available to download from the UK Data Service in a SASPAC format (.SYS). This means users will be able to: download the data from the UKDS, a software update from www.saspac.org and access these tables on their desktops. To prepare for the data, we would recommend registering for the UKDS now (open to academic/public sector users) and then signing up to the additional safeguarded t&cs when the data is published.

The SASPAC team have been working on the integrating the OD Public tables recently published. However, having raised some potential issues in the data with ONS, some corrected data was released yesterday (12/8/14) but there are still some outstanding issues – once we are confident in these datasets we will release these to our users.

A reminder that these public, safeguarded and secure OD data releases are just the priority tables and a lot more are due to be published in November/December this year.

 


SASPAC & Census flow data

24/07/2014

The Data

The Census Offices are preparing to begin publishing the 2011 Census flow data, these tables will include 4 datasets:

  1. Special Workplace statistics (SWS) – travel from usual residence to workplace (or place of study in Scotland)
  2. Special Migration statistics (SMS) – address 1 year prior to census day
  3. Special Student statistics (SSS) – student migration
  4. Special Residence statistics (SRS) – location of second residence

For all 4 datasets a set of England & Welsh and UK tables will exist.

How will I be able to access the data?

ONS have developed 3 levels of licence to access the data:

Public: openly available anyone and accessible to SASPAC users like any other Census data. These will include a small number of simple tables published for large geographic areas such as local authorities/MSOAs.

Safeguarded: available to researchers under a separate licence agreement. SASPAC are currently working closely with ONS and the UK Data Service to enable these tables to be available to our users on the day of publication (at this stage it is expected that the Safeguarded data will require users to agree to individual terms and conditions which will allow them to download the data in a SASPAC format. Data will then be accessible like any other dataset in SASPAC on their desktop).

These are slightly more detailed tables for larger geographies or simple tables for smaller geographies such as OA/WPZ/ward.

Secure: accessible via the ONS Virtual Microdata Laboratory (VML) held at Titchfield, Southampton. These will include the most detailed cross tabulations, available for the smallest Census geographies and data will only be released to users following ONS approval. SASPAC will be available to access these tables in the VML.

A new VML is currently under development by ONS and expected to be available at other sites across the E&W towards the end of the year.

When will the data be published?

Public tables: 25 July – 9 for E&W (3 SWS/6 SRS)  and 11 for UK* (6 SMS/3 SWS/2 SRS). These are ‘priority tables’ and more tables are planned from November 2014.

Safeguarded tables: August (date TBC) – 4 E&W (SMS) and 10 UK* (4 SMS /6 SWS). These are ‘priority tables’ and more tables are planned from November 2014.

Secure tables: details and date TBC

* Initially UK tables with only include England, Wales and NI flows. This is because issue has been identified with the Scottish data by NRS.

How to access the data?

Public – available to SASPAC users in the usual manner; users will be informed when system files are available for download.

Safeguarded – available to researchers under a separate licence agreement. SASPAC are currently working closely with ONS and the UK Data Service to enable these tables to be available to our users on the day of publication (at this stage it is expected that the Safeguarded data will require users to agree to individual terms and conditions which will allow them to download the data in a SASPAC format. Data will then be accessible like any other dataset in SASPAC on their desktop).

These are slightly more detailed tables for larger geographies or simple tables for smaller geographies such as OA/WPZ/ward.

Secure: available through SASPAC via the ONS VML

What SASPAC support will be available?

The SASPAC team are currently preparing/updating training materials to support users’ access to the 2011 flow datasets. We expect to make half-day training sessions available to users and we will post dates on our website shortly. In the meantime, if you wish to get familiar with the 2001 flow data, the data may be downloaded from our website along with supporting 2001 training materials.


Revisions and corrections in NRS data

23/07/2014

NRS have discovered an error in the original published versions of tables including information on country of birth, the tables involved were released in the following:

  • 26 September 2013 – Release 2A – KS204SC, QS203SC, national level summary table on country of birth
  • 27 February 2014 – Release 3A – DC2205SC
  • 19 March 2014 – Release 3B – DC2103SC, DC2207SC, DC2212SC, DC2802SC

However, all of these tables have now been updated in SASPAC and new System files can be downloaded from our website (here).