About this Dataset

Texas Commission On Environmental Quality - Historical Dry Cleaner Registrations

This dataset contains all historical Dry Cleaner Registrations in Texas. Note that most registrations listed are expired and are from previous years.

View operating dry cleaners with current and valid (unexpired) registration certificates here: https://data.texas.gov/dataset/Texas-Commission-on-Environmental-Quality-Current-/qfph-9bnd/

State law requires dry cleaning facilities and drop stations to register with TCEQ. Dry cleaning facilities and drop stations must renew their registration by August 1st of each year. The Dry Cleaners Registrations reflect self-reported registration information about whether a dry cleaning location is a facility or drop station, and whether they have opted out of the Dry Cleaning Environmental Remediation Fund. Distributors can find out whether to collect solvent fees from each registered facility as well as the registration status and delivery certificate expiration date of a location.
Organization: City of Austin
Last updated: 2024-01-25T10:48:14.236244
Tags: dry-cleaner-registration, historical, occupational-licensing-registration-division, office-of-waste

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_23edc6b4.table_1

1.84 MB
61,480 rows
32 columns

CREATE TABLE table_1 (
  "registration_id" VARCHAR,
  "regulated_entity_number" VARCHAR,
  "location_name" VARCHAR,
  "certificate_status" VARCHAR,
  "regulated_entity_name" VARCHAR,
  "location_address" VARCHAR,
  "location_address_line_2" VARCHAR,
  "location_city" VARCHAR,
  "location_state" VARCHAR,
  "location_zip_code" DOUBLE,
  "location_zip_code_extension" DOUBLE,
  "location_county" VARCHAR,
  "tceq_region_for_location" VARCHAR  -- TCEQ Region (for Location),
  "customer_number_cn" VARCHAR  -- Customer Number (CN),
  "customer_name" VARCHAR,
  "account_number" DOUBLE,
  "billing_address" VARCHAR,
  "billing_address_line_2" VARCHAR,
  "billing_state" VARCHAR,
  "billing_zip_code" DOUBLE,
  "billing_zip_code_extension" DOUBLE,
  "phone_area_code" DOUBLE,
  "phone_number" DOUBLE,
  "location_type" VARCHAR,
  "fiscal_year" VARCHAR,
  "solvent_type" VARCHAR,
  "capacity_gallons" DOUBLE  -- Capacity (Gallons),
  "fund_eligibility" VARCHAR,
  "gross_receipt_amount" VARCHAR,
  "expiration_date" TIMESTAMP,
  "outlet_number" DOUBLE,
  "solvent_fee_status" VARCHAR
);