Stone Souping Social Service Information with Airtable

[UPDATE, June 29 2018: Sarapis has recently taken this work a couple of steps forward. This week, they published this template to the “AirTable Universe.” Also, they developed a basic front-end service locator website demo, and published the open-source code to Github. Altogether, this adds up to a freely redeployable back-to-front resource directory information system – which can interoperate with other Open Referral-compliant databases. Cool!]

We know that many, if not most, of the community resource directories out there in the world aren’t managed with a database at all. Instead, many people use spreadsheets, Word documents, post-it notes, etc.

And we know that this labor of information maintenance could be made much more efficient, and this work could be made much more impactful, if such information was being managed through structured data systems that have interoperable APIs.

An AirTable “base” for Open Referral data

But many people who maintain resource directories themselves may know very little about this — and it would require them to adopting new technologies and new behaviors. So we know we need more than just to tell them about Open Referral and encourage them to adopt it; we need to make it easy and effective for them to do so.

Sarapis’s OR API documentation website

Fortunately, Airtable offers us just the thing: an easy-to-use, replicable database — with a familiar spreadsheet-style interface — that comes with simple, functional APIs that can automatically turn its contents into Open Referral compliant data.

We’ve been a fan of Airtable for a few years now. It’s as easy to use as a spreadsheet, free for small databases, produces simple csv files, and has an auto-generated API that developers love. We chose to leverage AirTable by creating an Open Referral template that organizations could copy and use to create their own services directory. That would get the data in an API accessible format that could be converted to true Open Referral API format.

Kin Lane, the API Evangelist and technical lead on the Human Services Data API (HSDA), generously offered to then create an API facade (a PHP script and API documentation that turns the AirTable API into HSDA). Thanks to Kin’s work, we could now turn any Open Referral AirTable into an ‘open platform’ for people to manage and share resource data.

For a previous project and partnership, we had built a tool that extracts and displays AirTable data through a familiar directory-style interface. People understand the value of directory websites, so we modified that tool to accommodate Open Referral style data, and viola — we could now offer participating organizations awesome, free directory software that their clients could use to find relevant services.

Our Laravel front-end/AirTable back-end directory app

Sahana has been offering trainings and field-testing this product through hands-on engagement with several local resource directory maintainers, including the managers of Connections resource directory produced by the Correctional Services department at the New York Public LibraryConnections is the city’s most popular nonprofit services directory for formerly incarcerated people — and it’s dataset has previously been managed in technically unsustainable ways.

The NYPL team is now converting their printed directory into an Open Referral AirTable dataset that will be easier to navigate and edit, easier to power an online database of Connections resources, and even accessible via API for other kinds of data exchange.

Interested in our NYC-based Open Referral efforts? Learn more on our program page or jump right in by copying our Open Referral AirTable template.

Interested in using AirTable to power an Open Referral directory? Join our mailing list and ask a question or send us a message.

Want to fund our efforts? Make a tax-deductible donation to Sahana and add a comment that says “Open Referral” so we know how to allocate it.

Thanks for reading!

A modified version of this post was originally published on the Open Referral website.

Leave a comment

Leave a Reply