Exploring open data quality

To contribute to discussions around open data quality, the ODI has been working with Experian to investigate quality in several UK Government open datasets. Here, ODI Associate Leigh Dodds introduces the project and its initial findings

null Open data communities are focusing on improving the quality of their data and sharing guidance. CC BY 2.0, uploaded by [Neil Rickards](https://www.flickr.com/photos/neilrickards/471690064/in/photolist-HFx2j-bKMhjV-8f3rrF-7eqXuM-eP2zzc-66BVjW-ceG9AL-btCADk-D5aMTE-gDqtze-btCAxD-7yzT34-cXz31Q-7VHwy6-hHU3vu-dkQnGi-hkMRSu-bLTw9n-7xLAFR-3MTfDt-8JjUSN-79hvX1-7erqEc-dvnBPZ-aDMSk2-gDqvPV-hkMoBr-gqhYR2-5bEW2y-hkMSCf-oybpTp-3MXvJm-cADL9y-LJpbM-mw7wcB-9h5GU6-bnYVUx-kg4obi-4vXuD8-dFMVW9-aCwNZ5-kfXGpg-spB4ZW-7eoLtc-7vUYBJ-7sTm1R-9jpYpE-amPKcJ-HWzErq-5yMYhH “Neil Rickards").

There are a number of initiatives at the moment exploring the idea of data quality, with particular reference to describing, measuring and improving the quality of open data.

For example, the W3C Data on the Web Best Practices Working Group are producing a vocabulary for publishing and describing data quality metrics. There is also related work capturing best practices for sharing public sector data.

Various open data projects and communities are working to improve the quality of their open data and have started to share guidance. For example data.gov.sg have recently shared their data quality guide for tabular data. And Mark Frank and Johanna Walker at Southampton University have recently published a paper exploring a user-centred view of data quality.

To contribute to this ongoing discussion, we recently undertook a small project with Experian to explore data quality in some open datasets.

The project had several goals:

  • to identify the types of data quality issues we might find in some existing open datasets

  • to suggest some common data quality checks that both publishers and users could apply to data

  • to explore the idea of an 'open data quality index', building on existing work on Open Data Certificates and benchmarking open data

For the initial exploratory project we’ve used the Land Registry Price Paid data, the Companies House register and the NHS Choices GP Practices and Surgeries.

We worked with the data quality team at Experian to run the datasets through their Pandora data quality tool. Pandora is a data-profiling tool designed to support exploration of datasets, highlight data quality issues and enrich data against other sources. For this project we used Pandora to generate some quality metrics for each of the datasets we reviewed.

You can recreate a number of the checks we carried out using the free version of the tool.

The outputs have been published under an open license and we’ve written a short report on the findings.

Our key insights are as follows:

  • There is still scope to improve how well datasets are documented and published to data.gov.uk and beyond

  • Even in large, well-used and maintained datasets there are a number of basic data quality checks that could be applied to improve data quality

  • Defining and using standard schemas for datasets would benefit both data publishers and users

  • Being able to quickly summarise and explore a dataset offers a powerful way to understand its structure and highlight potential data quality issues

  • The use of standard, open registers will be a significant boost to the quality of many open datasets

If you have any feedback on the findings or suggestions for how to build on the work further, then please get in touch with our labs team.

Leigh Dodds is an ODI Associate. Follow @ldodds on Twitter.

If you have ideas or experience in open data that you’d like to share, pitch us a blog or tweet us at @ODIHQ.