1 / 105

Census data and services

Census data and services. Welcome and introduction David Martin Programme Coordinator. Overview of session. Using UK census data in your research: David Martin Aggregate statistics Digital boundary data Interaction data Samples of anonymised records ONS and Scottish Longitudinal Studies.

dyre
Download Presentation

Census data and services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Census data and services Welcome and introduction David Martin Programme Coordinator

  2. Overview of session • Using UK census data in your research: David Martin • Aggregate statistics • Digital boundary data • Interaction data • Samples of anonymised records • ONS and Scottish Longitudinal Studies

  3. Using UK census data in your research Overview of datasets and services June 2006

  4. Using UK census data in your research • Census basics • Topic coverage • Data outputs • Principal datasets • Supporting datasets • Overview of programme services • Registration and data access • How to find out more

  5. Topic coverage • Age, sex, marital status, household structure • Country of birth/ethnicity • Health/disability • Economic status • Housing, amenities • Travel to work and cars • Qualifications Source: ons.gov.uk

  6. Data outputs • Principal datasets • Aggregate statistics • Boundaries • Interaction data • Microdata samples • Longitudinal data • Supporting datasets • Lookup tables • Metadata

  7. Overview of programme services • Data acquisition and purchase for academic use • Single online registration service provided by Census Registration Service for online resources • Support for ONS and Scottish Longitudinal Studies • New portal service: coming soon

  8. Census basics • Decennial data collection, most recently 29 April 2001 • Most detailed and comprehensive data source for socioeconomic research • Digital data series from modern censuses 1971 onwards • NB national differences: England and Wales; Scotland; Northern Ireland

  9. Registration and data access • One-stop registration using Athens ID, operated jointly with ESDS • Direct access to online services • Some datasets require acceptance of additional special conditions • Don’t forget Neighbourhood Statistics, SCROL, NICA!

  10. Registration – via Athens • Complete online registration form; • Agree to the End User Licence; • Respond to confirmation email.

  11. Special conditions

  12. How to find out more… http://census.ac.uk

  13. Case studies • Examples of how to make use of the census resources in your research • Examples from each unit • Expert staff on hand to answer questions in this session and at our display table all day

  14. Matching and Mixing Geographically-Referenced Data using Convert Justin Hayes, Census Dissemination Unit, University of Manchester

  15. Case Study 1 • An educational researcher wishes to compare levels of school exclusion with characteristics of both the school’s location, and location of residence of excluded pupils, in order to identify any relationships and determine whether school or residence location is a stronger predictor of school exclusion.

  16. Data Sources Lower Level Super Output Areas (LSOAs) Index of Multiple Deprivation 2004 Experian median household income • Postcodes • School locations • Numbers/ages of pupils • Postcodes of residence of excluded pupils 2001 Output Census Areas (OAs) 2001 Census ethnicity information NS 2001 Area Classification

  17. Convert System • Geography matching and geographical data conversion application • LUTs between wide range of current and historical geographies • Derived from ONS postcode directories (NSPD) • New version with regular updates launching soon • Potential for direct link to deprivation scores • http://census.ac.uk/convert

  18. Case Study 2 • Educational researcher with PCT data wishes to convert/resample to LEAs.

  19. Conversion Methodology B A 1 C

  20. Convert Limitations • Accuracy of PD information • Geographical allocations • Address counts • Assumptions • Addresses as population proxy • Homogeneously population-related conversions • Gender good, ethnicity not so good, cows/rainfall very bad • Quality of conversion lookups • Boundary effects and fuzziness • LUT quality measures within Convert

  21. ConvertGrid • Integration of Convert and Casweb technologies to exploit Grid potentials • Presents data from disparate datasets/geographies and combines to users choice of geography • Open-access datasets with standard metadata • Lets users get on with the clever stuff!

  22. Digital boundary data from UKBORDERS University of Edinburgh Data Library

  23. Includes the results of censuses, the surveys and records gathered about individuals by health authorities, central/local government and the service sector. Normally we are dealing with aggregated data describing a group of observations grouped by a particular Geography. Socioeconomic Data

  24. Geographical space can be subdivided in many different ways and for many different purposes for the reporting of socioeconomic data (census or otherwise). Reporting geographies form intangible boundaries which differ from natural geographic features. Differences between epochs of geographies – between the 1971, 1981, 1991 and 2001 census years for example. Which Geography?

  25. A Hierarchy of census output geographies.

  26. United Kingdom Boundary Outline and Reference Database for Education and Research Study. Based at EDINA, University of Edinburgh. Boundary data delivered through UKBORDERS since 1996. Provides services for supporting geographic data for learning, teaching and research. UKBORDERS

  27. Web based delivery of digitised boundary datasets and associated look-up-tables of the UK. Main group of datasets correspond to the various levels of the 1981, 1991 and 2001 census geography. Important associated datasets include current and historical postcode directories from ONS. Why use UKBORDERS?

  28. A key benefit is convenient access to “ready-made” datasets. • Full on-line help is provided. Off-line support is provided through the EDINA Geo Data Services support team. • Dedicated facilities provide access to these datasets, either pre-packaged or through a dynamic user driven interface.

  29. Researchers interested in the spatial visualisation and analysis of census statistics and other socioeconomic datasets linked to census output geographies. Who uses UKBORDERS? • Population • Deprivation • Employment • Education • Health • Housing • Crime

  30. Researcher is interested in patterns of deprivation and access to public health services in Oxford. Has claimant data from DWP and deprivation data from ODPM reported using the lower layer Super Output Area geography. Map data using boundaries

  31. Wants to visualise the data geographically and look for interesting patterns. • Through UKBORDERS, the researcher can download Lower layer SOA boundary data for Oxford.

  32. DWP Claimant Data. Provides a count of Jobseekers allowance claimants broken down by 3 age bands. ODPM deprivation data. Index of Multiple Deprivation made up from 7 weighted indices including income; employment; health & disability; education, skills & training; barriers to housing & services; crime and, living environment. Background

  33. Both datasets are reported using the Lower Super Output Area (LSOA) geography. Designed by ONS to improve the reporting of small area statistics. • Built from groups of Output Areas, LSOA`s have a minimum population of 1000, a mean population of 1500 and are constrained by the boundaries of census Standard Table wards.

  34. Obtain LSOA boundaries

  35. Login to UKBORDERS requires Registration with Census Registration Service and an Athens username.

  36. Use UKBORDERS Boundary Data Selector to extract LSOA boundary data for Oxford only.

  37. Select Output Format. Preview Data.

  38. Download boundary data and load into GIS

  39. Link data to the boundaries

  40. DWP data mapped using LSOAs

  41. ODPM data mapped using LSOAs

  42. Having explored the patterns in the datasets, the researcher chooses to focus on the patterns of deprivation within Oxford and explore possible associations between deprivation and access to Health care. Researcher obtains from Oxford Primary Care Trust a list of NHS dentists in the city, each of which has a postcode as part of its address. Use postcode directories

  43. Through UKBORDERS, the researcher can download postcode directories supplied by ONS • Directories provide a grid reference for each postcode and allocates each postcode to a range of geographies • Holds Live and terminated postcodes • Current version known as the National Statistics Postcode Directory (NSPD) and is released quarterly

  44. Obtain latest version of ONS NSPD from UKBORDERS.

  45. Use NSPD to assign LSOA codes and grid reference to each dental practice using its postcode. Associate ODPM Index of Multiple Deprivation Scores using the LSOA code.

  46. Are there any patterns?

  47. Maintain the viability and operation of existing UKBORDERS facilities Add new datasets Improved access to postcode directories Enhanced metadata and support materials Support the proposed Census Portal Developments during 2006-11

  48. Interaction data from the Census Interaction Data Unit (CIDS) Universities of Leeds and St Andrews

  49. What are Census interaction data? • Interaction data include: - Special Migration Statistics (SMS) - Special Workplace Statistics (SWS) - Special Travel Statistics (STS) • Flow data involving two geographies: origins and destinations • Extremely rich data sets for use by researchers and practitioners • Especially valuable because of lack of alternative data sources, especially below district scale

More Related