Baselight
Sign In

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

Eurostat code: ilc_li32$dv_1321

@eurostat.ilc_li32_dv_1321

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

  • 25.73 KB
  • 10467 rows
  • 8 columns
freq

Freq

c_birth

C Birth

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 19 yearsFemalesPercentageSwitzerland201535.7
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 19 yearsFemalesPercentageIreland201544.6
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 19 yearsFemalesPercentageIceland2015
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 19 yearsFemalesPercentageItaly201543.3
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 19 yearsFemalesPercentageLuxembourg201530.1
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 19 yearsMalesPercentageSwitzerland201510.8
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 19 yearsMalesPercentageIreland201535.7
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 19 yearsMalesPercentageLuxembourg201520.6
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 19 yearsTotalPercentageBelgium201546
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 19 yearsTotalPercentageSwitzerland201524.1

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