About this Dataset

Capital Projects Database (CPDB) - Commitments

Office of Management and Budget (OMB) publishes the Capital Commitment Plan three times a year as a series of pdf files, generally in the months of January, April, and September as part of the publication of the Preliminary, Executive, and Adopted Capital Budgets. To explore the data, please visit Capital Planning Explorer For additional information, please visit A Guide to The Capital Budget
Organization: City of New York
Last updated: 2022-11-04T18:04:33.598231
Tags: budget, capital-planning, capital-projects-database, cpdb, omb

Tables

Table 1

@usgov.city_of_new_york_capital_projects_database_cpdb_commitments.table_1

981.5 kB
31,798 rows
22 columns

CREATE TABLE table_1 (
  "ccpversion" VARCHAR,
  "maprojid" VARCHAR,
  "magency" BIGINT,
  "projectid" VARCHAR,
  "projectdescription" VARCHAR,
  "sagencyacro" VARCHAR,
  "sagencyname" VARCHAR,
  "budgetline" VARCHAR,
  "projecttype" VARCHAR,
  "plancommdate" TIMESTAMP,
  "commitmentdescription" VARCHAR,
  "commitmentcode" VARCHAR,
  "typc" VARCHAR,
  "typcname" VARCHAR,
  "plannedcommit_ccnonexempt" BIGINT,
  "plannedcommit_ccexempt" BIGINT,
  "plannedcommit_citycost" BIGINT,
  "plannedcommit_nccstate" BIGINT,
  "plannedcommit_nccfederal" BIGINT,
  "plannedcommit_nccother" BIGINT,
  "plannedcommit_noncitycost" BIGINT,
  "plannedcommit_total" BIGINT
);