Satisfaction With The Job By Risk Of Poverty Threshold And Level Of Disability (activity Limitation)

Eurostat code: ilc_pw14 · (2023 - 2023)

@eurostat.ilc_pw14

Table List

2 tables(12.72 KB)

Satisfaction With The Job By Risk Of Poverty Threshold And Level Of Disability (activity Limitation) - Raw

Satisfaction With The Job By Risk Of Poverty Threshold And Level Of Disability (activity Limitation) - Unpivoted

Satisfaction With The Job By Risk Of Poverty Threshold And Level Of Disability (activity Limitation) - Unpivoted

@eurostat.ilc_pw14.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.69 KB
451 rows
8 columns

freq Freq	statinfo Statinfo	lev_limit Lev Limit	rskpovth Rskpovth	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Average	None	Above 60%	Rating (0-10)	Austria	2023	7.8
Annual	Average	None	Above 60%	Rating (0-10)	Belgium	2023	7.8
Annual	Average	None	Above 60%	Rating (0-10)	Bulgaria	2023	6.3
Annual	Average	None	Above 60%	Rating (0-10)	Switzerland	2023	7.9
Annual	Average	None	Above 60%	Rating (0-10)	Cyprus	2023	8
Annual	Average	None	Above 60%	Rating (0-10)	Czechia	2023	7.8
Annual	Average	None	Above 60%	Rating (0-10)	Germany	2023	7.4
Annual	Average	None	Above 60%	Rating (0-10)	Denmark	2023	7.9
Annual	Average	None	Above 60%	Rating (0-10)	Euro area – 20 countries (from 2023)	2023	7.4
Annual	Average	None	Above 60%	Rating (0-10)	Estonia	2023	7.8


CREATE TABLE tidy (
  "freq" VARCHAR,
  "statinfo" VARCHAR,
  "lev_limit" VARCHAR,
  "rskpovth" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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