Name: TDLR - All Licenses
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

TDLR - All Licenses

A listing of all TDLR license holders from https://www.tdlr.texas.gov/LicenseSearch/.
Organization: City of Austin
Last updated: 2023-08-25T22:13:19.425719
Tags: license

Tables

Table 1

@usgov.city_of_austin_tdlr_all_licenses.table_1

42 MB
886,964 rows
18 columns

CREATE TABLE table_1 (
  "license_type" VARCHAR,
  "license_number" BIGINT,
  "business_county" VARCHAR,
  "business_name" VARCHAR,
  "business_address_line1" VARCHAR,
  "business_address_line2" VARCHAR,
  "business_city_state_zip" VARCHAR  -- BUSINESS CITY, STATE ZIP,
  "business_telephone" VARCHAR,
  "license_expiration_date_mmddccyy" TIMESTAMP  -- LICENSE EXPIRATION DATE (MMDDCCYY),
  "owner_name" VARCHAR,
  "mailing_address_line1" VARCHAR,
  "mailing_address_line2" VARCHAR,
  "mailing_address_city_state_zip" VARCHAR  -- MAILING ADDRESS CITY, STATE ZIP,
  "mailing_address_county" VARCHAR,
  "owner_telephone" VARCHAR,
  "license_subtype" VARCHAR,
  "continuing_education_flag" VARCHAR,
  "business_mailing" VARCHAR
);