Baselight
Sign In

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

Eurostat code: ilc_li32$dv_1965

@eurostat.ilc_li32_dv_1965

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

  • 35.17 KB
  • 17087 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 24 yearsFemalesPercentageAustria201528
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 24 yearsFemalesPercentageBelgium201532.6
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 24 yearsFemalesPercentageSwitzerland201532.8
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 24 yearsFemalesPercentageCyprus201530.7
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 24 yearsFemalesPercentageSpain201528.5
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 24 yearsFemalesPercentageIreland201534.7
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 24 yearsFemalesPercentageIceland201515.7
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 24 yearsFemalesPercentageItaly201541.5
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 24 yearsFemalesPercentageLuxembourg201529.6
AnnualEU27 countries (from 2020) except reporting countryFrom 16 to 24 yearsFemalesPercentageUnited Kingdom201548.4

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.