NEW training videos!

31/07/2014

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 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!

Classroom


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.


SASPAC v9.90 Released

15/07/2014

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

Scotland

  • 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).

 


Scottish SASPAC update (June’14)

13/06/2014

The SASPAC team have integrated the latest Scottish Census Release 3E tables into the application and these are now available for users to download along with the supporting System filesUsers will need to download the latest System files and update their version of the application to access these new tables. Release 3e was published on 4 June and is made up of 12 tables::

  • 12 Local Characteristic tables
  • 7 Detailed Characteristic tables (3  only available at Scotland and Council area)

In previous blog posts we have mentioned that LC1110SC (Family composition by age of Family Reference Person (FRP)) and DC1120SC (Households with full-time students away from home and age of student by number of students) would be published as part of this release but they will be part of Release 3F, scheduled for the 25 June and will comprise of 29 tables.  The SASPAC team will make these tables available to users ASAP after this date.


NEW training module video available

10/06/2014

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:


SASPAC update for Scotland

29/05/2014

The NRS have begun to release the first 2011 Census cross tabulations (Detailed and Local Characteristics tables) as part of Release 3, these tables are being published between February and August on a topic by topic basis. saspac-logo-master-button-maze-name-256-reversed-out-rounded-with-shadowPreviously only univariate tables (Key and Quick Statistics) had been available.

To date, the following tables have been published:

  • Release 3a (27/2/14): 10 DC tables
  • Release 3b (19/3/14): 9 DC tables and 5 LC tables
  • Release 3c (9/4/14): 1 DC table, 13 LC and 3 Quick Statistics tables
  • Release 3d (15/5/14): 12 DC tables and 9 LC tables

(DC tables are available for ward/DC sectors and higher geographies, LC tables are available for Output Area and higher geographies).

In total there are now 32 DC, 27 LC, 62 Quick Statistics and 34 Key Statistics tables available for a range of geographies from national down to the Output Area level. A list of all the tables and titles released can be found here (.xls) To support access to these new tables and geographies, the SASPAC team have produced a software update to the current application (v9.85) and supporting System files. Users will need to download the latest System files and update their version of the application to access these new tables.

 

 


SASPAC v9.85 April update

17/04/2014

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
  • Grade
  • 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.

 


Do you need Census data on the Armed Forces population?

06/02/2014

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.


Next Census Release Dates

03/02/2014

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
  • Religion
  • Scots language skills
  • Ethnic group
  • Country of birth

There is currently already a draft tables available to download from the NRS website.


SASPAC Training Dates

16/01/2014

With Census data coming think and fast and training budgets (if you have one!) closing at the end of the march, you may be interested in the following SASPAC training dates:Classroom

  • 12 February – Cardiff, Data Unit – Wales
  • 19 February – London, City Hall
  • 18 March –  London, City Hall

We are also in the process organising additional dates in Scotland, these are likely to be in late February/early March. If you are interested in attending any of these courses, please contact the helpdesk.

The training course will provide users with all the tools they need to search, extract and customise Census data to meet their organisation’s needs. A copy of the training programme can be found here (pdf) and further details on our training pages.