About this Dataset

Texas Commission On Environmental Quality - Monthly Waste Receipt Summary

Information from the TCEQ monthly waste receipts summary report form submitted by receivers of hazardous and Industrial Class 1 waste. It contains the receiver's registration number, the received date, waste code, quantity received, who shipped the waste and how it was handled.
Organization: City of Austin
Last updated: 2023-08-25T23:08:08.038250
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_2bab03f6.table_1

81.27 MB
2,819,851 rows
17 columns

CREATE TABLE table_1 (
  "receiver_s_registration_number" VARCHAR,
  "manifest_tracking_number" VARCHAR,
  "generator_s_texas_id" VARCHAR,
  "generator_s_epa_id" VARCHAR,
  "waste_code" VARCHAR,
  "quantity_received_lbs" DOUBLE  -- Quantity Received (lbs),
  "management_code" VARCHAR,
  "date_received" TIMESTAMP,
  "transporter_s_texas_id" VARCHAR,
  "receiver_s_name" VARCHAR,
  "no_shipment_received" BOOLEAN,
  "record_date" TIMESTAMP,
  "report_month_year" VARCHAR  -- Report Month & Year,
  "hazard_code_1" VARCHAR,
  "hazard_code_2" VARCHAR,
  "hazard_code_3" VARCHAR,
  "hazard_code_4" VARCHAR
);