About this Dataset

TABCLicenses

For Help: https://data.texas.gov/videos For more information, go to TABC Sept. 1, 2021 License Consolidation Explained chart
Contains information associated with the licenses, permits, certificates, and authorities granted (issued) by the Texas Alcoholic Beverage Commission (referenced herein as “Licenses”). This information includes certain identifiers for the licenses, the license holders (owners), the license types, and license statuses as more fully defined within this Open Data Portal (ODP) data file for both the Alcohol Industry Management System (AIMS), effective September 1, 2021, and TABCs legacy system(s) prior to September 1, 2021. This “tool” has been provided to allow the user to locate information and cross reference the licenses that were migrated from the TABC legacy system(s) to the AIMS system and for which have been assigned new License numbers effective September 1, 2021.
Organization: City of Austin
Last updated: 2023-08-25T23:07:21.439394
Tags: aims, aims-transition, alcohol, license-cross-reference, license-lookup, license-number, licenses, tabc, texas-alcoholic-beverage-commission

Tables

Table 1

@usgov.city_of_austin_tabclicenses.table_1

4.59 MB
75,090 rows
11 columns

CREATE TABLE table_1 (
  "aimsownername" VARCHAR,
  "aimstradename" VARCHAR,
  "aimslicensetype" VARCHAR,
  "aimslicenseid" BIGINT,
  "legacylicenseclass" VARCHAR,
  "legacylicensenumber" DOUBLE,
  "locationaddress" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "txcounty" VARCHAR
);