Strategic Trade Atlas Data 2014-2018
Joint Research Centre
@ecjrc.aab8a6e1_de9e_415b_b905_08c2a5f516e7
Table 3
@ecjrc.aab8a6e1_de9e_415b_b905_08c2a5f516e7.table_3
The compressed CSV file contains 101058 records about the Revealed Comparative Advantage by countries measured on the trade of strategic commodities. A record contains the following fields: REPORTER (country reporting trade, expressed in full text name, as well as ISO2 and ISO3 country codes); FLOW of trade (import, export); PERIOD of trade (a year); STRATEGIC COMMODITY SHORT DESCRIPTION; RCA VALUE USD (the Revealed Comparative Advantage measured on the value of trade); RCA QUANTITY KG (the Revealed Comparative Advantage measured on the quantity of trade); NRCA VALUE USD (the Normalized Revealed Comparative Advantage measured on the value of trade); NRCA QUANTITY KG (the Normalized Revealed Comparative Advantage measured on the quantity of trade).
- 34.28 MB
- 2606568 rows
- 13 columns
commodity_codeCOMMODITY CODE | commodity_descriptionCOMMODITY DESCRIPTION | flowFLOW | partnerPARTNER | partner_iso2PARTNER ISO2 | partner_iso3PARTNER ISO3 | periodPERIOD | reporterREPORTER | reporter_iso2REPORTER ISO2 | reporter_iso3REPORTER ISO3 | strategic_commodity_short_descriptionSTRATEGIC COMMODITY SHORT DESCRIPTION | quantity_kgQUANTITY KG | value_usdVALUE USD |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2811.19 | Inorganic acids (excl. hydrogen chloride "hydrochloric acid", chlorosulphuric acid, sulphuric acid, oleum, nitric acid, sulphonitric acids, phosphoric acid, polyphosphoric acids, boric acids and hydrogen fluoride "hydrofluoric acid") | Export | Tunisia | TN | TUN | Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Egypt | EG | EGY | CWC scheduled chemicals | 35152.98 | 59119 |
| 2811.19 | Inorganic acids (excl. hydrogen chloride "hydrochloric acid", chlorosulphuric acid, sulphuric acid, oleum, nitric acid, sulphonitric acids, phosphoric acid, polyphosphoric acids, boric acids and hydrogen fluoride "hydrofluoric acid") | Export | Libya | LY | LBY | Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tunisia | TN | TUN | CWC scheduled chemicals | 880 | 2064 |
| 2853 | Inorganic compounds, incl. distilled or conductivity water and water of similar purity, n.e.s.; liquid air, whether or not rare gases have been removed; compressed air; amalgams (excl. amalgams of precious metals) | Export | Algeria | DZ | DZA | Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tunisia | TN | TUN | CWC scheduled chemicals | 456.05 | 7601 |
| 2853 | Inorganic compounds, incl. distilled or conductivity water and water of similar purity, n.e.s.; liquid air, whether or not rare gases have been removed; compressed air; amalgams (excl. amalgams of precious metals) | Export | Egypt | EG | EGY | Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tunisia | TN | TUN | CWC scheduled chemicals | 12 | 178 |
| 2853 | Inorganic compounds, incl. distilled or conductivity water and water of similar purity, n.e.s.; liquid air, whether or not rare gases have been removed; compressed air; amalgams (excl. amalgams of precious metals) | Export | Libya | LY | LBY | Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tunisia | TN | TUN | CWC scheduled chemicals | 815800 | 335854 |
| 2844.4 | Radioactive elements, isotopes and compounds, and alloys and dispersions, incl. cermets, ceramic products and mixtures, containing these elements, isotopes and compounds; radioactive residues (excl. natural uranium, uranium enriched and depleted in U 235; plutonium, thorium and compounds of these pr… | Export | Libya | LY | LBY | Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tunisia | TN | TUN | Radioactive elements | 108 | 41723 |
| 2904.9 | Sulphonated, nitrated or nitrosated derivatives of hydrocarbons, whether or not halogenated (excl. those containing only sulpho, nitro or nitroso groups) | Export | Tunisia | TN | TUN | Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Algeria | DZ | DZA | CWC scheduled chemicals | 3355000 | 5911024 |
| 2918.19 | Carboxylic acids with additional oxygen function and their anhydrides, halides, peroxides and peroxyacids; their halogenated, sulphonated, nitrated or nitrosated derivatives (excl. lactic acid, tartaric acid, citric acid, gluconic acid and their salts and esters, and chlorobenzilate [ISO]) | Export | Algeria | DZ | DZA | Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tunisia | TN | TUN | CWC scheduled chemicals | 3010 | 34854 |
| 2920.9 | Esters of other inorganic acids of non-metals and their salts; their halogenated, sulphonated, nitrated or nitrosated derivatives (excl. esters of hydrogen halides, and thiophosphoric esters "phosphorothioates", their salts and their halogenated, sulphonated, nitrated or nitrosated derivatives, and … | Export | Tunisia | TN | TUN | Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Algeria | DZ | DZA | CWC scheduled chemicals | 144 | 20494 |
| 2920.9 | Esters of other inorganic acids of non-metals and their salts; their halogenated, sulphonated, nitrated or nitrosated derivatives (excl. esters of hydrogen halides, and thiophosphoric esters "phosphorothioates", their salts and their halogenated, sulphonated, nitrated or nitrosated derivatives, and … | Export | Algeria | DZ | DZA | Wed Dec 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time) | Tunisia | TN | TUN | CWC scheduled chemicals | 10 | 1298 |
CREATE TABLE table_3 (
"commodity_code" DOUBLE,
"commodity_description" VARCHAR,
"flow" VARCHAR,
"partner" VARCHAR,
"partner_iso2" VARCHAR,
"partner_iso3" VARCHAR,
"period" TIMESTAMP,
"reporter" VARCHAR,
"reporter_iso2" VARCHAR,
"reporter_iso3" VARCHAR,
"strategic_commodity_short_description" VARCHAR,
"quantity_kg" DOUBLE,
"value_usd" BIGINT
);