Baselight

Labour Market Transitions - Quarterly Data

Eurostat code: lfsi_long_q ยท (2003-Q2 - 2024-Q4)

@eurostat.lfsi_long_q

Labour Market Transitions - Quarterly Data - Unpivoted
@eurostat.lfsi_long_q.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.

  • 405.11 KB
  • 196152 rows
  • 8 columns
freq

Freq

unit

Unit

s_adj

S Adj

indic_em

Indic Em

sex

Sex

geo

Geo

time_period

Time Period

value

Value

QuarterlyPercentage of total employmentUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Transition employment - employmentFemalesNetherlands2003-Q296.3
QuarterlyPercentage of total employmentUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Transition employment - employmentMalesNetherlands2003-Q297.1
QuarterlyPercentage of total employmentUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Transition employment - employmentTotalNetherlands2003-Q296.7
QuarterlyPercentage of total employmentUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Transition employment - outside the labour forceFemalesNetherlands2003-Q22.5
QuarterlyPercentage of total employmentUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Transition employment - outside the labour forceMalesNetherlands2003-Q21.6
QuarterlyPercentage of total employmentUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Transition employment - outside the labour forceTotalNetherlands2003-Q22
QuarterlyPercentage of total employmentUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Transition employment - unemploymentFemalesNetherlands2003-Q21.3
QuarterlyPercentage of total employmentUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Transition employment - unemploymentMalesNetherlands2003-Q21.3
QuarterlyPercentage of total employmentUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Transition employment - unemploymentTotalNetherlands2003-Q21.3
QuarterlyPercentage of total employmentSeasonally adjusted data, not calendar adjusted dataTransition employment - employmentFemalesNetherlands2003-Q295.9

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

Share link

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