Baselight

Financial Account - Monthly Data

Eurostat code: ei_bpm6fa_m · (1991-01 - 2025-04)

@eurostat.ei_bpm6fa_m

Loading...
Loading...

About this Dataset

Financial Account - Monthly Data

This Eurostat dataset contains data on financial account - 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-07-04T23:00:00+0200

Tables

Financial Account - Monthly Data - Raw

@eurostat.ei_bpm6fa_m.raw
  • 783.91 KB
  • 390 rows
  • 421 columns
Loading...

CREATE TABLE raw (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "bop_item" VARCHAR,
  "sector10" VARCHAR,
  "sectpart" VARCHAR,
  "stk_flow" VARCHAR,
  "partner" VARCHAR,
  "s_adj" VARCHAR,
  "geo" VARCHAR,
  "n_1991_01" DOUBLE,
  "n_1991_02" DOUBLE,
  "n_1991_03" DOUBLE,
  "n_1991_04" DOUBLE,
  "n_1991_05" DOUBLE,
  "n_1991_06" DOUBLE,
  "n_1991_07" DOUBLE,
  "n_1991_08" DOUBLE,
  "n_1991_09" DOUBLE,
  "n_1991_10" DOUBLE,
  "n_1991_11" DOUBLE,
  "n_1991_12" DOUBLE,
  "n_1992_01" DOUBLE,
  "n_1992_02" DOUBLE,
  "n_1992_03" DOUBLE,
  "n_1992_04" DOUBLE,
  "n_1992_05" DOUBLE,
  "n_1992_06" DOUBLE,
  "n_1992_07" DOUBLE,
  "n_1992_08" DOUBLE,
  "n_1992_09" DOUBLE,
  "n_1992_10" DOUBLE,
  "n_1992_11" DOUBLE,
  "n_1992_12" DOUBLE,
  "n_1993_01" DOUBLE,
  "n_1993_02" DOUBLE,
  "n_1993_03" DOUBLE,
  "n_1993_04" DOUBLE,
  "n_1993_05" DOUBLE,
  "n_1993_06" DOUBLE,
  "n_1993_07" DOUBLE,
  "n_1993_08" DOUBLE,
  "n_1993_09" DOUBLE,
  "n_1993_10" DOUBLE,
  "n_1993_11" DOUBLE,
  "n_1993_12" DOUBLE,
  "n_1994_01" DOUBLE,
  "n_1994_02" DOUBLE,
  "n_1994_03" DOUBLE,
  "n_1994_04" DOUBLE,
  "n_1994_05" DOUBLE,
  "n_1994_06" DOUBLE,
  "n_1994_07" DOUBLE,
  "n_1994_08" DOUBLE,
  "n_1994_09" DOUBLE,
  "n_1994_10" DOUBLE,
  "n_1994_11" DOUBLE,
  "n_1994_12" DOUBLE,
  "n_1995_01" DOUBLE,
  "n_1995_02" DOUBLE,
  "n_1995_03" DOUBLE,
  "n_1995_04" DOUBLE,
  "n_1995_05" DOUBLE,
  "n_1995_06" DOUBLE,
  "n_1995_07" DOUBLE,
  "n_1995_08" DOUBLE,
  "n_1995_09" DOUBLE,
  "n_1995_10" DOUBLE,
  "n_1995_11" DOUBLE,
  "n_1995_12" DOUBLE,
  "n_1996_01" DOUBLE,
  "n_1996_02" DOUBLE,
  "n_1996_03" DOUBLE,
  "n_1996_04" DOUBLE,
  "n_1996_05" DOUBLE,
  "n_1996_06" DOUBLE,
  "n_1996_07" DOUBLE,
  "n_1996_08" DOUBLE,
  "n_1996_09" DOUBLE,
  "n_1996_10" DOUBLE,
  "n_1996_11" DOUBLE,
  "n_1996_12" DOUBLE,
  "n_1997_01" DOUBLE,
  "n_1997_02" DOUBLE,
  "n_1997_03" DOUBLE,
  "n_1997_04" DOUBLE,
  "n_1997_05" DOUBLE,
  "n_1997_06" DOUBLE,
  "n_1997_07" DOUBLE,
  "n_1997_08" DOUBLE,
  "n_1997_09" DOUBLE,
  "n_1997_10" DOUBLE,
  "n_1997_11" DOUBLE,
  "n_1997_12" DOUBLE,
  "n_1998_01" DOUBLE,
  "n_1998_02" DOUBLE,
  "n_1998_03" DOUBLE,
  "n_1998_04" DOUBLE,
  "n_1998_05" DOUBLE,
  "n_1998_06" DOUBLE,
  "n_1998_07" DOUBLE
);

Financial Account - Monthly Data - Unpivoted

@eurostat.ei_bpm6fa_m.tidy
  • 380.92 KB
  • 79123 rows
  • 11 columns
Loading...

CREATE TABLE tidy (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "bop_item" VARCHAR,
  "sector10" VARCHAR,
  "sectpart" VARCHAR,
  "stk_flow" VARCHAR,
  "partner" VARCHAR,
  "s_adj" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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