Final Energy Consumption

Eurostat code: sdg_07_11 · (2005 - 2023)

@eurostat.sdg_07_11

Table List

2 tables(34.04 KB)

Final Energy Consumption - Raw

Final Energy Consumption - Unpivoted

Final Energy Consumption - Raw

@eurostat.sdg_07_11.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

24.26 KB
84 rows
22 columns

freq Freq	unit Unit	geo Geo	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023
Annual	Index, 2005=100	Austria	100	100.3	98.7	98.8	95.7	100.7	97.5	97.7	99.8	95.8	98.6	101.1	102.5	101	102	94.3	100.4	95.6	91.9
Annual	Index, 2005=100	Belgium	100	98.8	95.7	99.8	96.8	104	96.2	97	99.7	92.9	97.6	98.3	97.4	98.2	96.2	90.3	97.2	90.2	88.5
Annual	Index, 2005=100	Bulgaria	100	103.5	102.1	100.3	87.9	90.3	94.7	94.3	89.8	91.9	97.1	98.7	101.3	101.5	100.8	97.5	104.4	101.5	98.1
Annual	Index, 2005=100	Cyprus	100	101.7	105.1	107.7	105.8	105.2	104.8	96.5	88.3	88.3	90.9	96.3	101.6	101.3	102.9	85.8	92.3	99.4	102.2
Annual	Index, 2005=100	Czechia	100	101.1	99	99	95.7	96.8	93.7	93.5	92.6	89.9	92.5	94.8	97.9	97	97.1	93.9	100	95.4	89.7
Annual	Index, 2005=100	Germany	100	102.7	96.7	100.8	95.3	101.3	96.2	98	100.5	95.3	96.6	98.5	99.3	97.6	97.6	92	94.2	91.8	87.2
Annual	Index, 2005=100	Denmark	100	101.1	101.4	100.2	95.5	100.1	95.5	92.2	91.1	88.1	91.3	93.5	94	94	92.3	84.4	89.3	86	86.3
Annual	Index, 2005=100	Estonia	100	100.7	107.8	106.9	96.5	101.8	98.8	100.9	101	98.6	97.9	99.3	100.2	103.4	101.2	96.1	99	97.1	91.4
Annual	Index, 2005=100	Greece	100	102.9	105.1	102	97.9	90.6	90	81.2	73	74.1	78.8	79.7	78	75.7	76.9	68.7	72.2	76.6	74.8
Annual	Index, 2005=100	Spain	100	97.8	100.5	97	90.3	91.5	88.9	85.4	82.3	81.1	82.8	84.7	87.1	89.1	89	76.1	82.6	83.7	83.2


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

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