Job Vacancy Statistics By Occupation, NUTS 2 Region And NACE Rev. 1.1 Activity - Annual Data (2000-2008)

Eurostat code: jvs_a_nace1 · (2000 - 2008)

@eurostat.jvs_a_nace1

Table List

2 tables(888.66 KB)

Job Vacancy Statistics By Occupation, NUTS 2 Region And NACE Rev. 1.1 Activity - Annual Data (2000-2008) - Raw

Job Vacancy Statistics By Occupation, NUTS 2 Region And NACE Rev. 1.1 Activity - Annual Data (2000-2008) - Unpivoted

Job Vacancy Statistics By Occupation, NUTS 2 Region And NACE Rev. 1.1 Activity - Annual Data (2000-2008) - Unpivoted

@eurostat.jvs_a_nace1.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.

423.48 KB
151511 rows
8 columns

freq Freq	nace_r1 Nace R1	sizeclas Sizeclas	isco88 Isco88	indic_em Indic Em	geo Geo	time_period Time Period	value Value
Annual	Agriculture; fishing	10 employees or more	Total	Job vacancy rate	Germany	2000	10.3
Annual	Agriculture; fishing	10 employees or more	Total	Job vacancy rate	Federal Republic of Germany (former territory of the FRG only)	2000	16.1
Annual	Agriculture; fishing	10 employees or more	Total	Job vacancy rate	German Democratic Republic	2000	1.5
Annual	Agriculture; fishing	Total	Total	Job vacancy rate	Germany	2000	12.7
Annual	Agriculture; fishing	Total	Total	Job vacancy rate	Federal Republic of Germany (former territory of the FRG only)	2000	17.8
Annual	Agriculture; fishing	Total	Total	Job vacancy rate	German Democratic Republic	2000	2.8
Annual	Industry (except construction)	10 employees or more	Total	Job vacancy rate	Germany	2000	2.1
Annual	Industry (except construction)	10 employees or more	Total	Job vacancy rate	Federal Republic of Germany (former territory of the FRG only)	2000	2.1
Annual	Industry (except construction)	10 employees or more	Total	Job vacancy rate	German Democratic Republic	2000	2
Annual	Industry (except construction)	Total	Total	Job vacancy rate	Germany	2000	2.5


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r1" VARCHAR,
  "sizeclas" VARCHAR,
  "isco88" VARCHAR,
  "indic_em" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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