About this Dataset

Texas Commission On Environmental Quality - Notices Of Enforcement (NOE)

Investigations resulting in a Notice of Enforcement (NOE) and the details associated with each violation. An investigation may be listed more than once if there were multiple violations associated to that investigation. Multiple violations may be due to identified noncompliance with different regulatory requirements (citations).
Organization: City of Austin
Last updated: 2023-08-25T23:27:27.336442
Tags: enforcement, investigations, oce, orders, program-support-environmental-assistance-division, violations

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_6ea984f0.table_1

3.13 MB
25,618 rows
26 columns

CREATE TABLE table_1 (
  "regulated_entity_number" VARCHAR,
  "regulated_entity_name" VARCHAR,
  "business_type" VARCHAR,
  "mailing_address" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_state" VARCHAR,
  "mailing_zip_code" DOUBLE,
  "physical_location" VARCHAR,
  "physical_city" VARCHAR,
  "physical_county" VARCHAR,
  "physical_zip_code" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "investigation_number" VARCHAR,
  "noe_date" VARCHAR,
  "tceq_docket_number_s_creation_dates" VARCHAR  -- TCEQ Docket Number(s) & Creation Dates,
  "tceq_region_name" VARCHAR,
  "total_violation_count" BIGINT,
  "mailing_zip_code_extension" DOUBLE,
  "notice_of_enforcement_id" DOUBLE,
  "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
);