Data and Report Packs – manage and deliver your local information

You can instantly benefit from our years of expertise in analysing, managing and maintaining public sector data. Data Packs enable you to deliver the critical information needed by your communities and partners:

  • The key datasets to understand the economic, social and health needs, trends, performance and priorities across your local neighbourhoods.
  • Rich visualisations, communicating the key information needed to inform and engage communities and partners for local decision-making.

Powering your local information system
Designed to load straight into your local information system, the packs sit alongside your existing information to provide additional data and outputs for all users. All data, visualisations and report outputs can be customised and combined with local data, using the functionality of your system.

Cost-effective
Save money in managing your local information system by reducing the resources used to obtain, format, load, visualise and update data. Data Packs load straight into your system, cost from as little as £1,500 and save as much as 70% of the cost of doing this work in-house.

Better use of your time
Instead of doing the heavy lifting of managing, importing and reporting routine data content, focus your resources on how you use the information to improve service delivery and decision-making.

Use our experience to get up-to-speed fast
We have spent years finding, collecting, cleaning, aggregating, analysing and interpreting data for national, regional and local public sector agencies. Benefit from our experience and the Data Packs to make better use of your resources.

For more information, see the articles on this Data and Report Packs blog, download an information pack, or contact us for a demonstration of how the OCSI Data and Report Packs can help you efficiently deliver the information your communities and partners need.

Advertisements

Data Packs update v.2.7 provides the latest content

Overview
The Data Packs v2.7 update provides users with the latest data, benchmarks and outputs available for all geographies.
Key updated datasets in v2.7 include:

  •  2011 Census Key Statistics at Local Authority level
  • Child proverty measures
  • Alcohol consumption profile
  • 2011 Mid Year Estimates

Regular updates include:

  • Annual Population Survey updates (available down to Local Authority District level)
  • Housing Benefit, and Council Tax Benefit (updated to the most recently available data)
  • DWP Benefit claimants
  • Claimant count and Job Centre Vacancies.

All Data Packs users are provided with an Excel workbook detailing the new and revised indicators. See the sections below for a summary of the update.

Key updated datasets
2011 Census Key Statistics at Local Authority level: A large array of Census 2011 data has been released, covering all Key Statistics tables and nine Quick Statistics tables for Local Authorities. 44 tables were released in total covering data on a range of themes related to;

  •  “who we are”; age, ethnicity, nationality, language and health
  • “how we live”; accommodation and tenure, housing characteristics, car ownership, marital status, household composition and living arrangements
  • “what we do”; occupation, industry of employment, hours worked, skills, economic activity

In addition, we have supplied several other Census-related datasets with this release. Census 2001 population figures have been integrated into Census 2011 data series to enable comparisons of change over time down to small area level.

We have also supplied data on second addresses of people resident in England Local Authorities

Finally, we have supplied the 2011 Mid Year Estimates which take the 2011 census data and project these figures forward from March to June 2011.

Child poverty measures: HM Customs and Revenue have published data on the proportion of children in poverty for 2010. The child poverty indicator measures the proportion of children in receipt of out of work benefits, or in receipt of tax credits where their reported income is less than 60% median income. Out of work means-tested benefits include: Income-Based Jobseekers Allowance  and Income Support. The data is provided with a range of age and benefit breakdowns and is available down to Lower layer Super Output Area level/

In addition the small area measure of the proportion of children living in ‘out of work
households’ has been updated for 2011. This provides a Lower layer Super Output Area level
of the proportion of children living in households where adults receive workless benefits
(Jobseekers Allowance, incapacity benefits, Income Support).

Local Alcohol Profiles for England 2012: The 2012 Local Alcohol Profiles for England 2012 have been added to Data Packs. This publication provides a range of alcohol-related indicators measuring the extent of alcohol consumption in the local area and the impact of alcohol on local communities including on levels of crime and health in the local area.

Data is available down to Local Authority level.

Denominator Revisions: Following the publication of the 2011 Census population estimates, we have revised some of the rates for the indicators we supply. Each indicator instance covering a time-points in 2011 and 2012 which previously used the ONS Mid Year Estimates as a denominator now use the more up 2011 Census denominator. As a result some rates have been revised.

If you are interested in subscribing to the OCSI Data Packs find out more information here.

Wish to speak to someone from the team? Do not hesitate to contact us. We will happily answer on of your questions, provide you with more information and arrange to set-up a demo for you and your team.

DWP Benefits change to release frequency

DWP have changed the frequency with which they will release their benefit claimant datasets. Until further notice these will only be published on a six monthly basis instead of the previous quarterly basis. As a result, the May 2012 update of the DWP benefits data (that was scheduled to be published this month) has been scrapped and will not be included in the 2.7 version of the datapacks (due in December)

The following datasets are affected:

  • Working age client group
  • Attendance Allowance
  • Carers Allowance
  • Disability Living Allowance
  • Employment Support Allowance
  • Incapacity Benefit
  • Income Suppory
  • Jobseekers Allowance
  • Pension Credit
  • State Pension

The next update will be in February 2013 covering when the August 2012 data. After that, the next anticipated release will be in August 2013, when February 2013 data will be released. DWP have no plans to make data for May or November periods available at any time.

This change is being made to allow resources to focus on the preparation of a new, improved dissemination tool and the development of new series for the Personal Independence Payment and Universal Credit.

This change does not affect the monthly JSA claimant count datasets produced by ONS which will continue to be updated to the published timetable.

Census 2011 key stats for small areas pushed back to end of January

Census population figures at small area level

This release will provide the population estimates, initially released in July 2012 at LA level, for small area geographies. The release comprises:

  • usually resident census population estimates for England and for Wales at output area level and ward level, by five year age bands and sex
  • estimates of occupied households for England and for Wales at country, at output area level, and ward level.

New publication dates for census key statistics

The ONS have revised dates for publication of the Census 2011 Key Statistics. This will be released in three phases.

The first phase (Census 2011 data release 2.1) will be published on the 11th of December. This release will contain 35 key statistics tables and nine quick statistics tables. Data will be published down to Local Authority District level. See here for the full details of the tables included in this release.

The second phase (Census 2011 data release 2.2) is scheduled to be published on January 31st (2013). This will include the full package of key and quick statistics for the output area hierarchy in England and Wales (107 tables). Information will also be provided for wards, parishes and parliamentary constituencies.

The third phase is due for publication before the end of February 2013 (Date will be confirmed a minimum of four
weeks before the release). This release will include the full package of key and quick statistics for Welsh Government devolved
constituencies, National Parks, as well as postcode sectors and health areas. Estimates of number of
households and population by sex for each postcode will also be published.

For more details about forthcoming census releases, click here.

Tom Smith talks to Instant Atlas about how OCSI Data Packs and data visualisation from InstantAtlas are helping organisations deliver effective and resource-light Local Information Systems

‘How OCSI Data Packs and data visualisation from InstantAtlas are helping organisations deliver effective and resource-light Local Information Systems’

Background

Oxford Consultants for Social Inclusion (OCSI) (http://www.ocsi.co.uk/) is a spin-out research consultancy from the Social Disadvantage Research Centre at the University of Oxford. Since launching in 2003, it has worked with more than 100 public sector organisations at local, regional and national level to improve the evidence-base for making decisions.

Tom Smith is managing director at the consultancy. He says OCSI’s aim is simple: “Our ethos is turning data into better decisions. We take complex data sets and deliver accessible intelligence”.

“In practice this means using data published by government, or held by organisations, to improve services. Since we launched we have seen significant growth in the number of Local Information Systems (LIS) and over time they have become powerful and flexible systems for users to manage, visualise, report and analyse data. We are now at a stage where we have sophisticated off-the-shelf packages from Geowise and others to help.”

Getting started

Tom always put great emphasis on working with the organisations that are delivering information systems. “Done well, LIS are an important part of the research and intelligence toolkit to help improve local services,” he says. However, he felt that many organisations were spending significant time and energy “feeding” their LIS, when they could have been trying to “understand the story from the data, and the implications for local services and commissioning”.

This led OCSI to develop the idea of having key data sets ready-collected and designed to load straight into an LIS. “We realised we could offer Data Packs, that would be regularly & automatically updated. This would save organisations the hassle of having to find and collect the data themselves, manage it and keep it up-to-date,” says Tom. “It also means that as far as analysis and data visualisation is concerned, the data is already there ready to be used.”

Cost is also an issue as maintaining an LIS can be resource intensive. He points to analysis by the Department for Communities and Local Governmentwhich has found that LIS set up costs have been falling but the cost of maintaining them is still high. By having the data ready-collected it means resources can be used more effectively.

Meeting the need

“The Data Packs provide the content which can load that directly into the LIS,” says Tom. “Given that InstantAtlas has become one of the ‘go-to’ tools for data visualisation it made a lot of sense to make sure the Data Packs could play nicely with it.”

Tom is clear about the benefits of Data Packs. He highlights Bradford LISwhere work was done to establish the cost savings of using them. The analysis found the council saved around 85 per cent of the cost of doing the work internally. “As well as the savings, the Data Packs are enabling councils like Newham, for instance, to keep its LIS going with a small team,”says Tom. “This is especially relevant at a time when many organisations are facing massive pressure to reduce costs in every area, yet still need good intelligence on how well services are meeting local needs.”

Tom also believes that OCSI’s experience in working with data helps its users. “Data Packs are not just about packaging and delivering a bumper-load of content from national sources. We have enormous experience in using the information and we know about the strengths and weaknesses of certain indicators. We answer a lot of questions from users on what the data means and how to analyse it – our data support is a valuable part of the service.”

Future developments

Looking ahead Tom believes changes in the way public services are being organised and delivered will see local authorities operating in a very fluid environment. He cites the example of public health becoming part of their remit which in turn means local research teams can find themselves facing requests for information from entirely new groups.

For Tom this means OCSI will have to evolve alongside and think about how data can be used across different platforms. “We have to be part of the move to take data out of LIS silos – to where conversations are taking place, and where local service decisions are being made, rather than thinking about data & information in a big warehouse that we have to go and look at.”

Key benefits of linking OCSI Data Packs with InstantAtlas

  • Organisations are able to develop LIS with data visualisation elements that are automatically updated requiring a less resource intensive approach
  • Key data being is presented in a meaningful and accessible way
  • Less time spent collecting and managing data, more time on analysis and helping local stakeholders understand what the data means.

Read article in full.

Data Packs update v.2.6 provides the latest content

Overview
The Data Packs v2.6 update provides users with the latest data, benchmarks and outputs available for all geographies.
Key updated datasets in v2.6 include:

  •  Recorded crime offences
  • Pupil attainment data
  • Health profile indicators
  • National Insurance Number (NINo.) registrations for overseas nationals.

Regular updates include:

  • Annual Population Survey updates (available down to Local Authority District level – data has also been re-weighted for all quarters back to 2009)
  • Housing Benefit, and Council Tax Benefit (updated to the most recently available data)
  • DWP Benefit claimants
  • Claimant count and Job Centre Vacancies.

All Data Packs users are provided with an Excel workbook detailing the new and revised indicators. See the sections below for a summary of the update.

Key updated datasets
Recorded crime offences: Police recorded crime rates for the 2011/12 period have been added to Data Packs. Police
statistics provide a good measure of trends in well-reported crimes, are an important indicator of police workload, and can be used for local crime pattern analysis.

Data is available down to Local Authority level for the following key crime types: Overall crime; Violence against the person; Sexual Offences; Burglary; Robbery; Vehicle Crime.

Pupil attainment data:Key pupil attainment datasets have been updated for the school year 2010/11. These indicators include pupil attainment for pupils by location of pupil residence at Key Stages 1, 2 and 4 down to neighbourhood level. The pupil attainment data also includes breakdowns for key equalities groups: gender, ethnicity and Free School Meal (FSM) eligibility.

Data on the following examinations are included: Early Years Foundation Profile, Key Stage 1; Key Stage 2; GCSE. Data is available to LSOA, MSOA or Local Authority level (depending on the dataset).

Health profile indicators: The 2012 Local Health Profiles have been produced by the Association of Public Health Observatories of England. The Health profiles contain a range of underlying health data grouped into eight domains: Our communities, Children’s and young people’s health, Adult’s health and lifestyle, Disease and poor health, Life expectancy and causes of death, Changes over time, Emergency hospital admissions by ethnic group, Deprivation.

Under each of these domains are a range of health indicators published down to Local Authority level. We have included the following indicators indicators:

  • Hospital admissions for self-harm
  • Breastfeeding prevalence
  • Diabetes prevalence
  • Drug misuse
  • Hip fractures
  • Adults participating in physical activity
  • Smoking in pregnancy
  • Smoking prevalence
  • Excess winter deaths
  • New cases of Tuberculosis.

National Insurance Number (NINo.) registrations for overseas nationals: National Insurance number registrations for overseas nationals are a measure of the number of people moving to the UK from overseas to work in a local area. This can be used as an estimate of the level of international migration in the local area. Data is presented by world area of origin of people receiving NINo.s. We have previously provided the data in cumulative form but data is now provided annually and updated for financial year 2011/12.
OCSI Data Packs Team
September-2012

Data Packs Clients get Census Data within hours of release

Data Packs Clients received the first release of Census 2011 data today, on the day it was released . The Data Packs Census First Release provides users with Census Tables giving the latest data, derived rates, benchmarks to 2001 Census Data and detailed metadata. Users received this release as part of a new 2011 Census theme, to help locate the census datasets and have incorporated them into the theme, block structure.

Census Tables included:

  • Table H01 2011 Census: Number of households with at least one usual resident, local authorities in England and Wales
  • Table M02 2011 Census: Number of non-UK short-term residents by sex, local authorities in England and Wales
  • Table P04 2011 Census: Usual resident population by five-year age group, local authorities in England and Wales
  • Table P05 2011 Census: Male usual resident population by five-year age group, local authorities in England and Wales
  • Table P06 2011 Census: Female usual resident population by five-year age group, local authorities in England and Wales
  • Table P07 2011 Census: Number of usual residents living in households and communal establishments, local authorities in England and Wales

Also included in the Data Packs Census First Release:

  • Derived rates for each of the indicators in the table (eg % of people in each age and gender band)
  • Indicators linked to their  corresponding 2001 census indicators  (for tables H01, P04 and P07),  to enable comparisons of change over time
  • Metadata for each of the indicators incorporating ONS methodology and definitions
  • Two new widgets to incorporate into profile reports:
    • Census 2011 population summary: showing the total population, household population and male and female population, comparing change from the 2001 to the 2011 Census
    • Short term migrants: showing the total number of short term residence from overseas (as a ratio of the usual resident population).

OCSI analysis of the data also available: Census 2011 impacts on local funding and deprivation levels and Census 2011 shows large population changes in local areas.

 About OCSI and Data Packs

Designed to load straight into your local information system, the Data and Report Packs provide the data and visualisations you, your communities and partners need to ensure effective service delivery and make informed decisions. You can instantly benefit from the years of expertise we have invested in managing, analysing, maintaining and cataloguing data for the public sector. See www.data-packs.com for detail.

OCSI develop and interpret the evidence base to help the public sector and other organisations deliver better services to the public. We are committed to improving social and economic outcomes by providing high quality rigorous research and analysis that meets the needs of our users. Since launching in 2003, OCSI have worked with more than 100 public and voluntary sector agencies at local, regional and national level to improve policy-making and service delivery. We are a “spin-out” research consultancy from the Oxford University team behind the Index of Multiple Deprivation. See the OCSI website www.ocsi.co.uk for more.

Data Packs update v2.5 provides the latest content

Overview

The Data Packs v2.5 update provides users with the latest data, benchmarks and outputs available for all geographies.

Key new datasets in v2.5 include:

  • Child health indicators
  • Teenage conceptions and births.

Key updated datasets in v2.5 include:

  • Counts of VAT enterprises and local business units
  • Pupil attainment data
  • Jobs density.

Regular updates include:

  • Annual Population Survey updates (available down to Local Authority District level)
  • Housing Benefit, and Council Tax Benefit (updated to the most recently available data)
  • Housing market updates – House prices and transactions
  • Claimant count and Job Centre Vacancies.

Major new datasets

Child health indicators A range of key indicators relating to children’s health outcomes have been added to the packs. These indicators were collected as key performance measures in the Child and Maternal Health Observatory (ChiMat). The indicators cover a number of themes including hospital admissions, healthy lifestyles, immunisation, mortality and wider determinants of health.

Teenage conceptions and births  The Data Packs previously contained a summary teenage conception dataset showing teenage conceptions over a three year period as a rate per 1,000 households. However, more detailed teenage conception data has been made available by the ONS. This dataset is an improvement on the previous data in a number of ways. 1) The data is updated annually rather than as a rolling three year average 2) the data includes counts of the number of conceptions as well as rates, 3) the data includes information on abortions and the number and proportion of live births to teenage mothers.

Key updated datasets

Business datasets  A range of data relating to business activity have been added including the number of enterprise ‘births’ and ‘deaths’ and total stock of VAT registered enterprises. Births are the number of new enterprises created in the reference year; deaths are enterprises that have ceased trading in the reference year. In both cases, enterprises that are removed or added to the population as a result of mergers, break-ups, split-ups or other restructuring are not included. Data has been updated for 2010 and 2011. Data showing the count of local business units by Broad Industry group, and by Employment Size band has also been updated for 2011.

Pupil attainment data  Key pupil attainment datasets have been updated for the school year 2010/11. These indicators include headline pass rates for pupils by location of pupil residence at Key Stages 1, 2 and 4.

Jobs Density Data on the number of employee jobs located in the local area and a measure of ‘Jobs Density’ – jobs per working age population has been updated for 2010. The total number of jobs is a workplace-based measure and comprises employee jobs, self-employed, government-supported trainees and HM Forces. Data is available down to Local Authority District level levels.

 The full lists of new and updated datasets are in the User area (login required), including details of all indicators in the Data Packs.