Baselight
Sign In

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

Eurostat code: ilc_scp28 · (2022 - 2022)

@eurostat.ilc_scp28

Persons Reading Books In The Last 12 Months By Risk Of Poverty Threshold, Household Composition, Degree Of Urbanization And Number Of Books - Unpivoted
@eurostat.ilc_scp28.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.

  • 29.94 KB
  • 14260 rows
  • 9 columns
freq

Freq

n_book

N Book

rskpovth

Rskpovth

deg_urb

Deg Urb

hhcomp

Hhcomp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualNo booksAbove 60%CitiesOne adultPercentageAustria202221.9
AnnualNo booksAbove 60%CitiesOne adultPercentageBelgium202232.7
AnnualNo booksAbove 60%CitiesOne adultPercentageBulgaria202237.5
AnnualNo booksAbove 60%CitiesOne adultPercentageSwitzerland202214.4
AnnualNo booksAbove 60%CitiesOne adultPercentageCyprus202250.3
AnnualNo booksAbove 60%CitiesOne adultPercentageCzechia202226.7
AnnualNo booksAbove 60%CitiesOne adultPercentageDenmark202225.5
AnnualNo booksAbove 60%CitiesOne adultPercentageEuro area – 20 countries (from 2023)202235.8
AnnualNo booksAbove 60%CitiesOne adultPercentageEstonia202222.1
AnnualNo booksAbove 60%CitiesOne adultPercentageGreece202246.3

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