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 and Spend by Fiscal Year

gyhf-rsr3City Government8 columns
All major capital infrastructure projects with a committed budget and spend by fiscal year. Financial information and agency schedule details for each project are joined via FMS ID. Only projects in the design phase or later have project schedules displayed. This dataset is part of the Capital Projects Dashboard . Note: Each row is uniquely identified by its Financial Management Service (FMS) ID. FMS ID is the unique ID that OMB uses for the FMS (Financial Information System). This ID can be universally joined with any OMB dataset that has the same field. The Capital Projects Dashboard is the result of joining OMB’s fiscal data with the agency’s schedule data. FMS IDs and agency projects don't always have a one-to-one relationship (ie. one project schedule may correlate to multiple FMS IDs, and one FMS may correct to multiple projects with different schedules).
View on NYC Open Data↗

Quality

B87.3 / 100

From a 500-row sample across 8 columns.

completeness93/ 25% weight
consistency63/ 20% weight
accuracy94/ 20% weight
timeliness92/ 15% weight
usability95/ 20% weight

Related datasets

  • Capital Projects Dashboard - Citywide Budget and Schedule0.70
    joins onreporting_periodmanaging_agencyfms_id
  • Capital Projects Dashboard - Citywide Budget Spend History and Variance0.60
    joins onmanaging_agencyfms_id
  • Capital Projects Dashboard - Citywide Schedule History and Variance0.55
    joins onreporting_periodmanaging_agency
  • Mayor's Management Report Spending and Budget0.37
  • Preliminary Mayor's Management Report Spending and Budget0.35
  • Agency Spending by Budget Function

Sample rows

reporting_periodmanaging_agencyfms_idfiscal_yeartotal_budget_city_non_citycitynon_city
202305ACSACSPDF20230.000.000.00
202305ACSACSPDF20241525000.00763000.00762000.00
202305ACSACSPDF2025

Columns

8 queryable · 8 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)0%202605202601202505of 10
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%C519HW34907HW349LUM
fiscal_yeartextOne-year accounting period0%

Query this from your own app

GET /api/datasets/gyhf-rsr3
GET /api/datasets/gyhf-rsr3/quality
GET /api/datasets/gyhf-rsr3/related
GET /api/columns?dataset=gyhf-rsr3
0.34
  • Local Law 83 - City Agency Advertising Spend0.34
    joins onfiscal_year
  • Local Law 83 – FY 2020-2022 Historical Ethnic and Community Media Agency Ad Spend by Agency0.32
    joins onfiscal_year
  • 2132000.00
    2132000.00
    0.00
    202305ACSACSPDF20261571000.001083000.00488000.00
    202305ACSACSPDF20271746000.001746000.000.00
    202305ACSACSPDF20309820000.009820000.000.00
    202305ACSACSPDF20319823000.009823000.000.00
    202305ACSACSPDF203220191000.0020191000.000.00
    202305ACSACSPDF203320000000.0020000000.000.00
    202305ACSBXELEVFAR20241284000.001284000.000.00
    2024
    2023
    2025
    total_budget_city_non_cityintegerThe total cost of the project, as reflected by ""Commitments"" in the City's Financial Management System (FMS) and in the https://data.cityofnewyork.us/d/fb86-vt7u dataset’s ""Total Budget"" column1%0.0050000.00100000.00
    cityintegerTotal planned expenditures for the project funded by the City1%0.0050000.00100000.00
    non_cityintegerTotal planned expenditures for the project funded by sources other than the City1%0.001000.00500000.00
    spendfloatThe amount of money spent, as reflected by "Liquidations" in the City's Financial Management System (FMS)32%0.0050000.0025000.00