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 (if you are a Community Insight Wales or Scotland user, these updates will be coming soon):

  • 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 [email protected] 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 (if you are a Community Insight Scotland user, these updates will be coming soon).

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.

Data updates in Community Insight

October has been a busy month for! We have updated a number of the standard datasets in Community Insight. The monthly data updates include indicators from the Office for National Statistics (ONS), Hospital Episode Statistics, Business Register and Employment Survey (BRES) and Department for Work and Pensions (DWP).

What’s been updated?

Data on employment type and the proportion of employees per industry sector from the Business Register and Employment Survey (BRES)
Highlights include:

  • Full-time employee jobs
  • Part-time employee jobs
  • Public sector employee jobs
  • Private sector employee jobs
  • Jobs in agriculture, forestry and fishing
  • Jobs in arts, entertainment, recreation and other services
  • Jobs in business administration and support services
  • Jobs in construction
  • Jobs in education

Monthly unemployment benefit data from The Department for Work and Pensions (DWP) Highlights include: 

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

Please note, in accordance with the changes made by the Department of Work and Pensions relating to Universal Credit, the unemployment benefit gender breakdowns (male and female) now include both JSA and Universal Credit. The indicators are now called:

  • Unemployment benefit (JSA and Universal Credit), male
  • Unemployment benefit (JSA and Universal Credit), female

Please note, the following indicators are not available for Community Insight Scotland or Comunity Insight Wales users:

Data on causes of death from the Office for National Statistics (ONS). Datasets included are:

  • Low birth weight
  • Cancer incidence
  • Deaths from cancer
  • Deaths (all causes)
  • Deaths all ages, coronary heart disease (CHD)
  • Deaths all ages, circulatory disease
  • Deaths all ages, respiratory disease
  • Deaths all ages, stroke

This data is broken down further with indicators showing the causes of deaths of under 75s and under 65s, and covering different types of cancer incidence. This data now covers the time period of 2011-2015.

Data on elective and emergency hospital admissions from the Hospital Episode Statistics. Datasets include:

  • Emergency hospital admissions, Myocardial Infarction
  • Emergency hospital admissions, Stroke
  • Hospital stays for intentional self harm
  • Hospital admissions for alcohol attributable harm

Indicators available in Community Insight

To see a list of all of the indicators 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.

New and updated data in Community Insight reports

 

Hopefully by now you are already well acquainted with the reports in Community Insight. Within the reports you will have noticed data visualisations and charts comparing your custom area to two other areas.  Since our announcement last week, where we added new Community Dynamics data into our tool, we’ve been working hard to show those indicators in our area profile reports. But we didn’t want to leave it there – so, we have also added data on housing affordability to the reports too – enjoy!

New indicators

Under the heading ‘Communities and environment: Neighbourhood Satisfaction and Local Participation’, you will be able to see the following data:

  • Local social relationships
  • Belonging
  • Satisfaction with local area as a place to live

Neighbourhood Satisfaction

On a separate page as part of the ‘Housing: How affordable is local housing?’  (released back in April) section you will be able to see

  • Housing affordability gap
  • Savings ratio
  • Total affordability ratio

How Affordable is Local Housing

Please note: data on housing affordability is not available for Community Insight Scotland

Updated data

In addition to the new data, all other data is now up-to-date within the reports.

Update your reports

To see the latest 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 the Knowledge Base.

 

For more information take a look at our blogs on

 

New Community Dynamics data and regular updates in Community Insight

 

This month we have added some new datasets on Community Dynamics to Community Insight. The datasets use modeled data from the annual Community Life Survey and can be used to help predict how people are likely to feel about the areas they live in.

Alongside this new data we have updated a range of indicators covering various themes such as housing, crime, travel time to key services and unemployment.

 

New Community Dynamics Data

The Community Dynamics data has been constructed by Social Life; an organisation specialising in research and community projects exploring how people are affected by changes in the built environment. The datasets use modeled data from the annual Community Life Survey and Understanding Society Survey to map this data to Output Areas.

The datasets are presented indexed against the country within Community Insight, where a positive score (greater than zero) indicates that an area is performing better than the national average and a negative score (below zero) indicates an area is performing worse than the national average. The datasets available in Local Insight are:

  • Local social relationships: average score
  • Belonging: average score
  • Satisfaction with local area as a place to live: average score

Check out our blog for more on how these could be used to help design and deliver local services.

Explore these new indicators in Community Insight 

To find these new indicators in Community Insight:

If you have used the Manage Indicators feature before:

  • Click on the Group Admin tab and go onto the Manage Indicators page. The indicators will be in the Unassigned theme.

If you have not used the Manage Indicators feature before:

  • The indicators will be available on the map as default, within the Community and Environment theme.
  • If you would like to remove these from the map or edit which theme they appear in, you can do this using the Manage Indicators feature.

If you need a reminder of how to add new indicators to your maps and dashboards, check out this article in our Knowledge Base.

 

Updated Datasets

The following indicators, from the below publishers, are not available for Community Insight Wales:

  • The Deparment for Energy and Climate Change

The following indicators, from the below publishers, are not available for Community Insight Scotland:

  • Department for Transport (DfT)
  • Land Registry
  • Police UK (Police recorded crime figures)
  • Department for Energy and Climate Change (DECC)
  • Valuation Office Agency (VOA)

Unfortunately these datasets are not published by the source for Scotland and Wales. If you are aware of similar dataset covering Scotland and/or Wales, please let us know.

 

Housing

some of the (wales doesn’t have travel time core updates, fuel poverty, not connected to gas)

We have updated the Land Registry data on average house prices. This is also broken down by housing type, for example:

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

We have updated The Valuation Office Agency (VOA) data on Dwelling stock by council tax band and build period. For example, 

  • Dwelling stock built before 1900
  • Dwelling Stock by Council Tax Band – Band A

We have updated The Department for Energy and Climate Change data. The indicators are:

  • Households not connected to the gas network
  • Households in Fuel Poverty

 

Travel time to key services

Travel time data from the Department of Transport. Highlights include:

  • Travel time to nearest employment centre by public transport/walk
  • Travel time to nearest Further Education Institution by public transport/walk
  • Travel time to nearest GP by public transport/walk

 

Crime Data

We have updated all Police UK data . Highlights include:

  • Anti-social behaviour
  • Bicycle theft offences
  • Burglary

 

Unemployment Data

Monthly unemployment benefit data. Highlights include: 

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

 

View a list of 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 and a full list of the new updates check out this Knowledge Base article.

If you have any questions, 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

It has been a busy month for data updates in Community Insight! For those of you interested in data on local business units, we have just updated 31 datasets from the Office of National Statistics. Alongside these, we have also updated the regular monthly and quarterly datasets from the Department of Work and Pensions (DWP). There is also news about some discontinued datasets from the Department of Work and Pensions.

What’s been updated?

Business units data from the Office of National (ONS) statistics. Highlights include:

  • VAT based local units in a range of industries, for example:
    • Construction
    • Education
    • Health
    • Motor trades

To see the full list of updated indicators from the ONS check out this Knowledge Base article

Please note, if you are a member of Community Insight Scotland, the business units data is not available on the site.

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
  • State Pension total claimants

Listed above are the headline indicators from the Department of Work and Pensions. There are also age and gender breakdowns available for the above. To find those indicators simply search the unassigned theme. For guidance on how to select your themes and indicators, check out this section on our Knowledge Base.

Updates coming next month

Next month is an equally busy month for data updates. We are rolling the Land Registry and Police UK updates into the September data updates. So keep an eye on the news blog for more information.

Discontinued datasets

Working age client group datasets discontinued

The Department for Work and Pensions (DWP) are changing the way that they publish benefit statistics from August 2017. The quarterly working age client group datasets will no longer be produced by DWP and will therefore no longer be updated within Community Insight. For more information see here. When the DWP replace these datasets with new indicators we will load them into Community Insight.

For now, the working age client group datasets will remain in Community Insight showing the data for the most recent time-point available. A list of the discontinued datasets in Community Insight is below:

  • Working-age DWP benefit claimants aged 16-24
  • Working-age DWP benefit claimants aged 25-49
  • Working-age DWP benefit claimants aged 50 and over
  • Working-age DWP benefit claimants, Bereaved
  • Working-age DWP benefit claimants, Carer
  • Working-age DWP benefit claimants, Disabled
  • Working-age DWP benefit claimants, female
  • Working-age DWP benefit claimants, Incapacity Benefits
  • Working-age DWP benefit claimants, Income Related Benefit
  • Working-age DWP benefit claimants, Job Seeker
  • Working-age DWP benefit claimants, Lone Parent
  • Working-age DWP benefit claimants, male

Indicators available on Community Insight

To see a list of all of the indicators 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.

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.