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

Financial Plan Statements - Capital Cashflow

4xfc-mzbgCity Government8 columns
This dataset represents the Report NO. 5A--Capital Cashflow in the Financial Plan Statement Dollars are in millions. It is updated Monthly.
View on NYC Open Data↗

Quality

B89.3 / 100

From a 500-row sample across 8 columns.

completeness100/ 25% weight
consistency69/ 20% weight
accuracy93/ 20% weight
timeliness99/ 15% weight
usability85/ 20% weight
  • · No obvious temporal column — limits time-series joins

Related datasets

  • Financial Plan Statements - Personal Service Expenditures0.58
    joins onfisc_yrmnthpub_dt
  • Financial Plan Statements - Obligation0.57
    joins onfisc_yrmnthpub_dt
  • Financial Plan Statements - Revenue0.57
    joins onfisc_yrmnthpub_dt
  • Financial Plan Statements - Revenue and Obligation Forecast0.54
    joins onfisc_yrpub_dt
  • Financial Plan Statements - Cash Flow0.52

Sample rows

pub_dtdeptmnthfisc_yrcurr_mnth_actlytd_actlfisc_yr_plnfnd
20240111TRANSITNovember20241.2171.7633.7(C)
20240111TRANSITNovember2024000(N)
20240111HIGHWAY AND STREETS

Columns

8 queryable · 8 profiled

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

FieldTypeDescriptionNullValues
pub_dttextPublication date of document on OMB's website0%202609162024041720240111
deptcategoricalProject Type0%HOUSINGPARKSSEWERSof 19
mnthcategoricalMonth of publication0%NovemberMayFebruaryof 13
fisc_yrcategorical4-digit number for fiscal year of publication0%202220252021of 6

Query this from your own app

GET /api/datasets/4xfc-mzbg
GET /api/datasets/4xfc-mzbg/quality
GET /api/datasets/4xfc-mzbg/related
GET /api/columns?dataset=4xfc-mzbg
joins on
fisc_yr
pub_dt
  • Projection of Cash Source and Use0.40
  • Capital Projects Dashboard - Citywide Budget Spend History and Variance0.37
  • Capital Projects Dashboard - Citywide Budget and Spend by Fiscal Year0.35
    • November
    2024
    18.8
    125.3
    306.2
    (C)
    20240111HIGHWAY AND STREETSNovember20242.51472.9(N)
    20240111HIGHWAY BRIDGESNovember202411.456.9154.4(C)
    20240111HIGHWAY BRIDGESNovember20241.919.876.1(N)
    20240111WATERWAY BRIDGESNovember20247.755.562.6(C)
    20240111WATERWAY BRIDGESNovember202400.333.5(N)
    20240111WATER SUPPLYNovember2024957.6218.5(C)
    20240111WATER SUPPLYNovember2024000(N)
    curr_mnth_actl
    float
    Dollars in millions reflecting this months liquidations by project type
    0%
    00.10.2
    ytd_actlfloatDollars in millions reflecting the year to date liquidations by project type0%00.10.2
    fisc_yr_plnfloatEstimated annual planned liquidations in Dollars in millions by project type0%02.917
    fndcategoricalSource of funding. (C) for City Funds (N) for Non-City Funds, Federal and Other Sources0%(C)(N)of 2