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 Budget--Debt Service Statement II

77zj-y2i9City Government10 columns
Dataset shows the funded debt outstanding and debt service payable to bondholders during the next fiscal year. Debt and Debt Service is shown by category/purpose for which the debt was issued and is further classified as to the amounts that are exempt or not exempt from the Constitutional Debt Limit. All amounts are in dollars and information is updated twice per year at the Executive and Adopted budgets.
View on NYC Open Data↗

Quality

B88.3 / 100

From a 500-row sample across 10 columns.

completeness97/ 25% weight
consistency70/ 20% weight
accuracy96/ 20% weight
timeliness92/ 15% weight
usability85/ 20% weight
  • · No obvious temporal column — limits time-series joins

Related datasets

  • Expense Budget-Debt Service Agency OTPS Detail0.59
    joins onagy_cdcat_nmagy_nm+1
  • Expense Budget--Miscellaneous Expense by Category0.54
    joins onagy_cdcat_nmsubcat_nm+2
  • Expense Financial Plan - Adpt\Prel0.37
  • Contract Budget by Category0.37
    joins onpub_dt
  • Expense Actuals By Funding Source0.37
    joins onagy_cdagy_nmpub_dt

Sample rows

pub_dtagy_cdagy_nmcurr_yrdbt_lmt_clscat_nmcurr_yr_outstd_amtnxt_yr_intnxt_yr_redpt_amt
20200630099DEBT SERVICE2020EXEMPTTransit88475329312080
20200630099DEBT SERVICE2020EXEMPTWater261360661179246

Columns

10 queryable · 10 profiled

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

FieldTypeDescriptionNullValues
pub_dtcategorical—0%202404242023063020250630of 14
agy_cdtext—0%099of 1
agy_nmtext—0%DEBT SERVICEof 1
curr_yrcategorical—0%202020262024of 7
dbt_lmt_clscategorical—0%

Query this from your own app

GET /api/datasets/77zj-y2i9
GET /api/datasets/77zj-y2i9/quality
GET /api/datasets/77zj-y2i9/related
GET /api/columns?dataset=77zj-y2i9
  • New York City Pension Expenses0.36
    joins onpub_dt
  • Hurricane Sandy Expense and Capital Estimate by Agency0.35
    joins onagy_nmpub_dt
  • NYC Climate Budgeting Report: Climate Funding Expense Highlights0.35
    • 3154810
    20200630099DEBT SERVICE2020EXEMPTWater Pollution Control95821523874642621960
    20200630099DEBT SERVICE2020EXEMPTSewer Improvement207727228189736992392
    20200630099DEBT SERVICE2020EXEMPTElementary and High Schools126164227065181793482
    20200630099DEBT SERVICE2020NON EXEMPTTransit124975822553483446139730438
    20200630099DEBT SERVICE2020NON EXEMPTDocks116406600397214221065427
    20200630099DEBT SERVICE2020NON EXEMPTWater Pollution Control4784482320565914853500
    20200630099DEBT SERVICE2020NON EXEMPTOff-Street Parking197807347942221929913
    20200630099DEBT SERVICE2020NON EXEMPTFerries and Airports96543967372752010557078
    NON EXEMPTEXEMPTof 2
    cat_nmcategorical—0%Public Safety, Correctio…Housing and Urban Develo…Parks, Recreation and Cu…of 18
    subcat_nmtext—29%Emergency Response Syste…Limited Profit and Other…Parks and Recreation
    curr_yr_outstd_amtinteger—0%6637133455149116226136066
    nxt_yr_intinteger—0%25000004332547930571
    nxt_yr_redpt_amtinteger—0%0153409801173428404