Baselight
Sign In

Severe Material Deprivation Rate By Group Of Citizenship (population Aged 18 And Over)

Eurostat code: ilc_mddd15 ยท (2003 - 2020)

@eurostat.ilc_mddd15

Severe Material Deprivation Rate By Group Of Citizenship (population Aged 18 And Over) - Unpivoted
@eurostat.ilc_mddd15.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.

  • 148.56 KB
  • 93656 rows
  • 8 columns
freq

Freq

citizen

Citizen

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEU27 countries (2007-2013) except reporting countryFrom 16 to 29 yearsFemalesPercentageAustria2003
AnnualEU27 countries (2007-2013) except reporting countryFrom 16 to 29 yearsFemalesPercentageBelgium200313.7
AnnualEU27 countries (2007-2013) except reporting countryFrom 16 to 29 yearsFemalesPercentageIreland200314.2
AnnualEU27 countries (2007-2013) except reporting countryFrom 16 to 29 yearsFemalesPercentageLuxembourg20032.1
AnnualEU27 countries (2007-2013) except reporting countryFrom 16 to 29 yearsMalesPercentageBelgium20034.6
AnnualEU27 countries (2007-2013) except reporting countryFrom 16 to 29 yearsMalesPercentageGreece200330.4
AnnualEU27 countries (2007-2013) except reporting countryFrom 16 to 29 yearsMalesPercentageLuxembourg20031.4
AnnualEU27 countries (2007-2013) except reporting countryFrom 16 to 29 yearsMalesPercentageNorway200314.3
AnnualEU27 countries (2007-2013) except reporting countryFrom 16 to 29 yearsTotalPercentageAustria20035.7
AnnualEU27 countries (2007-2013) except reporting countryFrom 16 to 29 yearsTotalPercentageBelgium20039.9

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