Baselight

Employment Rates By Sex, Age And Other Typologies

Eurostat code: urt_lfe3emprt$dv_1586

@eurostat.urt_lfe3emprt_dv_1586

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

  • 9.28 KB
  • 1332 rows
  • 8 columns
freq

Freq

unit

Unit

sex

Sex

age

Age

terrtypo

Terrtypo

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageFemalesFrom 15 to 64 yearsCoastal regionsBelgium201462.1
AnnualPercentageFemalesFrom 15 to 64 yearsCoastal regionsBulgaria201455.4
AnnualPercentageFemalesFrom 15 to 64 yearsCoastal regionsCyprus201458.6
AnnualPercentageFemalesFrom 15 to 64 yearsCoastal regionsDenmark201468
AnnualPercentageFemalesFrom 15 to 64 yearsCoastal regionsEstonia201466.4
AnnualPercentageFemalesFrom 15 to 64 yearsCoastal regionsGreece201441.1
AnnualPercentageFemalesFrom 15 to 64 yearsCoastal regionsSpain201450.9
AnnualPercentageFemalesFrom 15 to 64 yearsCoastal regionsFinland201468.4
AnnualPercentageFemalesFrom 15 to 64 yearsCoastal regionsCroatia201450.8
AnnualPercentageFemalesFrom 15 to 64 yearsCoastal regionsIreland201458.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.