Forecast From PASS by US Government | Finance and Economics

About this Dataset

Forecast From PASS

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:31.332937
Tags: contract, dc, district-of-columbia, financial, forecast, government-operations, money, ocp, pass, procurement, washington-dc

Tables

Table 1

@usgov.district_of_columbia_forecast_from_pass_c8593.table_1

289.55 KB
2790 rows
36 columns


CREATE TABLE table_1 (
  "row_id" BIGINT,
  "oaptnumber" VARCHAR,
  "name" VARCHAR,
  "requester" VARCHAR,
  "agency" VARCHAR,
  "agencyname" VARCHAR,
  "agencypoc" VARCHAR,
  "phone" VARCHAR,
  "fiscalyear" VARCHAR,
  "needbydate" VARCHAR,
  "quarter" VARCHAR,
  "statustring" VARCHAR,
  "submitdate" VARCHAR,
  "arrpoveddate" VARCHAR,
  "citywide" VARCHAR,
  "contractingofficer" VARCHAR,
  "procurementtype" VARCHAR,
  "amount" VARCHAR,
  "oaptlineno" VARCHAR,
  "projecttitle" VARCHAR,
  "description" VARCHAR,
  "fundingsource" VARCHAR,
  "estimatedamount" DOUBLE,
  "acquisition" VARCHAR,
  "contractnumber" VARCHAR,
  "commoditycode" DOUBLE,
  "commoditycodename" VARCHAR,
  "lineneedbydate" TIMESTAMP,
  "linequater" VARCHAR,
  "pocemailaddress" VARCHAR,
  "coemailaddress" VARCHAR,
  "dcs_rec_crt_dttm" VARCHAR,
  "dcs_last_mod_dttm" TIMESTAMP,
  "objectid" BIGINT,
  "agency_acronym" VARCHAR,
  "agency_name" VARCHAR
);