Food Service Establishment Inspections: Beginning 2005 (ACTIVE)

health.data.ny.gov | Last Updated 8 Jun 2024

This data includes the name and location of active food service establishments and the violations that were found at the time of the inspection. Inspections are a snapshot in time and are not always reflective of the day-to-day operations and overall condition of an establishment.

Tags: restaurant, food, inspection, violation, oph, public health, consumer resources, environmental health, community health and chronic disease

This dataset has the following 31 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
FACILITYfacilitytextName of the Facility or establishment where FSE operates
ADDRESSaddresstextStreet address and city of facility
DATE OF INSPECTIONdate_of_inspectioncalendar_dateDate of inspection
VIOLATION ITEMviolation_itemtextViolation item from inspection form
VIOLATION DESCRIPTIONviolation_descriptiontextDescription of violation
CRITICAL VIOLATIONcritical_violationtextViolation type, critical Red (R) or non-critical Blue (B)
TOTAL # CRITICAL VIOLATIONStotal_critical_violationsnumberTotal number of Red (critical) violations identified during inspection
TOTAL #CRIT. NOT CORRECTEDtotal_crit_not_correctednumberTotal number of red (critical) violations that were NOT corrected at the time of the inspection
TOTAL # NONCRITICAL VIOLATIONStotal_noncritical_violationsnumberTotal number of Blue (noncritical) violations identified during inspection
LOCAL HEALTH DEPARTMENTlocal_health_departmenttextLocal Health Department issuing permit to FSE
COUNTYcountytextCounty where FSE is located
FACILITY CODEfacility_codetextLocal Health Department assigned code for FSE facility
FACILITY ADDRESSfacility_addresstextStreet address of facility
FACILITY CITYfacility_citytextCity where FSE is located
FACILITY POSTAL ZIPCODEfacility_postal_zipcodetextFacility postal zip code
NYSDOH GAZETTEER (1980)nysdoh_gazetteer_1980textMunicipality code for facility location is derived from the 1980 NYSDOH Gazetteer version. The municipality code identifies the county and the town, village, or city in which the facility is located.
FACILITY MUNICIPALITYfacility_municipalitytextFacility location name (town, village, city or hamlet)
OPERATION NAMEoperation_nametextName of FSE operation
PERMIT EXPIRATION DATEpermit_expiration_datecalendar_dateExpiration date of FSE permit
FOOD SERVICE TYPEfood_service_typetextDescription of FSE operation type
FOOD SERVICE DESCRIPTIONfood_service_descriptiontextAdditional detail on description of FSE operation type
PERMITTED (D/B/A)permitted_d_b_atextBusiness name of operation, Doing Business As (D/B/A)
PERMITTED CORP. NAMEpermitted_corp_nametextPermit applicant (operator) corporation name
PERM. OPERATOR LAST NAMEperm_operator_last_nametextPermit applicant (operator) last name
PERM. OPERATOR FIRST NAMEperm_operator_first_nametextPermit applicant (operator) first name
NYS HEALTH OPERATION IDnys_health_operation_idtextUnique identifier for operation, used on inspection forms
INSPECTION TYPEinspection_typetextType of service (inspection, re-inspection, field visit, preoperational, complaint, illness, incident)
INSPECTION COMMENTSinspection_commentstextInspector’s comments and narrative regarding the inspection (optional in database)
FS FACILITY STATEfs_facility_statetextState that facility is located in (NY)
LATITUDElatitudenumberLatitude of facility
LONGITUDElongitudenumberLongitude of facility