Name: OLCC Monthly Pricing
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

OLCC Monthly Pricing

Prices for liquor items sold by the OLCC
Organization: State of Oregon
Last updated: 2024-04-19T17:13:30.169147
Tags: liquor, monthly, olcc, price

Tables

Table 1

@usgov.state_of_oregon_olcc_monthly_pricing.table_1

1.38 MB
93,839 rows
17 columns

CREATE TABLE table_1 (
  "asofdate" TIMESTAMP,
  "itemcode" VARCHAR,
  "extendeditemcode" BIGINT,
  "description" VARCHAR,
  "oregonproduct" VARCHAR,
  "itemstatus" VARCHAR,
  "itemstatuscode" VARCHAR,
  "category" VARCHAR,
  "newitem" VARCHAR,
  "specialpricing" VARCHAR,
  "size" VARCHAR,
  "age" VARCHAR,
  "proof" DOUBLE,
  "priceperbottle" DOUBLE,
  "bottlespercase" BIGINT,
  "pricepercase" DOUBLE,
  "pricechange" DOUBLE
);