Baselight

Current Account - Quarterly Data

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

@eurostat.ei_bpm6ca_q

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

  • 1.16 MB
  • 288663 rows
  • 11 columns
freq

Freq

unit

Unit

s_adj

S Adj

sector10

Sector10

sectpart

Sectpart

partner

Partner

stk_flow

Stk Flow

bop_item

Bop Item

geo

Geo

time_period

Time Period

value

Value

QuarterlyMillion euroUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Total economyTotal economyRest of the worldBalanceCurrent accountGermany1991-Q1-6260
QuarterlyMillion euroUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Total economyTotal economyRest of the worldBalanceCurrent plus capital account (balance = net lending (+) / net borrowing (-))Germany1991-Q1-6977
QuarterlyMillion euroUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Total economyTotal economyRest of the worldBalancePrimary income: compensation of employeesGermany1991-Q1273
QuarterlyMillion euroUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Total economyTotal economyRest of the worldBalancePrimary income: other primary incomeGermany1991-Q1184
QuarterlyMillion euroUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Total economyTotal economyRest of the worldBalancePrimary income: investment income; direct investmentGermany1991-Q1-17
QuarterlyMillion euroUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Total economyTotal economyRest of the worldBalancePrimary income: investment incomeGermany1991-Q14164
QuarterlyMillion euroUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Total economyTotal economyRest of the worldBalancePrimary income: investment income; other investmentGermany1991-Q13139
QuarterlyMillion euroUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Total economyTotal economyRest of the worldBalancePrimary income: investment income; portfolio investmentGermany1991-Q11041
QuarterlyMillion euroUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Total economyTotal economyRest of the worldBalanceGoodsGermany1991-Q15229
QuarterlyMillion euroUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Total economyTotal economyRest of the worldBalanceGeneral merchandise on a balance of payments basisGermany1991-Q14926

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

Share link

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