ONS Population Estimate Revisions

ONS has made revisions to their mid-year population estimates for England and Wales from mid-2012 to mid-2016. For the vast majority of local authorities, these revisions have been very minor. However, for a small handful of authorities, the change is large enough to affect how decisions are made in the local area.

In order to take into account these changes, we have made revisions to all of the indicators in Local Insight which are derived from the ONS population estimates. This includes not just the population estimate figures themselves, but also any figure which uses the population estimates to calculate a rate e.g. Unemployment claimant count uses the working-age population from the ONS population estimates, combined with DWP data on counts of Universal Credit and Jobseekers Allowance claimants to calculate the unemployment rate. In total 196 of the 924 Indicators on Local Insight have been affected by the population revisions.

Click here for a full list of affected indicators.

Please note: there may be discrepancies between Local Authority and small area data

The revisions to the ONS population estimates have been released at Local Authority (LA) level only, with the population estimates for neighbourhood geographies (LSOAs, MSOAs, Output Areas etc.) still based on the unrevised estimates.

Revisions to the neighbourhood geographies are due to be published in Autumn 2018, but in the meantime, there will be inconsistencies between LA and MSOA/LSOA/Output Area data for the 196 indicators which are derived from ONS population estimates.

For example, the total population for all of the LSOAs in an LA will no longer add up to the total population of that LA as the LSOA data will be based on unrevised estimates and the LA data will be based on revised estimates. These inconsistencies could also potentially occur depending on whether your custom areas are built up from LSOA geographies or LA geographies.

Minimising the risk of misinterpretation

We have included health warnings for each of the affected indicators in the About the indicator pop-up and in the Introduction page of the report. These health warnings will remain in the metadata until the small area data is revised to be consistent with the LA data in Autumn 2018.

Out of 348 local authorities, only 28 have had their population estimate for mid-2016 revised by 1% or more; a minority of areas have seen notable changes to their overall population estimates. The population in one LA (Wandsworth) has been revised upwards by more than 5,000 people, while four LAs have been revised downwards by more than 5,000 people (Cambridge, Haringey, Oxford and Westminster).

Downward revisions have mostly resulted from higher emigration estimates for areas containing international students and lower immigration estimates for Inner London. For more details see ONS’ Revised population estimates for England and Wales: mid-2012 to mid-2016

Get in touch

If you require any further clarification, please don’t hesitate to get in touch with us at support@ocsi.co.uk or give us a call on 01273 810270.

Data Updates in Local Insight

A small number of updates this time, as there will be more coming at the end of the month.

Updated Indicators

Indicator Source Reports Maps
Youth unemployment (18-24 receiving JSA or Universal Credit) DWP Yes Yes
Claimant count age 50+ DWP Yes Yes
Unemployment benefit (JSA and Universal Credit) DWP Yes Yes
Jobseekers Allowance claimants, claiming for over 12 months DWP Yes Yes
Unemployment benefit (JSA and Universal Credit), female DWP Yes Yes
Unemployment benefit (JSA and Universal Credit), male DWP Yes Yes
Unemployment benefit DWP Yes Yes
National Insurance numbers issued to non-UK nationals DWP Yes Yes

ONS population estimate revisions

You may be aware that the ONS has revised their population estimates and published these at LA level. We are currently working on adding these revisions into Local Insight. There will be more information on this process and what it means for your data and areas over the next few weeks. We will mail out all users specifically about this.

Current indicators within Local Insight

To see a list of all of the current indicators available in Local Insight, check out this knowledge base article containing a list of all the datasets available in Local Insight

Want to see more indicators within Local Insight?

We are always looking to add new indicators to Local 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.

Data updates in Local Insight

Updated Indicators

This month we have updated 94 indicators across Local Insight! See the table below for a snapshot of the highlights or take a look at the full list of updated indicators on our Knowledge Base article.

Indicator Source Reports Maps
Mortgage debt per household UK Finance Yes Yes
Broadband speed Ofcom Yes Yes
Unemployment benefit (JSA and Universal Credit) Department for Work and Pensions (DWP) Yes Yes
Disability benefit (DLA) Department for Work and Pensions (DWP) Some Yes
Pensioners in poverty (Pension Credit) Department for Work and Pensions (DWP) Yes Yes
Income estimates Office for National Statistics (ONS) Some Yes
Employment and Support Allowance claimants Department for Work and Pensions (DWP) Some Yes
Income Support claimants Department for Work and Pensions (DWP) Some Yes
Housing Benefit Department for Work and Pensions (DWP) Yes Yes
Housing affordability ONS House Price Statistics for Small Areas Yes Yes

Changes to datasets

There have been changes to some datasets in addition to the data updates this month:

  • Housing affordability indicators have changed sources, from ‘Land Registry’ to ‘ONS House Price Statistics for Small Areas’ or ‘ONS Income Estimates; ONS House Price Statistics for Small Areas’
  • Income estimates are now expressed as annual income rather than weekly income because ONS now publish the statistics as annual estimates.
  • Housing affordability indicators’ methodology has been tweaked so it’s consistent with ONS

Current indicators within Local Insight

To see a list of all of the current indicators available in Local Insight check out this knowledge base article containing a list of all the datasets available in Local Insight

Want to see more indicators within Local Insight?

We are always looking to add new indicators to Local 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.

Report generation will be down on Tuesday 15th May 2018

We are getting in touch to let you know that due to circumstances outside of our control, our report generation server will be down on:

  • Tuesday 15th May; between 8am – 3pm.

What does this mean for you?

You will be able to use Local Insight as normal during this time. However, report generation will not work during this time.

Any reports that you request during the power outage, will be added to a report queue and will generate once the servers regain power.

To minimise inconvenience as a result of the power outage; we recommend:

  • You request any reports that you might need on Tuesday 15th May in advance
  • You avoid generating new reports during the power outage
  • You avoid generating new reports in the hour leading up to the power outage
  • You avoid using the Bulk Update Reports functionality on Monday 14th May & Tuesday 15th May.

We will monitor the report generation throughout the day, and once the power is back up and running, to ensure you receive reports as quickly as possible.

We will also send you an email to confirm that report generation is up and running on Tuesday afternoon.

We apologise for any inconvenience this might cause. If you would like to talk to one of the team about what this might mean for you – please get in touch on support@ocsi.co.uk

Data updates in Local Insight

A quick update for now, as we’ve only updated indicators from the Department for Work and Pensions (DWP).

Updated Indicators

Indicator Source Reports Maps
Youth unemployment (18-24 receiving JSA or Universal Credit) Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit (JSA and Universal Credit) Department for Work and Pensions (DWP) Yes Yes
Jobseekers Allowance claimants, claiming for over 12 months Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit (JSA and Universal Credit), female Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit (JSA and Universal Credit), male Department for Work and Pensions (DWP) Yes Yes
Unemployment benefit Department for Work and Pensions (DWP) Yes Yes

Current indicators within Local Insight

To see a list of all of the current indicators available in Local Insight check out this knowledge base article containing a list of all the datasets available in Local Insight

Want to see more indicators within Local Insight?

We are always looking to add new indicators to Local 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.

 

The shapefile importer is here!

 

We know this development was one of the top priorities from the Local Insight user group, so we’re excited to announce that you can now create custom areas by importing shapefiles!

What can you do with this new functionality?

Consider the situation where you have:

  • An area of interest stored away in another GIS platform but can’t recreate the area exactly in Local Insight
  • 100s of areas you would like to import into Local Insight, but know it would take considerable effort to import each area individually

Well, now you can solve both of these problems with the shapefile importer tool.

How to use this functionality

To import a shapefile you will need to:

  • Head to Group admin and then Manage custom areas
  • Alongside Add custom area and Add category you will find Import shapefile
  • Follow the onscreen instructions to make sure you’ve provided the right files and information
  • You’re ready to import!

Top tip: Your areas will all be added to the category ‘Uncategorised’, so we recommend moving any areas you have here already into another category.

Now, your new areas will magically appear in your list of custom areas!

See our shapefile importer documentation for a full description what’s needed and what to expect.

Let us know

Any feedback on the process would be greatly appreciated. Do let us know at support if you have any questions.

Happy importing!

 

 

Data updates in Local 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 datasets added and updated this month, see our knowledge base article containing a list of all the datasets available in Local Insight.

Updated indicators

Indicators on Source Reports Maps
Average house price Land Registry Yes Yes
Number of property transactions Land Registry Yes Yes
Anti-social behaviour Police UK (Police recorded crime figures) Yes Yes
Children in poverty HM Revenue and Customs/Department for Work and Pensions (DWP) Yes Yes
Children in families receiving Support HM Revenue and Customs (HMRC) Yes Yes
Average consumption of domestic gas (per household) Department for Business, Energy and Industrial Strategy Yes Yes
Households not connected to the gas network Department for Business, Energy and Industrial Strategy Yes Yes

 

Current indicators available within Local Insight

To see a list of all of the current indicators available in Local Insight check out this knowledge base article containing a list of all the datasets available in Local Insight

Want to see more indicators within Local Insight?

We are always looking to add new indicators to Local 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.
 

Custom area boundary changes for Local 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 custom areas 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 custom area 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 Local 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

We’ve added two new indicators from HM Revenue and Customs (HMRC)/Department for Work and Pensions (DWP):

  • Children (0-15) in out-of-work families (includes families claiming Universal Credit)
  • Children and young people (0-18) in out-of-work families (includes families claiming Universal Credit)

Feature indicators in the reports

For those of you who are interested in the feature indicators which we have been adding over the past year, here is a breakdown of where those indicators can be found in the reports.

  • 10 year percentage change in house price – Page 25
  • Ratio of residential property transactions to the number of private dwellings – Page 25
  • Housing affordability measures – Page 26
  • Domestic energy consumption – Page 28
  • Energy efficiency- Page 29
  • Musculoskeletal conditions (arthritis) – Page 38
  • Physical activity among adults – Page 40
  • Household debt – Page 45
  • Broadband – Page 53
  • Community dynamics measures – Page 56
  • Greenspace coverage – Page 58
  • Big Lottery funding – 59

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 support@ocsi.co.uk or give us a call on 01273 810270.

4 ways to encourage self service using Local Insight

Local Insight is designed to be easy to use and accessible by all – so that you don’t need to be a statistician to gain useful insights. Local Insight can help answer a lot of the day-to-day questions that people have about local statistics, freeing up the time of analysts to focus on the important stuff.

As a Local Insight subscription covers unlimited users, there is no reason why it shouldn’t be being used right across your organisation and beyond. However, it can only be used if people know it is there and know how to extract the information they need.

We have put together a few tips on promoting Local Insight within your organisation and beyond. If you have any tried and tested tactics to add, please let us know.

Some of the tips below refer specifically to public sites; however everything is possible using the standard Local Insight subscription (there may be a bit more overhead in these cases for setting up and managing users!). If you would like to know more about public sites, please get in touch.

For support and more information on any of the suggestions here, please get in touch on support@ocsi.co.uk

Find the data champions

Scouting out the individuals that are already sympathetic to the benefits of instant access to local data is a great place to start in increasing uptake of Local Insight.

Take the opportunity to ask lots of questions. What will be the most appealing part of Local Insight to their team? What custom areas and services would be most useful to add? What are the potential barriers to others using Local Insight?

Use this to help shape your approach when talking to new teams, and ask your ‘data champions’ if their experiences can be used as a case study.

In addition to your own organisational knowledge on potential data champions, do also look at your user logs in Local Insight, which could give you insight into your most active users. If you would like more information on who have been your most active users over the last 3 months, get in touch and we can provide some additional information for you.

Run mini training sessions

Offering mini lunchtime training sessions to specific services (for example; CVS, elected members or commissioners) is a great way to get the word out about Local Insight. In 30 minutes you can cover basic navigation of the tool, show people where they can access reports about their local areas and the breadth of data that is available.

Equally, scheduling regular “drop in” sessions for Local Insight related questions (whether these are virtual or in person) could help increase understanding of Local Insight and the data it holds.

And of course, providing some basic support materials (either printed copies or online) to go alongside the training. If you have a public site, we can add a basic user guide to the site for you. And if you do not have a public site, we can send a copy of this to you to distribute internally.

If you would like any advice on running short training sessions, or some help in putting support materials together, please get in touch and our team will be able to help you.

Using permalinks to signpost to specific datasets

We have recently updated Local Insight to allow you to directly share links to datasets on your maps. This is much easier for the end user if you have a public site (as they will not have to be set up as a user or logged in) but works for a standard Local Insight subscription too.

This makes it much easier to signpost users directly to datasets. For example;

  • Adding a direct link to the data in Local Insight in response to any data requests
  • Including hyperlinks to datasets in reports and presentations (please note, this example is better suited to public sites).

Internal bulletins / social media

“The rule of seven” is a concept used in advertising, that states a prospect needs to hear or see your message at least seven times before they’ll take any action. And this concept can be transferred to the many potential Local Insight users in your organisation.

Be repetitive, and be consistent with your promotion of Local Insight. Internal bulletins, social media, and your website are great channels to push your message through. For example

  • Highlight new datasets that have been added (using permalinks as above)
  • Pull out interesting statistics to include in social media posts
  • Add links to Local Insight in your email signature
  • Start a Local Insight User Group on LinkedIn or KnowledgeHub for your organisation
  • Signpost to Local Insight from any data / local statistics pages on your website

Disclaimer: Check with your comms teams that this is in line with your organisation’s policies.

If you have a public site, we can also provide you with monthly analytics on site usage. We can include information here on how people are reaching your site. This can help refine your approach and understand which channels are generating the most visits to your site. Get in touch if you would like us to set this up for you.

Your suggestions

What other tactics have you used to promote Local Insight within your organisation and beyond? What has worked well?

If you have any suggestions to add to these tips, please let us know at support@ocsi.co.uk