Baselight

Financial Account - Quarterly Data

Eurostat code: ei_bpm6fa_q ยท (1991-Q1 - 2024-Q4)

@eurostat.ei_bpm6fa_q

Financial Account - Quarterly Data - Unpivoted
@eurostat.ei_bpm6fa_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.

  • 299.85 KB
  • 51138 rows
  • 11 columns
freq

Freq

currency

Currency

bop_item

Bop Item

sector10

Sector10

sectpart

Sectpart

stk_flow

Stk Flow

partner

Partner

s_adj

S Adj

geo

Geo

time_period

Time Period

value

Value

QuarterlyMillion euroNet errors and omissionsTotal economyTotal economyNetRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-Q11821
QuarterlyMillion euroFinancial accountTotal economyTotal economyAssetsRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-Q116279
QuarterlyMillion euroFinancial accountTotal economyTotal economyLiabilitiesRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-Q121435
QuarterlyMillion euroFinancial accountTotal economyTotal economyNetRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-Q1-5156
QuarterlyMillion euroFinancial account; direct investmentTotal economyTotal economyAssetsRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-Q13755
QuarterlyMillion euroFinancial account; direct investmentTotal economyTotal economyLiabilitiesRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-Q1720
QuarterlyMillion euroFinancial account; direct investmentTotal economyTotal economyNetRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-Q13035
QuarterlyMillion euroFinancial account; financial derivatives and employee stock optionsTotal economyTotal economyNetRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-Q165
QuarterlyMillion euroFinancial account; other investmentTotal economyTotal economyAssetsRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-Q113334
QuarterlyMillion euroFinancial account; other investmentTotal economyTotal economyLiabilitiesRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-Q118652

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.