Skip to content

YOD (Year, Origin, Destination)

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

YOD (Year - Origin - Destination)

Database Columns *

* primary keys in bold

Column ID Description
year Year
origin_id Origin (country) ID
dest_id Destination (country) ID
export_val Nominal value of exports
import_val Nominal value of imports
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 dest_id export_val import_val 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 nausa saarg 8729113525.86 4146707047.80 0.095 0.107 754844709.43 3468962591.06 -0.064 0.018 -281707061.61 348106014.22
2014 nausa sabol 1201104879.57 2035347199.84 -0.122 0.152 -167654036.42 609517157.32 0.622 0.322 780225834.86 1530819794.77
2014 nausa sabra 35115899088.50 27328937963.90 -0.028 0.118 -1005741420.80 15052846710.60 0.086 0.099 2164361156.20 10291732836.70
2014 nausa sachl 13999965614.90 9338689691.90 -0.13 0.131 -2091681822.20 6439797383.18 -0.092 0.082 -948902819.80 3043139266.98
2014 nausa sacol 17735172651.30 14807692244.80 0.083 0.132 1355108438.00 8210160809.63 -0.231 0.022 -4450186676.90 1538798738.90