Balance Of Payments

Eurostat code: enps_bop_c6_a · (2005 - 2022)

@eurostat.enps_bop_c6_a

Table List

2 tables(117.45 KB)

Balance Of Payments - Unpivoted

@eurostat.enps_bop_c6_a.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.

53.03 KB
8003 rows
8 columns

freq Freq	currency Currency	bop_item Bop Item	stk_flow Stk Flow	partner Partner	geo Geo	time_period Time Period	value Value
Annual	Million euro	Current account	Balance	European Union - 27 countries (from 2020)	Algeria	2005	11391.5
Annual	Million euro	Current account	Balance	European Union - 27 countries (from 2020)	Tunisia	2005	1800.3
Annual	Million euro	Current account	Balance	All countries of the world	Algeria	2005	16133.7
Annual	Million euro	Current account	Balance	All countries of the world	Egypt	2005	2346.6
Annual	Million euro	Current account	Balance	All countries of the world	Israel	2005	3921.9
Annual	Million euro	Current account	Balance	All countries of the world	Jordan	2005	-1826.4
Annual	Million euro	Current account	Balance	All countries of the world	Lebanon	2005	-2231.8
Annual	Million euro	Current account	Balance	All countries of the world	Palestine*	2005	-1097.5
Annual	Million euro	Current account	Balance	All countries of the world	Tunisia	2005	-240.8
Annual	Million euro	Current account	Credit	European Union - 27 countries (from 2020)	Algeria	2005	22216.2


CREATE TABLE tidy (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "bop_item" 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.