Baselight
Sign In

At-risk-of-poverty Rate By Group Of Citizenship (population Aged 18 And Over)

Eurostat code: ilc_li31$dv_1981

@eurostat.ilc_li31_dv_1981

At-risk-of-poverty Rate By Group Of Citizenship (population Aged 18 And Over) - Unpivoted
@eurostat.ilc_li31_dv_1981.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.

  • 28.66 KB
  • 12451 rows
  • 8 columns
freq

Freq

citizen

Citizen

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 29 yearsFemalesPercentageAustria201533.7
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 29 yearsFemalesPercentageBelgium201524.3
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 29 yearsFemalesPercentageSwitzerland201522.9
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 29 yearsFemalesPercentageCyprus201540.5
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 29 yearsFemalesPercentageGermany201530
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 29 yearsFemalesPercentageGreece201537.6
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 29 yearsFemalesPercentageSpain201522.8
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 29 yearsFemalesPercentageIreland201524.9
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 29 yearsFemalesPercentageIceland20158.9
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 29 yearsFemalesPercentageItaly201532.4

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

Share link

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