About this Dataset

Texas Commission On Environmental Quality - NOR Episodic Notifications

This dataset lists site information, waste codes, and waste descriptions for episodic notifications for unregistered generators. Episodic notifications for unregistered generators are temporary waste generation events that require notification but do not require a solid waste registration. Episodic notifications prior to February 7, 2022 were referred to as one-time shipments.
Organization: City of Austin
Last updated: 2025-06-25T12:54:09.432888
Tags: nor, occupational-licensing-registration-division, office-of-waste, oow

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_fdc49f99.table_1

1.69 MB
17620 rows
37 columns


CREATE TABLE table_1 (
  "episodic_request_id" BIGINT,
  "regulated_entity_number" VARCHAR,
  "epa_id_number" VARCHAR,
  "solid_waste_registration_number" DOUBLE,
  "facility_site_name" VARCHAR,
  "episodic_request_id_status" VARCHAR,
  "texas_waste_code" VARCHAR,
  "waste_description" VARCHAR,
  "epa_hazardous_waste_numbers" VARCHAR,
  "origin_code" DOUBLE,
  "source_code" VARCHAR,
  "physical_location_address" VARCHAR,
  "physical_location_description" VARCHAR,
  "city" VARCHAR,
  "zip_code" DOUBLE,
  "county" VARCHAR,
  "tceq_region_number" VARCHAR,
  "land_type" VARCHAR,
  "primary_naics_code" DOUBLE,
  "request_received_date" VARCHAR,
  "generator_name_customer_name" VARCHAR,
  "generator_mailing_address" VARCHAR,
  "generator_mailing_city" VARCHAR,
  "generator_mailing_state" VARCHAR,
  "generator_mailing_zip_code" DOUBLE,
  "generator_mailing_zip_code_4" DOUBLE,
  "generator_mailing_country_code" VARCHAR,
  "generator_phone_number" VARCHAR,
  "generator_fax_number" VARCHAR,
  "broker_company_name" VARCHAR,
  "broker_mailing_address" VARCHAR,
  "broker_mailing_city" VARCHAR,
  "broker_mailing_state" VARCHAR,
  "broker_mailing_zip_code" DOUBLE,
  "broker_mailing_zip_code_4" DOUBLE,
  "broker_phone_number" VARCHAR,
  "broker_fax_number" VARCHAR
);