Population By Type Of Longstanding Health Problem, Sex And Age

Eurostat code: hlth_dp020 · (2011 - 2011)

@eurostat.hlth_dp020

Table List

2 tables(126.57 KB)

Population By Type Of Longstanding Health Problem, Sex And Age - Raw

Population By Type Of Longstanding Health Problem, Sex And Age - Unpivoted

Population By Type Of Longstanding Health Problem, Sex And Age - Unpivoted

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

64.11 KB
8394 rows
8 columns

freq Freq	unit Unit	hlth_pb Hlth Pb	age Age	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Thousand	No response	Total	Females	Switzerland	2011	9.428
Annual	Thousand	No response	Total	Females	Czechia	2011	3.114
Annual	Thousand	No response	Total	Females	Germany	2011	870.834
Annual	Thousand	No response	Total	Females	Denmark	2011	8.31
Annual	Thousand	No response	Total	Females	Finland	2011	6.013
Annual	Thousand	No response	Total	Females	Hungary	2011	17.909
Annual	Thousand	No response	Total	Females	Ireland	2011	3.575
Annual	Thousand	No response	Total	Females	Iceland	2011	1.826
Annual	Thousand	No response	Total	Females	Italy	2011	119.091
Annual	Thousand	No response	Total	Females	Netherlands	2011	15.224


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

Share link

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