Baselight

Relative Poverty Gap By Risk Of Poverty And Work Intensity Of The Household

Eurostat code: ilc_li12 ยท (2014 - 2024)

@eurostat.ilc_li12

Relative Poverty Gap By Risk Of Poverty And Work Intensity Of The Household - Unpivoted
@eurostat.ilc_li12.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.

  • 12.17 KB
  • 2238 rows
  • 8 columns
freq

Freq

workint

Workint

yn_rskpov

Yn Rskpov

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualTotalAt risk of povertyFrom 16 to 64 yearsPercentageCroatia201427.9
AnnualTotalAt risk of povertyFrom 18 to 64 yearsPercentageCroatia201428
AnnualVery low work intensity (0-0.2)TotalFrom 16 to 64 yearsPercentageCroatia201432.7
AnnualVery low work intensity (0-0.2)TotalFrom 18 to 64 yearsPercentageCroatia201432.9
AnnualVery low work intensity (0-0.2)At risk of povertyFrom 16 to 64 yearsPercentageCroatia201444.6
AnnualVery low work intensity (0-0.2)At risk of povertyFrom 18 to 64 yearsPercentageCroatia201445.3
AnnualTotalAt risk of povertyFrom 16 to 64 yearsPercentageAustria201521.7
AnnualTotalAt risk of povertyFrom 16 to 64 yearsPercentageBelgium201519.7
AnnualTotalAt risk of povertyFrom 16 to 64 yearsPercentageBulgaria201534.5
AnnualTotalAt risk of povertyFrom 16 to 64 yearsPercentageSwitzerland201520.3

CREATE TABLE tidy (
  "freq" VARCHAR,
  "workint" VARCHAR,
  "yn_rskpov" 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.