Baselight

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

Eurostat code: ilc_iw01 ยท (2003 - 2024)

@eurostat.ilc_iw01

In-work At-risk-of-poverty Rate By Age And Sex - Unpivoted
@eurostat.ilc_iw01.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.

  • 95.44 KB
  • 60963 rows
  • 8 columns
freq

Freq

wstatus

Wstatus

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEmployed personsFemalesFrom 16 to 19 yearsPercentageAustria20033
AnnualEmployed personsFemalesFrom 16 to 19 yearsPercentageGreece200318
AnnualEmployed personsFemalesFrom 16 to 19 yearsPercentageIreland20032.2
AnnualEmployed personsFemalesFrom 16 to 19 yearsPercentageLuxembourg200320.8
AnnualEmployed personsFemalesFrom 16 to 19 yearsPercentageNorway200339.5
AnnualEmployed personsFemalesFrom 16 to 24 yearsPercentageAustria20036.1
AnnualEmployed personsFemalesFrom 16 to 24 yearsPercentageBelgium20034.3
AnnualEmployed personsFemalesFrom 16 to 24 yearsPercentageDenmark200322.8
AnnualEmployed personsFemalesFrom 16 to 24 yearsPercentageGreece200313.5
AnnualEmployed personsFemalesFrom 16 to 24 yearsPercentageIreland20035.7

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

Share link

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