Industry by employment size class (NACE Rev. 2, B-E) - sbs_sc_ind_r2

Data - Eurostat

Author

François Geerolf

Info

Last observation: 2020 (N = 553733)

First observation: 2005 (N = 27497)

Last data update: 14 aoû 2026, 23:28. Last compile: 18 aoû 2026, 04:00

Structure

France: Manufacturing Employment by Firm Size

Code

sbs_sc_ind_r2 |>
  filter(geo == "FR",
         nace_r2 == "C",
         indic_sb == "V16110",
         size_emp %in% c("0-9", "GE250", "TOTAL")) |>
  year_to_date() |>
  mutate(values = values/1000) |>
  ggplot() + geom_line(aes(x = date, y = values, color = Size_emp)) +
  theme_minimal() +
  scale_x_date(breaks = as.Date(paste0(seq(2005, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  theme(legend.position = c(0.7, 0.85),
        legend.title = element_blank()) +
  xlab("") + ylab("Persons employed, Manufacturing (thousands)")

France, Germany, Italy, Spain: Manufacturing Productivity

Code

sbs_sc_ind_r2 |>
  filter(geo %in% c("FR", "DE", "IT", "ES"),
         nace_r2 == "C",
         indic_sb == "V91110",
         size_emp == "TOTAL") |>
  year_to_date() |>
  left_join(colors, by = c("Geo" = "country")) |>
  ggplot() + geom_line(aes(x = date, y = values, color = color)) +
  theme_minimal() + scale_color_identity() + add_flags +
  scale_x_date(breaks = as.Date(paste0(seq(2005, 2100, 2), "-01-01")),
               labels = date_format("%Y")) +
  xlab("") + ylab("Apparent labour productivity (th. €/person employed)")

Latest Year: Manufacturing Employment by Firm Size

Code

latest_y <- sbs_sc_ind_r2 |>
  filter(nace_r2 == "C",
         indic_sb == "V16110",
         !is.na(values)) |>
  summarise(m = max(time)) |>
  pull(m)

sbs_sc_ind_r2 |>
  filter(geo %in% c("FR", "DE", "IT", "ES"),
         nace_r2 == "C",
         indic_sb == "V16110",
         time == latest_y,
         size_emp != "TOTAL") |>
  mutate(values = values/1000) |>
  select(size_emp, Size_emp, Geo, values) |>
  spread(Geo, values) |>
  print_table_conditional()

size_emp	Size_emp	France	Germany	Italy	Spain
0-9	From 0 to 9 persons employed	334.958	481.778	791.999	333.346
10-19	From 10 to 19 persons employed	181.232	468.081	490.243	176.319
20-49	From 20 to 49 persons employed	242.065	607.050	560.799	300.845
50-249	From 50 to 249 persons employed	475.795	1506.011	848.292	470.500
GE250	250 persons employed or more	1946.353	4821.607	1054.130	763.588