Energy Dataset Country-Wise (1900-2021)
Complete Energy dataset including several metrics for country wise comparison.
@kaggle.pranjalverma08_energy_dataset_countrywise_19002021
Table List
- 241 tables(25.35 MB)
- Afghanistan Energy Data
- Africa Energy Data
- Albania Energy Data
- Algeria Energy Data
- American Samoa Energy Data
- Angola Energy Data
- Antarctica Energy Data
- Antigua And Barbuda Energy Data
- Argentina Energy Data
- Armenia Energy Data
- Aruba Energy Data
- Asia Pacific Energy Data
- Australia Energy Data
- Austria Energy Data
- Azerbaijan Energy Data
- Bahamas Energy Data
- Bahrain Energy Data
- Bangladesh Energy Data
- Barbados Energy Data
- Belarus Energy Data
- Belgium Energy Data
- Belize Energy Data
- Benin Energy Data
- Bermuda Energy Data
- Bhutan Energy Data
- Bolivia Energy Data
- Bosnia And Herzegovina Energy Data
- Botswana Energy Data
- Brazil Energy Data
- British Virgin Islands Energy Data
- Brunei Energy Data
- Bulgaria Energy Data
- Burkina Faso Energy Data
- Burundi Energy Data
- Cambodia Energy Data
- Cameroon Energy Data
- Canada Energy Data
- Cape Verde Energy Data
- Cayman Islands Energy Data
- Central African Republic Energy Data
- Chad Energy Data
- Chile Energy Data
- China Energy Data
- Cis Energy Data
- Colombia Energy Data
- Comoros Energy Data
- Congo Energy Data
- Cook Islands Energy Data
- Costa Rica Energy Data
- Cote Divoire Energy Data
- Croatia Energy Data
- Cuba Energy Data
- Cyprus Energy Data
- Czechia Energy Data
- Czechoslovakia Energy Data
- Democratic Republic Of Congo Energy Data
- Denmark Energy Data
- Djibouti Energy Data
- Dominican Republic Energy Data
- Dominica Energy Data
- East Germany Energy Data
- Eastern Africa Energy Data
- Ecuador Energy Data
- Egypt Energy Data
- El Salvador Energy Data
- Equatorial Guinea Energy Data
- Eritrea Energy Data
- Estonia Energy Data
- Eswatini Energy Data
- Ethiopia Energy Data
- European Union 27 Energy Data
- Europe Energy Data
- Faeroe Islands Energy Data
- Falkland Islands Energy Data
- Fiji Energy Data
- Finland Energy Data
- France Energy Data
- French Guiana Energy Data
- French Polynesia Energy Data
- Gabon Energy Data
- Gambia Energy Data
- Georgia Energy Data
- Germany Energy Data
- Ghana Energy Data
- Greece Energy Data
- Greenland Energy Data
- Grenada Energy Data
- Guadeloupe Energy Data
- Guam Energy Data
- Guatemala Energy Data
- Guinea Bissau Energy Data
- Guinea Energy Data
- Guyana Energy Data
- Haiti Energy Data
- Hawaiian Trade Zone Energy Data
- Honduras Energy Data
- Hong Kong Energy Data
- Hungary Energy Data
- Iceland Energy Data
- India Energy Data
- Indonesia Energy Data
- Iran Energy Data
- Iraq Energy Data
- Ireland Energy Data
- Israel Energy Data
- Italy Energy Data
- Jamaica Energy Data
- Japan Energy Data
- Jordan Energy Data
- Kazakhstan Energy Data
- Kenya Energy Data
- Kiribati Energy Data
- Kosovo Energy Data
- Kuwait Energy Data
- Kyrgyzstan Energy Data
- Laos Energy Data
- Latvia Energy Data
- Lebanon Energy Data
- Lesotho Energy Data
- Liberia Energy Data
- Libya Energy Data
- Lithuania Energy Data
- Luxembourg Energy Data
- Macao Energy Data
- Madagascar Energy Data
- Malawi Energy Data
- Malaysia Energy Data
- Maldives Energy Data
- Mali Energy Data
- Malta Energy Data
- Martinique Energy Data
- Mauritania Energy Data
- Mauritius Energy Data
- Mexico Energy Data
- Micronesia Country Energy Data
- Middle Africa Energy Data
- Middle East Energy Data
- Moldova Energy Data
- Mongolia Energy Data
- Montenegro Energy Data
- Montserrat Energy Data
- Morocco Energy Data
- Mozambique Energy Data
- Myanmar Energy Data
- Namibia Energy Data
- Nauru Energy Data
- Nepal Energy Data
- Netherlands Antilles Energy Data
- Netherlands Energy Data
- New Caledonia Energy Data
- New Zealand Energy Data
- Nicaragua Energy Data
- Nigeria Energy Data
- Niger Energy Data
- Niue Energy Data
- Non Oecd Energy Data
- North Korea Energy Data
- North Macedonia Energy Data
- Northern Mariana Islands Energy Data
- Norway Energy Data
- Oecd Energy Data
- Oman Energy Data
- Pakistan Energy Data
- Palestine Energy Data
- Panama Energy Data
- Papua New Guinea Energy Data
- Paraguay Energy Data
- Peru Energy Data
- Philippines Energy Data
- Poland Energy Data
- Portugal Energy Data
- Puerto Rico Energy Data
- Qatar Energy Data
- Reunion Energy Data
- Romania Energy Data
- Russia Energy Data
- Rwanda Energy Data
- Saint Helena Energy Data
- Saint Kitts And Nevis Energy Data
- Saint Lucia Energy Data
- Saint Pierre And Miquelon Energy Data
- Saint Vincent And The Grenadines Energy Data
- Samoa Energy Data
- Sao Tome And Principe Energy Data
- Saudi Arabia Energy Data
- Senegal Energy Data
- Serbia And Montenegro Energy Data
- Serbia Energy Data
- Seychelles Energy Data
- Sierra Leone Energy Data
- Singapore Energy Data
- Slovakia Energy Data
- Slovenia Energy Data
- Solomon Islands Energy Data
- Somalia Energy Data
- South Africa Energy Data
- South Korea Energy Data
- South Sudan Energy Data
- Spain Energy Data
- Sri Lanka Energy Data
- Sudan Energy Data
- Suriname Energy Data
- Sweden Energy Data
- Switzerland Energy Data
- Syria Energy Data
- Taiwan Energy Data
- Tajikistan Energy Data
- Tanzania Energy Data
- Thailand Energy Data
- Timor Energy Data
- Togo Energy Data
- Tonga Energy Data
- Trinidad And Tobago Energy Data
- Tunisia Energy Data
- Turkey Energy Data
- Turkmenistan Energy Data
- Turks And Caicos Islands Energy Data
- Tuvalu Energy Data
- U S Pacific Islands Energy Data
- U S Territories Energy Data
- Uganda Energy Data
- Ukraine Energy Data
- United Arab Emirates Energy Data
- United Kingdom Energy Data
- United States Virgin Islands Energy Data
- United States Energy Data
- Uruguay Energy Data
- Ussr Energy Data
- Uzbekistan Energy Data
- Vanuatu Energy Data
- Venezuela Energy Data
- Vietnam Energy Data
- Wake Island Energy Data
- West Germany Energy Data
- Western Africa Energy Data
- Western Sahara Energy Data
- World Energy Data
- Yemen Energy Data
- Yugoslavia Energy Data
- Zambia Energy Data
- Zimbabwe Energy Data
Africa Energy Data
@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.africa_energy_data
- 139.97 KB
- 121 rows
- 128 columns
- Only the first 100 columns are shown
iso_codeIso Code | countryCountry | yearYear | coal_prod_change_pctCoal Prod Change Pct | coal_prod_change_twhCoal Prod Change Twh | gas_prod_change_pctGas Prod Change Pct | gas_prod_change_twhGas Prod Change Twh | oil_prod_change_pctOil Prod Change Pct | oil_prod_change_twhOil Prod Change Twh | energy_cons_change_pctEnergy Cons Change Pct | energy_cons_change_twhEnergy Cons Change Twh | biofuel_share_elecBiofuel Share Elec | biofuel_elec_per_capitaBiofuel Elec Per Capita | biofuel_cons_change_pctBiofuel Cons Change Pct | biofuel_share_energyBiofuel Share Energy | biofuel_cons_change_twhBiofuel Cons Change Twh | biofuel_consumptionBiofuel Consumption | biofuel_cons_per_capitaBiofuel Cons Per Capita | carbon_intensity_elecCarbon Intensity Elec | coal_share_elecCoal Share Elec | coal_cons_change_pctCoal Cons Change Pct | coal_share_energyCoal Share Energy | coal_cons_change_twhCoal Cons Change Twh | coal_consumptionCoal Consumption | coal_elec_per_capitaCoal Elec Per Capita | coal_cons_per_capitaCoal Cons Per Capita | coal_productionCoal Production | coal_prod_per_capitaCoal Prod Per Capita | electricity_demandElectricity Demand | biofuel_electricityBiofuel Electricity | coal_electricityCoal Electricity | fossil_electricityFossil Electricity | gas_electricityGas Electricity | hydro_electricityHydro Electricity | nuclear_electricityNuclear Electricity | oil_electricityOil Electricity | other_renewable_exc_biofuel_electricityOther Renewable Exc Biofuel Electricity | other_renewable_electricityOther Renewable Electricity | renewables_electricityRenewables Electricity | solar_electricitySolar Electricity | wind_electricityWind Electricity | electricity_generationElectricity Generation | greenhouse_gas_emissionsGreenhouse Gas Emissions | energy_per_gdpEnergy Per Gdp | energy_per_capitaEnergy Per Capita | fossil_cons_change_pctFossil Cons Change Pct | fossil_share_energyFossil Share Energy | fossil_cons_change_twhFossil Cons Change Twh | fossil_fuel_consumptionFossil Fuel Consumption | fossil_energy_per_capitaFossil Energy Per Capita | fossil_cons_per_capitaFossil Cons Per Capita | fossil_share_elecFossil Share Elec | gdpGdp | gas_share_elecGas Share Elec | gas_cons_change_pctGas Cons Change Pct | gas_share_energyGas Share Energy | gas_cons_change_twhGas Cons Change Twh | gas_consumptionGas Consumption | gas_elec_per_capitaGas Elec Per Capita | gas_energy_per_capitaGas Energy Per Capita | gas_productionGas Production | gas_prod_per_capitaGas Prod Per Capita | hydro_share_elecHydro Share Elec | hydro_cons_change_pctHydro Cons Change Pct | hydro_share_energyHydro Share Energy | hydro_cons_change_twhHydro Cons Change Twh | hydro_consumptionHydro Consumption | hydro_elec_per_capitaHydro Elec Per Capita | hydro_energy_per_capitaHydro Energy Per Capita | low_carbon_share_elecLow Carbon Share Elec | low_carbon_electricityLow Carbon Electricity | low_carbon_elec_per_capitaLow Carbon Elec Per Capita | low_carbon_cons_change_pctLow Carbon Cons Change Pct | low_carbon_share_energyLow Carbon Share Energy | low_carbon_cons_change_twhLow Carbon Cons Change Twh | low_carbon_consumptionLow Carbon Consumption | low_carbon_energy_per_capitaLow Carbon Energy Per Capita | net_elec_imports_share_demandNet Elec Imports Share Demand | net_elec_importsNet Elec Imports | nuclear_share_elecNuclear Share Elec | nuclear_cons_change_pctNuclear Cons Change Pct | nuclear_share_energyNuclear Share Energy | nuclear_cons_change_twhNuclear Cons Change Twh | nuclear_consumptionNuclear Consumption | nuclear_elec_per_capitaNuclear Elec Per Capita | nuclear_energy_per_capitaNuclear Energy Per Capita | oil_share_elecOil Share Elec | oil_cons_change_pctOil Cons Change Pct | oil_share_energyOil Share Energy | oil_cons_change_twhOil Cons Change Twh | oil_consumptionOil Consumption | oil_elec_per_capitaOil Elec Per Capita | oil_energy_per_capitaOil Energy Per Capita | oil_productionOil Production | oil_prod_per_capitaOil Prod Per Capita | other_renewables_elec_per_capita_exc_biofuelOther Renewables Elec Per Capita Exc Biofuel | other_renewables_elec_per_capitaOther Renewables Elec Per Capita | other_renewables_cons_change_pctOther Renewables Cons Change Pct | other_renewables_share_energyOther Renewables Share Energy | other_renewables_cons_change_twhOther Renewables Cons Change Twh | other_renewable_consumptionOther Renewable Consumption | other_renewables_share_elec_exc_biofuelOther Renewables Share Elec Exc Biofuel | other_renewables_share_elecOther Renewables Share Elec | other_renewables_energy_per_capitaOther Renewables Energy Per Capita | per_capita_electricityPer Capita Electricity | populationPopulation | primary_energy_consumptionPrimary Energy Consumption | renewables_elec_per_capitaRenewables Elec Per Capita | renewables_share_elecRenewables Share Elec | renewables_cons_change_pctRenewables Cons Change Pct | renewables_share_energyRenewables Share Energy | renewables_cons_change_twhRenewables Cons Change Twh | renewables_consumptionRenewables Consumption | renewables_energy_per_capitaRenewables Energy Per Capita | solar_share_elecSolar Share Elec | solar_cons_change_pctSolar Cons Change Pct | solar_share_energySolar Share Energy | solar_cons_change_twhSolar Cons Change Twh | solar_consumptionSolar Consumption | solar_elec_per_capitaSolar Elec Per Capita | solar_energy_per_capitaSolar Energy Per Capita | wind_share_elecWind Share Elec | wind_cons_change_pctWind Cons Change Pct | wind_share_energyWind Share Energy | wind_cons_change_twhWind Cons Change Twh | wind_consumptionWind Consumption | wind_elec_per_capitaWind Elec Per Capita | wind_energy_per_capitaWind Energy Per Capita |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OWID_AFR | Africa | 1900 | 6.68 | 48.118 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| OWID_AFR | Africa | 1901 | 67.81 | 4.53 | 11.21 | 80.592 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| OWID_AFR | Africa | 1902 | 49.068 | 5.5 | 16.71 | 119.729 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| OWID_AFR | Africa | 1903 | 35.697 | 5.965 | 22.675 | 161.881 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| OWID_AFR | Africa | 1904 | 12.88 | 2.921 | 25.596 | 182.055 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| OWID_AFR | Africa | 1905 | 15.171 | 3.883 | 29.479 | 208.879 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| OWID_AFR | Africa | 1906 | 14.187 | 4.182 | 33.662 | 237.588 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| OWID_AFR | Africa | 1907 | 10.355 | 3.485 | 37.147 | 261.15 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| OWID_AFR | Africa | 1908 | 3.723 | 1.383 | 38.53 | 269.773 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| OWID_AFR | Africa | 1909 | 14.77 | 5.691 | 44.221 | 308.358 |
CREATE TABLE africa_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" DOUBLE,
"coal_prod_change_twh" DOUBLE,
"gas_prod_change_pct" DOUBLE,
"gas_prod_change_twh" DOUBLE,
"oil_prod_change_pct" DOUBLE,
"oil_prod_change_twh" DOUBLE,
"energy_cons_change_pct" DOUBLE,
"energy_cons_change_twh" DOUBLE,
"biofuel_share_elec" DOUBLE,
"biofuel_elec_per_capita" DOUBLE,
"biofuel_cons_change_pct" DOUBLE,
"biofuel_share_energy" DOUBLE,
"biofuel_cons_change_twh" DOUBLE,
"biofuel_consumption" DOUBLE,
"biofuel_cons_per_capita" DOUBLE,
"carbon_intensity_elec" DOUBLE,
"coal_share_elec" DOUBLE,
"coal_cons_change_pct" DOUBLE,
"coal_share_energy" DOUBLE,
"coal_cons_change_twh" DOUBLE,
"coal_consumption" DOUBLE,
"coal_elec_per_capita" DOUBLE,
"coal_cons_per_capita" DOUBLE,
"coal_production" DOUBLE,
"coal_prod_per_capita" DOUBLE,
"electricity_demand" DOUBLE,
"biofuel_electricity" DOUBLE,
"coal_electricity" DOUBLE,
"fossil_electricity" DOUBLE,
"gas_electricity" DOUBLE,
"hydro_electricity" DOUBLE,
"nuclear_electricity" DOUBLE,
"oil_electricity" DOUBLE,
"other_renewable_exc_biofuel_electricity" DOUBLE,
"other_renewable_electricity" DOUBLE,
"renewables_electricity" DOUBLE,
"solar_electricity" DOUBLE,
"wind_electricity" DOUBLE,
"electricity_generation" DOUBLE,
"greenhouse_gas_emissions" DOUBLE,
"energy_per_gdp" VARCHAR,
"energy_per_capita" DOUBLE,
"fossil_cons_change_pct" DOUBLE,
"fossil_share_energy" DOUBLE,
"fossil_cons_change_twh" DOUBLE,
"fossil_fuel_consumption" DOUBLE,
"fossil_energy_per_capita" DOUBLE,
"fossil_cons_per_capita" DOUBLE,
"fossil_share_elec" DOUBLE,
"gdp" VARCHAR,
"gas_share_elec" DOUBLE,
"gas_cons_change_pct" DOUBLE,
"gas_share_energy" DOUBLE,
"gas_cons_change_twh" DOUBLE,
"gas_consumption" DOUBLE,
"gas_elec_per_capita" DOUBLE,
"gas_energy_per_capita" DOUBLE,
"gas_production" DOUBLE,
"gas_prod_per_capita" DOUBLE,
"hydro_share_elec" DOUBLE,
"hydro_cons_change_pct" DOUBLE,
"hydro_share_energy" DOUBLE,
"hydro_cons_change_twh" DOUBLE,
"hydro_consumption" DOUBLE,
"hydro_elec_per_capita" DOUBLE,
"hydro_energy_per_capita" DOUBLE,
"low_carbon_share_elec" DOUBLE,
"low_carbon_electricity" DOUBLE,
"low_carbon_elec_per_capita" DOUBLE,
"low_carbon_cons_change_pct" DOUBLE,
"low_carbon_share_energy" DOUBLE,
"low_carbon_cons_change_twh" DOUBLE,
"low_carbon_consumption" DOUBLE,
"low_carbon_energy_per_capita" DOUBLE,
"net_elec_imports_share_demand" DOUBLE,
"net_elec_imports" DOUBLE,
"nuclear_share_elec" DOUBLE,
"nuclear_cons_change_pct" DOUBLE,
"nuclear_share_energy" DOUBLE,
"nuclear_cons_change_twh" DOUBLE,
"nuclear_consumption" DOUBLE,
"nuclear_elec_per_capita" DOUBLE,
"nuclear_energy_per_capita" DOUBLE,
"oil_share_elec" DOUBLE,
"oil_cons_change_pct" DOUBLE,
"oil_share_energy" DOUBLE,
"oil_cons_change_twh" DOUBLE,
"oil_consumption" DOUBLE,
"oil_elec_per_capita" DOUBLE,
"oil_energy_per_capita" DOUBLE,
"oil_production" DOUBLE,
"oil_prod_per_capita" DOUBLE,
"other_renewables_elec_per_capita_exc_biofuel" DOUBLE,
"other_renewables_elec_per_capita" DOUBLE,
"other_renewables_cons_change_pct" DOUBLE,
"other_renewables_share_energy" DOUBLE,
"other_renewables_cons_change_twh" DOUBLE
);