Name: FY2023 OregonBuys POs
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

FY2023 OregonBuys POs

Purchase Orders (contracts) published in OregonBuys during Fiscal Year 2023 (1 July 2022 - 30 June 2023).
Organization: State of Oregon
Last updated: 2024-04-12T17:12:43.521077

Tables

Table 1

@usgov.state_of_oregon_fy2023_oregonbuys_pos_4ba03.table_1

2.43 MB
37,687 rows
20 columns

CREATE TABLE table_1 (
  "n_279a_025_application_of_pcc" VARCHAR  -- 279A.025 Application Of PCC,
  "org_id" VARCHAR,
  "org_name" VARCHAR,
  "po_nbr" VARCHAR,
  "release_nbr" BIGINT,
  "po_sent_date" VARCHAR,
  "purchase_order_total_amount" DOUBLE,
  "total_spend_amount" VARCHAR,
  "short_description" VARCHAR,
  "vendor_name" VARCHAR,
  "vendor_nbr" VARCHAR,
  "vendor_address" VARCHAR,
  "vendor_city" VARCHAR,
  "vendor_state" VARCHAR,
  "vendor_zip" VARCHAR,
  "po_type" VARCHAR,
  "discipline" VARCHAR,
  "blanket_begin_date" VARCHAR,
  "blanket_end_date" VARCHAR,
  "blanket_description" VARCHAR
);