Baselight

Energy Statistics, Prices Of Natural Gas And Electricity

@owid.gas_and_electricity_prices

Loading...
Loading...

About this Dataset

Energy Statistics, Prices Of Natural Gas And Electricity

Tables

Gas And Electricity Price Components In Europe

@owid.gas_and_electricity_prices.owid_gas_and_electricity_price_components_euro_flat_1
  • 67.88 KB
  • 278 rows
  • 46 columns
Loading...

CREATE TABLE owid_gas_and_electricity_price_components_euro_flat_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "electricity_household_capacity_taxes_euro" FLOAT,
  "electricity_household_environmental_taxes_euro" FLOAT,
  "electricity_household_network_costs_euro" FLOAT,
  "electricity_household_nuclear_taxes_euro" FLOAT,
  "electricity_household_other_euro" FLOAT,
  "electricity_household_renewable_taxes_euro" FLOAT,
  "electricity_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "electricity_household_total_price_including_taxes_euro" FLOAT,
  "electricity_household_value_added_tax_vat_euro" FLOAT,
  "electricity_non_household_capacity_taxes_euro" FLOAT,
  "electricity_non_household_environmental_taxes_euro" FLOAT,
  "electricity_non_household_network_costs_euro" FLOAT,
  "electricity_non_household_nuclear_taxes_euro" FLOAT,
  "electricity_non_household_other_euro" FLOAT,
  "electricity_non_household_renewable_taxes_euro" FLOAT,
  "electricity_non_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "electricity_non_household_total_price_including_taxes_euro" FLOAT,
  "electricity_non_household_value_added_tax_vat_euro" FLOAT,
  "electricity_household_capacity_taxes_allowances_euro" INTEGER,
  "electricity_household_energy_and_supply_euro" FLOAT,
  "electricity_household_environmental_taxes_allowance_euro" FLOAT,
  "electricity_household_nuclear_taxes_allowance_euro" INTEGER,
  "electricity_household_other_allowance_euro" FLOAT,
  "electricity_household_renewable_taxes_allowance_euro" FLOAT,
  "electricity_non_household_energy_and_supply_euro" FLOAT,
  "gas_household_capacity_taxes_euro" FLOAT,
  "gas_household_energy_and_supply_euro" FLOAT,
  "gas_household_environmental_taxes_euro" FLOAT,
  "gas_household_network_costs_euro" FLOAT,
  "gas_household_other_euro" FLOAT,
  "gas_household_renewable_taxes_euro" FLOAT,
  "gas_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "gas_household_total_price_including_taxes_euro" FLOAT,
  "gas_household_value_added_tax_vat_euro" FLOAT,
  "gas_non_household_capacity_taxes_euro" FLOAT,
  "gas_non_household_energy_and_supply_euro" FLOAT,
  "gas_non_household_environmental_taxes_euro" FLOAT,
  "gas_non_household_network_costs_euro" FLOAT,
  "gas_non_household_other_euro" FLOAT,
  "gas_non_household_renewable_taxes_euro" FLOAT,
  "gas_non_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "gas_non_household_total_price_including_taxes_euro" FLOAT,
  "gas_non_household_value_added_tax_vat_euro" FLOAT,
  "electricity_household_taxes_fees_levies_and_charges_al_37751a02" FLOAT
);

Gas And Electricity Price Components In Europe

@owid.gas_and_electricity_prices.owid_gas_and_electricity_price_components_euro_flat_2
  • 70.56 KB
  • 239 rows
  • 46 columns
Loading...

CREATE TABLE owid_gas_and_electricity_price_components_euro_flat_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "electricity_household_capacity_taxes_euro" FLOAT,
  "electricity_household_capacity_taxes_allowances_euro" INTEGER,
  "electricity_household_energy_and_supply_euro" FLOAT,
  "electricity_household_environmental_taxes_euro" FLOAT,
  "electricity_household_environmental_taxes_allowance_euro" FLOAT,
  "electricity_household_network_costs_euro" FLOAT,
  "electricity_household_nuclear_taxes_euro" FLOAT,
  "electricity_household_nuclear_taxes_allowance_euro" INTEGER,
  "electricity_household_other_euro" FLOAT,
  "electricity_household_other_allowance_euro" FLOAT,
  "electricity_household_renewable_taxes_euro" FLOAT,
  "electricity_household_renewable_taxes_allowance_euro" FLOAT,
  "electricity_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "electricity_household_total_price_including_taxes_euro" FLOAT,
  "electricity_household_value_added_tax_vat_euro" FLOAT,
  "electricity_non_household_capacity_taxes_euro" FLOAT,
  "electricity_non_household_energy_and_supply_euro" FLOAT,
  "electricity_non_household_environmental_taxes_euro" FLOAT,
  "electricity_non_household_network_costs_euro" FLOAT,
  "electricity_non_household_nuclear_taxes_euro" FLOAT,
  "electricity_non_household_other_euro" FLOAT,
  "electricity_non_household_renewable_taxes_euro" FLOAT,
  "electricity_non_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "electricity_non_household_total_price_including_taxes_euro" FLOAT,
  "electricity_non_household_value_added_tax_vat_euro" FLOAT,
  "gas_household_capacity_taxes_euro" FLOAT,
  "gas_household_energy_and_supply_euro" FLOAT,
  "gas_household_environmental_taxes_euro" FLOAT,
  "gas_household_network_costs_euro" FLOAT,
  "gas_household_other_euro" FLOAT,
  "gas_household_renewable_taxes_euro" FLOAT,
  "gas_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "gas_household_total_price_including_taxes_euro" FLOAT,
  "gas_household_value_added_tax_vat_euro" FLOAT,
  "gas_non_household_capacity_taxes_euro" FLOAT,
  "gas_non_household_energy_and_supply_euro" FLOAT,
  "gas_non_household_environmental_taxes_euro" FLOAT,
  "gas_non_household_network_costs_euro" FLOAT,
  "gas_non_household_other_euro" FLOAT,
  "gas_non_household_renewable_taxes_euro" FLOAT,
  "gas_non_household_taxes_fees_levies_and_charges_euro" FLOAT,
  "gas_non_household_total_price_including_taxes_euro" FLOAT,
  "gas_non_household_value_added_tax_vat_euro" FLOAT,
  "electricity_household_taxes_fees_levies_and_charges_al_37751a02" FLOAT
);

Gas And Electricity Price Components In Europe (PPS)

@owid.gas_and_electricity_prices.owid_gas_and_electricity_price_components_pps_flat_1
  • 66.6 KB
  • 278 rows
  • 46 columns
Loading...

CREATE TABLE owid_gas_and_electricity_price_components_pps_flat_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "electricity_household_capacity_taxes_pps" FLOAT,
  "electricity_household_environmental_taxes_pps" FLOAT,
  "electricity_household_network_costs_pps" FLOAT,
  "electricity_household_nuclear_taxes_pps" FLOAT,
  "electricity_household_other_pps" FLOAT,
  "electricity_household_renewable_taxes_pps" FLOAT,
  "electricity_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "electricity_household_total_price_including_taxes_pps" FLOAT,
  "electricity_household_value_added_tax_vat_pps" FLOAT,
  "electricity_non_household_capacity_taxes_pps" FLOAT,
  "electricity_non_household_environmental_taxes_pps" FLOAT,
  "electricity_non_household_network_costs_pps" FLOAT,
  "electricity_non_household_nuclear_taxes_pps" FLOAT,
  "electricity_non_household_other_pps" FLOAT,
  "electricity_non_household_renewable_taxes_pps" FLOAT,
  "electricity_non_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "electricity_non_household_total_price_including_taxes_pps" FLOAT,
  "electricity_non_household_value_added_tax_vat_pps" FLOAT,
  "electricity_household_capacity_taxes_allowances_pps" INTEGER,
  "electricity_household_energy_and_supply_pps" FLOAT,
  "electricity_household_environmental_taxes_allowance_pps" FLOAT,
  "electricity_household_nuclear_taxes_allowance_pps" INTEGER,
  "electricity_household_other_allowance_pps" FLOAT,
  "electricity_household_renewable_taxes_allowance_pps" FLOAT,
  "electricity_non_household_energy_and_supply_pps" FLOAT,
  "gas_household_capacity_taxes_pps" FLOAT,
  "gas_household_energy_and_supply_pps" FLOAT,
  "gas_household_environmental_taxes_pps" FLOAT,
  "gas_household_network_costs_pps" FLOAT,
  "gas_household_other_pps" FLOAT,
  "gas_household_renewable_taxes_pps" FLOAT,
  "gas_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "gas_household_total_price_including_taxes_pps" FLOAT,
  "gas_household_value_added_tax_vat_pps" FLOAT,
  "gas_non_household_capacity_taxes_pps" FLOAT,
  "gas_non_household_energy_and_supply_pps" FLOAT,
  "gas_non_household_environmental_taxes_pps" FLOAT,
  "gas_non_household_network_costs_pps" FLOAT,
  "gas_non_household_other_pps" FLOAT,
  "gas_non_household_renewable_taxes_pps" FLOAT,
  "gas_non_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "gas_non_household_total_price_including_taxes_pps" FLOAT,
  "gas_non_household_value_added_tax_vat_pps" FLOAT,
  "electricity_household_taxes_fees_levies_and_charges_al_8da3a87c" FLOAT
);

Gas And Electricity Price Components In Europe (PPS)

@owid.gas_and_electricity_prices.owid_gas_and_electricity_price_components_pps_flat_2
  • 70.04 KB
  • 239 rows
  • 46 columns
Loading...

CREATE TABLE owid_gas_and_electricity_price_components_pps_flat_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "electricity_household_capacity_taxes_pps" FLOAT,
  "electricity_household_capacity_taxes_allowances_pps" INTEGER,
  "electricity_household_energy_and_supply_pps" FLOAT,
  "electricity_household_environmental_taxes_pps" FLOAT,
  "electricity_household_environmental_taxes_allowance_pps" FLOAT,
  "electricity_household_network_costs_pps" FLOAT,
  "electricity_household_nuclear_taxes_pps" FLOAT,
  "electricity_household_nuclear_taxes_allowance_pps" INTEGER,
  "electricity_household_other_pps" FLOAT,
  "electricity_household_other_allowance_pps" FLOAT,
  "electricity_household_renewable_taxes_pps" FLOAT,
  "electricity_household_renewable_taxes_allowance_pps" FLOAT,
  "electricity_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "electricity_household_total_price_including_taxes_pps" FLOAT,
  "electricity_household_value_added_tax_vat_pps" FLOAT,
  "electricity_non_household_capacity_taxes_pps" FLOAT,
  "electricity_non_household_energy_and_supply_pps" FLOAT,
  "electricity_non_household_environmental_taxes_pps" FLOAT,
  "electricity_non_household_network_costs_pps" FLOAT,
  "electricity_non_household_nuclear_taxes_pps" FLOAT,
  "electricity_non_household_other_pps" FLOAT,
  "electricity_non_household_renewable_taxes_pps" FLOAT,
  "electricity_non_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "electricity_non_household_total_price_including_taxes_pps" FLOAT,
  "electricity_non_household_value_added_tax_vat_pps" FLOAT,
  "gas_household_capacity_taxes_pps" FLOAT,
  "gas_household_energy_and_supply_pps" FLOAT,
  "gas_household_environmental_taxes_pps" FLOAT,
  "gas_household_network_costs_pps" FLOAT,
  "gas_household_other_pps" FLOAT,
  "gas_household_renewable_taxes_pps" FLOAT,
  "gas_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "gas_household_total_price_including_taxes_pps" FLOAT,
  "gas_household_value_added_tax_vat_pps" FLOAT,
  "gas_non_household_capacity_taxes_pps" FLOAT,
  "gas_non_household_energy_and_supply_pps" FLOAT,
  "gas_non_household_environmental_taxes_pps" FLOAT,
  "gas_non_household_network_costs_pps" FLOAT,
  "gas_non_household_other_pps" FLOAT,
  "gas_non_household_renewable_taxes_pps" FLOAT,
  "gas_non_household_taxes_fees_levies_and_charges_pps" FLOAT,
  "gas_non_household_total_price_including_taxes_pps" FLOAT,
  "gas_non_household_value_added_tax_vat_pps" FLOAT,
  "electricity_household_taxes_fees_levies_and_charges_al_8da3a87c" FLOAT
);

Energy Statistics, Prices Of Natural Gas And Electricity

@owid.gas_and_electricity_prices.owid_gas_and_electricity_prices_1
  • 57.34 KB
  • 10234 rows
  • 8 columns
Loading...

CREATE TABLE owid_gas_and_electricity_prices_1 (
  "country" VARCHAR,
  "date" TIMESTAMP,
  "source" VARCHAR,
  "consumer_type" VARCHAR,
  "price_component_or_level" VARCHAR,
  "year" INTEGER,
  "price_euro" FLOAT,
  "price_pps" FLOAT
);

Gas And Electricity Prices 2

@owid.gas_and_electricity_prices.owid_gas_and_electricity_prices_2
  • 87.41 KB
  • 9091 rows
  • 8 columns
Loading...

CREATE TABLE owid_gas_and_electricity_prices_2 (
  "country" VARCHAR,
  "date" TIMESTAMP,
  "source" VARCHAR,
  "consumer_type" VARCHAR,
  "price_component_or_level" VARCHAR,
  "year" INTEGER,
  "price_euro" FLOAT,
  "price_pps" FLOAT
);

Gas And Electricity Prices In Europe

@owid.gas_and_electricity_prices.owid_gas_and_electricity_prices_euro_flat_1
  • 23.7 KB
  • 242 rows
  • 14 columns
Loading...

CREATE TABLE owid_gas_and_electricity_prices_euro_flat_1 (
  "country" VARCHAR,
  "date" TIMESTAMP,
  "electricity_non_household_all_taxes_and_levies_included_euro" FLOAT,
  "electricity_non_household_excluding_vat_and_other_reco_b183e5ec" FLOAT,
  "electricity_non_household_excluding_taxes_and_levies_euro" FLOAT,
  "electricity_household_all_taxes_and_levies_included_euro" FLOAT,
  "electricity_household_excluding_vat_and_other_recovera_f62ee7bb" FLOAT,
  "electricity_household_excluding_taxes_and_levies_euro" FLOAT,
  "gas_non_household_all_taxes_and_levies_included_euro" FLOAT,
  "gas_non_household_excluding_vat_and_other_recoverable__9f3a1cac" FLOAT,
  "gas_non_household_excluding_taxes_and_levies_euro" FLOAT,
  "gas_household_all_taxes_and_levies_included_euro" FLOAT,
  "gas_household_excluding_vat_and_other_recoverable_taxe_9f3a61a0" FLOAT,
  "gas_household_excluding_taxes_and_levies_euro" FLOAT
);

Gas And Electricity Prices In Europe

@owid.gas_and_electricity_prices.owid_gas_and_electricity_prices_euro_flat_2
  • 23.39 KB
  • 220 rows
  • 14 columns
Loading...

CREATE TABLE owid_gas_and_electricity_prices_euro_flat_2 (
  "country" VARCHAR,
  "date" TIMESTAMP,
  "electricity_non_household_all_taxes_and_levies_included_euro" FLOAT,
  "electricity_non_household_excluding_vat_and_other_reco_b183e5ec" FLOAT,
  "electricity_non_household_excluding_taxes_and_levies_euro" FLOAT,
  "electricity_household_all_taxes_and_levies_included_euro" FLOAT,
  "electricity_household_excluding_vat_and_other_recovera_f62ee7bb" FLOAT,
  "electricity_household_excluding_taxes_and_levies_euro" FLOAT,
  "gas_non_household_all_taxes_and_levies_included_euro" FLOAT,
  "gas_non_household_excluding_vat_and_other_recoverable__9f3a1cac" FLOAT,
  "gas_non_household_excluding_taxes_and_levies_euro" FLOAT,
  "gas_household_all_taxes_and_levies_included_euro" FLOAT,
  "gas_household_excluding_vat_and_other_recoverable_taxe_9f3a61a0" FLOAT,
  "gas_household_excluding_taxes_and_levies_euro" FLOAT
);

Gas And Electricity Prices In Europe (PPS)

@owid.gas_and_electricity_prices.owid_gas_and_electricity_prices_pps_flat_1
  • 23.33 KB
  • 242 rows
  • 14 columns
Loading...

CREATE TABLE owid_gas_and_electricity_prices_pps_flat_1 (
  "country" VARCHAR,
  "date" TIMESTAMP,
  "electricity_non_household_all_taxes_and_levies_included_pps" FLOAT,
  "electricity_non_household_excluding_vat_and_other_reco_dbf3985b" FLOAT,
  "electricity_non_household_excluding_taxes_and_levies_pps" FLOAT,
  "electricity_household_all_taxes_and_levies_included_pps" FLOAT,
  "electricity_household_excluding_vat_and_other_recovera_4680f723" FLOAT,
  "electricity_household_excluding_taxes_and_levies_pps" FLOAT,
  "gas_non_household_all_taxes_and_levies_included_pps" FLOAT,
  "gas_non_household_excluding_vat_and_other_recoverable__f0714caa" FLOAT,
  "gas_non_household_excluding_taxes_and_levies_pps" FLOAT,
  "gas_household_all_taxes_and_levies_included_pps" FLOAT,
  "gas_household_excluding_vat_and_other_recoverable_taxe_abd50d50" FLOAT,
  "gas_household_excluding_taxes_and_levies_pps" FLOAT
);

Gas And Electricity Prices In Europe (PPS)

@owid.gas_and_electricity_prices.owid_gas_and_electricity_prices_pps_flat_2
  • 23.22 KB
  • 220 rows
  • 14 columns
Loading...

CREATE TABLE owid_gas_and_electricity_prices_pps_flat_2 (
  "country" VARCHAR,
  "date" TIMESTAMP,
  "electricity_non_household_all_taxes_and_levies_included_pps" FLOAT,
  "electricity_non_household_excluding_vat_and_other_reco_dbf3985b" FLOAT,
  "electricity_non_household_excluding_taxes_and_levies_pps" FLOAT,
  "electricity_household_all_taxes_and_levies_included_pps" FLOAT,
  "electricity_household_excluding_vat_and_other_recovera_4680f723" FLOAT,
  "electricity_household_excluding_taxes_and_levies_pps" FLOAT,
  "gas_non_household_all_taxes_and_levies_included_pps" FLOAT,
  "gas_non_household_excluding_vat_and_other_recoverable__f0714caa" FLOAT,
  "gas_non_household_excluding_taxes_and_levies_pps" FLOAT,
  "gas_household_all_taxes_and_levies_included_pps" FLOAT,
  "gas_household_excluding_vat_and_other_recoverable_taxe_abd50d50" FLOAT,
  "gas_household_excluding_taxes_and_levies_pps" FLOAT
);

Share link

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