About this Dataset

Texas Commission On Environmental Quality - Notices Of Violation (NOV)

Approved regional investigations resulting in a Notice of Violation (NOV) and the details associated with each violation that are documented in the Consolidated Compliance and Enforcement Data System (CCEDS). All NOVs displayed were sent as physical letters to the Regulated Entities' business contacts. An NOV may contain multiple violation citations (Category A, B, and C) due to identified noncompliance with different regulatory requirements. Note other databases are utilized within the agency and may contain information on additional violations.
Organization: City of Austin
Last updated: 2023-08-25T23:13:15.359952
Tags: investigations, oce, office-of-compliance-and-enforcement, program-support-environmental-assistance-division, violations

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_f22fa473.table_1

5 MB
65,639 rows
21 columns

CREATE TABLE table_1 (
  "regulated_entity_number" VARCHAR,
  "regulated_entity_name" VARCHAR,
  "business_type" VARCHAR,
  "physical_location" VARCHAR,
  "physical_city" VARCHAR,
  "physical_state" VARCHAR,
  "physical_zip_code" DOUBLE,
  "county" VARCHAR,
  "investigation_number" BIGINT,
  "investigation_approved_date" TIMESTAMP,
  "nov_date" VARCHAR,
  "coordinates_county_centroid" VARCHAR  -- Coordinates (County Centroid),
  "tceq_region" VARCHAR,
  "notice_of_violation_id" BIGINT,
  "cat_a_violation_tracking_numbers" VARCHAR  -- Cat. A Violation Tracking Numbers,
  "cat_a_violation_citations" VARCHAR  -- Cat. A Violation Citations,
  "cat_b_violation_tracking_numbers" VARCHAR  -- Cat. B Violation Tracking Numbers,
  "cat_b_violation_citations" VARCHAR  -- Cat. B Violation Citations,
  "cat_c_violation_tracking_numbers" VARCHAR  -- Cat. C Violation Tracking Numbers,
  "cat_c_violation_citations" VARCHAR  -- Cat. C Violation Citations,
  "total_violation_count" BIGINT
);