Name: Cooling And Heating Degree Days By Country - Monthly Data
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Cooling And Heating Degree Days By Country - Monthly Data

This Eurostat dataset contains data on cooling and heating degree days by country - monthly data, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-03-28T23:00:00+0100

Tables

Cooling And Heating Degree Days By Country - Monthly Data - Raw

@eurostat.nrg_chdd_m.raw

523.76 kB
58 rows
556 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "indic_nrg" VARCHAR,
  "geo" VARCHAR,
  "n_1979_01" DOUBLE  -- 1979-01,
  "n_1979_02" DOUBLE  -- 1979-02,
  "n_1979_03" DOUBLE  -- 1979-03,
  "n_1979_04" DOUBLE  -- 1979-04,
  "n_1979_05" DOUBLE  -- 1979-05,
  "n_1979_06" DOUBLE  -- 1979-06,
  "n_1979_07" DOUBLE  -- 1979-07,
  "n_1979_08" DOUBLE  -- 1979-08,
  "n_1979_09" DOUBLE  -- 1979-09,
  "n_1979_10" DOUBLE  -- 1979-10,
  "n_1979_11" DOUBLE  -- 1979-11,
  "n_1979_12" DOUBLE  -- 1979-12,
  "n_1980_01" DOUBLE  -- 1980-01,
  "n_1980_02" DOUBLE  -- 1980-02,
  "n_1980_03" DOUBLE  -- 1980-03,
  "n_1980_04" DOUBLE  -- 1980-04,
  "n_1980_05" DOUBLE  -- 1980-05,
  "n_1980_06" DOUBLE  -- 1980-06,
  "n_1980_07" DOUBLE  -- 1980-07,
  "n_1980_08" DOUBLE  -- 1980-08,
  "n_1980_09" DOUBLE  -- 1980-09,
  "n_1980_10" DOUBLE  -- 1980-10,
  "n_1980_11" DOUBLE  -- 1980-11,
  "n_1980_12" DOUBLE  -- 1980-12,
  "n_1981_01" DOUBLE  -- 1981-01,
  "n_1981_02" DOUBLE  -- 1981-02,
  "n_1981_03" DOUBLE  -- 1981-03,
  "n_1981_04" DOUBLE  -- 1981-04,
  "n_1981_05" DOUBLE  -- 1981-05,
  "n_1981_06" DOUBLE  -- 1981-06,
  "n_1981_07" DOUBLE  -- 1981-07,
  "n_1981_08" DOUBLE  -- 1981-08,
  "n_1981_09" DOUBLE  -- 1981-09,
  "n_1981_10" DOUBLE  -- 1981-10,
  "n_1981_11" DOUBLE  -- 1981-11,
  "n_1981_12" DOUBLE  -- 1981-12,
  "n_1982_01" DOUBLE  -- 1982-01,
  "n_1982_02" DOUBLE  -- 1982-02,
  "n_1982_03" DOUBLE  -- 1982-03,
  "n_1982_04" DOUBLE  -- 1982-04,
  "n_1982_05" DOUBLE  -- 1982-05,
  "n_1982_06" DOUBLE  -- 1982-06,
  "n_1982_07" DOUBLE  -- 1982-07,
  "n_1982_08" DOUBLE  -- 1982-08,
  "n_1982_09" DOUBLE  -- 1982-09,
  "n_1982_10" DOUBLE  -- 1982-10,
  "n_1982_11" DOUBLE  -- 1982-11,
  "n_1982_12" DOUBLE  -- 1982-12,
  "n_1983_01" DOUBLE  -- 1983-01,
  "n_1983_02" DOUBLE  -- 1983-02,
  "n_1983_03" DOUBLE  -- 1983-03,
  "n_1983_04" DOUBLE  -- 1983-04,
  "n_1983_05" DOUBLE  -- 1983-05,
  "n_1983_06" DOUBLE  -- 1983-06,
  "n_1983_07" DOUBLE  -- 1983-07,
  "n_1983_08" DOUBLE  -- 1983-08,
  "n_1983_09" DOUBLE  -- 1983-09,
  "n_1983_10" DOUBLE  -- 1983-10,
  "n_1983_11" DOUBLE  -- 1983-11,
  "n_1983_12" DOUBLE  -- 1983-12,
  "n_1984_01" DOUBLE  -- 1984-01,
  "n_1984_02" DOUBLE  -- 1984-02,
  "n_1984_03" DOUBLE  -- 1984-03,
  "n_1984_04" DOUBLE  -- 1984-04,
  "n_1984_05" DOUBLE  -- 1984-05,
  "n_1984_06" DOUBLE  -- 1984-06,
  "n_1984_07" DOUBLE  -- 1984-07,
  "n_1984_08" DOUBLE  -- 1984-08,
  "n_1984_09" DOUBLE  -- 1984-09,
  "n_1984_10" DOUBLE  -- 1984-10,
  "n_1984_11" DOUBLE  -- 1984-11,
  "n_1984_12" DOUBLE  -- 1984-12,
  "n_1985_01" DOUBLE  -- 1985-01,
  "n_1985_02" DOUBLE  -- 1985-02,
  "n_1985_03" DOUBLE  -- 1985-03,
  "n_1985_04" DOUBLE  -- 1985-04,
  "n_1985_05" DOUBLE  -- 1985-05,
  "n_1985_06" DOUBLE  -- 1985-06,
  "n_1985_07" DOUBLE  -- 1985-07,
  "n_1985_08" DOUBLE  -- 1985-08,
  "n_1985_09" DOUBLE  -- 1985-09,
  "n_1985_10" DOUBLE  -- 1985-10,
  "n_1985_11" DOUBLE  -- 1985-11,
  "n_1985_12" DOUBLE  -- 1985-12,
  "n_1986_01" DOUBLE  -- 1986-01,
  "n_1986_02" DOUBLE  -- 1986-02,
  "n_1986_03" DOUBLE  -- 1986-03,
  "n_1986_04" DOUBLE  -- 1986-04,
  "n_1986_05" DOUBLE  -- 1986-05,
  "n_1986_06" DOUBLE  -- 1986-06,
  "n_1986_07" DOUBLE  -- 1986-07,
  "n_1986_08" DOUBLE  -- 1986-08,
  "n_1986_09" DOUBLE  -- 1986-09,
  "n_1986_10" DOUBLE  -- 1986-10,
  "n_1986_11" DOUBLE  -- 1986-11,
  "n_1986_12" DOUBLE  -- 1986-12
);

Cooling And Heating Degree Days By Country - Monthly Data - Unpivoted

@eurostat.nrg_chdd_m.tidy

124.28 kB
32,016 rows
6 columns

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