Baselight

At-risk-of-poverty Rate After Deducting Housing Costs By Age And Sex

Eurostat code: ilc_li45 ยท (2003 - 2024)

@eurostat.ilc_li45

At-risk-of-poverty Rate After Deducting Housing Costs By Age And Sex - Unpivoted
@eurostat.ilc_li45.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.

  • 23.4 KB
  • 11550 rows
  • 7 columns
freq

Freq

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesTotalPercentageIreland200329.5
AnnualFemalesTotalPercentageLuxembourg200323
AnnualFemalesFrom 18 to 64 yearsPercentageIreland200323.6
AnnualFemalesFrom 18 to 64 yearsPercentageLuxembourg200322.2
AnnualFemales18 years or overPercentageIreland200329.6
AnnualFemales18 years or overPercentageLuxembourg200321.6
AnnualFemales65 years or overPercentageIreland200359.2
AnnualFemales65 years or overPercentageLuxembourg200318.8
AnnualFemalesLess than 18 yearsPercentageIreland200329
AnnualFemalesLess than 18 yearsPercentageLuxembourg200328

CREATE TABLE tidy (
  "freq" 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.