About this Dataset

Judicial Dept. Contracts - Multi-Year Report

Report includes contracts and amendments issued for the Oregon Judicial Department. Contract values provided are estimates. Visit the Oregon Transparency website https://www.oregon.gov/transparency/Pages/index.aspx, or the Oregon Judicial website https://www.courts.oregon.gov/Pages/default.aspx for more information.
Organization: State of Oregon
Last updated: 2020-11-10T17:21:54.239580
Tags: contracts, judicial, judicial-contracts, transparency

Tables

Table 1

@usgov.state_of_oregon_judicial_dept_contracts_fy_2019_2015.table_1

193.04 KB
2440 rows
15 columns


CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "award_number" VARCHAR,
  "award_title" VARCHAR,
  "award_type" VARCHAR,
  "company_name" VARCHAR,
  "company_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "company_phone" VARCHAR,
  "contract_effective_date" TIMESTAMP,
  "contract_expiration_date" VARCHAR,
  "original_contract_value" DOUBLE,
  "total_amendments" DOUBLE,
  "total_contract_value" DOUBLE
);