Scotland’s Census- Release 1C (part one) now available


The Scottish Census has released more data collected during Scotland’s 2011 Census. The release, 1C (part 1), which can be downloaded here, includes:-

  • unrounded estimates of the usually resident population and households of Scotland and each Council and Health Board Area, by single year of age and sex;
  • unrounded estimates of the usually resident population of Scotland and each council area on Census day, by whether living in a household or communal establishment.

Plans for the future release of data from the Scottish Census can found here, in summary:

  • 15th August 2013- Population and household estimates by Postcodes, Output Areas and Datazones, as well as other geography products (lookup tables and boundary files).
  • (from) late September 2013- Key and Quick Statistics and Census Profiles.
  • Autumn 2013-   Local Characteristics and Local Themes.
  • Winter 2013/14- Detailed Characteristics and Themes.

ONS Census Release Schedule Aug’13 to Feb’14


ONS have just announced the Census release schedule for the next six months, more details are on the ONS website but you’ll find a short summary below:

  • 31 July 2013- LC on Ethnicity, Identity, Language and Religion for Output Areas in England and Wales.
  • 30 August 2013- LC on Health and Unpaid Care for Output Areas in England and Wales. DC for demography and families for MSOAs and wards in England and Wales.
  • September 2013- LC on labour market and qualifications. DC for communal establishments for MSOAs and wards in England and Wales.
  •  November 2013- DC for labour market and qualifications for MSOAs and wards in England and Wales.
  • December 2013- LC on housing and demography for Output Areas in England and Wales.
  • January 2014- LC on labour market and qualifications for Output Areas in England and Wales.
  • February 2014- DC for travel to work and armed forces for MSOAs and wards in England and Wales.

(LC = Local Characteristics, DC = Detailed Characteristics)

SASPAC v9.83 (with enhanced metadata)


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.

New Members


A warm welcome to colleagues at the Coast to Capital Local Enterprise Partnership who are now taking advantage of the SASPAC software initiative.


For those not already on board, here is a quick 2 minute introduction video:


Tomorrow’s Census Data Release (3.2b)


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.

SASPAC data releases


The SASPAC team have recently added the following datasets to our website:

  • 2011 Census Key/Quick Statistics and Commissioned tables for Clincial Commissioning Groups (CCG) in England. A link to the data download page is here or a direct link to download the Health System files is here (3MB .zip). The CCG geography has been created from a Lower Super Output Areas to CCG lookup available from the ONS Geoportal.
  • 2011 Census Commissioned Table CT0050: Method of Travel to Work (alternative) for Output Areas and above (supersedes CT0015 and 45 previously released for ward/LAs) has been added to the Commissioned tables System files. This table is comparable with data from the 2001 Census (UV039), unlike the previously published QS701EW
  • 2011 Census Administrative Ward boundary files in Mapshore (BDY),MapInfo (TAB) and ESRI (SHP) formats are now available to download.

Please contact the helpdesk if you have any issues downloading these files.

Update on Scottish Outputs


NRS have announced a change to the timetable for the forthcoming Census outputs, with Release 1C now being split into 2 parts:

  1. 23 July: population estimates by single year of age and sex for Scotland, Council Areas and Health Boards
  2. 15 August: population estimates and household estimates by Postcodes, Output Areas and Datazones, along with supporting digital boundaries and lookup tables

and, the first phase of Release 2 (Key and Quick Statistics tables) will be available from late September.

The latest version of the Output Prospectus is available from the NRS website.

ONS Outputs Update


ONS have recently updated plans for the next Census outputs, with Release 4 now beginning on 31 July and before the end of Release 3. A timeline of what to expect  next, as it currently stands, is below:

  • 12 July: Release 3.2b – MSOA and ward level Detailed Characteristic tables (for the 76 tables already available at LA level) + 21 additional tables (14 national, 5 regional and 2 at LA level)
  • 31 July: Release 4.1 – Output Area level Local Characteristic tables relating to ethnicity, identity, religion and language
  • 30 August: Release 3.3 – MSOA and ward level Detailed Characteristic tables relating to the Demography topic

More details relating to these releases can be found on the ONS website, along with the latest Release 3 layouts. It’s not currently clear when Armed Forces or Detailed Theme tables can be expected but we’ll keep users posted as soon as we know more.

Census Release 3.2a and Training courses


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.