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 - Milestones

s7yh-frbmCity Government12 columns
This dataset contains capital commitment plan data by managing agency, project identification number and project schedules. 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

B81.1 / 100

From a 500-row sample across 12 columns.

completeness100/ 25% weight
consistency71/ 20% weight
accuracy99/ 20% weight
timeliness14/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Capital Project Detail Data - Dollars0.62
    joins onproject_descrproject_idboro+3
  • Capital Commitment Plan0.35
    joins onpub_date
  • Capital Budget0.33
    joins onpub_date
  • Expense Budget-Debt Service Agency OTPS Detail0.33
  • Agency Spending by Budget Function0.32
  • Expense Financial Plan - Adpt\Prel0.32

Geography

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

Sample rows

pub_dateboromanaging_agcy_cdmanaging_agcyproject_idproject_descrseq_numbertask_descriptionorig_start_dateorig_end_datetask_start_datetask_end_date
20220517CITYWIDE042CITY UNIVERSITYCA202-006ADA Compliance4BID AWARD AND REGISTER CONTRCT2006-06-01T00:00:00.0002006-09-01T00:00:00.0002006-06-01T00:00:00.0002006-09-01T00:00:00.000

Columns

12 queryable · 12 profiled

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

FieldTypeDescriptionNullValues
pub_datecategorical—0%202004162021112220210805of 14
borocategorical—0%MANHATTANBROOKLYNQUEENSof 6
managing_agcy_cdtext—0%850846826
managing_agcytext—0%DEPT OF DESIGN & CONSTRU…DEPT OF PARKS AND RECREA…DEPT ENVIRONMENTAL PROTE…

Query this from your own app

GET /api/datasets/s7yh-frbm
GET /api/datasets/s7yh-frbm/quality
GET /api/datasets/s7yh-frbm/related
GET /api/columns?dataset=s7yh-frbm
joins onpub_date
  • Expense Budget--Miscellaneous Expense by Category0.31
  • Community Boards Geographic Report0.31
    • 20220517CITYWIDE042CITY UNIVERSITYCA202-006ADA Compliance5CONSTRUCTION TO 25%2006-09-01T00:00:00.0002007-01-01T00:00:00.0002006-09-01T00:00:00.0002007-01-01T00:00:00.000
    20220517CITYWIDE042CITY UNIVERSITYCA202-006ADA Compliance6CONSTRUCTION TO 50%2007-01-01T00:00:00.0002007-05-01T00:00:00.0002007-01-01T00:00:00.0002007-05-01T00:00:00.000
    20220517CITYWIDE042CITY UNIVERSITYCA202-006ADA Compliance7CONSTRUCTION TO 75%2007-05-01T00:00:00.0002007-09-01T00:00:00.0002007-05-01T00:00:00.0002007-09-01T00:00:00.000
    20220517CITYWIDE042CITY UNIVERSITYCA202-006ADA Compliance8ORIGINAL EQUIP & FURNISHING2007-09-01T00:00:00.0002007-12-01T00:00:00.0002007-09-01T00:00:00.0002007-12-01T00:00:00.000
    20220517CITYWIDE042CITY UNIVERSITYCA202-006ADA Compliance9SUBSTANTIAL COMPLETION2007-12-01T00:00:00.0002008-02-01T00:00:00.0002007-12-01T00:00:00.0002008-02-01T00:00:00.000
    20220517CITYWIDE042CITY UNIVERSITYCA202-006ADA Compliance10PUNCHLIST COMPLETE, JOB CLOSED2008-02-01T00:00:00.0002008-03-01T00:00:00.0002008-02-01T00:00:00.0002008-03-01T00:00:00.000
    20220517CITYWIDE042CITY UNIVERSITYCA207-006CUNY Incubator Network1DEVELOP SCOPE2009-05-01T00:00:00.0002009-08-01T00:00:00.0002021-07-01T00:00:00.0002021-09-01T00:00:00.000
    20220517CITYWIDE042CITY UNIVERSITYCA207-006CUNY Incubator Network2PRELIMINARY DESIGN2009-08-01T00:00:00.0002009-12-01T00:00:00.0002021-09-01T00:00:00.0002022-01-01T00:00:00.000
    20220517CITYWIDE042CITY UNIVERSITYCA207-006CUNY Incubator Network3FINAL DESIGN2009-12-01T00:00:00.0002010-06-01T00:00:00.0002022-01-01T00:00:00.0002022-07-01T00:00:00.000
    project_id
    text
    —
    0%
    BED-806JA-179-LOH-88-L
    project_descrtext—0%JOB ORDER CONTRACTING WO…SAFE ROUTES TO SCHOOLS-9…FUEL TANK REPLACEMENT
    seq_numberinteger—0%213
    task_descriptiontext—0%PUNCHLIST COMPLETE, JOB …DEVELOP SCOPEBID AWARD AND REGISTER C…
    orig_start_datedatetime—0%2022-09-19T00:00:00.0002022-09-20T00:00:00.0002022-12-18T00:00:00.000
    orig_end_datedatetime—0%2022-09-21T00:00:00.0002022-09-20T00:00:00.0002022-09-19T00:00:00.000
    task_start_datedatetime—0%2022-09-19T00:00:00.0002022-09-20T00:00:00.0002022-09-21T00:00:00.000
    task_end_datedatetime—0%2022-09-21T00:00:00.0002022-09-20T00:00:00.0002022-09-22T00:00:00.000