Baselight

Economically Active Population By Sex, Age And Other Typologies

Eurostat code: urt_lfp3pop ยท (1999 - 2023)

@eurostat.urt_lfp3pop

Economically Active Population By Sex, Age And Other Typologies - Unpivoted
@eurostat.urt_lfp3pop.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.

  • 274.57 KB
  • 69682 rows
  • 8 columns
freq

Freq

unit

Unit

age

Age

sex

Sex

terrtypo

Terrtypo

geo

Geo

time_period

Time Period

value

Value

AnnualThousand personsFrom 15 to 24 yearsFemalesBorder regionsAustria1999220
AnnualThousand personsFrom 15 to 24 yearsFemalesBorder regionsCzechia1999293.8
AnnualThousand personsFrom 15 to 24 yearsFemalesBorder regionsEstonia199911.8
AnnualThousand personsFrom 15 to 24 yearsFemalesBorder regionsGreece199937.1
AnnualThousand personsFrom 15 to 24 yearsFemalesBorder regionsSpain1999320.7
AnnualThousand personsFrom 15 to 24 yearsFemalesBorder regionsHungary1999196.8
AnnualThousand personsFrom 15 to 24 yearsFemalesBorder regionsIreland199944.2
AnnualThousand personsFrom 15 to 24 yearsFemalesBorder regionsLithuania199976.2
AnnualThousand personsFrom 15 to 24 yearsFemalesBorder regionsLuxembourg19997.6
AnnualThousand personsFrom 15 to 24 yearsFemalesBorder regionsLatvia199937.9

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

Share link

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