Today's post goes into the global consumption of energy and provides a dataset in Excel for researchers on global primary energy consumption from 1830 to 2010. In other words, the energy contained in fossil fuels, uranium, and biomass in their raw form before processing into electricity, heat, or liquid fuel, and direct electricity production from hydro, solar, wind, and geothermal. The dataset, based on an assessment of seven different data sources, shows the following:
A graphical depiction of the data and comparison of sources can be found below the fold.
The charts below can be found in the Excel file, source attribution can be found at the bottom. The data in the charts is normally displayed in exajoules (10^18 joules) and in a few cases in Quadrillion (10^15) BTU's for data comparison. The following conversion factors were used:
A few notes on calculations made to make a data comparison:
Global Primary Energy Consumption per source stacked and individual graphs
The first two charts in this section display the evolution of primary energy consumption broken down by energy sources. Figure 1 shows the evolution from 1830 to 2010 and Figure 2 from 1970 to 2010. The same is shown in Figures 3 and 4 but by the individual curves of each energy source.

Figure 1 - Stacked chart of Global Primary Energy Consumption 1830 - 2010

Figure 2 - Stacked chart of Global Primary Energy Consumption 1970 - 2010

Figure 3 - Individual curves for energy sources of Global Primary Energy Consumption 1830 - 2010

Figure 4 - Individual curves for energy sources of Global Primary Energy Consumption 1970 - 2010
Growth path comparison of Primary Energy delivered per source
In this section, a dataset is graphically depicted wherein a comparison is made of the number of years for each energy source to grow from 1 exajoule to 10 exajoules of energy production. By comparing these, it can be shown how long different energy sources took to become influential in global energy supply.

Figure 5 - Energy Source Growth Path comparison 1 to 10 exajoules
Comparison of different Primary Energy Data sources
Four charts are shown below that outline the differences between datasets for bio-energy (biomass + biofuel), coal, natural gas, and crude oil. The main differences in the datasets can be found in the years after 2000 for biofuels, 1950 to 2000 for natural gas, and 1945 to present for crude oil.

Figure 6 - Global Primary Energy from Bio-Energy comparing Smil and Fernandes 1900 to 2008

Figure 7 - Global Primary Energy from coal comparing Krausmann, Anonymous Source, and BP Statistical Review 1900 to 2008

Figure 8 - Global Primary Energy from Natural Gas comparing Krausmann, Anonymous Source, and BP Statistical Review 1900 to 2008

Figure 9 - Global Primary Energy from Crude Oil comparing O&G Journal, IHS Energy, Anonymous Source, Krausmann, and BP Statistical Review 1930 to 2005
Sources of data
Anonymous Source - Book reference not available due to permanent library closure
BP Statistical Review - BP Statistical Review of World Energy 2011
Fernandes - Fernandes et al. 2007. Global Biofuel Use 1850 - 2000. Global Biogeochemical cycles. Vol. 21
IHS Energy - old petroconsultants database
Krausmann - Krausmann et al., 2009. Growth in material use, GDP and population during the 21st century. Ecological Economics. 68
Oil & Gas Journal - Oil & Gas Journal
Rembrandt Koppelaar is co-founder and former President of ASPO Netherlands (Association for the Study of Peak Oil and Gas Netherlands) from 2005 to 2010. He holds a BSc in economics from Wageningen University of Life Sciences. Currently he is towards a Research Master degree in environmental economics. His main research interests lie in the management of finite resources.
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.
Links:
[1] http://www.theoildrum.com/node/8936
[2] http://www.theoildrum.com/files/Primary_Energy_to_GDP_1830_2010_Feb15.xls
[3] http://www.bp.com/sectionbodycopy.do?categoryId=7500&contentId=7068481
[4] http://www.google.co.uk/url?sa=t&rct=j&q=Fernandes+et+al.+2007.+Global+Biofuel+Use+1850+-+2000.+Global+Biogeochemical+cycles.+Vol.+21&source=web&cd=1&ved=0CCgQFjAA&url=http%3A%2F%2Fwww.sage.wisc.edu%2Fpubs%2Farticles%2FM-Z%2FTrautmann%2FFernandesetalGBC07.pdf&ei=M387T_WkCpOz0QWfgbls&usg=AFQjCNEoIlcUIfWPWoiIRjJHkYEgyKQXTA&sig2=NLJPLUpEc7i1jRPWGBVgcA
[5] http://www.china-sds.org/kcxfzbg/addinfomanage/lwwk/data/Growth%20in%20global%20materials%20use,%20GDP%20and%20population%20during%20the%2020th%20century.pdf
[6] http://www.vaclavsmil.com/energy-transitions-history-requirements-prospects/
[7] http://www.theoildrum.com/special/about
[8] http://creativecommons.org/licenses/by-sa/3.0/us/