About this Dataset

HHSC CCL Non-Compliance Data

This Data set contains all the non-compliance detail information for the specific section evaluated. The Operation ID, Activity ID and Section ID can be used to link back to the Activity records, Activity Section record, and Operation record files.
Organization: City of Austin
Last updated: 2023-08-25T23:33:07.552991
Tags: ccl, child-care, complicance, hhsc, non-compliance, noncompliance

Tables

Table 1

@usgov.city_of_austin_hhsc_ccl_non_compliance_data.table_1

14.25 MB
147,756 rows
11 columns

CREATE TABLE table_1 (
  "operation_id" BIGINT,
  "activity_id" BIGINT,
  "section_id" BIGINT,
  "non_compliance_id" BIGINT,
  "standard_number_description" VARCHAR,
  "standard_risk_level" VARCHAR,
  "corrected_at_inspection" VARCHAR,
  "corrected_date" VARCHAR,
  "date_correction_verified" VARCHAR,
  "narrative" VARCHAR,
  "technical_assistance_given" VARCHAR
);