Euro area19 trade by SITC product group since 1999 - ext_st_easitc

Data - Eurostat

Author

François Geerolf

Info

LAST_DOWNLOAD

Code 
tibble(dataset = c("ext_st_easitc", "ext_st_eu27_2020sitc", "namq_10_a10")) %>%
  mutate(LAST_DOWNLOAD = as.Date(file.info(paste0("~/iCloud/website/data/eurostat/", dataset, ".RData"))$mtime)) %>%
  mutate(html = paste0("[html](https://fgeerolf.com/data/eurostat/", dataset, '.html)')) %>%
  print_table_conditional()
dataset LAST_DOWNLOAD html
ext_st_easitc 2026-01-30 [html]
ext_st_eu27_2020sitc 2026-01-30 [html]
namq_10_a10 2026-01-30 [html]

LAST_COMPILE

LAST_COMPILE
2026-01-31

Last

Code 
ext_st_easitc %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  head(1) %>%
  print_table_conditional()
time Nobs
2025M11 21185

stk_flow

Code 
ext_st_easitc %>%
  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 2941733
IMP Imports 2904899
BAL_RT Balance for values / Ratio for indices 1345668

indic_et

Code 
ext_st_easitc %>%
  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 881271
TRD_VAL_SCA Seasonally and calendar adjusted trade value in million ECU/EURO 881271
IVU Unit value index (2015=100) 764924
IVOL_SCA Seasonally and calendar adjusted volume indices (2015=100) 763423
IVOL_NSA Volume indices - unadjusted data (2015=100) 763405
TRD_VAL_SCA_RT1 Growth rate M/M-1 of the seasonally and calendar adjusted trade value 583250
TRD_VAL_RT12 Growth rate M/M-12 of the trade value 561057
IVU_RT1 Growth rate M/M-1 of the unit-value indices 508858
IVOL_SCA_RT1 Growth rate M/M-1 of the seasonally and calendar adjusted volume Indices 507684
IVU_RT12 Growth rate M/M-12 of the unit-value indices 489146
IVOL_NSA_RT12 Growth rate M/M-12 of the volume Indices - unadjusted data 488011

sitc06

Code 
ext_st_easitc %>%
  left_join(sitc06, by = "sitc06") %>%
  group_by(sitc06, Sitc06) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()
sitc06 Sitc06 Nobs
TOTAL Total - all products 490664
SITC5-8 Manufactured goods 490632
SITC6_8 Other manufactured goods 490492
SITC6 Manufactured goods classified chiefly by material 490417
SITC7 Machinery and transport equipment 490259
SITC2 Crude materials, inedible, except fuels 490235
SITC2_4 Raw materials 490210
SITC0_1 Food, drinks and tobacco 488146
SITC8 Miscellaneous manufactured articles 487976
SITC0 Food and live animals 487954
SITC5 Chemicals and related products, n.e.s. 486855
SITC1 Beverages and tobacco 486182
SITC3 Mineral fuels, lubricants and related materials 474382
SITC4 Animal and vegetable oils, fats and waxes 470692
SITC33 Petroleum, petroleum products and related materials 195402
SITC9 Commodities and transactions not classified elsewhere in the SITC 181802

stk_flow

Code 
ext_st_easitc %>%
  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 2941733
IMP Imports 2904899
BAL_RT Balance for values / Ratio for indices 1345668

geo

Code 
ext_st_easitc %>%
  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_easitc %>%
  left_join(partner, by = "partner") %>%
  group_by(partner, Partner) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()

time

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