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.

Brand new Indicators and data updates in Community Insight

Our new years resolution for 2017 is to keep you better informed about new data and data updates, so you can get the most out of Community Insight.

New Indicators in Community Insight

New Data on local jobs

Community Insight now includes information on the local jobs market, allowing you to find which local areas have the highest concentrations of jobs. We have included headline measures of jobs density (jobs per working age population as well as breakdowns by industry of employment and public/private sector – with figures on full-time and part-time employment to be updated end of the month). Data is from the Business Register and Employment Survey (BRES) of approximately 80,000 businesses and weighted to represent all sectors of the UK economy.

New Data on life expectancy, healthy life expectancy and disability free years

A range of life expectancy indicators have been added or updated to the system including life expectancy at birth, healthy life expectancy (the average number of years that an individual might expect to live in “good” health in their lifetime) and disability-free life expectancy (the average number of years that an individual might expect to live free from a limiting persistent illness or disability in their lifetime). Figures are published by the Office for National Statistics (ONS).

 

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

Do you have ideas for new indicators?

New indicators like these often come directly from the feedback we get from our users. So 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.

Jobs in..... New BRES data

The Regular Data updates

Alongside these brand new indicators, we have also updated a range of key indicators in Community Insight. Highlights include:

  • Updated population estimates: Population estimates for 2015 (ONS mid year estimates) are now available at neighbourhood level providing up to date estimates of the local population by gender and age. Note, with the updates to the Mid Year Estimates we have also made adjustments to all of the indicators on Insight which use the MYEs as a denominator – including all DWP benefit datasets, business datasets and crime datasets hence the slight delay in publication of these.
  • Benefit data Department of Work and Pensions including:Unemployment Benefit (JSA and Universal Credit), Disability Living Allowance, Attendance Allowance and Pension Credit claimants
  • A range of Health indicators for 2010/11 to 2014/15,  including incidence ratios, mortality ratios, hospital admissions ratios from key health causes

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.

Time to update your reports

With all these brilliant new data updates, now would be a great time to update your reports. To update your reports, simply click Request Report on the Manage Custom areas page. For more information about the Reports in Community Insight check out the Report section in our Knowledge Base.

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.

Data updates in Community Insight

We have updated a whole bunch of indicators on Community Insight (184 to be precise!). Alongside the usual monthly updates we now also have the latest mid-year population estimates for 2015.

Highlights  

  • The mid-year population estimates produced by the Office for National Statistics. This is broken down into smaller indicators by age and gender. This data has also been used to revise other indicators within Community Insight such as:
    • Data on business units published by the Office of National Statistics
    • Police recorded crime figures published by Police UK

Alongside those updates are the usual updates, highlights include;

  • Benefit data Department of Work and Pensions, including:
    • Unemployment Benefit (JSA and Universal Credit)
    • Disability Living Allowance
    • Attendance Allowance
    • Pension Credit claimants

If you would like the full list of updated indicators within Community Insight, drop us a line on [email protected] and we will send it over to you.

Reports 

Please note. Whilst the data is all updated within Community Insight, on the maps, dashboard, data for your areas popup etc. The updated data is not yet available within the reports. Therefore, please hold off on updating your reports for now. The data will be available within the reports by early next week and we will let you know.

Community Insight top tip 

If you are unsure about the date period for which an indicator refers to, what the source of the dataset is or when the next publication date is, then remember you can check the metadata. To do this in Community Insight, start by selecting to view a dataset on the map, click on the Info button and then click About the Indicator.  See the image below for more information.

Click on the image to make it larger

Click on the image to make it larger

As ever, 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 cal on 01273 810270

 

Add your own custom datasets to the dashboard.

Our most recent development to Community Insight allows you to add your own datasets, created through Upload Your Data, to the dashboard. This means you are now able to see how your areas fare according to your own locally held data.

Additionally, it means you are able to view and compare your own datasets to the standard indicators pre-loaded into Community Insight. This gives you another way of identifying patterns and trends between the data your organisation holds, and the range of open data available in Community Insight.

bigger Li blog post db pic

 

This is something a lot of users were keen to see and we’re excited to see how people use this new feature in their daily work.

You can add your own datasets to the dashboard in the same way that you would add standard indicators to the dashboard. Take a look at this Knowledge Base article on how to add your custom datasets to the dashboard.

As well as extending the functionality, we have also made some aesthetic tidies to the dashboard too.

Reports

The eagle eyed amongst you may have spotted we have removed the “Reports” icon from left-hand side of the map. You can still view all of you reports using the “Reports and data” tab at the top of the page. Removing the icon from the map has improved site loading times considerably – we hope that you can see the difference!

If you have any questions or would like any advice on adding your custom datasets to the dashboard, get in touch on [email protected]

2016 Scottish Index of Multiple Deprivation on Community Insight Scotland

In case you haven’t already spotted it, Community Insight Scotland now has the 2016 Scottish Index of Multiple Deprivation (SIMD) data for you to use. As with all other indicators on Community Insight Scotland, you will be able to view the data on the map, view data for your specific areas and compare on the dashboard.

Released by The Scottish Government, The Scottish Index of Multiple Deprivation (SIMD) combines seven different domains (aspects) of deprivation: Income; Employment; Health; Education, Skills and Training; Geographic Access to Services; Crime; Housing. Within Community Insight Scotland, you can view data for both the overall rank and for each of the individual domains.

scotland-2016-imd-picture-for-blog

Where to find The Scottish Index of Multiple Deprivation in Community Insight?

For the majority of you the SIMD 2016 data can be found with the Deprivation theme on the maps page. However, if you have customised your themes and indicators and do not use the Deprivation theme, then the new SIMD 2016 indicators can be found in the Unassigned theme To add these new indicators on the map, you must go to the Manage Indicators page and move the indicators into a theme. For guidance on how to do this check out this short video.

Find out more

Learn more about the Scottish Index of Multiple Deprivation on the Scottish Government website 

If you have any questions about using the SIMD, then give us an email on [email protected] or call us on  01273 810270.

Latest data updates for Community Insight

We know that having the latest data for your local areas is important and so we keep all the datasets in Community Insight up to date for you. Here is a summary of the most recent data updates in Community Insight.

Unemployment benefits data from the Department of Work and Pensions  (August 2016) This includes: 

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

whole range of Benefit data from the Department of Work and Pensions has also been released (February 2016), 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

These headline datasets are also broken down into further more detailed datasets defined by gender, age and other factors. You can find all these indicators in the Unassigned theme using the Manage Indicators feature. For more information on using this feature see this article.

National Insurance numbers issued to non-UK nationals 2015/2016 (The data is from the period of March 2015 to March 2016)

This dataset from the department of Work and Pensions shows, the total number of people registering with a National Insurance number who have come from overseas. This is a measure of the number of people who have migrated to the UK from overseas to work, who have moved into the local area.

If you would like to see a full list of the data updates in Community Insight then send us an email on [email protected]

Reports 

Please note, we would like to make users aware of a slight error with one indicator within the reports. This error was isolated to the Vehicle crime data on page 29, Crime and safety: Recorded crime (1). 

The Vehicle crime data generated for your stock groups was correct, however the per 1,000 of the population and England average figures were incorrect. Once spotted this error was fixed immediately and quality control checks were done across the reports.

This error affects all reports generated between 2016-06-20 and 2016-08-19. To regenerate the reports and amend the issue simply generate a new report for that stock group.

For advice on updating reports when new data is released check out this article. 

 

Delete stock group categories

New functionality

We have added a new improvement to the Manage Stock Groups page. You can now delete stock group categories – hoorah!

Ci Delete stock group categories button

Using stock group categories

The categories feature is used by many users to organise stock groups. For those of you with hundreds of stock groups, this feature helps keep Community Insight manageable and organised.

We receive lots of positive feedback from you about stock group categories. Now that you are able to delete categories, we hope you’ll find them even more useful. Have a go experimenting with some new ways to use stock group categories. For example, use temporary categories for particular projects. Then when you are done, simply delete the category.

The categories and the order of the stock groups within your categories affects how your stock groups are displayed on the dashboard, the data for your areas popup and under the stock icon on the maps page. Do you have any key groups you are always using? Why not move them to a category at the top so you can always find them. 

Please note. You cannot delete categories which contain stock groups. To delete these categories you must first delete or move any stock groups within them.

Learn more 

To learn more about using categories to organise your stock groups, check out this article on our Knowledge Base: