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

Additional Costs Allocation

u42g-qjajCity Government9 columns
Additional agency costs for Pension, Fringe Benefits and Debt Service that are included in the Pensions, Miscellaneous Budget and Debit Service agencies. Dollars are In thousands. This data set is updated annually.
View on NYC Open Data↗

Quality

B87.3 / 100

From a 500-row sample across 9 columns.

completeness100/ 25% weight
consistency67/ 20% weight
accuracy94/ 20% weight
timeliness88/ 15% weight
usability85/ 20% weight
  • · No obvious temporal column — limits time-series joins

Related datasets

  • Expense Actuals By Funding Source0.51
    joins onfisc_yragy_nmagy_cd+1
  • Headcount Actuals By Funding Source0.50
    joins onfisc_yragy_nmagy_cd+1
  • Expense Financial Plan - Qtr10.36
  • Expense Financial Plan - Exec0.36
  • Preliminary Mayor's Management Report Agency Resources0.36
  • Preliminary Mayor's Management Report Spending and Budget0.36

Sample rows

pub_dtcst_catact_plnfisc_yragy_cdagy_nmttl_amtcity_amtic_amt
20220426Fringe BenefitsActual2021002Mayoralty26874240990
20220426Fringe BenefitsActual2021003Board of Elections26174180530

Columns

9 queryable · 9 profiled

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

FieldTypeDescriptionNullValues
pub_dtcategorical8-digit number for date of publication0%202605122025050120230426of 6
cst_catcategoricalType of Cost0%Fringe BenefitsDebt ServicePensionsof 3
act_plncategoricalActual or Planned expenditures0%ForecastExecutivePreliminaryof 4
fisc_yrcategoricalFour Digit Year0%202520242023

Query this from your own app

GET /api/datasets/u42g-qjaj
GET /api/datasets/u42g-qjaj/quality
GET /api/datasets/u42g-qjaj/related
GET /api/columns?dataset=u42g-qjaj
  • Capital Commitment Actuals0.35
    joins onfisc_yrpub_dt
  • Mayor's Management Report Spending and Budget0.35
    • 20220426Fringe BenefitsActual2021004Campaign Finance Board280326530
    20220426Fringe BenefitsActual2021008Office of the Actuary11809910
    20220426Fringe BenefitsActual2021010BP - Manhattan127211990
    20220426Fringe BenefitsActual2021011BP - Bronx135312850
    20220426Fringe BenefitsActual2021012BP - Brooklyn166215760
    20220426Fringe BenefitsActual2021013BP - Queens158715020
    20220426Fringe BenefitsActual2021014BP - Staten Island10469980
    20220426Fringe BenefitsActual2021015Comptroller20849186480
    of 8
    agy_cdtext3-digit code which identifies an agency (e.g. 056 is the Police Department).0%846850132
    agy_nmtextDescriptive name associated with the 3-digit code (e.g. "Police Department, Fire Department").0%New York Public LibraryOffice of the ActuaryDistricting Commission
    ttl_amtintegerTotal expenditures0%038498
    city_amtintegerCity Tax Levy dollars0%038498
    ic_amtintegerIntra-City dollars1%0112254114492