Delivering Open Referral Solutions with Airtable

In 2018, with a small grant provided by the Alliance of Information and Referral Systems to the Sahana Software Foundation, Sarapis developed an Airtable template of a community resource database using Open Referral’s Human Services Data Specification (HSDS). This project responded to a need articulated by many in our community for a lightweight, easy-to-use resource database for the management of complex service directory data.

With the functionality of a basic database, and the user interface of a common spreadsheet, we hypothesized that an Airtable template could provide a workable solution for organizations and projects with very limited funding.

Continue reading

Continue reading


Providing Access to Legal Assistance through Instant Attorney

[Welcome to Everett Pompeii of Clerical.AI! We are excited to feature this as our most recent highlighted project from the field of legal services.]

Where should you refer someone for legal help?

The answer given is usually one of two extremes: free legal aid or the local bar association.

There are other options out there, from do-it-yourself apps like Legalzoom to flat rate and limited scope attorneys. However, in the vast ocean of the internet, these resources can be difficult if not impossible to find, and even if you do find them it can be difficult to compare prices. A newly launched platform, Instant Attorney, is aiming to make the problem of finding affordable legal services a whole lot easier. Instant Attorney, which went into open beta last month, is a collaborative legal resource knowledge base built on the Human Services Data Specification (HSDS). Continue reading

Continue reading


Our 2019 Year in Review

As January 2020 comes to a close, I’m pleased to share our Year in Review report for Open Referral’s 2019.

The report is available to download here. You can also read it embedded in this blog post below.

This year, our report features voices of stakeholders across our network — including social workers and legal aid providers, Chief Information Officers managing legacy systems and young innovators breaking ground with new projects. These stories convey the wide range of ways in which Open Referral is making it easier for communities to share information about the resources available for their residents in need.

Continue reading

Continue reading


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


Not another directory of services! Adopting Open Referral in the UK

Today we welcome to the blog Mike Thacker of Porism Limited. Porism is a technical partner of the Local Government Association (LGA), a membership organisation of English local authorities, which owns the Improvement and Development Agency for local government (IDeA). Porism works with iStandUK, a local government standards body that promotes efficiency, transformation, and transparency of local public services in the UK. 

Earlier this year, the Ministry of Housing, Communities and Local Government (MHCLG) has commissioned discovery work on standards for local community-based services, which recommended alignment with Open Referral’s resource data exchange standards. Now, Porism is working with LGA and iStandUK to test and support extensions to Open Referral. This work includes commissioning an open-source “service finder” application – for which Porism is currently soliciting proposals.

This post is adapted from the original on Medium. 

Most of us who’ve worked in or with the public and voluntary sectors will have come across a plethora of directories of services from registers of specialists kept by a department to more general lists of family services, sporting activities and advisers. The prevalence of such directories of overlapping content and variable quality is a testament to how far away we are from achieving an efficient means of getting accurate information. Now the Local Government Association (LGA) is piloting an approach to bring us closer to that goal. Here I summarise the approach being taken and provide some links for open data people who want to get more involved.

Continue reading

Continue reading


Sunlight Foundation on local governments and the opening of social service data

Allegheny County’s Department of Human Services has long been known as one of the most innovative government agencies of its kind: their data infrastructure famously enables sharing of client information across a complex array of programs and powers analytic capabilities. As Ian Mavero started his role as their Chief Technology Officer, he took on the department’s next strategic priority: further improving the Department of Human Services’ (DHS) flow of information about, well, human services.

“When it comes to information about residents — and activities of our programs — our data infrastructure is really impressive,” says Ian Mavero. “When it comes to information about our services, we have a single database that contains information about all of the providers with whom we contract and their associated facilities and services… But we commonly hear that our community partners and clients themselves, desire better access to information about these services. And we agree: community mental health specialists should have access to the same information about available services as our own agency’s case workers do.”

In order to share information about services more broadly and effectively, Mavero realized that Allegheny DHS’s IT would need to take another step forward — not with fancy new technology, just with more deliberate practices of structuring and sharing this existing data.

“We needed a standardized way to structure this directory information in a way that could enable it to be shared across all offices, with our contracted partners, and even with the public at large.” Continue reading

Continue reading


Link2Feed leveraging Open Referral to provide resource directory information to food pantries

This post is by Emily Branton, President of Link2Feed. Welcome, Emily!

 

Link2Feed believes that food pantries don’t just play a key role in mitigating hunger – they also a catalyst for change for broader poverty issues.

Our client-intake software and reporting tool is used by food banks and other non-profits across North America to enable them to gather data that can drive organizational strategy and increase the impact of their services.

 

The Need for Change: Connecting Food Support With Additional Services

At Link2Feed, we have heard consistently how challenging it was to find and facilitate referrals to pantry clients.

One of our partners, Feed Ontario (formerly the Ontario Association of Food Banks), saw an opportunity to expand the reach and impact of their 1,200 member food banks and hunger-relief organizations, by making resource directory data directly available within the Link2Feed system, so that food bank staff and volunteers can more effectively refer clients to other services.

This summer, Link2Feed and Feed Ontario are piloting a new referral method that uses the Open Referral standard to receive resource data from Ontario 211. Continue reading

Continue reading


New research finds urgent needs for interoperability across health, human, and social service sectors

It often doesn’t matter how clever or well-designed a new technology is – if it can’t easily work with other technologies (and other organizations and people) then it may not accomplish much good at all.

In the last month, three significant reports have underscored this reality – one each from the US (produced by the Social Interventions Research & Evaluation Network), Canada (produced by MaRS Discovery District), and the UK (produced by Snook).

These reports compile a considerable amount of research from across the field of public informatics in general, and community resource information and referral systems in particular. Each assesses a broad swath of organizations and technologies that are trying to innovate in ways that help people in need – yet often struggling to realize their intended potential.

Taken together, this set of research and analysis makes an urgent case that governments, philanthropies, and civil society organizations should prioritize interoperability as a core value of their investment strategies, through promotion of open data standards in general – and Open Referral in particular.

Let’s take a look!

Continue reading

Continue reading