Baselight
Sign In

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

Eurostat code: ilc_iw15$dv_1992

@eurostat.ilc_iw15_dv_1992

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

  • 27.29 KB
  • 13281 rows
  • 8 columns
freq

Freq

unit

Unit

citizen

Citizen

sex

Sex

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageEU27 countries (from 2020) except reporting countryFemalesFrom 16 to 29 yearsAustria201521.4
AnnualPercentageEU27 countries (from 2020) except reporting countryFemalesFrom 16 to 29 yearsBelgium201512.5
AnnualPercentageEU27 countries (from 2020) except reporting countryFemalesFrom 16 to 29 yearsSwitzerland201517.3
AnnualPercentageEU27 countries (from 2020) except reporting countryFemalesFrom 16 to 29 yearsCyprus201520.2
AnnualPercentageEU27 countries (from 2020) except reporting countryFemalesFrom 16 to 29 yearsSpain20155.9
AnnualPercentageEU27 countries (from 2020) except reporting countryFemalesFrom 16 to 29 yearsIreland20153.2
AnnualPercentageEU27 countries (from 2020) except reporting countryFemalesFrom 16 to 29 yearsIceland201511.5
AnnualPercentageEU27 countries (from 2020) except reporting countryFemalesFrom 16 to 29 yearsItaly201526.3
AnnualPercentageEU27 countries (from 2020) except reporting countryFemalesFrom 16 to 29 yearsLuxembourg201511.1
AnnualPercentageEU27 countries (from 2020) except reporting countryFemalesFrom 16 to 29 yearsUnited Kingdom20159.3

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

Share link

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