Data in a compatible and recognised format is easier to link, share, match and correct for errors. Yet much data is still collected and sorted in different formats and indexing systems, even when standards such as the Unique Property Reference Number exist. Often this is because of a history of working in silos – a specific department that has always collected citizen or property data in a particular way for example. But it is also perpetuated by software suppliers, either because their software demands proprietary formats, or because they consciously or unconsciously design solutions that require non-standard data formats for competitive advantage or lock-in.
Public service organisations need to resist these pressures. Failure to adopt standard data structures increases risks from poor data quality, mismatches when sharing data and unnecessary manual intervention. Opting for a holistic approach to common data standards and architectures, such as citizen identity and address data, and making it clear to IT suppliers that non-standard data formats are unacceptable are essential requirements for the future of personalised and place-based local public services.
Principles to adopt
- Use standard data formats and referencing for all data sets and plan to retire or adjust all systems data that does not conform.
- Cleanse and match legacy data sets to common referencing systems.
- Prioritise open data, linked data and open application programming interfaces (APIs).
- Adopt common and open standards for data and avoid closed solutions (such as pdf – easy to consume but maintain data lock-in) where possible in favour of portable data formats (such as CSV files – open and shareable).
- Ensure standard data formats and referencing systems are covered in all digital and IT systems procurements, particularly anticipating data linkages and the potential value from open data in the public domain.
- Ensure all suppliers adopt open data standards and good practices in data handling and storage. This includes cloud hosting and ensuring data can readily be unlocked from systems for reuse or retrieved when contracts end.
- Adopt good practices for maintaining data quality, processing and use in accordance with the Government Design Principles (GOV.UK) and Local Public Services Data Handling Guidelines (NLAWARP)
- Develop common data architectures to ensure value can be maximised, risks can be managed and linkages can be made to share data safely and securely.
Dorset Care Record
Hampshire & Isle of Wight Care and Health Information Exchange
Making open data work
Open data products
OneLondon Health and Care Record Exemplar
Our Healthier Manchester Health and Care Record Exemplar
Thames Valley Health and Care Record Exemplar
Wessex Health and Care Record Exemplar
Yorkshire & Humber Health and Care Record Exemplar