Energy Flow - Sankey Diagram Data
Eurostat code: nrg_bal_sd ยท (1990 - 2023)
@eurostat.nrg_bal_sd
Eurostat code: nrg_bal_sd ยท (1990 - 2023)
@eurostat.nrg_bal_sd
This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.
freqFreq | nrg_balNrg Bal | siecSiec | unitUnit | geoGeo | n_19901990 | n_19911991 | n_19921992 | n_19931993 | n_19941994 | n_19951995 | n_19961996 | n_19971997 | n_19981998 | n_19991999 | n_20002000 | n_20012001 | n_20022002 | n_20032003 | n_20042004 | n_20052005 | n_20062006 | n_20072007 | n_20082008 | n_20092009 | n_20102010 | n_20112011 | n_20122012 | n_20132013 | n_20142014 | n_20152015 | n_20162016 | n_20172017 | n_20182018 | n_20192019 | n_20202020 | n_20212021 | n_20222022 | n_20232023 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Annual | Available from all sources | Coking coal | Thousand tonnes of oil equivalent | Albania | 40.3 | 39 | ||||||||||||||||||||||||||||||||
Annual | Available from all sources | Coking coal | Thousand tonnes of oil equivalent | Austria | 1649.7 | 1455.3 | 1472 | 1303.2 | 1335.2 | 1324.8 | 1453.2 | 1504.6 | 1508.1 | 1521.3 | 1303.2 | 1313 | 1317.8 | 1317.8 | 1322 | 1433.9 | 1313.1 | 1319.3 | 1341 | 1181.1 | 1328.7 | 1240.3 | 1248.9 | 1240 | 1267.9 | 1230 | 1242.9 | 1229.3 | 1225.2 | 1272.2 | 1208.7 | 1217 | 1229.6 | 1302.7 |
Annual | Available from all sources | Coking coal | Thousand tonnes of oil equivalent | Bosnia and Herzegovina | 977.4 | 943.4 | 903.9 | 944.8 | 1011.6 | 1063 | 763.6 | 934.6 | 779.8 | |||||||||||||||||||||||||
Annual | Available from all sources | Coking coal | Thousand tonnes of oil equivalent | Belgium | 5010 | 4498.3 | 4056.6 | 3521 | 3328.5 | 3687 | 3727.6 | 3117.8 | 2936.5 | 2767.1 | 2891 | 2918.3 | 2611 | 2508.1 | 2552.9 | 2550.8 | 2633.4 | 2417.8 | 2095.1 | 1439.9 | 1960.7 | 1892.8 | 1781.5 | 1663.4 | 1321.2 | 1145.4 | 1108.1 | 1102.5 | 1136 | 1105 | 1143.2 | 1158.4 | 1216.7 | 1203 |
Annual | Available from all sources | Coking coal | Thousand tonnes of oil equivalent | Bulgaria | 1146 | 620.2 | 754.6 | 1004.7 | 1162.1 | 1248.6 | 1168.2 | 1310.1 | 927.4 | 883 | 1057.2 | 894.5 | 847.6 | 926.6 | 805.7 | 718.9 | 637.8 | 501.8 | 296.6 | |||||||||||||||
Annual | Available from all sources | Coking coal | Thousand tonnes of oil equivalent | Czechia | 9700 | 9180.5 | 8706.9 | 7895.2 | 7870.9 | 8057.9 | 7780.7 | 7340.2 | 6780.9 | 5831.3 | 5728.3 | 5798.3 | 5616.9 | 5685.7 | 5413.6 | 5137.7 | 5940.3 | 6083.6 | 5918.1 | 4805.5 | 4831.9 | 4344.2 | 4288.7 | 3846.2 | 4338.5 | 3904.9 | 3567.7 | 3433.1 | 3237.1 | 2872.6 | 2362.5 | 3069.9 | 2553.7 | 1952.6 |
Annual | Available from all sources | Coking coal | Thousand tonnes of oil equivalent | Germany | 32019.4 | 29037.9 | 28131.6 | 25118.4 | 24048.2 | 24051 | 21445.2 | 20488.7 | 20055.8 | 18937.1 | 16945.8 | 14675.2 | 16024.5 | 15843.1 | 16593.4 | 15662 | 15369 | 16194.9 | 13861.4 | 10792.9 | 11067.9 | 11421.8 | 12735.1 | 8690 | 10008.1 | 8117.2 | 10481.2 | 10961.2 | 10487.5 | 7951.7 | 7095.8 | 8049 | 8017.9 | 7962.1 |
Annual | Available from all sources | Coking coal | Thousand tonnes of oil equivalent | Spain | 3201.1 | 3424.3 | 3131.3 | 3276 | 2937.8 | 2373.2 | 2391.8 | 2701.3 | 2798.1 | 2542.3 | 2752.2 | 2480.8 | 2515.1 | 2704.5 | 2898.9 | 2658 | 2672.3 | 2695.3 | 2485.7 | 1709.1 | 2040 | 1904.4 | 1674.1 | 1758.6 | 1429.7 | 1416.1 | 1433.9 | 1397.9 | 1307.4 | 734.3 | 475.8 | 1048.6 | 1207.1 | 1407 |
Annual | Available from all sources | Coking coal | Thousand tonnes of oil equivalent | European Union - 27 countries (from 2020) | 97971.8 | 88625.2 | 87733.1 | 82374.4 | 81478.3 | 83672.7 | 77310.4 | 79847.6 | 74260.3 | 68179.5 | 62563.6 | 59559.3 | 57485 | 58187.1 | 59840.1 | 57231.5 | 58823.4 | 59698.1 | 55469.6 | 40494.3 | 47085.7 | 45574.5 | 46507.5 | 41126.2 | 42074.1 | 39520.9 | 41328.9 | 41831.9 | 41051.6 | 36758.5 | 32088.6 | 33673 | 32967.9 | 30927.9 |
Annual | Available from all sources | Coking coal | Thousand tonnes of oil equivalent | Finland | 447.9 | 397.5 | 488.3 | 688.6 | 913.5 | 1040.1 | 898.6 | 864.3 | 916.8 | 886.7 | 898.6 | 1025.2 | 918.9 | 896.5 | 954.6 | 980.4 | 867.8 | 992.3 | 864.3 | 778.9 | 928.7 | 895.1 | 861.5 | 893.7 | 940.6 | 925.2 | 917.5 | 860.8 | 954.6 | 842.6 | 757.9 | 819.4 | 894.4 | 847.5 |
CREATE TABLE raw (
"freq" VARCHAR,
"nrg_bal" VARCHAR,
"siec" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"n_1990" DOUBLE,
"n_1991" DOUBLE,
"n_1992" DOUBLE,
"n_1993" DOUBLE,
"n_1994" DOUBLE,
"n_1995" DOUBLE,
"n_1996" DOUBLE,
"n_1997" DOUBLE,
"n_1998" DOUBLE,
"n_1999" DOUBLE,
"n_2000" DOUBLE,
"n_2001" DOUBLE,
"n_2002" DOUBLE,
"n_2003" DOUBLE,
"n_2004" DOUBLE,
"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
);
Anyone who has the link will be able to view this.