Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Cumulative CO2 emissions data 1990-1992

Hi there, can you please have a closer look at your "Cumulative CO2 emissions (tonnes)" datasheet? I can't see why, but the cumulative totals drop between 1990 and 1991 and again between 1991 and 1992. Just love the data availability. Very grateful.
1 person has
this question
+1
Reply
  • I’m glad i found an answer
    So i got curious and went on to explore the issue =)

    Here is the original dataset:
    https://docs.google.com/spreadsheets/...

    Here is my copy:
    https://docs.google.com/spreadsheets/...

    you can see, to the right and bottom of the table i've calculated deltas for total emissions at each year, and also for every country for years 1991 minus 1990 and 1992 minus 1991

    the negative values which correspond to CO2 drop are highlighted with red

    i can see you're right about 1991 and 1992, but it turns out that the countries that contributed to the emission drop are the ones that stopped existing these years: USSR, Yugoslavia, Czechoslovakia, East Germany, West Germany, North Yemen (former), South Yemen (former)

    And there is also data for united Germany for all the years, calculated as the sum of the two (plus cumulative value before the split of Germany). So there you go, East and West Germany disappear, the total value drops.

    There is also a drop in total value in 2009 to 2010, just because data is missing for many countries for 2010 and beyond.

    Thanks for the riddle! Let me know if you have more questions!
    //Angie from Gapminder
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • Dear Angie,
    Thank you very much for pinpointing the problem. In my version of the data, I have now removed the duplication regarding Germany, Yugoslavia, Yemen, Estonia and Latvia. This has removed the drop between 1990 and 1991, but not between 1991 and 1992. There is about 100 billion tonnes missing as a result of the dissolution of the USSR.
    Any further ideas?
    One explanation might be a political need of the former USSR to artificially inflate its economic output in light of the cold war. But I have no data to verify that assumption.
    Kind regards,
    Jos
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • This is the animated GIF that I intended to create.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated