Stone Souping Social Service Information with Airtable

[UPDATE, June 29 2018: Sahana 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!]


The Sahana Software Foundation makes high quality, open source information management systems for emergency preparedness, response, recovery and resilience. We were recently awarded a microgrant by Open Referral (using funding from Stanford’s Digital Impact program, with fiscal sponsorship from the Alliance of Information and Referral Services) to develop and deploy an open source system for managing community resource data in the popular AirTable platform and making it accessible via Open Referral’s Human Services Data API.

An AirTable “base” for Open Referral data

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.

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.

Our 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 with Sarapis, 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

We’ve 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 Library. Connections 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!


6 responses to “Stone Souping Social Service Information with Airtable”

  1. […] a functional version of this kind of ‘common data pool,’ using the Open Referral Airtable designed by Sarapis. This is a free system (though scaling its use will likely require upgrading to paid features) and […]

  2. […] 9, 2020March 8, 2020 Devin Balkind   In 2018, with a small grant provided by the Alliance of Information and Referral Systems to the Sahana Softwa…, Sarapis developed an Airtable template of a community resource database using Open Referral’s […]

  3. […] 2018, with a small grant provided by the Alliance of Information and Referral Systems to the Sahana Softwa…, Sarapis developed an Airtable template of a community resource database using Open […]

  4. […] project began in 2018 with a microgrant to build an approximation of Open Referral’s HSDS in Airtable. Sarapis then funded a Laravel-based […]

  5. […] project began in 2018 with a microgrant to build an approximation of Open Referral’s HSDS in Airtable. Sarapis then funded a Laravel-based […]

  6. […] modified version of this post was originally published on the Open Referral […]

Leave a Reply

Your email address will not be published. Required fields are marked *