About this Dataset

Texas Commission On Environmental Quality - Complaints

View complaints received by the TCEQ with their associated Complaint Number. The information alleged by the complainant is documented and associated to that unique number and then further investigated. Note, a complaint may be listed more than once if there are multiple associated Customer Names, Released Materials, Media, and/or Effects.
Organization: City of Austin
Last updated: 2024-04-25T11:15:02.992995
Tags: complaints, incidents, oce, office-of-compliance-and-enforcement, program-support-environmental-assistance-division

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_2024a179.table_1

67.06 MB
228,052 rows
24 columns

CREATE TABLE table_1 (
  "complaint_tracking_number" BIGINT,
  "regulated_entity_number" VARCHAR,
  "regulated_entity_name" VARCHAR,
  "complaint_received_date" TIMESTAMP,
  "number_complaining" BIGINT,
  "status" VARCHAR,
  "status_date" TIMESTAMP,
  "media" VARCHAR,
  "program_name" VARCHAR,
  "incident_priority" BIGINT,
  "team_assigned" VARCHAR,
  "priority_description" VARCHAR,
  "incident_description" VARCHAR,
  "county" VARCHAR,
  "incident_comment" VARCHAR,
  "incident_action_taken" VARCHAR,
  "tceq_region" VARCHAR,
  "investigation_status" VARCHAR,
  "investigation_status_date" TIMESTAMP,
  "incident_start_date" VARCHAR,
  "incident_end_date" VARCHAR,
  "investigation_number" DOUBLE,
  "notice_type" VARCHAR,
  "naics_code" DOUBLE
);