Name: County Clerk License Information
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

County Clerk License Information

Alcohol Licensing information by County compiled weekly storing 3 weeks at a time
Organization: State of Missouri
Last updated: 2020-11-10T17:23:37.970526
Tags: alcohol, clerk, county, license, liquor, missouri, weekly

Tables

Table 1

@usgov.state_of_missouri_county_clerk_license_information.table_1

287.86 kB
2,483 rows
34 columns

CREATE TABLE table_1 (
  "license_number" BIGINT,
  "licensee_name" VARCHAR,
  "dba_name" VARCHAR,
  "license_type" VARCHAR,
  "current_status" VARCHAR,
  "effective_date" TIMESTAMP,
  "fee_date" TIMESTAMP,
  "fee_type" VARCHAR,
  "expiration_date" TIMESTAMP,
  "business_phone" DOUBLE,
  "manager_phone" DOUBLE,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "district" BIGINT,
  "subdistrict" BIGINT,
  "county" VARCHAR,
  "street_number" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "mailing_address_1" VARCHAR,
  "mailing_address_2" VARCHAR,
  "mailing_address_3" VARCHAR,
  "mailing_address_4" VARCHAR,
  "legal_1" VARCHAR,
  "legal_2" VARCHAR,
  "legal_3" VARCHAR,
  "legal_4" VARCHAR,
  "legal_5" VARCHAR,
  "legal_6" VARCHAR,
  "legal_7" VARCHAR,
  "legal_8" VARCHAR,
  "latlng" VARCHAR
);