Job vacancy statistics by NACE Rev. 2 activity, occupation and NUTS 2 regions - quarterly data - jvs_q_isco_r2

Data - Eurostat

s_adj

Code
jvs_q_isco_r2 %>%
  left_join(s_adj, by = "s_adj") %>%
  group_by(s_adj, S_adj) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
s_adj S_adj Nobs
NSA Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) 1675202
SA Seasonally adjusted data, not calendar adjusted data 330801

nace_r2

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

sizeclas

Code
jvs_q_isco_r2 %>%
  left_join(sizeclas, by = "sizeclas") %>%
  group_by(sizeclas, Sizeclas) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
sizeclas Sizeclas Nobs
TOTAL Total 1050151
GE10 10 employees or more 955852

indic_em

Code
jvs_q_isco_r2 %>%
  left_join(indic_em, by = "indic_em") %>%
  group_by(indic_em, Indic_em) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
indic_em Indic_em Nobs
JOBVAC Number of job vacancies 538656
JOBOCC Number of occupied jobs 520813
JOBRATE Job vacancy rate 482498
CH_Q_Q Job vacancy rate quarter on quarter change 464036

isco08

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

geo

Code
jvs_q_isco_r2 %>%
  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
jvs_q_isco_r2 %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

Example

Code
jvs_q_isco_r2 %>%
  filter(sizeclas == "TOTAL",
         s_adj == "NSA",
         indic_em == "JOBRATE",
         grepl("DE", geo),
         isco08 == "TOTAL",
         time %in% c("2020Q2", "2006Q2", "2013Q2")) %>%
  select(time, nace_r2, values) %>%
  left_join(nace_r2, by = "nace_r2") %>%
  spread(time, values) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}