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

Expense Financial Plan - Exec

x5tk-fa54City Government15 columns
This dataset contains agency summary level data for PS, OTPS and Total by type of funds. The dollar amount fields are rounded to the thousands. The Executive Budget report, published in April or May, contains previous fiscal year actuals, the current fiscal year Executive budget, eight month actuals and forecast plus four out years of data which coincide with the release of the published financial plan.
View on NYC Open Data↗

Quality

B82.8 / 100

From a 500-row sample across 15 columns.

completeness87/ 25% weight
consistency57/ 20% weight
accuracy88/ 20% weight
timeliness87/ 15% weight
usability95/ 20% weight

Related datasets

  • Expense Financial Plan - Qtr10.63
    joins onagency_numberfiscal_year_1report_sort+8
  • Expense Financial Plan - Adpt\Prel0.53
    joins onagency_name
  • Expense Actuals0.38
  • Expense Budget-Debt Service Agency OTPS Detail0.38
  • Expense Budget--Miscellaneous Expense by Category0.38
  • Expense Actuals By Funding Source0.36

Sample rows

publication_dateagency_numberreport_sortagency_nameline_numberline_number_descriptionfiscal_year_1year_1_executive_budyear_1_forecastyear_2_estimateyear_3_estimateyear_4_estimate
20260512103103720City Clerk720City Funds202613274132160216021602
20260512

Columns

15 queryable · 15 profiled

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

FieldTypeDescriptionNullValues
publication_datecategorical—0%202204262020041620160426of 11
agency_numbertext—0%846841806
report_sortinteger—0%567086972063707
agency_nametext—0%Dept of Parks and Recrea…MayoraltyMiscellaneous
line_number

Query this from your own app

GET /api/datasets/x5tk-fa54
GET /api/datasets/x5tk-fa54/quality
GET /api/datasets/x5tk-fa54/related
GET /api/columns?dataset=x5tk-fa54
  • Expense Budget Funding - All Source0.35
    joins onagency_numberagency_namepublication_date
  • Expense Budget--Debt Service Statement II0.34
  • 858
    858710
    D.O.I.T.T.
    710
    Capital Funds-I.F.A.
    2026
    2319
    2319
    —
    —
    —
    2026051205858735Office of Community Safety735Federal - Other2026———20832083
    20260512103103719City Clerk719Total O.T.P.S.202613274132160216021602
    20260512826826709Dept of Environmental Prot.709Other Categorical2026—1051———
    20260512858858709D.O.I.T.T.709Other Categorical20261933126126126126
    2026051201717723Dept. of Emergency Management723State202616753250———
    2026051205656723Police Department723State20268826804888888
    20260512103103718City Clerk718Other O.T.P.S.202613274132160216021602
    20260512858858713D.O.I.T.T.713Federal - C.D.2026510510255255255

    Showing 12 of 15 columns. All of them are listed below.

    integer
    —
    0%
    704728729
    line_number_descriptiontext—0%City FundsStateIntra-City Other
    fiscal_year_1categorical—0%202220202016of 11
    prior_year_actualinteger—14%0217
    year_1_executive_budinteger—3%0316
    year_1_actualinteger—14%023
    year_1_forecastinteger—1%050000-400000
    year_2_estimateinteger—3%03176
    year_3_estimateinteger—3%0555191000000
    year_4_estimateinteger—3%01110381000000
    year_5_estimateinteger—3%01665571000000