Capital Projects Dashboard - Citywide Schedule History and Variance
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.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
New
- Says it updates
- Other
- Actually updates about every
- —
- Publisher last updated the data
- Jul 15, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Jul 15, 2026, 1:25 PM
- Rows in our copy
- 22,464
- Rows at the source
- 22,464
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
0 of 10 columns carry a concept; 10 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
completion_date_type | Completion Date Type | This field specify if the 'completion date' is a forecast date or an actual date | Not bound | Text | completion_date_type | text | — | |
current_phase | Current Phase | The phase the project is in: Pre-Design, Design, Construction Procurement, Construction, or Close-out | Not bound | Text | current_phase | text | — | |
agency_project_name | Agency Project Name | The name of the project in the managing agency's project management system | Not bound | Text | agency_project_name | text | — | |
variance_day | Variance (day) | This is the difference calculated by 'completion date' of current row value subtracted by the same column of prior nearest reporting period. | Not bound | Number | variance_day | numeric | — | |
data_date | Data Date | The actual date this record submitted by agency | Not bound | Calendar date | data_date | timestamp | — | |
completion_date | Completion Date | The date when the entire project is expected to be completed or has completed (driven by 'completion date type' field.) | Not bound | Calendar date | completion_date | timestamp | — |
Download
This file was produced on Aug 25, 2026, 10:10 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/95tx-snak
- Version
- Content hash:
c925c01ead1a1909114c4e89c336741226a3a28e6266645dfc1bfb13d41546f4 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Jul 15, 2026, 1:25 PM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 25, 2026, 6:31 AM | full_replace | success | 22,464 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.69 |
| Aug 7, 2026, 2:39 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.48 |