Total and active population by sex, age, employment status, residence one year prior to the census and NUTS 3 regions - cens_01rapop

Data - Eurostat

wstatus

Code
cens_01rapop %>%
  left_join(wstatus, by = "wstatus") %>%
  group_by(wstatus, Wstatus) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
wstatus Wstatus Nobs
POP Population 61909
ACT Persons in the labour force (former name: active persons) 60011
EMP Employed persons 60008
UNE Unemployed persons 57545
INAC Persons outside the labour force (former name: inactive persons) 41575
SAL Employees 39807
INAC_OTH Other persons outside the labour force (former name: inactive persons) 38582
SELF_S Self-employed persons with employees (employers) 38105
EMP_OTH Other employed persons 38098
INC Retired persons and capital income recipients 37186
EDUC Students 34811
CFAM Contributing family workers 30374
NAP Not applicable 14988
ACT_UNK Persons in the labour force (former name: active population) - unknown 4628
INAC_UNK Persons outside the labour force (former name: inactive persons) - unknown 596

age

Code
cens_01rapop %>%
  left_join(age, by = "age") %>%
  group_by(age, Age) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

sex

Code
cens_01rapop %>%
  left_join(sex, by = "sex") %>%
  group_by(sex, Sex) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
sex Sex Nobs
T Total 186910
F Females 186021
M Males 185292

unit

Code
cens_01rapop %>%
  left_join(unit, by = "unit") %>%
  group_by(unit, Unit) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
unit Unit Nobs
PER Person 558223

geo

Code
cens_01rapop %>%
  left_join(geo, by = "geo") %>%
  group_by(geo, Geo) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

time

Code
cens_01rapop %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
time Nobs
2001 558223

2001 Unemployed

Code
cens_01rapop %>%
  filter(nchar(geo) == 5,
         wstatus %in% c("ACT", "UNE"),
         age == "TOTAL",
         sex == "T") %>%
  select(geo, wstatus, values) %>%
  spread(wstatus, values) %>%
  left_join(geo, by = "geo") %>%
  right_join(europe_NUTS3, by = "geo") %>%
  filter(long >= -15, lat >= 33) %>%
  ggplot(., aes(x = long, y = lat, group = group, fill = UNE/ACT)) +
  geom_polygon() + coord_map() +
  scale_fill_viridis_c(na.value = "white",
                       direction = -1,
                       labels = percent_format(accuracy = 1),
                       breaks = 0.01*seq(0, 90, 5),
                       values = c(0, 0.1, 0.2, 0.3, 0.4, 0.5, 1)) +
  theme_void() + theme(legend.position = c(0.25, 0.85)) + 
  labs(fill = "Manuf Share")