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) - Commitments

djxg-kcfiCity Government22 columns
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 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

A92.6 / 100

From a 500-row sample across 22 columns.

completeness100/ 25% weight
consistency77/ 20% weight
accuracy94/ 20% weight
timeliness96/ 15% weight
usability95/ 20% weight

Related datasets

  • Capital Projects Database (CPDB) - Projects0.61
    joins ontotalplannedcommitmagencynccother+8
  • Capital Projects Database (CPDB) - Projects (Points)0.59
    joins onmagencyccpversionprojectid+1
  • Capital Projects Database (CPDB) - Projects (Polygons)0.58
    joins onmagencyccpversionprojectid+1
  • Revenue Budget & Financial Plan--Qtr10.37
  • Civil Service List (Terminated)0.34

Sample rows

ccpversionmaprojidmagencyprojectidprojectdescriptionsagencyacrosagencynamebudgetlineprojecttypeplancommdatecommitmentdescriptioncommitmentcode
fisa_2026850AGMBDXVAN850AGMBDXVANMBD COMMUNITY HOUSING CORPORATION VANS FOR SENIOR ACTIVITIESDFTADepartment for the AgingAG-DN04LAging2027-06-01T00:00:00.000EQUIPMENT AND FURNITUREEQFN

Columns

22 queryable · 22 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%846P-6TREPLS040SCA26826SE-EMRNGY
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%850846826
projectidtextAlphanumeric code created by the sponsor agency that identifies a distinct project. A Project ID must be unique within a managing agency.0%

Query this from your own app

GET /api/datasets/djxg-kcfi
GET /api/datasets/djxg-kcfi/quality
GET /api/datasets/djxg-kcfi/related
GET /api/columns?dataset=djxg-kcfi
  • Capital Project Detail Data - Milestones0.33
  • Expense Budget0.32
  • Capital Project Detail Data - Dollars0.31
    • fisa_2026125AGUPGRADE125AGUPGRADEAging Computer UpgradeDFTADepartment for the AgingAG-0002Aging2031-06-01T00:00:00.000EQUIPMENT AND FURNITUREEQFN
    fisa_2026125AGVARSRCT125AGVARSRCTREHABILITATION OF VARIOUS SENIOR CENTERSDFTADepartment for the AgingAG-0001Aging2032-06-01T00:00:00.000CONSTRUCTIONCONS
    fisa_2026125AGVARSRCT125AGVARSRCTREHABILITATION OF VARIOUS SENIOR CENTERSDFTADepartment for the AgingAG-0001Aging2035-06-01T00:00:00.000EQUIPMENT AND FURNITUREEQFN
    fisa_2026125AGVARSRCT125AGVARSRCTREHABILITATION OF VARIOUS SENIOR CENTERSDFTADepartment for the AgingAG-0001Aging2033-06-01T00:00:00.000EQUIPMENT AND FURNITUREEQFN
    fisa_2026125AGVARSRCT125AGVARSRCTREHABILITATION OF VARIOUS SENIOR CENTERSDFTADepartment for the AgingAG-0001Aging2031-06-01T00:00:00.000EQUIPMENT AND FURNITUREEQFN
    fisa_2026125AGVARSRCT125AGVARSRCTREHABILITATION OF VARIOUS SENIOR CENTERSDFTADepartment for the AgingAG-0001Aging2030-06-01T00:00:00.000EQUIPMENT AND FURNITUREEQFN
    fisa_2026125AGVARSRCT125AGVARSRCTREHABILITATION OF VARIOUS SENIOR CENTERSDFTADepartment for the AgingAG-0001Aging2029-06-01T00:00:00.000EQUIPMENT AND FURNITUREEQFN
    fisa_2026125AGVARSRCT125AGVARSRCTREHABILITATION OF VARIOUS SENIOR CENTERSDFTADepartment for the AgingAG-0001Aging2028-06-01T00:00:00.000EQUIPMENT AND FURNITUREEQFN
    fisa_2026125AGVARSRCT125AGVARSRCTREHABILITATION OF VARIOUS SENIOR CENTERSDFTADepartment for the AgingAG-0001Aging2027-06-01T00:00:00.000EQUIPMENT AND FURNITUREEQFN

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

    SCA26P-6TREPLSSE-EMRNGY
    projectdescriptiontextShort description of the project as described by the sponsor agency. If one projectid had many descriptions the longest description is reported by CPDB.0%Emergency Reconstruction…Emergency Sewer Lining C…JOB ORDER CONTRACTING WO…
    sagencyacrotextCommon acronym of the city agency sponsoring the planned commitment. This value is derived from the budget line.0%DPRDEPDOT
    sagencynametextCommon name for the city agency sponsoring the planned commitment. This value is derived from the budget line.0%Department of Parks and …Department of Environmen…Department of Transporta…
    budgetlinetextUnique identifier of the budget used to fund the project.0%P-I001P-1018WP-0112
    projecttypetextShort description of the type of project based on the budget funding the project.0%Parks and RecreationHighwaysCultural Affairs
    plancommdatedatetimeMonth and year of when the planned commitment is projected to be committed.0%2026-06-01T00:00:00.0002027-06-01T00:00:00.0002028-06-01T00:00:00.000
    commitmentdescriptioncategoricalShort description of what the planned commtiment will specifically fund. Not all commitments have descriptions.0%CONSTRUCTIONEQUIPMENT AND FURNITUREIFA CONSTRUCTION SUPERVI…of 14
    commitmentcodecategoricalFour letter or digit code indicating what part of the planned commitment the associated funding is for, such as design, construction, or contingency.0%CONSEQFNIFSPof 14
    typctextClassification 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.0%NFPRECREH
    typcnametextTen year plan category (typc) the planned commitment supports.0%Neighborhood Parks, Play…ESSENTIAL RECONSTRUCTION…PRIMARY STREET RECONSTRU…
    ccnonexemptintegerSum of City funding (Non-Exempt) associated with the planned commitment in the Capital Commitment Plan.0%01000500000
    ccexemptintegerSum of City funding (Exempt) associated with the planned commitment in the Capital Commitment Plan.0%05000001000000
    totalcityplannedcommitintegerSum of City funding associated with the planned commitment the Capital Commitment Plan.0%05000001000000
    nccstateintegerSum of State funding associated with the planned commitment in the Capital Commitment Plan.0%05000001000
    nccfederalintegerSum of Federal funding associated with the planned commitment in the Capital Commitment Plan.0%0100040000000
    nccotherintegerSum of Other funding associated with the planned commitment in the Capital Commitment Plan.0%010002000
    totalnoncityplannedcommitintegerSum of Non-City funding associated with the planned commitment in the Capital Commitment Plan,0%010002000
    totalplannedcommitintegerSum of of the total planned commitments in in the Capital Commitment Plan.0%05000001000000