Intra And Extra-EU Trade In Sporting Goods By Product

Eurostat code: sprt_trd_prd · (2004 - 2023)

@eurostat.sprt_trd_prd

Table List

2 tables(1.09 MB)

Intra And Extra-EU Trade In Sporting Goods By Product - Raw

Intra And Extra-EU Trade In Sporting Goods By Product - Unpivoted

Intra And Extra-EU Trade In Sporting Goods By Product - Unpivoted

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

505.08 KB
152174 rows
8 columns

freq Freq	prod_sp Prod Sp	partner Partner	stk_flow Stk Flow	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Extra-EU27 (from 2020)	Exports	Percentage	Austria	2004	0.08
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Extra-EU27 (from 2020)	Exports	Percentage	Belgium	2004	0.18
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Extra-EU27 (from 2020)	Exports	Percentage	Bulgaria	2004	0.62
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Extra-EU27 (from 2020)	Exports	Percentage	Switzerland	2004	0.3
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Extra-EU27 (from 2020)	Exports	Percentage	Czechia	2004	1.16
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Extra-EU27 (from 2020)	Exports	Percentage	Germany	2004	2.87
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Extra-EU27 (from 2020)	Exports	Percentage	Denmark	2004	3.86
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Extra-EU27 (from 2020)	Exports	Percentage	Estonia	2004	1.07
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Extra-EU27 (from 2020)	Exports	Percentage	Greece	2004	1.44
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Extra-EU27 (from 2020)	Exports	Percentage	Spain	2004	1.71


CREATE TABLE tidy (
  "freq" VARCHAR,
  "prod_sp" VARCHAR,
  "partner" VARCHAR,
  "stk_flow" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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