Self-perceived Health By Sex, Age And Income Quintile

Eurostat code: hlth_silc_10$dv_2042

@eurostat.hlth_silc_10_dv_2042

Table List

2 tables(806.03 KB)

Self-perceived Health By Sex, Age And Income Quintile - Raw

Self-perceived Health By Sex, Age And Income Quintile - Unpivoted

Self-perceived Health By Sex, Age And Income Quintile - Unpivoted

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

376.87 KB
276475 rows
9 columns

freq Freq	unit Unit	quantile Quantile	age Age	sex Sex	levels Levels	geo Geo	time_period Time Period	value Value
Annual	Percentage	First quintile	From 16 to 24 years	Females	Bad	Austria	2015	0.6
Annual	Percentage	First quintile	From 16 to 24 years	Females	Bad	Belgium	2015	3.6
Annual	Percentage	First quintile	From 16 to 24 years	Females	Bad	Bulgaria	2015	2.1
Annual	Percentage	First quintile	From 16 to 24 years	Females	Bad	Switzerland	2015	0.7
Annual	Percentage	First quintile	From 16 to 24 years	Females	Bad	Cyprus	2015	0.8
Annual	Percentage	First quintile	From 16 to 24 years	Females	Bad	Czechia	2015	2.1
Annual	Percentage	First quintile	From 16 to 24 years	Females	Bad	Germany	2015	4.2
Annual	Percentage	First quintile	From 16 to 24 years	Females	Bad	Denmark	2015	3.3
Annual	Percentage	First quintile	From 16 to 24 years	Females	Bad	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2015	2.1
Annual	Percentage	First quintile	From 16 to 24 years	Females	Bad	Euro area - 18 countries (2014)	2015	2.1


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

Share link

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