World Energy Consumption
Consumption of energy by different countries
@kaggle.pralabhpoudel_world_energy_consumption
Consumption of energy by different countries
@kaggle.pralabhpoudel_world_energy_consumption
Our complete Energy dataset is a collection of key metrics maintained by Our World in Data. It is updated regularly and includes data on energy consumption (primary energy, per capita, and growth rates), energy mix, electricity mix and other relevant metrics.
The CSV and XLSX files follow a format of 1 row per location and year. The JSON version is split by country, with an array of yearly records.
The variables represent all of our main data related to energy consumption, energy mix, electricity mix as well as other variables of potential interest.
We will continue to publish updated data on energy as it becomes available. Most metrics are published on an annual basis.
A full codebook is made available, with a description and source for each variable in the dataset.
The dataset is built upon a number of datasets and processing steps:
Additionally, to construct region aggregates and variables per capita and per GDP, we use the following datasets and processing steps:
electricity_share_energy (electricity as a share of primary energy) was added to the dataset.Europe (BP) corresponds to Europe as defined by BP.fossil_cons_per_capita has been renamed fossil_elec_per_capita for consistency, since it corresponds to electricity generation.greenhouse_gas_emissions).carbon_intensity_elec column was added back into the energy dataset.carbon_intensity_elec column was removed from the energy dataset (since no updated data was available).other_renewables_elec_per_capita_exc_biofuel, and other_renewables_share_elec_exc_biofuel).Europe (EI) corresponds to Europe as defined by the Energy Institute.population metric, which is included in the complete dataset.
gdp metric used in the calculation as part of the dataset.All visualizations, data, and code produced by Our World in Data are completely open access under the Creative Commons BY license. You have the permission to use, distribute, and reproduce these in any medium, provided the source and authors are credited.
The data produced by third parties and made available by Our World in Data is subject to the license terms from the original third-party authors. We will always indicate the original source of the data in our database, and you should always check the license of any such third-party data before use.
This data has been collected, aggregated, and documented by Hannah Ritchie, Pablo Rosado, Edouard Mathieu, Max Roser.
Our World in Data makes data and research on the world’s largest problems understandable and accessible. Read more about our mission.
If you are using this dataset, please cite both Our World in Data and the underlying data source(s).
Please follow the guidelines in our FAQ on how to cite our work.
CREATE TABLE world_energy_consumption (
"country" VARCHAR,
"year" BIGINT,
"iso_code" VARCHAR,
"population" DOUBLE,
"gdp" DOUBLE,
"biofuel_cons_change_pct" DOUBLE,
"biofuel_cons_change_twh" DOUBLE,
"biofuel_cons_per_capita" DOUBLE,
"biofuel_consumption" DOUBLE,
"biofuel_elec_per_capita" DOUBLE,
"biofuel_electricity" DOUBLE,
"biofuel_share_elec" DOUBLE,
"biofuel_share_energy" DOUBLE,
"carbon_intensity_elec" DOUBLE,
"coal_cons_change_pct" DOUBLE,
"coal_cons_change_twh" DOUBLE,
"coal_cons_per_capita" DOUBLE,
"coal_consumption" DOUBLE,
"coal_elec_per_capita" DOUBLE,
"coal_electricity" DOUBLE,
"coal_prod_change_pct" DOUBLE,
"coal_prod_change_twh" DOUBLE,
"coal_prod_per_capita" DOUBLE,
"coal_production" DOUBLE,
"coal_share_elec" DOUBLE,
"coal_share_energy" DOUBLE,
"electricity_demand" DOUBLE,
"electricity_generation" DOUBLE,
"electricity_share_energy" DOUBLE,
"energy_cons_change_pct" DOUBLE,
"energy_cons_change_twh" DOUBLE,
"energy_per_capita" DOUBLE,
"energy_per_gdp" DOUBLE,
"fossil_cons_change_pct" DOUBLE,
"fossil_cons_change_twh" DOUBLE,
"fossil_elec_per_capita" DOUBLE,
"fossil_electricity" DOUBLE,
"fossil_energy_per_capita" DOUBLE,
"fossil_fuel_consumption" DOUBLE,
"fossil_share_elec" DOUBLE,
"fossil_share_energy" DOUBLE,
"gas_cons_change_pct" DOUBLE,
"gas_cons_change_twh" DOUBLE,
"gas_consumption" DOUBLE,
"gas_elec_per_capita" DOUBLE,
"gas_electricity" DOUBLE,
"gas_energy_per_capita" DOUBLE,
"gas_prod_change_pct" DOUBLE,
"gas_prod_change_twh" DOUBLE,
"gas_prod_per_capita" DOUBLE,
"gas_production" DOUBLE,
"gas_share_elec" DOUBLE,
"gas_share_energy" DOUBLE,
"greenhouse_gas_emissions" DOUBLE,
"hydro_cons_change_pct" DOUBLE,
"hydro_cons_change_twh" DOUBLE,
"hydro_consumption" DOUBLE,
"hydro_elec_per_capita" DOUBLE,
"hydro_electricity" DOUBLE,
"hydro_energy_per_capita" DOUBLE,
"hydro_share_elec" DOUBLE,
"hydro_share_energy" DOUBLE,
"low_carbon_cons_change_pct" DOUBLE,
"low_carbon_cons_change_twh" DOUBLE,
"low_carbon_consumption" DOUBLE,
"low_carbon_elec_per_capita" DOUBLE,
"low_carbon_electricity" DOUBLE,
"low_carbon_energy_per_capita" DOUBLE,
"low_carbon_share_elec" DOUBLE,
"low_carbon_share_energy" DOUBLE,
"net_elec_imports" DOUBLE,
"net_elec_imports_share_demand" DOUBLE,
"nuclear_cons_change_pct" DOUBLE,
"nuclear_cons_change_twh" DOUBLE,
"nuclear_consumption" DOUBLE,
"nuclear_elec_per_capita" DOUBLE,
"nuclear_electricity" DOUBLE,
"nuclear_energy_per_capita" DOUBLE,
"nuclear_share_elec" DOUBLE,
"nuclear_share_energy" DOUBLE,
"oil_cons_change_pct" DOUBLE,
"oil_cons_change_twh" DOUBLE,
"oil_consumption" DOUBLE,
"oil_elec_per_capita" DOUBLE,
"oil_electricity" DOUBLE,
"oil_energy_per_capita" DOUBLE,
"oil_prod_change_pct" DOUBLE,
"oil_prod_change_twh" DOUBLE,
"oil_prod_per_capita" DOUBLE,
"oil_production" DOUBLE,
"oil_share_elec" DOUBLE,
"oil_share_energy" DOUBLE,
"other_renewable_consumption" DOUBLE,
"other_renewable_electricity" DOUBLE,
"other_renewable_exc_biofuel_electricity" DOUBLE,
"other_renewables_cons_change_pct" DOUBLE,
"other_renewables_cons_change_twh" DOUBLE,
"other_renewables_elec_per_capita" DOUBLE,
"other_renewables_elec_per_capita_exc_biofuel" DOUBLE,
"other_renewables_energy_per_capita" DOUBLE
);Anyone who has the link will be able to view this.