Debt securities statistics - DEBTSEC

Data - BIS

iso3c, iso2c, Issuer residence

Code
DEBTSEC %>%
  arrange(iso3c, date) %>%
  group_by(iso3c, iso2c, `Issuer residence`) %>%
  summarise(Nobs = n(),
            start = first(date),
            end = last(date)) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

MARKET, Issue market

Code
DEBTSEC %>%
  group_by(MARKET, `Issue market`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
MARKET Issue market Nobs
C International markets 15540354
A Domestic market 39403
1 All markets 23833

FREQ, Frequency

Code
DEBTSEC %>%
  group_by(FREQ, Frequency) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
FREQ Frequency Nobs
Q Quarterly 15603590

ISSUER_NAT, Issuer nationality

Code
DEBTSEC %>%
  group_by(ISSUER_NAT, `Issuer nationality`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

ISSUER_BUS_IMM, Issuer sector - immediate borrower

Code
DEBTSEC %>%
  group_by(ISSUER_BUS_IMM, `Issuer sector - immediate borrower`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
ISSUER_BUS_IMM Issuer sector - immediate borrower Nobs
1 All issuers 9548347
B Financial corporations 1282421
E Private banks 1001983
J Non-financial corporations 995559
2 General government 912262
G Private other financial institutions 856986
I Public banks 445622
K Public other financial institutions 408804
7 Central bank 94780
S International institutions 56826

ISSUER_BUS_ULT, Issuer sector - ultimate borrower

Code
DEBTSEC %>%
  group_by(ISSUER_BUS_ULT, `Issuer sector - ultimate borrower`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
ISSUER_BUS_ULT Issuer sector - ultimate borrower Nobs
1 All issuers 9409305
B Financial corporations 1322572
J Non-financial corporations 1155395
E Private banks 1050559
2 General government 890123
G Private other financial institutions 857004
I Public banks 391784
K Public other financial institutions 382832
7 Central bank 94780
S International institutions 49236

MARKET, Issue market

Code
DEBTSEC %>%
  group_by(MARKET, `Issue market`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
MARKET Issue market Nobs
C International markets 15540354
A Domestic market 39403
1 All markets 23833

ISSUE_TYPE, Issue type

Code
DEBTSEC %>%
  group_by(ISSUE_TYPE, `Issue type`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
ISSUE_TYPE Issue type Nobs
A All issue types 15603590

ISSUE_CUR_GROUP, Issue currency group

Code
DEBTSEC %>%
  group_by(ISSUE_CUR_GROUP, `Issue currency group`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
ISSUE_CUR_GROUP Issue currency group Nobs
A All currencies 6941824
F Foreign currencies 6318725
D Domestic currency 2343041

ISSUE_CUR, Issue currency

Code
DEBTSEC %>%
  group_by(ISSUE_CUR, `Issue currency`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

ISSUE_OR_MAT, Original maturity

Code
DEBTSEC %>%
  group_by(ISSUE_OR_MAT, `Original maturity`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
ISSUE_OR_MAT Original maturity Nobs
A Total (all maturities) 6789263
K Long-term 6519293
C Short-term 2295034

ISSUE_RE_MAT, Remaining maturity

Code
DEBTSEC %>%
  group_by(ISSUE_RE_MAT, `Remaining maturity`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
ISSUE_RE_MAT Remaining maturity Nobs
A Total (all maturities) 10713137
U Up to and including 1 year 4890453

ISSUE_RATE, Rate type

Code
DEBTSEC %>%
  group_by(ISSUE_RATE, `Rate type`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
ISSUE_RATE Rate type Nobs
A All rate types 8110240
C Straight fixed rate 7493350

ISSUE_RISK, Default risk (for future expansion)

Code
DEBTSEC %>%
  group_by(ISSUE_RISK, `Default risk (for future expansion)`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
ISSUE_RISK Default risk (for future expansion) Nobs
A All credit ratings 15603590

ISSUE_COL, Collateral type (for future expansion)

Code
DEBTSEC %>%
  group_by(ISSUE_COL, `Collateral type (for future expansion)`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
ISSUE_COL Collateral type (for future expansion) Nobs
A All issues 15603590