Data updates in Community Insight

We have updated a number of indicators, published by the Department of Work and Pensions, in Community Insight. This includes the monthly unemployment benefit data and also data showing attendance allowance claimants.

What’s been updated?

Monthly unemployment benefit data. Highlights include: 

  • Unemployment benefit (JSA and Universal Credit)
  • Youth unemployment (18-24 receiving JSA or Universal Credit)

Quarterly Attendance Allowance datasets. These are broken down into further indicators based on gender and age groupings. The age groupings are as follows:

  • Attendance Allowance claimants aged 65-69
  • Attendance Allowance claimants aged 70-74
  • Attendance Allowance claimants aged 75-79
  • Attendance Allowance claimants aged 80-84
  • Attendance Allowance claimants aged 85-89
  • Attendance Allowance claimants aged 90+

Indicators available in Community Insight

To see a list of all of the indicators available in Community Insight England, Scotland and Wales check out this Knowledge Base article.

If you have any questions about the new data updates, please do not hesitate to get in touch with us on [email protected] or give us a call on 01273 810270.

Latest data updates in Community Insight

A roundup up of all the May updates in Community Insight

All of the monthly unemployment data from the Department for Work and Pensions has been updated in Community  Insight. Listed below are all the updated datasets:

  • Youth unemployment (18-24 receiving JSA and Universal Credit)
  • Unemployment benefit (JSA and Universal Credit)
  • Unemployment benefit
  • Jobseekers Allowance claimants, claiming for over 12 months
  • Jobseekers Allowance claimants, female
  • Jobseekers Allowance claimants, male

Please note: This data has been updated across all three Community Insight sites; England, Scotland and Wales.

Time to update your reports

To see this latest unemployment data in your reports you must generate new reports for your stock groups. To do this, simply click Request Report on the Manage Stock Groups page. For more information about the Reports in Community Insight, check out the Report section in our Knowledge Base.

Indicators available within Community Insight

To see a list of all of the indicators available in Community Insight check out this Knowledge Base article.

If you have any questions about the new data updates, please do not hesitate to get in touch with us on [email protected] or give us a call on 01273 810270.

Improving user experience: New updates in Community Insight

The development team here at OCSI are always working on a number of different projects. And looking for ways in which work from one project can be used to improve another and make your user experience even better. Today we are rolling out a collection of these improvements.

We noticed that people are creating more and more stock groups in Community Insight and it is great to see people making the most out of the stock groups feature! As a result we have adapted the way you can search for your stock groups, on the Map and on the Manage stock groups pages, to make it easier for you to find specific areas within a long list. We’ve also made some minor improvements to help people understand and effectively use the Dashboard.

What’s changed?

Maps page

Previously when you wanted to view a stock group on the map, you would click on the stock icon and select the stock group from the drop down box. We have now created a specific button for stock groups. This new button is called the Areas button and can be found nestled between the stock and settings buttons on the Map page. Click the Areas button and a list of all the stock groups on Community Insight with a filtering option appears.

Use the filtering box to type in the name of a particular stock group and then select that stock group to view on the map. Next to each stock group is a little information icon. Click on this icon to open up a popup detailing information about that stock group. Information includes; a list of stock within the area, how the stock group was created, when it was created, who created it and which constituent regions are contained within the area.

Click on the image to enlarge

Click on the image to enlarge

 

Manage stock groups page
If you are a group admin or power user who creates stock groups for your group, you will also see improvements on the Manage stock groups page. We have added a filter box so you can easily zoom to a stock group within a long list.

Ci new filter bar

Click on the image to enlarge

To refresh your knowledge on the different ways of creating stock groups in Community Insight, check out the stock groups section in the Knowledge Base.

 

Dashboard 

The Dashboard is a great way of visualising how your stock groups compare to one and another on multiple indicators. To ensure that everyone understand how the dashboard works and what it is showing, we have added a link to a detailed Knowledge Base article. Hover your cursor over the colour key in the top left hand corner to find the link to the Knowledge Base article.

If you haven’t used the Knowledge Base before, it is full of bite sized articles which help you get the most out of Community Insight. It can be found on the Support tab in the top right hand corner of Community Insight.

If you have any questions about the recent improvements to Community Insight then please contact us on [email protected]

Big Lottery data now available in Community Insight

We are always looking to add new datasets into Community Insight. So, we are really excited to announce that we have now added Big Lottery grant data to the tool. If you’ve ever bought a lottery ticket,  you can now use Community Insight to see where that money has been spent!

The Big Lottery data

We have added three datasets from the Big Lottery. The datasets span different time periods in order to provide both a snapshot of how recent grant funding has been spent whilst also allowing for the study of more longitudinal data.The datasets available are:

  • Big Lottery grant funding per head (£) 2004-2010
  • Big Lottery grant funding per head (£) 2004-2015
  • Big Lottery grant funding per head (£) 2011-2015

The data is published by the Big Lottery at Ward level and we have apportioned it down using population weighting at Output Area level to provide data for your custom areas. To find out more about the raw data see the Big Lottery website

Big Lottery grant funding per head (3) 2004-2015

Big Lottery grant funding per head (£) 2004-2015

Use the Big Lottery data to…

  • Explore how much Big Lottery grant funding your local areas receive compared to areas around the country
  • Question assumptions made about how grant money has been spent across the areas you work in.
  • Build up a picture of how grant funding has affected your communities over the past 13 years and see whether there are any areas which have received little to no funding.
  • Measure if there is a correlation between levels of grant funding and areas of deprivation.

Explore the new data in Community Insight

To find these new 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). If you need a reminder of how to add new indicators to your maps and dashboards, check out this article in our Knowledge Base.

To see a full list of all the datasets available in Community Insight check out this Knowledge Base article.

If you have any questions about these new indicators, please do not hesitate to get in touch with us on [email protected] or give us a call on 01273 810270.

May data updates and two new indicators on energy consumption!

This month we have added two new indicators on energy consumption to Community Insight. We have also updated all the monthly and quarterly datasets from the Department of Work and Pensions.

New Energy datasets

We have added:

  • Estimated total domestic gas consumption in megawatt hours (Mwh)
  • Estimated total domestic electricity consumption in megawatt hours (Mwh)

Both of these indicators are published by the Department for Business Innovation and Skills (BIS) and cover the calendar year of 2015. This is the latest small area level data published on gas and electricity consumption.

Data could be used for:

  • Targeting
  • Examining trends over time
  • Assessing the effectiveness of carbon reduction and energy efficiency policies and initiatives.

For more information see this fact sheet.

Explore the new indicators in Community Insight

To find these new 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. For further guidance, check out this article on our Knowledge Base about adding new indicators to the maps.

What’s been updated

Monthly unemployment benefit data. Highlights include: 

  • Jobseekers Allowance claimants
  • Unemployment benefit (JSA and Universal Credit)

Quarterly benefit data. Highlights include:

  • Attendance Allowance claimants
  • Disability benefit (DLA)
  • Disability Living Allowance claimants
  • Employment and Support Allowance claimants
  • Income support claimants
  • Incapacity benefit claimants
  • Working-age DWP benefit claimants

To see a list of all the datasets available in Community Insight and also a full list of the new updates check out this Knowledge Base article.

If you have any questions about these new indicators, please do not hesitate to get in touch with us on [email protected] or give us a call on 01273 810270.

Data updates in Community Insight

April was a busy month for data in Community Insight! We added 8 brand new indicators on housing affordability and updated key monthly and quarterly indicators. To read more about the new indicators check out our blog.

So What’s been updated?

All the monthly unemployment data from the Department for Work and Pensions has been updated in Community Insight. Listed below are all the updated datasets:

  • Youth unemployment (18-24 receiving JSA and Universal Credit)
  • Unemployment benefit (JSA and Universal Credit)
  • Unemployment benefit
  • Jobseekers Allowance claimants, claiming for over 12 months
  • Jobseekers Allowance claimants, female
  • Jobseekers Allowance claimants, male

All the Police UK data has been updated. Indicators include:

  • Anti-social behaviour
  • Bicycle theft offences
  • Burglary
  • Criminal damage
  • Drug crime offences
  • Other crime offences
  • Other theft offences
  • Possession of weapons offences
  • Public order offences
  • Robbery recorded offences
  • Shoplifting offences
  • Theft from the person offences
  • Vehicle crime
  • Violent crime and sexual offences

The Land Registry data has been updated to show the latest data on average house prices.

  • Average house price for detached houses
  • Average house price for flats
  • Average house price for semi-detached houses
  • Average house price for terraced houses

Indicators available within Community Insight

To see a list of all the datasets available in Community Insight check out this Knowledge Base article.

If you have never used the Knowledge Base before, have a look a around here. It can be found by clicking on the support button in the top right hand side of Community Insight. If you have a question about how to use Community Insight, more often than not, the answer can be found in one of the bite sized Knowledge Base articles. Use the search bar to look for specific questions or browse the different sections to learn more about how to get the most out of Community Insight.

 

Ci kb

 

If the Knowledge Base cannot answer your question or if you have a very specific question, please do not hesitate to get in touch with us on [email protected] or give us a call on 01273 810270.

A brand new suite of indicators on housing affordability

Housing affordability is a key issue affecting communities across the county.  Being able to understand housing affordability, accurately and at a local level is incredibly valuable. Therefore, we are really excited to announce that we have added a suite of new indicators on housing affordability in Community Insight.

The Research team here at OCSI have constructed the indicators through combining data from Land Registry Price Paid Data for December 2015 to November 2016 with small area estimated weekly income data from the ONS 2013/14. There are eight different indicators available on Community Insight. 

Indicators available

Housing affordability data for average house prices  (OA level)

We have produced four indicators around housing affordability for average house prices at Output Areas (OA level). The indicators were created by combining data from Land Registry Price Paid Data (December 2015 to November 2016) with small area estimated weekly income data from the ONS (2013/14). We have used data published at OA level, the smallest of the Census geographies, as this provides a very detailed picture at local level.The indicators available are:

  • Gap between average house prices and 4.5 times average annual salary
  • Housing affordability: Total price/salary ratio (average house)
  • Housing affordability: Savings/income ratio (average house)
  • Housing affordability: Savings required for 15% mortgage deposit and stamp duty for an average priced property

Housing affordability data for entry level properties (MSOA level)

We have also produced four indicators around housing affordability for entry level properties. Entry level properties are defined as house prices in the lower quartile for a particular local area for England and Wales. These indicators give a useful insight to the local picture for first time buyers, and can contribute to the overall picture of sustainable and good growth in a local area. Creating these indicators using underlying OA level data for the whole country, would be very tricky as it relies upon at least 4 entry level properties being sold within each output area. Instead for these indicators, we have used MSOA level Land Registry Price Paid data as the underlying data. The indicators available are:

  • Gap between average house prices and 4.5 times average annual salary
  • Housing affordability: Total price/salary ratio (entry level houses)
  • Housing affordability: Savings/income ratio (entry level houses)

  • Housing affordability: Savings required for 15% mortgage deposit and stamp duty for an entry level property

To learn more about the housing affordability indicators check out our blog on the OCSI website.

Housing affordability indicator on mpa blog

 

Explore these new indicators in your Community Insight 
To find these new indicators in your 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) or for the following keywords: gap, savings, affordability. If you need a reminder of how to add new indicators to your maps and dashboards, check out this article in our Knowledge Base.

Please note, in cases where we add new indicators which we believe to be of real interest to most users we will place the indicators directly into the default themes. This is the case for the below two Housing indicators. However, if you have already customised your themes and indicators all new indicators added will be within the Unassigned theme.

  • Savings required for 15% mortgage deposit and stamp duty (entry level houses)
  • Gap between house prices and 4.5 times average annual salary (entry level houses)

 

View a list of all the datasets available in Community Insight.
To see a list of all the datasets available in Community Insight and also a full list of the new updates check out this Knowledge Base article.

If you have any questions about these new indicators, please do not hesitate to get in touch with us on [email protected] or give us a call on 01273 810270.

Please note, the housing affordability indicators are not available for Community Insight Wales or Community Insight Scotland.

Creating stock groups just got even easier

Creating stock groups by drawing on a map is up there as one of the most used features in Community Insight. And although it was already pretty simple to create your local neighbourhoods and communities, we wanted to make it even easier.

We have added brand new functionality to make it quicker and easier to find the area you are talking about. When drawing a stock group on the map, you can now click on the Jump to Location button, enter a postcode or a place name and hey presto –  you will be re-centred to that area on the map.

 Li blog Jump to location button

 

To refresh your knowledge on the different ways of creating stock groups in Community Insight, check out the stock group section in the Knowledge Base.

If you have any questions or feedback, please get in touch with us on [email protected]

Data updates in Community Insight

A round up of the March data updates in Community Insight

All the unemployment data from the Department for Work and Pensions has been updated in Community Insight. Listed below are all the updated datasets:

  • Youth unemployment (18-24 receiving JSA)
  • Unemployment benefit (JSA and Universal Credit)
  • Unemployment benefit
  • Jobseekers Allowance claimants, claiming for over 12 months
  • Jobseekers Allowance claimants, female
  • Jobseekers Allowance claimants, male

Time to update your reports

To see this latest unemployment data in your reports you must generate new reports for your stock groups. To do this, simply click Request Report on the Manage Stock Groups page. For more information about the Reports in Community Insight, check out the Report section in our Knowledge Base.

New housing affordability indicator coming soon to Community Insight

We are excited to announce that we will soon be launching a housing affordability indicator in Community Insight. This indicator will be a composite measure based on house price and income data from the ONS.

A list of indicators available in Community Insight

To see a list of all the datasets available in Community Insight  check out this Knowledge Base article.

If you have any questions about the new data updates, please do not hesitate to get in touch with us on [email protected] or give us a call on 01273 810270.

More brand new indicators and data updates in Community Insight

As part of our monthly updates, we have updated the regular indicators and also added a few brand new ones too.

New indicators in Community Insight

Health

Teenage pregnancy
New data has been published on the total proportion of teenage mothers (under 18). This is the first time that this data has been available at small area level. The figure is calculated by taking the total number of maternal episodes for a mother aged between 12 and 17 years as a proportion of all maternal episodes. Data is sourced from Public Health England – Local Health Profiles.
Disability Free life expectancy
New data is has been published on Disability-free life expectancy (DFLE) for males and females. DFLE is the average number of years that an individual might expect to live free from a limiting persistent illness or disability in their lifetime.
Data is sourced from Public Health England – Local Health Profiles.

 

Economy

Income data 
Net weekly household income estimate (equivalised to take into account variations in household size) with breakdowns by income before and after housing costs. These figures are model-based estimates, taking the regional figures from the Family Resources Survey and modelling down to neighbourhood level based on characteristics of the neighbourhood obtained from census and administrative statistics. The most recent data is for 2013/14.

Jobs by part time/full time and industrial use case
New data on concentration of jobs by broad industrial use case and proportion of full time and part time jobs have been added to the system. Data is collected from the Business Register and Employment Survey (BRES).

 

Housing

Number of property transactions
This new indicator shows the number of property transactions over the last 12 months. This is broken down for all property types. Data is from the Land Registry.

new data on number of property transactions for Ci Feb 2017 data updates

Use these new indicators in your Community Insight 
To find these new indicators go to the Unassigned theme, on the Manage Indicators page, search for the following keywords: teenage, disability, income estimate, sector and property transactionIf you need a reminder of how to add new indicators to your maps and dashboards, check out this article in our Knowledge Base.

Some regular data updates

Alongside these brand new indicators, we have also updated the following indicators in Community Insight. Highlights include:

  • Crime indicators include crimes for 14 key offences (anti-social behaviour, burglary, bicycle theft, criminal damage, drugs, violent crime, vehicle crime, possession of weapons, public order offences, theft from a person, other theft, robbery, shoplifting, and other offences).  Data is available for the time period up until November 2016. Data is sourced from Police UK.
  • Benefit data including: Unemployment Benefit; with both JSA and Universal Credit broken down by age and gender. This data is published monthly and will reflect the time period of December 2016.

Do you have ideas for new indicators?
The idea for two of these new indicators came directly from Community Insight users. If you have some suggestions for new indicators, then let us know on [email protected]. Provided that the indicator is open data and available at LSOA level then we will add it in to Community Insight.

How can I view all the datasets available in Community Insight and a full list of the most recent updates?
To see a list of all the datasets available in Community Insight and also a full list of the new updates check out this Knowledge Base article.

If you have any questions about the new data updates, please do not hesitate to get in touch with us on [email protected] or give us a call on 01273 810270.