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

Eurostat code: sprt_trd_prt · (2004 - 2023)

@eurostat.sprt_trd_prt

Table List

2 tables(4.72 MB)

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

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

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

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

2.43 MB
803327 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)	Andorra	Exports	Thousand euro	Germany	2004	0.55
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Andorra	Exports	Thousand euro	Spain	2004	56
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Andorra	Exports	Thousand euro	European Union - 27 countries (from 2020)	2004	90
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Andorra	Exports	Thousand euro	France	2004	26
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Andorra	Exports	Thousand euro	Italy	2004	7.08
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Andorra	Exports	Thousand euro	Netherlands	2004	0.06
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	Andorra	Exports	Thousand euro	Portugal	2004	0.03
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	United Arab Emirates	Exports	Thousand euro	Austria	2004	0.23
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	United Arab Emirates	Exports	Thousand euro	Belgium	2004	4.82
Annual	Tennis balls, inflatable balls, other balls (excl. golf balls, and table-tennis balls)	United Arab Emirates	Exports	Thousand euro	Switzerland	2004


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.