Open Restaurant Applications (Historic)

The Temporary Program, is no longer accepting applications.

*Visit Permanent Dining Out website for information: https://www.diningoutnyc.info/

The New York City Open Restaurant is an effort to implement a citywide multi-phase program to expand outdoor seating options for food establishments to promote open space, enhance social distancing, and help them rebound in these difficult economic times.

For real time updates on restaurants registered in the program, please visit NYC Open Restaurants dashboard: https://bit.ly/2Z00kn8

** Please note this Open Restaurant Applications dataset may contain multiple entries (e.g. restaurants submitting 2 or more applications). The Open Restaurants dashboard website containing real time update, noted above, will have fewer total records due to the removal of multiple applications and only list the newest entry.

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-restaurant-applications-historic-pitm-atqc\".\"open_restaurant_applications_historic\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.