About this Dataset

Texas Commission On Environmental Quality - Violation Citations

Violation citations are displayed along with their category, allegation description, resolution, and further details that are documented in the Consolidated Compliance and Enforcement Data System (CCEDS). Note other databases are utilized within the agency and may contain additional violation data.
Organization: City of Austin
Last updated: 2023-11-25T10:37:42.541017
Tags: citations, notices-of-violation, nov, tceq, violation

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_c15b961d.table_1

38 MB
251,669 rows
15 columns

CREATE TABLE table_1 (
  "investigation_number" BIGINT,
  "investigation_approved_date" TIMESTAMP,
  "notice_of_violation_id" BIGINT,
  "violation_tracking_number" BIGINT,
  "current_violation_status" VARCHAR,
  "violation_status_date" TIMESTAMP,
  "violation_allegation" VARCHAR,
  "violation_resolution" VARCHAR,
  "violation_repeat_indicator" BOOLEAN,
  "compliance_due_date" VARCHAR,
  "compliance_history_classification" VARCHAR,
  "violation_category" VARCHAR,
  "investigation_type" VARCHAR,
  "county" VARCHAR,
  "tceq_region" VARCHAR
);