Baselight

European Energy Prices

@owid.energy_prices

Loading...
Loading...

About this Dataset

European Energy Prices

Wholesale day-ahead electricity price data for European countries.

Tables

European Wholesale Electricity Price Data

@owid.energy_prices.owid_energy_prices_annual_1
  • 140.07 KB
  • 338 rows
  • 91 columns
Loading...

CREATE TABLE owid_energy_prices_annual_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "annual_electricity_household_capacity_taxes_euro" FLOAT,
  "annual_electricity_household_environmental_taxes_euro" FLOAT,
  "annual_electricity_household_network_costs_euro" FLOAT,
  "annual_electricity_household_nuclear_taxes_euro" FLOAT,
  "annual_electricity_household_other_euro" FLOAT,
  "annual_electricity_household_renewable_taxes_euro" FLOAT,
  "annual_electricity_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "annual_electricity_household_total_price_including_taxes_euro" FLOAT,
  "annual_electricity_household_value_added_tax_vat_euro" FLOAT,
  "annual_electricity_non_household_capacity_taxes_euro" FLOAT,
  "annual_electricity_non_household_environmental_taxes_euro" FLOAT,
  "annual_electricity_non_household_network_costs_euro" FLOAT,
  "annual_electricity_non_household_nuclear_taxes_euro" FLOAT,
  "annual_electricity_non_household_other_euro" FLOAT,
  "annual_electricity_non_household_renewable_taxes_euro" FLOAT,
  "annual_electricity_non_household_taxes_fees_levies_and_a8a01c4b" FLOAT,
  "annual_electricity_non_household_total_price_including_e1960738" FLOAT,
  "annual_electricity_non_household_value_added_tax_vat_euro" FLOAT,
  "annual_electricity_household_capacity_taxes_allowances_euro" INTEGER,
  "annual_electricity_household_energy_and_supply_euro" FLOAT,
  "annual_electricity_household_environmental_taxes_allowance_euro" FLOAT,
  "annual_electricity_household_nuclear_taxes_allowance_euro" INTEGER,
  "annual_electricity_household_other_allowance_euro" FLOAT,
  "annual_electricity_household_renewable_taxes_allowance_euro" FLOAT,
  "annual_electricity_non_household_energy_and_supply_euro" FLOAT,
  "annual_gas_household_capacity_taxes_euro" FLOAT,
  "annual_gas_household_energy_and_supply_euro" FLOAT,
  "annual_gas_household_environmental_taxes_euro" FLOAT,
  "annual_gas_household_network_costs_euro" FLOAT,
  "annual_gas_household_other_euro" FLOAT,
  "annual_gas_household_renewable_taxes_euro" FLOAT,
  "annual_gas_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "annual_gas_household_total_price_including_taxes_euro" FLOAT,
  "annual_gas_household_value_added_tax_vat_euro" FLOAT,
  "annual_gas_non_household_capacity_taxes_euro" FLOAT,
  "annual_gas_non_household_energy_and_supply_euro" FLOAT,
  "annual_gas_non_household_environmental_taxes_euro" FLOAT,
  "annual_gas_non_household_network_costs_euro" FLOAT,
  "annual_gas_non_household_other_euro" FLOAT,
  "annual_gas_non_household_renewable_taxes_euro" FLOAT,
  "annual_gas_non_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "annual_gas_non_household_total_price_including_taxes_euro" FLOAT,
  "annual_gas_non_household_value_added_tax_vat_euro" FLOAT,
  "annual_electricity_household_taxes_fees_levies_and_cha_f469fd78" FLOAT,
  "annual_electricity_household_capacity_taxes_pps" FLOAT,
  "annual_electricity_household_environmental_taxes_pps" FLOAT,
  "annual_electricity_household_network_costs_pps" FLOAT,
  "annual_electricity_household_nuclear_taxes_pps" FLOAT,
  "annual_electricity_household_other_pps" FLOAT,
  "annual_electricity_household_renewable_taxes_pps" FLOAT,
  "annual_electricity_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "annual_electricity_household_total_price_including_taxes_pps" FLOAT,
  "annual_electricity_household_value_added_tax_vat_pps" FLOAT,
  "annual_electricity_non_household_capacity_taxes_pps" FLOAT,
  "annual_electricity_non_household_environmental_taxes_pps" FLOAT,
  "annual_electricity_non_household_network_costs_pps" FLOAT,
  "annual_electricity_non_household_nuclear_taxes_pps" FLOAT,
  "annual_electricity_non_household_other_pps" FLOAT,
  "annual_electricity_non_household_renewable_taxes_pps" FLOAT,
  "annual_electricity_non_household_taxes_fees_levies_and_3cca9027" FLOAT,
  "annual_electricity_non_household_total_price_including_b87131df" FLOAT,
  "annual_electricity_non_household_value_added_tax_vat_pps" FLOAT,
  "annual_electricity_household_capacity_taxes_allowances_pps" INTEGER,
  "annual_electricity_household_energy_and_supply_pps" FLOAT,
  "annual_electricity_household_environmental_taxes_allowance_pps" FLOAT,
  "annual_electricity_household_nuclear_taxes_allowance_pps" INTEGER,
  "annual_electricity_household_other_allowance_pps" FLOAT,
  "annual_electricity_household_renewable_taxes_allowance_pps" FLOAT,
  "annual_electricity_non_household_energy_and_supply_pps" FLOAT,
  "annual_gas_household_capacity_taxes_pps" FLOAT,
  "annual_gas_household_energy_and_supply_pps" FLOAT,
  "annual_gas_household_environmental_taxes_pps" FLOAT,
  "annual_gas_household_network_costs_pps" FLOAT,
  "annual_gas_household_other_pps" FLOAT,
  "annual_gas_household_renewable_taxes_pps" FLOAT,
  "annual_gas_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "annual_gas_household_total_price_including_taxes_pps" FLOAT,
  "annual_gas_household_value_added_tax_vat_pps" FLOAT,
  "annual_gas_non_household_capacity_taxes_pps" FLOAT,
  "annual_gas_non_household_energy_and_supply_pps" FLOAT,
  "annual_gas_non_household_environmental_taxes_pps" FLOAT,
  "annual_gas_non_household_network_costs_pps" FLOAT,
  "annual_gas_non_household_other_pps" FLOAT,
  "annual_gas_non_household_renewable_taxes_pps" FLOAT,
  "annual_gas_non_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "annual_gas_non_household_total_price_including_taxes_pps" FLOAT,
  "annual_gas_non_household_value_added_tax_vat_pps" FLOAT,
  "annual_electricity_household_taxes_fees_levies_and_cha_cc68075c" FLOAT,
  "annual_electricity_all_wholesale_euro" FLOAT
);

Energy Prices Annual 2

@owid.energy_prices.owid_energy_prices_annual_2
  • 147 KB
  • 337 rows
  • 91 columns
Loading...

CREATE TABLE owid_energy_prices_annual_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "annual_electricity_household_capacity_taxes_euro" FLOAT,
  "annual_electricity_household_capacity_taxes_allowances_euro" INTEGER,
  "annual_electricity_household_energy_and_supply_euro" FLOAT,
  "annual_electricity_household_environmental_taxes_euro" FLOAT,
  "annual_electricity_household_environmental_taxes_allowance_euro" FLOAT,
  "annual_electricity_household_network_costs_euro" FLOAT,
  "annual_electricity_household_nuclear_taxes_euro" FLOAT,
  "annual_electricity_household_nuclear_taxes_allowance_euro" INTEGER,
  "annual_electricity_household_other_euro" FLOAT,
  "annual_electricity_household_other_allowance_euro" FLOAT,
  "annual_electricity_household_renewable_taxes_euro" FLOAT,
  "annual_electricity_household_renewable_taxes_allowance_euro" FLOAT,
  "annual_electricity_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "annual_electricity_household_total_price_including_taxes_euro" FLOAT,
  "annual_electricity_household_value_added_tax_vat_euro" FLOAT,
  "annual_electricity_non_household_capacity_taxes_euro" FLOAT,
  "annual_electricity_non_household_energy_and_supply_euro" FLOAT,
  "annual_electricity_non_household_environmental_taxes_euro" FLOAT,
  "annual_electricity_non_household_network_costs_euro" FLOAT,
  "annual_electricity_non_household_nuclear_taxes_euro" FLOAT,
  "annual_electricity_non_household_other_euro" FLOAT,
  "annual_electricity_non_household_renewable_taxes_euro" FLOAT,
  "annual_electricity_non_household_taxes_fees_levies_and_a8a01c4b" FLOAT,
  "annual_electricity_non_household_total_price_including_e1960738" FLOAT,
  "annual_electricity_non_household_value_added_tax_vat_euro" FLOAT,
  "annual_gas_household_capacity_taxes_euro" FLOAT,
  "annual_gas_household_energy_and_supply_euro" FLOAT,
  "annual_gas_household_environmental_taxes_euro" FLOAT,
  "annual_gas_household_network_costs_euro" FLOAT,
  "annual_gas_household_other_euro" FLOAT,
  "annual_gas_household_renewable_taxes_euro" FLOAT,
  "annual_gas_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "annual_gas_household_total_price_including_taxes_euro" FLOAT,
  "annual_gas_household_value_added_tax_vat_euro" FLOAT,
  "annual_gas_non_household_capacity_taxes_euro" FLOAT,
  "annual_gas_non_household_energy_and_supply_euro" FLOAT,
  "annual_gas_non_household_environmental_taxes_euro" FLOAT,
  "annual_gas_non_household_network_costs_euro" FLOAT,
  "annual_gas_non_household_other_euro" FLOAT,
  "annual_gas_non_household_renewable_taxes_euro" FLOAT,
  "annual_gas_non_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "annual_gas_non_household_total_price_including_taxes_euro" FLOAT,
  "annual_gas_non_household_value_added_tax_vat_euro" FLOAT,
  "annual_electricity_household_taxes_fees_levies_and_cha_f469fd78" FLOAT,
  "annual_electricity_household_capacity_taxes_pps" FLOAT,
  "annual_electricity_household_capacity_taxes_allowances_pps" INTEGER,
  "annual_electricity_household_energy_and_supply_pps" FLOAT,
  "annual_electricity_household_environmental_taxes_pps" FLOAT,
  "annual_electricity_household_environmental_taxes_allowance_pps" FLOAT,
  "annual_electricity_household_network_costs_pps" FLOAT,
  "annual_electricity_household_nuclear_taxes_pps" FLOAT,
  "annual_electricity_household_nuclear_taxes_allowance_pps" INTEGER,
  "annual_electricity_household_other_pps" FLOAT,
  "annual_electricity_household_other_allowance_pps" FLOAT,
  "annual_electricity_household_renewable_taxes_pps" FLOAT,
  "annual_electricity_household_renewable_taxes_allowance_pps" FLOAT,
  "annual_electricity_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "annual_electricity_household_total_price_including_taxes_pps" FLOAT,
  "annual_electricity_household_value_added_tax_vat_pps" FLOAT,
  "annual_electricity_non_household_capacity_taxes_pps" FLOAT,
  "annual_electricity_non_household_energy_and_supply_pps" FLOAT,
  "annual_electricity_non_household_environmental_taxes_pps" FLOAT,
  "annual_electricity_non_household_network_costs_pps" FLOAT,
  "annual_electricity_non_household_nuclear_taxes_pps" FLOAT,
  "annual_electricity_non_household_other_pps" FLOAT,
  "annual_electricity_non_household_renewable_taxes_pps" FLOAT,
  "annual_electricity_non_household_taxes_fees_levies_and_3cca9027" FLOAT,
  "annual_electricity_non_household_total_price_including_b87131df" FLOAT,
  "annual_electricity_non_household_value_added_tax_vat_pps" FLOAT,
  "annual_gas_household_capacity_taxes_pps" FLOAT,
  "annual_gas_household_energy_and_supply_pps" FLOAT,
  "annual_gas_household_environmental_taxes_pps" FLOAT,
  "annual_gas_household_network_costs_pps" FLOAT,
  "annual_gas_household_other_pps" FLOAT,
  "annual_gas_household_renewable_taxes_pps" FLOAT,
  "annual_gas_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "annual_gas_household_total_price_including_taxes_pps" FLOAT,
  "annual_gas_household_value_added_tax_vat_pps" FLOAT,
  "annual_gas_non_household_capacity_taxes_pps" FLOAT,
  "annual_gas_non_household_energy_and_supply_pps" FLOAT,
  "annual_gas_non_household_environmental_taxes_pps" FLOAT,
  "annual_gas_non_household_network_costs_pps" FLOAT,
  "annual_gas_non_household_other_pps" FLOAT,
  "annual_gas_non_household_renewable_taxes_pps" FLOAT,
  "annual_gas_non_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "annual_gas_non_household_total_price_including_taxes_pps" FLOAT,
  "annual_gas_non_household_value_added_tax_vat_pps" FLOAT,
  "annual_electricity_household_taxes_fees_levies_and_cha_cc68075c" FLOAT,
  "annual_electricity_all_wholesale_euro" FLOAT
);

European Wholesale Electricity Price Data

@owid.energy_prices.owid_energy_prices_monthly_1
  • 19.9 KB
  • 3224 rows
  • 3 columns
Loading...

CREATE TABLE owid_energy_prices_monthly_1 (
  "country" VARCHAR,
  "date" VARCHAR,
  "monthly_electricity_all_wholesale_euro" FLOAT
);

Energy Prices Monthly 2

@owid.energy_prices.owid_energy_prices_monthly_2
  • 32.83 KB
  • 3565 rows
  • 5 columns
Loading...

CREATE TABLE owid_energy_prices_monthly_2 (
  "country" VARCHAR,
  "date" VARCHAR,
  "monthly_electricity_all_wholesale_euro" FLOAT,
  "ppi" FLOAT,
  "flag" VARCHAR
);

Share link

Anyone who has the link will be able to view this.