Balance sheet and income - BSI

Data - OECD

Author

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