Persons Attending Live Sport Events In The Last 12 Months By Sex And Age

Eurostat code: sprt_pcs_sea · (2007 - 2011)

@eurostat.sprt_pcs_sea

Table List

2 tables(34.07 KB)

Persons Attending Live Sport Events In The Last 12 Months By Sex And Age - Raw

Persons Attending Live Sport Events In The Last 12 Months By Sex And Age - Unpivoted

Persons Attending Live Sport Events In The Last 12 Months By Sex And Age - Unpivoted

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

15.49 KB
4059 rows
8 columns

freq Freq	age Age	frequenc Frequenc	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	From 25 to 34 years	From 1 to 6 times	Females	Percentage	Austria	2007	31.3
Annual	From 25 to 34 years	From 1 to 6 times	Females	Percentage	Belgium	2007	29
Annual	From 25 to 34 years	From 1 to 6 times	Females	Percentage	Bulgaria	2007	14.8
Annual	From 25 to 34 years	From 1 to 6 times	Females	Percentage	Cyprus	2007	18.8
Annual	From 25 to 34 years	From 1 to 6 times	Females	Percentage	Czechia	2007	29.1
Annual	From 25 to 34 years	From 1 to 6 times	Females	Percentage	Estonia	2007	33.4
Annual	From 25 to 34 years	From 1 to 6 times	Females	Percentage	Greece	2007	9.9
Annual	From 25 to 34 years	From 1 to 6 times	Females	Percentage	Spain	2007	23.5
Annual	From 25 to 34 years	From 1 to 6 times	Females	Percentage	Finland	2007	35.7
Annual	From 25 to 34 years	From 1 to 6 times	Females	Percentage	Croatia	2007	24.8


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