Baselight
Sign In

Persons At Two-fold Risk Of Poverty By Age And Sex - Experimental Statistics

Eurostat code: icw_pov_10 ยท (2010 - 2020)

@eurostat.icw_pov_10

Persons At Two-fold Risk Of Poverty By Age And Sex - Experimental Statistics - Unpivoted
@eurostat.icw_pov_10.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.

  • 13.18 KB
  • 4410 rows
  • 8 columns
freq

Freq

sex

Sex

age

Age

indic_il

Indic Il

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesTotalConsumption poverty and liquid financial assets povertyPercentageAustria20105.5
AnnualFemalesTotalConsumption poverty and liquid financial assets povertyPercentageBelgium20106.6
AnnualFemalesTotalConsumption poverty and liquid financial assets povertyPercentageCyprus201012.8
AnnualFemalesTotalConsumption poverty and liquid financial assets povertyPercentageGermany20106.3
AnnualFemalesTotalConsumption poverty and liquid financial assets povertyPercentageGreece201015.4
AnnualFemalesTotalConsumption poverty and liquid financial assets povertyPercentageSpain201010.7
AnnualFemalesTotalConsumption poverty and liquid financial assets povertyPercentageFinland20107.5
AnnualFemalesTotalConsumption poverty and liquid financial assets povertyPercentageFrance20108.5
AnnualFemalesTotalConsumption poverty and liquid financial assets povertyPercentageItaly20108.1
AnnualFemalesTotalConsumption poverty and liquid financial assets povertyPercentageLuxembourg20108.7

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

Share link

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