Renewable Energy
Global renewable energy by country and US states - Changes from 2015 to 2022
@kaggle.joebeachcapital_renewable_energy
Global renewable energy by country and US states - Changes from 2015 to 2022
@kaggle.joebeachcapital_renewable_energy
Over 30% of the world’s electricity is now generated from renewable sources – and it’s increasing. (source)
Renewable sources include solar power, wind, hydro-electric, geothermal and – controversially – bioenergy (aka biomass or biofuel – mostly burning of wood pellets).
Why is it controversial? Because of differing definitions of ‘renewable’. In the technical definition, ‘renewable’ is any energy collected from resources that are naturally replenished on a human timescale. In the popular definition ‘renewable’ is equated with ‘sustainable’ and ‘eco-friendly’. Most renewables are sustainable, but some are not. A technically renewable source like biomass (wood pellets), for example, emits air pollution when incinerated and requires large amounts of water and land to produce.
Energy vs Electricity Generation When perusing stats on this topic, note the difference between renewable energy production and renewable electricity production. Energy production & consumption refers to a country’s total economic activity: creation of fuels, powering of industry, transportation and the generation of electricity (a subset of ‘energy’).
CREATE TABLE renewable_electricity_by_country_2015_data (
"country" VARCHAR,
"renewables_as_of_total_electricity_generation" VARCHAR -- Renewables As % Of Total Electricity Generation,
"electricity_generation_all_sources_gwh" BIGINT -- Electricity Generation, All Sources (GWh),
"source" VARCHAR,
"url" VARCHAR
);CREATE TABLE renewable_electricity_by_country_electricity_prices_wo_2577a520 (
"country" VARCHAR,
"household_price_kwh" DOUBLE -- Household Price $/kWh,
"business_price_kwh" VARCHAR -- Business Price $/kWh,
"average_price_kwh" DOUBLE -- Average Price $/kWh,
"source_2022_data" VARCHAR -- Source (2022 Data):
);CREATE TABLE renewable_electricity_by_country_renewable_electricity_7736322b (
"country" VARCHAR,
"all_renewables_2020_or_latest_year" VARCHAR,
"excluding_hydropower" VARCHAR,
"all_renewables_2015" VARCHAR,
"n__difference_2015_vs_2020" VARCHAR -- % Difference 2015 Vs 2020,
"all_electricity_generation_gwh" DOUBLE,
"all_renewables_gwh" DOUBLE,
"non_hydro_renewables_gwh" DOUBLE,
"notes" VARCHAR,
"source" VARCHAR
);CREATE TABLE renewable_electricity_by_country_us_states_renewable_e_9bf5c5f9 (
"us_state" VARCHAR,
"renewables" DOUBLE,
"exc_hydro" DOUBLE -- Exc. Hydro,
"nuclear" DOUBLE -- NUCLEAR (%),
"coal" DOUBLE -- COAL (%),
"natural_gas" DOUBLE -- NATURAL GAS (%),
"petroleum" DOUBLE -- PETROLEUM (%),
"hydro" DOUBLE -- HYDRO (%),
"geothermal" DOUBLE -- GEOTHERMAL (%),
"solar_pv" DOUBLE -- SOLAR - PV (%),
"wind" DOUBLE -- WIND (%),
"biomass_and_other" DOUBLE -- BIOMASS AND OTHER (%),
"source" VARCHAR
);Anyone who has the link will be able to view this.