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 - Adpt\Prel

e4p3-6ecrCity Government12 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 Adopted and Preliminary reports, published by July 1 and January or February respectively, contain the current fiscal year plus four out years of data which coincide with the release of the published financial plan.
View on NYC Open Data↗

Quality

B88.0 / 100

From a 500-row sample across 12 columns.

completeness100/ 25% weight
consistency58/ 20% weight
accuracy93/ 20% weight
timeliness92/ 15% weight
usability95/ 20% weight

Related datasets

  • Expense Financial Plan - Exec0.53
    joins onagency_name
  • Expense Financial Plan - Qtr10.52
    joins onagency_name
  • Expense Budget-Debt Service Agency OTPS Detail0.42
  • Expense Budget--Miscellaneous Expense by Category0.41
  • Expense Actuals0.37
  • Expense Budget--Debt Service Statement II0.37
  • Expense Budget Funding - All Source0.35

Sample rows

pub_dateagency_cdrpt_sortagency_namelinenolineno_dscyr1_fyyear1_frcstyear2_amtyear3_amtyear4_amtyear5_amt
2026063001111704President,Borough of the Bronx704Total Department202672867215654765476547
20260630014

Columns

12 queryable · 12 profiled

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

FieldTypeDescriptionNullValues
pub_dateintegerWhen data is made available for public review as legally required.0%201802012017012420200630
agency_cdtext3-digit code which identifies an agency (e.g. 056 is the Police Department).0%846126850
rpt_sortintegerSequence of report0%10272282072613704
agency_nametextDescriptive name associated with the 3-digit code (e.g. "Mayoralty, Board of Elections, Law Department").0%City CouncilPublic Administrator - B…

Query this from your own app

GET /api/datasets/e4p3-6ecr
GET /api/datasets/e4p3-6ecr/quality
GET /api/datasets/e4p3-6ecr/related
GET /api/columns?dataset=e4p3-6ecr
joins onagency_name
  • Asset Management Executive Summary - State of Good Repair Needs (Expense)0.35
    joins onpub_date
  • 14704
    President,Borough of S.I.
    704
    Total Department
    2026
    5545
    5248
    4957
    4957
    4957
    202606300044704Campaign Finance Board704Total Department2026102381104409140821409914116
    2026063001010704President,Borough of Manhattan704Total Department202663246079565056505650
    2026063001212704President,Borough of Brooklyn704Total Department202681217885700970097009
    2026063001313704President,Borough of Queens704Total Department202681596774592259225922
    202606300022704Mayoralty704Total Department2026187148198938194816192240192241
    202606300033704Board of Elections704Total Department2026273814212331149873149873149873
    202606300088704Office of the Actuary704Total Department202674328484848484848484
    2026063001515704Office of the Comptroller704Total Department2026130930135705136191135997136038
    Citywide Pension Contrib…
    linenointeger—0%710727726
    lineno_dsctext—0%Federal - OtherOther CategoricalIntra-City Other
    yr1_fycategorical—0%202620202018of 11
    year1_frcstinteger—0%03-400000
    year2_amtinteger—0%03176
    year3_amtinteger—0%0555193
    year4_amtinteger—0%01110383
    year5_amtinteger—0%01665573