Baselight

Persons Reading Books In The Last 12 Months By Sex, Age, Educational Attainment And Number Of Books

Eurostat code: ilc_scp27 · (2022 - 2022)

@eurostat.ilc_scp27

Persons Reading Books In The Last 12 Months By Sex, Age, Educational Attainment And Number Of Books - Unpivoted
@eurostat.ilc_scp27.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.

  • 45.49 KB
  • 26708 rows
  • 9 columns
freq

Freq

n_book

N Book

isced11

Isced11

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualNo booksLess than primary, primary and lower secondary education (levels 0-2)FemalesFrom 16 to 24 yearsPercentageAustria202223.5
AnnualNo booksLess than primary, primary and lower secondary education (levels 0-2)FemalesFrom 16 to 24 yearsPercentageBelgium202228.1
AnnualNo booksLess than primary, primary and lower secondary education (levels 0-2)FemalesFrom 16 to 24 yearsPercentageBulgaria202261.9
AnnualNo booksLess than primary, primary and lower secondary education (levels 0-2)FemalesFrom 16 to 24 yearsPercentageSwitzerland202210.6
AnnualNo booksLess than primary, primary and lower secondary education (levels 0-2)FemalesFrom 16 to 24 yearsPercentageCyprus202275.7
AnnualNo booksLess than primary, primary and lower secondary education (levels 0-2)FemalesFrom 16 to 24 yearsPercentageCzechia202212.7
AnnualNo booksLess than primary, primary and lower secondary education (levels 0-2)FemalesFrom 16 to 24 yearsPercentageDenmark202220.2
AnnualNo booksLess than primary, primary and lower secondary education (levels 0-2)FemalesFrom 16 to 24 yearsPercentageEuro area – 20 countries (from 2023)202233.6
AnnualNo booksLess than primary, primary and lower secondary education (levels 0-2)FemalesFrom 16 to 24 yearsPercentageEstonia202214.2
AnnualNo booksLess than primary, primary and lower secondary education (levels 0-2)FemalesFrom 16 to 24 yearsPercentageGreece202234.1

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

Share link

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