Supplementary data for "Energy Justice and Housing: Spatial distribution of Energy Burden in Berlin"

This dataset provides supplementary material to the journal article "Energy Justice and Housing: Spatial distribution of Energy Burden in Berlin", submitted to Environmental Research: Energy / IOP Science. The relevant context and methodology is provided in this publication. The supplementary material includes the following files:

A novel PLR-level dataset of energy consumption, energy burden and energy poverty in Berlin, in two formats: `energy_consump_burden_epov_berlin.csv` and `energy_consump_burden_epov_berlin.geojson`

Specifically, the datasets capture following indicators on PLR-level (Planungsräume (PLR], eng: planning areas):

Energy consumption per square meter of living space, per capita and per household, based on:

SenWEB. Energieatlas Berlin [Energy Atlas Berlin], 2024. https://energieatlas.berlin.de/

SenStadtUm. Emissionsdatenbank Berlin [Emissions database Berlin], 2016.

AfSBB. Energie- und CO2-Bilanz in Berlin 2021 [Energy and CO2 balance in Berlin 2021], 2023a.

AfSBB. Ergebnisse des Mikrozensus im Land Berlin 2023 (Erstergebnisse) [Results of the Berlin Microcensus 2023 (initial results)], 2024b.

AfSBB. Kleinräumige Daten Berlin. Lebensweltlich Orientierte Räume. Ebene: Planungsräume. Zensus 2022 [Small-Scale Data Berlin. Lifeworld-Oriented Areas. Level: Planning Areas. 2022 Census], 2024c.

SenStadt. Datengrundlage: Gebäudeeignung für ein zentrales oder dezentrales Wärmeversorgungssystem [Data basis: Building suitability for a central or decentralized heat supply system], 2022.

SenStadt. Gebäudeeignung für ein zentrales / dezentrales Wärmeversorgungssystem. Inhaltliche Beschreibung [Building suitability for a centralized/decentralized heat supply system. Content description], Aug. 2023a.

Based on energy consumption per household, we also provide

Share of energy from electricity 

Share of energy from district heating

Share of energy from heating oil

Share of energy from gas 

Energy expenditure per household (own derivation based on price assumptions)

Energy burdens as share of household income spent on household energy consumption, per income level (own calculation)

Income levels based on: AfSBB. Einwohnerinnen und Einwohner und Privathaushalte in Berlin am 31.12.2022 [Residents and private households in Berlin on 31.12.2022], 2024a.

Weighted energy burden across PLR, from income level (own derivation)

Share households in energy burden levels, accoding to Berlin-wide median energy burden of 5.7% (own derivation)

Energy burden below 0.5 of median energy burden (0.5 M, energy unburdened)

Energy burden above 1.5 of median energy burden (1.5 M, energy burdened)

Energy burden above 2 of median energy burden (2 M, energy impoverished)

Net household income from net rent, net rent burden and average heated living area 

AfSBB. Kleinräumige Daten Berlin. Lebensweltlich Orientierte Räume. Ebene: Planungsräume. Zensus 2022 [Small-Scale Data Berlin. Lifeworld-Oriented Areas. Level: Planning Areas. 2022 Census], 2024c.

bulwiengesa AG. Berliner Nachhaltigkeitsatlas. Januar 2025. https://atruvia.scene7.com/is/content/atruvia/studie-berliner-nachhaltigkeitsatlas.pdf 

bulwiengesa AG, Michael Bauer Research GmbH 2022; ImmobilienScout; Zensus 2022: Statistische Ämter des Bundes und der Länder. Indikatoren des Berliner Nachhaltigkeitsatlases. 2025.

Average energy burden across PLR (own derivation)

Further information may be gathered from:

Wanner Fandrych, S. (2025). Energiegerechtigkeit und Wohnen. Eine räumliche Analyse für Berlin anhand der Energiekostenbelastung [Energy justice and housing: A spatial analysis for Berlin based on energy cost burden]. Master thesis. https://doi.org/10.5281/zenodo.15683167