Name: Energy Footprints (domestic Technology Assumption)
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Energy Footprints (domestic Technology Assumption)

This Eurostat dataset contains data on energy footprints (domestic technology assumption), 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-25T23:00:00+0100

Tables

Energy Footprints (domestic Technology Assumption) - Raw

@eurostat.env_ac_pefafp.raw

383.21 KB
8040 rows
16 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "indic_pefa" VARCHAR,
  "cpa08" VARCHAR,
  "ind_acct" VARCHAR,
  "origin" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "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
);

Energy Footprints (domestic Technology Assumption) - Unpivoted

@eurostat.env_ac_pefafp.tidy

353.34 KB
72360 rows
9 columns


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_pefa" VARCHAR,
  "cpa08" VARCHAR,
  "ind_acct" VARCHAR,
  "origin" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);