Baselight
Sign In

Persons At Two-fold Risk Of Poverty By Household Type - Experimental Statistics

Eurostat code: icw_pov_11 ยท (2010 - 2020)

@eurostat.icw_pov_11

Persons At Two-fold Risk Of Poverty By Household Type - Experimental Statistics - Unpivoted
@eurostat.icw_pov_11.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.

  • 9.32 KB
  • 1469 rows
  • 7 columns
freq

Freq

hhcomp

Hhcomp

indic_il

Indic Il

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualOne adultConsumption poverty and liquid financial assets povertyPercentageAustria20106.4
AnnualOne adultConsumption poverty and liquid financial assets povertyPercentageBelgium20104.4
AnnualOne adultConsumption poverty and liquid financial assets povertyPercentageCyprus201037.2
AnnualOne adultConsumption poverty and liquid financial assets povertyPercentageGermany20106.1
AnnualOne adultConsumption poverty and liquid financial assets povertyPercentageGreece201013.9
AnnualOne adultConsumption poverty and liquid financial assets povertyPercentageSpain20106.8
AnnualOne adultConsumption poverty and liquid financial assets povertyPercentageFinland201014.4
AnnualOne adultConsumption poverty and liquid financial assets povertyPercentageFrance20109.2
AnnualOne adultConsumption poverty and liquid financial assets povertyPercentageItaly20106.3
AnnualOne adultConsumption poverty and liquid financial assets povertyPercentageLuxembourg20103.9

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