Baselight

Overall Perceived Social Support By Sex, Age And Degree Of Urbanisation

Eurostat code: hlth_ehis_ss1u ยท (2014 - 2019)

@eurostat.hlth_ehis_ss1u

Overall Perceived Social Support By Sex, Age And Degree Of Urbanisation - Unpivoted
@eurostat.hlth_ehis_ss1u.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.

  • 48.15 KB
  • 29724 rows
  • 9 columns
freq

Freq

lev_perc

Lev Perc

deg_urb

Deg Urb

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualIntermediateCitiesFemalesTotalPercentageAustria201440
AnnualIntermediateCitiesFemalesTotalPercentageBelgium201452.5
AnnualIntermediateCitiesFemalesTotalPercentageBulgaria201456.9
AnnualIntermediateCitiesFemalesTotalPercentageCyprus201442.2
AnnualIntermediateCitiesFemalesTotalPercentageCzechia201451.1
AnnualIntermediateCitiesFemalesTotalPercentageGermany201452.7
AnnualIntermediateCitiesFemalesTotalPercentageDenmark201448.1
AnnualIntermediateCitiesFemalesTotalPercentageEstonia201461.5
AnnualIntermediateCitiesFemalesTotalPercentageGreece201453.7
AnnualIntermediateCitiesFemalesTotalPercentageSpain201437.2

CREATE TABLE tidy (
  "freq" VARCHAR,
  "lev_perc" VARCHAR,
  "deg_urb" 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.