Balance Of Payments

Eurostat code: med_ecbp · (2005 - 2018)

@eurostat.med_ecbp

Table List

2 tables(66.96 KB)

Balance Of Payments - Unpivoted

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

29.25 KB
4006 rows
7 columns

freq Freq	post Post	stk_flow Stk Flow	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Current account, goods	Credit	Million euro	Algeria	2005	37234.1
Annual	Current account, goods	Credit	Million euro	Egypt	2005	11152.7
Annual	Current account, goods	Credit	Million euro	Israel	2005	32735.1
Annual	Current account, goods	Credit	Million euro	Jordan	2005	3457.8
Annual	Current account, goods	Credit	Million euro	Lebanon	2005	2218.8
Annual	Current account, goods	Credit	Million euro	Palestine*	2005	400.4
Annual	Current account, goods	Credit	Million euro	Tunisia	2005	8553.6
Annual	Current account, goods	Debit	Million euro	Algeria	2005	15924.9
Annual	Current account, goods	Debit	Million euro	Egypt	2005	19504.6
Annual	Current account, goods	Debit	Million euro	Israel	2005	35276.6


CREATE TABLE tidy (
  "freq" VARCHAR,
  "post" VARCHAR,
  "stk_flow" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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