health-data-ny-gov/food-service-establishment-last-inspection-cnih-y5dw
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 11 months ago
Indexed 11 months ago

Food Service Establishment: Last Inspection

This 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.htm

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"health-data-ny-gov/food-service-establishment-last-inspection-cnih-y5dw\".\"food_service_establishment_last_inspection\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • food_service_establishment_last_inspection
     
     
     
     
     
Upstream Metadata