Industrial and Hazardous Waste (IHW) Datasets

Current as of 03/14/2023. Texas Solid Waste Activity statewide files consist of three sets of extracts: IHW notice of registration data, IHW summary data, and reference tables affiliated with both NOR and summary data. Some are available for download here—others must be ordered.

Each file is an ASCII fixed length text file. The IHW dataset file specifications and instructions to import into Access will allow you to import the text files into a database program such as Access.

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.

On this page:

IHW notice of registration (NOR) data
IHW Summary Files
Reference tables

IHW Notice of Registration (NOR) Data

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.
one-time shipper EPA hazardous waste numbers (nor_ext_ots_ehwn): a list of EPA waste codes that are currently associated with a waste from a one-time shipment. This file contains the shipper unique ID number, waste id and the EPA waste code. There may be many ots_ehwn records to one Texas Waste Code and are linked by waste id.
universal waste activities (nor_ext_universal): indicates the universal waste activities listed on a solid waste registration.
unit waste (nor_ext_unitwst): 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

Annual Waste Summary

This file contains information from the TCEQ annual waste summary report form, including generator's registration number, year of report, waste, total quantity generated, quantity handled and how the waste was handled.

Waste Shipment Summary

This file contains information from the TCEQ waste shipment summary report form used by one-time generators. It contains the generator's registration number and name, the shipped date, waste, quantity shipped, who received the waste and how it was handled.

Monthly Waste Receipt Summary

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.

IHW Reference Tables

The following three files are reference table files for both the NOR data and Summary data.

genref
This file contains several tables of codes for the following:
- county
- TCEQ regions
- measurement point
- origin
- system type
- EPA system type
- unit type
- waste form
- EPA waste form
- waste source
- EPA waste source
- standard industrial classification
- capacity units of measurement
eparef
contains the EPA Hazardous waste code and the first 80 characters of EPA's description.