Data updates in Community Insight

As promised, our second round of data updates 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 indicators added and updated this month, see our knowledge base article containing a list of all the datasets available in Community Insight.

New Indicators For Wales and Scotland

The below indicators have now been added or updated for the following sites:

Indicators for Source Reports England Wales Scotland
Children in poverty HM Revenue and Customs/Department for Work and Pensions (DWP) Yes Yes Yes New
Average consumption of domestic gas (per household) Department for Business, Energy and Industrial Strategy No Yes New No

Updated indicators

Indicators for Source Reports England Wales Scotland
Average house price Land Registry Yes Yes No Yes
Number of property transactions Land Registry Yes No Yes Yes
Crime and theft offences Police UK (Police recorded crime figures) Yes Yes No No
Children in poverty HM Revenue and Customs/Department for Work and Pensions (DWP) No Yes Yes Yes
Children in families receiving support HM Revenue and Customs (HMRC) No Yes Yes Yes
Average consumption of domestic gas (per household) Department for Business, Energy and Industrial Strategy No Yes Yes No
Households not connected to the gas network Department for Business, Energy and Industrial Strategy Yes No Yes No

Current indicators available within Community Insight

To see a list of all of the current indicators available in Community Insight England, Scotland and Wales 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.

 

Stock group boundary changes in Community Insight

We are always looking for ways to improve our tool, and a big part of what informs this is gathering feedback. One example of this is how we’ve heard from our users that they’d like the way stock groups are shown on the map to be more intuitive.

Well, we’ve taken that feedback on board and we’re making some important changes to how you view areas on the map.

What does this mean for me?

From now on, if you create a stock group using draw on the map or from a standard area, when displayed on the map:

  • The area will be outlined in black
  • The area will remain clear (and not filled in with a light grey colour)
  • You will be able to hover over or select LSOAs within your area

     

We’d love to hear from you!

If you have any questions about the new 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 we will have two data updates for you, with more coming at the end of the month. For now, we have updates from the Department for Work and Pensions (DWP):

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

New indicators in Community Insight Wales

Our Community Insight Wales customers will also receive two new indicators from the Welsh Index of Multiple Deprivation (WIMD), which are:

  • Repeat absences from primary school
  • Repeat absences from secondary school

Please note: The following indicators are not available for Community Insight England or Community Insight Scotland

Update your reports

Reports have been updated with the latest data. To see the latest data in your reports, you must generate new reports for your custom areas.

Current indicators available within Community Insight

Current indicators available within Community Insight. To see a list of all of the current indicators available in Community Insight and also a list of the most recent round of 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 support@ocsi.co.uk or give us a call on 01273 810270.

Data updates in Community Insight

As we get settled into the new year, we have plenty of data updates to get stuck into, with plenty from the Department for Work and Pensions (DWP), and several new indicators too:

New data

Data on your local housing market 

Please note: The following data is not available for Community Insight Scotland

We have added two new measure of the local housing market:

  • Inflation adjusted 10 year house price change by house type (using the CPIH index)
  • Ratio of residential transactions to number of private dwellings – a measure of housing ‘churn’

Take a look at our blog for more on how these datasets were constructed and some headline trends.

Percentage of children in poverty (after housing costs)

Please note: The following datasets are not available for Community Insight Scotland or Community Insight Wales

End Child Poverty has published new figures on the level of child poverty in each constituency, local authority and ward in the UK. The Centre for Research in Social Policy makes these annual estimates for the End Child Poverty Coalition, allowing them to map the percentage of children in poverty at small area level for a snapshot of time (July – September 2017).

Please note: This dataset is not directly comparable to the previous Children in Poverty dataset included within Community Insight. As such, we have kept both datasets available. The previous indicator is called Children in poverty. Take a look at our blog for more on how the data was constructed and caveats for use.

Please note: The following datasets are not available for Community Insight Scotland or Community Insight Wales

New health measures: We have added data from Imperial College London, taken from a longitudinal study on a number of health conditions including:

  • Percentage of people aged 45+ with (severe) hip osteoarthritis
  • Percentage of people aged 45+ with (severe) knee osteoarthritis
  • Percentage of people with (severe) back pain

To add these new datasets to your maps and dashboards, you will need to use the Manage Indicators feature. Search in the Unassigned theme for the datasets and drag & drop to the theme you wish to display them in. If you have any trouble, get in touch on support@ocsi.co.uk

Data Updates

In addition to the new data, as always, we have ensured everything else is up-to-date, so that you can be confident you are using the most recent data available.

Indicators include:

  • DWP Claimants data
    • Attendance allowance (broken down by age, gender and higher / lower rate award)
    • Disability living allowance (broken down by age, gender and higher / lower rate award)
    • Employment and support allowance (broken down by age, gender, higher / lower rate and reason for claiming)
    • Income Support (broken down by gender and living arrangements)
    • Incapacity Benefit (broken down by age and gender)
    • Pension credit claimants
    • Unemployment benefit (JSA & Universal Credit)
    • Youth Unemployment

Please note: The following updates are not available for Community Insight Scotland or for Community Insight Wales

  • Life expectancy
    • Female life expectancy at birth
    • Male life expectancy at birth

Please note: The following updates are not available for Community Insight Scotland or for Community Insight Wales

And finally, due to Sport England’s correction for the Active Lives data, we have temporarily removed the indicator People physically active (at least 150 minutes per week in the past month) from Community Insight. When Sport England republish the data, which will also include a more recent time point, we will add this back into the tool.

Update your reports

Reports have been updated with the latest data. To see the latest data in your reports, you must generate new reports for your custom areas.

Current indicators available within Community Insight

Current indicators available within Community Insight. To see a list of all of the current indicators available in Community Insight and also a list of the most recent round of 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 support@ocsi.co.uk or give us a call on 01273 810270.

Speed improvements

Our tech team have also been working away to improve overall site performance of Community Insight. The most recent updates have resulted in maps loading much faster with data – let us know if you have noticed any difference!

As always, if you have any questions at all on the data, please get in touch at support@ocsi.co.uk

Data updates in Community Insight

Happy 2018! With this new year comes brand new indicators, along with a number of updated indicators too.

New metadata Calculations

At Community Insight we’re continually developing our product, and we rely on input from our users. Some feedback we received from you was that you’d like to see more detailed metadata. Well, we’re pleased to say that we have updated our metadata structure so you can now see more clarity on the calculations used to derive the indicators.

For example, take the dataset ‘Unemployment benefit’. Previously you would have seen the description:

Shows the proportion of people receiving Jobseekers Allowance (JSA). JSA is payable to people under pensionable age who are out of work and available for, and actively seeking, work of at least 40 hours a week. Universal Credit data is not currently included in the counts.

We now have extra text to show the calculation, which in this case is:

Rate calculated as = (Jobseekers Allowance claimants (monthly))/(Population aged 16-64)*100

To see an indicator’s metadata, once the dataset is overlaid on the map click ‘info’ and then ‘about the indicator’. For more details see our help article, here.

New datasets

We’re always looking for new datasets to add into Community Insight that can support you in better understanding your communities. This month we’re very excited to bring you several new datasets!

Sport England have provided us with 3, courtesy of their Small Area Estimates survey:

  • People physically active (at least 150 minutes per week in the past month)
  • People not physically active (less than 30 mins activity in the past month)
  • Participation in physical activity at least twice in the last month

Please note:

  • Community Insight Scotland and Community Insight Wales will not have access to the Sport England indicators

This is modelled, local level (MSOA) data that can help you understand the diversity of participation in sport and other activities in their local area. Have a look at their overview of the survey and more information about the data modelling process, here.

We’ve also included some very interesting data on personal debt:

  • Mortgage debt per household
  • Personal debt (unsecured loans) per person aged 18+

The data is from UK Finance, who publish detailed figures for loan balances by postcode sector across mortgages, unsecured personal loans and SME loans. (We haven’t included SME data for now – but please let us know if this would be a useful addition!). In order to add personal debt to Community Insight, we have modelled the data to Output Areas, using apportioning based on population for personal debt data and number of households for mortgage debt data. For more information about how you might want to use these datasets, take a look at our blog post, here.

To add these new datasets to Community Insight, head to ‘group admin’, ‘manage indicators’ and then ‘unassigned’ to drag and drop the indicator into a theme. (If you have not customised your themes yet, click ‘start managing your indicators’, then head to unassigned). For more detail, see our knowledge base article on how to do this, here.

Data for your areas for Scotland

Data for your areas is now fully functioning for Community Insight Scotland. For details on how to use this feature, see our knowledge base article, here.

Data updates

There are also a number of datasets that have been updated in Community Insight:

  • Children and young people in out-of-work families (includes families claiming Universal Credit)
  • All crime datasets (we now use 12 month rolling average for maps and the dashboard as well the reports)

Updates to the monthly Department for Work and Pensions (DWP) data

The monthly data on unemployment from the DWP is being published a little later than usual this month. It will be published by the DWP early next week, we will then update it in Community Insight. This updated data will be live by the end of w/c 22nd January.

The reports will also reflect the above data updates by the end of w/c 22nd January.

Update (26/01/2018) The monthly data on unemployment from the DWP is now updated in Community Insight on the maps and reports.

Current indicators available within Community Insight

Current indicators available within Community Insight. To see a list of all of the current indicators available in Community Insight and also a list of the most recent round of 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 support@ocsi.co.uk or give us a call on 01273 810270.

Christmas holiday

Office closure

 

Image credit: https://www.pexels.com/photo/cold-snow-holiday-winter-40541/

Image credit: https://www.pexels.com/photo/cold-snow-holiday-winter-40541/

 

We hope you have a lovely break over the festive period! This is just to let you know that OCSI will be closed Thursday 21st December – Wednesday 2nd January. 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 Wednesday 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 2018 will bring!

 

Data updates in Community Insight

Monthly data updates

This month we have a number of updates from Land Registry, Police UK, Department for Work and Pensions and Ofcom, as well as updating the reports. Indicators included are:

  • Average house price, broken down by house type
  • Number of property transactions, broken down by house type
  • Incidents of crime, broken down by offence type
  • Recipients of unemployment benefit, broken down by age, time period and gender
  • Postcodes with low broadband speed

Please note:

  • Community Insight Scotland
    • Both broadband indicators are new indicators
    • Land Registry and Police UK indicators will not be updated (this includes Average house, Number of property transactions and Incidents of crime)
  • Community Insight Wales
    • Both broadband indicators are new indicators
  • The ‘Low broadband speed’ indicators differ slightly from the old indicator it replaces. The new indicators give a % of broadband connections that have speeds < 2Mbits/s. The old indicator gave proportion of postcodes with slow internet

Greenspaces data in Community Insight

We have also added two Greenspaces datasets this month: Greenspace coverage, total (this show the percentage of an area that is covered by green space) and Greenspace coverage, public parks and gardens (this shows the percentage of an area that is covered by public parks and gardens). For more information on use cases and how the data was put together see our blog postor for more information on how to view the data in Community Insight and what’s included in the data, see our blog post here.

Current indicators available within Community Insight

To see a list of all of the current indicators available in Community Insight, 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 support@ocsi.co.uk or give us a call on 01273 810270.

 

Greenspaces data in Community Insight

New greenspace datasets

Data on greenspaces has now been added to our Community Insight tool!

Where is the data from?

The data has been taken from Ordnance Survey’s Open Greenspace data. The data depicts the location and extent of spaces such as parks and sports facilities that are likely to be accessible to the public. 

The full technical specification and product guide are available online for the data heroes among us!

How do I understand the data?

We have taken the raw data and converted it into a format compatible with Community Insight. For more information on how we converted this data check out our blog.

How do I access the data on Community Insight?

There are two greenspaces indicators available on Community Insight:

  • Greenspace coverage, total
    • This show the percentage of an area that is covered by green space.
  • Greenspace coverage, public parks and gardens
    • This shows the percentage of an area that is covered by public parks and gardens.

 

Please note: The ‘Greenspace coverage, total’ definition includes allotments or community growing spaces, bowling greens, cemeteries, religious grounds, golf courses, other sports facilities, play spaces, playing fields, public parks or gardens and tennis courts. There are open spaces that aren’t covered under the greenspaces definition (for example, national parks), therefore large portions of the countryside may not be considered in this dataset.

 

To add these datasets to the map you will need to click on the Group Admin tab and go to the Manage Indicators page. The indicators can then be found in the ‘Unassigned’ theme. Then either create a new theme or drag and drop them into an existing theme. Don’t forget once you have moved them into a theme you need to tick the box to show on the map and/or dashboard.

Current indicators available within Community Insight

To see a list of all of the current indicators available in Community Insight, 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 support@ocsi.co.uk or give us a call on 01273 810270.

 

Data updates in Community Insight

Monthly data updates

This month the Department of Work and Pensions was our focus. The updates cover a wide range of indicators – some of the highlights include:

  • Unemployment benefit, broken down by JSA and Universal Credit and gender
  • Attendance Allowance claimants, broken down by age, gender, and Higher/Lower Rate award
  • Disability Living Allowance claimants, broken down by age, gender, Higher/Lower Rate Mobility award and level of Rate Care award
  • Employment and Support Allowance claimants, broken down by age, gender and disease
  • Incapacity Benefit claimants, broken down by age, gender and disease
  • Income Support claimants, broken down by age, gender, marital status and those in receipt of disability premium top-up
  • Pension credit claimants, broken down by gender, marital status and those in receipt of the Guarantee/Saving Element top-up

Mid Year Estimate update

The recent mid-year population estimates released by the ONS were a big data update, as population figures are used as denominators in many of the calculations. For more detail, such as which indicators were updated, see our blog post.

Current indicators available within Community Insight

To see a list of all of the current indicators available in Community Insight, 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 support@ocsi.co.uk or give us a call on 01273 810270.

 

Mid Year Estimate Update in Community Insight

The Office for National Statistics (ONS) recently released the 2016 Output Area level mid-year population estimates for England and Wales and Scotland.

As well as updating the population indicators themselves, this data update will affect the majority of indicators in Local Insight, as population figures are used as denominators in many of the calculations. To see these updates reflected in the reports you will need to update your reports individually.

To see a list of all indicators affected by this update, as well as the full list of indicators available in Local Insight, check out our Knowledge Base article.