About this Dataset

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.

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.
Organization: City of New York
Last updated: 2020-11-10T17:02:34.174569
Tags: child, health, inspections

Tables

Table 1

@usgov.city_of_new_york_dohmh_childcare_center_inspections.table_1

1.05 MB
27,828 rows
34 columns

CREATE TABLE table_1 (
  "center_name" VARCHAR,
  "legal_name" VARCHAR,
  "building" VARCHAR,
  "street" VARCHAR,
  "borough" VARCHAR,
  "zipcode" DOUBLE,
  "phone" VARCHAR,
  "permit_number" DOUBLE,
  "permit_expiration" TIMESTAMP,
  "status" VARCHAR,
  "age_range" VARCHAR,
  "maximum_capacity" BIGINT,
  "day_care_id" VARCHAR,
  "program_type" VARCHAR,
  "facility_type" VARCHAR,
  "child_care_type" VARCHAR,
  "building_identification_number" DOUBLE,
  "url" VARCHAR,
  "date_permitted" TIMESTAMP,
  "actual" VARCHAR,
  "violation_rate_percent" DOUBLE,
  "average_violation_rate_percent" DOUBLE,
  "total_educational_workers" BIGINT,
  "average_total_educational_workers" DOUBLE,
  "public_health_hazard_violation_rate" DOUBLE,
  "average_public_health_hazard_violation_rate" DOUBLE,
  "critical_violation_rate" DOUBLE,
  "average_critical_violation_rate" DOUBLE,
  "inspection_date" TIMESTAMP,
  "regulation_summary" VARCHAR,
  "violation_category" VARCHAR,
  "health_code_sub_section" VARCHAR,
  "violation_status" VARCHAR,
  "inspection_summary_result" VARCHAR
);