YODP (Year, Origin, Destination, Product)

YODP (Year - Origin - Destination - Product)

Database Columns ^*

^* primary keys in bold

Column ID	Description
year	Year
origin_id	Origin (country) ID
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