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.

Data updates in Community Insight

We have a number of updates from the DWP, the DECC and the DfT. See the tables below for a snapshot of the highlights in the different national sites. Or take a look at the full list of updated indicators for your national site on our Knowledge Base article.

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

Indicator 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

 

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

Indicator Source Reports Maps
Lower quartile house price House Price Statistics for Small Areas (HPSSAs): Office for National Statistics, HM Land Registry No Yes
Median house price House Price Statistics for Small Areas (HPSSAs): Office for National Statistics, HM Land Registry No Yes

 

Explore these new house price indicators in Community Insight
To find the two new house price indicators in Community Insight click on the Group Admin tab and go onto the Manage Indicators page, search within the Unassigned theme for the full names of the indicators (see above). Then in order to view these new indicators on the map or dashboard you must add them to a theme and select them to be shown on the map. If you need a reminder of how to add new indicators to your maps and dashboards, check out this article in our Knowledge Base.

 

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

Indicator Source Reports Maps
Households in Fuel Poverty Department for Energy and Climate Change Yes Yes
Travel time to nearest service by public transport/walk, broken down by service type Department for Transport (DfT) 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.

Take better screenshots in Community Insight with new Display Mode functionality

Visualising datasets on the maps in Community Insight overlaid with your stock groups and stock is one of the core uses of the tool. We receive a lot of feedback that including images of the maps in reports, grant applications and presentations is a real benefit in being able to communicate a story with data.

To create these images, we always recommend that you use Snipping Tool (or Grab if you are a Mac user).

However, we are aware that it can sometimes be a fiddly and cumbersome task to get the image that you want – without including all the icons and site headers.

To help tackle this, we are excited to release new functionality that allows you to see your map full-screen, with all the screen furniture removed. This makes it far simpler to get that perfect screenshot, and you are able to see more of the maps at once – hoorah!

Who can use this Functionality?

Any user of Community Insight, whether you are a View Reports User, Power User or Group Admin can benefit from the Display Mode functionality.

ci - 4 as a jpeg

How does it work?

When you navigate to the Maps page, you will now see a Display button in the top right. Clicking on this will remove all screen furniture so that you can see the map in full.

Any area or stock icons that you have loaded on the screen before pressing the Display button will be shown when viewing in Display Mode.

You can still interact with the screen, so you can zoom in or zoom out and position the image exactly as you like.

From here, you can now take your screenshot, either using Print Screen or the Snipping Tool.

To return to view maps as normal, simply hit Escape on your keyboard.

It works when viewing data too

You can also use Display Mode when you view datasets on the map. Simply select a dataset from the Data icon and hit the Display button.

The legend will be displayed on the map in the top right-hand corner and all the remaining screen furniture will be removed.

Full guidance and feedback

For more information on using the Display Mode, please read through the Knowledge Base. 

If you have any thoughts & feedback on this new functionality, we would love to hear it! Your feedback helps us improve Community Insight, to ensure that it’s meeting all your needs while keeping the tool intuitive and accessible by all.

You can get in touch with the Support Team on support@ocsi.co.uk or on 01273 810270.

Upload your data gets a makeover!

What’s new?

In addition to the 800+ preloaded datasets readily available in Community Insight, you can also add in your own organisational datasets. Up until now, this has been restricted to postcode level data.

However, we know that you collect and hold data at a number of other geographic levels and have added functionality so that you can quickly and easily add your own data into Community Insight for a range of geographies.

You can now upload datasets held at output area (OA), lower layer super output area (LSOA), middle layer super output area (MSOA) and Local Authority area (LA) level, as well as postcodes. This gives you more freedom to customise and curate Community Insight, by opening up a wider pool of potential datasets you can upload.

Please note: Community Insight Scotland users will use Data Zones, Intermediate Geographies and Districts instead of LSOAs, MSOAs and LAs.

 

What can you do with this new functionality?

Why any geography?

At OCSI we are always adding new and exciting datasets to Community Insight, which are available for everyone to use. However, there are three conditions indicators must meet in order to be loaded into Community Insight. The datasets must :

  • Have national coverage
  • Be available at small area level
  • Be open data

The new functionality provides you will the ability to load in any dataset to Community Insight. Therefore, if you have data which covers your local areas only, data only available at Local Authority level or private purchased data you can now load these indicators into Community Insight. These will be visible only to people with access to your account.

Local data

For example, your organisation may hold data related to patches within neighbourhoods, such as arrears or complaints. This data might be published at smaller OA levels. Using the new functionality this data can now be loaded into Community Insight. Once loaded into the tool, you could:

  • Visualise the data on the map to identify hotspot areas
  • Use the Dashboard to see how your stock groups compare on local datasets
  • Use the Dashboard to compare this local data with the standard national datasets to see if the local picture matches the national picture.

Local Authority level data

We often receive requests to add Local Authority level data to Community Insight. We do not load such datasets in as once the data is apportioned down to match stock groups it is no longer an accurate representation for that local area.

However, you can now add your own Local Authority data to view on the maps if you so wish. We have also set a threshold on the zoom feature so that you can only visualise the data on the map at LA level, if you try to scroll in further to see the data at MSOA or LSOA level, it will not change.

Below are some examples of LA level datasets that have been requested before:

  • Fly tipping data
  • Amount of grant money given
  • Social mobility
  • Indicators from the London Data Store, such as sport participation

You can now load these datasets into Community Insight.

Private Data

If your organisation has purchased or licensed private data this can also now be loaded into Community Insight (As long as your license agreement allows for the use of the data in this way).

 

How to use this new functionality?

In Community Insight you have always been able to upload your own data at postcode level using the Manage your Data feature on the Group Admin drop-down menu item. This new development has built upon and extended that feature to allow you to load in your organisation’s data at standard area level: OA, LSOA, MSOA or Local Authority (LA).

Have a look at the Knowledge Base for a step by step guide to uploading data in Community Insight.

What codes can you upload?

Upload your Data uses standard area codes and accepts both 2001 and 2011 LSOA codes. Take a look at the Knowledge Base for more information on the format to upload data in. If you use different formats for your data and want to know if they are compatible with the upload your data tool, please get in touch and we can talk this through with you.

 

More improvements to Upload Your Data

As part of the development work for this project, we added some tweaks and tidies

Edit metadata

You can now edit some of the metadata for your datasets. This applies to the parts of metadata that are purely aesthetic (e.g. the description, name of the indicator, text on the legend). So now if you spot a typo or receive feedback on your metadata, you can easily change this!

Please note: You will not be able to change the parts of the metadata that affect the way that data is aggregated (e.g. choosing whether the data is summed or averaged), so take care in ensuring that you pick the right option the first time around!

Feedback on upload results

We have made improvements to the user experience once you have uploaded your data. When you click the final “import” button, you will now see a pop-up indicating that the upload is working.

 

Let us know!

Any feedback on the process would be greatly appreciated. Do let us know at support if you have any questions.

Quarterly data updates from Land Registry and Department of Work and Pensions

Updated indicators

We have updated a range of quarterly published indicators in Community Insight. See the tables below for a snapshot of the highlights in the different national sites. Or take a look at the full list of updated indicators for your national site on our Knowledge Base article.

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

Indicator Source Reports Maps
Older people social care benefit (Attendance Allowance) DWP Yes Yes
Attendance Allowance claimants, Higher Rate award DWP No Yes
Attendance Allowance claimants, Lower Rate award DWP No Yes
Attendance Allowance claimants aged 65-69 DWP No Yes
Attendance Allowance claimants, female DWP No Yes

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

Indicator Source Reports Maps
Average house price Land Registry Yes Yes
Average house price for terraced houses Land Registry Yes Yes
Average house price for flats Land Registry Yes Yes

The indicator in the below table is now updated and live in Community Insight England only

Indicator Source Reports Maps
Number of property transactions Land Registry Yes Yes

Quarterly police UK updates

The crime indicators, published quarterly by Police UK, have been published a little later than usual this round. As a result, they will be updated in the next round of regular data updates which will be live in Community Insight mid month.

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.