Download all the data in Community Insight at LSOA level

You can now download all the data (more than 900 datasets) in Community Insight for every Lower Layer Super Output Area (LSOA) in the country. In addition to being able to explore data within Community Insight, we hope that access to all the raw data in one place will make further analysis even easier.

How will the All Data Download work?

You can now download a CSV file which contains all the data in Community Insight for all LSOAs in the country. This file will be updated on a quarterly basis, so that you always have the latest data at your fingertips. We will send a mailout to all users every time the file is updated to keep you in the loop.

The CSV file (roughly 300 MB in size) can be found on the Reports tab

All Data download on Community Insight

What does the file contain?

The file contains data for all the indicators in Community Insight at LSOA level, as well as the associated metadata (e.g. name, description, date, source).

How to find the LSOAs  you care about

In Column B, we have included the local authority names. Filter this column to search only for the local authorities you are interested in, in order to make the file more manageable.

If you need a reminder of how LSOAs are defined and how they are created check out this handy geographies guide 

 

Further analysis

The All Data Download makes further analysis easier outside of Community Insight. For example anybody within your organisation could very quickly and easily:

  • Use Excel or other visualisation tools to produce your own charts and tables for use in your analysis
  • Identify which (if any) of your LSOAs are in the 10% most deprived nationally for the index of multiple deprivation.

And of course the analysts among us could delve a lot further into the data, using the Rank command in Excel for benchmarking or using conditional formatting to see whether the areas you care about score relatively high or low compared to other areas, as a couple of examples.

We would love to know how you are using the All Data Download and if you have any ideas and tips to share with the rest of Community Insight user base, please tell us on support@ocsi.co.uk

 

Download data for all your stock groups

If you want to download data for all your existing stock groups in Community Insight, you can use the dashboard export feature.

Learn how to export data from the dashboard

Full guidance & feedback

For more information on using the All Data Download, please read through the Knowledge Base.

If you have any thoughts & feedback on this new functionality then do get in touch. We’d love to hear how you are going to use the All Data Download and if there is anything we can do to make the process of accessing and analysing the data any easier.

You can get in touch with the Support Team on support@ocsi.co.uk or on 01273 810270.