[Alpha] This is a new service - to help improve it please give us your feedback.

Compare a local authority and the UK average (median) local authority by different indicators, such as weekly pay and healthy life expectancy.

You can also add and compare up to three other local authorities.

Where the chosen local authority is more than one standard deviation away from the median, you will see the indicators highlighted under "better than the median" or "worse than the median". Some indicators have higher values positioned on the left under "worse than the median" such as the percentage of smoking adults because it is more intuitive.

Links to the publicly available sources of the data displayed in the tool can be found within our accompanying dataset.

Embed code

Download data for the subnational indicators explorer (CSV, 2.04MB)

Updates 1 December 2022

Four new indicators have been included. These are:

  • persistent absences for all pupils
  • persistent absences for pupils eligible for free school meals
  • persistent absences for pupils looked after by local authorities
  • overweight children at Year 6 age (aged 10 to 11 years)

Two existing indicators are now also displayed in our interactive tool, they are:

  • apprenticeship starts (rate per 100,000)
  • apprenticeship achievements (rate per 100,000)

We expanded the range of geographies included in the accompanying dataset and the data download, for example adding data for city regions, International Territorial Levels (ITLs), English regions, countries, Great Britain and UK, where available and methodologically comparable. For more details see column S, data dictionary tab, in the accompanying dataset.

Confidence intervals for the indicators, where applicable and available, have been included in the accompanying dataset. A confidence interval is a measure of the uncertainty around a specific estimate. If a confidence interval is 95%, it is expected that the interval will contain the true value on 95 occasions if repeated 100 times. As intervals around estimates widen, the level of uncertainty about where the true value lies increases.

Notes

This interactive tool will be updated on a quarterly basis. The data displayed will not always match the most recent version of the related data source where new data and revisions become available in-between updates. Please refer to the data dictionary in the accompanying dataset for details on years covered and geographical coverage of each indicator, and for links to the original data sources. The data displayed are correct as of 1 November 2022.

This fourth iteration of our interactive tool shows 33 subnational indicators. Data for seven more indicators are available in the accompanying dataset and in the data download. These are:

  • total value of UK exports
  • inward foreign direct investment (FDI)
  • outward foreign direct investment (FDI)
  • 4G coverage
  • aged 19 years and over further education and skills achievements
  • new houses
  • homicide

The polarity of the indicator determines whether the lowest or highest value is positioned on the left-hand side of the jitter plot. The jitter plot presents the indicators so that "worse than the median" are on the left, and "better than the median" are on the right regardless of the value itself (for example, a high percentage of smoking adults is presented on the left-hand side). The indicators for which higher values are shown on the left are:

  • public transport or walk to employment centre with 500 to 4,999 jobs
  • cycle to employment centre with 500 to 4,999 jobs
  • drive to employment centre with 500 to 4,999 jobs
  • persistent absences for all pupils
  • persistent absences for pupils eligible for free school meals
  • persistent absences for pupils looked after by local authorities
  • cigarette smokers
  • overweight children at reception age (aged four to five years)
  • overweight children at Year 6 age (aged 10 to 11 years)
  • overweight adults (aged 18 years and over)
  • cardiovascular mortality considered preventable in persons aged under 75
  • anxiety

Because of methodological differences, data for 22 indicators (two of which not displayed) are included for England only, one indicator (not displayed) is included for England and Wales, and seven indicators (three of which are not displayed) are included for Great Britain, rather than for the whole of the UK. We are continuing to work with colleagues in the devolved administrations to improve the comparability of indicators at UK level where possible, as set out in the Government Statistical Service coherence work programme, while acknowledging the devolved nature of some policy areas.

The following six indicators are based on re-weighted Annual Population Survey datasets updated on 16 August 2022. These indicators are: employment rate for 16 to 64 year olds, aged 16 to 64 years level 3 or above qualifications, life satisfaction, feeling life is worthwhile, happiness and anxiety. Read more about the Impact of reweighting on Labour Force Survey key indicators.

Employment rate for 16 to 64 year olds data have been updated to 2021 for Great Britain. To ensure comparability, data for Council Areas in Northern Ireland have been omitted from this iteration, as they are not yet available for 2021. Please refer to the NISRA website for 2020 employment rate data for Northern Ireland.

On 31 October 2022, alongside the publication of the latest Personal well-being in the UK estimates for the period between April 2021 to March 2022, previously published estimates for the periods between April 2011 and March 2019 have been updated because of changes in guidance on data suppression, where estimates no longer need to be suppressed solely based on their co-efficient of variation (CV) values. Previously published estimates were suppressed based on their co-efficient of variation (CV) values being over 20. Estimates have also been updated following quality assurance of previous publications.

Persistent absence includes absence where a pupil had tested positive for coronavirus (COVID-19) (national isolation policies for people ill with COVID-19 were still in effect during this period). Consequently, a large proportion of persistent absence and regional variation in persistent absence, is because of differing regional spread of COVID-19 rather than pupil behaviour.

Our interactive tool operates on local authority districts' and unitary authorities’ 2021 boundaries. Where the original data source includes different boundaries, for example counties or boundaries predating 2021, data points for these geographies will be not displayed in our interactive tool but will be available in the accompanying dataset and in the data download.

Data for ten indicators are only published for upper tier local authorities (counties and unitary authorities) and not for lower tier local authorities (local authority districts and unitary authorities). For example, 24 indicators will appear in the interactive tool for Fareham, however, the other nine will be available for Hampshire in the accompanying dataset and in the data download. These are:

  • pupils at expected standards by end of primary school
  • schools and nursery schools rated good or outstanding
  • persistent absences for all pupils
  • persistent absences for pupils looked after by local authorities
  • children at expected standard for communication and language by end of early years foundation stage
  • children at expected standard for literacy by end of early years foundation stage
  • children at expected standard for maths by end of early years foundation stage
  • female healthy life expectancy
  • male healthy life expectancy

In line with the original data sources, data for Isles of Scilly and City of London are not available for several indicators. Please refer to the original data sources to learn more about the reasons for excluding them.

About this tool

The Subnational indicators explorer, the first step towards an Explore Subnational Statistics service, promotes transparency and makes it easy for users to access and visualise subnational indicators in one place.

The indicators are grouped in three categories ("boosting productivity, pay, jobs and living standards", "spreading opportunity and improving public services" and “restoring a sense of community, local pride and belonging”) in line with the Levelling Up the United Kingdom: missions and metrics Technical Annex.

Methodology

To position each local authority within the cloud of local authorities, we used a robust measure of statistical dispersion called the median absolute deviation (MAD). We preferred the MAD to the mean absolute deviation as outliers have a smaller effect on the median than they do on the mean.

To compute the MAD for a specific indicator, first calculate the median of all values at local authority level for that indicator. Second, subtract the median from each value and get the absolute values. Finally, calculate the median of the median absolute deviations obtained from the previous step and multiply this by 1.4826. This constant is linked to the assumption of normality of the data.

The distance of each local authority from the centre line (the local authority with the median value in the distribution) is equivalent to the difference between the value of the chosen local authority and the value of the median local authority, divided by the MAD. We consider the resulting score to be positive or negative if the score is at least one MAD above or below the median. Usually, a score is considered to be significantly different from the median score if it is at least two MADs above or below the median.

Where the score of a local authority is more than 7.5 MADs above or below the score of the median local authority, the local authority is shown at the end of the scale and its position is not fully representative of its score.

Last updated on 1 December 2022

View all data used in this article

Related

  • Foreign direct investment, experimental UK subnational estimates

    Experimental subnational foreign direct investment inward and outward positions, earnings and flows statistics, by partner economy or industry between 2015 and 2020.

  • Energy efficiency of housing in England and Wales

    Insights on the energy efficiency, environmental impact, carbon dioxide emissions and central heating main fuel type for new and existing homes by property type, tenure and property age.

  • Personal well-being in the UK

    Estimates of life satisfaction, feeling that the things done in life are worthwhile, happiness and anxiety at the UK, country, regional, county, local and unitary authority level.

  • Household and resident characteristics, England and Wales

    Household size, household composition, household deprivation status, and people’s marital and civil partnership status, Census 2021 data.

  • How health has changed in your local area: 2015 to 2020

    Use our interactive tool to explore how health changed in each local authority area across England between 2015 and 2020, according to the Health Index.