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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"wa-gov/washington-state-liquor-and-cannabis-board-lcb-vgcw-qfjm\".\"washington_state_liquor_and_cannabis_board_lcb\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.