About this Dataset

Purchase Orders From PASS

DC Office of Contracting and Procurement Purchase Orders from Procurement Automated Support System (PASS). This dataset contains purchase orders with the amount spend greater than $2500. Data has been updated to include agency budget code, name, and acronym attributes. Budget codes were used to assign the agency name and acronym to each record. Agencies that share the same budget code, such as those under the Executive Office of the Mayor, were left blank in PASS records. For questions regarding details within the data, contact the Office of Contracting and Procurement at https://contracts.ocp.dc.gov/contact.
Organization: District of Columbia
Last updated: 2024-05-22T14:09:37.147810
Tags: contract, dc, district-of-columbia, financial, government-operations, money, ocp, pass, procurement, purchase-order, washington-dc

Tables

Table 1

@usgov.district_of_columbia_purchase_orders_from_pass_1e673.table_1

25.14 MB
262,680 rows
19 columns

CREATE TABLE table_1 (
  "ponumber" VARCHAR,
  "agencycode" VARCHAR,
  "status" VARCHAR,
  "requester" VARCHAR,
  "requistionnumber" VARCHAR,
  "commoditycode" BIGINT,
  "commodityname" VARCHAR,
  "contractnumber" VARCHAR,
  "supplier" VARCHAR,
  "ordereddate" TIMESTAMP,
  "createdate" TIMESTAMP,
  "pototal" DOUBLE,
  "fiscalyear" DOUBLE,
  "dcs_rec_crt_dttm" TIMESTAMP,
  "dcs_last_mod_dttm" TIMESTAMP,
  "potitle" VARCHAR,
  "object_id" BIGINT,
  "agency_acronym" VARCHAR,
  "agency_name" VARCHAR
);