About this Dataset

TABC License Information

The TABC License Information dataset includes valuable information associated with each primary license issued by TABC as the result of a successfully submitted, processed. and approved application for one of the twenty eight (28) primary license types for a given business entity. Such information includes data in seven (7) subtopics: identifiers, effective dates, managing entities, attributes, subordinate information, contact information and legacy identifier.
Organization: City of Austin
Last updated: 2023-08-25T22:15:11.178462
Tags: alcohol, license-id, license-information, license-number, tabc, texas-alcoholic-beverage-commission

Tables

Table 1

@usgov.city_of_austin_tabc_license_information.table_1

11.54 MB
114,601 rows
47 columns

CREATE TABLE table_1 (
  "master_file_id" DOUBLE,
  "license_type" VARCHAR,
  "license_id" BIGINT,
  "primary_status" VARCHAR,
  "secondary_status" VARCHAR,
  "license_status" VARCHAR,
  "current_issued_date" TIMESTAMP,
  "status_change_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "expiration_year" DOUBLE,
  "expiration_month" DOUBLE,
  "expiration_day" DOUBLE,
  "trade_name" VARCHAR,
  "owner" VARCHAR,
  "tbd_01" VARCHAR,
  "tbd_02" VARCHAR,
  "wine_percent" VARCHAR,
  "gun_sign" VARCHAR,
  "original_issue_date" TIMESTAMP,
  "tier" VARCHAR,
  "subordinates" VARCHAR,
  "bp" DOUBLE,
  "sd" DOUBLE,
  "e" DOUBLE,
  "fb" DOUBLE,
  "lh" DOUBLE,
  "lp" DOUBLE,
  "wp" DOUBLE,
  "fc" VARCHAR,
  "address" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "phone" VARCHAR,
  "county" VARCHAR,
  "country" VARCHAR,
  "tbd_03" VARCHAR,
  "tbd_04" VARCHAR,
  "tbd_05" VARCHAR,
  "mail_address" VARCHAR,
  "mail_address_2" VARCHAR,
  "mail_city" VARCHAR,
  "mail_state" VARCHAR,
  "mail_zip" VARCHAR,
  "mail_country" VARCHAR,
  "legacy_clp" VARCHAR
);