| Hello from London and welcome back to the Climate Graphic: Explained. While FT colleagues are working hard to bring you the latest insights from the UN COP31 in Antalya, Turkey, where almost 200 countries are gathered, this week I delved into the latest data behind the emissions of their populations. It confirms that regardless of where you live in the world, the richest contribute disproportionately to the planet warming — even within individual countries. Oxfam published a report in the lead-up to the annual climate summit stating the wealthiest 1% of the global population contributed about twice the emissions of the poorest 50%. The report describes how the very wealthy also have the means to insulate themselves — literally and figuratively — from the impact of climate change caused by their increased carbon footprint. The other 99 per cent are by turns disproportionately affected by climate-related disasters such as floods, droughts and food shortages. The authors of the study use data from the Stockholm Environment Institute’s Emissions Inequality Calculator to break down annual global emissions per capita by wealth group. Instead of creating a bar chart to compare the numbers, I wanted to use a format that would show both the share each wealth group comprises of the global population and their share of emissions. Initially, I tried out a Marimekko chart, which is a useful format when you want to show both the size and proportion of your data. In this chart, the y-axis represents the share of the population and the x-axis represents the share of global emissions. [Nerd note: Want to go beyond the bar chart when it comes to designing your own data visualisations? The FT Visual Vocabulary is a handy guide on when and how to use different chart formats.] Ironically, this chart format highlighted the disparity but the bar for the wealthiest 1% was so thin it was easy to miss! Instead I used two stacked bar charts scaled to 100% and shaded the areas in between to draw a stronger visual link between the population groups and their emissions. I also used the same stacked bar format to illustrate the breakdown of wealthy Americans’ emissions by asset ownership using data compiled by World Inequality Lab. When researching data for stories like this, I analyse information from multiple sources such as databases run by think-tanks and NGOs and research papers by scientists across the world. The charts that make it into the final story are usually a subset of the greater set of exploratory visuals created, to make sure every graphic we publish has an insight to share. But sometimes the work needed to turn a table of data into an impactful graphic requires more time than anticipated, and it's a stretch to finish the work before deadline. One of the graphics that came late into the article was a map of carbon footprint disparity across districts in India based on data released by researchers affiliated with the Spatial Footprint project. The dataset came from the researchers with the name and calculated footprint value per district. In order to use it in our mapping software of choice Qgis, I had to match the data for each district to a data file of the shapes of each district. This should have been straightforward — so long as two datasets have a column in common that uses the same values, such as a district ID, then I could have joined them using code or the Qgis inbuilt functionality. However, I realised that not only was the Spatial Footprint dataset mapped to the 2011 district boundaries instead of the more up-to-date version we use now, but the only column information given was the district name. That wasn’t the only problem: the district names didn’t match up perfectly; there were significant differences in the way several district names had been spelled in English, and others used different versions of the official name. There were also a handful of districts in different states that used the same name. I ended up having to match the datasets manually and because there were more than 600 districts it took several more hours than initially anticipated. Ultimately, it was a good learning exercise, even if stressful on deadline. The graphics and data back up the research about the need for policies that recognised the disparities of wealth. “We have a policy gap because we’re trying to come up with like one-size fits-all solutions,” said Malcolm Morgan, a senior research fellow at the University of Leeds, who has led the project mapping carbon footprints across the UK. Edited by Emiliya Mychasuk, FT climate editor |