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

Debt Service Major Indicators

4yay-s2usCity Government10 columns
This dataset shows expected issuance amounts, debt outstanding, and annual debt service costs by issuer for a given set of plan years. The data is represented in millions and will be updated twice per year in the Preliminary and Executive Budgets.
View on NYC Open Data↗

Quality

B82.9 / 100

From a 169-row sample across 10 columns.

completeness92/ 25% weight
consistency65/ 20% weight
accuracy84/ 20% weight
timeliness87/ 15% weight
usability85/ 20% weight
  • · No obvious temporal column — limits time-series joins

Related datasets

  • Debt Burden0.55
    joins onpub_dtfy1_yrft_nt
  • Capital Plan Funding Source0.51
    joins onfy3_amtfy2_amtpub_dt+4
  • NYW Bond Issuance0.50
    joins onpub_dtft_nt
  • NYC Floating Rate Exposure0.48
    joins onpub_dt
  • Debt Issuance by Issuer0.47
    joins onpub_dt

Sample rows

pub_dtindctsisr_typfy1_yrfy1_amtfy2_amtfy3_amtfy4_amtfy5_amtft_nt
20200416Financing ProgramCity General Obligation Bonds202037803820458054205760—
20200416Financing ProgramTFA Bonds2020360038204580

Columns

10 queryable · 10 profiled

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

FieldTypeDescriptionNullValues
pub_dtcategorical8-digit number for date of publication0%202301122022021620200416of 13
indctscategoricalName of Indicator0%Annual Debt Service Cost…Debt Outstanding at Year…Financing Programof 3
isr_typcategoricalIndicates the Issuer bonds and the debt indicator shown0%TFA BondsWater Authority BondsCity General Obligation …of 5
fy1_yrcategoricalThe first fiscal year of the data set0%

Query this from your own app

GET /api/datasets/4yay-s2us
GET /api/datasets/4yay-s2us/quality
GET /api/datasets/4yay-s2us/related
GET /api/columns?dataset=4yay-s2us
  • Quarterly Borrowing Schedule0.43
    joins onpub_dt
  • New York City Forecasts of Selected Economic Indicators0.42
    joins onpub_dt
  • Full-Time and FTE Headcount including Covered Organizations0.41
    • 5420
    5760
    TFA Bonds do not include BARBs issued for education capital purposes. TFA expects to continue to issue BARBs under the current legislative authorization. For amounts, see the Transitional Finance Authority section below.
    20200416Financing ProgramWater Authority Bonds202020951571161115491617Includes commercial paper and revenue bonds issued for the water and sewer system’s capital program. Figures do not include bonds that defease commercial paper or refunding bonds. Does not include bonds to fund reserves or cost of issuance.
    20200416Debt Outstanding at Year EndCity General Obligation Bonds20203878440460427344569248870—
    20200416Debt Outstanding at Year EndTFA Bonds20204070242948458634952353483Figures above do not include state funded financing for education capital purposes through the TFA BARBs.
    20200416Debt Outstanding at Year EndTSASC Bonds20201023993966938909—
    20200416Debt Outstanding at Year EndConduit Debt20201058995929838739—
    20200416Debt Outstanding at Year EndWater Authority Bonds20203087132206333663444235567—
    20200416Annual Debt Service Costs Before PrepaymentsCity General Obligation Bonds202039434008431046404966—
    20200416Annual Debt Service Costs Before PrepaymentsTFA Bonds202028903257359139454082Figures above do not include state funded financing for education capital purposes through the TFA BARBs.
    202420232022of 7
    fy1_amtintegerRepresents the value of the indicator for the first fiscal year0%7682879
    fy2_amtintegerRepresents the value of the indicator for the second fiscal year0%76694820
    fy3_amtintegerRepresents the value of the indicator for the third fiscal year0%76695580
    fy4_amtintegerRepresents the value of the indicator for the fourth fiscal year0%7669118
    fy5_amtintegerRepresents the value of the indicator for the fifth fiscal year0%6769116
    ft_ntcategoricalFootnotes to the table76%Includes First Resolutio…Includes commercial pape…Figures above do not inc…of 9