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

New York City Pension Expenses

95bz-ea2tCity Government4 columns
The dataset illustrates the breakdown of total pension expenses for New York City into three categories: City Actuarial Systems, Non-City Systems and Non-Actuarial Systems. Data is reported in units of thousands. Updates are posted two times per year, in Financial Plan Detail for January Plan and in Message of the Mayor for Executive Plan.
View on NYC Open Data↗

Quality

B87.5 / 100

From a 210-row sample across 4 columns.

completeness100/ 25% weight
consistency63/ 20% weight
accuracy100/ 20% weight
timeliness87/ 15% weight
usability85/ 20% weight
  • · No obvious temporal column — limits time-series joins

Related datasets

  • CUNY Community College Expenditures By Source0.46
    joins onamtpub_dtfisc_yr
  • DOE Funding Sources0.46
    joins onamtpub_dtfisc_yr
  • New York City Employment Forecast0.44
    joins onpub_dt
  • Expense Actuals By Funding Source0.43
    joins onamtpub_dtfisc_yr
  • CDBG-DR Reimbursements Over Time0.38
    joins onpub_dt

Sample rows

pub_dtpnsn_sysfisc_yramt
20200116City Actuarial Systems20209733181
20200116City Actuarial Systems20219827428
20200116City Actuarial Systems202210304426
20200116City Actuarial Systems202310338237
20200116City Actuarial Systems2024

Columns

4 queryable · 4 profiled

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

FieldTypeDescriptionNullValues
pub_dtcategorical8-digit number for date of publication0%202301122020041620250501of 14
pnsn_syscategoricalBreakdown of pension systems into three categories: City Actuarial Systems, Non-City Systems and Non-Actuarial Systems0%Non-ActuarialNon-City SystemsCity Actuarial Systemsof 3
fisc_yrcategorical4-digit to identify fiscal year of data observation0%202620252024of 11
amtintegerThe pension expenses for each category in the given fiscal year0%

Query this from your own app

GET /api/datasets/95bz-ea2t
GET /api/datasets/95bz-ea2t/quality
GET /api/datasets/95bz-ea2t/related
GET /api/columns?dataset=95bz-ea2t
  • COVID-19 Revenue Report (Historical)0.38
    joins onpub_dt
  • Additional Costs Allocation0.37
    joins onpub_dtfisc_yr
  • IBO Federal Stimulus Budget and Spending Tracker (ARPA and CRRSAA)0.27
    • 9988679
    20200116Non-City Systems202098034
    20200116Non-City Systems2021111424
    20200116Non-City Systems2022117305
    20200116Non-City Systems2023119247
    20200116Non-City Systems2024122871
    350108120108230