Data Updates in Local Insight

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

New metadata calculations

At Local 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 Local 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

This is modelled, local level (MSOA) data that helps Local Authorities 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+

This 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 Local 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 Local 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 updates

There are also a number of regular datasets that have been updated in Local 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 Local Insight. This updated data will be live by the end of next week.

Current indicators available within Local Insight

Current indicators available within Local 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 [email protected] 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 Local Insight. We are looking forward to what 2018 will bring!

 

Data updates in Local 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
  • Broadband speed

Please note: 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 a proportion of postcodes with slow internet.

Greenspaces data in Local 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 Local Insight and what’s included in the data, see our blog post here.

Current indicators available within Local Insight

To see a list of all of the current indicators available in Local 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 [email protected] or give us a call on 01273 810270.

 

Greenspaces data in Local Insight

New greenspace datasets

Data on greenspaces has now been added to our Local 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 Local Insight. For more information on how we converted this data check out our blog.

How do I access the data on Local Insight?

There are two greenspaces indicators available on Local 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 Local Insight

To see a list of all of the current indicators available in Local 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 [email protected] or give us a call on 01273 810270.

 

 

Data updates in Local 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

In case you missed it: Mid-Year Population Estimates

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 Local Insight

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

 

Mid Year Estimate Update in Local Insight

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

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 Local Insight

October has been a busy month for Local Insight! Last week we released some brand new functionality to allow you to upload more of your own data into Local Insight. Read more about that new functionality here.

We have also updated a number of the standard datasets in Local 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

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 within Local Insight

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

Upload your data gets a makeover!

What’s new

In addition to the 800 preloaded datasets readily available in Local 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 Local 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 Local Insight, by opening up a wider pool of potential datasets you can upload.

This development was one of the top priorities from the Local Insight user group, and we are excited to see how you will use it in your work.

What can you do with this new functionality?

At OCSI we are data addicts and so where possible, we are always adding new and exciting datasets to Local Insight. However, there are three conditions indicators must meet in order to be loaded into Local 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 Local 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 Local Insight. These will be visible only to people with access to your account.

Local data

Many of our users are from Public Health teams across the country. These teams hold detailed local datasets on many health issues such as alcohol consumption, smoking prevalence and cessation. Much of this data is held at LSOA level. Using the new functionality this data can now be loaded into Local 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 custom areas 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 get a lot of requests to add Local Authority level data to Local Insight.  We do not load such datasets in as once the data is apportioned down to match custom areas 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:

  • EU Referendum results data (some data available at LA level)
  • Hate Crime
  • Domestic abuse
  • Young carers
  • Annual Population Survey

You can now load these datasets into Local Insight. If you want advice on how to do this please email [email protected] and watch out for our upcoming webinar on uploading data into Local Insight.

Private Data

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

How to use this new functionality?

In Local 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. 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).

Uploading your own data

To upload data into Local Insight you need to do two things:

  • Create the Metadata  
  • Upload the data.

Creating Metadata  

Metadata is the underlying information which describes the context of the dataset. What is it called? What source is it from? Which time period does it cover? At this stage you also  select the geographic level you are uploading data for.

Uploading the Data

Once the metadata is ready you can upload the raw data. To do this you will need a CSV file with two columns. The first column is for the area codes. For example, a list of postcodes, OA codes, LSOA codes, MSOA codes or LA codes. In the second column you will put the actual numerical data.

Have a look at the Knowledge Base for a step by step guide to uploading data in Local 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 suggested to us by our users

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 – hoorah!

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 round!

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.

 

loading page

Start uploading your own data

If you’ve never used the Upload your Data feature before, you may want to check out this section on our Knowledge Base first. However, for the data heroes that have uploaded data before, the new functionality is now live so jump right in.

Over the next couple of weeks we will be running some webinars on how to get most out of this new functionality. Keep an eye out for dates and times. For more information on the webinars and to be kept up to date on times and dates email [email protected].

Community

The Local Insight Community is a space to share ideas and best practice. So, whether you have big plans for how you will be uploading data – or are looking for a bit of inspiration, share your experiences over on the Community Forum.

New and updated data in Local Insight reports

 

Hopefully by now you are already well acquainted with the reports in Local 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

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 custom areas. To do this, 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 the Knowledge Base.

 

For more information take a look at our blogs on

 

New Community Dynamics data and regular updates in Local Insight

 

This month we have added some new datasets on Community Dynamics to Local 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 Local 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 Local Insight 

To find these new indicators in Local 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

Housing

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 Local 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.