PDAP metadata made easier to access and work with, beginning with data sources and agencies.
This mirrors our Data Sources what's that? from Airtable to our PostgreSQL database. Airtable is the entry point for our data, but using Postgres allows us to make an API that's decoupled from Airtable.
Weekly
We're taking advantage of a Python wrapper around the Airtable API to provide flat data joinable on an agency's airtable_uid.
The intent is to do as little transformation as we can, erring on the side of being true to what the API wrapper returns, while also being transparent about how we're doing things.
Some caveats:
- As with all data, this is human-entered and human-devised and subject to imperfections. Corrections and suggestions and questions welcome.
- We'd love to have more fields filled out, or new records added, related to any agencies or data sources.