About this Dataset

Capital Project Detail Data - Dollars

This dataset contains capital commitment plan data by project type, budget line and source of funds. The dollar values are in thousands. The dataset was updated three times a year during the Preliminary, Executive and Adopted Capital Commitment Plans. Starting in January 2024, OMB will no longer update this dataset. It is being replaced by the Capital Projects Dashboard administered by the Mayor's Office of Operations.
Organization: City of New York
Last updated: 2020-11-10T17:05:54.908129
Tags: adopted-budget, capital, capital-project, capital-project-commitments, executive-budget, nyc-omb, office-of-management-budget, preliminary-budget

Tables

Table 1

@usgov.city_of_new_york_capital_project_detail_data_dollars.table_1

2.37 MB
72,437 rows
30 columns

CREATE TABLE table_1 (
  "pub_date" BIGINT,
  "boro" VARCHAR,
  "managing_agcy_cd" BIGINT,
  "managing_agcy" VARCHAR,
  "project_id" VARCHAR,
  "project_descr" VARCHAR,
  "typ_category_name" VARCHAR,
  "community_board" VARCHAR,
  "budget_line" VARCHAR,
  "delay_desc" VARCHAR,
  "site_descr" VARCHAR,
  "scope_text" VARCHAR,
  "fy_yr1_plan" BIGINT,
  "orig_bud_amt" BIGINT,
  "city_prior_actual" DOUBLE,
  "city_yr1_plan" BIGINT,
  "city_yr2_plan" BIGINT,
  "city_yr3_plan" BIGINT,
  "city_yr4_plan" BIGINT,
  "city_yr5_plan" BIGINT,
  "city_rtc" BIGINT,
  "city_plan_total" DOUBLE,
  "noncity_prior_actual" DOUBLE,
  "noncity_yr1_plan" BIGINT,
  "noncity_yr2_plan" BIGINT,
  "noncity_yr3_plan" BIGINT,
  "noncity_yr4_plan" BIGINT,
  "noncity_yr5_plan" BIGINT,
  "noncity_rtc" BIGINT,
  "noncity_plan_total" DOUBLE
);