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: https://www1.nyc.gov/site/doh/services/child-care.page.

<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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/dohmh-childcare-center-inspections-dsg6-ifza\".\"dohmh_childcare_center_inspections\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.