Turnover In Services - Quarterly Data

Eurostat code: sts_setu_q$dv_668

@eurostat.sts_setu_q_dv_668

Table List

2 tables(65.3 KB)

Turnover In Services - Quarterly Data - Raw

Turnover In Services - Quarterly Data - Unpivoted

Turnover In Services - Quarterly Data - Unpivoted

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

26.02 KB
5956 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
Quarterly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Austria	2022-Q3	201.3
Quarterly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Belgium	2022-Q3	178.5
Quarterly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Bulgaria	2022-Q3	410.7
Quarterly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Cyprus	2022-Q3	774.1
Quarterly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Czechia	2022-Q3	348.1
Quarterly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Germany	2022-Q3	206.2
Quarterly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Denmark	2022-Q3	197.3
Quarterly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Euro area - 19 countries (2015-2022)	2022-Q3	220.8
Quarterly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Estonia	2022-Q3	254.9
Quarterly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Greece	2022-Q3	303.6


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.