Long-term Unemployment By Sex - Quarterly Data

Eurostat code: une_ltu_q · (2003-Q1 - 2024-Q4)

@eurostat.une_ltu_q

Table List

2 tables(755.23 KB)

Long-term Unemployment By Sex - Quarterly Data - Raw

Long-term Unemployment By Sex - Quarterly Data - Unpivoted

Long-term Unemployment By Sex - Quarterly Data - Unpivoted

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

270.99 KB
148863 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	France	2003-Q1	2.4
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	France	2003-Q1	2.1
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	France	2003-Q1	2.3
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Females	France	2003-Q1	2.3
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Males	France	2003-Q1	2
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Seasonally adjusted data, not calendar adjusted data	Total	France	2003-Q1	2.1
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Trend cycle data	Females	France	2003-Q1	2.3
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Trend cycle data	Males	France	2003-Q1	2
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of population in the labour force	Trend cycle data	Total	France	2003-Q1	2.2
Quarterly	Long-term unemployment	From 15 to 74 years	Percentage of unemployment	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Females	France	2003-Q1	25.6


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.