About this Dataset

Lottery Expenditures - Multi-Year Report

This report includes expenditure data from the Oregon Lottery. The Lottery uses the Microsoft Dynamics 365 system, a standalone ERP (enterprise resource planning system) for financial transactions. Visit the Oregon Lottery and Oregon Transparency websites for more information. Links: https://www.oregonlottery.org/about/where-the-money-goes/ and https://www.oregon.gov/transparency/Pages/index.aspx.
Organization: State of Oregon
Last updated: 2021-08-07T14:42:04.243001
Tags: expenditures, lottery, lottery-expenditures

Tables

Table 1

@usgov.state_of_oregon_lottery_expenditures_multi_year_report.table_1

74.89 kB
4,802 rows
7 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "department" VARCHAR,
  "acct_name" VARCHAR,
  "amount" DOUBLE,
  "vendor_name" VARCHAR,
  "state" VARCHAR,
  "gl_acct" BIGINT
);