YOP (Year, Origin, Product)
Alex Simoes edited this page Jan 8, 2017
·
3 revisions
* primary keys in bold
| Column ID | Description |
|---|---|
year |
Year |
origin_id |
Origin (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_rca |
Export RCA (revealed comparative advantage) value |
import_rca |
Import RCA (revealed comparative advantage) value |
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 |
| year | origin_id | hs92_id | hs92_id_len | export_val | import_val | export_rca | import_rca | 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 | density | opp_gain | normalized_opp_gain_density |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2014 | nausa | 010101 | 6 | 390685133.49 | 295884352.21 | 1.913 | 0.964 | 0.17 | -0.004 | 56815801.37 | -8456906.72 | -0.121 | 0.04 | -40852761.09 | 52616674.50 | 0.556178 | -0.143527 | 1.29592 |
| 2014 | nausa | 01010111 | 8 | 207353287.81 | 55699336.04 | 1.907 | 0.341 | 0.093 | -0.009 | 17655150.64 | -9546232.34 | 0.364 | 0.065 | 14871142.66 | 15083115.78 | NULL | NULL | NULL |
| 2014 | nausa | 01010119 | 8 | 181507481.24 | 237244947.25 | 1.955 | 1.7 | 0.273 | -0.001 | 38869367.28 | -735038.83 | -0.197 | 0.032 | -58353685.39 | 34593489.80 | NULL | NULL | NULL |
| 2014 | nausa | 01010120 | 8 | 1824364.45 | 2940068.92 | 0.69 | 0.74 | 0.19 | NULL | 291283.45 | NULL | 8.475 | NULL | 2629781.64 | NULL | NULL | NULL | NULL |
| 2014 | nausa | 010102 | 6 | 190799749.18 | 2543476477.23 | 0.236 | 2.098 | -0.411 | 0.15 | -132872824.67 | 95854849.87 | 0.396 | 0.137 | 721719194.38 | 1202926576.99 | 0.388447 | 0.0813952 | 1.13195 |