Name: Child Care Regulated Programs
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Child Care Regulated Programs

Information on OCFS regulated child care programs, which includes program overview information and violation history.
Organization: State of New York
Last updated: 2020-11-12T03:59:47.251954
Tags: child-care, day-care, programs, violations

Tables

Table 1

@usgov.state_of_new_york_child_care_regulated_programs.table_1

2 MB
16205 rows
33 columns


CREATE TABLE table_1 (
  "facility_id" BIGINT,
  "program_type" VARCHAR,
  "region_code" VARCHAR,
  "county" VARCHAR,
  "facility_status" VARCHAR,
  "facility_name" VARCHAR,
  "facility_opened_date" TIMESTAMP,
  "license_issue_date" TIMESTAMP,
  "license_expiration_date" TIMESTAMP,
  "address_omitted" VARCHAR,
  "street_number" VARCHAR,
  "street_name" VARCHAR,
  "additional_address" VARCHAR,
  "floor" VARCHAR,
  "apartment" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "phone_number_omitted" VARCHAR,
  "phone_number" VARCHAR,
  "phone_extension" VARCHAR,
  "provider_name" VARCHAR,
  "school_district_name" VARCHAR,
  "capacity_description" VARCHAR,
  "infant_capacity" BIGINT,
  "toddler_capacity" BIGINT,
  "preschool_capacity" BIGINT,
  "school_age_capacity" BIGINT,
  "total_capacity" BIGINT,
  "program_profile" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "georeference" VARCHAR
);