About this Dataset

Texas Commission On Environmental Quality - Emergency Response Spills

Emergency Response Spills received by the TCEQ are assigned an Incident Tracking Number. The information submitted by the reporting party is documented and associated to that unique number and then further investigated. An Incident Tracking Number may be listed more than once if there are multiple Customer Names, Released Materials, Media, and/or Effects.
Organization: City of Austin
Last updated: 2023-08-25T23:46:35.830189
Tags: emergency-response-spills, oce, program-support-environmental-assistance-division

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_661a5c40.table_1

19.96 MB
43,936 rows
34 columns

CREATE TABLE table_1 (
  "customer_number" VARCHAR,
  "customer_name" VARCHAR,
  "regulated_entity_number" VARCHAR,
  "regulated_entity_name" VARCHAR,
  "physical_location" VARCHAR,
  "nearest_city_name" VARCHAR,
  "county" VARCHAR,
  "location_zip_code" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "mailing_address" VARCHAR,
  "mailing_address_2" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "incident_number" BIGINT,
  "incident_status" VARCHAR,
  "incident_start_date" TIMESTAMP,
  "incident_received_date" TIMESTAMP,
  "incident_status_date" TIMESTAMP,
  "media" VARCHAR,
  "receiving_water_body" VARCHAR,
  "incident_source" VARCHAR,
  "material_released" VARCHAR,
  "material_released_amount" DOUBLE,
  "unit_of_measure" VARCHAR,
  "spill_classification" VARCHAR,
  "effect" VARCHAR,
  "nature" VARCHAR,
  "incident_comment" VARCHAR,
  "incident_action_taken" VARCHAR,
  "incident_description" VARCHAR,
  "investigation_number" DOUBLE,
  "tceq_region" VARCHAR,
  "coordinates" VARCHAR
);