About this Dataset

Texas Commission On Environmental Quality - Compliance History Report

TCEQ calculates the compliance history mass classification on Sept. 1 each year, which generates compliance history ratings and classifications for all applicable entities. By Nov. 15 these ratings and classifications are then published.

Customers and regulated entities are scored on their performance and assigned a corresponding rating and classification, which range from "High Performer" to "Unsatisfactory Performer". "Unclassified" indicates that there is no information on which to base a rating.

Please refer to the TCEQ Compliance History website for additional information: https://www.tceq.texas.gov/compliance/enforcement/compliance-history
Organization: City of Austin
Last updated: 2023-12-25T11:06:16.313215
Tags: annual-enforcement-report, compliance, compliance-history, compliance-records, enforcement-division, oce, office-of-compliance-and-enforcement

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_51586d6e.table_1

29.71 MB
502,079 rows
16 columns

CREATE TABLE table_1 (
  "customer_number_cn" VARCHAR  -- Customer Number (CN),
  "customer_name" VARCHAR,
  "customer_rating" DOUBLE,
  "customer_classification" VARCHAR,
  "customer_rating_date" TIMESTAMP,
  "regulated_entity_number_rn" VARCHAR  -- Regulated Entity Number (RN),
  "regulated_entity_name" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "tceq_region" VARCHAR,
  "regulated_entity_rating" DOUBLE,
  "regulated_entity_classification" VARCHAR,
  "regulated_entity_rating_date" TIMESTAMP,
  "naics_code" DOUBLE,
  "sic_code" DOUBLE,
  "additional_identifiers" VARCHAR
);