Saturday, 17 May 2014

Census 2011 Household composition by age and sex

The publication of release 3D tables enable analysis to be done on different age groups and separately for males and females

Children in lone parent families
In 2011, 25% of children aged 0 to 15 years old, live in a lone parent family.  This varies across areas in Scotland with the lowest percentage in Aberdeenshire at 13% and the highest in Glasgow at 38%





Adults living alone

In 2011, 16% of the population aged 16 and over live alone.  This varies by age group and between males and females as shown below.  Between the ages of 25 and 49, males are more likely to live alone than females at 19% and 11% respectively.  Whereas with people 65 and over, just over 40% of females live alone compared with just under 25% of males.
   




Overall 35% of people aged 65 and over live alone.  Comparing local authority areas indicates a wide variation in older people living alone. The local authorities with the smallest percentage of people living alone are East Dunbartonshire and Midlothian at 30% , with the highest percentages in Glasgow City (44%), Dundee City (40%) and West Dunbartonshire and Edinburgh City at 39%.  Some of this will relate to the higher mortality rates resulting in widowhood , but also might relate to variation in partnership formation and older people living with other family members. 




Living in a communal establishment


In 2011, overall 2% of the population of Scotland live in a communal establishment. In age groups 18-19 this rises to 12% with students living in halls of residence.  In the older age groups the percentage living in communals rises as people live in care homes. Females are more likely to live in a communal than males; for example in 90-94 year olds  15% males live in a communal in constrast to 26% of females. It is therefore important to remember to account for this population when looking at older populations.
 
 www.scotlandscensus.gov.uk
DC1104SC  - Residence type by sex by age
DC1109SC - Household composition by sex by age 

Tuesday, 13 May 2014

Census 2011 Release 3D - 3E

Scottish Census Releases 3D will be published on 15 May and will consist of the following tables:

                       
Release 3D                Table title
DC1101SC
Marital and civil partnership status by age - Household Reference Persons (HRPs)
DC1102SC
Living arrangements by sex by age - Household Reference Persons (HRPs)
DC1104SC
Residence type by sex by age
DC1106SC
Schoolchildren and full-time students living away from home during term time by sex by age
DC1107SC
Marital and civil partnership status by sex by age
DC1108SC
Living arrangements by sex by age
DC1109SC
Household composition by sex by age
DC1113SC
Age of youngest dependent child by household type
DC1119SC
Age of youngest dependent child by household composition
DC1201SC
Household composition by ethnic group of Household Reference Person (HRP)
DC2408SC
Length of residence in the UK by household size
DC2409SC
Length of residence in the UK by household type
LC1101SC
Marital and civil partnership status by sex by age - Household Reference Persons (HRPs)
LC1107SC
Marital and civil partnership status by age
LC1108SC
Living arrangements by age
LC1109SC
Household composition by age
LC1113SC
Age of youngest dependent child by household type
LC1201SC
Household composition by ethnic group of Household Reference Person (HRP)
LC2213SC
Country of birth by English language skills
LC2408SC
Length of residence in the UK by household size
LC2409SC
Length of residence in the UK by household type


Release 3E will be published on 4 June 2014 and will consist of the following tables:


Release 3E
Table Title

LC1102SC
Living arrangements by age - Household Reference Persons (HRPs)

LC1104SC
Residence type by age

LC1110SC
Family composition by age of Family Reference Person (FRP)

LC1112SC
Dependent children by household type by age

LC1114SC
Dependent children by family type

LC1118SC
Age of youngest dependent child by family type

DC1110SC
Family composition by age of Family Reference Person (FRP)

DC1112SC
Dependent children by household type by sex by age

DC1114SC
Dependent children by family type

DC1116SCca
Marital and civil partnership status by sex by age - People in communal establishments*

DC1118SC
Age of youngest dependent child by family type

DC1120SC
Households with full-time students away from home and age of student by number of students

DC4211SCca
Communal establishment management and type by ethnic group by sex*

DC4414SCca
Communal establishment management type by type of resident by sex by age*







 *these tables will be published at Scotland and Council Area level, only.


Release 3F will be published on 25 June 2014 and will consist of tables from the Health topic. 

Thursday, 3 April 2014

Finding out about Leith Scottish Parliamentary Constituency

The Area Profiles section of Scotland's Census website gives a snapshot of the data for an area, and enables comparisons with another area.

Here is an example comparing households composition in Edinburgh Northern and Leith with neighbouring Edinburgh Eastern Scottish Parliamentary Constituency.

 Single person households under 65

Edinburgh Northern and Leith -   34.8%

Edinburgh Eastern                  -    25.5%








Tuesday, 1 April 2014

Scottish Census migration data released as part of European Commission Census Regulation Stats

Census statistics appeared today on Eurostat census hub. This draws census statistics together statistics in a common format, and releases them down to NUTS3 regions.

https://ec.europa.eu/CensusHub2/query.do?step=selectHyperCube&qhc=false&countrycode=en-gb

There is also a release on the ONS website which includes 12 reference tables

http://www.ons.gov.uk/ons/rel/census/2011-census/european-commission-census-regulation-statistics/index.html

This release includes a table of migration (based on change of address since year prior to Census).  The following charts illustrate some of the patterns in this data for Scotland.



The areas where the highest percentage of residents have changed address include the cities of Edinburgh, Glsgow, and Aberdeen City - all areas with universities which attract migrants.

There is a very distinctive pattern of migration which results in a high percentage of people to have changed address for age groups 20-24 and 25-29 years.  There is also a high rate for children before school age.  Illustrated in chart below.  



The effect of student migration can be seen by comparing the levels of change of residence between areas with different numbers of students. Edinburgh with  Inverclyde, Renfrewshire and East Renfrewshire









Tuesday, 25 March 2014

Post Graduate Primary class - data handling and social subjects

This is the beginning of a post to provide some background data for students teachers to use in producing and interpreting charts with primary classes.

Here is a chart of household composition in Scotland with comparable figures for England,  Wales



Sources:
Census tables -
QS113SC,QS113EW

At a local level, the following gives the percentage of households in each electoral ward in Edinburgh.  This can be adapted for your own area.


What sorts of areas have the least one person households ?
And what about the areas with lots of one person households?


The chart below compares the percentage of single person households  in these areas, with the percentage of households in an area which are under 35 years(young households).



What does this suggest?

There are a couple of areas which are out of line, with the general trends. The class could investigate if there are any special features of these areas.
  • The Meadows ward seems to have an unusually high percentage of young households. 
  • The Southside ward has a relatively low percentage of young households.  
These statistics along with other characteristics which might be related to single person households are given in the table below

- the size of the house in terms of rooms
- a measure of underoccupancy (households with 2 or more rooms than required)




Data source here  http://bit.ly/1hmdykc


Tuesday, 18 March 2014

Census 2011 - more products on topic of ethnicity, language, religion and identity

Release 3B - Scottish Census 2011 tables 
- to be published 19th March

Details of all new tables planned
  - LC tables are produced for small areas including output areas and data zones



All the data contained in this release can be accessed through the Census Data Explorer on the Scotland’s Census website ( http://www.scotlandscensus.gov.uk  ).




Overview of Equality Results from the 2011 Census Release 2 
- to be published 21st March

The Scottish Government have analysed equality data from the 2011 Census Release 2 and will publish an overview paper drawing upon data from other already published sources.  It will focus primarily on ethnicity, religion and disability.
























.

Sunday, 9 March 2014

SMC Conference session on using Census Data in Schools

I attended the Scottish Mathematical Council Conference in Stirling University on Saturday 8th March and ran a session to introduce maths teachers to Census data.  The session was a brief introduction to the Census process, but mostly a hands on session to use the Census Data Explorer

Seemed to go down well and discussions at the end point to creating an online guide to using the website - maybe a demo of the stages to interrogate the data and then creating charts using it.  Now off to explore free software tools to do this. Slides available on Past Conference Presentations section of the SMC conference website  http://bit.ly/MZfoK6

Stages of the workshop

1) Area profiles - compare characteristics of two areas with Scotland

Comparison of responses to identity question in
Scottish Parliamentary Constituencies of Falkirk East and Linlithgow





2) Standard Maps 
 Screen shot of percentage of local authority responding Scottish Identity only
[Apologies Shetland seems to be off the map]




3) Standard Charts
Screen shot of chart of percentage reporting Scottish Identity only - sorted by council from Edinburgh City to West Dunbartonshire




4) Standard Outputs
Screen shot of method of selecting areas using map function




5) Downloaded tables of national identity by religion