Census 2011 – Outputs & Analysis

1. Census 2011 – Outputs & Analysis What we have published, what we & others have planned and where can you find it 18th July 2013 Manchester

2. Aims of the day • Recap on what ONS has published so far • Gain an insight into how census is used • Share our thinking for our future plans and gain your input into this - particularly on plans for analysis • Gain an understanding of how others are planning to analyse census data • Information on how to access the data through ONS

3. Realising the benefits The census is a rich and unique data set • Census data are used to allocate funds • Local authorities use local data on populations so local plans better reflect future local needs and development happens in the right places • Census underpins consumer market research for the design of surveys • Census data help retail businesses tailor their stores so that they better match the interests of local people • Census data can shed light on policy or social issues – family types, carers, areas of deprivation, environmental pressures etc …and we aim to ensure that the opportunities that the census release presents are maximised

4. And finally… Benefit realisation quantification In liaison with users, catalogue the uses of the results, prepare case studies and, where possible, aim to place an economic value on the range of uses of data

5. Agenda

6. Twitter & Storify • Tweet questions to #2011Census • Follow the content online at http://sfy.co/sAjf

7. Ice breaker Provide an unusual or unexpected example of how you have used census data or are planning to use census data

8. What we have available: Outputs

9. What did we collect? • “Usual” and “Short-term” residents • Data to calculate alternative population bases • Weekday/Working day/Seasonal • Demographic data • Age, Sex, Marital Status • Cultural • Ethnic Group, National Identity, Religion, Language • Migration • Country of Birth, Passports, Month of Arrival

10. What did we collect? • Health and Care • General Health, Long-Term Illness, Unpaid Care • Labour Market • Economic Activity, Occupation, Industry, Quals • Addresses and Travel • Second, Workplace and Previous (1 yr ago) address • Method of Travel to Work • Housing • Accommodation, Tenure, Rooms

11. Releases to date • Numerous releases since July 2012 • Statistical Bulletins • Analysis to supplement the outputs • Interactive content • Univariate data for all topics • Age and sex, and occupied household estimates • Information about second addresses by age, sex and type • Key Statistics and Quick Statistics • Data available down to Output Area level • Around 300 people in an average OA • Range of other geographies

12. Census 2011: Population Counts • Population and household estimates • 16 July 2012 (Rounded, LA Level) • 24 September 2012 (Unrounded, LA level) • Second addresses • 22 October 2012 (LA level) • Population and household estimates • 23 November 2012 (Ward, OA level)

13. First release – Summary

14. 2011 Census: Univariate releases • Keystatistics • 11 December 2012 (LA level) • Key statistics and Quick statistics • 30 Jan 2013 - Ward, OA level • 19 Feb 2013 - National Parks & ‘other’ geographies • 26 Mar 2013 – Short term residents, National Identity, passports held & country of birth • 28 Jun 2013 – Built up areas

15. Population Pyramids

16. Interactive maps

17. Interactive map – change over time

18. Census 2011: Multivariate releases • Release 3.1 – May 16th • 42 Detailed Characteristics tables • Three main topic groups • Ethnicity, Identity, Language and Religion • Migration • Health and Care • Release 3.2a – June 28th • 34 Detailed Characteristics tables • Housing topic • Release 3.2b – July 12th • Tables relating to migration

19. Interactive line charts – comparisons between variables

20. UK Products • Population estimates • 17 December 2012 (Rounded, LA Level) • Population and household estimates • 21 March 2013 (Rounded, LA Level) • Population estimates rounded to the nearest 100 • Household estimates rounded to the nearest 10 • Releases supplemented by: • Statistical bulletins • Interactive content

21. Where to find 2011 Census Data • ONS websitewww.ons.gov.uk/census • Census customer services • There to help you find and interpret data Tel: 01329 444972 Email: census.customerservices@ons.gsi.gov.uk

22. Data Visualisation tools available to help you understand the data in more detail Data Visualisations ONS Homepage Census Landing Page

23. Census Landing Page • Dedicated Census web pages on ONS website • Links to: • Data tables • Statistical bulletins • Data visualisations • Census Analysis • Videos • Census prospectus

24. Where to currently find Census data

25. What tools are available to help #1 • Key Statistics Interface • Available at: www.ons.gov.uk/ons/guide-method/census/2011/census-data/2001-2011-census-comparator-tool.zip

27. What tools are available to help #2 • Search tables by topics • Available at www.ons.gov.uk/ons/guide-method/census/2011/census-data/2011-census-data-catalogue/2011-census-index-of-tables-and-topics.zip

29. What we have DONE: Analysis

30. Census Analysis work programme • Produce more timely analysis • Providing users with a planned & coordinated release programme that ties in with outputs • Prioritises analyses to meet user needs • Coordinated approach • Across ONS • Across the UK • External researchers/academics • Aim to maximise benefits

31. Why produce analysis? • To fully exploit the use of the Census data/outputs • Helping users to understand and interpret Census outputs • Adding value to Census outputs by incorporating them in topic reports, adding insight to policy and other users • Comparisons over the decade • Census recognised as source of information on ethnicity, identity, language, citizenship, nationality and religion - reflect the work in developing Census questions on these topics • More robust survey outputs

32. How has the analytical programme been developed? • Internal consultation • Using expertise of relevant business areas • Workshops/meetings • Taking on user views • Continued discussions with various groups • GSS Theme Groups • CLIP • Working in partnership with academics/researchers • ESRC

33. Analytical Stories – second release • Produced 14 ‘stories’ • Been supplemented with podcasts/infographics • Available on ONS YouTube channel • Analysis based on univariate data • Supplementing Census data release • ‘Stories’ mainly focused at higher geographical levels: • National • Regional • Local Authority – highest/lowest Language InternationalMigrants Religion Families NationalParks Disability UnpaidCare Housing Ethnicity & National Identity GeneralHealth Labour Market Travel to Work Non-UK born short term residents

34. How the analysis is being disseminated • Want to promote analysis and stimulate further analysis • easier access for users accessing analysis of Census data/outputs • widening the availability and use of analysis, potentially increasing the number of users • internal and external analysis • tool to help coordinate analysis across internal & external areas • Provide guidance to users on analysis work associated with the census • A forum to encourage discussion with users and producers of analysis

35. List of analyses based on univariate data

36. Examples of the analysis in the stories

37. Analytical stories – third release

39. Where to find the analysis • Census analysis landing page • Can be linked from the main Census page • Latest stories on the main page • Sub-pages for earlier analyses by topic

40. Upcoming PlansOutputs

41. What’s coming next? • Further cross tabulations • Detailed & local characteristics • Table specifications available on Census pages of ONS website • Further commentary • Statistical Bulletins • Interactive content / data visualisations

42. Release 3 & 4 - Summary

43. UK outputs • Unrounded population estimates – July 2013 • Includes single year of age and sex for the UK and all local authorities (or equivalent) in the UK • Key and Quick statistics – Summer 2013 • Includes Census Profiles; Population and Household estimates by postcode • Local characteristics – Autumn 2013 • Detailed characteristics – Winter 2013

44. Subsequent releases • Alternative population bases • Potential examples: workplace, workday • Subject to quality and disclosure checks • Small populations data • Explore characteristics of small population groups • Micro data • Public use file • Safeguarded files • VML files • Origin-destination (flow) data • Comprising travel-to-work & migration patterns, cross-tabulated by variables of interest

45. Commissioned Outputs • Users can ask for anything they like • Univariate available now, Multivariate from September • Subject to disclosure checking • Examples • More detailed univariate tables • Different multivariate tables • Specific population groups • Tables or flow data

46. Upcoming PlansANALYSIS

47. Planned Analysis • Further Stories – detailed characteristics • Key topics analysed from the cross tabulation • More to follow linked to the detailed characteristics release(s) • Further analysis: • Stories - utilise further data visualisations • Scholarly Articles • Detailed pieces of analysis • Reports • Accompany publications • Provide clarification on specific issues • Information provided as part of prospectus

48. Short term analysis

49. Further analysis planned in 2013 using Detailed Characteristics tables

50. Further analysis – provisional (1) • Health & social care • Small area analyses of health expectancy at birth by sex for MSOAs and by IMD 2010 defined area deprivation in England 2009-2013 • Sub-national analyses of Health Expectancies at birth and at other ages by sex for Upper\Lower tier Local Authorities in England, Welsh Unitary Authorities • Migration & demography • Analysis of population eligible to vote and voter registration rates • Development of a data visualisation tool that maps family type/living arrangements/marital & partnership status by local area