Baselight
Sign In

Non-household Consumption Volumes Of Gas By Consumption Bands

Eurostat code: nrg_pc_203_v ยท (2017 - 2024)

@eurostat.nrg_pc_203_v

Non-household Consumption Volumes Of Gas By Consumption Bands - Unpivoted
@eurostat.nrg_pc_203_v.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

  • 13.61 KB
  • 1126 rows
  • 7 columns
freq

Freq

nrg_cons

Nrg Cons

product

Product

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualConsumption from 1 000 GJ to 9 999 GJ -band I2Natural gasPercentageAustria20179.9
AnnualConsumption from 1 000 GJ to 9 999 GJ -band I2Natural gasPercentageBosnia and Herzegovina201710.8
AnnualConsumption from 1 000 GJ to 9 999 GJ -band I2Natural gasPercentageBelgium201711.8767
AnnualConsumption from 1 000 GJ to 9 999 GJ -band I2Natural gasPercentageBulgaria20175.53
AnnualConsumption from 1 000 GJ to 9 999 GJ -band I2Natural gasPercentageCzechia201719.1241
AnnualConsumption from 1 000 GJ to 9 999 GJ -band I2Natural gasPercentageDenmark201719
AnnualConsumption from 1 000 GJ to 9 999 GJ -band I2Natural gasPercentageEstonia20179.9103
AnnualConsumption from 1 000 GJ to 9 999 GJ -band I2Natural gasPercentageGreece20171.99
AnnualConsumption from 1 000 GJ to 9 999 GJ -band I2Natural gasPercentageEuropean Union - 27 countries (from 2020)20178.4295
AnnualConsumption from 1 000 GJ to 9 999 GJ -band I2Natural gasPercentageFinland20173.1577

CREATE TABLE tidy (
  "freq" VARCHAR,
  "nrg_cons" VARCHAR,
  "product" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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