Name: Child Care & Youth Camp Licensing Program Data
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Child Care & Youth Camp Licensing Program Data

Child Care & Youth Camp Licensing Program Data
Organization: State of Connecticut
Last updated: 2023-09-29T14:18:59.222000
Tags: camps, child-care, child-care-center, day-care, family-child-care, group-child-care, youth-camps

Tables

Table 1

@usgov.state_of_connecticut_child_care_youth_camp_licensing_program.table_1

1.96 MB
15832 rows
49 columns


CREATE TABLE table_1 (
  "contactidnt" BIGINT,
  "name" VARCHAR,
  "businessflag" VARCHAR,
  "contactlastmodifieddate" VARCHAR,
  "credentialidnt" BIGINT,
  "licensenumber" VARCHAR,
  "credentialdefinitionidnt" BIGINT,
  "licensetype" VARCHAR,
  "credentialstatusid" BIGINT,
  "status" VARCHAR,
  "credentialstatusreasonidnt" DOUBLE,
  "statusreason" VARCHAR,
  "effectivedate" TIMESTAMP,
  "expirationdate" TIMESTAMP,
  "firsteffectivedate" TIMESTAMP,
  "credentiallastmodifieddate" VARCHAR,
  "addresslastmodifieddate" VARCHAR,
  "attention" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "city" VARCHAR,
  "statecode" VARCHAR,
  "zipcode" VARCHAR,
  "phone" VARCHAR,
  "fax" VARCHAR,
  "mailattention" VARCHAR,
  "mailaddress2" VARCHAR,
  "mailaddress3" VARCHAR,
  "mailcity" VARCHAR,
  "mailstatecode" VARCHAR,
  "mailzipcode" VARCHAR,
  "director" VARCHAR,
  "headteacher" VARCHAR,
  "edconsultant" VARCHAR,
  "healthconsultant" VARCHAR,
  "minimumage" VARCHAR,
  "maximumage" VARCHAR,
  "capacityunder3" DOUBLE,
  "maximumcapacity" DOUBLE,
  "regularcapacity" DOUBLE,
  "schoolagecapacity" DOUBLE,
  "minimumcamperage" VARCHAR,
  "maximumcamperage" VARCHAR,
  "projectednumberofcampers" DOUBLE,
  "credentialclassunder3years" VARCHAR,
  "credentialclassnightcare" VARCHAR,
  "credentialclasspreschool" VARCHAR,
  "credentialclassschoolage" VARCHAR,
  "uniquekey" VARCHAR
);