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 Projects Database (CPDB) - Projects

fi59-268wCity Government51 columns
The Capital Projects Database reports information at the project level on discrete capital investments from the Capital Commitment Plan.Each row is uniquely identified by its Financial Management Service (FMS) ID, and contains data pertaining to the sponsoring and managing agency. To explore the data, please visit Capital Planning Explorer For additional information, please visit A Guide to The Capital Budget All previously released versions of this data are available on the DCP Website: BYTES of the BIG APPLE . Current version: 26exec
View on NYC Open Data↗

Quality

B88.3 / 100

From a 500-row sample across 51 columns.

completeness100/ 25% weight
consistency57/ 20% weight
accuracy93/ 20% weight
timeliness96/ 15% weight
usability95/ 20% weight

Related datasets

  • Capital Projects Database (CPDB) - Projects (Points)0.88
    joins onspent_nccfederaladopt_citycostcommit_nccstate+41
  • Capital Projects Database (CPDB) - Projects (Polygons)0.88
    joins onspent_nccfederaladopt_citycostcommit_nccstate+41
  • Capital Projects Database (CPDB) - Commitments

Sample rows

ccpversionmaprojidmagencyacromagencymagencynamedescriptionprojectidmindatemaxdatetypecategoryplannedcommit_ccnonexemptccexempt
fisa_2026850GKOH15-01DDC850Department of Design and ConstructionGI - GREEN INFRASTRUCTURE IN OH-015 GRAVESEND BAY CSO PH 1GKOH15-012018-04-03T00:00:00.0002028-06-01T00:00:00.000Fixed Asset185400076389000

Columns

51 queryable · 51 profiled

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

FieldTypeDescriptionNullValues
ccpversiontextReports the version of the Capital Commitment Plan which the record is based on.0%fisa_2026of 1
maprojidtextUnique identifier that defines a discrete project. The maprojid is a concatenation of magency and projectid and it is the primary key.0%057F109HPPUM806HAM22MEBC042CA203-006
magencyacrotextCommon acronym of the city agency managing the project. This value is derived from the three digit managing agency code.0%DPRDDCHPD
magencyintegerThree digit code of the distinct City agency managing the project. The managing agency is the agency overseeing the construction or implementation of a project.0%

Query this from your own app

GET /api/datasets/fi59-268w
GET /api/datasets/fi59-268w/quality
GET /api/datasets/fi59-268w/related
GET /api/columns?dataset=fi59-268w
0.61
joins onnccothernccfederaltotalnoncityplannedcommit+8
  • Capital Projects Dashboard - Citywide Budget and Schedule0.39
  • Property Exemption Detail0.33
  • Parking Violations Issued - Fiscal Year 20140.32
  • Parking Violations Issued - Fiscal Year 20270.32
  • Expense Budget Funding - All Source0.32
    • fisa_2026850PW311GELSDDC850Department of Design and ConstructionGeotechnical & Environmental Investigations Lump SumPW311GELS2011-10-18T00:00:00.0002026-06-01T00:00:00.000Lump Sum00
    fisa_2026846SANDY6-16DPR846Department of Parks and RecreationFor Flushing Meadow ConduitSANDY6-162026-06-01T00:00:00.0002026-06-01T00:00:00.000Fixed Asset00
    fisa_2026125HAM14CRSRDFTA125Department for the AgingCARVER HOUSES SENIOR CENTER COMPUTER LABHAM14CRSR2027-06-01T00:00:00.0002031-06-01T00:00:00.000Fixed Asset1000000
    fisa_2026035LRCE12DOTNYRL35New York Research LibrariesSASB:Improvements to the NYPL VicinityLRCE12DOT2028-06-01T00:00:00.0002031-06-01T00:00:00.000—00
    fisa_2026037LNCA13AGLNYPL37New York Public LibraryAGUILAR - Technology UpgradesLNCA13AGL2027-06-01T00:00:00.0002027-06-01T00:00:00.000ITT, Vehicles, and Equipment00
    fisa_2026846P-411C567DPR846Department of Parks and RecreationUdall's Cove Land AcquisitionP-411C5672010-04-21T00:00:00.0002030-06-01T00:00:00.000Fixed Asset4540000
    fisa_2026035L21FREEZENYRL35New York Research LibrariesNYPL Research Libraries - Blast FreezerL21FREEZE2026-06-01T00:00:00.0002026-06-01T00:00:00.000—3930000
    fisa_2026850HWX413DDC850Department of Design and ConstructionHunts Point AvenueHWX4132026-03-09T00:00:00.0002031-06-01T00:00:00.000—388360000
    fisa_2026068JJZROSSLBACS68Administration for Children's ServicesTHE CROSSROADS JUVENILE CENTER - LIBRARY RENOVATIONJJZROSSLB2013-11-27T00:00:00.0002033-06-01T00:00:00.000Fixed Asset1000000

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

    846850801
    magencynametextCommon name for the city agency mananging the project. This value is derived from the three digit managing agency code.0%Department of Parks and …Department of Design and…Housing Preservation and…
    descriptiontextShort description of the project as described by the sponsor agency. If one projectid had many descriptions the longest description is reported by CPDB.0%JOB ORDER CONTRACTING WO…HPD GREEN PROGRAMHOME FIRST DOWN PAYMENT …
    projectidtextAlphanumeric code created by the sponsor agency that identifies a distinct project. A Project ID must be unique within a managing agency.0%LQSZ-RENOP-2BUSHDEPWSAMFIEH
    mindatedatetimeThe earliest panned commitment date associated with the project.0%2026-06-01T00:00:00.0002027-06-01T00:00:00.0002028-06-01T00:00:00.000
    maxdatedatetimeThe latest panned commitment date associated with the project.0%2026-06-01T00:00:00.0002027-06-01T00:00:00.0002028-06-01T00:00:00.000
    typecategorycategoricalClassification given by DCP based on keywords found in the short description describing if a projects is Fixed Asset, Lump Sum, or ITT, Vehicles, and Equipment.8%Fixed AssetITT, Vehicles, and Equip…Lump Sumof 3
    plannedcommit_ccnonexemptintegerSum of City Cost (Non-Exempt) funding across all commitments associated with the project.0%010001000000
    ccexemptintegerSum of City Cost (Exempt) funding across all commitments associated with the project.0%04000000100000
    totalcityplannedcommitintegerSum of City funding across all commitments associated with the project.0%01000500000
    nccstateintegerSum of State funding across all commitments associated with the project.0%050000010000000
    nccfederalintegerSum of Federal funding across all commitments associated with the project.0%0400000001000
    nccotherintegerSum of Other funding across all commitments associated with the project.0%022200001000
    totalnoncityplannedcommitintegerSum of Non-City funding across all commitments associated with the project.0%05000001000000
    totalplannedcommitintegerSum of City Cost and Non-City Cost, which reports the total planned commitments for the project allocated in the Capital Commitment Plan.0%010000001000
    adopt_ccnonexemptintegerSum of City adopted funding (Non-Exempt) associated with the project within in the City's budget.0%01000000500000
    adopt_ccexemptintegerSum of City adopted funding (Exempt) with the project within in the City's budget.0%010000004000000
    adopt_citycostintegerSum of City adopted funding associated with the project within in the City's budget.0%05000001000000
    adopt_nccstateintegerSum of State adopted funding associated with the project within in the City's budget.0%05000001000000
    adopt_nccfederalintegerSum of Federal adopted funding associated with the project within in the City's budget.0%0400000001000000
    adopt_nccotherintegerSum of Other adopted funding associated with the project within in the City's budget.0%0222000020000
    adopt_noncitycostintegerSum of Non-City adopted funding associated with the project within in the City's budget.0%02220000500000
    adopt_totalintegerSum of of the total adopted funding associated with the project within the City's budget.0%05000001000000
    allocate_ccnonexemptintegerSum of City allocated funding (Non-Exempt) associated with the project within in the City's budget.0%01000000500000
    allocate_ccexemptintegerSum of City allocated funding (Exempt) with the project within in the City's budget.0%050000004000000
    allocate_citycostfloatSum of City allocated funding associated with the project within in the City's budget.0%0.001100000
    allocate_nccstateintegerSum of State allocated funding associated with the project within in the City's budget.0%050000010000000
    allocate_nccfederalintegerSum of Federal allocated funding associated with the project within in the City's budget.0%0400000001000000
    allocate_nccotherfloatSum of Other allocated funding associated with the project within in the City's budget.0%022200001000
    allocate_noncitycostintegerSum of Non-City allocated funding associated with the project within in the City's budget.0%02220000500000
    allocate_totalintegerSum of of the total allocated funding associated with the project within the City's budget.0%01000000500000
    commit_ccnonexemptfloatSum of City committed funding (Non-Exempt) associated with the project within in the City's budget.0%01000001000000
    commit_ccexemptfloatSum of City committed funding (Exempt) with the project within in the City's budget.0%0.00500001750000
    commit_citycostfloatSum of City committed funding associated with the project within in the City's budget.0%0.001100000
    commit_nccstateintegerSum of State committed funding associated with the project within in the City's budget.0%050000010000000
    commit_nccfederalfloatSum of Federal committed funding associated with the project within in the City's budget.0%06703.2436976715.35
    commit_nccotherfloatSum of Other committed funding associated with the project within in the City's budget.0%0575007500
    commit_noncitycostfloatSum of Non-City committed funding associated with the project within in the City's budget.0%0575007500
    commit_totalfloatSum of of the total committed funding associated with the project within the City's budget.0%0.001100000
    spent_ccnonexemptfloatSum of City funding spent (Non-Exempt) associated with the project within in the City's budget.0%01000001000000
    spent_ccexemptfloatSum of City funding spent (Exempt) with the project within in the City's budget.0%01000000350000
    spent_citycostfloatSum of City funding spent associated with the project within in the City's budget.0%01000001000000
    spent_nccstatefloatSum of State funding spent associated with the project within in the City's budget.0%05000001000000
    spent_nccfederalfloatSum of Federal funding spent associated with the project within in the City's budget.0%0500000321729.66
    spent_nccotherintegerSum of Other funding spent associated with the project within in the City's budget.0%010925001000000
    spent_noncitycostfloatSum of Non-City funding spent associated with the project within in the City's budget.0%01000000500000
    spent_totalfloatSum of of the total funding spent associated with the project within the City's budget.0%01000001000000
    spent_total_checkbooknycfloatSum of check values from Checkbook NYC associated with the project.0%0100000073876.78