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

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

2.99 MB
25618 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_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_citations" VARCHAR,
  "cat_b_violation_tracking_numbers" VARCHAR,
  "cat_b_violation_citations" VARCHAR,
  "cat_c_violation_tracking_numbers" VARCHAR,
  "cat_c_violation_citations" VARCHAR
);