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.
In January 2015 ONS held a 2011 Census Outputs Evaluation workshop at City Hall, London. The meeting was an opportunity for reprsentatives from local authorities, business, academic and third sector Census users to feedback their experiences from 2011 to the Census Offices. Each sector presented their opinion of what ‘went well’ and what lessons need to be learnt for 2021. All the slides and a report (.pdf) from the day have now been published on the ONS website.
Callum Foster also shared some of ONS’ early thoughts on the potential data delivery channels we can expect following 2021:
Callum’s slides can be downloaded here (1MB .ppt)
2011 Census Safeguarded flow datasets have begun to be released by ONS and are now available in SASPAC. Currently 15 tables have been published via the UK Data Service, with further tables expected throughout Feb/March. Tables currently available include data on:
- Output Area to Workplace zone flow counts
- MSOA/Intermediate zone worker flows by age, sex and mode of travel
- Output Area to Output Area migrant flow counts
- ward to ward migrants flows by age groups and sex
A list of tables currently published is here (.xls).
Flow datasets are available under three levels of licence: Public, Safeguarded and Secure:
- Public – open and accessible like any other Census data (downloadable in SASPAC from here)
- Safeguarded – available to public sector and academic users to download in a SASPAC format from the UK Data Service – requires users to sign up to additional t&cs.
- Secure – available within the ONS Virtual Microdata Laboratory (VML) to Approved Researchers for specific projects – SASPAC is available in this environment.
Instructions on how to access the SASPAC data via these channels is explained in the attached guidance note (.pdf) along with important information regarding the End User Licence. Importantly, and unlike the majority of Census outputs, this licence has two specific conditions:
- data is licensed on an individual basis (not an organisation), so users are required to ensure only licensed individuals can access the Safeguarded data files.
- Users are also required to suppress any counts lower then 3 or replace 1s or 2s with 0 or 3.
SASPAC v9.93 is required to access these tables and more details on this dataset are available on our dedicated flow data page.
To support access to these datasets we are running a series of training courses specialising in flow data – a programme for the day is here (.pdf) and dates here. Flow data training materials and videos are also available.
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 website.
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.
Today ONS updated the timetable for the publication of the 2011 Census flow data. These datasets relate to:
- Travel to Work (or study in Scotland)
- Second Residences
- Student migration
The next data to be published will be four Safeguarded migration tables including:
- OA to OA/country flow (counts)
- ward to ward flows by sex and age
These are expected to be available later this month, with the Secure tables coming in November and safeguarded tables in December.
All Safeguarded tables will be available in SASPAC and users will be able to download the System Files from the UKDS website directly (having registered and accepted the T&Cs).
All Secure flow tables will only be accessible to approved researchers via the ONS secure VML (Virtual Microdata Laboratory). SASPAC will be available in the VML to allow our users to integrate these datatsets.
More details on the flow data, including table layouts, can be found on the ONS website and details of SASPAC’s specialist OD training courses here.
We have recently developed more training videos. Please take a look on our page to view these great step-by-step videos now currently available.
The most recent videos added are:
Part B and
This module shows you how to work with origin-destination dataset sets including filtering the data, rezoning to asymmetric zones and outputting the data into either an Excel pivot table or into Mapshore.
The SASPAC team have integrated the latest Scottish Census Release 3G and H tables into the application and these are now available to. Users will need to download the latest System files and update their version of the application to access these new tables. Details on how to update the software can be found here.
Release 3G and H were published on 23 July and 13 August:
- Release 3G: 12 Detailed Characteristic and 8 Local Characteristic tables (published on 23/7/14); tables relate to Labour Market and Education.
- Release 3H: 12 Detailed Characteristic and 12 Local Characteristic tables (published on 13/8/14); tables relate to Labour Market and Transport.
A list of all the Census tables and geographies currently available can be found here (.xls) If you have any query queries or issues applying this update please do not hesitate to contact the helpdesk.
The SASPAC team have developed a new training course to support users’ access to the Origin/Destination flow data that has begun to be released by the Census Offices. This dataset includes details of usual residents:
- Travel to Work (or study in Scotland)
- Second Residences
- Student migration
SASPAC provides users with the tools to access, manipulate and analyse this complex dataset. The course is designed for current users of the software interested in using the application to understand the flow data – a course outline can be seen here. The first course is scheduled for Wednesday 17th September at City Hall and more dates can be found on our booking page.
NB: In order register on this course you must have been on the Introduction to SASPAC course or be a long-time user of the software.
The first set of Public Flow data tables were released at the end of July and further releases (Safeguarded & Secure) are scheduled for the end of September and then again in November. All of these tables will be accessible through SASPAC either on users’ desktops (following the completion of the necessary licence) or the Census Offices physical sites via the Virtual Microdata Laboratory (VML).
Please contact firstname.lastname@example.org if you are interested in securing a place. We will allocate places on a first-come-first-served basis.
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.
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.