Debt Servicing Costs (% Of Exports And Net Income From Abroad)

Total debt service to exports of goods, services and primary income. Total debt service is the sum of principal repayments and interest actually paid in currency, goods, or services on long-term debt, interest paid on short-term debt, and repayments (repurchases and charges) to the IMF.

HOW TO JOIN WITH METADATA

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

• 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.debt_servicing_costs_percent_of_exports_and_net_income_from_abroad AS value
FROM @gapminder.debt_servicing_costs_percent_of_exports_and_net_income_from_abroad.debt_servicing_costs_percent_of_exports_and_net_income_from_abroad_by_geo_time d
LEFT JOIN @gapminder.metadata.entities_geo_country c ON d.geo = c.country;