Baselight

Euro Area Business Climate Indicator - Monthly Data

Eurostat code: ei_bsci_m_r2 ยท (1985-01 - 2025-09)

@eurostat.ei_bsci_m_r2

Loading...
Loading...

About this Dataset

Euro Area Business Climate Indicator - Monthly Data

This Eurostat dataset contains data on euro area business climate indicator - monthly data, as collected and published by the Statistical Office of the European Union.

Tables included:

  • raw: Original table as downloaded from Eurostat.
  • tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-09-29T11:00:00+0200

Tables

Euro Area Business Climate Indicator - Monthly Data - Raw

@eurostat.ei_bsci_m_r2.raw
  • 331.86 kB
  • 1 row
  • 493 columns
Loading...
CREATE TABLE raw (
  "freq" VARCHAR,
  "indic" VARCHAR,
  "s_adj" VARCHAR,
  "geo" VARCHAR,
  "n_1985_01" DOUBLE  -- 1985-01,
  "n_1985_02" DOUBLE  -- 1985-02,
  "n_1985_03" DOUBLE  -- 1985-03,
  "n_1985_04" DOUBLE  -- 1985-04,
  "n_1985_05" DOUBLE  -- 1985-05,
  "n_1985_06" DOUBLE  -- 1985-06,
  "n_1985_07" DOUBLE  -- 1985-07,
  "n_1985_08" DOUBLE  -- 1985-08,
  "n_1985_09" DOUBLE  -- 1985-09,
  "n_1985_10" DOUBLE  -- 1985-10,
  "n_1985_11" DOUBLE  -- 1985-11,
  "n_1985_12" DOUBLE  -- 1985-12,
  "n_1986_01" DOUBLE  -- 1986-01,
  "n_1986_02" DOUBLE  -- 1986-02,
  "n_1986_03" DOUBLE  -- 1986-03,
  "n_1986_04" DOUBLE  -- 1986-04,
  "n_1986_05" DOUBLE  -- 1986-05,
  "n_1986_06" DOUBLE  -- 1986-06,
  "n_1986_07" DOUBLE  -- 1986-07,
  "n_1986_08" DOUBLE  -- 1986-08,
  "n_1986_09" DOUBLE  -- 1986-09,
  "n_1986_10" DOUBLE  -- 1986-10,
  "n_1986_11" DOUBLE  -- 1986-11,
  "n_1986_12" DOUBLE  -- 1986-12,
  "n_1987_01" DOUBLE  -- 1987-01,
  "n_1987_02" DOUBLE  -- 1987-02,
  "n_1987_03" DOUBLE  -- 1987-03,
  "n_1987_04" DOUBLE  -- 1987-04,
  "n_1987_05" DOUBLE  -- 1987-05,
  "n_1987_06" DOUBLE  -- 1987-06,
  "n_1987_07" DOUBLE  -- 1987-07,
  "n_1987_08" DOUBLE  -- 1987-08,
  "n_1987_09" DOUBLE  -- 1987-09,
  "n_1987_10" DOUBLE  -- 1987-10,
  "n_1987_11" DOUBLE  -- 1987-11,
  "n_1987_12" DOUBLE  -- 1987-12,
  "n_1988_01" DOUBLE  -- 1988-01,
  "n_1988_02" DOUBLE  -- 1988-02,
  "n_1988_03" DOUBLE  -- 1988-03,
  "n_1988_04" DOUBLE  -- 1988-04,
  "n_1988_05" DOUBLE  -- 1988-05,
  "n_1988_06" DOUBLE  -- 1988-06,
  "n_1988_07" DOUBLE  -- 1988-07,
  "n_1988_08" DOUBLE  -- 1988-08,
  "n_1988_09" DOUBLE  -- 1988-09,
  "n_1988_10" DOUBLE  -- 1988-10,
  "n_1988_11" DOUBLE  -- 1988-11,
  "n_1988_12" DOUBLE  -- 1988-12,
  "n_1989_01" DOUBLE  -- 1989-01,
  "n_1989_02" DOUBLE  -- 1989-02,
  "n_1989_03" DOUBLE  -- 1989-03,
  "n_1989_04" DOUBLE  -- 1989-04,
  "n_1989_05" DOUBLE  -- 1989-05,
  "n_1989_06" DOUBLE  -- 1989-06,
  "n_1989_07" DOUBLE  -- 1989-07,
  "n_1989_08" DOUBLE  -- 1989-08,
  "n_1989_09" DOUBLE  -- 1989-09,
  "n_1989_10" DOUBLE  -- 1989-10,
  "n_1989_11" DOUBLE  -- 1989-11,
  "n_1989_12" DOUBLE  -- 1989-12,
  "n_1990_01" DOUBLE  -- 1990-01,
  "n_1990_02" DOUBLE  -- 1990-02,
  "n_1990_03" DOUBLE  -- 1990-03,
  "n_1990_04" DOUBLE  -- 1990-04,
  "n_1990_05" DOUBLE  -- 1990-05,
  "n_1990_06" DOUBLE  -- 1990-06,
  "n_1990_07" DOUBLE  -- 1990-07,
  "n_1990_08" DOUBLE  -- 1990-08,
  "n_1990_09" DOUBLE  -- 1990-09,
  "n_1990_10" DOUBLE  -- 1990-10,
  "n_1990_11" DOUBLE  -- 1990-11,
  "n_1990_12" DOUBLE  -- 1990-12,
  "n_1991_01" DOUBLE  -- 1991-01,
  "n_1991_02" DOUBLE  -- 1991-02,
  "n_1991_03" DOUBLE  -- 1991-03,
  "n_1991_04" DOUBLE  -- 1991-04,
  "n_1991_05" DOUBLE  -- 1991-05,
  "n_1991_06" DOUBLE  -- 1991-06,
  "n_1991_07" DOUBLE  -- 1991-07,
  "n_1991_08" DOUBLE  -- 1991-08,
  "n_1991_09" DOUBLE  -- 1991-09,
  "n_1991_10" DOUBLE  -- 1991-10,
  "n_1991_11" DOUBLE  -- 1991-11,
  "n_1991_12" DOUBLE  -- 1991-12,
  "n_1992_01" DOUBLE  -- 1992-01,
  "n_1992_02" DOUBLE  -- 1992-02,
  "n_1992_03" DOUBLE  -- 1992-03,
  "n_1992_04" DOUBLE  -- 1992-04,
  "n_1992_05" DOUBLE  -- 1992-05,
  "n_1992_06" DOUBLE  -- 1992-06,
  "n_1992_07" DOUBLE  -- 1992-07,
  "n_1992_08" DOUBLE  -- 1992-08,
  "n_1992_09" DOUBLE  -- 1992-09,
  "n_1992_10" DOUBLE  -- 1992-10,
  "n_1992_11" DOUBLE  -- 1992-11,
  "n_1992_12" DOUBLE  -- 1992-12
);

Euro Area Business Climate Indicator - Monthly Data - Unpivoted

@eurostat.ei_bsci_m_r2.tidy
  • 9.32 kB
  • 489 rows
  • 6 columns
Loading...
CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic" VARCHAR,
  "s_adj" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.