Food Service Establishment: Last Inspection

Food Service Establishment: Last InspectionThis data includes the name and location of food service establishments and the violations that were found at the time of their last inspection. Although violation details are collected on inspection reports (i.e., the actual food item, quantity and temperature of food found out of temperature control) as well as corrective actions for critical violations, this data set is limited to the violation number and the corresponding general violation description. This dataset is for reporting purposes only. Any concerns about individual establishments should be referred to the corresponding Local Health Department. Contact information can be found at http://www.health.ny.gov/environmental/water/drinking/doh_pub_contacts_map.htmVisit the full page to view this data.

This view cannot be displayed

Embed this Dataset

      <div><iframe width="_width_px" title="Food Service Establishment: Last Inspection" height="_height_px" src="https://health.data.ny.gov/w/cnih-y5dw/fbc6-cypp?cur=K2V-y76N5uJ&from=pHCMgoQAFk-" frameborder="0"scrolling="no"><a href="https://health.data.ny.gov/Health/Food-Service-Establishment-Last-Inspection/cnih-y5dw" title="Food Service Establishment: Last Inspection" target="_blank">Food Service Establishment: Last Inspection</a></iframe></div>

Size

500x425
760x646
950x808

Custom Size

425x425 is the minimum size

Width

Height

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

FACILITY: facility
ADDRESS: address
LAST INSPECTED: date
VIOLATIONS: violations
TOTAL # CRITICAL VIOLATIONS: total_critical_violations
TOTAL #CRIT. NOT CORRECTED: total_crit_not_corrected
TOTAL # NONCRITICAL VIOLATIONS: total_noncritical_violations
DESCRIPTION: description
LOCAL HEALTH DEPARTMENT: local_health_department
COUNTY: county
FACILITY ADDRESS: facility_address
CITY: city
ZIP CODE: zip_code
NYSDOH GAZETTEER (1980): nysdoh_gazetteer_1980
MUNICIPALITY: municipality
OPERATION NAME: operation_name
PERMIT EXPIRATION DATE: permit_expiration_date
PERMITTED (D/B/A): permitted_d_b_a
PERMITTED CORP. NAME: permitted_corp_name
PERM. OPERATOR LAST NAME: perm_operator_last_name
PERM. OPERATOR FIRST NAME: perm_operator_first_name
NYS HEALTH OPERATION ID: nys_health_operation_id
INSPECTION TYPE: inspection_type
INSPECTION COMMENTS: inspection_comments
FOOD SERVICE FACILITY STATE: food_service_facility_state
Location1: location1
New York Zip Codes: :@computed_region_43an_4dx5
Counties: :@computed_region_9yqb_tdyd
NYS Senate Districts: :@computed_region_assa_msit
Local Waterfront Revitalization Program (LWRP) Communities: :@computed_region_8ire_itmf
School Districts 2016.shp: :@computed_region_5edz_4hdv

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

New York State Department of Health | Health Data NY

API Endpoint:

Field Names:

OData V4 Endpoint:

OData V2 Endpoint:

Want to leave a comment?

You are leaving health.data.ny.gov.

Notice