Consumers - Monthly Data

Eurostat code: ei_bsco_m · (1980-01 - 2025-03)

@eurostat.ei_bsco_m

Table List

2 tables(1.85 MB)

Consumers - Monthly Data - Unpivoted

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

443.65 KB
290070 rows
7 columns

freq Freq	indic Indic	s_adj S Adj	unit Unit	geo Geo	time_period Time Period	value Value
Monthly	Financial situation over the last 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Italy	1980-01	-16.5
Monthly	Financial situation over the last 12 months	Seasonally adjusted data, not calendar adjusted data	Balance	Italy	1980-01	-17.2
Monthly	Financial situation over the next 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Italy	1980-01	-11
Monthly	Financial situation over the next 12 months	Seasonally adjusted data, not calendar adjusted data	Balance	Italy	1980-01	-11.4
Monthly	General economic situation over the last 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Italy	1980-01	-59
Monthly	General economic situation over the last 12 months	Seasonally adjusted data, not calendar adjusted data	Balance	Italy	1980-01	-59.8
Monthly	General economic situation over the next 12 months	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Italy	1980-01	-32
Monthly	General economic situation over the next 12 months	Seasonally adjusted data, not calendar adjusted data	Balance	Italy	1980-01	-33
Monthly	The current economic situation is adequate to make major purchases	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Balance	Italy	1980-01	-2
Monthly	The current economic situation is adequate to make major purchases	Seasonally adjusted data, not calendar adjusted data	Balance	Italy	1980-01	-1.2


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.