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-02-23 [html]
ext_st_eu27_2020sitc 2026-02-23 [html]
namq_10_a10 2026-02-23 [html]

LAST_COMPILE

LAST_COMPILE
2026-02-24

Last

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

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 2952123
IMP Imports 2915139
BAL_RT Balance for values / Ratio for indices 1350383

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 884343
TRD_VAL_SCA Seasonally and calendar adjusted trade value in million ECU/EURO 884343
IVU Unit value index (2015=100) 767615
IVOL_SCA Seasonally and calendar adjusted volume indices (2015=100) 766095
IVOL_NSA Volume indices - unadjusted data (2015=100) 766082
TRD_VAL_SCA_RT1 Growth rate M/M-1 of the seasonally and calendar adjusted trade value 585208
TRD_VAL_RT12 Growth rate M/M-12 of the trade value 563105
IVU_RT1 Growth rate M/M-1 of the unit-value indices 510652
IVOL_SCA_RT1 Growth rate M/M-1 of the seasonally and calendar adjusted volume Indices 509464
IVU_RT12 Growth rate M/M-12 of the unit-value indices 490939
IVOL_NSA_RT12 Growth rate M/M-12 of the volume Indices - unadjusted data 489799

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 492392
SITC5-8 Manufactured goods 492358
SITC6_8 Other manufactured goods 492221
SITC6 Manufactured goods classified chiefly by material 492141
SITC7 Machinery and transport equipment 491986
SITC2 Crude materials, inedible, except fuels 491955
SITC2_4 Raw materials 491938
SITC0_1 Food, drinks and tobacco 489868
SITC8 Miscellaneous manufactured articles 489704
SITC0 Food and live animals 489676
SITC5 Chemicals and related products, n.e.s. 488578
SITC1 Beverages and tobacco 487906
SITC3 Mineral fuels, lubricants and related materials 476043
SITC4 Animal and vegetable oils, fats and waxes 472344
SITC33 Petroleum, petroleum products and related materials 196093
SITC9 Commodities and transactions not classified elsewhere in the SITC 182442

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 2952123
IMP Imports 2915139
BAL_RT Balance for values / Ratio for indices 1350383

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