Sources of data used in the Energy Export Databrowser
BP Statistical Review 2017
The BP Statistical Review is British Petroleum's best effort to review world energy trends. Produced once a year, the Excel workbook contains regional consumption and production data for Oil, Natural Gas, Coal, Nuclear and Hydroelectric energy resources. Data from several worksheets in the Statistical Review are used as input to the Energy Export Databrowser. The data used by the Databrowser are unaltered except for minor cleanup as described the section on "ISO Standardized Data" below. It is assumed that BP has made every effort to harmonize data from different sources and ensure that values within this workbook are consistent and comparable between nations.
Definitions
All definitions are taken verbatim from the BP Statistical Review worksheets.
- Coal Production
- Commercial solid fuels only, i.e. bituminous coal and anthracite (hard coal), and lignite and brown (sub-bituminous) coal.
- Coal Consumption
- Commercial solid fuels only, i.e. bituminous coal and anthracite (hard coal), and lignite and brown (sub-bituminous) coal.
- Oil Production
- Includes crude oil, shale oil, oil sands and NGLs (the liquid content of natural gas where this is recovered separately).
- Oil Consumption
- Inland demand plus international aviation and marine bunkers and refinery fuel and loss. Consumption of fuel ethanol and biodiesel is also included.
- Natural Gas Production
- Excludes gas flared or recycled. As data are derived from tonnes oil equivalent using average conversion factors, they do not necessarily equate with gas volumes expressed in specific national terms.
- Natural Gas Consumption
- Differences between consumption figures and production statistics are due to variations in stocks at storage facilities and liquefaction plants, together with unavoidable disparities in the definition, measurement or conversion of gas supply and demand data. As data are derived from tonnes oil equivalent using average conversion factors, they do not necessarily equate with gas volumes expressed in specific national terms.
- Hydro Production
- Based on gross primary hydroelectric generation and not accounting for cross-border electricity supply.
- Hydro Consumption
- Based on gross primary hydroelectric generation and not accounting for cross-border electricity supply.
- Nuclear Production
- Based on gross generation and not accounting for cross-border electricity supply.
- Nuclear Consumption
- Based on gross generation and not accounting for cross-border electricity supply.
Notes
The "Definitions" worksheet of the Statistical review contains the following note:
The primary energy values of both nuclear and hydroelectric power generation have been derived by calculating the equivalent amount of fossil fuel required to generate the same volume of electricity in a thermal power station, assuming a conversion efficiency of 38% (the average for OECD thermal power generation).
This means that the data in the nuclear and hydroelectric worksheets in units of 'mtoe' (milltion tonnes of oil equivalent) are scaled up by a factor of 1/0.38 (=2.63). When fossil fuels are used primarily for generation of electricty, this scaling can be useful. It allows the amount of electrical energy available to consumers from nuclear and hydro power plants to be compared with the amount available to consumers from coal/oil/gas fired power plants.
To see the unscaled energy produced by nuclear and hydro power plants you must choose units of 'twh' (Terawatt-hours) or 'J' (Exajoules). Choosing units of Exajoules allows one to compare energy generated from nuclear or hydro with the 'embedded energy' in fossil fuels. From the standpoint of energy avaiable for human use, without assumptions as to how it will be used, Exajoules is a more appropriate unit.
Original Data
The original 2017 Statistical Review may be obtained from British Petroleum:
Copies of the current and older versions are archived on this site:
BP_2016.xlsx BP_2015.xlsx BP_2014.xlsx BP_2013.xlsx BP_2012.xlsx BP_2011.xls BP_2010.xls BP_2009.xls BP_2008.xls BP_2007.xls BP_2006.xls BP_2005.xls BP_2004.xls BP_2003.xls BP_2002.xls
ISO Standardized Data
For use in the Energy Export Databrowser, these data were converted from Excel spreadsheets with English language country names into ASCII CSV files with ISO 3166-1 two-digit country codes. These standardized data files are offered to the community in the interest of promoting internationalization and further investigation of the data.
Additional cleanup of the Excel worksheets included:
- conversion of numeric values stored as characters into floating point values
- conversion of '^' and '-' markers into floating point 0.0
- conversion of 'n/a' missing values markers to 'na'
- conversion of regions with no country equivalent into unique codes of the form: "BP_~~~" (e.g.Total North America = BP_TNA)
The ISO standardized files are:
- BP_2017_coal_consumption_mtoe.csv
- BP_2017_coal_production_mtoe.csv
- BP_2017_gas_consumption_ft3.csv
- BP_2017_gas_consumption_m3.csv
- BP_2017_gas_consumption_mtoe.csv
- BP_2017_gas_production_ft3.csv
- BP_2017_gas_production_m3.csv
- BP_2017_gas_production_mtoe.csv
- BP_2017_hydro_consumption_mtoe.csv
- BP_2017_hydro_consumption_twh.csv
- BP_2017_nuclear_consumption_mtoe.csv
- BP_2017_nuclear_consumption_twh.csv
- BP_2017_oil_consumption_bbl.csv
- BP_2017_oil_consumption_mtoe.csv
- BP_2017_oil_production_bbl.csv
- BP_2017_oil_production_mtoe.csv
- BP_2017_other_renewables_consumption_mtoe.csv
- BP_2017_other_renewables_consumption_twh.csv
- BP_2017_solar_consumption_mtoe.csv
- BP_2017_solar_consumption_twh.csv
- BP_2017_wind_consumption_mtoe.csv
- BP_2017_wind_consumption_twh.csv