Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Capital Project Detail Data - Dollars

wa2y-rh4bCity Government30 columns
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.
View on NYC Open Data↗

Quality

C78.0 / 100

From a 500-row sample across 30 columns.

completeness96/ 25% weight
consistency65/ 20% weight
accuracy94/ 20% weight
timeliness14/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Capital Project Detail Data - Milestones0.62
    joins onproject_descrmanaging_agcy_cdboro+3
  • Capital Commitment Plan0.43
    joins onpub_date
  • Expense Budget Funding - All Source0.35
  • Register of Community Board Budget Requests0.35
    joins onboro
  • Capital Budget0.35
    joins onpub_date
  • Revenue Budget & Financial Plan -- Exec\Adpt\Prel

Geography

Has borough codes (`boro`) — joinable, but needs boundary shapes to draw.

Sample rows

pub_dateboromanaging_agcy_cdmanaging_agcyproject_idproject_descrtyp_category_namecommunity_boardbudget_linedelay_descscope_textfy_yr1_plan
20200116CITYWIDE042CITY UNIVERSITYCA207-006CUNY Incubator NetworkMISCELLANEOUS RECONSTRUCTION0HN-0206PROJECT DELAYED DUE TO CHANGES IN SCOPE/DESIGNPROVIDE SPACE IN EACH COMMUNITY COLLEGE TO OFFER RESOURCES FOR SMALL BUSINESS OWNERS.

Columns

30 queryable · 30 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
pub_datecategorical—0%20211222021080520200416of 14
borocategorical—0%MANHATTANBROOKLYNQUEENSof 6
managing_agcy_cdtext—0%846850841
managing_agcytext—0%DEPT OF PARKS AND RECREA…DEPT OF DESIGN & CONSTRU…DEPARTMENT OF TRANSPORTA…

Query this from your own app

GET /api/datasets/wa2y-rh4b
GET /api/datasets/wa2y-rh4b/quality
GET /api/datasets/wa2y-rh4b/related
GET /api/columns?dataset=wa2y-rh4b
0.33
  • Expense Budget0.32
  • Position Schedule0.31
  • 2020
    20200116CITYWIDE056POLICE DEPARTMENTPO79-ADAADA COMPLIANCE RENOVATIONS AT NYPD PRECINCTSPOLICE FACILITIES0PO-0079—ADA COMPLIANCE RENOVATION AT NYPD PRECINTS2020
    20200116CITYWIDE056POLICE DEPARTMENTPO79BATHCITYWIDE BATHROOM RENOVATIONPOLICE FACILITIES0PO-0079PROJECT DELAYED DUE TO CHANGES IN SCOPE/DESIGNBATHROOM RENOVATION2020
    20200116CITYWIDE056POLICE DEPARTMENTPO79BMAHDBATHROOM RENO AT 67TH, 77TH AND TRAFFIC CONTROL DIVISIONPOLICE FACILITIES0PO-0079PROJECT DELAYED DUE TO CHANGES IN SCOPE/DESIGNBATHROOM RENOVATION2020
    20200116CITYWIDE056POLICE DEPARTMENTPO79BMAHGELEVATOR REHABILITATION FOR 20TH, 25THPOLICE FACILITIES0PO-0079PROJECT DELAYED DUE TO CHANGES IN SCOPE/DESIGNELEVATOR REHABILITATION2020
    20200116CITYWIDE056POLICE DEPARTMENTPO79BMAHIBOILER REPLACEMENT AT 68TH, 76TH AND 102ND PCTSPOLICE FACILITIES0PO-0079PROJECT DELAYED DUE TO CHANGES IN SCOPE/DESIGNBOILER REPLACEMENTS2020
    20200116CITYWIDE056POLICE DEPARTMENTPO79BMAHYBOILERS AT 26TH, 42ND & 46TH PRECINCTSPOLICE FACILITIES0PO-0079PROJECT DELAYED DUE TO CHANGES IN SCOPE/DESIGNBOILER REPLACEMENT2020
    20200116CITYWIDE056POLICE DEPARTMENTPO79BMAJZ49TH & 115TH & MTN PCT HVAC REPLACEMENTPOLICE FACILITIES0PO-0079—ESTIMATES2020
    20200116CITYWIDE056POLICE DEPARTMENTPO79BMAKFCAC BATHROOM RENOVATIONPOLICE FACILITIES0PO-0079—ESTIMATE2020
    20200116CITYWIDE056POLICE DEPARTMENTPO79BMAKIBOILERS AT MTS, HWY 3, 75 & 77 PRECINCTSPOLICE FACILITIES0PO-0079—ESTIMATE2020

    Showing 12 of 30 columns. All of them are listed below.

    project_id
    text
    —
    0%
    HBBA24181SANDCONDTSAND2605
    project_descrtext—0%JOB ORDER CONTRACTING WO…FUEL TANK REPLACEMENTSAFE ROUTES TO SCHOOLS-9…
    typ_category_nametext—0%NEIGHBORHOOD PARKS AND P…LOW TO MODERATE INCOME P…LARGE, MAJOR AND REGIONA…
    community_boardinteger—9%0300400
    budget_linetext—0%P-1018HA-D001PU-0025
    delay_desccategorical—40%PROJECT DELAYED DUE TO B…PROJECT DELAYED DUE TO C…PROJECT DELAYED DUE TO U…of 12
    site_descrtext—66%CITYWIDEBOROUGH OF BROOKLYNMANHATTAN
    scope_texttext—2%IA/SQSQ/IAESTIMATE
    fy_yr1_plancategorical—0%202120202023of 6
    orig_bud_amtinteger—0%50010000
    city_prior_actualinteger—0%050100
    city_yr1_planinteger—0%0500100
    city_yr2_planinteger—0%01000500
    city_yr3_planinteger—0%020001000
    city_yr4_planinteger—0%05002000
    city_yr5_planinteger—0%05002000
    city_rtcinteger—0%05001000
    city_plan_totalinteger—0%50010000
    noncity_prior_actualinteger—0%050015
    noncity_yr1_planinteger—0%05001000
    noncity_yr2_planinteger—0%05001
    noncity_yr3_planinteger—0%0100009309
    noncity_yr4_planinteger—0%010000750
    noncity_yr5_planinteger—0%010000750
    noncity_rtcinteger—0%011770
    noncity_plan_totalinteger—0%05001000