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

Data - Eurostat

Author

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)	1680822
SA	Seasonally adjusted data, not calendar adjusted data	331638

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	1053698
GE10	10 employees or more	958762

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	540237
JOBOCC	Number of occupied jobs	522357
JOBRATE	Job vacancy rate	484164
CH_Q_Q	Job vacancy rate quarter on quarter change	465702

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 .}