Baselight
Sign In

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

Eurostat code: jvs_a_nace2 · (2008 - 2015)

@eurostat.jvs_a_nace2

Job Vacancy Statistics By Occupation, NUTS 2 Region And NACE Rev. 2 Activity - Annual Data (2008-2015) - Unpivoted
@eurostat.jvs_a_nace2.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.

  • 720.49 KB
  • 262234 rows
  • 8 columns
freq

Freq

nace_r2

Nace R2

sizeclas

Sizeclas

isco08

Isco08

indic_em

Indic Em

geo

Geo

time_period

Time Period

value

Value

AnnualAgriculture, forestry and fishing10 employees or moreTotalNumber of occupied jobsCzechia2008103984
AnnualAgriculture, forestry and fishing10 employees or moreTotalNumber of occupied jobsČesko2008103984
AnnualAgriculture, forestry and fishing10 employees or moreTotalNumber of occupied jobsPraha2008445
AnnualAgriculture, forestry and fishing10 employees or moreTotalNumber of occupied jobsStřední Čechy200812172
AnnualAgriculture, forestry and fishing10 employees or moreTotalNumber of occupied jobsJihozápad200821452
AnnualAgriculture, forestry and fishing10 employees or moreTotalNumber of occupied jobsSeverozápad20088222
AnnualAgriculture, forestry and fishing10 employees or moreTotalNumber of occupied jobsSeverovýchod200812869
AnnualAgriculture, forestry and fishing10 employees or moreTotalNumber of occupied jobsJihovýchod200828261
AnnualAgriculture, forestry and fishing10 employees or moreTotalNumber of occupied jobsStřední Morava200812892
AnnualAgriculture, forestry and fishing10 employees or moreTotalNumber of occupied jobsMoravskoslezsko20087673

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

Share link

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