Upload your data gets a makeover!

What’s new?

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

Please note: Community Insight Scotland users will use Data Zones, Intermediate Geographies and Districts instead of LSOAs, MSOAs and LAs.

 

What can you do with this new functionality?

Why any geography?

At OCSI we are always adding new and exciting datasets to Community Insight, which are available for everyone to use. However, there are three conditions indicators must meet in order to be loaded into Community 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 Community 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 Community Insight. These will be visible only to people with access to your account.

Local data

For example, your organisation may hold data related to patches within neighbourhoods, such as arrears or complaints. This data might be published at smaller OA levels. Using the new functionality this data can now be loaded into Community 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 stock groups 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 often receive requests to add Local Authority level data to Community Insight. We do not load such datasets in as once the data is apportioned down to match stock groups 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:

  • Fly tipping data
  • Amount of grant money given
  • Social mobility
  • Indicators from the London Data Store, such as sport participation

You can now load these datasets into Community Insight.

Private Data

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

 

How to use this new functionality?

In Community 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 menu item. 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).

Have a look at the Knowledge Base for a step by step guide to uploading data in Community 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

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!

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

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.

 

Let us know!

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

Quarterly data updates from Land Registry and Department of Work and Pensions

Updated indicators

We have updated a range of quarterly published indicators in Community Insight. See the tables below for a snapshot of the highlights in the different national sites. Or take a look at the full list of updated indicators for your national site on our Knowledge Base article.

The indicators in the below table are now updated and live in all Community Insight sites (England, Scotland and Wales)

Indicator Source Reports Maps
Older people social care benefit (Attendance Allowance) DWP Yes Yes
Attendance Allowance claimants, Higher Rate award DWP No Yes
Attendance Allowance claimants, Lower Rate award DWP No Yes
Attendance Allowance claimants aged 65-69 DWP No Yes
Attendance Allowance claimants, female DWP No Yes

The indicators in the below table are now updated and live in Community Insight England and Wales only

Indicator Source Reports Maps
Average house price Land Registry Yes Yes
Average house price for terraced houses Land Registry Yes Yes
Average house price for flats Land Registry Yes Yes

The indicator in the below table is now updated and live in Community Insight England only

Indicator Source Reports Maps
Number of property transactions Land Registry Yes Yes

Quarterly police UK updates

The crime indicators, published quarterly by Police UK, have been published a little later than usual this round. As a result, they will be updated in the next round of regular data updates which will be live in Community Insight mid month.

Current indicators within Community Insight

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

Data updates in Community Insight

 

All indicator updates

Please note: ‘Unemployment benefit’ will be ‘Unemployment benefit (JSA)’ for Community Insight Scotland

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

 

Updated indicators for England only

Indicator Source Reports Maps
National Insurance numbers issued to non-UK nationals DWP Yes Yes

 

Updated indicators for Wales only

Indicator Source Reports Maps
Migration from overseas DWP Yes Yes

 

ONS population estimate revisions

Please note: Community Insight Scotland has not receive the following revisions

You may be aware that the ONS have revised their population estimates and published these at LA level. We have incorporated these revisions into Community Insight. For more information on this process and what it means for your data and areas check out our blog.

Current indicators within Community Insight

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

 

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

All indicator updates

Across the board, we have updated 94 indicators in Community 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

New indicators for Wales

Community Insight Wales have received a number of new indicators this month:

Indicator Source Reports Maps
Net annual household income estimate Office for National Statistics (ONS) No Yes
Net annual household income estimate after housing costs Office for National Statistics (ONS) Yes Yes
Net annual household income estimate before housing costs Office for National Statistics (ONS) Yes Yes
Total annual household income estimate Office for National Statistics (ONS) Yes Yes

Updated Indicators for Scotland

There are also plenty of updates for datasets on Community Scotland in the following areas:

Indicators for Source Reports Maps
Dwellings, broken down by dwelling type, council tax band and number of rooms National Records of Scotland Yes Yes
Low birth weight Population Health Yes Yes
Women giving birth, broken down by former smokers at booking, smoking at booking, and never smoked Population Health Yes Yes
People living within 0-500 metres of any Derelict Site Scottish Vacant and Derelict Land Survey (SVDLS) No Yes
Fires per 100,000 population, broken down by accidental and deliberate Scottish Government No 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 Community Insight

To see a list of all of the current indicators available in Community Insight 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 Community 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 Tuesday 15th May 2018

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 Community 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

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

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

 

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.