Intermediate Services Trade

Eurostat code: egi_tr4 · (2010 - 2022)

@eurostat.egi_tr4

Table List

2 tables(19.84 KB)

Intermediate Services Trade - Unpivoted

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

6.21 KB
364 rows
6 columns

freq Freq	stk_flow Stk Flow	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	Percentage	Austria	2010	59.2
Annual	Total	Percentage	Belgium	2010	74
Annual	Total	Percentage	Bulgaria	2010	49.3
Annual	Total	Percentage	Cyprus	2010	59.5
Annual	Total	Percentage	Czechia	2010	66.8
Annual	Total	Percentage	Germany	2010	67.9
Annual	Total	Percentage	Denmark	2010	80.3
Annual	Total	Percentage	Estonia	2010	65.4
Annual	Total	Percentage	Greece	2010	67.7
Annual	Total	Percentage	Spain	2010	51.2


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