Baselight

Persons Reading Books In The Last 12 Months By Sex, Age, Risk Of Poverty Or Social Exclusion Situation And Number Of Books

Eurostat code: ilc_scp31 · (2022 - 2022)

@eurostat.ilc_scp31

Persons Reading Books In The Last 12 Months By Sex, Age, Risk Of Poverty Or Social Exclusion Situation And Number Of Books - Unpivoted
@eurostat.ilc_scp31.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.

  • 36.35 KB
  • 20144 rows
  • 9 columns
freq

Freq

n_book

N Book

yn_arope

Yn Arope

sex

Sex

age

Age

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualNo booksNot at risk of poverty or social exclusionFemalesFrom 16 to 24 yearsPercentageAustria202220.1
AnnualNo booksNot at risk of poverty or social exclusionFemalesFrom 16 to 24 yearsPercentageBelgium202224.4
AnnualNo booksNot at risk of poverty or social exclusionFemalesFrom 16 to 24 yearsPercentageBulgaria202225.9
AnnualNo booksNot at risk of poverty or social exclusionFemalesFrom 16 to 24 yearsPercentageSwitzerland202216.5
AnnualNo booksNot at risk of poverty or social exclusionFemalesFrom 16 to 24 yearsPercentageCyprus202268.8
AnnualNo booksNot at risk of poverty or social exclusionFemalesFrom 16 to 24 yearsPercentageCzechia202212.7
AnnualNo booksNot at risk of poverty or social exclusionFemalesFrom 16 to 24 yearsPercentageDenmark202221.2
AnnualNo booksNot at risk of poverty or social exclusionFemalesFrom 16 to 24 yearsPercentageEuro area – 20 countries (from 2023)202228.2
AnnualNo booksNot at risk of poverty or social exclusionFemalesFrom 16 to 24 yearsPercentageEstonia20227.2
AnnualNo booksNot at risk of poverty or social exclusionFemalesFrom 16 to 24 yearsPercentageGreece202225.7

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