Non-autonomous pension funds - sbs_pen_7e

Data - Eurostat

nace_r1

Code
sbs_pen_7e %>%
  left_join(nace_r1, by = "nace_r1") %>%
  group_by(nace_r1, Nace_r1) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
nace_r1 Nace_r1 Nobs
TOTAL Total - all NACE activities 67
J Financial intermediation 43
C Mining and quarrying 41
D Manufacturing 41
E Electricity, gas and water supply 41
F Construction 41
G Wholesale and retail trade; repair of motor vehicles, motorcycles and personal and household goods 41
H Hotels and restaurants 41
I Transport, storage and communication 41
K Real estate, renting and business activities 41

indic_sb

Code
sbs_pen_7e %>%
  left_join(indic_sb, by = "indic_sb") %>%
  group_by(indic_sb, Indic_sb) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

unit

Code
sbs_pen_7e %>%
  left_join(geo, by = "geo") %>%
  group_by(geo, Geo) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}