Smoking Men (% Of Men Over Age 15)

Percentage of men (over age 15) that smoke. Note: only 2005 tobacco data is provided by WHOSIS. In order to compare with 2002 lung cancer data, 2005 tobacco data was copied into 2002, based on the assumption that people's habit of smoking won't significantly change during 3 years.

HOW TO JOIN WITH METADATA

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

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