Data Updates in Local Insight

Featured

Local Insight is updated every month with newly published data. Alongside this, the All Data Download is updated every quarter. To see a list of all the datasets in Local Insight check out this article on our Help Centre

In the below table you can find the archived links to all previous data updates.

Monthly Data Updates
2023 – January
2022 – November
2022 – October
2022 – September
2022 – August
2022 – July
2022 – June
2022 – May
2022 – April
2022 – March
2022 – Feb

Census 2021: Health, disability, and unpaid care data available in Local Insight

The small area Health, disability, and unpaid care census data is now live in Local Insight. You can start using and analysing this data for all your custom areas. 

For guidance on using Census 2021 data in Local Insight please see “How to explore Census 2021 data in Local Insight”.

Summary of published data

Download the full list of indicators now available in Local Insight.

We have added 17 indicators to Local Insight. This release includes small area data from the Health, disability, and unpaid care topic summary. Indicators for the following datasets can now be seen live in Local Insight:

  • Disability (3 indicators) 
  • General health (5 indicators) 
  • Number of disabled people in the household (3 indicators) 
  • Provision of unpaid care (6 indicators) 

Reports

We have updated 3 of the indicators in the Local Insight report (see Health and wellbeing: page 38). You will need to update your reports in order to see Census 2021 data here.

Census 2021: Population by 5 year age bands available in Local Insight

The small area population by 5 year age bands census data is now live in Local Insight. You can start using and analysing this data for all your custom areas. 

For guidance on using Census 2021 data in Local Insight please see “How to explore Census 2021 data in Local Insight”.

Summary of published data

Download the full list of indicators now available in Local Insight.

We have added 19 indicators to Local Insight. Starting with people aged 0-4 and going up in 5 year bands until people aged 85 and over.

Please note, there are various indicators for population in Local Insight, due to figures being published as part of Mid-Year estimates and figures published as part of Census 2021 data release.

All indicators for small-area census population data are named in the following format:

  • People aged X-Y (Census 2021)

We have also created a derived indicator that shows people aged 0-14 (Census 2021).

Single age band data and bespoke age ranges

The single age band data has not yet been published at small area level. Therefore, we are unable to create derived bespoke age bands at this stage. 

If you are interested in seeing data for a particular age band please let us know on support@ocsi.co.uk and when possible, we will add those indicators into Local Insight.

Reports

We have not added any of the 5 year age band population indicators to the Local Insight reports. We will review the reports once the single age band data is published.

Census 2021: Education data available in Local Insight

The small area education census data is now live in Local Insight. You can start using and analysing this data for all your custom areas. 

For guidance on using Census 2021 data in Local Insight please see “How to explore Census 2021 data in Local Insight”.

Summary of published data

Download the full list of indicators now available in Local Insight.

We have added 7 indicators to Local Insight. This release includes small area data from the education topic summary. The 7 indicators below are now live in Local Insight: 

  • People with no qualifications (Census 2021)
  • Highest level of qualification: Level 1 qualifications (Census 2021)
  • Highest level of qualification: Level 2 qualifications (Census 2021)
  • Highest level of qualification: Level 3 qualifications (Census 2021)
  • Highest level of qualification: Level 4/5 (degree or higher) qualifications (Census 2021)
  • Highest level of qualification: Other qualifications (Census 2021)
  • Highest level of qualification: Apprenticeship (Census 2021)

Reports

We have updated 5 of the indicators in the Local Insight report (see Education & skills: page 47). You will need to update your reports in order to see Census 2021 data here.

Census 2021: Sexual orientation and gender identity data available in Local Insight

The small area sexual orientation and gender identity census data is now live in Local Insight. You can start using and analysing this data for all your custom areas. 

For guidance on using Census 2021 data in Local Insight please see “How to explore Census 2021 data in Local Insight”.

Summary of published data

Download the full list of indicators now available in Local Insight.

We have added 26 indicators to Local Insight. This release includes small area data from the sexual orientation and gender identity topic summary. Indicators for the following datasets can now be seen live in Local Insight: 

  • Sexual orientation (13 indicators)
  • Gender identity (11 indicators)
  • Non respondents to these questions (2 indicators)

ONS also published 4 indicators; Non-binary, Pansexual, Asexual and Queer. These indicators are currently not available in Local Insight as the data is only published at Local Authority level. If you were interested in uploading this data yourself to Local Insight please get in touch on support@ocsi.co.uk.

More information about these datasets 

The question about sexual orientation and gender identity in the 2021 census was voluntary. 

In total, 92.5% of the population aged 16 years and over answered the question on sexual orientation and 94.0% of the population aged 16 years and over answered the question on gender identity. Read more about this on the ONS website

ONS percentages are calculated using the overall population rather than the population who responded to the sexual orientation and gender identity question. 

Alongside adding the official ONS figures to Local Insight, we have also included additional indicators that use only people who responded to the sexual orientation and gender identity question as the denominator. These indicators are displayed as [sexuality] (as a % of all who responded to the sexual orientation questions) (Census 2021).

Below is an example how these distinct indicators display in Local Insight

  • Bisexual (as a % of all who responded to the sexual orientation questions)  (Census 2021)
  • Bisexual (as a % of all aged 16+) (Census 2021)

These supplementary indicators that use respondents only as the denominator provide additional value as the response rates vary considerably across local areas. There are a multitude of possible driving factors behind non-response rates, which are not necessarily related to sexual orientation and gender identity.

Non respondents

We have also added 2 indicators that show the non response rates for this topic. These two indicators are called:

  • Non respondents to the sexual orientation question  (as a % of all aged 16+) (Census 2021)
  • Non respondents to the gender identity question  (as a % of all aged 16+) (Census 2021)

Reports

We have not added any of the sexual orientation and gender identity indicators to the Local Insight reports.

Census 2021: Housing data available in Local Insight

The small area housing census data is now live in Local Insight. You can start using and analysing this data for all your custom areas. 

For guidance on using Census 2021 data in Local Insight please see “How to explore Census 2021 data in Local Insight”.

Summary of published data

Download the full list of indicators now available in Local Insight.

We have added 71 indicators to Local Insight. This release includes small area data from the housing topic summary. Indicators for the following datasets can now be seen live in Local Insight: 

  • Accommodation Type (9 indicators) 
  • Car ownership (4 indicators) 
  • Central heating (1 indicator) 
  • Heating type (11 indicators) 
  • Number of Bedrooms (4 indicators) 
  • Number of Rooms (10 indicators) 
  • Occupancy rating of bedrooms (6 indicators) 
  • Occupancy rating of rooms (6 indicators) 
  • Second address type (8 indicators) 
  • Second addresses (2 indicators) 
  • Tenure (10 indicators) 

ONS also published datasets on Communal establishment resident by age and Communal establishment resident by management type. These are currently not available in Local Insight as the data has not been published at Output Area. 

Reports

We have updated 34 of the indicators in the Local Insight report (see Housing: pages 24, 25 and 29 and Access and transport: Car ownership: page 57). You will need to update your reports in order to see Census 2021 data here.

Christmas Break

The Local Insight support team will be off during the Christmas break from Wednesday 21 December to Tuesday 3 January inclusive.

We will not be able to respond to any Local Insight support requests sent to support@ocsi.co.uk during this time.

Support

If you experience any issues or need support please visit  the Help Centre.

There are also tutorial videos available that may answer your question.

If you have another question which requires assistance from a member of the team, please email support@ocsi.co.uk.  We will reply upon our return in January.

Enjoy the festive break.

Census 2021: Labour market and travel to work data available in Local Insight

The small area labour market and travel to work census data is now live in Local Insight. You can start using and analysing this data for all your custom areas. 

For guidance on using Census 2021 data in Local Insight please see “How to explore Census 2021 data in Local Insight”.

Summary of published data

Download the full list of indicators now available in Local Insight.

We have added 67 indicators to Local Insight. This release includes small area data from the labour market and travel to work topic summary. Indicators for the following datasets can now be seen live in Local Insight: 

  • Economic activity status (24 indicators) 
  • Travel to work (21 indicators) 
  • Industry and occupation (22 indicators)

ONS also published detailed breakdowns of different occupation and industry datasets. These are currently not available in Local Insight as the data has not been published at Output Area (and will show very low numbers in many instances). However, we can add breakdowns that are useful to you upon request – please send these to support@ocsi.co.uk 

Reports

We have updated 14 of the indicators in the Local Insight report (see Economy: Economic activity – page 51 and Economy: Job type – page 52). You will need to update your reports in order to see Census 2021 data here.

Census 2021: Ethnic group, national identity, language and religion data available in Local Insight

The small area ethnic group, national identity, language and religion census data is now live in Local Insight. You can start using and analysing this data for all your custom areas. 

For guidance on using Census 2021 data in Local Insight please see “How to explore Census 2021 data in Local Insight”.

Summary of published data 

Download the full list of indicators now available in Local Insight

We have added 68 indicators to Local Insight. This release includes small area data from the ethnic group, national identity, language and religion topic summary. Indicators for the following datasets can now be seen live in Local Insight: 

  • English language proficiency (5 indicators)
  • Ethnic Group (25 indicators)
  • Household language (4 indicators)
  • Households with multiple ethnic groups (6 indicators)
  • Households with multiple languages (4 indicators)
  • National identity (16 indicators)
  • Religion (8 indicators)

ONS also published detailed breakdowns of main language, national identity and religion datasets. These are currently not available in Local Insight as the data has not been published at Output Area (and will show very low numbers in many instances). However, we can add breakdowns that are useful to you upon request – please send these to support@ocsi.co.uk 

Additional census religion data in Local Insight

The question about religion in the 2021 census was voluntary. Overall, 94.0% (56.0 million) of usual residents answered the question.

ONS percentages are calculated out of the overall population as opposed to out of the population who responded to the religion question. Because the census question about religious affiliation is voluntary and has varying response rates, caution is needed when comparing figures between different areas or between censuses (source ONS).

Alongside adding the official ONS figures to Local Insight, we have also included an additional indicator for each religion that uses only people who responded to the religion question as the denominator. These indicators are displayed as [Religion] (% of all respondents – Census 2021)

Below is an example how these distinct indicators display in Local Insight

  • Jewish (% of all people – Census 2021)
  • Jewish (% of all respondents – Census 2021)

These supplementary indicators that use respondents only as the denominator provide additional value as the response rates vary considerably across local areas. There are a multitude of possible driving factors behind non-response rates, which are not necessarily related to religious affiliation.

The ONS figures are the ones that will be in your default themes. However, should you want to use the alternative figures you can find these on the Dashboard or add them to the map using the manage indicators page.

Reports

We have updated 35 of the indicators in the Local Insight report. You will need to update your reports in order to see Census 2021 data here.

Data includes:

  • Population by ethnic group (pg. 5)
  • Population by household language(pg. 6)
  • Population by religion (pg. 9)

Census 2021 resources from OCSI

Small-area Census 2021 data is here. Topic summary data will be released in stages over the coming months.

Alongside making sure the data is available in Local Insight as quickly as possible, the OCSI team are also providing additional support and resources for using and understanding the data.

We will add links to our resources and analysis here as and when they are published. Alternatively, sign up to our Census 2021 mailing list to get the latest news directly to your inbox. 

As always, let us know if there is anything else you would like to see from us.

General resources:

Analysis:

Census 2021: UK Armed Forces Veterans data

 

The small area UK Armed Forces Veterans census data is now live in Local Insight. You can start using and analysing this data for all your custom areas. 

For guidance on using Census 2021 data in Local Insight please see “How to explore Census 2021 data in Local Insight”.

Summary of published data 

Download the list of indicators.

We have added 14 indicators to Local Insight. This release includes small area data from the UK Armed Forces Veterans topic summary. Indicators for the following datasets can now be seen live in Local Insight: 

  • Household reference person indicator of previous service in UK armed forces (4 indicators) 
  • Previously served in the UK armed forces (4 indicators) 
  • Number of people in household who have previously served in UK armed forces (4 indicators) 
  • Population who have previously served in UK armed forces in communal establishments and in households (2 indicators)

Data availability

Please note the smallest geography this data has been published at is MSOA level. 

This may have an impact on how you can view data for your custom areas.

Viewing data on the map

While the smallest geography that the data has been published at is MSOA level, we have used population weighted apportioning so that you are also able to view this data at LSOA level on the map. 

As we have used population weighted apportioning, this may mean that some component LSOAs of a parent MSOA will have slightly different data values and may be shaded a different colour on the choropleth map.

Viewing data for custom areas

As the data is published at MSOA level, it is more difficult to accurately apportion to custom areas that are built out of smaller building blocks. We use population weighted apportioning to generate data for your custom areas (read more about our apportioning methodology here). Please see below for guidance on how this works for different area types.

Areas larger than an MSOA, built out of MSOA or Local Authorities: We use the figures published by ONS to build areas out of MSOAs and Local Authorities.

Areas larger than an MSOA, built out of LSOAs or OAs: Some custom areas are larger than MSOAs but built out of smaller component areas (eg, areas that you create by drawing on a map or through importing shapefiles). For these, we use population weighted apportioning to derive a value for each of the LSOAs. 

As we round apportioned results to the nearest round numbers, there may be some small variances in data at a sub-MSOA level.

Areas smaller than an MSOA: As with the above, we use population weighted apportioning to derive values for areas smaller than MSOA level. 

As the data is only published at MSOA level, data values are based on estimates rather than exact figures and so should be used with caution.

Reports

UK Armed Forces Veterans data is not available to view within reports. For guidance on how best to view this data in Local Insight, please see “How to explore Census 2021 data in Local Insight”.