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

NYW Bond Issuance

7c9t-ckpjCity Government9 columns
This dataset describes current year issuance for NYW. Amounts are in billions and are updated in each Preliminary and Executive Budget.
View on NYC Open Data↗

Quality

B88.4 / 100

From a 56-row sample across 9 columns.

completeness91/ 25% weight
consistency78/ 20% weight
accuracy100/ 20% weight
timeliness88/ 15% weight
usability85/ 20% weight
  • · No obvious temporal column — limits time-series joins

Related datasets

  • Debt Issuance by Issuer0.72
    joins onissr_nmiss_dtnm_ref+2
  • Debt Service Major Indicators0.50
    joins onpub_dtft_nt
  • Debt Burden0.48
    joins onpub_dtft_nt
  • Capital Plan Funding Source0.44
    joins onpub_dt
  • NYC Floating Rate Exposure0.43
    joins onpub_dt

Sample rows

pub_dtissr_nmsrs_nmnm_refiss_dtpar_amtticlng_matft_nt
20200416NYW ISSUANCE2020 AAR2019-07-02T00:00:00.0004602.942040—
20200416NYW ISSUANCE2020 BBN2019-07-17T00:00:00.0004503.372049—

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%202605122020041620220426of 13
issr_nmtextName of Issuer0%NYW ISSUANCEof 1
srs_nmtextThe name of the series of bonds issued0%2023 AA2021 BB2023 BB
nm_refcategoricalIndicates if the purpose of the bonds issued were for new money capital purpose or refunding of existing debt.0%N/RRNof 3

Query this from your own app

GET /api/datasets/7c9t-ckpj
GET /api/datasets/7c9t-ckpj/quality
GET /api/datasets/7c9t-ckpj/related
GET /api/columns?dataset=7c9t-ckpj
Quarterly Borrowing Schedule0.42
joins onpub_dt
  • Additional Costs Allocation0.41
    joins onpub_dt
  • Expense Budget--Debt Service Statement II0.40
    joins onpub_dt
    • 20200416NYW ISSUANCE2020 Series 2, 3, and 4N/R2019-10-08T00:00:00.0004421.3520491) Bonds Issued to EFC 2) Includes the benefit from the EFC subsidy and accounts for the cost of annual fees for administration
    20200416NYW ISSUANCE2020 CCN/R2019-12-12T00:00:00.0006382.912049—
    20200416NYW ISSUANCE2020 DDN/R2020-02-13T00:00:00.0005282.852050—
    20200416NYW ISSUANCE2020 EER2020-03-18T00:00:00.0003992.112042—
    20200416NYW ISSUANCE2020 Series 5, 6, and 7N/R2020-04-08T00:00:00.0003341.2520491) Bonds Issued to EFC 2) Includes the benefit from the EFC subsidy and accounts for the cost of annual fees for administration
    20210114NYW ISSUANCE2021 AAN/R2020-09-30T00:00:00.0006502.82050—
    20210114NYW ISSUANCE2021 BBN/R2020-12-15T00:00:00.0005342.852050—
    20210426NYW ISSUANCE2021 AAN/R2020-09-30T00:00:00.0006502.82050—
    iss_dt
    datetime
    The date that the series of bonds was issued.
    0%
    2022-02-10T00:00:00.0002026-02-05T00:00:00.0002026-04-07T00:00:00.000
    par_amtfloatThis column shows the par amount of the named series.0%200450825
    ticcoordinateThis column indicates the TIC for the named series0%VAR2.942.85
    lng_matcategoricalThis column indicates the year of the longest maturity in the named series.0%205220532050of 17
    ft_ntcategoricalFootnotes associated with the data82%Bonds issued to EFC. Inc…Bonds issued to EFC1) Bonds Issued to EFC 2…of 6