About this Dataset

HHSC CCL Sections And Standards Evaluated Data

This data set contains the list of sections evaluated along with number of standards evaluated and violated in each section for activities (inspections, investigations and assessments) done in each operation. The Operation ID and Activity ID can be used to link back to the HHSC CCL Inspection / Investigation / Assessment Dataset and HHSC CCL Operations Dataset.
Organization: City of Austin
Last updated: 2023-08-25T23:52:20.252397
Tags: ccl, ccl-section, evaluation, hhsc, inspection, standards

Tables

Table 1

@usgov.city_of_austin_hhsc_ccl_sections_and_standards_evaluated_data.table_1

16.02 MB
1013085 rows
6 columns


CREATE TABLE table_1 (
  "operation_id" BIGINT,
  "activity_id" BIGINT,
  "section_id" BIGINT,
  "evaluated_section_name" VARCHAR,
  "number_of_standards_evaluated" VARCHAR,
  "number_of_standards_violated" VARCHAR
);