Data updates

Featured

Community Insight is updated every month with new data. To see a list of all the datasets in Community Insight check out this article on our Knowledge Base.

Here you can find archived links to previous data updates:

Community Insight England Community Insight Scotland
Community Insight Wales
2020-Sep 2020-Sep 2020-Sep
2020-August 2020-Aug 2020-Aug
2020-July 2020-Jul 2020-July
2020-June 2020-Jun 2020-June
2020-May 2020-May 2020-May
2020-April 2020-Apr 2020-Apr
2020-March 2020-Mar 2020-Mar
2020-Feb 2020-Feb 2020-Feb
2020-Jan 2020-Jan 2020-Jan

Time series data for unemployment benefit in Community Insight

Explore how unemployment changed during the COVID-19 pandemic and lockdown with times series data in Community Insight. 

The Department for Work and Pensions publishes Unemployment benefit (JSA and Universal credit) every month. In turn, we update the data in Community Insight to show the latest monthly snapshot. 

Given the dramatic changes to unemployment and the effects that it may have on your communities, we have added in the previous 3 months unemployment benefit data as individual indicators, so that you can see the month-on-month change for your areas. These datasets can be displayed on the map and downloaded for your stock groups.

Alongside the usual monthly updates for Unemployment (June 2020), we have added 3 historical time-points for the indicator Unemployment benefit (JSA and Universal credit):

  • March 2020
  • April 2020
  • May 2020

How to view this data on Community Insight

The map

  1. Click on the Data button
  2. Search Unemployment using the search bar
  3. You will see the most recent Unemployment benefit (JSA and Universal credit) indicator for the month of June 2020 and the 3 historic timepoints listed beneath

Click on image to see full size

Download the data for all 4 timepoints for your stock groups

  1. Click on the Data button
  2. Search Unemployment using the search bar
  3. You will see the most recent Unemployment benefit (JSA and Universal credit) indicator for the month of June 2020 and the 3 historic timepoints listed beneath
  4. Select the first time point
  5. Click on the Info button
  6. Click Data for your areas (this will open up a popup with data for your stock groups)
  7. Click Download this dataset in CSV format
  8. Repeat this process for the other 3 timepoints 

Click on image to see full size

Please note in the Data for your areas popup the table of data has two columns. The first column shows the percentage figure, the second column shows the count data. When you export the data to a CSV, only the percentage figure is exported. Adding the count data to the export is one of our development priorities and will be coming soon. 

On the Dashboard

You can only view the latest time point for Unemployment benefit (JSA and Universal credit) on the dashboard

In the reports 

This data has not been added to the reports. The reports do however already contain a chart that shows how Unemployment benefit (JSA and Universal credit) has changed since 2004 (page 10).

Figure: Unemployment benefit (Jobseekers Allowance/Universal Credit) claimants Source: Department for Work and Pensions

Figure: Unemployment benefit (Jobseekers Allowance/Universal Credit) claimants
Source: Department for Work and Pensions

Would you like to see more time series data in Community Insight?

We are looking at options to include more time series data within Community Insight. Please email support@ocsi.co.uk with any suggestions for what would be useful and to register interest in taking part in future user research on this topic. 

Removed Monthly Change in Unemployment Indicator

We have removed the indicator Monthly Change in Unemployment. The new indicators for Unemployment benefit (JSA and Universal credit) for the last four months supersede this indicator. For those groups who had it assigned to a theme, it will no longer be available. 

Further reading

If you are interested in how COVID-19 has affected employment and the economy more broadly, take a look at some of our recent analysis: 

How to upload non-numerical survey data to Community Insight

Community Insight offers a number of ways to add your own organisational data into the system. The Upload your data functionality allows you to import datasets that display on the maps in the same way as the standard datasets that we include in the tool for you.

You can use this functionality to upload some non-numerical results of surveys that you run with tenants with a little bit of data reformatting.

This guide will run you through the process of uploading your data in this way.

You will need to be a Group Admin to upload your own data to Community Insight.

A choropleth map displaying percentage data on current smokers

 

1. Is your data suitable for uploading in this way?

You will first need to determine whether the data you want to upload is suitable for the Upload your data tool. 

The dataset must have:

  1. Geographic data: When uploading survey data, you will most likely want to use postcodes
  2. Binary data: The survey question must have only two possible responses.

Suitable:

As part of an annual residents survey, you collected respondents’ postcodes and asked ‘are you a current smoker?’

  1. In this case, you have suitable geographic data for every respondent (their postcode)
  2. The respondent can only answer ‘yes’ or ‘no’ to this question, so it is suitable to upload into Community Insight.

Not suitable:

As part of an annual residents survey, you collected respondents’ postcodes and asked ‘what is your ethnic group?’

  1. In this case, you have suitable geographic data for every respondent (their postcode)
  2. The respondent could give a wide range of answers to this question and so it is not suitable to load in as the tool cannot import categorical data.

If you are unsure whether your dataset can be imported in this way, please get in touch at support@ocsi.co.uk and we can talk it through with you.

2. Set up your metadata

Go to:

  • Group Admin
  • Manage your data
  • New dataset

General guidance for setting up metadata can be found in the Help Centre.

When setting up the metadata for survey responses, take note of the following points:

  • Description: Make it clear that the data has come from survey responses. You may want to include details on the question that was asked and the sample size
  • Percentage suffix: When you import the data into the tool it will display as a percentage. Make sure you add the percentage sign to the Suffix box when asked
  • Decimal points: Depending on what you are uploading, you may want to include one or two decimal places
  • Aggregation method: You will be asked ‘how should we create data for higher areas from your uploaded data?’ You must select Averaging here
  • Suppression: If you are uploading postcode level data that is potentially sensitive, you can select a suppression threshold (Please see the Help Centre for more information on suppression).

3. Format your data

When it comes to importing your data, you can do this by uploading a CSV file or through copying and pasting values.

In each case, you will need to ensure that you have two columns of data correctly formatted in an Excel document. 

  • Geographic data: In one column, you will need a postcode (or other geographic code) in each row. 
  • Binary, numerical data: In another column, you will need your survey responses in numerical format.

4. How to turn your survey data into numerical data

Let’s go back to the earlier example of asking ‘Are you a current smoker?’ Each respondent would have answered ‘Yes’ or ‘No’.

In order to import the data into Community Insight, you need to turn this into numerical data. To do this, all the respondents that answered ‘No’ should have the value of 0 and all the respondents that answered ‘Yes’ should have the value of 100.

Shows three columns in an Excel spreadsheet displaying survey data, numerical data and postcodes

Tip: You can bulk change all your responses to numerical data using the Find and Replace functionality in Excel.

  • Find all instances of ‘Yes’ and replace all with 100
  • Find all instance of ‘No’ and replace all with 0

Screenshot showing the Find and Replace all functionality in Excel

Alternatively, you could also use an IF statement to do this. This may be a better option if your survey results are denoted by single letters (eg. ‘Y’ and ‘N’) as you may end up replacing some of your postcode data using a simple ‘Find and Replace all’.

5. Import data

You can now import your data into Community Insight. At this stage, it doesn’t matter if you have more columns than you need – you will be able to filter these later.

If your spreadsheet includes formulae (eg. if you have used an IF statement), you must save the file as a CSV file, rather than Excel, before importing.

Follow the on-screen instructions to import your data. Further guidance is available in the Help Centre:

6. Add dataset to your maps and dashboard

Now that your data has been imported, you can add it to your Map and default dashboard using the Manage Indicators functionality.

The data will be displayed on your maps and dashboard as percentage figures.

Improvements to Community Insight to help save you time

We are excited to introduce two new improvements that enable you to:

  • Search for indicators on the map more easily
  • Identify your areas with ease using MSOA names 

Search for indicators on the map more easily

Community Insight has over 1000 indicators. With so much data available, being able to find what you are looking for quickly is important.

We have added 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.

Data search bar

How to use

  1. Click on the Data button to open the menu of themes and their indicators 
  2. The search bar is at the top. Type in any text and the indicators that contain that string of text will be displayed under their theme heading
  3. Click on an indicator name to view it on the map
  4. To show the full menu of indicators again, delete the text in the search bar 

Please note: Not all indicators within Community Insight are shown within the Data menu by default. There are over 1000 datasets in Community Insight and the Group Admin user(s) select which ones are shown. If a user searches for an indicator that is available in Community Insight but not assigned to a theme then nothing will come up in the search.

 

Identify your areas with ease using MSOA names 

MSOAs are an integral geography in Community Insight. You can view indicators on the map at MSOA level and you can create stock groups out of MSOAs. However, MSOA codes are not easily recognisable – they are made up of two parts: The parent Local Authority and a string of numbers. For example, Westminster 018. 

Meaningful Names

The House of Commons Library has created a set of meaningful names for MSOAs (also available on an interactive map). We have added these names into Community Insight to make it easier for you to find the areas you are interested in. As part of this, we have also changed the LSOA names to incorporate the name of the parent MSOA to help you have a better idea of where the LSOA is located.

 

Previous MSOA code New MSOA names 
Westminster 018 Strand, St James & Mayfair – Westminster 018
Westminster 019 Knightsbridge, Belgravia & Hyde Park – Westminster 019
Westminster 020 Central Westminster – Westminster 020


Where can you see these new names?

The names can be found in two places on Community Insight: 

  • When hovering over areas on the map
  • When creating stock groups out of MSOA or LSOA areas

 

When hovering over areas on the map

  1. Choose an indicator from the Data button and select to display it on the map 
  2. Zoom in to view the data at either MSOA or LSOA level (the Info popup will inform you at which level you are viewing the data)
  3. Minimise the Info popup, and then hover over the areas on the map
  4. In the top right hand corner will be a small box that displays the MSOA/LSOA area name and the value for that area

MSOA hover

 

When creating stock groups out of MSOA or LSOA areas

In Community Insight, you can create stock group areas made up of MSOAs and LSOAs. The new names will now display in the stock group creation popup. 

  1. Click Group Admin Manage stock groups
    1. Click Add stock group
    2. Select Area Type Based on standard area
  2. Select to browse the list of MSOAs or LSOAs

MSOA names

Please note: Only Group Admin and Power Users can create stock groups in Community Insight.

If you are unfamiliar with the terms LSOA and MSOA, these are statistical geographies created for the Census. Read more about them in our blog: LSOAs, LEPs and lookups : A beginner’s guide to statistical geographies.

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

Add additional information to your stock data

We have made some major improvements to the Stock feature on Community Insight so that you can now add additional information to your properties and view that on the maps page.


blog 1

The enhanced functionality allows you to add more information to Community Insight so that you can see information for individual properties. Coupled with the socio-economic data available within the system and the locally held datasets you can add in, this improved functionality contributes to making Community Insight a one-stop shop for local information. 

 

The developments focus on:

  • Enhancing the Stock functionality to allow you to add additional information to your individual properties
  • Improving the error feedback and the importing process so that you have a more streamlined experience
  • Improving the speed so the maps page loads quicker

 

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

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

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

What’s new in Community Insight?

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

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

Please note: If you use the Organisations feature then your metadata goes in the 5 columns after that Organisations column.

blog 2

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

blog 3

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

What has been improved?

Removed copy and paste option

Previously, you could upload your stock 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.

 

Better error feedback

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

 

Improved site performance

We have focused on speeding up the time it takes for the stock to load on the map. This is something which has been raised by users in the past and is an issue for those organisations who have very large property portfolios. This work means that you can now upload more information about your properties without seeing a significant drop in the performance of the site.

Potential use case

Understanding the areas you work in

Use Community Insight to combine the data you have on your properties with the socio-economic context of an area, to get a better understanding of your tenants and their needs. 

 

Upload your stock with the added metadata 

Now that you can add information to individual properties, you will need to upload your latest stock. 

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

 

The enhanced functionality allows you to add additional information to individual properties, which will then be displayed on the map when an icon is clicked on. The information you add is entirely up to you. For example, you could add any of the following:

  • Number of bedrooms in a property 
  • Number of occupants in a property
  • Council Tax Band 
  • Repairs due
  • Smart meter 

 

The example below demonstrates the kind of information you could upload and how it must be formatted.

blog 4

Download your property data for an area 

In Community Insight you can create stock groups, these are areas which can be standard areas or more bespoke areas created by you. Once you have successfully uploaded your stock data with the additional information, Community Insight will match the stock to your stock groups thereby allowing you to see the stock you have in an area. You can also download the list of stock in an area

To do this go onto the maps and select to view an area on the map, then click on the i icon next to the area name, this will open up a popup detailing more information about that stock group with the option to “Download list of stock”.

blog 5

blog 6

Visualise your property data on Community Insight 

Once you have successfully uploaded your stock data, you can view this on the map by clicking on individual stock icons. This allows you to visualise your property information in a more accessible way.

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

Overlay socio-economic data alongside your property data

Layer the property data you have uploaded with the standard socio-economic datasets in Community Insight so that you can see the housing provision alongside the needs of an area.

blog 7

Feedback

We are always looking for more feedback and would also love to hear how you are using the improved Stock functionality, so please do get in touch with us on support@ocsi.co.uk

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 Community 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 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 Community Insight England 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 Community 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. 

How to create stock groups based on top 10% most deprived LSOAs

Within Community 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 (or stock group in Community Insight) 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 stock group 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 stock group in Community Insight

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

The easiest method to create the stock group in Community Insight is through the Create a stock group 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 stock group 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 stock group
create custom area

Click on image to see full size

7. Create a stock group that spans multiple local authorities

If you are creating a stock group 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 stock group 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!

Community Needs Index indicators now in Community Insight

 

Community 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 Community 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 Community 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 Community 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 Community 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

Please note, the Community Needs Index indicators are only in Community Insight England. There is no data available for Community Insight Wales or Scotland.

As the data was developed at Ward level, we have apportioned the data in order to be able to include it within Community 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 70.

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 Community 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 Community 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 Community 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 Community 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 Community 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 Community 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.

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

New dashboard upgrades for a more intuitive and tailored experience

We have been working on some big improvements to the dashboard and we are so excited that they are now live for you to use.

The developments focus on:

  • making the dashboard more interactive and tailored to individual users
  • making it easier to understand and interpret the data

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

  • Creating your own custom dashboards
  • How the colour scales work
  • Using the national comparator
  • Improved metadata
  • Tailored data exports

For step-by-step guidance, please read through the Dashboard section on the Knowledge Base.

Creating your own custom dashboards

Build custom dashboards on a per user basis

Using the Areas and Data buttons (see below) you can now edit which indicators and areas populate the dashboard from within the dashboard page. This enables any user to create multiple dashboards that explore different themes for different areas, rather than using a dashboard preset by the Group Admin.

Dashboard buttons

 

Choose a preset theme and build a dashboard in seconds

Community Insight has preset themes (the themes that are shown on your Maps page). These have been set by the Group Admin in your organisation. You can now select to view all indicators in one particular theme on the dashboard.

Select a theme

 

Build your own custom dashboard from all the indicators in Community Insight

Community Insight has over 900 indicators. Use the custom dashboard builder to search through those indicators and find the ones that are most important to you. This enables you to create dashboards which reflect your strategic priorities or the priorities of individual projects. This is made much easier through the new search bar.

custom theme

 

Choose which areas to compare data for

The core functionality of the dashboard allows you to see how your areas compare to multiple indicators. However, we know that you may not always want to compare all of your areas at the same time. You can still select which areas you wish to display on the dashboard. However, now when you select areas, the dashboard will recalculate the colour bands so it is comparing only those areas you have selected to view.

areas button

How the colour scale works

We have simplified the colour scale on the dashboard so that it is easier to see patterns and identify issues across your areas. The areas are now shaded in three colours which represent high, medium or low values. The methodology used to distribute the areas into the colour bands takes the highest and lowest value across your custom areas and then create 3 bands which equally span that range.

Take the example below, looking at Cancer prevalence. The highest value in the table is 3.3 and the lowest is 1.5.

dashboard colours example

 

Therefore the value bands are as follows:colour bands

Note that these are equally sized bands so the difference between the lower and upper threshold of each band is 0.6 in this case.

As mentioned in the previous section, when you change which areas are displayed, the colours will also update to reflect how the selected areas compare against each other. The figure for the national average is not included in the creation of the value bands.

Please note: in cases where there are decimal figures involved, the figures in the dashboard are rounded to 1 decimal point.

 

Using the national comparator

The colours on the dashboard allow you to see how your areas compare against each other. However, you can now look at the national average along the top of the dashboard as a benchmark for how your areas fare compared to the national picture.

national comparator

 

Improved metadata

The dashboard is designed to show lots of data at once in a clear and concise manner. We also want to ensure that it is quick and easy for you to understand what the numbers show. Introducing:

  • Metadata on indicator headers
  • More info on what the data represents when you hover over a data value

Click on the indiactor headers

metadata popup

Hover interaction

Tailored data exports

The Export button allows you to export your dashboard to Excel, so that you can do further analysis or share with colleagues. We have made the export functionality more intuitive, so now when you export – the file will include the areas and the data you are currently viewing on the dashboard. The export also contains the data at a more granular level with the full decimal figure.

Please note:

  • As part of our work to make the dashboard simpler and more intuitive to use, we’ve decided to remove the charts tab. Our research tells us that the charts were not widely used and charts are accessible within the reports for those people who do want to see them

Feedback

We are always looking for more feedback so whether you love the dashboard or if there are a few tweaks and tidies that you’d like to see, please let us know on support@ocsi.co.uk