Baselight

Unemployment By Sex, Age And Educational Attainment (1998-2020) - Quarterly Data

Eurostat code: une_educ_q_h ยท (1998-Q1 - 2020-Q4)

@eurostat.une_educ_q_h

Unemployment By Sex, Age And Educational Attainment (1998-2020) - Quarterly Data - Unpivoted
@eurostat.une_educ_q_h.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.

  • 899.27 KB
  • 478458 rows
  • 9 columns
freq

Freq

sex

Sex

isced11

Isced11

age

Age

s_adj

S Adj

unit

Unit

geo

Geo

time_period

Time Period

value

Value

QuarterlyFemalesLess than primary, primary and lower secondary education (levels 0-2)From 15 to 74 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Percentage of population in the labour forceCzechia1998-Q114.6
QuarterlyFemalesLess than primary, primary and lower secondary education (levels 0-2)From 15 to 74 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Percentage of population in the labour forceGreece1998-Q115.1
QuarterlyFemalesLess than primary, primary and lower secondary education (levels 0-2)From 15 to 74 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Percentage of population in the labour forceSpain1998-Q128.9
QuarterlyFemalesLess than primary, primary and lower secondary education (levels 0-2)From 15 to 74 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Percentage of population in the labour forcePortugal1998-Q17.6
QuarterlyFemalesLess than primary, primary and lower secondary education (levels 0-2)From 15 to 74 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Percentage of population in the labour forceSlovakia1998-Q124.4
QuarterlyFemalesLess than primary, primary and lower secondary education (levels 0-2)From 15 to 74 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Percentage of unemploymentCzechia1998-Q127.3
QuarterlyFemalesLess than primary, primary and lower secondary education (levels 0-2)From 15 to 74 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Percentage of unemploymentGreece1998-Q134.9
QuarterlyFemalesLess than primary, primary and lower secondary education (levels 0-2)From 15 to 74 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Percentage of unemploymentSpain1998-Q155.4
QuarterlyFemalesLess than primary, primary and lower secondary education (levels 0-2)From 15 to 74 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Percentage of unemploymentPortugal1998-Q178.6
QuarterlyFemalesLess than primary, primary and lower secondary education (levels 0-2)From 15 to 74 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Percentage of unemploymentSlovakia1998-Q126.8

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

Share link

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