Turnover In Services - Annual Data

Eurostat code: sts_setu_a$dv_666

@eurostat.sts_setu_a_dv_666

Table List

2 tables(59.11 KB)

Turnover In Services - Annual Data - Raw

Turnover In Services - Annual Data - Unpivoted

Turnover In Services - Annual Data - Unpivoted

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

24.71 KB
6268 rows
8 columns

freq Freq	indic_bt Indic Bt	nace_r2 Nace R2	s_adj S Adj	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2015=100	Austria	2015	100
Annual	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2015=100	Belgium	2015	100
Annual	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2015=100	Bulgaria	2015	100
Annual	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2015=100	Cyprus	2015	100
Annual	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2015=100	Czechia	2015	100
Annual	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2015=100	Germany	2015	100
Annual	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2015=100	Denmark	2015	100
Annual	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2015=100	Euro area - 19 countries (2015-2022)	2015	100
Annual	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2015=100	Estonia	2015	100
Annual	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2015=100	Greece	2015	100


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_bt" VARCHAR,
  "nace_r2" VARCHAR,
  "s_adj" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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