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 Dashboard - Citywide Schedule History and Variance

95tx-snakCity Government10 columns
This is the history all agency reported forecasts/actual project completion dates. Each row is the snapshot of data taken on each reporting period. The 'completion date type' column shows if the 'completion date' is either a forecast or actual date. Over time, a project would have one or more forecasted completion dates before it is actually completed. The 'variance' is the day difference between 'completion date' of each row and its prior reporting period. This dataset is part of the Capital Projects Dashboard .
View on NYC Open Data↗

Quality

B87.0 / 100

From a 500-row sample across 10 columns.

completeness89/ 25% weight
consistency75/ 20% weight
accuracy83/ 20% weight
timeliness93/ 15% weight
usability95/ 20% weight

Related datasets

  • Capital Projects Dashboard - Citywide Budget Spend History and Variance0.59
    joins onmanaging_agency
  • Capital Projects Dashboard - Citywide Budget and Spend by Fiscal Year0.55
    joins onreporting_periodmanaging_agency
  • Capital Projects Dashboard - Citywide Budget and Schedule0.49
    joins onreporting_periodpidcurrent_phase+2
  • Capital Projects Database (CPDB) - Projects (Polygons)0.34
  • Capital Projects Database (CPDB) - Commitments0.34
  • Capital Projects Database (CPDB) - Projects (Points)

Sample rows

reporting_periodmanaging_agencypidagency_project_namecurrent_phasecompletion_datecompletion_date_typedata_datevariance_day
202305CUNY72BKLYNC-Performing Arts CenterClose-out2018-07-03T00:00:00.000Actual2023-04-26T00:00:00.000—
202305CUNY73BARUCH-17 Lexington AvenueClose-out2016-06-01T00:00:00.000

Columns

10 queryable · 10 profiled

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

FieldTypeDescriptionNullValues
reporting_periodcategoricalThe year and the month the report is published (format YYYYMM). The dataset is updated 3 times a year following OMB’s commitment plan release date in Jan/May/Sep.0%202401202509202409of 10
managing_agencycategoricalCommon acronym of the city agency that is responsible for managing the construction and delivery of the capital project. This value is derived from the three digit managing agency code.0%DPRDDCDEPof 13
pidintegerUnique identifier that represent a set of schedule managed by agency.0%400943584233
agency_project_nametextThe name of the project in the managing agency's project management system

Query this from your own app

GET /api/datasets/95tx-snak
GET /api/datasets/95tx-snak/quality
GET /api/datasets/95tx-snak/related
GET /api/columns?dataset=95tx-snak
0.34
  • City Council Capital Budget0.33
  • DCLA Cultural Organizations Capital Funding0.33
    • Actual
    2023-04-26T00:00:00.000
    —
    202305CUNY74HTSCC-ADA WorkClose-out2010-12-20T00:00:00.000Actual2023-04-26T00:00:00.000—
    202305CUNY75HTSCC-HVAC WorkPre-Design—Forecast2023-04-26T00:00:00.000—
    202309CUNY75HTSCC-HVAC WorkPre-Design—Forecast2024-02-02T00:00:00.000—
    202401CUNY75HTSCC-HVAC WorkDesign2025-05-12T00:00:00.000Forecast2024-05-03T00:00:00.000—
    202405CUNY75HTSCC-HVAC WorkDesign2025-05-12T00:00:00.000Forecast2024-05-03T00:00:00.0000
    202409CUNY75HTSCC-HVAC WorkConstruction2025-05-12T00:00:00.000Forecast2024-11-15T00:00:00.0000
    202501CUNY75HTSCC-HVAC WorkConstruction2025-05-12T00:00:00.000Forecast2025-03-20T00:00:00.0000
    202505CUNY75HTSCC-HVAC WorkClose-out2024-06-06T00:00:00.000Actual2025-06-25T00:00:00.000-340
    0%
    FUEL TANK REPLACEMENTReconstruction of Existi…HWPR24 Series Standard P…
    current_phasecategoricalThe phase the project is in: Pre-Design, Design, Construction Procurement, Construction, or Close-out1%DesignConstructionPre-Designof 10
    completion_datedatetimeThe date when the entire project is expected to be completed or has completed (driven by 'completion date type' field.)24%2026-06-30T00:00:00.0002025-06-30T00:00:00.0002026-09-30T00:00:00.000
    completion_date_typecategoricalThis field specify if the 'completion date' is a forecast date or an actual date0%ForecastActualof 2
    variance_dayintegerThis is the difference calculated by 'completion date' of current row value subtracted by the same column of prior nearest reporting period.37%0365-1
    reason_for_forecast_completion_changecategoricalThis is the rationale provided when the forecasted completion date differs from the previously forecasted date.89%PROJECT DELAYED DUE TO C…PROJECT DELAYED PENDING …PROJECT DELAYED DUE TO B…of 13
    data_datedatetimeThe actual date this record submitted by agency0%2024-11-01T00:00:00.0002024-04-22T00:00:00.0002024-02-16T00:00:00.000