Baselight

Supplementary Indicators To Unemployment - Quarterly Data

Eurostat code: lfsi_sup_q ยท (2003-Q1 - 2024-Q4)

@eurostat.lfsi_sup_q

Supplementary Indicators To Unemployment - Quarterly Data - Unpivoted
@eurostat.lfsi_sup_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.

  • 1.52 MB
  • 752876 rows
  • 9 columns
freq

Freq

sex

Sex

wstatus

Wstatus

s_adj

S Adj

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

QuarterlyFemalesPersons outside the labour forceUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)From 15 to 24 yearsPercentage of total populationFrance2003-Q165.6
QuarterlyFemalesPersons outside the labour forceUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)From 15 to 24 yearsThousand personsFrance2003-Q12481
QuarterlyFemalesPersons outside the labour forceUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)From 15 to 29 yearsPercentage of total populationFrance2003-Q149.5
QuarterlyFemalesPersons outside the labour forceUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)From 15 to 29 yearsThousand personsFrance2003-Q12850
QuarterlyFemalesPersons outside the labour forceUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)From 15 to 74 yearsPercentage of total populationFrance2003-Q142.4
QuarterlyFemalesPersons outside the labour forceUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)From 15 to 74 yearsThousand personsFrance2003-Q19649
QuarterlyFemalesPersons outside the labour forceUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)From 20 to 64 yearsPercentage of total populationFrance2003-Q128.8
QuarterlyFemalesPersons outside the labour forceUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)From 20 to 64 yearsThousand personsFrance2003-Q15195
QuarterlyFemalesPersons outside the labour forceUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)From 25 to 54 yearsPercentage of total populationFrance2003-Q118.3
QuarterlyFemalesPersons outside the labour forceUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)From 25 to 54 yearsThousand personsFrance2003-Q12377

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

Share link

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