Skip to content

YDP (Year, Destination, Product)

Alex Simoes edited this page Feb 13, 2017 · 1 revision

YDP (Year - Destination - Product)

Database Columns *

* primary keys in bold

Column ID Description
year Year
dest_id Dest (country) ID
prod_id Product ID
prod_id_len Product ID length (6 or 8)*
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 dest_id hs92_id hs92_id_len 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 sabra 010101 6 5912314.38 5420690.07 -0.05 0.102 -309480.37 2275150.96 0.466 -0.016 1722671.23 -464730.66
2014 sabra 01010111 8 3926097.00 3919558.35 0.353 0.118 1023882.87 1674873.59 0.593 -0.046 1459685.96 -1034807.17
2014 sabra 01010119 8 1983356.89 1501131.71 -0.403 0.074 -1336223.72 597416.89 0.212 0.1 262985.27 570076.51
2014 sabra 01010120 8 2860.48 NULL NULL NULL NULL NULL NULL NULL NULL NULL
2014 sabra 010102 6 7249649.07 717962696.43 30.272 -0.079 7017822.34 -3689576.26 0.022 0.049 15342782.74 153988395.67