Summary of data and analytical resources

All of the resources on this page have a link to Public Health England, either through a previous organisation, through sponsorship or production or co-production. It is possible that there are additional resources from other organisations that have been missed. Some of the resources identified were developed prior to the establishment of PHE and have not been updated since transition. These have been included for completeness but the date of the latest update or available data is highlighted.

Health profiles and summary reports designed to be used by non-analysts

Local authority health profiles

Set of health indicators designed to help local government and health services make decisions and plans to improve local people’s health and reduce health inequalities. Includes a range of measures of health inequality including differences in life expectancy from birth between most and least deprived, and a measure of inequality relating to ethnicity.

Format: Online resource and PDF.

Geography: Counties, unitary authorities and county districts.

Latest update: Last annual update June 2015.

Links: http://www.apho.org.uk/default.aspx?QN=P_HEALTH_PROFILES and http://fingertips.phe.org.uk/profile/health-profiles

Marmot Indicators for Local Authorities in England

LA Profiles published by PHE London KIT with the IHE with key indicators of social determinants of health, health outcomes and social inequality.

Format: PDF download.

Geography: Counties, unitary authorities.

Latest update: December 2015.

The Segment Tool – Segmenting life expectancy gaps by cause of death

Summary reports generated by the Segment Tool. The reports present headline measures of inequality for each LA, with ‘scarf charts’ and table to show the relative contribution that broad groups of causes of death make to the overall inequality gap in life expectancy.

Format: Summary report as pdf and excel spreadsheet.

Geography: Counties, unitary and district authorities, England and English regions.

Latest update: Updated Jan 2015, with 2010-12 data.

Public Health Outcomes Framework (PHOF) data tool

In addition to presenting between area inequalities for all PHOF indicators, the online PHOF data tool includes more complex measures designed to summarise inequalities for England or for smaller geographies including: slope index of inequality (SII) for life and healthy life expectancy at birth and the gap in life expectancy (LE gap) between each local authority and England overall. Some PHOF indicators are disaggregated by inequality dimensions: age, gender, ethnicity or deprivation.

Format: Fingertips online tool.

Geography: SII and LE gap for counties, unitary and district authorities. Geography of other breakdowns dependent on indicator, some at England only.

Latest update: Indicators updated throughout year dependent on release of underlying data. Updates in February, May, August and November.

Longer lives

Presents data on premature mortality by local authority. Allows comparison with local authorities with similar levels of socioeconomic deprivation for all premature deaths and for premature deaths due to cancer, heart disease and stroke, lung disease or liver disease.

Format: online tool.

Geography: County and unitary authority.

Latest update: 2010-12.

Local health

Range of health and health related indicators at small area level. Users may also upload their own data.

Format: Online tool.

Geography: County and unitary authority.

Latest update: Varies depending on indicator. Latest updates July 2014.

More complex online resources which allow for more in-depth exploration of health inequalities

The Segment Tool – Segmenting life expectancy gaps by cause of death

Segments life expectancy gaps by cause of death allowing comparison of: the gap between the LA as a whole and England as a whole, and the gap between the most deprived quintile of the selected LA and the least deprived quintile of the local authority. Outputs for England as a whole and English regions are now also available.

Format: Summary report as PDF download and excel spreadsheet.

Geography: Counties, unitary and district authorities, England and English Regions.

Latest update: Updated Jan 2015, with 2010-12 data. National and regional outputs released July 2015.

Potential Years of Life Lost (PYLL) tool

Designed to support action to reduce deaths from causes considered amenable to healthcare, the PYLL by disease group tool assists CCGs in identifying the broad mortality groups that currently contribute disproportionately (relative to England) to the overall PYLL rate. These groups are CHD, stroke, pneumonia, amenable cancers and other amenable causes.

Format: Excel spreadsheet.

Geography: CCG, local authority districts.

Latest update: Based on data from 2001-3 to 2010-12 projected to 2018.

Health inequalities intervention toolkit

This tool’s presentation of data on main causes of life expectancy gap for LAs and PCTs has largely been superseded by the Segment Tool. However, the intervention toolkit also allows exploration of the impact of a number of evidence-based interventions that can reduce the life expectancy gap in areas with the worst health and deprivation indices in England.

Format: online tool.

Geography: Local authority districts.

Latest update: Based on 2001-2005 data.

Infant mortality tool (part of HI intervention toolkit)

Presents trends in infant death rates for the R&M group, births within marriage and joint registrations, and sole registrations, factors that are contributing to the inequality gap and allows users to assess impact of modifying these factors.

Format: online tool.

Geography: SHA and local authorities with high numbers of infant deaths in routine and manual groups.

Latest update: Based on 2006-8 data.

Health inequalities gap measurement tool (the gap tool)

Developed by the former South East and London PHO and the DH, the gap tool shows within and between area comparison of death rates by main cause of death for local authority districts, counties, regions, PCTs, SHA and England. Latest data available are for 2005-9.

Format: online tool.

Geography: Local authority districts, PCTs, counties.

Latest update: 2005-9 for main causes of death, trend data for all causes, cancer and circulatory disease available for 2001-2009.

Health Poverty Index

Presents a range of indicators related to health poverty including root causes, intervening factors and health status. Comparisons can be made of trend over time, to other areas including ONS cluster groups and for different ethnic group.

Format: online tool.

Geography: Local authority districts.

Latest update: Last update was in 2008 with 2005 data.

Analytical tools designed for use by health analysts

Inequalities Analysis Tool

Tool for calculating measures of inequality commonly used in public health:

  • Simple measures of inequality gap (absolute, relative inequality, odds ratio (most deprived to least deprived group)
  • Slope index of inequality and 95% confidence intervals
  • Gini coefficient and Lorenz curve which measure disproportionality in the distribution in health or other outcomes.

Format: Excel spreadsheet.

Geography: user defined.

Latest update: User uploads own data.

Life expectancy calculator (ward and LA level)

Enables users to calculate life expectancy figures for small areas using local death and population data. Life expectancy is frequently used to monitor health inequalities between areas or population groups.

Format: Excel spreadsheet.

Geography: user defined.

Latest update: User uploads own data.

Local basket of indicators

Suite of 70 indicators across 13 categories developed by the then LHO in 2003 to monitor health inequalities. The indicators are now published through the HSCIC Indicator Portal. 21 of the original 70 indicators have been discontinued.

Format: HSCIC indicator portal, Excel spreadsheets.

Geography: Varies depending on indicator.

Latest update: Varies depending on indicator.