Data updates

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 all previous data updates:

October 2018

Community Insight England

Community Insight Scotland

Community Insight Wales

December 2018

December 2018 December 2018
November 2018 November 2018 November 2018

October 2018

 October 2018 October 2018
September 2018 September 2018 September 2018

 

A closer look at the newest additions to Community Insight

Participation in Higher Education

One of the newest datasets added to Community Insight is particularly exciting as it gives an insight into participation in Higher Education at a local level. The data is published by the Office for Students at MSOA level (which we have apportioned to other geographies) and shows the percentage of young people that entered higher education aged 18 or 19 as a proportion of all the 18 or 19 year olds in the area.

NB: Although the denominator is a proportion of the 18 or 19 year olds in the area, the calculation is not as straightforward as this. To compensate for the large migration of 18 and 19 year olds that attend university – often moving to concentrated student areas – the calculation is based on a previous cohort. Or in other words, it is based on the total number of young people (15 year olds) who would be 18 or 19 during the 2009-10 to 2014-15 academic years.

Due to this inherent variability involved in the estimation of these rates – some of the participation rates are estimated to be greater than 100%, due to population turnover of any 15 year olds that moved in or out of the area before reaching the age of 18 or 19.

Explore the data for yourself within Community Insight (Tip: you will first need to add the indicator to the map using the Manage Indicators functionality) and use it to better understand:

  • Where to target campaigns and funding on participation in higher education
  • Whether the local jobs market is likely to meet the demands of young people leaving education
  • The local need for training programmes and apprenticeships
  • Any risks for youth unemployment and the impact on economic planning

Headline trends:

  • Local Authorities in and around London have the highest proportion of 18 and 19 year olds participating in higher education, with concentrations across the country focused around the main big university cities.
  • The five Local Authorities with the highest proportion participating in higher education are in London: City of London (110%), Kensington and Chelsea (93%), Richmond upon Thames (85.9%), Westminster (70.4%), Harrow (67.2%). The England average is 37.5%.
  • Lower levels of participation in higher education are evident in coastal authorities, smaller cities and more rural areas across the country
  • The five Local Authorities with the lowest proportion participating in higher education are: Hull (21.6%), Stoke-on-Trent (23.5%), Barnsley (23.6%), Thurrock (24.8%), Nottingham (25.2%)

SME lending debt per person aged 18+

Another addition comes from UK Finance, looking at the total amount of borrowing outstanding on customer accounts for SME (small and medium sized enterprises) lending.

This has been calculated as a ‘debt per person’ figure in order to ensure areas are being compared like for like when looking at the distribution of SME lending.

Although it is interesting to explore the data, and the trends at both a national and local level, caution should be taken when attempting to discern causality.

Without in depth local knowledge and other supporting statistics, it is not possible to tell whether higher levels of lending in a local area is a positive or negative factor. For example; high levels of lending activity could be a positive indicator for local economic health, driven by a thriving small business sector, characterised by a high number of small businesses with outstanding (but manageable) loans to support their growth.

Conversely, it could indicate that small businesses in that local area are struggling, and taking out loans in order to help them survive, in which case, would be a less positive outlook for local economic health.

So, as is the case with all data, this data should not be used in isolation to make decisions – but can provide supplementary information and knowledge to help inform understanding of the local economic picture.

You can explore the data for yourself in Community Insight by adding the indicator to the map using the Manage Indicators functionality.

Small area benefits measures from DWP

There have been a number of changes in the local level benefits measures that the Department for Work and Pensions (DWP) publish on a regular basis. Take a look at our short guide for anybody navigating the changes. This details what the new data shows, what it replaces and what it can be used for.

Data updates in Community Insight

As we wind down for the festive season, we bring updates from the Department for Work and Pensions (DWP) and the Valuation Office Agency (VOA).

The below table is a snapshot of some of the key datasets which have been updated. To see a full breakdown of all datasets updated this month see our knowledge base article containing a list of all the datasets available in Community Insight.

New indicators for Community Insight England, Wales and Scotland

Indicators on Source Reports Maps
Personal Independence Payment (PIP), broken down by gender and mental health claimants Department for Work and Pensions (DWP) Yes Yes
Benefit claimants (benefit combinations), broken down by age and type of benefit Department for Work and Pensions (DWP) No Yes

Updated indicators for Community England, Wales and Scotland

Indicators on Source Reports Maps
Jobseekers allowance and unemployment benefit (JSA and Universal Credit), broken down by claim period, age and gender Department for Work and Pensions (DWP) Yes Yes
Universal Credit claimants – Conditionality Regime, broken down by claimant status Department for Work and Pensions (DWP) Yes Yes

Updated indicators for Community England and Wales only

Indicators on Source Reports Maps
Dwelling Stock by Council Tax Band, broken down by banding Valuation Office Agency (VOA) Yes Yes
Dwelling stock, broken down by time of build Valuation Office Agency (VOA) Yes Yes

Current indicators within Community Insight

To see a list of all of the current indicators available in Community Insight check out this knowledge base article containing a list of all the datasets available in Community Insight.

Want to see more indicators within Community Insight?

We are always looking to add new indicators to Community Insight. So if you have any ideas of particular indicators you would like to see then let us know. Provided that the data is open data and published at small area level, so below Local Authority level, we will load the data in for you.

Get in touch!

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

Christmas holiday

Office closure

Image credit: https://www.pexels.com/photo/santa-claus-plush-toy-1556679/

Image credit: https://www.pexels.com/photo/santa-claus-plush-toy-1556679/

 

We hope you have a lovely break over the festive period! This is just to let you know that OCSI will be closed Monday 24th December to Wednesday 2nd 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 Thursday 3rd January.

As another year draws to a close, we would like to thank you for your continued support and interest in Community Insight. We are looking forward to what 2019 will bring!

 

Hover over the maps in style!

Keen-eyed users may have noticed something different about the areas you can hover over in Community Insight – that’s because we’ve improved the way you can interact with data displayed on the map.

Hover Feature 

As part of our recent move to using 2011 boundaries in Community Insight, we undertook work to improve the way data is displayed on the map. Previously when data was displayed on the map, it was only possible to see the data value for an individual LSOA by hovering over it. Now our new and improved map allows you to see the indicator value of any individual LSOA, MSOA or LA!

hover gif

This improvement and the design of the functionality was inspired by input from a number of users. So a big thank you to all of those people who gave us feedback on this area of the site. For example, previously when you selected an area, the data value disappeared and only the geographic code displayed. We received lots of feedback identifying how it is valuable to see both the code and the data value and so we have changed this to always show both

The Knowledge Base

For a more detailed article on how to view data on the map, including for an individual area (at any geography level), see our article on Viewing Data For Individual Areas.

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

Data updates in Community Insight

This is quite possibly our largest data updates ever!

The below table is a snapshot of some of the key datasets which have been updated. To see a full breakdown of all datasets updated this month, see our knowledge base article containing a list of all the datasets available in Community Insight.

New indicators

England, Wales and Scotland

Indicators on Source Reports Maps
SME lending debt per person aged 18+ UK Finance Yes Yes
Universal Credit claimants – Conditionality Regime indicators Department for Work and Pensions (DWP) Yes Yes

England

Indicators on Source Reports Maps
Participation in higher education Office for Students (OFS) Yes Yes

If you want to use these indicators remember to add them to the map and dashboard. If you are unsure how to do this, then this article can help:

 

Revised indicators (Revised as part of Mid Year Estimate revisions)

Please note: These indicators have been updated because the denominator used for the indicator’s calculation has changed.

England, Wales and Scotland

Indicators on Source Reports Maps
Business units/VAT based local units Office for National Statistics (ONS) Yes Yes

England and Wales

Indicators on Source Reports Maps
Children in out-of-work families HM Revenue and Customs (HMRC)/Department for Work and Pensions (DWP) Yes Yes
Jobs density (jobs as a percentage of the working age population) Business Register and Employment Survey (BRES) Yes Yes
Road accident casualty rate Department for Transport (DfT) Yes Yes
National Insurance numbers issued to non-UK nationals Department for Work and Pensions (DWP) Yes Yes
Crimes Crimes Yes Yes

England

Indicators on Source Reports Maps
Big Lottery grant funding Big Lottery Yes Yes

 

Updated indicators

England, Wales and Scotland

Indicators on Source Reports Maps
Population Office for National Statistics (ONS) Yes Yes
Population density (persons per hectare) Office for National Statistics (ONS) Yes Yes
Unemployment benefit Department for Work and Pensions (DWP) Yes Yes
Universal credit Department for Work and Pensions (DWP) Yes Yes
Housing benefit Department for Work and Pensions (DWP) Yes Yes
Attendance Allowance claimants Department for Work and Pensions (DWP) No Yes
Carers receiving Income Support Department for Work and Pensions (DWP) Yes Yes
Disability Living Allowance claimants Department for Work and Pensions (DWP) Yes Yes
Employment and Support Allowance claimants Department for Work and Pensions (DWP) No Yes
Incapacity Benefit claimants Department for Work and Pensions (DWP) Summary yes, breakdowns no Yes
Income Support claimants Department for Work and Pensions (DWP) No Yes
Lone Parents receiving Income Support Department for Work and Pensions (DWP) Yes Yes
Older people social care benefit (Attendance Allowance) Department for Work and Pensions (DWP) Yes Yes
Pension credit claimants Department for Work and Pensions (DWP) No Yes
Debt UK Finance Yes Yes

England

Indicators on Source Reports Maps
Physical activity, broken down by amount and frequency Sport England Yes Yes
Universal Credit claimants – Conditionality Regime Department for Work and Pensions (DWP) Yes Yes

 

 

Current indicators within Community Insight

To see a list of all of the current indicators available in Community Insight check out this knowledge base article containing a list of all the datasets available in Community Insight.

Want to see more indicators within Community Insight?

We are always looking to add new indicators to Community Insight. So if you have any ideas of particular indicators you would like to see then let us know. Provided that the data is open data and published at small area level, so below Local Authority level, we will load the data in for you.

Get in touch!

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

Data updates in Community Insight

Plenty of data updates for you this month!

The below table is a snapshot of some of the key datasets which have been updated. To see a full breakdown of all datasets updated this month see our knowledge base article containing a list of all the datasets available in Community Insight.

Updated indicators For Community Insight England, Wales and Scotland

Indicators on Source Reports Maps
Unemployment benefit, broken down by age, gender Department for Work and Pensions (DWP) Yes Yes
Jobs density (jobs as a percentage of the working age population) Business Register and Employment Survey (BRES) Yes Yes
Jobs, broken down by sector, public or private and contract type Business Register and Employment Survey (BRES) Yes Yes

Updated indicators For Community Insight England and Wales only

Indicators on Source Reports Maps
Crime and offences, broken down by type Police UK (Police recorded crime figures) Yes Yes
House price, broken down by median and lower quartile House Price Statistics for Small Areas (HPSSAs) No Yes
Average house price, broken down by house type Land Registry Yes Yes

Updated indicators For Community Insight England only

Indicators on Source Reports Maps
Number of property transactions Land Registry Yes Yes
Number of property transactions for detached houses Land Registry Yes Yes
Number of property transactions for flats Land Registry Yes Yes
Number of property transactions for semi-detached houses Land Registry Yes Yes
Number of property transactions for terraced houses Land Registry Yes Yes

Current indicators within Community Insight

To see a list of all of the current indicators available in Community Insight check out this knowledge base article containing a list of all the datasets available in Community Insight.

Want to see more indicators within Community Insight?

We are always looking to add new indicators to Community Insight. So if you have any ideas of particular indicators you would like to see then let us know. Provided that the data is open data and published at small area level, so below Local Authority level, we will load the data in for you.

Get in touch!

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

Update to Community Insight geographies and maintenance period

This November we are updating the geographic areas in Community Insight England and Wales. In order to ensure this update goes smoothly, we will be limiting access to admin features on Community Insight for a short period of time. This upgrade to our geographic database will cause data for a small number of your stock groups to change. These changes will overall be very minor. The information in this blog details how, why and when these updates are happening.

Site Maintenance Period

This update is planned to commence on Thursday 15th November at 3pm and will finish on Monday 19th November at 2pm. During this period, you will still be able to access Community Insight, however, you will be limited to View Reports access. This means you will be able to view everything on the tool but will not be able to access any of the admin features which allow you to; create stock groups, request reports, upload stock, upload data or manage your indicators. We will keep you updated throughout this process and make you aware when all is back to normal. Please do get in touch if you have any concerns or questions.

What will change?

Community Insight is built on the Census geographies: Middle Layer Super Output Areas (MSOA), Lower Layer Super Output Areas (LSOA) and Output Areas (OA). These are statistical geographies which were created for the Census in 2001 and then updated in 2011. On Community Insight we have historically used the 2001 Census geographies. This means that when you create stock groups and when you view data on the maps, you are viewing the 2001 boundaries. During this update, we will be upgrading to use the 2011 boundaries.

Not all boundaries changed during the 2011 update, in fact, only about 5% of areas nationally had any changes.

For more information on the background of Super Output Areas and the ways in which they changed; please see guidance from ONS and download their explanations.

Why are we doing this update now?

We didn’t move to the 2011 codes straight away as until very recently data from a number of our key sources such as the Department of Work and Pensions (which update data very regularly) still published data at the 2001 area level.

During this time our data processes used weighted lookups from the old to new geographies in order to account for the 5% of areas that had changed. Take a look at our Knowledge Base for more information on our methodology.

What does this mean for my stock groups and data?

Stock Groups

Will data change for my stock groups?

Those stock groups which contain OAs, LSOAs or MSOAs that changed in 2011 will be updated to reflect these changes. What this means is that you may see some very slight changes to the data for some of your stock groups.

How will I know which stock groups have been affected?

We are going to email the Community Insight lead of every organisation with a list of all the stock groups which have been updated.  If you are unsure who the project lead for your organisation is, or would like to be included in this email, please get in touch on support@ocsi.co.uk.

Will my stock groups look different?

Some of your stock groups may look visually different after this update. This will depend on how your stock groups were created:

  • All stock groups which were created by; drawing on a map or based on postcodes will not change visually.
  • Stock groups created by selecting standard areas may change visually if they contain any OAs, LSOAs or MSOAs which were updated in 2011.

 

Custom Data

Custom datasets which you have uploaded yourselves may display differently and therefore may require re-uploading. We will send every Group Admin a breakdown of the custom datasets affected and guidance for how to re-upload successfully.  

More information

If you have any questions on how this will affect your stock groups and data, please do get in touch on support@ocsi.co.uk or give us a call on 01273 810270.

Data updates in Community Insight

Updates for this month focus on unemployment indicators.

The below table is a snapshot of some of the key datasets which have been updated. To see a full breakdown of all datasets updated this month see our knowledge base article containing a list of all the datasets available in Community Insight.

Updated indicators

Indicators on Source Reports Maps
Youth unemployment (18-24 receiving JSA or Universal Credit) Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit (JSA and Universal Credit) Department for Work and Pensions (DWP) Yes Yes
Jobseekers Allowance claimants, claiming for over 12 months Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit (JSA and Universal Credit), female Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit (JSA and Universal Credit), male Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit Department for Work and Pensions (DWP) Yes Yes
Older person unemployment (50+ receiving JSA or Universal Credit) Department for Work and Pensions (DWP) Yes Yes

Current indicators within Community Insight

To see a list of all of the current indicators available in Community Insight check out this knowledge base article containing a list of all the datasets available in Community Insight

Want to see more indicators within Community Insight?

We are always looking to add new indicators to Community Insight. So if you have any ideas of particular indicators you would like to see then let us know. Provided that the data is open data and published at small area level, so below Local Authority level, we will load the data in for you.

Get in touch!

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

Data updates in Community Insight

Data updates this month include 1 new dataset and 113 updated!

The below table is a snapshot of some of the key datasets which have been updated. To see a full breakdown of all datasets updated this month see our knowledge base article containing a list of all the datasets available in Community Insight.

The indicators in the below table are now updated and live in all Community Insight sites (England, Scotland and Wales)

Indicators on Source Reports Maps
Unemployment benefit (JSA and Universal Credit) Department for Work and Pensions (DWP) Yes Yes
Attendance Allowance claimants Department for Work and Pensions (DWP) No Yes
Incapacity Benefit claimants Department for Work and Pensions (DWP) Some Yes
Pensioners in poverty (Pension Credit) Department for Work and Pensions (DWP) Yes Yes
Disability benefit (DLA) Department for Work and Pensions (DWP) Some Yes
Employment and Support Allowance claimants Department for Work and Pensions (DWP) No Yes
All VAT based local units Office for National Statistics (ONS) Yes Yes

 

The indicators in the below table are new indicators and are now live in Community Insight England and Wales only

Indicator Source Reports Maps
Live births Office for National Statistics (ONS) No Yes

 

The indicators in the below table are new indicators and are now live in Community Insight Scotland

Indicators on Source Reports Maps
All VAT based local units Office for National Statistics (ONS) Yes Yes

 

Current indicators within Community Insight

To see a list of all of the current indicators available in Community Insight check out this knowledge base article containing a list of all the datasets available in Community Insight

Update your reports to fix data error

Please note, we would like to make users aware of an error with the data rate values for the following indicators:

  • All crimes (annual)
  • Violent crimes
  • Criminal damage
  • Burglaries
  • Robberies
  • Vehicle crimes

This error affects all reports generated between 9th April 2018 and 2nd August 2018. To regenerate the reports and amend the issue, simply request a new report for that stock group.

For advice on updating reports when new data is released, please see our article on Updating Your Reports. 

We take data quality and accuracy very seriously and apologise for any inconvenience caused. In order to prevent this type of issue from occurring in the future, we have added additional manual report checks when adding new or updated indicators in the tool. This is in addition to the comprehensive automated and manual testing we already run as part of the data import process. For more information on the full QA process for data added into the tool, please see our articles on The Quality Assurance Process For Data In Community Insight.

Want to see more indicators within Community Insight?

We are always looking to add new indicators to Community Insight. So if you have any ideas of particular indicators you would like to see then let us know. Provided that the data is open data and published at small area level, so below Local Authority level, we will load the data in for you.

Get in touch!

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