About this Dataset

Missouri Alcohol Licenses Not Renewed For The New License Year

List of Missouri alcohol licenses not yet renewed for the next license year. License year begins July 1. This dataset is generated nightly during the months of April through July for the license renewal period. This dataset will be empty the rest of the year.
Organization: State of Missouri
Last updated: 2020-11-10T17:23:41.040056
Tags: alcohol, licenses, liquor, missouri, renew

Tables

Table 1

@usgov.state_of_missouri_missouri_alcohol_licenses_not_renewe_afc54299.table_1

275.41 kB
4,905 rows
17 columns

CREATE TABLE table_1 (
  "license_number" BIGINT,
  "licensee_name" VARCHAR,
  "dba_name" VARCHAR,
  "license_type" VARCHAR,
  "district" BIGINT,
  "sub_district" BIGINT,
  "county" DOUBLE,
  "street_number" VARCHAR,
  "street_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "business_phone" VARCHAR,
  "renewal_date" VARCHAR,
  "latlng" VARCHAR
);