Job Vacancy Rate By NACE Rev. 2 Activity - Annual Data

Eurostat code: jvs_a_rate_r2 · (2008 - 2024)

@eurostat.jvs_a_rate_r2

Table List

2 tables(147.65 KB)

Job Vacancy Rate By NACE Rev. 2 Activity - Annual Data - Raw

Job Vacancy Rate By NACE Rev. 2 Activity - Annual Data - Unpivoted

Job Vacancy Rate By NACE Rev. 2 Activity - Annual Data - Unpivoted

@eurostat.jvs_a_rate_r2.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

71.79 KB
51886 rows
7 columns

freq Freq	nace_r2 Nace R2	sizeclas Sizeclas	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Agriculture, forestry and fishing	10 employees or more	Three-year average	Hungary	2008	0.6
Annual	Agriculture, forestry and fishing	10 employees or more	Annual average	Czechia	2008	3.2
Annual	Agriculture, forestry and fishing	10 employees or more	Annual average	Estonia	2008	2.1
Annual	Agriculture, forestry and fishing	10 employees or more	Annual average	Hungary	2008	0.7
Annual	Agriculture, forestry and fishing	10 employees or more	Annual average	Lithuania	2008	0.9
Annual	Agriculture, forestry and fishing	10 employees or more	Annual average	Luxembourg	2008	1.1
Annual	Agriculture, forestry and fishing	10 employees or more	Annual average	Latvia	2008	1
Annual	Agriculture, forestry and fishing	10 employees or more	Annual average	Slovakia	2008	0.2
Annual	Agriculture, forestry and fishing	Total	Three-year average	Hungary	2008	0.8
Annual	Agriculture, forestry and fishing	Total	Three-year average	Netherlands	2008	2.9


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "sizeclas" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.