Baselight
Login
Login

Severe Material And Social Deprivation By Age, Sex And Most Frequent Activity Status

Eurostat code: ilc_mdsd12 ยท (2015 - 2024)

@eurostat.ilc_mdsd12

Severe Material And Social Deprivation By Age, Sex And Most Frequent Activity Status - Unpivoted
@eurostat.ilc_mdsd12.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.

  • 232.29 KB
  • 157827 rows
  • 8 columns
freq

Freq

wstatus

Wstatus

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEmployed personsFrom 16 to 19 yearsFemalesPercentageAustria2015
AnnualEmployed personsFrom 16 to 19 yearsFemalesPercentageSwitzerland20150.6
AnnualEmployed personsFrom 16 to 19 yearsFemalesPercentageGermany2015
AnnualEmployed personsFrom 16 to 19 yearsFemalesPercentageFinland2015
AnnualEmployed personsFrom 16 to 19 yearsFemalesPercentageIceland2015
AnnualEmployed personsFrom 16 to 19 yearsFemalesPercentageMalta2015
AnnualEmployed personsFrom 16 to 19 yearsFemalesPercentageNorway2015
AnnualEmployed personsFrom 16 to 19 yearsFemalesPercentageSweden2015
AnnualEmployed personsFrom 16 to 19 yearsMalesPercentageAustria2015
AnnualEmployed personsFrom 16 to 19 yearsMalesPercentageSwitzerland2015

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