EU27 (from 2020) trade by SITC product group - ext_st_eu27_2020sitc

Data - Eurostat

Author

François Geerolf

stk_flow

Code 
ext_st_eu27_2020sitc %>%
  left_join(stk_flow, by = "stk_flow") %>%
  group_by(stk_flow, Stk_flow) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()
stk_flow Stk_flow Nobs
EXP Exports 2587729
IMP Imports 2560892
BAL_RT Balance for values / Ratio for indices 1205232

indic_et

Code 
ext_st_eu27_2020sitc %>%
  left_join(indic_et, by = "indic_et") %>%
  group_by(indic_et, Indic_et) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()
indic_et Indic_et Nobs
TRD_VAL Trade value in million ECU/EURO 769842
TRD_VAL_SCA Seasonally and calendar adjusted trade value in million ECU/EURO 729966
IVU Unit value index (2015=100) 724906
IVOL_NSA Volume indices - unadjusted data (2015=100) 723492
IVOL_SCA Seasonally and calendar adjusted volume indices (2015=100) 677446
TRD_VAL_RT12 Growth rate M/M-12 of the trade value 490314
TRD_VAL_SCA_RT1 Growth rate M/M-1 of the seasonally and calendar adjusted trade value 483585
IVU_RT1 Growth rate M/M-1 of the unit-value indices 447902
IVOL_SCA_RT1 Growth rate M/M-1 of the seasonally and calendar adjusted volume Indices 446468
IVU_RT12 Growth rate M/M-12 of the unit-value indices 430666
IVOL_NSA_RT12 Growth rate M/M-12 of the volume Indices - unadjusted data 429266

sitc06

Code 
ext_st_eu27_2020sitc %>%
  left_join(sitc06, by = "sitc06") %>%
  group_by(sitc06, Sitc06) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()
sitc06 Sitc06 Nobs
TOTAL Total - all products 432526
SITC5-8 Manufactured goods 432506
SITC6_8 Other manufactured goods 432428
SITC6 Manufactured goods classified chiefly by material 432342
SITC2_4 Raw materials 432138
SITC2 Crude materials, inedible, except fuels 432097
SITC7 Machinery and transport equipment 431995
SITC8 Miscellaneous manufactured articles 431549
SITC0_1 Food, drinks and tobacco 431133
SITC0 Food and live animals 430993
SITC5 Chemicals and related products, n.e.s. 430723
SITC1 Beverages and tobacco 429132
SITC3 Mineral fuels, lubricants and related materials 423871
SITC4 Animal and vegetable oils, fats and waxes 417586
SITC33 Petroleum, petroleum products and related materials 172509
SITC9 Commodities and transactions not classified elsewhere in the SITC 160325

stk_flow

Code 
ext_st_eu27_2020sitc %>%
  left_join(stk_flow, by = "stk_flow") %>%
  group_by(stk_flow, Stk_flow) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()
stk_flow Stk_flow Nobs
EXP Exports 2587729
IMP Imports 2560892
BAL_RT Balance for values / Ratio for indices 1205232

geo

Code 
ext_st_eu27_2020sitc %>%
  left_join(geo, by = "geo") %>%
  group_by(geo, Geo) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  mutate(Flag = gsub(" ", "-", str_to_lower(Geo)),
         Flag = paste0('<img src="../../bib/flags/vsmall/', Flag, '.png" alt="Flag">')) %>%
  select(Flag, everything()) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}

partner

Code 
ext_st_eu27_2020sitc %>%
  left_join(partner, by = "partner") %>%
  group_by(partner, Partner) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()

time

Code 
ext_st_eu27_2020sitc %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  print_table_conditional()