From a 500-row sample across 52 columns.
| ccpversion | maprojid | magencyacro | magency | magencyname | description | projectid | mindate | maxdate | typecategory | plannedcommit_ccnonexempt | plannedcommit_ccexempt |
|---|---|---|---|---|---|---|---|---|---|---|---|
| fisa_2026 | 850GKOH15-01 | DDC | 850 | Department of Design and Construction | GI - GREEN INFRASTRUCTURE IN OH-015 GRAVESEND BAY CSO PH 1 | GKOH15-01 | 2018-04-03T00:00:00.000 | 2028-06-01T00:00:00.000 | Fixed Asset | 1854000 | 76389000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
ccpversion | text | Reports the version of the Capital Commitment Plan which the record is based on. | 0% | fisa_2026of 1 |
maprojid | text | Unique identifier that defines a discrete project. The maprojid is a concatenation of magency and projectid and it is the primary key. | 0% | 801HUDSONGUI806RBEND850SEBLQX01 |
magencyacro | text | Common acronym of the city agency managing the project. This value is derived from the three digit managing agency code. | 0% | DPRDDCSBS |
magency | text | Three 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% |
GET /api/datasets/9jkp-n57r GET /api/datasets/9jkp-n57r/quality GET /api/datasets/9jkp-n57r/related GET /api/columns?dataset=9jkp-n57r
| fisa_2026 | 125HAM14CRSR | DFTA | 125 | Department for the Aging | CARVER HOUSES SENIOR CENTER COMPUTER LAB | HAM14CRSR | 2027-06-01T00:00:00.000 | 2031-06-01T00:00:00.000 | Fixed Asset | 100000 | 0.0 |
| fisa_2026 | 035LRCE12DOT | NYRL | 035 | New York Research Libraries | SASB:Improvements to the NYPL Vicinity | LRCE12DOT | 2028-06-01T00:00:00.000 | 2031-06-01T00:00:00.000 | — | 0.0 | 0.0 |
| fisa_2026 | 850HWX413 | DDC | 850 | Department of Design and Construction | Hunts Point Avenue | HWX413 | 2026-03-09T00:00:00.000 | 2031-06-01T00:00:00.000 | — | 38836000 | 0.0 |
| fisa_2026 | 850HWQ1182B | DDC | 850 | Department of Design and Construction | Broad Channel Bulkheads - Phase II (SEQ200586) | HWQ1182B | 2016-08-08T00:00:00.000 | 2033-06-01T00:00:00.000 | Fixed Asset | 6170000 | 31000 |
| fisa_2026 | 850HWTRR1 | DDC | 850 | Department of Design and Construction | Trench Restoration - Staten Island (SER002333) | HWTRR1 | 2019-06-06T00:00:00.000 | 2032-06-01T00:00:00.000 | Fixed Asset | 4796000 | 0.0 |
| fisa_2026 | 850HWQ1190A | DDC | 850 | Department of Design and Construction | Reconstruction of Queens Blvd Phase 1 (QED-1042A) | HWQ1190A | 2017-04-26T00:00:00.000 | 2030-06-01T00:00:00.000 | Fixed Asset | 90536000 | 0.0 |
| fisa_2026 | 850SEK200387 | DDC | 850 | Department of Design and Construction | Installation for tidegate on 9'6" x 5' sewer at Ave K BKLYN | SEK200387 | 2024-12-16T00:00:00.000 | 2027-07-01T00:00:00.000 | Fixed Asset | 2171000 | 0.0 |
| fisa_2026 | 850P-3RANDAL | DDC | 850 | Department of Design and Construction | Randall's Island Infrastructure, Roadways, Drainage, & CS | P-3RANDAL | 2017-02-02T00:00:00.000 | 2027-06-01T00:00:00.000 | Fixed Asset | 39566000 | 0.0 |
| fisa_2026 | 801PASSSHIP4 | SBS | 801 | Department of Small Business Services | Manhattan Cruise Terminal - Viaduct Concrete Rehabilitation | PASSSHIP4 | 2013-05-06T00:00:00.000 | 2033-06-01T00:00:00.000 | Fixed Asset | 0.0 | 0.0 |
Showing 12 of 52 columns. All of them are listed below.
846850801magencyname | text | Common 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…Department of Small Busi… |
description | text | Short description of the project as described by the sponsor agency. If one projectid had many descriptions the longest description is reported by CPDB. | 0% | SAFE ROUTES TO SCHOOLS-9…GATEWAYS TO CHINATOWNBrooklyn Academy of Musi… |
projectid | text | Alphanumeric code created by the sponsor agency that identifies a distinct project. A Project ID must be unique within a managing agency. | 0% | HWQ100SBBP-216BRCPP-412BPP1 |
mindate | datetime | The earliest panned commitment date associated with the project. | 0% | 2026-06-01T00:00:00.0002028-06-01T00:00:00.0002027-06-01T00:00:00.000 |
maxdate | datetime | The latest panned commitment date associated with the project. | 0% | 2028-06-01T00:00:00.0002030-06-01T00:00:00.0002026-06-01T00:00:00.000 |
typecategory | categorical | Classification 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. | 6% | Fixed AssetITT, Vehicles, and Equip…Lump Sumof 3 |
plannedcommit_ccnonexempt | integer | Sum of City Cost (Non-Exempt) funding across all commitments associated with the project. | 0% | 0.010001000000 |
plannedcommit_ccexempt | integer | Sum of City Cost (Exempt) funding across all commitments associated with the project. | 0% | 0.0100000200000 |
plannedcommit_citycost | integer | Sum of City funding across all commitments associated with the project. | 0% | 0.010001000000 |
plannedcommit_nccstate | integer | Sum of State funding across all commitments associated with the project. | 0% | 0.0100000036000 |
plannedcommit_nccfederal | integer | Sum of Federal funding across all commitments associated with the project. | 0% | 0.010000003000 |
plannedcommit_nccother | integer | Sum of Other funding across all commitments associated with the project. | 0% | 0.010002000 |
plannedcommit_noncitycost | integer | Sum of Non-City funding across all commitments associated with the project. | 0% | 0.010000001000 |
plannedcommit_total | integer | Sum of City Cost and Non-City Cost, which reports the total planned commitments for the project allocated in the Capital Commitment Plan. | 0% | 0.010001000000 |
adopt_ccnonexempt | integer | Sum of City adopted funding (Non-Exempt) associated with the project within in the City's budget. | 0% | 0.020000001000000 |
adopt_ccexempt | integer | Sum of City adopted funding (Exempt) with the project within in the City's budget. | 0% | 0.01560001548000 |
adopt_citycost | integer | Sum of City adopted funding associated with the project within in the City's budget. | 0% | 0.05000001000000 |
adopt_nccstate | integer | Sum of State adopted funding associated with the project within in the City's budget. | 0% | 0.0200000500000 |
adopt_nccfederal | integer | Sum of Federal adopted funding associated with the project within in the City's budget. | 0% | 0.0100000010000000 |
adopt_nccother | integer | Sum of Other adopted funding associated with the project within in the City's budget. | 0% | 0.040006000 |
adopt_noncitycost | integer | Sum of Non-City adopted funding associated with the project within in the City's budget. | 0% | 0.01000000200000 |
adopt_total | integer | Sum of of the total adopted funding associated with the project within the City's budget. | 0% | 0.010000002000000 |
allocate_ccnonexempt | integer | Sum of City allocated funding (Non-Exempt) associated with the project within in the City's budget. | 0% | 0.010000002000000 |
allocate_ccexempt | float | Sum of City allocated funding (Exempt) with the project within in the City's budget. | 0% | 0.0103283.91175330.81 |
allocate_citycost | integer | Sum of City allocated funding associated with the project within in the City's budget. | 0% | 0.010000002000000 |
allocate_nccstate | float | Sum of State allocated funding associated with the project within in the City's budget. | 0% | 0.0500000200000 |
allocate_nccfederal | float | Sum of Federal allocated funding associated with the project within in the City's budget. | 0% | 0.010000005000000 |
allocate_nccother | float | Sum of Other allocated funding associated with the project within in the City's budget. | 0% | 0.01000500.0 |
allocate_noncitycost | float | Sum of Non-City allocated funding associated with the project within in the City's budget. | 0% | 0.01000500.0 |
allocate_total | integer | Sum of of the total allocated funding associated with the project within the City's budget. | 0% | 0.010000002000000 |
commit_ccnonexempt | float | Sum of City committed funding (Non-Exempt) associated with the project within in the City's budget. | 0% | 0.022900082870.0 |
commit_ccexempt | float | Sum of City committed funding (Exempt) with the project within in the City's budget. | 0% | 0.015067400.023228070.1 |
commit_citycost | float | Sum of City committed funding associated with the project within in the City's budget. | 0% | 0.022900082870.0 |
commit_nccstate | float | Sum of State committed funding associated with the project within in the City's budget. | 0% | 0.035384.23387073.0 |
commit_nccfederal | float | Sum of Federal committed funding associated with the project within in the City's budget. | 0% | 0.011714182.33833791.08 |
commit_nccother | float | Sum of Other committed funding associated with the project within in the City's budget. | 0% | 0.0150006000 |
commit_noncitycost | float | Sum of Non-City committed funding associated with the project within in the City's budget. | 0% | 0.015000798507.27 |
commit_total | float | Sum of of the total committed funding associated with the project within the City's budget. | 0% | 0.022900060000 |
spent_ccnonexempt | float | Sum of City funding spent (Non-Exempt) associated with the project within in the City's budget. | 0% | 0.075000100000 |
spent_ccexempt | float | Sum of City funding spent (Exempt) with the project within in the City's budget. | 0% | 0.03500001000000 |
spent_citycost | float | Sum of City funding spent associated with the project within in the City's budget. | 0% | 0.075000150000 |
spent_nccstate | float | Sum of State funding spent associated with the project within in the City's budget. | 0% | 0.0500002212000 |
spent_nccfederal | float | Sum of Federal funding spent associated with the project within in the City's budget. | 0% | 0.0990001686406.42 |
spent_nccother | float | Sum of Other funding spent associated with the project within in the City's budget. | 0% | 0.0700020000 |
spent_noncitycost | float | Sum of Non-City funding spent associated with the project within in the City's budget. | 0% | 0.0700007000 |
spent_total | float | Sum of of the total funding spent associated with the project within the City's budget. | 0% | 0.075000150000 |
spent_total_checkbooknyc | float | Sum of check values from Checkbook NYC associated with the project. | 0% | 0.0693982.79106346.7 |
the_geom | unknown | Spatial data for the project. | — | — |