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 300313

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 148230
S12M Financial corporations other than MFIs 140551
S13 General Government 11532

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 209671
S1P Other sectors than MFIs and general government 84062
S13 General Government 6580

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 97463
L_LE Liabilities - positions at the end of period 70971
N_LE Net positions at the end of period 45889
A_KA Assets - other changes in the volume of Assets/Liabilities 30736
L_KA Liabilities - other changes in the volume of Assets/Liabilities 19316
N_KA Net other changes in the volume of Assets/Liabilities 17096
A_K7B Assets - revaluations due to other price changes 10342
L_K7B Liabilities - revaluations due to other price changes 3680
N_K7B Net revaluations due to other price changes 2612
A_K7A Assets - revaluations due to exchange rate changes 772
N_K7A Net revaluations due to exchange rate changes 772
L_K7A Liabilities - revaluations due to exchange rate changes 664

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) 146163
EIB European Investment Bank (EIB) 136210
COMM European Commission 11532
EIF European Investment Fund 6408