Turnover In Services - Monthly Data

Eurostat code: sts_setu_m$dv_667

@eurostat.sts_setu_m_dv_667

Table List

2 tables(38.95 KB)

Turnover In Services - Monthly Data - Raw

Turnover In Services - Monthly Data - Unpivoted

Turnover In Services - Monthly Data - Unpivoted

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

15.58 KB
2223 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
Monthly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Czechia	2024-05	210.4
Monthly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Germany	2024-05	144.6
Monthly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Denmark	2024-05	226
Monthly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Euro area - 19 countries (2015-2022)	2024-05	232.3
Monthly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Spain	2024-05	278.2
Monthly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	European Union - 27 countries (from 2020)	2024-05	206.2
Monthly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	France	2024-05	164
Monthly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Luxembourg	2024-05	84.7
Monthly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Latvia	2024-05	374.9
Monthly	Net turnover	Air transport	Calendar adjusted data, not seasonally adjusted data	Index, 2021=100	Portugal	2024-05	275.1


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.