Net Barter Terms Of Trade (2015 = 100)

Net barter terms of trade index is calculated as the percentage ratio of the export unit value indexes to the import unit value indexes, measured relative to the base year 2015. Unit value indexes are based on data reported by countries that demonstrate consistency under UNCTAD quality controls, supplemented by UNCTAD's estimates using the previous year___s trade values at the Standard International Trade Classification three-digit level as weights. To improve data coverage, especially for the latest periods, UNCTAD constructs a set of average prices indexes at the three-digit product classification of the Standard International Trade Classification revision 3 using UNCTAD___s Commodity Price Statistics, interna__tional and national sources, and UNCTAD secretariat estimates and calculates unit value indexes at the country level using the current year's trade values as weights.

HOW TO JOIN WITH METADATA

• Concepts (labels/units)
– Use the concept id net_barter_terms_of_trade_2015_100 to look up labels and units in @gapminder.metadata.concepts.
SELECT * FROM @gapminder.metadata.concepts WHERE concept = 'net_barter_terms_of_trade_2015_100'.

• Countries and names
– Join your datapoints on geo to @gapminder.metadata.entities_geo_country to get readable country/area names
(e.g., name) and membership attributes such as world_4region, income_groups.

• Regions and other group labels
– After you have a region code from the country table (e.g., world_4region),
you can join to:
· @gapminder.metadata.entities_geo_world_4region on world_4region → region names/colors/shapes
· @gapminder.metadata.entities_geo_world_6region on world_6region → region names
· @gapminder.metadata.entities_geo_income_groups on income_groups → income group names

Example:
SELECT d.time,
c.name AS country,
d.net_barter_terms_of_trade_2015_100 AS value
FROM @gapminder.net_barter_terms_of_trade_2015_100.net_barter_terms_of_trade_2015_100_by_geo_time d
LEFT JOIN @gapminder.metadata.entities_geo_country c ON d.geo = c.country;