City of Albany 2021 Resource

The City of Albany has created a comprehensive map of all resources provided in the city. The information presented through openAlbany is based on data provided by Program Providers. This table provides the Provider Name, Program Name, Type of Program, Age of child, Start and End Date, Start and End Time, Cost, Lunch Program, Transportation Provided, Phone Number and a link to the provider’s website. This map can be filtered by Provider Name, Type of Program, Age, Cost, etc., and can be downloaded. Blue icons represent all programs provided by the City of Albany Department of Recreation, Purple icons represent locations that provide Free Summer Meals while Orange icons represent every other program providers in the City. Please note that this data is subject to change; data is likely to show changes as we received more information from program providers or community organizations. Click here to have your program added to the map: https://bit.ly/2ZMMGCl

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"albanyny-gov/city-of-albany-2021-resource-bsw4-vmqr\".\"city_of_albany_2021_resource\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.