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 Budget Spend History and Variance

qj5n-h5qpCity Government8 columns
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 .
View on NYC Open Data↗

Quality

B88.6 / 100

From a 500-row sample across 8 columns.

completeness95/ 25% weight
consistency63/ 20% weight
accuracy97/ 20% weight
timeliness93/ 15% weight
usability95/ 20% weight

Related datasets

  • Capital Projects Dashboard - Citywide Budget and Spend by Fiscal Year0.60
    joins onfms_idmanaging_agency
  • Capital Projects Dashboard - Citywide Schedule History and Variance0.59
    joins onmanaging_agency
  • Capital Projects Dashboard - Citywide Budget and Schedule0.46
    joins onspend_to_date_1fms_idspend_to_date+2
  • Mayor's Management Report Spending and Budget0.39
  • Preliminary Mayor's Management Report Spending and Budget0.38
  • Local Law 83 - City Agency Advertising Spend

Sample rows

managing_agencyfms_idyear_month_reportedtotal_budgetspend_to_datespend_to_date_1budget_variancebudget_variance_1
NYRLL23LPAFAS2023053000000.00————
NYRLL23LPAFAS2023053000000.000.000.000.000.00
NYRL

Columns

8 queryable · 8 profiled

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

FieldTypeDescriptionNullValues
managing_agencytextCommon 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%DPRDDCDOT
fms_idtextUnique identifier in the Financial Management System (FMS)0%HWXS711HWQ1209SER200285
year_month_reportedintegerThe year and the month the budget spend data was recorded0%202605202601202509
total_budgetintegerThe total cost of the project, as reflected by "Commitments" in the City's Financial Management System (FMS)0%

Query this from your own app

GET /api/datasets/qj5n-h5qp
GET /api/datasets/qj5n-h5qp/quality
GET /api/datasets/qj5n-h5qp/related
GET /api/columns?dataset=qj5n-h5qp
0.33
  • CDBG-DR Program Categories0.33
  • Agency Spending by Budget Function0.32
    • L23LPAFAS
    202309
    3000000.00
    0.00
    0.00
    0.00
    0.00
    NYRLL23LPAFAS2024013000000.000.000.000.000.00
    NYRLL23LPAFAS2024053000000.000.000.000.000.00
    NYRLL23LPAFAS2024093000000.000.000.000.000.00
    NYRLL23LPAFAS2025013002000.000.000.002000.000.0006
    NYRLL23LPAFAS2025053002000.000.000.000.000.00
    NYRLL23LPAFAS2025093002000.000.000.000.000.00
    NYRLL23LPAFAS2026013002000.000.000.000.000.00
    0.001000000.00500000.00
    spend_to_datefloatThe amount of money spent to date, as reflected by "Liquidations" in the City's Financial Management System (FMS)8%0.00100000.0025000.00
    spend_to_date_1floatThe 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 (%).8%0.001.000.9999
    budget_varianceintegerThis is the difference calculated by 'total budget of current row ' value subtracted by the same column of prior nearest Year-Month reported.11%0.0050000.00100000.00
    budget_variance_1floatThis is the percentage calculated by 'total budget of current row ' value subtracted by the same column of prior nearest Year-Month reported, then divided by the same column of prior nearest Year-Month reported value.12%0.00-1.00-0.0001