Baselight

In-work At-risk-of-poverty Rate By Sex

Eurostat code: tesov110 ยท (2005 - 2024)

@eurostat.tesov110

In-work At-risk-of-poverty Rate By Sex - Unpivoted
@eurostat.tesov110.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.62 KB
  • 2142 rows
  • 8 columns
freq

Freq

wstatus

Wstatus

unit

Unit

age

Age

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualEmployed personsPercentage18 years or overFemalesAustria20056.1
AnnualEmployed personsPercentage18 years or overFemalesBelgium20053.1
AnnualEmployed personsPercentage18 years or overFemalesCyprus20056.6
AnnualEmployed personsPercentage18 years or overFemalesCzechia20053.6
AnnualEmployed personsPercentage18 years or overFemalesGermany20055.5
AnnualEmployed personsPercentage18 years or overFemalesDenmark20054.8
AnnualEmployed personsPercentage18 years or overFemalesEuro area - 19 countries (2015-2022)20056.5
AnnualEmployed personsPercentage18 years or overFemalesEstonia20058.1
AnnualEmployed personsPercentage18 years or overFemalesGreece200511.6
AnnualEmployed personsPercentage18 years or overFemalesSpain20059.1

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

Share link

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