Balance sheet and income - BSI

Data - OECD


Nobs - Javascript

Code
BSI %>%
  left_join(BSI_var %>% pluck("VAR"), by = c("VAR" = "id")) %>%
  rename(`VAR Description` = label) %>%
  left_join(BSI_var %>% pluck("ITYP"), by = c("ITYP" = "id")) %>%
  rename(`ITYP Description` = label) %>%
  group_by(VAR, `VAR Description`, ITYP, `ITYP Description`, TYP, CUR) %>%
  summarise(nobs = n()) %>%
  arrange(-nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

Data Structure

Code
BSI_var$VAR_DESC %>%
  {if (is_html_output()) print_table(.) else .}
id description
CUR Currency
VAR Variable
ITYP Insurance type
TYP Insurer type
COU Country
YEA Year
OBS_VALUE Observation Value
TIME_FORMAT Time Format
OBS_STATUS Observation Status
UNIT Unit
POWERCODE Unit multiplier
REFERENCEPERIOD Reference period

VAR

Code
BSI_var$VAR %>%
  {if (is_html_output()) print_table(.) else .}
id label
CLM Gross claims payments in the reporting country
EXP Gross operating expenses in the reporting country
COM Commissions in the reporting country
OCP Outstanding claims provision (changes)
ASS Total assets
PRO Gross technical provisions
UNI Unit-linked
EQU Shareholders' equity
NET Net income

ITYP

Code
BSI_var$ITYP %>%
  {if (is_html_output()) print_table(.) else .}
id label
LIFE Life
NLIFE Non-Life
COMP Composite
CL Of which: Life
CNL Of which: Non-Life
TOT Total