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-11-21 |
Data - Eurostat
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-11-21 |
LAST_COMPILE |
---|
2024-11-22 |
%>%
lc_nstruc_r2 group_by(time) %>%
summarise(Nobs = n()) %>%
arrange(desc(time)) %>%
head(1) %>%
print_table_conditional()
time | Nobs |
---|---|
2020 | 547980 |
%>%
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 |
%>%
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 |
%>%
lc_nstruc_r2 left_join(nace_r2, by = "nace_r2") %>%
group_by(nace_r2, Nace_r2) %>%
summarise(Nobs = n()) %>%
arrange(-Nobs) %>%
print_table_conditional()
%>%
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 .} {
%>%
lc_nstruc_r2 group_by(time) %>%
summarise(Nobs = n()) %>%
print_table_conditional()
time | Nobs |
---|---|
2008 | 586844 |
2012 | 654440 |
2016 | 600267 |
2020 | 547980 |