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 Knowledge Base.

In the below table you can find the archived links to all previous data updates in the first column and the archived links to all previous All Data Download updates in the second  column:

Monthly data updates
Quarterly All Data Download updates
20-Mar 20-Feb
20-Feb 19-Dec
20-Jan 19-Jul
19-Dec
19-Nov
19-Oct
19-Sep

Identify areas with higher proportions of people from at-risk groups

Hi all

We hope you, your loved ones and your colleagues are keeping as well and safe as possible at the moment. 

We have had a few requests for guidance on which datasets within Local Insight could be used to help inform responses to COVID-19 through identifying areas with higher proportions of people from at-risk groups.

Our Research Team has produced a list of datasets  that may be potentially useful covering:

  •  at-risk groups: including older people, underlying health conditions and benefit claimants for health and disability 
  • groups requiring additional support: including single-person households, households with no cars and prevalence of dementia
  • economic factors: (key workers and vulnerable sectors). 

These are all available in Local Insight and can be used immediately. We have also made these available as a mini data download at MSOA level for England . Please share with anybody that might find it useful.

There are also two new indicators available in Local Insight that could be useful:

  • Households on Universal Credit – Limited Capability for Work Entitlement: This captures those who are receiving Universal Credit due to poor physical or mental health. Universal Credit is increasingly replacing legacy work-limiting illness related benefits including Employment and Support Allowance and Incapacity Benefit so it provides a more comprehensive measure of those out of work due to poor health and disability.
  •  Personal Independence Payment (PIP), respiratory disease claimants: This measures those who are receiving additional financial help to manage conditions associated with respiratory diseases including asthma, chronic obstructive pulmonary disease, bronchiectasis, cystic fibrosis, pulmonary fibrosis, pneumoconiosis, heart and lung transplants and various lung diseases and diseases of the upper and lower respiratory tract.

For a reminder on how to add indicators to your Maps, please see Customise themes and indicators. You can select which indicators appear on the Dashboard from within the dashboard itself using the  Build a custom dashboard functionality.

Many of you must be under enormous amounts of pressure at the moment. Please let us know via support@ocsi.co.uk if there is any additional support we can give you during this time and we will do our very best to help.  

Learn how to upload your grant data to Local Insight

At the end of 2019 we extended the services functionality in Local Insight, which can be used to upload and overlay grant data alongside the standard socio-economic datasets within Local Insight. 

Join us for a training webinar here if you want to learn more about layering funding data on the Local Insight maps.

This blog gives some examples of what you could upload including a mini case study from Oxfordshire Community Foundation.

What kind of data can you upload?

The Services feature enables you to upload your grant data. In fact any data held at postcode level can be uploaded using this feature. Once uploaded it will show as markers on the map, which can be clicked on for more information.

There is support material available on the Help Centre on how to format and upload data to Local Insight using this feature.

An example of how data must be formatted in a CSV for it to be uploaded to Local Insight.

An example of how data must be formatted in a CSV for it to be uploaded to Local Insight.

 

Image caption: Once uploaded, the data shows as icons on the map, which can be selected on and off using the services button.

Once uploaded, the data shows as icons on the map, which can be selected on and off using the services button.

Use cases

Upload grants awarded data for your organisation 

Uploading all your grants awarded data for a particular funding round or financial year is a quick and easy way to visualise where your grants have been made.

The new functionality allows you to provide more context, such as the amount awarded, details on the organisation and when the grant was made. This can help your team understand whether particular types of organisations are being under-represented or whether there are any areas missing out on funding. 

You can use the Display Mode to enter full screen and then take a screenshot of the maps to add into presentations.

Image caption: In this example the grant data has been catagorised (using the service type column) by year awarded.

 In this example, the grant data has been categorised (using the service type column) by year awarded.

 

Image caption: The tick boxes next to the year awarded date can be selected/unselected to edit what is displayed on the map.

The tick boxes next to the year awarded date can be selected/unselected to edit what is displayed on the map.

Upload all the grants awarded by major funders in your patch 

Alongside your own data, you can also upload grant-making data from other funders in your area to better understand who is funding what and where, as well as whether there are any funding gaps. 

Lots of organisations publish their grant data using 360 Giving’s data standard, which is made available to explore easily via GrantNav. This data can be filtered and exported by region, district, funders, amount awarded and award year. Once exported, a little reformatting is required and then this can be uploaded into Local Insight (we have put together guidance on how to format data to help you). 

Image caption: This shows GrantNav filtered by district.

 This shows GrantNav filtered by district.

 

Image caption: In this example the grant data has been categorised (using the service type column) by the name of the funding organisation.

 In this example, the grant data has been categorised (using the service type column) by the name of the funding organisation.

 

Image caption: The tick boxes next to the funding organsation names can be selected/unselected to change what is displayed on the map.

The tick boxes next to the funding organisation names can be selected/unselected to change what is displayed on the map.

 

Join us for a webinar at 2pm on Tuesday 17 March where we will run through how to filter, export and reformat data from GrantNav for Local Insight.

Upload a round of grant applications for a panel

Upload a round of grant applications for a specific programme in order to aid decisions on how well they address fund criteria.

This can be used as additional guidance during panel meetings. At a click of a button, the panel can find out more information about the organisation applying for the grant, including potential beneficiaries and whether the organisation has received funding previously. You can of course also compare the grant application to data on the local need that is already preloaded into Local Insight for you.

Alongside the expertise of your grant panel, access to this contextual information can help ensure that grants are awarded to maximise the positive impact of your funding in the community. 

Image caption: dummy grant application data. In this example, the application is for a project to support employment for young people in the area.

Dummy grant application data. In this example, the application is for a project to support employment for young people in the area.

Image caption: The indicator youth unemployment (18-24) receiving JSA or Universal Credit is overlaid alongside the grant application to demonstrate the need in the area.

The indicator youth unemployment (18-24) receiving JSA or Universal Credit is overlaid alongside the grant application to demonstrate the need in the area.

How Oxfordshire Community Foundation used this new functionality? 

We caught up with Simon (Community Impact Analyst) from Oxfordshire Community Foundation (OCF) to see how they are using the new functionality. 

OCF wanted a way to map all the charities they have funded and then layer that data alongside the deprivation data on Local Insight. The aim was to identify both the needs of an area and the services already available that meet that need.  

The new functionality on Local Insight allowed them to upload the charity data and categorise it according to the theme it addressed (such as relief of poverty, community cohesion, health and wellbeing). For each charity, they uploaded additional information to show the name, beneficiaries, charity number and charity website. Alongside this, they could then overlay standard Local Insight datasets showing local need.  

The additional information they can now add into Local Insight means that the tool can be used to not only provide underlying data about local need, but also signpost users to other third sector organisations already working in that space. 

image 10

image 11

The maps OCF have created on Local Insight have already been useful, for example, they were approached by a local group looking to renovate a condemned church and turn it into a community asset. Using Local Insight, OCF were able to quickly display the location of the church and overlay the Community Needs Index (a composite indicator which measures social and cultural factors that can contribute to poorer life outcomes). They were also then able to layer the charities that work in that area and could provide the group with contact details and information on other groups working in this space.

Get in touch!

If you have any questions, please do not hesitate to get in touch with us on support@ocsi.co.uk or give us a call on 01273 810270

Local Insight in 2020

Local Insight is an evolving product and this year is no different. This blog outlines the Local Insight product plan for 2020.

The plan focuses on updates that will help save you time, get data for the areas you care about and be more confident in using the data. This is based upon feedback gathered during the Local Insight user group as well as feedback we receive throughout the year. 

Above and beyond the developments listed below, there is scope for additional improvements, so please keep voicing any development ideas you have. 

Save time

Spend less time searching for data and more time using data.

Search for indicators on the map more easily 

One of our clients described Local Insight as their Data Dictionary. We love this description as it captures the breadth of data available in the tool (over 1000 indicators in fact!). With so much data available, being able to find what you are looking for quickly is important. 

This year we will add a search bar to the Data dropdown on the Map page so that you can hone in on what you are interested in, in far fewer clicks.

Export the (N) values on the Data for more areas popup

This update will improve the export from the Data for more areas popup. You will be able to export total counts figures (where applicable) alongside percentage figures so that you can do further analysis or build your own visualisations.

Identify your areas with ease using MSOA names 

The House of Commons Library has created a set of recognisable names for MSOAs (also available on an interactive map). A number of users have requested that we add these names to Local Insight alongside the area codes so that standard areas display with more meaningful names. As part of this, we also propose changing the LSOA names to incorporate the name of the parent MSOA to help users have a better idea of where the LSOA is located.
This will make it easier to:

  • Identify local areas when hovering over the MSOA or LSOA data on the map
  • Find the MSOAs/LSOAs you want quickly when creating areas based on standard areas

MSOA names

See data for all the areas you care about  

No area is off bounds. 

Local Authority boundary changes

As of 1 April 2019, a number of new Unitary Authorities were formed. This spring, we are updating the Local Authority boundaries in Local Insight to reflect these changes.

Display multiple area boundaries on the map 

The current interface allows you to select a single custom area to view on the map at a time. With this update you will be able to view multiple custom areas, or even a whole category of areas, simultaneously. This will make it easier to see how your areas compare on different datasets within the map itself. 

Areas on the map

Be more confident in the data

Access resources and improved guidance so that you can be more confident using Local Insight. 

Revamping the Help Centre

We are improving the Help Centre to give you all the information you need to get the most out of Local Insight. You can look forward to more dynamic content including:

  • A new section on open data resources
  • More “how to” guides and blogs 
  • More information on how data is apportioned and aggregated

If you have any suggestions for resources you would like to see, please send them to support@ocsi.co.uk 

Help Centre

Lastly, if you would like to discuss any of the upcoming developments, please email support@ocsi.co.uk 

How to create custom areas based on top 10% most deprived LSOAs

Within Local Insight it is really quick and easy to set up any custom geography you are interested in – whether that is a ward, a local authority, parish or GP locality.

Another type of area that may be of particular use to you, is a composite area of all the LSOAs in your service patch that fall within the top 10% or 20% most deprived nationally, according to the Index of Multiple Deprivation.

It is fairly straightforward to work out which LSOAs fall within these deciles in your area and then create a custom area based upon these LSOAs through selecting from the standard areas dropdown.

Step-by-step guide

Here is a step-by-step guide for identifying the LSOAs to include, with the help of a handy tool from Swirrl.

1. Open the IMD Explorer tool

Visit http://imd-by-geo.opendatacommunities.org/imd/2019/area

2. Select the geography

Select the Local Authority or County that you are interested in from the list.

3. Select the index you are interested in:

Most organisations will likely be interested in the overall Index of Multiple Deprivation. However, if you are interested in a particular theme, such as health or employment, you can choose one of these domains instead.

4. Select the decile you are interested in:

If you are interested in the top 10% most deprived LSOAs, select decile 1 and download

If you are interested in the top 20% most deprived LSOAs, you will need to download the data for decile 1 and decile 2 separately

NB: If this produces an empty file, it means that there are no LSOAs within your service patch that fall within this decile.

The following steps assume you are looking at the top 10% most deprived (decile 1). You will need to repeat these steps for decile 2 if you are looking at the top 20% most deprived.

5. Remove duplicates

The file you have downloaded provides you with all of the postcodes that are in the top 10% most deprived alongside their corresponding LSOA codes. For this purpose, we are only interested in the LSOAs that are in the top 10% most deprived, so you need to remove the duplicates in the LSOA code column (column C). To do this:

  1. Click on the Data tab in the tool bar
  2. Select Remove Duplicates
  3. Select the ‘LSOA Code’ check box only
  4. This is now your list of individual LSOAs within your service patch that fall in the top 10% most deprived nationally.
remove duplicates

Click on image to see full size

6. Create your custom area in Local Insight

You can now create your custom area in Local Insight. Please note, you must be a Power User or Group Admin to be able to do this.

The easiest method to create the area in Local Insight is through the Create a custom area by selecting a standard area option. This guidance is for users looking at one local authority. If you are creating an area for a county, please see step 7.

  1. Provide a name and description for your area (Please note names cannot be longer than 255 characters)
  2. In the custom area type box, select create area based on standard area
  3. Select LSOA as the geography
  4. Select the local authority the LSOAs are in
  5. Select from the dropdown all the LSOA codes that correspond to those in your download (if you have a few LSOAs you can use Control+F, or Command+F on a Mac to find the codes you need)
  6. Save the custom area
create custom area

Click on image to see full size

7. Create custom area that spans multiple local authorities

If you are creating a custom area that spans multiple local authorities (such as a county), please send the full list of LSOA codes you would like included in your area to support@ocsi.co.uk and we can set this up for you.

8. Explore data for your custom area

Your custom area is now ready to use. You can now:

Office Christmas closure

We hope you have a lovely break over the festive period!

OCSI will be closed from Monday 23rd December to Friday 3rd January inclusive. We will not be able to respond to support requests during this time. We will answer any support requests when the office re-opens on Monday 6th January.

As another year draws to a close we are, as ever, appreciative of your continued support. Thank you to all our clients who have made 2019 a year to remember. Here’s to what 2020 will bring!

Add additional information to your services on Local Insight

We have made some major improvements to the Services feature on Local Insight so that you can now provide more contextual information to each of the individual service locations on the map.

GPs norfolk demo

 

The enhanced functionality allows you to add more locally held information to Local Insight so that you can signpost users to important information about their local services. As well as being able to say where a particular service is – you can also include contextual information quickly and easily in the same place. Coupled with the open data available within the system and the locally held datasets you can add in, this improved functionality contributes to making Local Insight a one-stop shop for local information for you and your strategic partners.

The developments focus on:

  • Enhancing the Services functionality to allow you to add additional information to your individual service locations
  • Improving the error feedback and the importing process so that you have a more streamlined experience

This blog is here to give you a rundown of all the changes including:

  • What’s new?
  • What has been improved?
  • Potential use cases

This functionality has been in the pipeline for a while and was voted a priority at the 2018 Local Insight user group so we are delighted that it is now up and running.

The developments & design were improved through the user testing period so a big thank you to everyone who spent time providing us with valuable feedback.

For step-by-step guidance, please read through the Manage Services section on the Help Centre.

What’s new in Local Insight?

Previously, you could upload your services, categorise them into a maximum of 30 types and then view those locations on the map. Now, along with assigning your services a type you can also add contextual information for each individual service, which can then be displayed on the map.

Adding metadata is optional and completely customisable. To add metadata to your service data you can input data in the 5 columns to the right of the postcode and service type columns.

2

Below is an example of how metadata will display on the map once uploaded.

3

For step-by-step guidance, please read through the Manage Services section on the Help Centre.

What has been improved?

We ran extensive beta testing on this new functionality to ensure it meets the needs of our user base. The below improvements have been informed by the beta testing.

You no longer have to add UPRNs
Previously when you uploaded services you needed to add a Unique Property Reference Number (UPRN) in the first column. The purpose of this was to inform Local Insight that each row was a separate service, even if postcodes were duplicated. Local Insight now intuitively knows that each row is a separate service so you don’t have to waste time putting in arbitrary UPRNS.

Please note. If your services have UPRNs that you wanted to keep in the tool, then get in touch at support@ocsi.co.uk as we have the UPRNs in the database and can send them to you. You can then add them back in as metadata if you wanted to still see the UPRNs on the map.

Removed copy and paste option
Previously, you could upload your services by either copying and pasting or uploading a CSV. We have removed the copy and paste option. Removing this option allowed us to focus on improving the error feedback and speeding up the upload process as these were highlighted as priorities during beta testing.

Better error feedback
We have improved the error feedback you receive when uploading services so that any formatting issues can easily be identified and rectified. This should make uploading services a smoother & less confusing process.

Potential use cases

Community Foundations

If you are a community foundation, you could upload the organisations you fund as Services and add metadata to provide additional information on the grants that they have applied for and received.

To illustrate this, the below example shows The Barrow Cadbury Trust grant data from GrantNav, reformatted and uploaded into Local Insight.

  • For the postcode column, the Recipient Org: Postal Code was used
  • For the service type column, the Grant Programme title was used
  • 4 columns of metadata were then added, including Grant Title, Grant Description, Amount Awarded and Recipient Org Name

The image below displays how the first row of data is formatted so it can be uploaded into Local Insight

4

The image below shows how that data will display on Local Insight when the service icon is clicked on.

5

Uploading this information would allow you to visualise all the grant applications geographically and then overlay the socio-economic datasets in Local Insight to gain an understanding of the characteristics of that area to explore whether local giving is going to the places most in need.

Local Authorities

If you are a Local Authority who has a public-facing Local Insight site then you could upload useful information about local services to help signpost information to public users.

To illustrate this, the below example shows GP surgeries in North Somerset published on Data.gov.uk by North Somerset Council reformatted and uploaded into Local Insight.

  • For the postcode column, the postcodes downloaded from Data.gov.uk were used
  • For the service type column, GP Surgery name was assigned for all postcodes
  • 3 columns of metadata were then added, including GP Surgery name, Address line and Telephone No.

The image below displays how the data is formatted so it can be uploaded into Local Insight

6

The image below shows how that data will display on Local Insight when the service icons are clicked on.

7

As it’s election day…

The services functionality has been designed to be completely customisable so it can be used to upload a whole range of information. As today is a general election, the below example shows all the polling stations in the London Borough of Hammersmith and Fulham.

The polling station data was downloaded from Data.gov.uk and published by London Borough of Hammersmith and Fulham

  • For the postcode column, the postcodes downloaded from Data.gov.uk were used
  • For the service type column, polling station was assigned for all postcodes
  • 2 columns of metadata were then added, including Location and Name

The image below displays how the data is formatted so it can be uploaded into Local Insight.

8

The image below shows how that data will display on Local Insight when the service icons are clicked on.

9

Feedback
Once again, thank you to all those users who took part in beta testing to help us develop this. We are always looking for more feedback and would also love to hear how you are using the improved Services functionality, so please do get in touch with us on support@ocsi.co.uk

Spend less time setting up users with the latest improvements to Local Insight

We have made improvements to the user setup process to make it easier for you to add new team members to Local Insight in a secure way. When adding new users, Local Insight will now send an account registration email by default, which will enable them to create their own password and log in.

This will reduce the admin overhead in setting up new users so that you can take full advantage of unlimited users across your organisation.

What’s new in Local Insight? 

  • Previously, when you created a user in Local Insight you were required to manually create a password and then email over the login details. Now you only need to set that user up and Local Insight will send across all the relevant information, including password creation. 
  • The automated account registration email also has links to the Local Insight News blog and Help Centre to ensure users can get up and running right away.
  • You can also send login details to existing users using the newly added Send user login details button found on the Manage Users page. This is useful if you want to remind your team that they have access to Local Insight and how to access the tool. 
  • The Send user login details box is selected by default when setting up new users, however, you have the option to unselect the box if you would rather wait to send the login details or you would like to send a personalised message.

How to add new users

Please note, only Group Admins can add new users to your group. For a reminder of what the different user permission levels mean read User Permissions on Local Insight.

To add a new user to your Local Insight group:

  • Navigate to the Group Admin tab
  • Click Manage Users
  • On that page, click Add a new user

This will load the New User form where you can fill in the required information:

  • Firstname, Surname and Email address is required
  • Telephone is optional 
  • Beneath the user form are four checkboxes
  • The first box, Send user login details, is selected by default. This will send the new user an account registration email where they can set a password and log in to Local Insight. If you do not want them to receive login details immediately then you can unselect this box 
  • The other three checkboxes, View Reports, Power User and Group Administrator, allow you to define what access permissions this user will have (LINK). Please note, if you are setting someone to be Group Admin, the other permission boxes also need to be selected
  • Click Register to create the user

Tip: If you cannot find the registration email, check your junk folder.

Get in touch!

If you have any questions, please do not hesitate to get in touch with us on support@ocsi.co.uk or give us a call on 01273 810270

Community Needs Index indicators now in Local Insight

 

Local Insight is the first platform to publish the new Community Needs Index, which can be used to help policymakers target investment in social infrastructure.

Introducing our newest set of indicators in Local Insight: Community Needs Index (CNI). This suite of indicators has been produced by OCSI to measure social and cultural factors that can contribute to poorer life outcomes. OCSI was commissioned by Local Trust to develop a quantitative measure of ‘left-behind’ areas (you can read the full publication to find out more about the research). As part of this, we developed a Community Needs Index, the first composite indicator of its kind, looking at the social and cultural factors that can contribute to poorer life outcomes.

We have included four new datasets in Local Insight; the scores for each individual domain and the overall CNI. In each case, a higher score indicates higher levels of community need.

  • Community Needs Index: Civic Assets score
  • Community Needs Index: Connectedness score
  • Community Needs Index: Active and Engaged Community score
  • Community Needs Index: Community Needs Score

This blog will provide more information on the data and how you can explore it in Local Insight.

About the data 

The CNI is particularly exciting as it gives a different perspective to more economically based measures of local need and is a useful measure in and of itself to help policymakers target investment in social infrastructure. 

The index has been developed at ward level after significant consultation and debate. The principal reason for selecting wards as the units of analysis as opposed to Lower Super Output Areas (LSOAs) was that wards align more closely with community boundaries and are of a sufficient size to cover locally recognised neighbourhoods. There is, of course, a potential risk that this can mask variations in community need at a very local level. We have run the same analysis at LSOA level and the results are broadly consistent with the ward level data. 

The index covers 19 indicators, across three domains;

  • Civic Assets: Measures the presence of key community, civic, educational and cultural assets in close proximity of the area. These include pubs, libraries, green space, community centres, swimming pools – facilities that provide things to do often, at no or little cost, which are important to how positive a community feels about its area.
  • Connectedness: Measures the connectivity to key services, digital infrastructure, isolation and strength of the local jobs market. It looks at whether residents have access to key services, such as health services, within a reasonable travel distance. It considers how good public transport and digital infrastructure are and how strong the local job market is.
  • Active and Engaged Community: Measures the levels of third sector civic and community activity and barriers to participation and engagement. It shows whether charities are active in the area and whether people appear to be engaged in the broader civic life of their community.

For a more detailed look at the indicators included within the CNI, please have a flick through the slides below.

Using the data in Local Insight 

This figure shows the Community Needs score in the East of England where the need is particularly high, especially around the agricultural Fen areas near the Wash.

This figure shows the Community Needs score in the East of England where the need is particularly high, especially around the agricultural Fen areas near the Wash

Technical information

As the data was developed at Ward level, we have apportioned the data in order to be able to include it within Local Insight at standard geographies. The ward score was copied down to Output Area level (every OA in the ward got the same score) and then aggregated to all higher geographies using population-weighted aggregation.

Where an LSOA fits exactly in a ward it will also have the same score as the ward it fits in. Where an LSOA cuts across wards e.g. 60% of people in the LSOA lived in ward A and 40% in Ward B it would get 60% of ward A’s score and 40% of ward B’s score.

Maps 

Across all four indicators, a higher score indicates higher levels of community need. These new indicators will not be shown on the Map by default, the Group Admin users can add these datasets to the maps using the Manage Indicators functionality. To do so, search the Unassigned theme for the indicator names, drag and drop them into a theme and then tick to show on the map.

Dashboard

All users can use the build a custom dashboard functionality to build dashboards that explore how different areas compare on these indicators. When building a custom dashboard, use the search bar to find the Community Needs Index indicators.

Reports

This new suite of indicators will be in any newly requested reports and can be found on page 65.

All Data Download

These indicators will also be added to the All Data Download in the next update which is due to take place at the end of November 2019.

Support

If you have any questions on these datasets, or suggestions for new ones to add, please get in touch on support@ocsi.co.uk

 

Access to Healthy Assets and Hazards

Introducing our newest set of indicators in Local Insight: Access to Healthy Assets and Hazards (AHAH). This suite of indicators from the University of Liverpool and CDRC includes 21 indicators (including a multi-dimensional index), that looks at how accessible certain health-related environmental features are to individuals. This covers, for example, proximity to GPs (an asset) to access to fast food outlets (a hazard).

This is the first time that a comprehensive small-scale set of indicators like these have been made available as open data with national coverage and there are exciting implications for supporting and informing decision making. The indicators included are from the recently updated version of AHAH (which includes an additional indicator).

Download the full indicator list for Access to Healthy Assets and Hazards in Insight

This blog will provide more information on the data (although for a much more detailed explanation, please read the technical report) as well as looking at how organisations may want to use this in practice and the ways Local Insight can support this work. 

About the data 

This is a vastly simplified summary of the datasets, so for the #dataheroes among us, please read the technical report, which goes into a lot more detail on the methodological choices made when constructing the datasets.

The individual indicators are based upon four domains of accessibility;

  • Retail environment (access to fast food outlets, pubs, off-licences, tobacconists, gambling outlets)
  • Health services (access to GPs, hospitals, pharmacies, dentists, leisure services)
  • Physical environment (Blue Space, Green Space – Active, Green Space – Passive)
  • Air quality (Nitrogen Dioxide, Particulate Matter 10, Sulphur Dioxide).

The individual indicators are combined to create the overall index, using an adapted version of the methodology for the Index of Multiple Deprivation. All data is published at LSOA level (or the equivalent Data Zones for Scotland) with larger scores depicting poorer health-related environments.

The datasets can be accessed via CRDC.

Limitations

As with all datasets, there are some limitations in using these indicators. The academic paper from the first version of the index has more detail on each of the points below:

  • The suite of indicators do not include all features of the environment that may influence health
  • It is simplistic to assume that we can separate environments to be ‘positive’ or ‘negative’ – that is to say different combinations of different features may produce different outcomes
  • The suite of indicators do not incorporate features of the social environment (which was a conscious decision so as not to replicate existing deprivation measures)
  • Each measure and overall domain scores are weighted equally, however they may not contribute equally towards influencing health.

Use cases

Map from Local Insight shows hotspot areas for poor access to GPs

Map from Local Insight shows hotspot areas for poor access to GPs

Some of the use cases below are sourced from the previously mentioned academic paper.

Service provision and use

The datasets can provide insight into whether services are provided in areas that are most in need. The dataset itself could help to flag up hotspot areas that have the poorest access to services. Using Local Insight, you can identify these areas quickly and easily using hotspots and then overlay this data with your locally held data on individual local assets (such as GP practices & pharmacies), in order to start conversations and inform commissioning decisions.

In addition, you could also compare the data with socio-economic indicators on the dashboard to quickly and easily identify areas with poor access to health services that have high health needs. 

Retail outlets and shaping behaviour

There is an argument that the sources of services and goods we have access to may shape our behaviours. For example, some research has shown that individuals who have a greater number of fast food outlets within their vicinity can be associated with risk of obesity and the proximity to gambling outlets may affect the risk of problem gambling behaviours.

With this in mind, being able to identify areas with a particularly large score in relation to hazards could be useful in targeting public health communications and resources to these areas. Furthermore, it could have implications for planning and licensing teams and the public health implications for any new premises. 

The Index of AHAH could also be useful to compare with locally held data to test underlying assumptions about which areas have most or least access to these services.

National level decision-making

Finally, as this data has been made available as open data on a national scale, there are lots of opportunities for better partnership working both across institutions and local authority boundaries, through removing some of the barriers associated with sharing data. For organisations that have a public-facing Local Insight site, this means that stakeholders from across local authorities, CCGs and the local community and voluntary sector can all find and use consistent, up-to-date and robust data around local assets and hazards. 

Equally, as the methodology has been applied consistently across all areas, it is possible to make comparisons across different local authorities with less risk of local bias. In practice, this means local authorities can compare their own areas to other authorities that are experiencing broadly similar socio-economic challenges, but with a substantially different outlook when it comes to AHAH. This could lead to better sharing of resources & knowledge around policy-making and initiatives that are most likely to have a positive impact. 

 

How to access the data in Local Insight 

Maps 

Group Admin users can add these datasets to the maps using the Manage Indicators functionality. To do so, search the Unassigned theme for the indicator names, drag and drop them into a theme and then tick to show on the map.

Dashboard

All users can use the build a custom dashboard functionality to build dashboards that explore how different areas compare on these indicators.

Reports

This new suite of indicators will be in any newly requested reports and can be found on page 45.

All Data Download

These indicators will also be within the All Data Download, a download of the data for every indicator in Local Insight for every Lower Layer Super Output Area (LSOA) in the country.

If you have any questions on these datasets, or suggestions for new ones to add, please get in touch on support@ocsi.co.uk

5 ways to get the most out of the dashboard

1. Create a custom dashboard in seconds

The dashboard is a great way to be able to compare multiple indicators at once, however with only one dashboard view per organisation, it used to be tricky to build a dashboard that suited everybody’s needs.

Not anymore.

The new functionality in Local Insight allows users to create custom dashboards on the fly. This means the indicators appearing on the dashboard can be tailored to each individual for any project. Everybody (not just Group Admins!) now has the ability to build their own dashboards quickly and easily – meaning you can create dashboards set up specifically for your needs – whether that is adolescent health, loneliness or access to services.

build a custom dashboard

2. Get to grips with the data from within the dashboard itself

With some improvements to the metadata on the dashboard, it is now possible to gain a lot more information about what the data shows from within the dashboard itself. For example, the metadata can be found by clicking on the indicator header, and hovering over an individual data value will show you everything you need to know about what that number means. 

We have a real focus on keeping things accessible and simple to use with Local Insight, and hope that this will help all users – not just analysts – make better use of the dashboard.

click on indicator heading

Metadata

3. Generate a tailored data export for particular areas and indicators

There are already a number of ways to export data from Local Insight. The recent addition of the All Data Download means you can dig into all of the raw data held in Local Insight at LSOA level and the download from the Data for my Areas pop up puts a spotlight on one indicator.

The dashboard export covers the needs in between and is super useful for providing data for a selection of areas and selection of indicators – as decided by you.

So, if you want to create some of your own charts or send the data to a colleague, why not see if using the dashboard export can save you a bit of time.

(Of course – you can still copy and paste the dashboard directly from Local Insight into Excel to do your own further analysis. This has the additional benefit of retaining the colour scales.)

4. Use comparators to show how your areas fare locally, regionally and nationally

The dashboard now includes the England value as standard so that you can quickly and easily see how your areas fare compared to the national comparator. 

But you needn’t stop there, you can set up any area you like as a custom area in Local Insight. It will then be visible on the dashboard for you to use as a comparator area.

You could set up a new Custom Area Category for all your comparator areas – and then set up local authorities, counties, regions, CIPFA nearest neighbours – whatever is useful for you. 

benchmark areas

5. Use dashboards in your presentations and reports

All of the data in Local Insight is open data – so you are free to use and reuse the data in any way you like. So, if your PowerPoint presentation is lacking in visuals, or you need a neat way to explain the local context for your service patch, why not try adding a screenshot from your dashboard in? It is quick and easy to do as well as clear and concise way to tell your story.

More information:

For more information on all of the updates to the dashboard, take a look at our blog. For step-by-step guidance on using all the new functionality, head to the Knowledge Base.