Baselight

Current Account - Monthly Data

Eurostat code: ei_bpm6ca_m ยท (1991-01 - 2025-02)

@eurostat.ei_bpm6ca_m

Current Account - Monthly Data - Unpivoted
@eurostat.ei_bpm6ca_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.

  • 1.03 MB
  • 238300 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

MonthlyMillion euroCurrent accountTotal economyTotal economyBalanceRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-01-1215
MonthlyMillion euroCurrent accountTotal economyTotal economyCreditRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-0138799
MonthlyMillion euroCurrent accountTotal economyTotal economyDebitRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-0140015
MonthlyMillion euroCurrent plus capital account (balance = net lending (+) / net borrowing (-))Total economyTotal economyBalanceRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-01-1611
MonthlyMillion euroCurrent plus capital account (balance = net lending (+) / net borrowing (-))Total economyTotal economyCreditRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-0138858
MonthlyMillion euroCurrent plus capital account (balance = net lending (+) / net borrowing (-))Total economyTotal economyDebitRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-0140470
MonthlyMillion euroPrimary income: compensation of employeesTotal economyTotal economyBalanceRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-0191
MonthlyMillion euroPrimary income: compensation of employeesTotal economyTotal economyCreditRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-01260
MonthlyMillion euroPrimary income: compensation of employeesTotal economyTotal economyDebitRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-01169
MonthlyMillion euroPrimary income: other primary incomeTotal economyTotal economyBalanceRest of the worldUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Germany1991-0194

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.