Labour costs by NACE Rev. 2 activity - lc_an_struc_r2

Data - Eurostat

Author

François Geerolf

Info

LAST_DOWNLOAD

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

LAST_COMPILE

LAST_COMPILE
2024-11-22

Last

Code 
lc_an_struc_r2 %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  head(1) %>%
  print_table_conditional()
time Nobs
2011 2104

lcstruct

Code 
lc_an_struc_r2 %>%
  left_join(lcstruct, by = "lcstruct") %>%
  group_by(lcstruct, Lcstruct) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()
lcstruct Lcstruct Nobs
D11 Wages and salaries (total) 4668
D12-D4_MD5 Employers' social contributions and other labour costs paid by employer 4664

sizeclas

Code 
lc_an_struc_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 5940
TOTAL Total 3392

nace_r2

Code 
lc_an_struc_r2 %>%
  left_join(nace_r2, by = "nace_r2") %>%
  group_by(nace_r2, Nace_r2) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()
nace_r2 Nace_r2 Nobs
C Manufacturing 334
F Construction 334
G Wholesale and retail trade; repair of motor vehicles and motorcycles 334
H Transportation and storage 334
J Information and communication 334
K Financial and insurance activities 334
B-E Industry (except construction) 328
B-F Industry and construction 328
B-N Business economy 328
E Water supply; sewerage, waste management and remediation activities 328
G-J Wholesale and retail trade; transport; accommodation and food service activities; information and communication 328
G-N Services of the business economy 328
I Accommodation and food service activities 328
K-N Financial and insurance activities; real estate activities; professional, scientific and technical activities; administrative and support service activities 328
M Professional, scientific and technical activities 328
P-S Education; human health and social work activities; arts, entertainment and recreation; other service activities 328
Q Human health and social work activities 328
R Arts, entertainment and recreation 328
S Other service activities 328
N Administrative and support service activities 327
P Education 322
B Mining and quarrying 321
D Electricity, gas, steam and air conditioning supply 321
L Real estate activities 321
B-S_X_O Industry, construction and services (except public administration, defense, compulsory social security) 316
G-S_X_O Services (except public administration, defense, compulsory social security, activities of households as employers and extra-territorial organisations and bodies) 308
B-S Industry, construction and services (except activities of households as employers and extra-territorial organisations and bodies) 280
O Public administration and defence; compulsory social security 280
O-S Public administration and defence; compulsory social security; education; human health and social work activities; arts, entertainment and recreation; other service activities 268

geo

Code 
lc_an_struc_r2 %>%
  left_join(geo, by = "geo") %>%
  group_by(geo, Geo) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  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_an_struc_r2 %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  print_table_conditional()
time Nobs
2011 2104
2010 2176
2009 2176
2008 1868
2007 162
2006 162
2005 162
2004 58
2003 58
2002 58
2001 58
2000 58
1999 58
1998 58
1997 58
1996 58