Name: Texas Commission On Environmental Quality - Central Registry Files - North Texas
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Texas Commission On Environmental Quality - Central Registry Files - North Texas

This data set contains data from the TCEQ Central Registry for the following TCEQ Regional Offices: North Central Texas Regions 1, 2, 3, 8
Organization: City of Austin
Last updated: 2025-07-25T13:28:04.992809

Tables

Table 1

@usgov.city_of_austin_texas_commission_on_environmental_quali_0dac520d.table_1

48.15 MB
1,119,611 rows
35 columns

CREATE TABLE table_1 (
  "regulated_entity_number_re" VARCHAR  -- Regulated Entity Number (RE),
  "re_name" VARCHAR,
  "re_physical_address" VARCHAR,
  "re_physical_address_cont" VARCHAR  -- RE Physical Address Cont.,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "zip_4" DOUBLE  -- ZIP +4,
  "re_physical_location_description" VARCHAR,
  "re_primary_business_description" VARCHAR,
  "re_naics_code" VARCHAR,
  "customer_name" VARCHAR,
  "customer_legal_name" VARCHAR,
  "customer_number" VARCHAR,
  "customer_type" VARCHAR,
  "program" VARCHAR,
  "additional_id_ai" VARCHAR  -- Additional ID (AI),
  "ai_status" VARCHAR,
  "ai_physical_address" VARCHAR,
  "ai_physical_address_cont" VARCHAR  -- AI Physical Address Cont.,
  "ai_city" VARCHAR,
  "ai_state" VARCHAR,
  "ai_zip_code" VARCHAR,
  "ai_physical_location_description" VARCHAR,
  "ai_naics_code" DOUBLE,
  "ai_naics_name" VARCHAR,
  "ai_sic_code" DOUBLE,
  "ai_sic_name" VARCHAR,
  "tceq_region" BIGINT,
  "affiliation_begin_date" TIMESTAMP,
  "affiliation_end_date" VARCHAR,
  "re_status" VARCHAR,
  "re_status_date" VARCHAR,
  "customer_status" VARCHAR
);