About this Dataset

Washington State Liquor And Cannabis Board (LCB) Cannabis 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 Cannabis Renewals.
Organization: State of Washington
Last updated: 2023-12-09T04:49:00.098976
Tags: application, cannabis, endorsement, license, local-authority, permit, privilege

Tables

Table 1

@usgov.state_of_washington_lcb_cannabis_renewal.table_1

19.22 KB
1 row
31 columns


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