Consumers - Quarterly Data

Eurostat code: ei_bsco_q · (1990-Q1 - 2025-Q1)

@eurostat.ei_bsco_q

Table List

2 tables(179.86 KB)

Consumers - Quarterly Data - Unpivoted

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

29.69 KB
14282 rows
7 columns

freq Freq	indic Indic	s_adj S Adj	unit Unit	geo Geo	time_period Time Period	value Value
Quarterly	Home improvements over the next 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Belgium	1990-Q1	-54.2
Quarterly	Home improvements over the next 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Germany	1990-Q1	-23
Quarterly	Home improvements over the next 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Denmark	1990-Q1	-86
Quarterly	Home improvements over the next 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Euro area – 20 countries (from 2023)	1990-Q1	-52.2
Quarterly	Home improvements over the next 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Greece	1990-Q1	-70
Quarterly	Home improvements over the next 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Spain	1990-Q1	-68.7
Quarterly	Home improvements over the next 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	European Union - 27 countries (from 2020)	1990-Q1	-52.9
Quarterly	Home improvements over the next 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	France	1990-Q1	-74.5
Quarterly	Home improvements over the next 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Italy	1990-Q1	-60.5
Quarterly	Home improvements over the next 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Netherlands	1990-Q1	-62.8


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.