Structure of labour cost by NACE Rev. 2 activity - % of total cost - lc_nstruc_r2

Data - Eurostat

Info

LAST_DOWNLOAD

Code
tibble(LAST_DOWNLOAD = as.Date(file.info("~/Library/Mobile\ Documents/com~apple~CloudDocs/website/data/eurostat/lc_nstruc_r2.RData")$mtime)) %>%
  print_table_conditional()
LAST_DOWNLOAD
2024-10-08

LAST_COMPILE

LAST_COMPILE
2024-11-05

Last

Code
lc_nstruc_r2 %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  head(1) %>%
  print_table_conditional()
time Nobs
2020 547980

lcstruct

Code
lc_nstruc_r2 %>%
  left_join(lcstruct, by = "lcstruct") %>%
  group_by(lcstruct, Lcstruct) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()
lcstruct Lcstruct Nobs
D1 Compensation of employees (total) 117849
D11 Wages and salaries (total) 117846
D111 Wages and salaries (excluding apprentices) 117846
D1111 Direct remuneration, bonuses and allowances 117842
D12 Employers' social contributions (total) 117809
D121 Employers' actual social contributions 117809
D1113 Payments for days not worked 117745
D1114 Wages and salaries in kind 117665
D122 Employers' imputed social contributions 117271
D3 Other expenditure 117151
D2 Vocational training costs 117097
D5 Subsidies 115846
D4 Taxes 113594
D1112 Payments to employees savings schemes 108683
D112 Wages and salaries of apprentices 105362
D123 Employers' social contributions for apprentices 103941
D11111 Direct remuneration, bonuses and allowances paid in each pay period 49714
D1211 Statutory social security contributions 49712
D11112 Direct remuneration, bonuses and allowances not paid in each pay period 49703
D1212 Collectively agreed, contractual and voluntary social security contributions 49634
D1223 Payments to employees leaving the enterprise 46840
D1221 Guaranteed remuneration in the event of sickness 46070
D1224 Other employers' imputed social benefits 45968
D1222 Employers' imputed social contributions for pensions and health 44008
D11143 Company cars 42458
D11142 Staff housing 41713
D11144 Stock options and share purchase schemes 41467
D11141 Company products 40888

sizeclas

Code
lc_nstruc_r2 %>%
  left_join(sizeclas, by = "sizeclas") %>%
  group_by(sizeclas, Sizeclas) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()
sizeclas Sizeclas Nobs
GE10 10 employees or more 452622
10-49 From 10 to 49 employees 332987
50-249 From 50 to 249 employees 332596
250-499 From 250 to 499 employees 319720
500-999 From 500 to 999 employees 298537
GE1000 1 000 employees or more 277616
TOTAL Total 189872
LT10 Fewer than 10 employees 185581

nace_r2

Code
lc_nstruc_r2 %>%
  left_join(nace_r2, by = "nace_r2") %>%
  group_by(nace_r2, Nace_r2) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()

geo

Code
lc_nstruc_r2 %>%
  left_join(geo, by = "geo") %>%
  group_by(geo, Geo) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  mutate(Geo = ifelse(geo == "DE", "Germany", Geo)) %>%
  mutate(Flag = gsub(" ", "-", str_to_lower(Geo)),
         Flag = paste0('<img src="../../bib/flags/vsmall/', Flag, '.png" alt="Flag">')) %>%
  select(Flag, everything()) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}

time

Code
lc_nstruc_r2 %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  print_table_conditional()
time Nobs
2008 586844
2012 654440
2016 600267
2020 547980