About this Dataset

Washington State Liquor And Cannabis Board (LCB) Liquor Renewal

State law requires the Washington State Liquor and Cannabis Board (LCB) to notify the local authority (i.e. mayor or county commission) of the city or county a proposed business is located in that have applied for a license. The local authority has a designated time period respond with an approval, objection or no response to the license application. This dataset provides details submitted to the local authority for applications related to Liquor Renewals.
Organization: State of Washington
Last updated: 2024-09-13T19:06:05.325532
Tags: application, endorsement, license, liquor, local-authority, permit, privilege

Tables

Table 1

@usgov.state_of_washington_washington_state_liquor_and_cannab_c5a9796a.table_1

610.33 kB
4,453 rows
31 columns


CREATE TABLE table_1 (
  "license" VARCHAR,
  "ubi" BIGINT,
  "designatedsignee" VARCHAR,
  "countycode" BIGINT,
  "countyname" VARCHAR,
  "citycode" BIGINT,
  "cityname" VARCHAR,
  "dayphone" VARCHAR,
  "l_a_type" VARCHAR,
  "tradename" VARCHAR,
  "streetaddress" VARCHAR,
  "roomnumber" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" DOUBLE,
  "mailaddress" VARCHAR,
  "mailroom" VARCHAR,
  "mailcity" VARCHAR,
  "mailstate" VARCHAR,
  "mailzip" VARCHAR,
  "privdesc01" VARCHAR,
  "privdesc02" VARCHAR,
  "privdesc03" VARCHAR,
  "privdesc04" VARCHAR,
  "privdesc05" VARCHAR,
  "privdesc06" VARCHAR,
  "privdesc07" VARCHAR,
  "privdesc08" VARCHAR,
  "applicants" VARCHAR,
  "renewaldate" BIGINT,
  "location" VARCHAR
);