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 2424433
IMP Imports 2399087
BAL_RT Balance for values / Ratio for indices 1131191

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 721890
TRD_VAL_SCA Seasonally and calendar adjusted trade value in million ECU/EURO 684498
IVU Unit value index (2015=100) 679554
IVOL_NSA Volume indices - unadjusted data (2015=100) 678883
IVOL_SCA Seasonally and calendar adjusted volume indices (2015=100) 635742
TRD_VAL_RT12 Growth rate M/M-12 of the trade value 458349
TRD_VAL_SCA_RT1 Growth rate M/M-1 of the seasonally and calendar adjusted trade value 453321
IVU_RT1 Growth rate M/M-1 of the unit-value indices 419849
IVOL_SCA_RT1 Growth rate M/M-1 of the seasonally and calendar adjusted volume Indices 418564
IVU_RT12 Growth rate M/M-12 of the unit-value indices 402633
IVOL_NSA_RT12 Growth rate M/M-12 of the volume Indices - unadjusted data 401428

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 405310
SITC5-8 Manufactured goods 405290
SITC6_8 Other manufactured goods 405214
SITC6 Manufactured goods classified chiefly by material 405104
SITC7 Machinery and transport equipment 405102
SITC2_4 Raw materials 405091
SITC2 Crude materials, inedible, except fuels 405067
SITC8 Miscellaneous manufactured articles 404444
SITC5 Chemicals and related products, n.e.s. 404214
SITC0_1 Food, drinks and tobacco 403955
SITC0 Food and live animals 403771
SITC1 Beverages and tobacco 402440
SITC3 Mineral fuels, lubricants and related materials 397150
SITC4 Animal and vegetable oils, fats and waxes 390728
SITC33 Petroleum, petroleum products and related materials 161565
SITC9 Commodities and transactions not classified elsewhere in the SITC 150266

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 2424433
IMP Imports 2399087
BAL_RT Balance for values / Ratio for indices 1131191

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()