Stone Souping Social Service Information with Airtable in New York City

An AirTable “base” for Open Referral data

The Sahana Software Foundation was 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.

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.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.

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.

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.

Our API documentation website

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.

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.

Our Laravel Front-end AirTable Back-end Directory App

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!

2 Comments


  1. More such grants should be issued in order to ensure the safety of data stored on open source systems. The security of data is becoming a more serious topic these days with more security breaches happening every few days.

    Reply

  2. It is not my first time to pay a quick visit this web site, i am browsing this web site dailly
    and obtain good data from here every day.

    Reply

Leave a Reply

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