YP (Year, Product)

YP (Year - Product)

Database Columns ^*

^* primary keys in bold

Column ID	Description
year	Year
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
pci	Product complexity value
pci_rank	Product's PCI ranking compared to all other products of the same digit length and year
pci_rank_delta	Product's PCI ranking change from previous year
top_exporter	Country that was the #1 exporter of this product in this year
top_importer	Country that was the #1 importer of this product in this 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	hs92_id	hs92_id_len	export_val	import_val	pci	pci_rank	pci_rank_delta	top_exporter	top_importer	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	010101	6	2474250181.86	2474250181.86	0.196	559	2951	eugbr	eugbr	0.031	0.03	73926692.80	341210957.48	0.031	0.03	73926692.80	341210957.48
2014	01010111	8	1317320766.08	1317320766.08	0.973	782	1381	eugbr	eugbr	0.026	0.012	33537208.86	74286182.57	0.026	0.012	33537208.86	74286182.57
2014	01010119	8	1124893962.43	1124893962.43	0.592	1454	269	nausa	nausa	0.024	0.048	26440472.40	234890771.56	0.024	0.048	26440472.40	234890771.56
2014	01010120	8	32035453.36	32035453.36	-0.445	3181	604	euirl	eugbr	0.771	6.394	13949011.56	32034003.36	0.771	6.394	13949011.56	32034003.36
2014	010102	6	9775868145.11	9775868145.11	-0.695	908	2958	nacan	nausa	0.114	0.09	1001309946.00	3412423658.04	0.114	0.09	1001309946.00	3412423658.04