About this Dataset

HHSC CCL Daycare And Residential Operations Data

This Data set contains detailed information about Day Care and/ or Residential Care Operation that is displayed on the Public site. The Operation ID is a unique key that ties to the other data sets for Child Care Licensing data
Organization: City of Austin
Last updated: 2023-08-25T22:32:16.345811
Tags: ccl, child-care, child-care-licensing, daycare, hhsc, operations, operations-data, residential

Tables

Table 1

@usgov.city_of_austin_hhsc_ccl_daycare_and_residential_operations_data.table_1

3.07 MB
15,333 rows
44 columns

CREATE TABLE table_1 (
  "operation_id" BIGINT,
  "operation_type" VARCHAR,
  "operation_number" VARCHAR,
  "operation_name" VARCHAR,
  "programs_provided" VARCHAR,
  "location_address" VARCHAR,
  "mailing_address" VARCHAR,
  "phone_number" DOUBLE,
  "county" VARCHAR,
  "website_address" VARCHAR,
  "administrator_director_name" VARCHAR,
  "type_of_issuance" VARCHAR,
  "issuance_date" TIMESTAMP,
  "conditions_on_permit" VARCHAR,
  "accepts_child_care_subsidies" VARCHAR,
  "hours_of_operation" VARCHAR,
  "days_of_operation" VARCHAR,
  "other_schedule_information" VARCHAR,
  "total_capacity" DOUBLE,
  "open_foster_homes" BIGINT,
  "open_branch_offices" BIGINT,
  "licensed_to_serve_ages" VARCHAR,
  "corrective_action" VARCHAR,
  "adverse_action" VARCHAR,
  "temporarily_closed" VARCHAR,
  "programmatic_services" VARCHAR,
  "treatment_services" VARCHAR,
  "deficiency_high" BIGINT,
  "deficiency_medium_high" BIGINT,
  "deficiency_medium" BIGINT,
  "deficiency_medium_low" BIGINT,
  "deficiency_low" BIGINT,
  "total_inspections" BIGINT,
  "total_assessments" BIGINT,
  "total_reports" BIGINT,
  "total_self_reports" BIGINT,
  "location_address_geo" VARCHAR,
  "email_address" VARCHAR,
  "care_type" VARCHAR,
  "operation_status" VARCHAR,
  "address_line" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" VARCHAR
);