Open Storefronts Applications (Historical)

Program had ended.

The Open Storefronts program assists existing ground-floor storefront businesses who want to use outdoor areas on a temporary bases due to the COVID-19 crisis. Note: Geospatial data is based on the application address, geocoding error may be the result from an incorrect address submission.

For real time business application updates, please visit NYC Open Storefront dashboard: http://nycopenstorefronts.info/

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 \"cityofnewyork-us/open-storefronts-applications-historical-d54t-ywim\".\"open_storefronts_applications_historical\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.