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 Agency OTPS Detail

iw4r-p85gCity Government12 columns
The Debt Service Agency OTPS detail lays out the various expense and funding line items for Agency 099. It further compares the Adopted Budget, Current Modified Budget for the Current Year, and the Executive or Adopted Budget for the next fiscal year. 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.6 / 100

From a 322-row sample across 12 columns.

completeness100/ 25% weight
consistency75/ 20% weight
accuracy89/ 20% weight
timeliness92/ 15% weight
usability85/ 20% weight
  • · No obvious temporal column — limits time-series joins

Related datasets

  • Expense Budget--Debt Service Statement II0.59
    joins onagy_nmpub_dtcat_nm+1
  • Expense Budget--Miscellaneous Expense by Category0.56
    joins onagy_nmfisc_yrpub_dt+2
  • Financial Plan Statements - Revenue0.41
    joins onfisc_yrpub_dt
  • New York City Personal Income Tax Collections By Component0.39
    joins onfisc_yrpub_dt
  • Financial Plan Statements - Revenue and Obligation Forecast0.39

Sample rows

pub_dtfisc_yragy_cdagy_nmexp_fndcat_nmobj_cls_nm_fnd_cls_nmobj_cd_fnd_cdobj_nm_fnd_nmcy_adp_amtcy_amt_curr_modnfy_amt
202006302021099DEBT SERVICEEXPENSEFunded Debt Outside Consitutional LimitDebt Service Funded Debt810Interest on Bonds - General95206569715488326391300825405
20200630

Columns

12 queryable · 12 profiled

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

FieldTypeDescriptionNullValues
pub_dtcategorical8-digit number for date of publication0%202404242023063020250630of 14
fisc_yrcategoricalIdentifies the fiscal year of the dataset which is one fiscal year after the publication date.0%202120242026of 7
agy_cdtextThree digit number identifying the reporting agency0%099of 1
agy_nmtextAgency name0%DEBT SERVICEof 1

Query this from your own app

GET /api/datasets/iw4r-p85g
GET /api/datasets/iw4r-p85g/quality
GET /api/datasets/iw4r-p85g/related
GET /api/columns?dataset=iw4r-p85g
joins onfisc_yrpub_dt
  • New York City Settlement Payments0.37
    joins onpub_dt
  • Where the Dollar Comes From and Goes To0.36
    joins onfisc_yrpub_dt
  • New York City Tax Revenue Actuals0.36
    joins onfisc_yrpub_dt
    • 2021
    099
    DEBT SERVICE
    EXPENSE
    Funded Debt Outside Consitutional Limit
    Debt Service Funded Debt
    850
    Redemption of Bonds - General
    1342998891
    622845000
    1342998891
    202006302021099DEBT SERVICEEXPENSEFunded Debt Outside Consitutional LimitDebt Service Funded Debt617Interest Exchange Agreements170745491794100014819999
    202006302021099DEBT SERVICEEXPENSEFunded Debt Outside Consitutional LimitDebt Service Funded Debt618Letter of Credit & Remarketing Fees786540425972120182783379
    202006302021099DEBT SERVICEEXPENSEFunded Debt Outside Consitutional LimitDebt Service Funded Debt810Various Municipal Purposes U/A 004027234633420
    202006302021099DEBT SERVICEEXPENSETemporary Debt Within Constitutional LimitTemporary Debt830Interest000
    202006302021099DEBT SERVICEEXPENSELease Purchase City Guaranteed DebtLease Purchase City Guaranteed Debt870Education Construction Fund205340592053405920505141
    202006302021099DEBT SERVICEEXPENSELease Purchase City Guaranteed DebtLease Purchase City Guaranteed Debt870City University Construction Fund116630131166301311091587
    202006302021099DEBT SERVICEEXPENSELease Purchase City Guaranteed DebtLease Purchase City Guaranteed Debt870Hudson Yards Infrastructure Corporation000
    202006302021099DEBT SERVICEEXPENSELease Purchase City Guaranteed DebtLease Purchase City Guaranteed Debt870Industrial Development Agency605621060562106057280
    exp_fnd
    categorical
    Identifies the line item as Expense or Funding.
    0%
    EXPENSEFUNDINGof 2
    cat_nmcategoricalNames the category of the debt type.0%Funding for DebtFunded Debt Outside Cons…Lease Purchase City Guar…of 7
    obj_cls_nm_fnd_cls_nmcategoricalDescribes the expense or funding category.0%Lease Purchase City Guar…Debt Service Funded DebtFunded Debtof 5
    obj_cd_fnd_cdcategoricalCode that identifies either the expense line item or the funding line item.0%870CSof 10
    obj_nm_fnd_nmcategoricalFurther describes the expense or funding line item.0%City FundingBuild America Bonds Subs…Courts Interest Aidof 19
    cy_adp_amtintegerRepresents the amount, in dollars, to be displayed for the current fiscal year adopted budget amount. This would be the amount that was adopted in the prior fiscal year for the current fiscal year.0%025000001342998891
    cy_amt_curr_modintegerRepresents the amount, in dollars, to be displayed for the current fiscal year current modified amount.0%025000009725000
    nfy_amtintegerRepresents the amount, in dollars, to be displayed for the next fiscal year amount. This would be the amount that was published in the current fiscal year financial plans (Exec or Adopt) for the next fiscal year. The next fiscal year is also identified in this dataset as "Fiscal Year." See definition above.0%025000001342998891