Baselight
Sign In

Job Vacancy Statistics By NACE Rev. 1.1 Activity - Quarterly Data (2001Q1-2009Q4)

Eurostat code: jvs_q_nace1 ยท (2001-Q1 - 2009-Q4)

@eurostat.jvs_q_nace1

Job Vacancy Statistics By NACE Rev. 1.1 Activity - Quarterly Data (2001Q1-2009Q4) - Unpivoted
@eurostat.jvs_q_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.

  • 265.63 KB
  • 76623 rows
  • 8 columns
freq

Freq

s_adj

S Adj

nace_r1

Nace R1

sizeclas

Sizeclas

indic_em

Indic Em

geo

Geo

time_period

Time Period

value

Value

QuarterlyUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Agriculture, hunting and forestry10 employees or moreNumber of occupied jobsSlovenia2001-Q16772
QuarterlyUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Agriculture, hunting and forestry10 employees or moreJob vacancy rateSlovenia2001-Q10.7
QuarterlyUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Agriculture, hunting and forestry10 employees or moreNumber of job vacanciesSlovenia2001-Q145
QuarterlyUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Agriculture, hunting and forestryTotalNumber of occupied jobsSlovenia2001-Q18618
QuarterlyUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Agriculture, hunting and forestryTotalJob vacancy rateSlovenia2001-Q10.9
QuarterlyUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Agriculture, hunting and forestryTotalNumber of job vacanciesSlovenia2001-Q178
QuarterlyUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Agriculture; fishing10 employees or moreNumber of occupied jobsSlovenia2001-Q16846
QuarterlyUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Agriculture; fishing10 employees or moreJob vacancy rateSlovenia2001-Q10.7
QuarterlyUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Agriculture; fishing10 employees or moreNumber of job vacanciesSlovenia2001-Q145
QuarterlyUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Agriculture; fishingTotalNumber of occupied jobsSlovenia2001-Q18800

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

Share link

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