Skip to content
Alex Simoes edited this page Jan 8, 2017 · 2 revisions

YO (Year - Origin)

Database Columns *

* primary keys in bold

Column ID Description
year Year
origin_id Origin (country) ID
export_val Nominal value of exports
import_val Nominal value of imports
top_export_hs4 Top exported HS4 product for that country in that year
top_import_hs4 Top imported HS4 product for that country in that year
top_export_hs6 Top exported HS6 product for that country in that year
top_import_hs6 Top imported HS6 product for that country in that year
export_val_growth_pct Percentage growth of export_val over past year
export_val_growth_pct_5 Percentage growth of export_val over past 5 years
export_val_growth_val Value change of export_val over past year
export_val_growth_val_5 Value change of export_val over past 5 years
import_val_growth_pct Percentage growth of import_val over past year
import_val_growth_pct_5 Percentage growth of import_val over past 5 years
import_val_growth_val Value change of import_val over past year
import_val_growth_val_5 Value change of import_val over past 5 years

Sample Rows

year origin_id export_val import_val top_export_hs4 top_import_hs4 top_export_hs6 top_import_hs6 top_export_dest top_import_dest export_val_growth_pct export_val_growth_pct_5 export_val_growth_val export_val_growth_val_5 import_val_growth_pct import_val_growth_pct_5 import_val_growth_val import_val_growth_val_5
2014 afago 54618425459.00 25942263641.00 052709 178905 05270900 17890520 aschn aschn -0.088 0.098 -5290508266.60 20472455360.00 0.177 0.087 3898358399.00 8821595812.00
2014 afbdi 148194879.29 733618724.25 020901 052710 02090111 05271000 afcod aschn 0.894 0.019 69953290.26 13415211.79 0.942 0.08 355794411.25 234153723.51
2014 afben 2229203230.50 6782685338.93 052710 021006 05271000 02100630 afsle aschn 1.505 0.305 1339368866.05 1640640974.10 -0.039 0.119 -276980698.79 2921379223.50
2014 afbfa 3622203541.17 3578276475.77 147108 052710 14710812 05271000 euche afciv 0.333 0.284 905564868.14 2585982395.05 -0.166 0.112 -712523573.83 1469552685.56
2014 afcaf 72272894.46 399528770.96 094403 063004 09440333 06300490 aschn eufra -0.358 -0.067 -40227485.26 -30191757.47 -0.037 0.05 -15495986.46 85962193.76