Baselight

People Having A Long-standing Illness Or Health Problem, By Sex, Age And Groups Of Country Of Birth

Eurostat code: hlth_silc_25 ยท (2008 - 2024)

@eurostat.hlth_silc_25

People Having A Long-standing Illness Or Health Problem, By Sex, Age And Groups Of Country Of Birth - Unpivoted
@eurostat.hlth_silc_25.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.

  • 188.74 KB
  • 106638 rows
  • 8 columns
freq

Freq

sex

Sex

age

Age

c_birth

C Birth

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesFrom 16 to 24 yearsEU27 countries (2007-2013) except reporting countryPercentageAustria200825.5
AnnualFemalesFrom 16 to 24 yearsEU27 countries (2007-2013) except reporting countryPercentageBelgium200816.4
AnnualFemalesFrom 16 to 24 yearsEU27 countries (2007-2013) except reporting countryPercentageSwitzerland200829.6
AnnualFemalesFrom 16 to 24 yearsEU27 countries (2007-2013) except reporting countryPercentageCyprus20089.4
AnnualFemalesFrom 16 to 24 yearsEU27 countries (2007-2013) except reporting countryPercentageCzechia200836.9
AnnualFemalesFrom 16 to 24 yearsEU27 countries (2007-2013) except reporting countryPercentageGermany200831.6
AnnualFemalesFrom 16 to 24 yearsEU27 countries (2007-2013) except reporting countryPercentageEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)200828.9
AnnualFemalesFrom 16 to 24 yearsEU27 countries (2007-2013) except reporting countryPercentageEuro area - 18 countries (2014)200829
AnnualFemalesFrom 16 to 24 yearsEU27 countries (2007-2013) except reporting countryPercentageEuro area - 19 countries (2015-2022)200829
AnnualFemalesFrom 16 to 24 yearsEU27 countries (2007-2013) except reporting countryPercentageSpain200816.3

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

Share link

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