Baselight

Total Energy Supply By Product

Eurostat code: ten00122 ยท (2012 - 2023)

@eurostat.ten00122

Total Energy Supply By Product - Unpivoted
@eurostat.ten00122.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.

  • 35.05 KB
  • 5760 rows
  • 7 columns
freq

Freq

nrg_bal

Nrg Bal

siec

Siec

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualTotal energy supplySolid fossil fuelsThousand tonnes of oil equivalentAlbania201277.225
AnnualTotal energy supplySolid fossil fuelsThousand tonnes of oil equivalentAustria20123245.066
AnnualTotal energy supplySolid fossil fuelsThousand tonnes of oil equivalentBelgium20123235.666
AnnualTotal energy supplySolid fossil fuelsThousand tonnes of oil equivalentBulgaria20126915
AnnualTotal energy supplySolid fossil fuelsThousand tonnes of oil equivalentCyprus20120.124
AnnualTotal energy supplySolid fossil fuelsThousand tonnes of oil equivalentCzechia201217283.113
AnnualTotal energy supplySolid fossil fuelsThousand tonnes of oil equivalentGermany201279918.633
AnnualTotal energy supplySolid fossil fuelsThousand tonnes of oil equivalentDenmark20122467.764
AnnualTotal energy supplySolid fossil fuelsThousand tonnes of oil equivalentEstonia201224.464
AnnualTotal energy supplySolid fossil fuelsThousand tonnes of oil equivalentGreece20128134.842

CREATE TABLE tidy (
  "freq" VARCHAR,
  "nrg_bal" VARCHAR,
  "siec" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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