Overall Perceived Social Support By Sex, Age And Country Of Citizenship

Eurostat code: hlth_ehis_ss1c$dv_2108

@eurostat.hlth_ehis_ss1c_dv_2108

Table List

2 tables(32.31 KB)

Overall Perceived Social Support By Sex, Age And Country Of Citizenship - Raw

Overall Perceived Social Support By Sex, Age And Country Of Citizenship - Unpivoted

Overall Perceived Social Support By Sex, Age And Country Of Citizenship - Unpivoted

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

15.05 KB
3903 rows
9 columns

freq Freq	unit Unit	lev_perc Lev Perc	sex Sex	age Age	citizen Citizen	geo Geo	time_period Time Period	value Value
Annual	Percentage	Intermediate	Females	Total	Foreign country	Austria	2014	42.8
Annual	Percentage	Intermediate	Females	Total	Foreign country	Belgium	2014	45.5
Annual	Percentage	Intermediate	Females	Total	Foreign country	Cyprus	2014	54.9
Annual	Percentage	Intermediate	Females	Total	Foreign country	Czechia	2014	54.2
Annual	Percentage	Intermediate	Females	Total	Foreign country	Germany	2014	53.5
Annual	Percentage	Intermediate	Females	Total	Foreign country	Denmark	2014	50.1
Annual	Percentage	Intermediate	Females	Total	Foreign country	Estonia	2014	61.3
Annual	Percentage	Intermediate	Females	Total	Foreign country	Greece	2014	59.3
Annual	Percentage	Intermediate	Females	Total	Foreign country	Spain	2014	56.1
Annual	Percentage	Intermediate	Females	Total	Foreign country	European Union - 27 countries (from 2020)	2014	51.7


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

Share link

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