About this Dataset

Texas Commission On Environmental Quality - Annual Waste Summary

Information from the TCEQ annual waste summary report form, including generator's registration number, the year of report, waste, total quantity generated, quantity handled and how the waste was handled. The report lists the generator's annual waste generation quantities and handling for hazardous and Industrial Class 1 waste.
Organization: City of Austin
Last updated: 2023-08-25T22:13:58.024850
Tags: hazardous-waste, industrial-waste, occupational-licensing-registration-division, office-of-waste, oow

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_33b89768.table_1

14 MB
717,269 rows
17 columns

CREATE TABLE table_1 (
  "generator_s_registration_number" VARCHAR,
  "reporting_year" BIGINT,
  "texas_waste_code" VARCHAR,
  "quantity_generated_lbs" DOUBLE  -- Quantity Generated (lbs),
  "quantity_handled_lbs" DOUBLE  -- Quantity Handled (lbs),
  "management_code" VARCHAR,
  "facility_number" VARCHAR,
  "epa_id" VARCHAR,
  "no_reporting_required" BOOLEAN,
  "record_date" TIMESTAMP,
  "reporting_method" VARCHAR,
  "form_submitter" VARCHAR,
  "hazardous_waste_flag" VARCHAR,
  "acute_hazardous_waste_flag" VARCHAR,
  "generator_comments" VARCHAR,
  "exemption_code" VARCHAR,
  "exemption_resolution_code" VARCHAR
);