Capital Projects Dashboard - Citywide Budget Spend History and Variance
This is the history all FMS reported budget-and-spend by budget line item and reported Year-Month. Each row is the snapshot of data recorded in each reported Year-Month. The earliest snapshot represents the 'original budget' of a project. The 'budget variance' is the difference between 'total budget' of each row and its prior reported Year-Month. 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
- 53,495
- Rows at the source
- 53,495
- 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 8 columns carry a concept; 8 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 |
|---|---|---|---|---|---|---|---|---|
year_month_reported | Year-Month Reported | The year and the month the budget spend data was recorded | Not bound | Number | year_month_reported | numeric | — | |
managing_agency | Managing Agency | Common 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. | Not bound | Text | managing_agency | text | — | |
total_budget | Total Budget | The total cost of the project, as reflected by "Commitments" in the City's Financial Management System (FMS) | Not bound | Number | total_budget | numeric | — | |
spend_to_date_1 | Spend to Date % | The amount of money spent to date, as reflected by "Liquidations" in the City's Financial Management System (FMS) shown as a percentage of Total Budget (%). | Not bound | Number | spend_to_date_1 | numeric | — | |
budget_variance | Budget Variance | This is the difference calculated by 'total budget of current row ' value subtracted by the same column of prior nearest Year-Month reported. | Not bound | Number | budget_variance | numeric | — | |
fms_id | FMS ID | Unique identifier in the Financial Management System (FMS) | Not bound |
Download
This file was produced on Aug 27, 2026, 10:03 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/qj5n-h5qp
- Version
- Content hash:
b742ae812fa047db56f7ed4e345ad22b381368ec690aeb9e298b1c6a59fb513e - 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 27, 2026, 1:45 AM | full_replace | success | 53,495 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |