Icon for Socrata external plugin
Open repository in Console
Updated 7 months ago
Indexed 1 hour ago

DOHMH Childcare Center Inspections

This dataset contains a list of all inspections conducted and any associated violations at active, city-regulated, center-based child care programs and summer camps over the past 3 years. The violations are pre-adjudicated. Violations that are subject to potential penalties (fines) are submitted to NYC Office of Administrative Trials and Hearing where they are adjudicated as either sustained/upheld or dismissed. The dataset also contains additional information on the programs, including license information. For more information on child care in NYC visit:


<em>Note: Due to an ongoing upgrade, this dataset reflects data as of 5/14/2019. We will resume publishing updated data when the upgrade is completed. We apologize for any inconvenience.</em>

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/dohmh-childcare-center-inspections-dsg6-ifza\".\"dohmh_childcare_center_inspections\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • dohmh_childcare_center_inspections
Upstream Metadata