About this Dataset

Treasury Contracts - Multi-Year Report

This is a multi-year contract report of the State Treasurer's office. For more information, please visit https://www.oregon.gov/treasury/pages/index.aspx, or the Oregon Transparency website for more information. https://www.oregon.gov/transparency/Pages/index.aspx
Organization: State of Oregon
Last updated: 2021-08-07T14:38:19.816658
Tags: contracts, oregon-treasury, state-treasurer, treasury, treasury-contracts

Tables

Table 1

@usgov.state_of_oregon_treasury_contracts_multi_year_report.table_1

208.81 kB
4,448 rows
15 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "contract_id" BIGINT,
  "award_title" VARCHAR,
  "contract_classification" VARCHAR,
  "contractor_name" VARCHAR,
  "street1" VARCHAR,
  "city" VARCHAR,
  "state_province" VARCHAR,
  "postal_code" VARCHAR,
  "effective_date" TIMESTAMP,
  "supplemental_effective_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "supplemental_expiration_date" TIMESTAMP,
  "contract_nte_amount" DOUBLE  -- Contract (NTE) Amount,
  "supplemental_contract_amount" DOUBLE
);