SASPAC v9.93 is now available to download to our all users, this includes:
- Scottish Census releases I, j and k (41 DC and 43 LC tables)
- 2011 ONS Flow data: Public and Safeguarded*
- 2013 Mid-Year Population estimates (single year of age by sex for OAs and higher geographies)
*The first Safeguarded OD tables have begun to be released via the UK Data Service: 8 migration tables relating to OAs and merged ward geographies were released on 3/12/14. There is a plan to publish around 200 tables via this route between January-March next year. Remember there are additional terms and conditions regarding the use of these statistics and we will be providing more details in a blog post soon.
A release note with update instructions can be found here, whilst the relevant SASPAC System files for E&W can be found here and the Scottish data 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.
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!
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).
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).
All of our training videos are basic step by step guides of how to carry out certain modules.
If you are not already aware of what the SASPAC features are then please watch this 2min video clip for a better understanding, you can also access the other training module videos here.
However please take a second to view our latest training video which shows how to output information and map data from SASPAC:
NRS have confirmed that on the 15 May 2014 they will be publishing Release 3D Census tables. This contains data on Population and Households, Ethnicity, Identity, Language and Religion and will contain 24 tables, 13 of which are Detailed Characteristic tables and 11 are Local Characteristic tables.
If you would like to see more scheduled release dates and draft table layouts for this release please check here.
March and April saw ONS release 65 new Census tables for England and Wales, these included:
- 3.5c – 8 Detailed Characteristic and 1 Quick Statistics table relating to Approximated Social
- 3.6 – 20 Detailed Characteristic tables relating to travel to work and car or van availability (
- Local Authorities only)
- 4.6 – 26 Local Characteristic and 1 Quick Statistics table relating to travel to work and car or
- van availability (Output Areas)
- Supplementary tables on 9/4/14 – 9 Local Characteristic tables relating to a range of topics
To provide access to these tables users will need to update to the v9.85 (April update) available from our software download page and download the latest System files from our Data page. Layouts of these tables can be found below and an Excel file of all the tables released to date can be found here (.xls).
– new Quick Statistics tables (.pdf)
– new Local Characteristics tables (.pdf)
– new Detailed Characteristics tables (.pdf)
Copies of table layouts released to date can also be found on our Support page.
The 2001 Census produced a number of tables at ward level specifically relating to the armed forces population (AF001 to AF004). This population is likely to be geographically concentrated across specific local authorities but key to understanding service provision and demand. ONS are preparing the equivalent 2011 Census tables and have circulated some table mockups (.xls) for users to comment on. The current intention is to provide this tables at regional level only. ONS are keen to hear from users on their data requirements and requested feedback by 11 February.
ONS have announced the release date for the next Local Characteristics tables. The information will be found in tables 4.5a and 4.5b and will include topics on:
- Labour Market at output area level
- Qualifications at output area level
This release will be on the 26 February 2014. There are currently no drafts of this information published, but once available they will be accessible via here.
Also on the 27 February 2014, NRS will be releasing Scotland’s Census results part 3A, which provides 10 new tables:
- Age by sex
- Ethnic group
- National identity
- Proficiency in English
- Scots language skills
- Ethnic group
- Country of birth
There is currently already a draft tables available to download from the NRS website.