Industrial and Hazardous Waste (IHW) Datasets
The IHW NOR data contains twelve files. The IHW summary data contains three files covering the past three years. The three reference table files affiliated with both the IHW NOR data and the summary data may also be downloaded if needed.
IHW Notice of Registration (NOR) Data
The following IHW datasets are current as of 01/04/2017.
- facility (nor_ext_fac)
contains the basic information for a site including registration number, registration type, company name, mailing address, site location, facility, contact, waste activities, and other notification information.
- owner (nor_ext_own)
contains the basic information for a facility owner including facility registration number, owner name, mailing address, phone, fax, email, business type, and tax ID. The mailing address, phone, fax, and email information is the information for the contact with role of owner or owner/operator. Only the most recent owner for the facility will be included in this file.
- operator (nor_ext_oper)
contains the basic information for a facility operator including facility registration number, operator name, mailing address, phone, fax, email, business type, and tax id.
- contact (nor_ext_cont)
contains the basic information for a facility contact including facility registration number, contact name, title, contact role, mailing address, phone, fax and email.
- billing contact (nor_ext_billcont)
contains billing contact information including billing contact name, title, phone, mailing address, customer number, and customer name.
- waste (nor_ext_waste)
contains information about a generator's wastes that are registered including registration number, Texas waste code, and the first 80 characters of the generator's waste description. This file also contains a waste id which is a unique id used by the PARIS IHW database for linking with other tables pertaining to waste. (See below for further explanation.) There may be zero to many waste records to one fac record and are linked to a fac record by registration number.
- waste description (nor_ext_wastedesc)
contains the customer's textual description of its wastes. This file contains the registration number, TCEQ unique facility id, waste id, Texas waste code, a sequence number for grouping a waste's multiple lines of descriptions and a single line of the waste description. There may be one to many waste description records per waste record and are linked to a waste record by waste id.
- unit (nor_ext_unit)
contains information about a registrant's waste management units where wastes are managed from on-site or off-site. Unit information includes registration number, unit sequence number and unit type. There may be zero to many unit records to one fac record and are linked by registration number.
- unit description (nor_ext_unitdesc)
contains the customer's textual description of its units. This file contains the registration number, TCEQ unique facility id, unit seq number and the unit description. There will be one record per unit and are linked to a unit record by unit seq number and registration number.
- one-time shipper (nor_ext_ots)
contains information on one-time shipment activities for facilities including the shipper unique ID number, site name, site address, and broker information.
- unit waste (nor_ext_fac)
contains a cross reference for a registration that indicates wastes that are currently managed onsite by a unit. This file contains the registration number, unit sequence number and the waste id. There may be many unitwst records to one unit record and/or many unitwst records to one waste record. The unitwst record is linked by registration number, unit sequence number and waste id.
- EPA hazardous waste numbers (nor_ext_epawst)
contains a list of EPA waste codes that are currently associated with a registered waste. This file contains the registration number, waste id and the EPA waste code. There may be many epawst records to one waste record and are linked by waste id.
IHW Summary Files
Monthly Waste Receipt Records
These files have 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.
- 2016 Monthly Waste Receipts
- 2015 Monthly Waste Receipts
- 2014 Monthly Waste Receipts
- 2013 Monthly Waste Receipts
IHW Reference Tables
The following three files are reference table files for both the NOR data and Summary data.
This file contains several tables of codes for the following:
- TCEQ regions
- measurement point
- system type
- EPA system type
- unit type
- waste form
- EPA waste form
- waste source
- EPA waste source
- standard industrial classification
- capacity units of measurement
contains the EPA Hazardous waste code and the first 80 characters of EPA's description.
contains the reference table for Foreign/Domestic out-of-state codes. This includes the numbers used for out of state receivers and shippers. This file contains the out-of-state code used by PARIS/STEERS, the name of the state or country and the state abbreviation if applicable.