Persons Reporting Basic Activity Difficulty By Sex, Age, Level Of Difficulty And Degree Of Urbanization

Eurostat code: ilc_hch18$dv_2263

@eurostat.ilc_hch18_dv_2263

Table List

2 tables(13.29 KB)

Persons Reporting Basic Activity Difficulty By Sex, Age, Level Of Difficulty And Degree Of Urbanization - Raw

Persons Reporting Basic Activity Difficulty By Sex, Age, Level Of Difficulty And Degree Of Urbanization - Unpivoted

Persons Reporting Basic Activity Difficulty By Sex, Age, Level Of Difficulty And Degree Of Urbanization - Unpivoted

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

6.95 KB
124 rows
9 columns

freq Freq	lev_diff Lev Diff	deg_urb Deg Urb	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Severe	Cities	Total	Total	Percentage	Austria	2022	8.8
Annual	Severe	Cities	Total	Total	Percentage	Belgium	2022	7.4
Annual	Severe	Cities	Total	Total	Percentage	Bulgaria	2022	4.8
Annual	Severe	Cities	Total	Total	Percentage	Switzerland	2022	7.3
Annual	Severe	Cities	Total	Total	Percentage	Cyprus	2022	6.2
Annual	Severe	Cities	Total	Total	Percentage	Czechia	2022	8
Annual	Severe	Cities	Total	Total	Percentage	Denmark	2022	12.5
Annual	Severe	Cities	Total	Total	Percentage	Euro area – 20 countries (from 2023)	2022	9.7
Annual	Severe	Cities	Total	Total	Percentage	Estonia	2022	11.6
Annual	Severe	Cities	Total	Total	Percentage	Greece	2022	6.4


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

Share link

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