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 Actuals

7yay-m4aeCity Government7 columns
This dataset contains agency summary level data for total and city funded expense actuals. The dollar amount fields are rounded to thousands.
View on NYC Open Data↗

Quality

B82.6 / 100

From a 500-row sample across 6 columns.

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

Related datasets

  • Expense Actuals By Funding Source0.44
    joins onpub_dtagy_nmfisc_yr+1
  • Expense Financial Plan - Qtr10.41
  • Expense Financial Plan - Exec0.38
  • Expense Financial Plan - Adpt\Prel0.37
  • Expense Budget--Miscellaneous Expense by Category0.37
    joins onpub_dtagy_nmfisc_yr+1
  • Hurricane Sandy Expense and Capital Estimate by Agency0.35

Sample rows

pub_dtfisc_yragy_cdagy_nmall_fndcty_fnd
201711302011991General Reserve00
201711302002858D.O.I.T.T.17095153506
201711302008817Dept of Mental Health00
201711302009

Columns

7 queryable · 7 profiled

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

FieldTypeDescriptionNullValues
pub_dtcategorical—0%2017113020171201of 2
fisc_yrcategorical—0%201320142016of 16
agy_cdtext—0%002003004
agy_nmtext—0%City CouncilPublic Administrator - B…Civil Service Commission
all_fndinteger

Query this from your own app

GET /api/datasets/7yay-m4ae
GET /api/datasets/7yay-m4ae/quality
GET /api/datasets/7yay-m4ae/related
GET /api/columns?dataset=7yay-m4ae
joins on
pub_dt
agy_nm
fisc_yr
  • DOE Funding Sources0.33
    joins onpub_dtfisc_yr
  • Expense Budget-Debt Service Agency OTPS Detail0.33
    joins onpub_dtagy_nmfisc_yr+1
    • 991
    General Reserve
    0
    0
    201711302008819Health + Hospitals256837128181
    201711302002100M.A.C. Debt Service462900462900
    201711302002101Public Advocate28212821
    201711302002102City Council4729947094
    201711302002103City Clerk27272650
    201711302002125Department for the Aging231227166267
    —
    0%
    0421344
    cty_fndinteger—0%0421830
    remarktext—100%—