Balance of payments of the EU institutions - quarterly data (BPM6) - bop_euins6_q

Data - Eurostat

currency

Code
bop_euins6_q %>%
  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 11752495

bop_item

Code
bop_euins6_q %>%
  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_q %>%
  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 6254934
S13 General Government 4788003
S12M Financial corporations other than MFIs 709558

sectpart

Code
bop_euins6_q %>%
  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 7587512
S13 General Government 3905638
S1P Other sectors than MFIs and general government 241585
S1W Other sectors than General Government 17760

stk_flow

Code
bop_euins6_q %>%
  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
BAL Balance 4649862
DEB Debit 3918003
CRE Credit 1715972
ASS Assets 699667
NET Net 678841
LIAB Liabilities 90150

partner

Code
bop_euins6_q %>%
  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_q %>%
  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) 4982842
COMM European Commission 4727253
EDF European Development Fund 1226842
EIB European Investment Bank (EIB) 815558