Name: Financial Services - Monthly Data
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Financial Services - Monthly Data

This Eurostat dataset contains data on financial services - 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: 2024-06-27T11:00:00+0200

Tables

Financial Services - Monthly Data - Raw

@eurostat.ei_bsfs_m.raw

192.06 kB
48 rows
209 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "s_adj" VARCHAR,
  "nace_r2" VARCHAR,
  "indic" VARCHAR,
  "geo" VARCHAR,
  "n_2006_04" DOUBLE  -- 2006-04,
  "n_2006_05" DOUBLE  -- 2006-05,
  "n_2006_06" DOUBLE  -- 2006-06,
  "n_2006_07" DOUBLE  -- 2006-07,
  "n_2006_08" DOUBLE  -- 2006-08,
  "n_2006_09" DOUBLE  -- 2006-09,
  "n_2006_10" DOUBLE  -- 2006-10,
  "n_2006_11" DOUBLE  -- 2006-11,
  "n_2006_12" DOUBLE  -- 2006-12,
  "n_2007_01" DOUBLE  -- 2007-01,
  "n_2007_02" DOUBLE  -- 2007-02,
  "n_2007_03" DOUBLE  -- 2007-03,
  "n_2007_04" DOUBLE  -- 2007-04,
  "n_2007_05" DOUBLE  -- 2007-05,
  "n_2007_06" DOUBLE  -- 2007-06,
  "n_2007_07" DOUBLE  -- 2007-07,
  "n_2007_08" DOUBLE  -- 2007-08,
  "n_2007_09" DOUBLE  -- 2007-09,
  "n_2007_10" DOUBLE  -- 2007-10,
  "n_2007_11" DOUBLE  -- 2007-11,
  "n_2007_12" DOUBLE  -- 2007-12,
  "n_2008_01" DOUBLE  -- 2008-01,
  "n_2008_02" DOUBLE  -- 2008-02,
  "n_2008_03" DOUBLE  -- 2008-03,
  "n_2008_04" DOUBLE  -- 2008-04,
  "n_2008_05" DOUBLE  -- 2008-05,
  "n_2008_06" DOUBLE  -- 2008-06,
  "n_2008_07" DOUBLE  -- 2008-07,
  "n_2008_08" DOUBLE  -- 2008-08,
  "n_2008_09" DOUBLE  -- 2008-09,
  "n_2008_10" DOUBLE  -- 2008-10,
  "n_2008_11" DOUBLE  -- 2008-11,
  "n_2008_12" DOUBLE  -- 2008-12,
  "n_2009_01" DOUBLE  -- 2009-01,
  "n_2009_02" DOUBLE  -- 2009-02,
  "n_2009_03" DOUBLE  -- 2009-03,
  "n_2009_04" DOUBLE  -- 2009-04,
  "n_2009_05" DOUBLE  -- 2009-05,
  "n_2009_06" DOUBLE  -- 2009-06,
  "n_2009_07" DOUBLE  -- 2009-07,
  "n_2009_08" DOUBLE  -- 2009-08,
  "n_2009_09" DOUBLE  -- 2009-09,
  "n_2009_10" DOUBLE  -- 2009-10,
  "n_2009_11" DOUBLE  -- 2009-11,
  "n_2009_12" DOUBLE  -- 2009-12,
  "n_2010_01" DOUBLE  -- 2010-01,
  "n_2010_02" DOUBLE  -- 2010-02,
  "n_2010_03" DOUBLE  -- 2010-03,
  "n_2010_04" DOUBLE  -- 2010-04,
  "n_2010_05" DOUBLE  -- 2010-05,
  "n_2010_06" DOUBLE  -- 2010-06,
  "n_2010_07" DOUBLE  -- 2010-07,
  "n_2010_08" DOUBLE  -- 2010-08,
  "n_2010_09" DOUBLE  -- 2010-09,
  "n_2010_10" DOUBLE  -- 2010-10,
  "n_2010_11" DOUBLE  -- 2010-11,
  "n_2010_12" DOUBLE  -- 2010-12,
  "n_2011_01" DOUBLE  -- 2011-01,
  "n_2011_02" DOUBLE  -- 2011-02,
  "n_2011_03" DOUBLE  -- 2011-03,
  "n_2011_04" DOUBLE  -- 2011-04,
  "n_2011_05" DOUBLE  -- 2011-05,
  "n_2011_06" DOUBLE  -- 2011-06,
  "n_2011_07" DOUBLE  -- 2011-07,
  "n_2011_08" DOUBLE  -- 2011-08,
  "n_2011_09" DOUBLE  -- 2011-09,
  "n_2011_10" DOUBLE  -- 2011-10,
  "n_2011_11" DOUBLE  -- 2011-11,
  "n_2011_12" DOUBLE  -- 2011-12,
  "n_2012_01" DOUBLE  -- 2012-01,
  "n_2012_02" DOUBLE  -- 2012-02,
  "n_2012_03" DOUBLE  -- 2012-03,
  "n_2012_04" DOUBLE  -- 2012-04,
  "n_2012_05" DOUBLE  -- 2012-05,
  "n_2012_06" DOUBLE  -- 2012-06,
  "n_2012_07" DOUBLE  -- 2012-07,
  "n_2012_08" DOUBLE  -- 2012-08,
  "n_2012_09" DOUBLE  -- 2012-09,
  "n_2012_10" DOUBLE  -- 2012-10,
  "n_2012_11" DOUBLE  -- 2012-11,
  "n_2012_12" DOUBLE  -- 2012-12,
  "n_2013_01" DOUBLE  -- 2013-01,
  "n_2013_02" DOUBLE  -- 2013-02,
  "n_2013_03" DOUBLE  -- 2013-03,
  "n_2013_04" DOUBLE  -- 2013-04,
  "n_2013_05" DOUBLE  -- 2013-05,
  "n_2013_06" DOUBLE  -- 2013-06,
  "n_2013_07" DOUBLE  -- 2013-07,
  "n_2013_08" DOUBLE  -- 2013-08,
  "n_2013_09" DOUBLE  -- 2013-09,
  "n_2013_10" DOUBLE  -- 2013-10,
  "n_2013_11" DOUBLE  -- 2013-11,
  "n_2013_12" DOUBLE  -- 2013-12,
  "n_2014_01" DOUBLE  -- 2014-01,
  "n_2014_02" DOUBLE  -- 2014-02
);

Financial Services - Monthly Data - Unpivoted

@eurostat.ei_bsfs_m.tidy

24.27 kB
9,792 rows
7 columns

CREATE TABLE tidy (
  "freq" VARCHAR,
  "s_adj" VARCHAR,
  "nace_r2" VARCHAR,
  "indic" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);