Food Service Establishment Inspections: Beginning 2005 (ACTIVE)

This data includes the name and location of active food service establishments and the violations that were found at the time of the inspection. Active food service establishments include only establishments that are currently operating. This dataset excludes inspections conducted in New York City (http://www.nyc.gov/html/doh/html/rii/index.shtml), Suffolk County (http://apps.suffolkcountyny.gov/health/Restaurant/intro.html) and Erie County. Inspections are a “snapshot” in time and are not always reflective of the day-to-day operations and overall condition of an establishment. Occasionally, remediation may not appear until the following month due to the timing of the updates. Update frequencies and availability of historical inspection data may vary from county to county. Some counties provide this information on their own websites and information found there may be updated more frequently. This dataset is refreshed on a monthly basis. The inspection data contained in this dataset was not collected in a manner intended for use as a restaurant grading system, and should not be construed or interpreted as such. Any use of this data to develop a restaurant grading system is not supported or endorsed by the New York State Department of Health. For more information, visit http://www.health.ny.gov/regulations/nycrr/title_10/part_14/subpart_14-1.htm or go to the “About” tab. This data set is available at: https://health.data.ny.gov/Health/Food-Service-Establishment-Inspections-Beginning-2/2hcc-shji

Getting Started

All communication with the API is done through HTTPS, and errors are communicated through HTTP response codes. Available response types include JSON, XML, and CSV, which are selectable by the "extension" on API requests or by HTTP Accepts headers.

This documentation also includes inline, runable examples. Click on any link that contains a gear symbol next to it to run that example live against the Food Service Establishment Inspections: Beginning 2005 (ACTIVE) API.

App Tokens

All requests should include an app token that identifies your application, and each application should have its own unique app token. A limited number of requests can be made without an app token, but they are subject to much lower throttling limits than request that do include one. If you don't have an app token yet, click the button to the right to sign up for one.

Once you have an app token, you can include it with your request either by using the X-App-Token HTTP header, or by passing it via the $app_token parameter on your URL.

Response Codes

One of the following response codes will be returned with every request:

  1. 200Successful request.
  2. 202Request processing. You can retry your request, and when it's complete, you'll get a 200 instead.
  3. 400Bad request
  4. 401Unauthorized. You're not authorized to access this resource.
  5. 404Not found. The resource requested doesn't exist.
  6. 429Too Many Requests. The client has made too many requests and is currently being rate limited.
  7. 500Server errors. Our bad!

Code Samples

#!/usr/bin/env ruby

require 'net/https'
uri = URI('https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?recall_id=94')

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = true
http.verify_mode = OpenSSL::SSL::VERIFY_PEER

request = Net::HTTP::Get.new(uri.request_uri)
request.add_field('X-App-Token', ARGV[0])

response = http.request(request)
puts response.code
puts response.body
#!/usr/bin/env python

import sys
import requests

r = requests.get('https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?recall_id=94', headers={'X-App-Token': sys.argv[1]})
print r.status_code
print r.text
request = require 'request'
options = uri: 'https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$$app_token=APP_TOKEN&recall_id=94'
request options, (err, response, body) ->  console.log body
#!/bin/sh 

curl --header "X-App-Token: $1" "https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?recall_id=94"

Fields

The following fields are available on the Food Service Establishment Inspections: Beginning 2005 (ACTIVE) API.

facility

Human Name: FACILITY
Type: text
Name of the Facility or establishment where FSE operates

Examples

Retrieve all records with facility equal to ZUPPA :

Retrieve all records where facility is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(facility, 47.598177,-122.33448, 1000)

address

Human Name: ADDRESS
Type: text
Street address and city of facility

Examples

Retrieve all records with address equal to ZOAR AVENUE, ALBANY:

Retrieve all records where address is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(address, 47.598177,-122.33448, 1000)

date_of_inspection

Human Name: DATE OF INSPECTION
Date of inspection

Examples

Retrieve all records with date_of_inspection equal to 2014-03-10T00:00:00:

Retrieve all records where date_of_inspection is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(date_of_inspection, 47.598177,-122.33448, 1000)

violation_item

Human Name: VIOLATION ITEM
Type: text
Violation item from inspection form

Examples

Retrieve all records with violation_item equal to None:

Retrieve all records where violation_item is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(violation_item, 47.598177,-122.33448, 1000)

violation_description

Human Name: VIOLATION DESCRIPTION
Type: text
Description of violation

Examples

Retrieve all records with violation_description equal to Wiping cloths improperly used [14-4.115]:

Retrieve all records where violation_description is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(violation_description, 47.598177,-122.33448, 1000)

critical_violation

Human Name: CRITICAL VIOLATION
Type: text
Violation type, critical Red (R) or non-critical Blue (B)

Examples

Retrieve all records with critical_violation equal to Not Critical Violation:

Retrieve all records where critical_violation is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(critical_violation, 47.598177,-122.33448, 1000)

total_critical_violations

Human Name: TOTAL # CRITICAL VIOLATIONS
Type: number
Total number of Red (critical) violations identified during inspection

Examples

Retrieve all records with total_critical_violations equal to 81:

Retrieve all records where total_critical_violations is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(total_critical_violations, 47.598177,-122.33448, 1000)

total_crit_not_corrected

Human Name: TOTAL #CRIT. NOT CORRECTED
Type: number
Total number of red (critical) violations that were NOT corrected at the time of the inspection

Examples

Retrieve all records with total_crit_not_corrected equal to 90:

Retrieve all records where total_crit_not_corrected is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(total_crit_not_corrected, 47.598177,-122.33448, 1000)

total_noncritical_violations

Human Name: TOTAL # NONCRITICAL VIOLATIONS
Type: number
Total number of Blue (noncritical) violations identified during inspection

Examples

Retrieve all records with total_noncritical_violations equal to 98:

Retrieve all records where total_noncritical_violations is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(total_noncritical_violations, 47.598177,-122.33448, 1000)

local_health_department

Human Name: LOCAL HEALTH DEPARTMENT
Type: text
Local Health Department issuing permit to FSE

Examples

Retrieve all records with local_health_department equal to Wyoming County:

Retrieve all records where local_health_department is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(local_health_department, 47.598177,-122.33448, 1000)

county

Human Name: COUNTY
Type: text
County where FSE is located

facility_code

Human Name: FACILITY CODE
Type: text
Local Health Department assigned code for FSE facility

Examples

Retrieve all records with facility_code equal to ZA-276 :

Retrieve all records where facility_code is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(facility_code, 47.598177,-122.33448, 1000)

facility_address

Human Name: FACILITY ADDRESS
Type: text
Street address of facility

Examples

Retrieve all records with facility_address equal to ZOAR AVENUE:

Retrieve all records where facility_address is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(facility_address, 47.598177,-122.33448, 1000)

facility_city

Human Name: FACILITY CITY
Type: text
City where FSE is located

Examples

Retrieve all records with facility_city equal to Yulan:

Retrieve all records where facility_city is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(facility_city, 47.598177,-122.33448, 1000)

facility_postal_zipcode

Human Name: FACILITY POSTAL ZIPCODE
Type: text
Facility postal zip code

Examples

Retrieve all records with facility_postal_zipcode equal to NY :

Retrieve all records where facility_postal_zipcode is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(facility_postal_zipcode, 47.598177,-122.33448, 1000)

nysdoh_gazetteer_1980

Human Name: NYSDOH GAZETTEER (1980)
Type: text
Municipality 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.

Examples

Retrieve all records with nysdoh_gazetteer_1980 equal to 615800:

Retrieve all records where nysdoh_gazetteer_1980 is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(nysdoh_gazetteer_1980, 47.598177,-122.33448, 1000)

facility_municipality

Human Name: FACILITY MUNICIPALITY
Type: text
Facility location name (town, village, city or hamlet)

Examples

Retrieve all records with facility_municipality equal to YORKTOWN:

Retrieve all records where facility_municipality is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(facility_municipality, 47.598177,-122.33448, 1000)

operation_name

Human Name: OPERATION NAME
Type: text
Name of FSE operation

Examples

Retrieve all records with operation_name equal to ZUPPA:

Retrieve all records where operation_name is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(operation_name, 47.598177,-122.33448, 1000)

permit_expiration_date

Human Name: PERMIT EXPIRATION DATE
Expiration date of FSE permit

Examples

Retrieve all records with permit_expiration_date equal to 2914-08-31T00:00:00:

Retrieve all records where permit_expiration_date is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(permit_expiration_date, 47.598177,-122.33448, 1000)

food_service_type

Human Name: FOOD SERVICE TYPE
Type: text
Description of FSE operation type

Examples

Retrieve all records with food_service_type equal to SOFA Food Service:

Retrieve all records where food_service_type is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(food_service_type, 47.598177,-122.33448, 1000)

food_service_description

Human Name: FOOD SERVICE DESCRIPTION
Type: text
Additional detail on description of FSE operation type

Examples

Retrieve all records with food_service_description equal to Tavern:

Retrieve all records where food_service_description is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(food_service_description, 47.598177,-122.33448, 1000)

permitted_d_b_a

Human Name: PERMITTED (D/B/A)
Type: text
Business name of operation, Doing Business As (D/B/A)

Examples

Retrieve all records with permitted_d_b_a equal to ZORN'S FAMOUS CHICKEN & RIBS:

Retrieve all records where permitted_d_b_a is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(permitted_d_b_a, 47.598177,-122.33448, 1000)

permitted_corp_name

Human Name: PERMITTED CORP. NAME
Type: text
Permit applicant (operator) corporation name

Examples

Retrieve all records with permitted_corp_name equal to ZZ SOUTHGATE LLC:

Retrieve all records where permitted_corp_name is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(permitted_corp_name, 47.598177,-122.33448, 1000)

perm_operator_last_name

Human Name: PERM. OPERATOR LAST NAME
Type: text
Permit applicant (operator) last name

Examples

Retrieve all records with perm_operator_last_name equal to ZYSMAN:

Retrieve all records where perm_operator_last_name is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(perm_operator_last_name, 47.598177,-122.33448, 1000)

perm_operator_first_name

Human Name: PERM. OPERATOR FIRST NAME
Type: text
Permit applicant (operator) first name

Examples

Retrieve all records with perm_operator_first_name equal to ZYNAH:

Retrieve all records where perm_operator_first_name is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(perm_operator_first_name, 47.598177,-122.33448, 1000)

nys_health_operation_id

Human Name: NYS HEALTH OPERATION ID
Type: text
Unique identifier for operation, used on inspection forms

Examples

Retrieve all records with nys_health_operation_id equal to 858112:

Retrieve all records where nys_health_operation_id is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(nys_health_operation_id, 47.598177,-122.33448, 1000)

inspection_type

Human Name: INSPECTION TYPE
Type: text
Type of service (inspection, re-inspection, field visit, preoperational, complaint, illness, incident)

Examples

Retrieve all records with inspection_type equal to Re-Inspection:

Retrieve all records where inspection_type is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(inspection_type, 47.598177,-122.33448, 1000)

inspector_id

Human Name: INSPECTOR ID
Type: text
Inspector ID

Examples

Retrieve all records with inspector_id equal to yxp04 :

Retrieve all records where inspector_id is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(inspector_id, 47.598177,-122.33448, 1000)

inspection_comments

Human Name: INSPECTION COMMENTS
Type: text
Inspector’s comments and narrative regarding the inspection (optional in database)

Examples

Retrieve all records with inspection_comments equal to yellow rice out at room temp + 63*:

Retrieve all records where inspection_comments is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(inspection_comments, 47.598177,-122.33448, 1000)

fs_facility_state

Human Name: FS FACILITY STATE
Type: text
State that facility is located in (NY)

Examples

Retrieve all records with fs_facility_state equal to NY:

Retrieve all records where fs_facility_state is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/food-service-establishment-inspections-beginning-2005-active-.json?$where=within_circle(fs_facility_state, 47.598177,-122.33448, 1000)

latitude

Human Name: LATITUDE
Type: number
Latitude of facility

Examples

longitude

Human Name: LONGITUDE
Type: number
Longitude of facility