Balance Of Payments And International Investment Position - BPS

European Central Bank

@ecb.balance_of_payments_and_international_investment_position_bps

Table List

1 table(43.17 MB)

Table 1

@ecb.balance_of_payments_and_international_investment_position_bps.table_1

43.17 MB
6830276 rows
35 columns

key KEY	freq FREQ	adjustment ADJUSTMENT	ref_area REF AREA	counterpart_area COUNTERPART AREA	ref_sector REF SECTOR	counterpart_sector COUNTERPART SECTOR	flow_stock_entry FLOW STOCK ENTRY	accounting_entry ACCOUNTING ENTRY	int_acc_item INT ACC ITEM	functional_cat FUNCTIONAL CAT	instr_asset INSTR ASSET	maturity MATURITY	unit_measure UNIT MEASURE	currency_denom CURRENCY DENOM	valuation VALUATION	comp_method COMP METHOD	type_entity TYPE ENTITY	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	conf_status CONF STATUS	time_format TIME FORMAT	comment_ts COMMENT TS	compiling_org COMPILING ORG	decimals DECIMALS	time_per_collect TIME PER COLLECT	title TITLE	title_compl TITLE COMPL	unit_mult UNIT MULT
BPS.A.N.SK.W1.S1.S1.LE.NE.FA._T.FNED._Z.EUR_R_B1GQ._T._X.N.ALL	A	N	SK	W1	S1	S1	LE	NE	FA	_T	FNED	_Z	EUR_R_B1GQ	_T	_X	N	ALL	2019	31.806541264976325	A	F	P1Y	- Neither seasonally adjusted nor calendar adjusted data- Slovakia vis-a-vis Rest of the World- sector: Total economy vis-a-vis Total economy- Closing balance sheet/Positions/Stocks- Net Liabilities (Liabilities minus Assets)- Financial account- All functional categories- Net external debt- Euro; ra…	4F0		E	Net external debt
BPS.A.N.SK.W1.S1.S1.LE.NE.FA._T.FNED._Z.EUR_R_B1GQ._T._X.N.ALL	A	N	SK	W1	S1	S1	LE	NE	FA	_T	FNED	_Z	EUR_R_B1GQ	_T	_X	N	ALL	2020	31.04438815199766	A	F	P1Y	- Neither seasonally adjusted nor calendar adjusted data- Slovakia vis-a-vis Rest of the World- sector: Total economy vis-a-vis Total economy- Closing balance sheet/Positions/Stocks- Net Liabilities (Liabilities minus Assets)- Financial account- All functional categories- Net external debt- Euro; ra…	4F0		E	Net external debt
BPS.A.N.SK.W1.S1.S1.LE.NE.FA._T.FNED._Z.EUR_R_B1GQ._T._X.N.ALL	A	N	SK	W1	S1	S1	LE	NE	FA	_T	FNED	_Z	EUR_R_B1GQ	_T	_X	N	ALL	2021	30.847994743480207	A	F	P1Y	- Neither seasonally adjusted nor calendar adjusted data- Slovakia vis-a-vis Rest of the World- sector: Total economy vis-a-vis Total economy- Closing balance sheet/Positions/Stocks- Net Liabilities (Liabilities minus Assets)- Financial account- All functional categories- Net external debt- Euro; ra…	4F0		E	Net external debt
BPS.M.N.CZ.W1.S121.S1.KA.A.FA.R.F3.T.EUR.X1.M.N.ALL	M	N	CZ	W1	S121	S1	KA	A	FA	R	F3	T	EUR	X1	M	N	ALL	2013-01		Q	F	P1M	- Monthly- Neither seasonally adjusted nor calendar adjusted data- Czech Republic vis-a-vis Rest of the World- sector: Central bank vis-a-vis Total economy- Other Changes in the volume of Assets/Liabilities = Other changes excluding revaluations- Assets (Net Acquisition of)- Financial account- Reser…	4F0	3	S	Financial account, Reserve Assets, Assets	Financial account, Reserve Assets, Debt securities- Assets, Monthly - Czech Republic vis-a-vis Rest of the World -sector: Central bank vis-a_vis Total economy	6
BPS.M.N.CZ.W1.S121.S1.KA.A.FA.R.F3.T.EUR.X1.M.N.ALL	M	N	CZ	W1	S121	S1	KA	A	FA	R	F3	T	EUR	X1	M	N	ALL	2013-02		Q	F	P1M	- Monthly- Neither seasonally adjusted nor calendar adjusted data- Czech Republic vis-a-vis Rest of the World- sector: Central bank vis-a-vis Total economy- Other Changes in the volume of Assets/Liabilities = Other changes excluding revaluations- Assets (Net Acquisition of)- Financial account- Reser…	4F0	3	S	Financial account, Reserve Assets, Assets	Financial account, Reserve Assets, Debt securities- Assets, Monthly - Czech Republic vis-a-vis Rest of the World -sector: Central bank vis-a_vis Total economy	6
BPS.M.N.CZ.W1.S121.S1.KA.A.FA.R.F3.T.EUR.X1.M.N.ALL	M	N	CZ	W1	S121	S1	KA	A	FA	R	F3	T	EUR	X1	M	N	ALL	2013-03		Q	F	P1M	- Monthly- Neither seasonally adjusted nor calendar adjusted data- Czech Republic vis-a-vis Rest of the World- sector: Central bank vis-a-vis Total economy- Other Changes in the volume of Assets/Liabilities = Other changes excluding revaluations- Assets (Net Acquisition of)- Financial account- Reser…	4F0	3	S	Financial account, Reserve Assets, Assets	Financial account, Reserve Assets, Debt securities- Assets, Monthly - Czech Republic vis-a-vis Rest of the World -sector: Central bank vis-a_vis Total economy	6
BPS.M.N.CZ.W1.S121.S1.KA.A.FA.R.F3.T.EUR.X1.M.N.ALL	M	N	CZ	W1	S121	S1	KA	A	FA	R	F3	T	EUR	X1	M	N	ALL	2013-04		Q	F	P1M	- Monthly- Neither seasonally adjusted nor calendar adjusted data- Czech Republic vis-a-vis Rest of the World- sector: Central bank vis-a-vis Total economy- Other Changes in the volume of Assets/Liabilities = Other changes excluding revaluations- Assets (Net Acquisition of)- Financial account- Reser…	4F0	3	S	Financial account, Reserve Assets, Assets	Financial account, Reserve Assets, Debt securities- Assets, Monthly - Czech Republic vis-a-vis Rest of the World -sector: Central bank vis-a_vis Total economy	6
BPS.M.N.CZ.W1.S121.S1.KA.A.FA.R.F3.T.EUR.X1.M.N.ALL	M	N	CZ	W1	S121	S1	KA	A	FA	R	F3	T	EUR	X1	M	N	ALL	2013-05		Q	F	P1M	- Monthly- Neither seasonally adjusted nor calendar adjusted data- Czech Republic vis-a-vis Rest of the World- sector: Central bank vis-a-vis Total economy- Other Changes in the volume of Assets/Liabilities = Other changes excluding revaluations- Assets (Net Acquisition of)- Financial account- Reser…	4F0	3	S	Financial account, Reserve Assets, Assets	Financial account, Reserve Assets, Debt securities- Assets, Monthly - Czech Republic vis-a-vis Rest of the World -sector: Central bank vis-a_vis Total economy	6
BPS.M.N.CZ.W1.S121.S1.KA.A.FA.R.F3.T.EUR.X1.M.N.ALL	M	N	CZ	W1	S121	S1	KA	A	FA	R	F3	T	EUR	X1	M	N	ALL	2013-06		Q	F	P1M	- Monthly- Neither seasonally adjusted nor calendar adjusted data- Czech Republic vis-a-vis Rest of the World- sector: Central bank vis-a-vis Total economy- Other Changes in the volume of Assets/Liabilities = Other changes excluding revaluations- Assets (Net Acquisition of)- Financial account- Reser…	4F0	3	S	Financial account, Reserve Assets, Assets	Financial account, Reserve Assets, Debt securities- Assets, Monthly - Czech Republic vis-a-vis Rest of the World -sector: Central bank vis-a_vis Total economy	6
BPS.M.N.CZ.W1.S121.S1.KA.A.FA.R.F3.T.EUR.X1.M.N.ALL	M	N	CZ	W1	S121	S1	KA	A	FA	R	F3	T	EUR	X1	M	N	ALL	2013-07		Q	F	P1M	- Monthly- Neither seasonally adjusted nor calendar adjusted data- Czech Republic vis-a-vis Rest of the World- sector: Central bank vis-a-vis Total economy- Other Changes in the volume of Assets/Liabilities = Other changes excluding revaluations- Assets (Net Acquisition of)- Financial account- Reser…	4F0	3	S	Financial account, Reserve Assets, Assets	Financial account, Reserve Assets, Debt securities- Assets, Monthly - Czech Republic vis-a-vis Rest of the World -sector: Central bank vis-a_vis Total economy	6


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "adjustment" VARCHAR,
  "ref_area" VARCHAR,
  "counterpart_area" VARCHAR,
  "ref_sector" VARCHAR,
  "counterpart_sector" VARCHAR,
  "flow_stock_entry" VARCHAR,
  "accounting_entry" VARCHAR,
  "int_acc_item" VARCHAR,
  "functional_cat" VARCHAR,
  "instr_asset" VARCHAR,
  "maturity" VARCHAR,
  "unit_measure" VARCHAR,
  "currency_denom" VARCHAR,
  "valuation" VARCHAR,
  "comp_method" VARCHAR,
  "type_entity" VARCHAR,
  "time_period" VARCHAR,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "conf_status" VARCHAR,
  "pre_break_value" VARCHAR,
  "comment_obs" VARCHAR,
  "time_format" VARCHAR,
  "comment_ts" VARCHAR,
  "compiling_org" VARCHAR,
  "data_comp" VARCHAR,
  "decimals" BIGINT,
  "diss_org" VARCHAR,
  "ref_period_detail" VARCHAR,
  "time_per_collect" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit_mult" BIGINT
);