Persons Not Reading Books In The Last 12 Months By Risk Of Poverty Threshold, Household Composition, Degree Of Urbanization And Reasons

Eurostat code: ilc_scp30$dv_2382

@eurostat.ilc_scp30_dv_2382

Table List

2 tables(22.07 KB)

Persons Not Reading Books In The Last 12 Months By Risk Of Poverty Threshold, Household Composition, Degree Of Urbanization And Reasons - Raw

Persons Not Reading Books In The Last 12 Months By Risk Of Poverty Threshold, Household Composition, Degree Of Urbanization And Reasons - Unpivoted

Persons Not Reading Books In The Last 12 Months By Risk Of Poverty Threshold, Household Composition, Degree Of Urbanization And Reasons - Unpivoted

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

11.21 KB
1800 rows
9 columns

freq Freq	reason Reason	rskpovth Rskpovth	deg_urb Deg Urb	hhcomp Hhcomp	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Difficulty	Above 60%	Cities	Total	Percentage	Austria	2022	0.6
Annual	Difficulty	Above 60%	Cities	Total	Percentage	Belgium	2022	0.5
Annual	Difficulty	Above 60%	Cities	Total	Percentage	Bulgaria	2022	0.9
Annual	Difficulty	Above 60%	Cities	Total	Percentage	Cyprus	2022	0.4
Annual	Difficulty	Above 60%	Cities	Total	Percentage	Czechia	2022	0.6
Annual	Difficulty	Above 60%	Cities	Total	Percentage	Denmark	2022	0.5
Annual	Difficulty	Above 60%	Cities	Total	Percentage	Euro area – 20 countries (from 2023)	2022	0.4
Annual	Difficulty	Above 60%	Cities	Total	Percentage	Estonia	2022	0.3
Annual	Difficulty	Above 60%	Cities	Total	Percentage	Greece	2022	0.1
Annual	Difficulty	Above 60%	Cities	Total	Percentage	Spain	2022	0.4


CREATE TABLE tidy (
  "freq" VARCHAR,
  "reason" VARCHAR,
  "rskpovth" VARCHAR,
  "deg_urb" VARCHAR,
  "hhcomp" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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