The dataset contains every sustained or not yet adjudicated violation citation from every full or special program inspection conducted up to three years prior to the most recent inspection for restaurants and college cafeterias in an active status on the RECORD DATE (date of the data pull). When an inspection results in more than one violation, values for associated fields are repeated for each additional violation record. Establishments are uniquely identified by their CAMIS (record ID) number. Keep in mind that thousands of restaurants start business and go out of business every year; only restaurants in an active status are included in the dataset.
Records are also included for each restaurant that has applied for a permit but has not yet been inspected and for inspections resulting in no violations. Establishments with inspection date of 1/1/1900 are new establishments that have not yet received an inspection. Restaurants that received no violations are represented by a single row and coded as having no violations using the ACTION field.
Because this dataset is compiled from several large administrative data systems, it contains some illogical values that could be a result of data entry or transfer errors. Data may also be missing.
This dataset and the information on the Health Department’s Restaurant Grading website come from the same data source. The Health Department’s Restaurant Grading website is here:
http://www1.nyc.gov/site/doh/services/restaurant-grades.page
See the data dictionary file in the Attachments section of the OpenData website for a summary of data fields and allowable values.

NOTE: This dataset reflects data as of 7/21/2023. The Department of Consumer and Worker Protection (DCWP) is working on an updated version of this dataset.

This dataset features DCWP licenses that have been revoked, suspended, or surrendered as well as licenses that have been reinstated, if applicable.

Licenses can be suspended or revoked for several reasons including, an order by the Office of Administrative Trials and Hearings; non-payment of fines and/or fees; or not maintaining a license requirement such as a current driver’s license or insurance coverage.

Licenses are typically surrendered when a business closes, changes ownership, changes location, changes business name, or discontinues the activity that required the license.

Licenses can be reinstated based on appeal of a revocation, expiration of a suspension, or new application after surrendering it.

Each record in the dataset represents a time that a license was revoked, suspended, surrendered, or reinstated so a license can appear more than once.

This dataset can be linked to other DCA datasets using the DCA License Number column. This dataset cannot be linked to an administrative hearing decision or provide a specific reason for the change in status.