International investment position of the EU institutions (BPM6) - bop_euins6_iip

Data - Eurostat

currency

Code
bop_euins6_iip %>%
  left_join(currency, by = "currency") %>%
  group_by(currency, Currency) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
currency Currency Nobs
EUR Euro 314071

bop_item

Code
bop_euins6_iip %>%
  left_join(bop_item, by = "bop_item") %>%
  group_by(bop_item, Bop_item) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

sector10

Code
bop_euins6_iip %>%
  left_join(sector10, by = "sector10") %>%
  group_by(sector10, Sector10) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
sector10 Sector10 Nobs
S1 Total economy 154912
S12M Financial corporations other than MFIs 146331
S13 General Government 12828

sectpart

Code
bop_euins6_iip %>%
  left_join(sectpart, by = "sectpart") %>%
  group_by(sectpart, Sectpart) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
sectpart Sectpart Nobs
S1 Total economy 219241
S1P Other sectors than MFIs and general government 87434
S13 General Government 7396

stk_flow

Code
bop_euins6_iip %>%
  left_join(stk_flow, by = "stk_flow") %>%
  group_by(stk_flow, Stk_flow) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
stk_flow Stk_flow Nobs
A_LE Assets - positions at the end of period 102346
L_LE Liabilities - positions at the end of period 74000
N_LE Net positions at the end of period 48093
A_KA Assets - other changes in the volume of Assets/Liabilities 32184
L_KA Liabilities - other changes in the volume of Assets/Liabilities 20056
N_KA Net other changes in the volume of Assets/Liabilities 17892
A_K7B Assets - revaluations due to other price changes 10692
L_K7B Liabilities - revaluations due to other price changes 3820
N_K7B Net revaluations due to other price changes 2696
A_K7A Assets - revaluations due to exchange rate changes 800
N_K7A Net revaluations due to exchange rate changes 800
L_K7A Liabilities - revaluations due to exchange rate changes 692

partner

Code
bop_euins6_iip %>%
  left_join(partner, by = "partner") %>%
  group_by(partner, Partner) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

geo

Code
bop_euins6_iip %>%
  left_join(geo, by = "geo") %>%
  group_by(geo, Geo) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
geo Geo Nobs
EUI_X_EAI EU institutions except the institutions of the euro area (aggregate changing according to the context) 152719
EIB European Investment Bank (EIB) 141864
COMM European Commission 12828
EIF European Investment Fund 6660