HISTORICAL Sidewalk Café Licenses and Applications
NOTE: This dataset reflects a historical program that is no longer active. The NYC Department of Transportation will be responsible for regulating outdoor dining under the new Dining Out program, and will be publishing program data once its available. In the interim, please consult the Open Restaurants dataset. This dataset features detailed information about sidewalk café license applications and, if applicable, issued licenses.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Dormant
- Says it updates
- Historical data
- Actually updates about every
- —
- Publisher last updated the data
- Aug 21, 2023
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Aug 21, 2023, 10:13 AM
- Rows in our copy
- 324
- Rows at the source
- 324
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
The publisher has not provided a data dictionary.
3 of 47 columns carry a concept; 47 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
street | STREET | The street name of the business’s address. | Not bound | Text | street | text | — | |
app_status | APP_STATUS | This indicates the status of a business’s DCA sidewalk café application. | Not bound | Text | app_status | text | — | |
submit_date | SUBMIT_DATE | Latest date when a business pays (a portion of) its submission fee for a DCA sidewalk café license application. | Not bound | Calendar date | submit_date | timestamp | — | |
final_x | FINAL_X | X coordinate of business’s address using New York Long Island State Plane. | Not bound | Number | final_x | numeric | — | |
zip | ZIP | The zip code where the business is located. | zipdeclared | Text | zip | text | — | |
swc_chairs | SWC_CHAIRS | This indicates the maximum number of chairs for the sidewalk café space as permitted by the business’s DCA license. | Not bound | Number | swc_chairs | numeric | — | |
send_package_dd | SEND_PACKAGE_DD | Date when the sidewalk café license application was sent to the relevant Borough President, Community Board, City Council Member, and Speaker of the Council. |
Download
This file was produced on Aug 27, 2026, 10:04 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/qcdj-rwhu
- Version
- Content hash:
bf995ebc5119614728411515369b2937b8e38b6b171b4c3dc9155deee9a460bf - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Aug 21, 2023, 10:13 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 27, 2026, 2:45 AM | full_replace | success | 324 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |