Washington State Liquor And Cannabis Board (LCB) Local Authority Letters by US Government | Demographics and Population Studies

About this Dataset

Washington State Liquor And Cannabis Board (LCB) Local Authority Letters

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 Change of Location, Assumption, Applied for added priv., New Application, and App. In lieu of cur. Priv.
Organization: State of Washington
Last updated: 2024-09-13T19:08:57.203818
Tags: application, cannabis, endorsement, license, liquor, local-authority, permit, privilege

Tables

Table 1

@usgov.state_of_washington_washington_state_liquor_and_cannab_24c652bb.table_1

30.23 KB
24 rows
38 columns


CREATE TABLE table_1 (
  "license" VARCHAR,
  "ubi" BIGINT,
  "designatedsignee" VARCHAR,
  "applicationdate" DOUBLE,
  "countycode" BIGINT,
  "countyname" VARCHAR,
  "citycode" BIGINT,
  "cityname" VARCHAR,
  "corrected_l_a_updated" VARCHAR,
  "dayphone" BIGINT,
  "contact" VARCHAR,
  "l_a_type" VARCHAR,
  "licenseename" 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,
  "la_posted_date" TIMESTAMP,
  "la_posted_time" BIGINT,
  "systemdate" BIGINT,
  "systemtime" BIGINT,
  "location" VARCHAR
);