This blog is the second in our series of articles introducing different sources of public data and how you can use them to improve your research, evidence need and develop insights.
Previously, we looked at what data is in the public domain and how this data can be used to support fundraising and evaluation (read the first blog here: Maximising public data for evaluation and fundraising success). This blog considers what we might need to do with the data to support our research and give us the most interesting insights over time.
When used correctly, public data can offer invaluable insights into how the societal landscape is changing. Often, this data is provided in a ready-to-use format but on occasion we may need to work with the data to make the most of it, such as matching data from multiple files published at different points. Where the format is consistent, this process should be straightforward, however, there is no guarantee that things will remain consistent. The data published can change.
A future blog in this series will revisit homelessness rates across England, exploring how the picture has changed since we first looked at this topic in 2023. The data for this analysis is published every quarter and does not refer to previous quarters as the data is very in-depth. This means that we needed to undertake this matching ourselves. We noted two major changes in the data:
- Change 1-Additional data columns
- After our last blog on homelessness was released, the published data in the subsequent quarter contained additional columns. We use scripts of code to undertake this analysis as this saves time and ensures steps are repeatable. As new columns had been incorporated, we needed to double check that everything was joined together correctly.
- Change 2-New local authority boundaries
- Since 2019, local authority boundaries in North Yorkshire, Suffolk, Dorset, and Cumbria among others have all been redrawn in recent years. Somerset is the county where the most change has been seen, with boundaries being changed in 2019 and again in 2023. Further boundary changes across England are proposed and may be implemented in coming years. These boundary changes make comparisons over time invalid. As a result of this, we have opted to not repeat our analysis at a local authority level.
At The Charity Spark, we regularly incorporate public data into our research projects, often incorporating them alongside context provided through policy pieces released by trusts and foundations.
Get in touch if you’re interested in finding out more.