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 - Qtr1

sqmu-2ixdCity Government11 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 Quarter 1 report, published in October or November, contain the current fiscal year plus three out years of data which coincide with the release of the published financial plan.
View on NYC Open Data↗

Quality

B85.0 / 100

From a 500-row sample across 11 columns.

completeness100/ 25% weight
consistency59/ 20% weight
accuracy93/ 20% weight
timeliness71/ 15% weight
usability95/ 20% weight

Related datasets

  • Expense Financial Plan - Exec0.63
    joins online_numberyear_4_estimateyear_3_estimate+8
  • Expense Financial Plan - Adpt\Prel0.52
    joins onagency_name
  • Revenue Budget & Financial Plan--Qtr10.45
    joins onpublication_dateagency_nameagency_number
  • Financial Plan Statements - Obligation0.35
  • Capital Plan Funding Source0.35

Sample rows

publication_dateagency_numberreport_sortagency_nameline_numberline_number_descriptionfiscal_year_1year_1_forecastyear_2_estimateyear_3_estimateyear_4_estimate
201611170022704Mayoralty704 704 Total Department2017136644138424136603132522
20161117002

Columns

11 queryable · 11 profiled

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

FieldTypeDescriptionNullValues
publication_datecategorical—0%202511172023111620241120of 10
agency_numbertext—0%132992126
report_sortinteger—0%3872690671195710
agency_nametext—0%Citywide Pension Contrib…Public Administrator - B…City Council

Query this from your own app

GET /api/datasets/sqmu-2ixd
GET /api/datasets/sqmu-2ixd/quality
GET /api/datasets/sqmu-2ixd/related
GET /api/columns?dataset=sqmu-2ixd
Financial Plan Baseline & Initiatives By Funding
0.35
joins onagency_name
  • Financial Plan Statements - Revenue0.33
  • Financial Plan Statements - Cash Flow0.33
  • 2705
    Mayoralty
    705
    705 Salaries and Wages
    2017
    104380
    101670
    101126
    100130
    201611170022706Mayoralty706 706 Fringe Benefits2017272176176176
    201611170022707Mayoralty707 707 Total Personal Service2017104652101846101302100306
    201611170022708Mayoralty708 708 City Funds201775925782797844977453
    201611170022709Mayoralty709 709 Other Categorical20174746446244364436
    201611170022710Mayoralty710 710 Capital Funds-I.F.A.201711993121311213112131
    201611170022711Mayoralty711 711 State2017279273273273
    201611170022713Mayoralty713 713 Federal - C.D.20176268332133283328
    201611170022714Mayoralty714 714 Federal - Other201731851114419419
    line_number
    integer
    —
    0%
    707727726
    line_number_descriptiontext—0%Intra-City OtherStateOther Categorical
    fiscal_year_1categorical—0%202120182025of 8
    year_1_forecastinteger—0%03176
    year_2_estimateinteger—0%0355519
    year_3_estimateinteger—0%01110381000000
    year_4_estimateinteger—0%01665571000000