Long-term Unemployment By Sex (1992-2020) - Quarterly Data

Eurostat code: une_ltu_q_h · (1992-Q2 - 2020-Q4)

@eurostat.une_ltu_q_h

Table List

2 tables(1.49 MB)

Long-term Unemployment By Sex (1992-2020) - Quarterly Data - Raw

Long-term Unemployment By Sex (1992-2020) - Quarterly Data - Unpivoted

Long-term Unemployment By Sex (1992-2020) - Quarterly Data - Unpivoted

@eurostat.une_ltu_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.

608.44 KB
318498 rows
9 columns

freq Freq	indic_em Indic Em	age Age	unit Unit	s_adj S Adj	sex Sex	geo Geo	time_period Time Period	value Value
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Greece	1992-Q2	7.3
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Spain	1992-Q2	13.2
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	Portugal	1992-Q2	1.7
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Males	Greece	1992-Q2	1.9
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Males	Spain	1992-Q2	4.6
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Males	Portugal	1992-Q2	0.8
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total	Greece	1992-Q2	3.9
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total	Spain	1992-Q2	7.7
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total	Portugal	1992-Q2	1.2
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Females	Greece	1992-Q2	7.3


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

Share link

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