Services - Quarterly Data

Eurostat code: ei_bsse_q_r2 · (2001-Q2 - 2025-Q1)

@eurostat.ei_bsse_q_r2

Table List

2 tables(224.38 KB)

Services - Quarterly Data - Unpivoted

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

55.36 KB
33596 rows
7 columns

freq Freq	indic Indic	s_adj S Adj	unit Unit	geo Geo	time_period Time Period	value Value
Quarterly	Main factors limiting the business - none	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Portugal	2001-Q2	81.8
Quarterly	Main factors limiting the business - none	Seasonally adjusted data, not calendar adjusted data	Balance	Portugal	2001-Q2	81.8
Quarterly	Main factors limiting the business - insufficient demand	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Portugal	2001-Q2	5.6
Quarterly	Main factors limiting the business - insufficient demand	Seasonally adjusted data, not calendar adjusted data	Balance	Portugal	2001-Q2	5.6
Quarterly	Main factors limiting the business - labour	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Portugal	2001-Q2	16.4
Quarterly	Main factors limiting the business - labour	Seasonally adjusted data, not calendar adjusted data	Balance	Portugal	2001-Q2	16.4
Quarterly	Main factors limiting the business - equipment and/or space	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Portugal	2001-Q2
Quarterly	Main factors limiting the business - equipment and/or space	Seasonally adjusted data, not calendar adjusted data	Balance	Portugal	2001-Q2
Quarterly	Main factors limiting the business - financial constraints	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Portugal	2001-Q2	5.1
Quarterly	Main factors limiting the business - financial constraints	Seasonally adjusted data, not calendar adjusted data	Balance	Portugal	2001-Q2	5.1


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