2011 Census Travel to Work commissioned table

15/05/2013

The GLA have commissioned a Method of Travel to Work table (CT0045)  for ward, LA/UA, counties and regions in E&W which is comparable with the 2001 table. This is identical to table CT0015 ONS previously released to support their own analysis but was only released down to district level.

This new table provides Census estimates that are consistent with the classifications used in 2001 (table KS015), e.g. if a person indicates their place of work is at their home address but said that they travel to work by driving a car or van, they will appear in the category “Work mainly at or from home”, as was the case in 2001. In contrast, the 2011 table QS701EW uses a person’s method of travel to work to classify them, even if they have ticked the “Work mainly at or from home” category.

(We have requested ONS add geography codes to this file as it currently only contains names).


SASPAC Data update

07/05/2013

We have recently updated the System files available from our website to include:

- population centroid data for 2011 Census Output Areas, Lower Layer Super Output Areas and Middle Layer Super Ouptut Areas (the population weighted centroid is a single point that represent the median location of households). These may be extracted from the software using the header variables “Easting” and “Northing” which are stored on the updated System files.

- Quick Statistics tables: QS212EW (Passports Held (detailed)), QS214EW (National Identify (detailed)) and QS611EW (Approximate Social Grade).

This completes all the Key and Quick Statistics tables expected from the 2011 Census.

Next week (16/5) ONS will be releasing 42 Detailed Characteristic tables and will be the first detailed cross tabulations produced from the 2011 Census. This release represents Phase 1 of 3 in Release 3.0. 33 of these tables will be available for ward and Middle Layer Super Output Areas, 1 at Local Authority and 8 at regional level. The final table layouts can be found here (.xls).

Once the SASPAC team have loaded and quality assured this data, System files will be downloadable from the SASPAC website, along with a small software update. We’ll blog as soon as this data is available.


Next Census release – 16 May

25/04/2013

ONS have recently added the Census table layouts relating to Release 3.1 (tables in Release 3.1 (.xls)). These are the first set of detailed cross-tabulations released from the 2011 Census.

Release 3.1 will commence on 16 May and will include tables covering the following topics at local authority level:

2011-census

  • Migration
  • ethnicity
  • identity
  • country of birth
  • language and religion
  • health
  • Welsh language skills

Release 3.2 and 3.3 are expected in June and July.

For more information on Release 3, see the ONS website. ONS are expecting to provide further layouts and updates to tables as information becomes available.


Creating Improved Census Ward Population Estimates

22/03/2013

ONS’ GSS policy of best-fitting 2011 Census estimates (and other national statistics) from output areas has been causing issues for some local authorities that have seen ward boundary changes since 2003. SASPAC has received considerable interest from users on this particular issue as well as discussion on the StatsUserNet and Knowledge Hub forums.

The Issue

All 2011 Census ward estimates have been created using a method of best-fitting from the population weighted centroids of the underlying 2011 Census Output Area (OA). The population weighted centroid is a single point within the OA that represent the median location of households. The whole population of this OA is then assigned to the ward in which it falls. This means that where OA boundaries no longer match ward boundaries (i.e. they have changed since 2003 when the 2001 Census OAs were produced on an exact-fit to wards) the population/household estimates may not reflect all households physically located within the ward boundary. Conversely households outside the ward boundary may be included.

ONS-Best-fit

2011 best-fit of OAs to Wards: OA4 is allocated to WARD 2 because OA4′s population weighted centroid falls within the WARD 2 boundary (Source: ONS, An overview of best-fitting: Building 2011 Census Estimates from Output Areas)

Creating improved estimates

This is leading many organisations to look out how they can create improved best-fit estimates using alternative methods of redistributing the OA population more accurately. A number of methods can be used such as:

  • using the proportion of each OA’s areal extent that falls within each ward (assumes the population is evenly distributed across the OA) or,
  • using Census day address lists (e.g. Royal Mail Postcode Address File or the Local Land and Property Gazetteers maintained by local authorities) to distribute the population. Tees Valley Unlimited have very helpfully documented their approach here.  

Another approach will be possible when the 2011 Census Unit Postcode Headcount data (Postcode estimates tables are currently expected in May (p35 of the 2011 Census Prospectus (.pdf)) are published. These will provide details of the number of males, females and occupied households for each Census day postcode and will provide a very accurate method of redistributing the population to ward boundaries.

How SASPAC can help?

Once you have created the improved OA population distributions, SASPAC’s rezoning tool can then be used to easily recreate all the Census tables for these more accurate ward household or population distributions. For more information in how to rezone in SASPAC see Module 4 of our training manual.

Census estimates for other areas such as Parishes have also been best-fitted from whole OAs. This re-estimation method can be applied to any zones where best-fitted figures are insufficiently precise.

But remember…

Creating your own local ward estimates will produce alternative figures to those officially produced by ONS and should be documented and correctly labelled as such to avoid any confusion. Also, the best-fit methodology will be applied to create other ONS datasets, so care should be taken to use denominators created using the best-fit method.

Some useful resources:

ONS page on exact and best-fit estimates

ONS overview of the best-fitting methodology

Download median population weighted centroids for output areas, super output areas and workplace zones in shp and mid/mif format.

ONS National Postcode Directory

ONS 2001/2011 Census geography lookups products


Scottish Census Release

21/03/2013

Today NRS released the latest results from the 2011 Census. Release 1B includes:

  • usually resident census population estimates (rounded to the nearest 100) for Scotland, by five-year age bands and sex;
  • usually resident census population estimates (rounded to the nearest 100) for each council area, by five-year age bands and sex;
  • estimates of number of households (rounded to the nearest 10) for Scotland and each council area
  • Additional Quality Assurance, methods material and interactive data visualisations.

Individual tables in xls, csv and pdf formats are available to download from the NRS download page.

scotlandscensus2011logo

The next data release is scheduled for May and will include single year of age estimates for council areas. For more details on subsequent releases see the latest Census Output Prospectus available from here.


Scotland 2011 Census Update

08/03/2013

Yesterday, NRS published an update to the 2011 Census Outputs Prospectus for Scotland. The key points are:

NRS

  • Local Authority level five-year age band population estimates (release 1B) are scheduled for release on 21 March, with single year data (release 1C) following in May.
  • Key & Quick Statistics tables (release 2) will begin in Summer 2013, Local Characteristics (release 3) in Autumn 2013, and Winter 2013 (release 4) will contain Detailed Characteristics tables.
  • Table layouts for Key and Quick Statistics are now available on the NRS website (.xls)
  • NRS are keen to hear from users if they should follow ONS/NISRA and change the order of Releases 3 and 4

All the Census outputs relating to releases 2, 3 and 4 will be made available through SASPAC.


More and updated Census data available for download!

19/02/2013

Building on the current System Files (.sys) downloads available for various geographies in England & Wales, new data is now available to download!

This includes:

  • USOAs (Wales only)
  • Parliamentary Constituencies
  • Parishes in England & Communities in Wales
  • Primary Care Organisations (PCOs) in England/Local Health Boards (LHB) in Wales and Strategic Health Authorities (SHA) in England

In addition, ONS recently notified Census users of an error relating to Quick Statistics table  QS203EW (Detailed Country of Birth). The error was present across all Census releases on the ONS website (including bulk data outputs) going back to December 2012. SASPAC has corrected these tables and, to assist users data management, is maintaining a list of all data corrections/re-releases (.xls) on our website. Following its recent release, this and previous data may be accessed using SASPAC v9.80.

ONS also published the following datasets earlier today:

  • KS for National Parks in England and Wales
  • KS and QS for Postcode Sectors
  • KS and QS for National Assembly for Welsh Constituencies

The SASPAC team are currently processing the data, which will be available for download shortly.


SASPAC v9.80 Released

08/02/2013

ONS published the latest release of 2011 Census data on the 30 January 2013. This included 104 Census tables (35 Key Statistics (KS), 68 Quick Statistics(QS) and one Commissioned Table) for the Output Area (OA, Lower SOA and Middle SOA) and Ward geography hierarchies in England & Wales. This builds on the local authority KS and QS tables released on 11 December 2012.  A list of tables available in this release can be found here (.xls), as well as the table layouts (.xls).

To access these new tables the SASPAC team have prepared and provided an updated version of the application (v9.80), which is available for download. In addition, all the SASPAC System files have been added to our data page and may be downloaded (Please be aware of the file sizes when downloading).

SASPAC v9.80

If you have any issues relating to this release or the Census date available please contact the helpdesk.


30th January Census Data Release

25/01/2013
Many of you will be aware that the next Census 2011 data release (Release 2.2) is imminent, with the release of Key Statistics (35 tables) and Quick Statistics (69 tables) for Output Area, ward, parish and parliamentary constituency geographies expected next week. A list of table names and numbers can be found here (.xls). The latest table layouts are available from the ONS website but be aware as these may change before next week’s release date.

Once the SASPAC team have quality assured the data and created System files these will be made available for download via the data page of our website. To support the new 2011 statistical geography an updated version of the software (v9.80) will also be available to members for download. Followers will be notified as soon as software and the data is available via our blog.


A Happy New Year (and some more data)!

04/01/2013

A Happy New year to all SASPAC users and blog followers.

An exciting year of 2011 Census data releases is ahead of us and has already begun with the (delayed) release of Quick Statistics Table QS209EW by ONS yesterday. The table supplements the data for 18 ethnic groups previously released in KS201EW on 11 December and includes details for 91 ethnic groups. In addition, ONS have also provided a commissioned table (CT0010EW) that includes details of the ‘write-in’ responses for the ethnic group question.

Due to the table definition for QS209EW changing from that previously specified by ONS, users interested in accessing this table will need to update a small number of files in v9.75 – please contact the helpdesk for details. SASPAC System files including this table are available to download.

If you are happy to wait, this table will be incorporated as part of the next software release in early February.

 


Follow

Get every new post delivered to your Inbox.

Join 175 other followers