Baselight

People Declaring Physical Pain Or Physical Discomfort By Sex, Age And Educational Attainment Level (%)

Eurostat code: hlth_ehis_st4 ยท (2008 - 2008)

@eurostat.hlth_ehis_st4

People Declaring Physical Pain Or Physical Discomfort By Sex, Age And Educational Attainment Level (%) - Unpivoted
@eurostat.hlth_ehis_st4.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.

  • 18.69 KB
  • 6288 rows
  • 8 columns
freq

Freq

sex

Sex

age

Age

levels

Levels

isced97

Isced97

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesTotalLowPre-primary, primary and lower secondary education (levels 0-2)Bulgaria200817.6
AnnualFemalesTotalLowPre-primary, primary and lower secondary education (levels 0-2)Cyprus200820.3
AnnualFemalesTotalLowPre-primary, primary and lower secondary education (levels 0-2)Czechia200819.4
AnnualFemalesTotalLowPre-primary, primary and lower secondary education (levels 0-2)Estonia200822.7
AnnualFemalesTotalLowPre-primary, primary and lower secondary education (levels 0-2)Greece200830.8
AnnualFemalesTotalLowPre-primary, primary and lower secondary education (levels 0-2)Spain200810.7
AnnualFemalesTotalLowPre-primary, primary and lower secondary education (levels 0-2)Hungary200830.1
AnnualFemalesTotalLowPre-primary, primary and lower secondary education (levels 0-2)Latvia200827
AnnualFemalesTotalLowPre-primary, primary and lower secondary education (levels 0-2)Malta200835.9
AnnualFemalesTotalLowPre-primary, primary and lower secondary education (levels 0-2)Poland200820.5

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

Share link

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