Baselight

Balance Of Payments Of The EU Institutions - Quarterly Data (BPM6)

Eurostat code: bop_euins6_q ยท (1999-Q1 - 2024-Q4)

@eurostat.bop_euins6_q

Balance Of Payments Of The EU Institutions - Quarterly Data (BPM6) - Unpivoted
@eurostat.bop_euins6_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.

  • 31.16 MB
  • 11804273 rows
  • 10 columns
freq

Freq

currency

Currency

bop_item

Bop Item

sector10

Sector10

sectpart

Sectpart

stk_flow

Stk Flow

partner

Partner

geo

Geo

time_period

Time Period

value

Value

QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican, Caribbean and Pacific Group of States, signatories of the Partnership AgreementEuropean Commission1999-Q1-65134531
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican, Caribbean and Pacific Group of States, signatories of the Partnership AgreementEuropean Development Fund1999-Q1-174044502
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican, Caribbean and Pacific Group of States, signatories of the Partnership AgreementEU institutions except the institutions of the euro area (aggregate changing according to the context)1999-Q1-239179033
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican ACP statesEuropean Commission1999-Q1-62546402
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican ACP statesEuropean Development Fund1999-Q1-151469465
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceAfrican ACP statesEU institutions except the institutions of the euro area (aggregate changing according to the context)1999-Q1-214015867
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceCaribbean ACP statesEuropean Commission1999-Q1-2288128
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceCaribbean ACP statesEuropean Development Fund1999-Q1-18587236
QuarterlyEuroCurrent accountTotal economyTotal economyBalanceCaribbean ACP statesEU institutions except the institutions of the euro area (aggregate changing according to the context)1999-Q1-20875364
QuarterlyEuroCurrent accountTotal economyTotal economyBalancePacific ACP statesEuropean Commission1999-Q1-300000

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

Share link

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