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 Burden

hdie-5bdvCity Government9 columns
This dataset has various calculations of debt burden. The data is represented as percentages and will be updated twice per year in the Preliminary and Executive Budgets.
View on NYC Open Data↗

Quality

B87.3 / 100

From a 52-row sample across 9 columns.

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

Related datasets

  • Debt Service Major Indicators0.55
    joins onft_ntfy1_yrpub_dt
  • NYC Floating Rate Exposure0.48
    joins onpub_dt
  • NYW Bond Issuance0.48
    joins onft_ntpub_dt
  • Debt Issuance by Issuer0.46
    joins onpub_dt
  • Full-Time and FTE Headcount including Covered Organizations0.43
  • New York City Employment Forecast0.42

Sample rows

pub_dtdbt_bdn_typfy1_yrfy1_pctfy2_pctfy3_pctfy4_pctfy5_pctft_nt
20200416Total Debt Service as % of Total Revenues20207.18.38.599.3Total Debt Service and Debt Outstanding include GO, conduit debt and TFA bonds other than BARBs
20200416Total Debt Service as % of Total Taxes202011.212.212.4

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%202301122022021620200416of 13
dbt_bdn_typcategoricalIndicates the type of debt burden reported0%Total Debt Service as % …Total Debt Outstanding a…Total Debt Service as % …of 4
fy1_yrcategoricalThe first fiscal year of the data set0%202420232022of 7
fy1_pctfloatRepresents the applicable calculation of the percentage for first fiscal year0%

Query this from your own app

GET /api/datasets/hdie-5bdv
GET /api/datasets/hdie-5bdv/quality
GET /api/datasets/hdie-5bdv/related
GET /api/columns?dataset=hdie-5bdv
joins onpub_dt
  • Capital Plan Funding Source0.42
    joins onfy1_yrpub_dt
  • New York City Forecasts of Selected Economic Indicators0.42
    joins onpub_dt
    • 13
    13.4
    Total Debt Service and Debt Outstanding include GO, conduit debt and TFA bonds other than BARBs
    20200416Total Debt Service as % of Total NYC Personal Income202011.11.11.21.2Total Debt Service and Debt Outstanding include GO, conduit debt and TFA bonds other than BARBs
    20200416Total Debt Outstanding as % of Total NYC Personal Income20201212.612.613.213.7Total Debt Service and Debt Outstanding include GO, conduit debt and TFA bonds other than BARBs
    20210114Total Debt Service as % of Total Revenues20216.888.99.19.5Total Debt Service and Debt Outstanding include GO, conduit debt and TFA bonds other than BARBs
    20210114Total Debt Service as % of Total Taxes202110.611.813.113.213.7Total Debt Service and Debt Outstanding include GO, conduit debt and TFA bonds other than BARBs
    20210114Total Debt Service as % of Total NYC Personal Income20210.911.11.11.2Total Debt Service and Debt Outstanding include GO, conduit debt and TFA bonds other than BARBs
    20210114Total Debt Outstanding as % of Total NYC Personal Income20211212.212.512.712.9Total Debt Service and Debt Outstanding include GO, conduit debt and TFA bonds other than BARBs
    20210426Total Debt Service as % of Total Revenues20216.37.28.68.89.3Total Debt Service and Debt Outstanding include GO, conduit debt and TFA FTS Bonds
    20210426Total Debt Service as % of Total Taxes202110.211.412.81313.5Total Debt Service and Debt Outstanding include GO, conduit debt and TFA FTS Bonds
    1121.1
    fy2_pctfloatRepresents the applicable calculation of the percentage for second fiscal year0%1.10.10812.1
    fy3_pctfloatRepresents the applicable calculation of the percentage for third fiscal year0%1.10.0118.1
    fy4_pctfloatRepresents the applicable calculation of the percentage for fourth fiscal year0%1.112.61.2
    fy5_pctfloatRepresents the applicable calculation of the percentage for fifth fiscal year0%1.11.212.6
    ft_ntcategoricalFootnotes to the table0%Total Debt Service and D…Total Debt Service and D…Total Debt Service and D…of 4