Introducing Open Referral’s data transformation toolkit

We’re excited to introduce a set of tools that make it easier to standardize resource data.

Community resource directory data (i.e., information about health, human, and social services available to people in need) is deceptively complex. In order to accurately represent the relationships between organizations, the services they provide, and the locations they are offered, Open Referral’s Human Service Data Specification (HSDS) calls for multiple tables, linked together — which can be challenging to work with. HSDS addressed this challenge by calling for a set of CSV files to be bundled together by a ‘datapackage’ which would specify the tables’ contents and relationships in a single machine-readable file.

Few of the members of our community, however, were familiar with datapackages and how to create them. So we’ve now made it easier to facilitate this complex approach to resource data sharing!

Thanks to the Open Knowledge Foundation, which developed the standard format for JSON datapackages, we’ve now upgraded our specification and associated tools to make it easier to produce, share, and read standardized resource data in the HSDS format, datapackage and all. Continue reading

Continue reading


The DC Community Resource Information Exchange: Phase One Report

The District of Columbia’s community of health, human, and social service providers are struggling with a familiar challenge: they want to be able to more effectively coordinate care among their patients and clients, yet their systems can’t currently ‘talk’ to each other.

In response to this issue, DC’s Department of Health Care Finance (DHCF) initiated the DC Community Resource Information Exchange (DC CoRIE) to develop data infrastructure that supports coordinated screening, referral and tracking across a range of health, human, and social services in DC. DHCF selected the DC Primary Care Association (DCPCA) and Open Referral to lead an initial planning phase to help understand how to build infrastructure that would facilitate these functions. As part of this planning phase, we were tasked with the development of a Community Resource Inventory that can sustainably aggregate up-to-date information about the health, human, and social services available to DC residents. Continue reading

Continue reading