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).
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.
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:
- country of birth
- language and religion
- 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.
Earlier today, ONS published the following five tables:
- AP1101EW Sex by five-year age group (non-UK born short-term residents)
- AP1102EW Sex by single year of age (non-UK born short-term residents)
- AP1201EW Country of birth (non-UK born short-term residents)
- AP1202EW Passports held (detailed) (non-UK born short-term residents)
- AP1601EW Economic activity (non-UK born short-term residents)
A further four Quick Statistics tables were also released, detailing Passports held, Country of birth, National Identity, and Approximate social grade.
These tables can be downloaded from the ONS website and will be available in SASPAC shortly.
ONS published a 2011 Census update letter earlier this afternoon, reporting on imminent plans for Census releases 3 and 4. Key points from this letter are:
- Non-UK born short-term residents and detailed tables relating to Passports Held, Country of Birth, and National Identity will be released 26 March.
- Release 3 will now be Detailed Characteristics at local authority level, followed by MSOA and Ward geographies, and will begin in May.
- Local Characteristics data will now be Release 4 (summer).
- More details of the exact timings of these releases are expected in April.
As usual, all of the above data will be available through SASPAC.
Building on the current System Files (.sys) downloads available for various geographies in England & Wales, new data is now available to download!
- 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.
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).
If you have any issues relating to this release or the Census date available please contact the helpdesk.
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.
The first ONS Census newsletter of 2013 was published earlier today. This edition reports on December’s release of the second set of 2011 Census results and incorporates details of the upcoming January/February outputs. Included in this edition is the following:
• Details of data tables to be released on 30 January and 19 February;
• January release of additional Census geography products (boundaries/lookups);
• Bulk data release and distribution of associated supporting information;
• Survey for Local Authorities regarding the benefits gained from Census data;
• ONS Census advisory groups and details of meetings;
• Links to useful census websites
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.