Unemployment Rate (%) - Monthly Data
Eurostat code: ei_lmhr_m ยท (1983-01 - 2025-03)
@eurostat.ei_lmhr_m
Unemployment Rate (%) - Monthly Data - Unpivoted
@eurostat.ei_lmhr_m.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.
- 321.3 KB
- 242575 rows
- 7 columns
freqFreq | unitUnit | s_adjS Adj | indicIndic | geoGeo | time_periodTime Period | valueValue |
|---|---|---|---|---|---|---|
| Monthly | Percentage of population in the labour force | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Unemployment according to ILO definition - over 25 years - females | Denmark | 1983-01 | 6.8 |
| Monthly | Percentage of population in the labour force | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Unemployment according to ILO definition - over 25 years - females | Ireland | 1983-01 | 12.9 |
| Monthly | Percentage of population in the labour force | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Unemployment according to ILO definition - over 25 years - females | Italy | 1983-01 | 6.5 |
| Monthly | Percentage of population in the labour force | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Unemployment according to ILO definition - over 25 years - females | Japan | 1983-01 | 2.5 |
| Monthly | Percentage of population in the labour force | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Unemployment according to ILO definition - over 25 years - females | Luxembourg | 1983-01 | 3.7 |
| Monthly | Percentage of population in the labour force | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Unemployment according to ILO definition - over 25 years - females | Netherlands | 1983-01 | 9.9 |
| Monthly | Percentage of population in the labour force | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Unemployment according to ILO definition - over 25 years - females | Sweden | 1983-01 | 2.6 |
| Monthly | Percentage of population in the labour force | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Unemployment according to ILO definition - over 25 years - females | United Kingdom | 1983-01 | 6.9 |
| Monthly | Percentage of population in the labour force | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Unemployment according to ILO definition - over 25 years - females | United States | 1983-01 | 8.4 |
| Monthly | Percentage of population in the labour force | Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data) | Unemployment according to ILO definition - under 25 years - females | Denmark | 1983-01 | 17.7 |
CREATE TABLE tidy (
"freq" VARCHAR,
"unit" VARCHAR,
"s_adj" VARCHAR,
"indic" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);