Baselight
Sign In

Persons At Two-fold Risk Of Poverty By Activity Status- Experimental Statistics

Eurostat code: icw_pov_12 ยท (2010 - 2020)

@eurostat.icw_pov_12

Persons At Two-fold Risk Of Poverty By Activity Status- Experimental Statistics - Unpivoted
@eurostat.icw_pov_12.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.61 KB
  • 1633 rows
  • 7 columns
freq

Freq

wstatus

Wstatus

indic_il

Indic Il

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEmployed personsConsumption poverty and liquid financial assets povertyPercentageAustria20103.3
AnnualEmployed personsConsumption poverty and liquid financial assets povertyPercentageBelgium20103.7
AnnualEmployed personsConsumption poverty and liquid financial assets povertyPercentageCyprus20108.3
AnnualEmployed personsConsumption poverty and liquid financial assets povertyPercentageGermany20103.7
AnnualEmployed personsConsumption poverty and liquid financial assets povertyPercentageGreece20108.1
AnnualEmployed personsConsumption poverty and liquid financial assets povertyPercentageSpain20106.7
AnnualEmployed personsConsumption poverty and liquid financial assets povertyPercentageFinland20104
AnnualEmployed personsConsumption poverty and liquid financial assets povertyPercentageFrance20105.4
AnnualEmployed personsConsumption poverty and liquid financial assets povertyPercentageItaly20105.1
AnnualEmployed personsConsumption poverty and liquid financial assets povertyPercentageLuxembourg20106.7

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