Baselight
Sign In

Persons Attending Live Sport Events In The Last 12 Months By Sex And Educational Attainment Level

Eurostat code: sprt_pcs_see ยท (2007 - 2011)

@eurostat.sprt_pcs_see

Persons Attending Live Sport Events In The Last 12 Months By Sex And Educational Attainment Level - Unpivoted
@eurostat.sprt_pcs_see.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.

  • 12.48 KB
  • 2002 rows
  • 8 columns
freq

Freq

isced97

Isced97

frequenc

Frequenc

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualPre-primary, primary and lower secondary education (levels 0-2)From 1 to 6 timesFemalesPercentageAustria200718.3
AnnualPre-primary, primary and lower secondary education (levels 0-2)From 1 to 6 timesFemalesPercentageBelgium200716.6
AnnualPre-primary, primary and lower secondary education (levels 0-2)From 1 to 6 timesFemalesPercentageCyprus20075.8
AnnualPre-primary, primary and lower secondary education (levels 0-2)From 1 to 6 timesFemalesPercentageCzechia200710.4
AnnualPre-primary, primary and lower secondary education (levels 0-2)From 1 to 6 timesFemalesPercentageEstonia200715.3
AnnualPre-primary, primary and lower secondary education (levels 0-2)From 1 to 6 timesFemalesPercentageGreece20073
AnnualPre-primary, primary and lower secondary education (levels 0-2)From 1 to 6 timesFemalesPercentageSpain200712.9
AnnualPre-primary, primary and lower secondary education (levels 0-2)From 1 to 6 timesFemalesPercentageFinland200720.8
AnnualPre-primary, primary and lower secondary education (levels 0-2)From 1 to 6 timesFemalesPercentageCroatia20079
AnnualPre-primary, primary and lower secondary education (levels 0-2)From 1 to 6 timesFemalesPercentageHungary200711.1

CREATE TABLE tidy (
  "freq" VARCHAR,
  "isced97" VARCHAR,
  "frequenc" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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