Baselight

Employment By Sex, Age And Other Typologies

Eurostat code: urt_lfe3emp ยท (1999 - 2023)

@eurostat.urt_lfe3emp

Employment By Sex, Age And Other Typologies - Unpivoted
@eurostat.urt_lfe3emp.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.

  • 136.42 KB
  • 27390 rows
  • 8 columns
freq

Freq

unit

Unit

sex

Sex

age

Age

terrtypo

Terrtypo

geo

Geo

time_period

Time Period

value

Value

AnnualThousand personsFemalesFrom 15 to 64 yearsBorder regionsAustria19991421
AnnualThousand personsFemalesFrom 15 to 64 yearsBorder regionsEstonia1999128.2
AnnualThousand personsFemalesFrom 15 to 64 yearsBorder regionsGreece1999196.9
AnnualThousand personsFemalesFrom 15 to 64 yearsBorder regionsSpain19991595.3
AnnualThousand personsFemalesFrom 15 to 64 yearsBorder regionsHungary19991204.5
AnnualThousand personsFemalesFrom 15 to 64 yearsBorder regionsIreland1999210.2
AnnualThousand personsFemalesFrom 15 to 64 yearsBorder regionsLithuania1999576.9
AnnualThousand personsFemalesFrom 15 to 64 yearsBorder regionsLuxembourg199968.5
AnnualThousand personsFemalesFrom 15 to 64 yearsBorder regionsLatvia1999295.6
AnnualThousand personsFemalesFrom 15 to 64 yearsBorder regionsRomania19992189.6

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

Share link

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