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.
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.
Please take some time to view our video training page; the videos available are great step-by-step guides of how to carry out common tasks.
There are currently 7 videos available with the most recent videos added being modules 4a & 4b, these modules show:
Module 4a – Demonstrates how to create new zones – By individual area selection.
Module 4b – Demonstrates how to create new zones – By reference to a gazetteer.
Please take a look and keep an eye out for more videos becoming available soon!
Recent months have seen a number of datasets released by the Census Offices for England & Wales and Scotland, the SASPAC team have been busy processing and quality assuring this data and are now in a position to release a software update to users. SASPAC v9.90 incorporates all the data tables currently available including the most recent updates:
England & Wales
- 21 Workplace for Output Areas/workplace zones and larger geographies
- 10 Workday tables for Output Areas and larger geographies
- Supplementary Release 2: 3 DC and 8 LC tables (published on 23/5/14)
- 6 Armed Forces tables for LA*
- QS613EW – detailed Country of birth table for LAs
*published for a limited number of LAs due to disclosure control
- Release 3f: 16 Detailed & 8 Local Characteristic tables relating to health, housing, population and diversity)
Here is a list of all the tables and datasets currently available for E&W (.xls) and Scotland (.xls).
In addition, the SASPAC team have also Incorporated the ONS Mid-year population estimate data from 2001 to 2012 for Output and higher geographies in E&W.
Users will need to download a small update to upgrade to v9.90, instructions on how to this can be found in the following Release note (.pdf).
Following release 2B of the Scottish Census results from NRS, the SASPAC team is pleased to release a software update to our
users. This release incorporates all the Key (29) and Quick Statistic tables (32) currently available for Scottish Census geographies.
SASPAC v9.85 is available to download from the software page along with update instructions (.pdf). This release includes:
- access to all Key statistics (with percentage values) and Quick Statistics tables;
- new “year” and “country” filters to restrict data searching/selection to just Scottish tables;
- enhanced hierarchic geography trees that present 2011 Output Areas within Multi-member wards, Postcode sectors and Datazones (facilitates easy selection of “all the OAs within area X”).
All the necessary System files may also be downloaded from our data page.
The next Census release for Scotland is scheduled for 18 December and will include four Key and 27 Quick statistics tables relating to Living Arrangements (planned table layouts). Please note, we also expect to release an updated full installation package later in December 2013, this will update all previous versions of the application.
Please contact the helpdesk if you have any issue with this release or require any further details.
Following the release of the 2011 Census Detailed Characteristics tables for Middle Layer Super Output Area (MSOAs) and Census Merged Wards on 12 July, SASPAC v9.83 is now available and provides access to all these datasets tables. Software update files (7MB .zip) and instructions (.pdf) are downloadable from our website.
In addition, updated System files relating to these new tables are available to download from SASPAC’s data page or a link to just the Detailed Characteristics datasets (National to MSOA/ward geographies) can be downloaded here (640 MB .zip).
Finally, following user demand, the software’s CSV export function has now been enhanced to include cell-level metadata descriptions:
|SASPAC CSV output without metadata:
|SASPAC CSV output available with v9.83 with metadata:
Users may also be interested in saving version of the Census table layouts for all the datasets currently available:
Quick Statistics table layouts (22.07.13) (pdf)
Key Statistics table layouts (22.07.13) (.pdf)
Detailed Characteristics table layouts (22.07.13) (.pdf)
Commissioned table layouts (22.07.13) (.pdf)
As tables are released/updated these layouts will be updated on our support page.
We thought it would be helpful to clarify the data we are expecting ONS to publish tomorrow as part of Release 3.2b:
– 2 new Welsh LA level tables: DC1103WA and DC2112WA (Household composition by dependent children and ability to speak Welsh)
– 62 (incs. 8 Welsh) Details Characteristic tables for Census merged wards and MSOAs; these have all been previously released at LA level as part of Release 3.1 and 3.2a
– 4 new regional DC tables and 14 new Commissioned tables relating to migration but for England & Wales only
Table layouts for the new tables can be found here (2MB .xls).
The SASPAC team will process and quality assure these outputs before releasing to our users, along with a small software update, early next week.
On Friday 28 June ONS published 34 Detailed Characteristics tables for Local Authorities in England & Wales. These tables represent release 3.2a and contain detailed cross-tabulations from the 2011 Census relating to housing, topics include:
- marital status/civil partnership
- living arrangements
- tenure/accommodation type
- Welsh language
- NS-SeC/Economic activity
A copy of the table layouts from these tables can be found on the ONS website.
The SASPAC team have processed and quality assured these datasets and the System files can now be downloaded from our data page. A link to download just these Detailed Characteristic System files can be found here (34 MB .zip). SASPAC requires a small number of files to be updated to integrate these new tables within its searching mechanism.
To update from v9.80 users will need to download these update files (7MB .zip) and follow the instructions in this release note (.pdf).
If users are already running v9.82, a simple update process is necessary using the files here (4MB .zip) and accompanying update note (.pdf).
To support users in accessing these new tables, we have a number of courses scheduled at City Hall in the coming months – visit our booking page for the latest dates or contact Wil Tonkiss for more details. All our course materials can be found on our training pages.
Please do not hesitate to contact the helpdesk if you have any issues with this release.
On the 16 May 2013 ONS published 42 Detailed Characteristics Census tables for Local Authorities in England & Wales. These tables represent the first detailed cross-tabulations to be released from the 2011 Census and, in most cases, will be released for ward and Middle Layer Super Output Area (MSOA) geographies. However, some tables will not be available for these small zones due to disclosure control. Of the 42 tables:
- nine are available for the nine English regions and Wales;
- one (DC6301EW) for 2011 Census Merged Districts1;
- 32 for Local Authorities in England & Wales (three are Welsh only)
A copy of these table layouts in Excel can be found here (.xls)
To support access to these new tables, the SASPAC team have produced an updated version of the application (v9.82). Due to the relatively small nature of the update and to help organisations’ avoid the, sometimes costly, process of arranging a full software installation the update files need to be simply “copy and pasted” to your current system. A release note (.pdf) explains how to go about this process and the relevant update files (6MB.zip) are available to download. Finally, the supporting System files for this release can also be downloaded here (28MB .zip).
This data release represents the first in a set of tables to be published as part of Release 3 and a further three subsequent releases (3.2/3.3/3.4) are expected to be made available over the summer months (between June and August). It is not currently clear what data will be available when but we will keep users up to data as soon as we hear more. More details relating to this release can be found on the ONS website.
1“2011 Census Merged District” geographies have been produced where small districts have been merged to ensure the confidentiality of individual’s personal information. The Isles of Scilly UA has been merged with Cornwall UA, and the City of London has been merged with Westminster.