Name: Missouri Active Alcohol License Data
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Missouri Active Alcohol License Data

Current license information of businesses involved in the manufacture, shipping, and/or sale of alcohol in the State of Missouri
Organization: State of Missouri
Last updated: 2020-11-10T17:23:46.955771
Tags: alcohol, alcohol-and-tobacco-control, atc, beer, license, manufacturer, missouri, shipping, wine

Tables

Table 1

@usgov.state_of_missouri_missouri_active_alcohol_license_data.table_1

1.45 MB
18,942 rows
20 columns

CREATE TABLE table_1 (
  "licensee" VARCHAR,
  "dbaname" VARCHAR,
  "street_number" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" BIGINT,
  "phone_number" BIGINT,
  "primary_license" BIGINT,
  "secondary_license" BIGINT,
  "primary_type" VARCHAR,
  "secondary_type" VARCHAR,
  "county" VARCHAR,
  "district" BIGINT,
  "subdist" BIGINT,
  "latlng" VARCHAR,
  "assoc" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "phone" BIGINT
);