Severity Of Bodily Pain By Level Of Disability (activity Limitation), Sex And Age

Eurostat code: hlth_ehis_pn1d · (2014 - 2019)

@eurostat.hlth_ehis_pn1d

Table List

2 tables(179.36 KB)

Severity Of Bodily Pain By Level Of Disability (activity Limitation), Sex And Age - Raw

Severity Of Bodily Pain By Level Of Disability (activity Limitation), Sex And Age - Unpivoted

Severity Of Bodily Pain By Level Of Disability (activity Limitation), Sex And Age - Unpivoted

@eurostat.hlth_ehis_pn1d.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.

85.33 KB
57612 rows
9 columns

freq Freq	lev_perc Lev Perc	lev_limit Lev Limit	sex Sex	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Mild	Moderate	Females	Total	Percentage	Austria	2014	28.7
Annual	Mild	Moderate	Females	Total	Percentage	Belgium	2014	17.1
Annual	Mild	Moderate	Females	Total	Percentage	Bulgaria	2014	20.6
Annual	Mild	Moderate	Females	Total	Percentage	Cyprus	2014	11.8
Annual	Mild	Moderate	Females	Total	Percentage	Czechia	2014	25.5
Annual	Mild	Moderate	Females	Total	Percentage	Germany	2014	17.1
Annual	Mild	Moderate	Females	Total	Percentage	Denmark	2014	34.8
Annual	Mild	Moderate	Females	Total	Percentage	Estonia	2014	19.6
Annual	Mild	Moderate	Females	Total	Percentage	Greece	2014	15.2
Annual	Mild	Moderate	Females	Total	Percentage	Spain	2014	19.1


CREATE TABLE tidy (
  "freq" VARCHAR,
  "lev_perc" VARCHAR,
  "lev_limit" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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