Aid Received Per Person (current US$)

Net official development assistance (ODA) per capita consists of disbursements of loans made on concessional terms (net of repayments of principal) and grants by official agencies of the members of the Development Assistance Committee (DAC), by multilateral institutions, and by non-DAC countries to promote economic development and welfare in countries and territories in the DAC list of ODA recipients; and is calculated by dividing net ODA received by the midyear population estimate. It includes loans with a grant element of at least 25 percent (calculated at a rate of discount of 10 percent).

HOW TO JOIN WITH METADATA

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

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