The MyGov.NYC APP uses a unique combination of software. It’s data management backend is a collection of AirTables (currently 3 and growing) that hold different datasets but all share one feature: a table that matches organziation names with a UID for the organization. That organization/UID pairing is the same in all the AirTables.
AirTables offer a native API, so we built an app that imports all the data from the AirTables and then joins that data together using the shared UIDs. This app uses a MySQL database and a Laravel application framework.