Code
tibble(LAST_DOWNLOAD = as.Date(file.info("~/iCloud/website/data/eurostat/lc_nstruc_r2.RData")$mtime)) %>%
print_table_conditional()| LAST_DOWNLOAD |
|---|
| 2026-03-24 |
Data - Eurostat
tibble(LAST_DOWNLOAD = as.Date(file.info("~/iCloud/website/data/eurostat/lc_nstruc_r2.RData")$mtime)) %>%
print_table_conditional()| LAST_DOWNLOAD |
|---|
| 2026-03-24 |
| LAST_COMPILE |
|---|
| 2026-03-25 |
lc_nstruc_r2 %>%
group_by(time) %>%
summarise(Nobs = n()) %>%
arrange(desc(time)) %>%
head(1) %>%
print_table_conditional()| time | Nobs |
|---|---|
| 2020 | 565308 |
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) | 121404 |
| D11 | Wages and salaries (total) | 121401 |
| D111 | Wages and salaries (excluding apprentices) | 121401 |
| D1111 | Direct remuneration, bonuses and allowances | 121397 |
| D12 | Employers' social contributions (total) | 121364 |
| D121 | Employers' actual social contributions | 121364 |
| D1113 | Payments for days not worked | 121300 |
| D1114 | Wages and salaries in kind | 121219 |
| D122 | Employers' imputed social contributions | 120826 |
| D3 | Other expenditure | 120705 |
| D2 | Vocational training costs | 120651 |
| D5 | Subsidies | 119400 |
| D4 | Taxes | 117148 |
| D1112 | Payments to employees savings schemes | 112238 |
| D112 | Wages and salaries of apprentices | 108916 |
| D123 | Employers' social contributions for apprentices | 107495 |
| D11111 | Direct remuneration, bonuses and allowances paid in each pay period | 50789 |
| D1211 | Statutory social security contributions | 50787 |
| D11112 | Direct remuneration, bonuses and allowances not paid in each pay period | 50778 |
| D1212 | Collectively agreed, contractual and voluntary social security contributions | 50709 |
| D1223 | Payments to employees leaving the enterprise | 47914 |
| D1221 | Guaranteed remuneration in the event of sickness | 47144 |
| D1224 | Other employers' imputed social benefits | 47042 |
| D1222 | Employers' imputed social contributions for pensions and health | 45082 |
| D11143 | Company cars | 43532 |
| D11142 | Staff housing | 42787 |
| D11144 | Stock options and share purchase schemes | 42541 |
| D11141 | Company products | 41962 |
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 | 465123 |
| 10-49 | From 10 to 49 employees | 341555 |
| 50-249 | From 50 to 249 employees | 341068 |
| 250-499 | From 250 to 499 employees | 327484 |
| 500-999 | From 500 to 999 employees | 306289 |
| GE1000 | 1 000 employees or more | 285464 |
| TOTAL | Total | 197528 |
| LT10 | Fewer than 10 employees | 194785 |
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 | 604673 |
| 2012 | 671948 |
| 2016 | 617367 |
| 2020 | 565308 |