Solicitations From PASS by US Government | Finance and Economics

About this Dataset

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

Tables

Table 1

@usgov.district_of_columbia_solicitations_from_pass_85ffa.table_1

2.56 MB
25804 rows
46 columns


CREATE TABLE table_1 (
  "agency_acronym" VARCHAR,
  "agency_name" VARCHAR,
  "object_id" BIGINT,
  "solicitationnumber" VARCHAR,
  "solicitationprojectnumber" VARCHAR,
  "solicitationtitle" VARCHAR,
  "agencycode" VARCHAR,
  "agencydescription" VARCHAR,
  "citywide" VARCHAR,
  "subcontracting_req" VARCHAR,
  "solicitationstatus" VARCHAR,
  "due_date" TIMESTAMP,
  "nigpcode" VARCHAR,
  "nigpcodedescription" VARCHAR,
  "markettype" VARCHAR,
  "worksitelocation" VARCHAR,
  "type" VARCHAR,
  "pickuplocation" VARCHAR,
  "solfee" DOUBLE,
  "issuancedate" TIMESTAMP,
  "opendate" TIMESTAMP,
  "closedate" TIMESTAMP,
  "owner" VARCHAR,
  "owneragency" VARCHAR,
  "phone" VARCHAR,
  "faxnumber" VARCHAR,
  "email" VARCHAR,
  "contractingofficer" VARCHAR,
  "coemailaddress" VARCHAR,
  "award_to" VARCHAR,
  "award_date" VARCHAR,
  "procurementmethod" VARCHAR,
  "contracttype" VARCHAR,
  "eventstatus" DOUBLE,
  "eventdisplaystatus" VARCHAR,
  "source" VARCHAR,
  "synopsis" VARCHAR,
  "preconferencedate" TIMESTAMP,
  "preconferencelocation" VARCHAR,
  "fiscalyear" DOUBLE,
  "rec_create_date" TIMESTAMP,
  "rec_lastmodified_date" TIMESTAMP,
  "documentversion" DOUBLE,
  "octo_posted" DOUBLE,
  "dcs_rec_crt_dttm" TIMESTAMP,
  "dcs_last_mod_dttm" TIMESTAMP
);