Thank you for visiting nature.com. You are using a browser version with limited support for CSS. To obtain the best experience, we recommend you use a more up to date browser (or turn off compatibility mode in Internet Explorer). In the meantime, to ensure continued support, we are displaying the site without styles and JavaScript.

# Time series of useful energy consumption patterns for energy system modeling

## Abstract

The analysis of energy scenarios for future energy systems requires appropriate data. However, while more or less detailed data on energy production is often available, appropriate data on energy consumption is often scarce. In our JERICHO-E-usage dataset, we provide comprehensive data on useful energy consumption patterns for heat, cold, mechanical energy, information and communication, and light in high spatial and temporal resolution. Furthermore, we distinguish between residential, industrial, commerce, and mobility consumers. For our dataset, we aggregate bottom-up data and disaggregate top-down data both to the NUTS2 level. The NUTS2 level serves as an interface to validate our combined method approach and the calculations. We combine a multitude of data sources such as weather time series, standard load profiles, census data, movement data, and employment figures to increase the scope, validity, and reproducibility for energy system modeling. The focus of our JERICHO-E-usage dataset on useful energy consumption might be of particular interest to researchers who analyze energy scenarios where renewable electricity is largely substituted for fossil fuel (sector coupling).

 Measurement(s) space heat consumption patterns • hot water consumption patterns • space cooling consumption patterns • process cooling consumption patterns • mechanical energy consumption patterns • information and communication (ICT) consumption patterns • light consumption patterns • mileage profiles • process heat consumption patterns Technology Type(s) computational modeling technique Factor Type(s) final energy consumption pattern • final energy annual consumption • heating system dimensioning guidelines • census data • traffic census data • weather data • economic reports and statistics • technical reports and statistics Sample Characteristic - Environment spatiotemporal region • temperature of air • building • economy • industry • demography • energy

Machine-accessible metadata file describing the reported data: https://doi.org/10.6084/m9.figshare.14039456

## Background & Summary

To successfully mitigate greenhouse gas emissions, energy systems must be transformed through global endeavors. Open data can help drive and support these efforts1,2. This does not only apply to the generation side, which is changing from centralized fossil to decentralized renewable energy conversion. It also concerns energy consumption, which is transforming (1) through energy efficiency measures and (2) the change in end-user technologies (e.g. the adoption of heat pumps or battery electric vehicles). Ultimately, the transformations on the generation and consumption sides define the infrastructure requirements for the distribution of energy carriers3.

Energy system modeling is becoming increasingly important for the analysis of energy scenarios and their implications on infrastructure and society. However, a thorough analysis of energy systems requires appropriate data. A widespread source for such data are energy balances. Energy balances comprise data on the procurement, conversion, and consumption of energy carriers. Figure 1 shows an exemplary energy balance. Energy balances are usually divided into primary and final energy, energy conversion, and energy consumption within the residential, industrial, commerce, and mobility sectors. Despite being valuable for energy system analysis, energy balances lack multiple information that would be highly valuable to analyze future energy systems:

1. 1)

Energy balances do not comprise the last step of energy conversion which consumers take using their end-use appliances (e.g., heating systems, cars, light bulbs) to convert final energy (e.g., electricity, natural gas, gasoline, diesel) into the eventually sought-after useful energy (e.g., heat, mechanical energy, light) at the end-consumer level. While some reports name the different types of useful energy categories that the final energy carriers can be associated with, these reports do not include actual quantitative data on useful energy.

2. 2)

Energy balances are usually not available on a sub-national level (in Germany, energy balances are available on the federal level but in varying quality and depth of detail).

3. 3)

Energy balances report annual energy quantities and are therefore not available in a temporal resolution of less than one year.

Future renewable energy systems are likely to be centered around renewable electricity as the main final energy carrier that will be converted into the different types of useful energy using appliances such as heat pumps or electric vehicles or via indirect electrification based on, e.g., hydrogen4. With the increasing share of volatile renewable electricity generation and changing consumption patterns, the temporal distribution of energy consumption becomes increasingly important for the outline of future energy systems. At the same time, the spatial distribution of energy consumption gains importance as the production of renewable electricity and its consumption regionally decouple.

Our JERICHO-E-usage dataset is an extension of the national energy balance that depicts the so far unattended consumption of useful energy in high spatio-temporal resolution. We use 2019 as our base year. As we publish our source code, the JERICHO-E-usage dataset can be updated in the future. Further, the geographical scope can be extended by applying the described methods to other countries. The dataset is spatially resolved at the NUTS2 level comprising 38 regions (see Fig. 2 and Table 1) and temporally resolved in hours (NUTS refers to Nomenclature des unités territoriales statistiques of the European Union a hierarchical system in which regions are administrative levels or units). We perform our calculations separately for the residential, industrial, commerce, and mobility sectors. We use combinations of bottom-up and top-down approaches. For this, we aggregate bottom-up data and disaggregate top-down data both to the NUTS2 level. The NUTS2 level serves as an interface to validate our calculations. We combine a multitude of data sources such as weather time series, standard load profiles, census data, movement data, and employment figures, among others. Overall, our dataset increases:

1. (1)

the scope of possible investigations with respect to future energy systems with high degrees of sector-coupling as our dataset allows for investigations in high spatio-temporal resolution,

2. (2)

the validity of these analyses as they no longer rely on simplified distribution keys for consumption patterns, and

3. (3)

the reproducibility as we provide a common input data framework.

Our JERICHO-E-usage dataset covers consumption patterns for eight types of useful energy in the residential, industrial, and commerce sectors. For the mobility sector, we provide the consumption patterns for mechanical energy and additionally mileage profiles for six vehicle types. For more details, see the Data Records section. Our dataset can be used to outline possible sector coupling pathways and analyze their systemic implications as shown in the Usage Notes section. As discussed in the Technical Validation section, our dataset and methodology can further improve energy system analyses by featuring spatial and sectoral resolutions of energy consumption patterns that were so far not publicly available.

## Methods

We divide useful energy into the following types: consumption patterns for (1) space heating, (2) hot water, (3) process heat, (4) space cooling, (5) process cooling, (6) mechanical energy, (7) information and communication technology, and (8) lighting. The underlying application purpose of useful energy differs among the residential, the industrial, the commerce, and the mobility sectors. The following methods can be applied generically and are not limited to the German case.

For the combined top-down and bottom-up approach, we use the NUTS2 level as the validation interface. In our top-down model, we disaggregate the energy balances for Germany from 2019 down to the NUTS2 level for all sectors and forms of useful energy5. We define the bottom-up model at the NUTS3 level and aggregate the resulting data to the NUTS2 level. We identify main drivers for the top-down and bottom-up approaches based on methods used to generate the national energy balance6,7 and extend them with the help of scientific studies8,9. In particular, the heat demand depends on regionally specific climate conditions. We represent differences in climate conditions using 15 climate zones within Germany as defined by German Climate Agency10. For the temporal resolution, the time series calculated account for climate zone-specific temperature and occultation time series. Besides, the time series are created according to the calendar of the year 2019, i.e., distribution of weekdays, Saturdays, as well as Sundays, and public holidays. Figure 3 shows spatio-temporal space heating consumption patterns as an illustration of the regional and temporal scopes of the dataset.

### Residential sector

In the residential sector, we identify the demand for heating and cooling to be the main driver for useful energy consumption patterns. We distinguish between single-family and multi-family houses and account for regional influencing factors. Figure 4 shows our methodology for the spatial and temporal distribution of the useful energy consumption for the residential sector.

In a first step, we calculate annual energy consumption (for space heating, hot water, and other appliances) per building type according to the VDI guideline 465511 and data on building typologies12. This calculation requires data on the year of construction, the size, and the number of residents and apartments per building which we derive from census data13. The spatial distribution is determined by the distribution of the different residential building types in the respective NUTS3 regions according to the latest census data13. For each region, we define representative buildings (separated by single and multi-family houses) that are determined by the age structure of the building stock, average living areas, and regional temperature profiles. Based on this distribution, we allocate average representative consumption patterns to the regions. The annual heating consumption is scaled in correspondence to the respective climate zone.

The temporal distribution is based on measured load profiles of different types of residential buildings in hourly resolution11. For this, we distribute energy consumption based on a typical-day approach for the year 2019. For the consideration of simultaneity effects and user behavior, the individual time series are stochastically shifted horizontally (discrete distribution with an expected value of zero hours and a standard deviation of one hour) and vertically (normal distribution with the original value as expected value and a standard deviation of 5%) before being aggregated to representative profiles per region.

Finally, we disaggregate the regional consumption time series for other appliances into different useful energy categories. We transform the time series to relative time series in reference to the total consumption across all regions. We then calculate the total consumption for useful energy for all categories of useful energy except space heating and hot water, as these time series were already calculated in the first step. We multiply the relative time series by the total consumption of useful energy.

Figure 5 shows the validation and scaling procedure for the residential sector. In the top-down approach, we use the aggregated data for final energy5 and data on conversion efficiencies14 to calculate total annual useful energy consumption per end-use. In the bottom-up approach, we aggregate the useful energy consumption per end-use across all regions and hours. By comparing the resulting total annual useful energy consumption, we derive scaling factors that we apply to our spatio-temporal time series.

### Industrial and commerce sectors

For the industrial and commerce sectors, we calculate the useful energy consumption patterns by combining top-down and bottom-up models as outlined in Fig. 6.

Starting with the annual final energy consumption for the German commerce and industrial sectors5, we then disaggregate the data spatially to the NUTS3 level based on sub-sector-specific employment figures and energy intensities within these sub-sectors. The sector-specific energy intensities correspond to the energy-weighted added value that we calculate based on the input-output table for Germany of the year 201515 (see Table 1). The sub-sectors comprise agriculture, trade, public, and finance for the commerce sector and food industry, manufacture of glassware and ceramics, car industry, mechanical engineering, chemical industry, paper industry, metal production and processing, and other industry for the industrial sector. We extracted the number of employees in each NUTS3 region for the commerce sector from official data by the statistical office of the federal states16 and the industrial sector from the national17 and European18 statistical offices. We manually filled missing data points based on online research on the respective companies at locations with insufficiently accurate data.

Furthermore, the temporal disaggregation is based on a bottom-up approach, in which representative time series for each sub-sector in each NUTS3 region are determined based on typical days for the different industrial19 and the commerce20 sub-sectors. We translate the time series of final energy consumption to time series of useful energy consumption using end-use-specific conversion efficiencies14. Finally, the data is aggregated to the NUTS2 level.

### Mobility sector

We estimate the consumption of useful energy in the mobility sector based on the regional driving profiles of different vehicles and road types. Figure 7 shows our methodology for the spatial and temporal distribution of the consumption in the mobility sector in Germany’s NUTS2 regions.

The spatial distribution of vehicle mileage depends on (1) the types of vehicles, (2) the average annual mileage per vehicle type, and (3) the mileage shares of urban and non-urban roads per vehicle type.

Table 2 gives an overview of these indicators. The vehicles and mileages are spatially distributed to the NUTS3 regionals using official vehicle stock and mileage statistics21,22. We then temporally disaggregate the yearly values to an hourly resolution. For this, we generate vehicle-specific time series for urban23 and non-urban24 mileage and assign mileage shares for the two road types to each of the vehicle types. We differentiate between the final energy sources diesel, gasoline, gas, electricity, and biofuels and account for engine sizes and other vehicle-specific features by using individual conversion efficiencies per vehicle type. After having calculated the hourly mileage for NUTS3 regions, we again aggregate the data to the NUTS2 level.

To validate and scale the mileage profiles, we use the annual final energy consumptions of diesel, gasoline, gas, biomass, and electricity in the road traffic sector25. The mileage profiles for the different vehicle types influence multiple final energy consumption – e.g., the mileage profiles for passenger cars influence the consumption of diesel, gasoline, gas, biomass, and electricity. To solve the resulting system of equations, we set up a linear programming (LP) problem as follows:

$$\mathop{\min }\limits_{{\alpha }_{v,}{\beta }_{v,f}^{FE},{\gamma }_{f}^{FE},{\delta }_{f}^{FE,pos},{\delta }_{f}^{FE,neg}}\sum _{f\in F}({\delta }_{f}^{FE,pos}+{\delta }_{f}^{FE,neg})$$
$$\begin{array}{cc}{s.t.}\quad {\alpha }_{v}\cdot {{\rm{A}}}_{v,f}^{Fuel\;Share}\cdot {{\rm{B}}}_{v,f}^{Conversion}\cdot \sum _{n\in N}\sum _{h\in H}{\Gamma }_{v,n,h}^{Mileage}={\beta }_{v,f}^{FE} & \forall v\in V,f\in F\\ \sum _{v\in V}{\beta }_{v,f}^{FE}={\gamma }_{f}^{FE} & \forall f\in F\\ {\gamma }_{f}^{FE}-{{\rm{E}}}_{f}^{AGEB}={\delta }_{f}^{FE,pos}-{\delta }_{f}^{FE,neg} & \forall f\in F\\ {\alpha }_{v}{\ge \Delta }^{Lowerlimit} & \forall v\in V\\ {\alpha }_{v}{\le \Delta }^{Upperlimit} & \forall v\in V\\ {\delta }_{f}^{FE,pos},{\delta }_{f}^{FE,neg}\ge 0 & \forall f\in F\end{array}$$

Here, the objective of the LP problem is to minimize the deviation in final energy consumption $${\delta }_{f}^{FE}={\delta }_{f}^{FE,pos}+$$ $${\delta }_{f}^{FE,neg}$$ between the consumption stated by the national statistics $${{\rm{E}}}_{f}^{AGEB}$$ and our bottom-up data $${\gamma }_{f}^{FE}$$ for the relevant final energy type $$f\in F$$. By solving the LP problem, the factors αv are defined that scale the mileage profiles for the different vehicle types $$v\in V$$. The contribution of each vehicle type v to the final energy consumption of f is represented by the variable $${\beta }_{v,f}^{FE}$$. The parameter $${{\rm{A}}}_{\nu ,f}^{Fuel\;share}$$ defines the mileage share for a vehicle type that is allocated to a specific fuel, e.g. the share of mileage that can be accounted to diesel-fueled passenger cars22,26. The parameter $${{\rm{B}}}_{\nu ,f}^{Conversion}$$ defines the average conversion efficiency per vehicle type from final energy to mileage27. The mileage per vehicle type, region, and hour is represented by the parameter $${\Gamma }_{v,n,h}^{Mileage}$$. We incrementally decrease and increase the parameters ΔLower limit and ΔUpper limit starting from one until the total deviation $${\delta }_{f}^{FE}$$ converges to zero. The results show that the mileage for trucks was underestimated in the initial profiles. This was expected as Germany is a transit country for road transportation which could not be depicted solely with the German vehicle stock.

Finally, useful energy consumption time series are calculated using the scaled mileage profiles and end-use-specific conversion efficiencies14. We restrict the useful energy types to mechanical energy for the mobility sector as other consumption is negligibly small. We include both, the useful energy consumption as well as the mileage per vehicle type in the JERICHO-E-usage dataset.

## Data Records

The JERICHO-E-usage dataset is available on https://doi.org/10.6084/m9.figshare.c.524545728 and visualized in an interactive tool on https://jericho-energy.de/e-usage. All data are spatially resolved at the NUTS2 level and temporally resolved in hours. The dataset includes 28 time series of useful energy and energy service consumption per NUTS2 region (see Table 3).

We provide the data separately for the four energy sectors: Residential, industrial, commerce, and mobility. We use the classification of AGEB5 for the useful energy consumption that comprises space heating, hot water, process heat, space cooling, process cooling, mechanical energy, information and communication, and light. For the mobility sector, we limit the useful energy consumption to mechanical energy as the consumption of all other useful energy types is negligibly small. We additionally provide the mileage profiles in spatio-temporal resolution for the following vehicle types: Passenger cars, motorcycles, trucks below 3.5 t, trucks above 3.5 t, semitrailer trucks, and other vehicles. All energy data has the unit kW, the mileage data has the unit km.

We provide the spatio-temporal data as separate files for each sector and energy type using a single-index shape (csv, xlsx) as well as in a single file using a multi-index shape (csv, xlsx). We use the year 2019 from the final energy consumption data of AGEB5 as our central source for the calculation. We, therefore, adjust the timestamps of our dataset to the year 2019. The hourly values are indexed by the Central European Time (Coordinated Universal Time + 1 (UTC+1)).

## Technical Validation

As described in the Methods section, our methodology includes multiple validations and scaling steps that ensure a high validity of our dataset. In the following, we perform additional spatial and temporal validation of our dataset.

### Spatial validation

We validate the regionalized useful energy consumption patterns against reported regional energy balances. Energy balances report on primary and final energy flows. Regional energy balances are available on the level of federal states in Germany (NUTS1). Accordingly, we aggregate our data from the NUTS2 to the NUTS1 level. For the residential, industrial, and commerce sectors, we compare the annual consumption for useful energy from our dataset to the annual consumption for useful energy that we calculate from the regional energy balances. For the mobility sector, our dataset is limited to mechanical energy. To have a more accurate validation for the mobility sector, we compare annual final energy consumption that we calculate from our dataset to annual consumption for final energy from the regional energy balances. We use data from the years 2016 and 2017, respectively, from four federal states for our validation as not all federal states report their energy balances with the required scope and at the same time. The selected federal states vary in terms of area and population density. The results of the validation are shown in Fig. 8. Numerical results for the validation can be found in the Supplementary Material.

For most regions and energy types, our dataset shows a relative deviation from the regional time series below 10% or below 20% accompanied by a small absolute deviation (marked in dark and light green). Most deviations can be found for heat consumption patterns. The deviations may stem from the time difference in the data we validate against as the most recent regional energy balances available are from 2016 and 2017.

### Temporal validation

To the best of our knowledge, there are no publicly available time series on useful energy consumption patterns on any spatial aggregation level. Therefore, we aggregate our regional time series of useful energy consumption to the NUTS0 level and translate them into final energy consumption time series. We then compare the results time series for electricity consumption to respective reported time series from entso-e29. The electricity consumption is reported by national transmission system operators. The reported time series are found to not fully depict the true consumption patterns as in particular industrial consumption is difficult to observe. As our consumption patterns include industrial profiles, we use further key figures to compare the peak and annual electricity consumption from entso-e30. The results are shown in Table 4.

It seems as if our dataset overestimates peak electricity consumption if only compared to the reported time series. When comparing the key figures for peak consumption we observe that our time series are close to the peak consumption reported by entso-e. The same result can be seen for annual consumption. If we account for the electricity consumption from the rail traffic of 11.5 TWh/a that is not included in our dataset the deviation to the reported annual consumption shrinks to 3.2 TWh/a. Overall, we conclude that our time series include additional information and can offer higher validity compared to aggregated reported time series due to their bottom-up nature.

## Usage Notes

### Applicability

Our JERICHO-E-usage dataset provides a starting point for appropriate data to account for energy consumption patterns in energy system analyses with high temporal and spatial resolution. For the spatial distribution of energy consumption, rather simplified distribution keys – such as the GDP per capita – are commonly used (see e.g. Robinius et al.31). Our data allows the derivation of substantially more reliable regional consumption patterns for the entire energy flows.

Figure 9 shows an exemplary case for passenger cars. Starting with the useful energy consumption (in our example mechanical energy for the mobility of passenger cars) and by reversing the energy flow, we derive the final energy consumption depending on the end-use technology and subsequently the primary energy consumption. Our example is based on the current regional fuel distribution among passenger cars. Systemic implications of different sector coupling pathways can now easily be analyzed by e.g., increasing the share of battery electric vehicles.

With increasing degrees of sector-coupling, analyses of infrastructure requirements become more relevant causing the need for input data both in high spatial and temporal resolution. Our dataset increases the range and accuracy of possible investigations. As demonstrated in Kockel et al.3, our data can serve as input to analyze infrastructure requirements that come with higher degrees of sector-coupling.

### Limitations

To evaluate the developed disaggregation method of useful energy consumption, Germany was used as an example. Partly, because a validation basis is available (see section Technical Validation) and partly because it is a highly interesting use case for analyzing sector coupling scenarios with its rapidly rising share of renewable energy in the power sector while lagging in the heat and mobility sectors. However, the approach and methodology can be transferred to other regions.

Due to the novel focus on disaggregated useful energy consumption, comparable data has not been published yet. Therefore, direct verification with other data is not possible. However, the data was calculated to final energy consumption and then validated in the section Technical Validation with existing data. For the spatial and temporal disaggregation, generalizations had to be made. For this, the applied combination of disaggregation factors and distribution keys was each justified and validated. The largest deviations compared to the validation data were found in the residential sector, in particular for space heating consumption. This is a common problem referred to as the performance gap due to occupant behavior in buildings32,33.

We use a broad variety of indicators for the temporal and spatial disaggregation of macro data. However, due to partially unavailable data, we rely on some critical assumptions such as standard load profiles for the commerce sector and a spatially homogeneous mobility requirement per vehicle type. Another limitation is that the data for the mobility sector only includes road traffic. Rail, air, and water transport have been excluded from the analysis as road transport accounts for the majority of energy consumption in the mobility sector (83%).

## Code availability

The code for compiling the time series of useful energy consumption and energy service profiles is published at https://github.com/FCN-ESE/JERICHO-E-usage34 under the open MIT license. Detailed instructions for using the code are included in the repository. All code is implemented in Python. For easy use of the scripts, we have added a Jupyter Notebook with further instructions on the workflow. The required input data, comprising pre-calculated data and data from official reports, are included with references.

## References

1. 1.

Morrison, R. Energy system modeling: Public transparency, scientific reproducibility, and open development. Energy Strategy Reviews 20, 49–63 (2018).

2. 2.

Manfren, M., Nastasi, B., Groppi, D. & Astiaso Garcia, D. Open data and energy analytics - An analysis of essential information for energy system planning, design and operation. Energy 213, 118803 (2020).

3. 3.

Kockel, C., Nolting, L., Priesmann, J. & Praktiknjo, A. Energy infrastructure for decarbonizing other energy sectors through renewable electricity – a spatio-temporal analysis from useful energy demand to renewable energy supply of sector coupling pathways based on the German case. ADBI Working Paper Series (2020).

4. 4.

Ruhnau, O., Bannik, S., Otten, S., Praktiknjo, A. & Robinius, M. Direct or indirect electrification? A review of heat generation and road transport decarbonisation scenarios for Germany 2050. Energy 166, 989–999 (2019).

5. 5.

AG Energiebilanzen e.V. (AGEB). Anwendungsbilanzen zur Energiebilanz Deutschland (Application balances for the energy balance Germany). 38, https://ag-energiebilanzen.de/index.php?article_id=29&fileName=ageb_19_v3.pdf (2020).

6. 6.

Fraunhofer ISI. Erstellung von Anwendungsbilanzen für die Jahre 2018 bis 2020 für die Sektoren Industrie und GHD (Preparation of application balances for the years 2018 to 2020 for the industry and tertiary sectors). https://ag-energiebilanzen.de/index.php?article_id=29&fileName=isi_anwendungsbilanz_industrie_2019_20200727.pdf (2020).

7. 7.

RWI. Erstellung der Anwendungsbilanzen 2019 für den Sektor der Privaten Haushalte und den Verkehrssektor in Deutschland (Preparation of the 2019 application balances for the private household sector and the transport sector in Germany). https://ag-energiebilanzen.de/index.php?article_id=29&fileName=rwi_anwendungsbilanz_2019__priv._hh_und_verkehr_.pdf (2020).

8. 8.

Heitkoetter, W., Medjroubi, W., Vogt, T. & Agert, C. Regionalised heat demand and power-to-heat capacities in Germany – An open dataset for assessing renewable energy integration. Applied Energy 259, 114161 (2020).

9. 9.

Robinius, M., Stein, F., ter, Schwane, A. & Stolten, D. A top-down spatially resolved electrical load model. Energies 10, 361 (2017).

10. 10.

DWD. Ortsgenaue Testreferenzjahre von Deutschland für mittlere, extreme und zukünftige Witterungsverhältnisse (Location-specific test reference years of Germany for average, extreme and future weather conditions). https://www.bbsr.bund.de/BBSR/DE/forschung/programme/zb/Auftragsforschung/5EnergieKlimaBauen/2013/testreferenzjahre/01-start.html?nn=2544408&cms_pos=2 (2017).

11. 11.

Verein Deutscher Ingenieure (VDI). Reference load profiles of single-family and multi-family houses for the use of CHP systems (VDI 4655). (2008).

12. 12.

IWU. Datenerhebung Wohngebäudebestand 2016 – Datenerhebung zu den energetischen Merkmalen und Modernisierungsraten im deutschen und hessischen Wohngebäudebestand (Data collection residential building stock 2016 - Data collection on energy characteristics and modernization rates in the German and Hessian residential building stock). http://wohngebaeudedaten2016.iwu.de/ (2018).

13. 13.

Statistische Ämter des Bundes und der Länder. Zensus 2011. https://www.zensus2011.de/DE/Home/Aktuelles/DemografischeGrunddaten.html?nn=3065474 (2011).

14. 14.

Paoli, L., Lupton, R. C. & Cullen, J. M. Useful energy balance for the UK: An uncertainty analysis. Applied Energy 228, 176–188 (2018).

15. 15.

OECD. Input-output tables 2018 edition. https://stats.oecd.org/Index.aspx?DataSetCode=IOTSI4_2018 (2018).

16. 16.

Statistische Ämter des Bundes und der Länder. Bruttoinlandsprodukt, Bruttowertschöpfung in den kreisfreien Städten und Landkreisen der Bundesrepublik Deutschland 1992 und 1994 bis 2018 (Gross Domestic Product, Gross Value Added in the Cities and Counties of the Federal Republic of Germany 1992 and 1994 to 2018). https://www.statistikportal.de/de/veroeffentlichungen/bruttoinlandsprodukt-bruttowertschoepfung-0 (2019).

17. 17.

DESTATIS. Klassifikation der Wirtschaftszweige (Classification of economic sectors). https://www.destatis.de/static/DE/dokumente/klassifikation-wz-2008-3100100089004.pdf (2019).

18. 18.

Eurostat. Gross value added by A*10 industry - selected international annual data. https://data.europa.eu/euodp/en/data/dataset/OHP2Ox9IDexf0YB74ZLK2g (2021).

19. 19.

Gobmaier, T. et al. Simulationsgestützte Prognose des elektrischen Lastverhaltens (Simulation-supported prognosis of the electrical load behavior). (Forschungsstelle für Energiewirtschaft e.V. (FfE), 2012).

20. 20.

Meier, H., Fünfgeld, C., Adam, T. & Schieferdecker, B. Repräsentative VDEW-Lastprofile (Representative VDEW load profiles). https://www.bdew.de/media/documents/1999_Repraesentative-VDEW-Lastprofile.pdf (1999).

21. 21.

Kraftfahrt-Bundesamt. Bestand an Kraftfahrzeugen und Kraftfahrzeuganhängern nach Zulassungsbezirken (Stock of motor vehicles and trailers by registration districts). https://www.kba.de/SharedDocs/Publikationen/DE/Statistik/Fahrzeuge/FZ/2020/fz1_2020_xlsx.xlsx;jsessionid=D5571CA908019E2209E00D84B3892814.live21301?__blob=publicationFile&v=8 (2020).

22. 22.

Kraftfahrt-Bundesamt. Verkehr in Kilometern - Inländerfahrleistung (Traffic in kilometers - national mileage). https://www.kba.de/DE/Statistik/Kraftverkehr/VerkehrKilometer/vk_inlaenderfahrleistung/vk_archiv/2019/verkehr_in_kilometern_kurzbericht_pdf.pdf?__blob=publicationFile&v=5 (2020).

23. 23.

SCB-ERP. Traffic data collected within the Project ‘Smart City Berlin Ernst Reuter Platz (SCB ERP)’. https://flow.dai-labor.de/datasets/ (2018).

24. 24.

Bundesanstalt für Straßenwesen. Automatische Straßenverkehrszählung. https://www.bast.de/BASt_2017/DE/Verkehrstechnik/Fachthemen/v2-verkehrszaehlung/Stundenwerte.html;jsessionid=F183E84B87DC756EECAC415D51A04E7A.live11313?nn=1819490 (2017).

25. 25.

AG Energiebilanzen e.V. (AGEB). Energy Balance for the Federal Republic of Germany 2018. (2020).

26. 26.

Kraftfahrt-Bundesamt. Bestand an Kraftfahrzeugen nach Umwelt-Merkmalen (Stock of motor vehicles by environmental characteristics). https://www.kba.de/SharedDocs/Publikationen/DE/Statistik/Fahrzeuge/FZ/2020/fz13_2020_pdf.pdf?__blob=publicationFile&v=6 (2020).

27. 27.

Notter, B. et al. HBEFA 4.1 Onlineversion des Handbuch Emissionsfaktoren des Strassenverkehrs (Online Version of the Handbook Emission Factors of Road Traffic) (2020).

28. 28.

Priesmann, J., Nolting, L., Kockel, C. & Praktiknjo, A. Time series of useful energy consumption patterns for energy system modeling. figshare https://doi.org/10.6084/m9.figshare.c.5245457 (2021).

29. 29.

entso-e. Transparency Platform. (2020).

30. 30.

31. 31.

Robinius, M. et al. Linking the power and transport sectors—Part 2: Modelling a sector coupling scenario for Germany. Energies 10, 957 (2017).

32. 32.

Zhang, Y., Bai, X., Mills, F. P. & Pezzey, J. C. V. Rethinking the role of occupant behavior in building energy performance: A review. Energy and Buildings 172, 279–294 (2018).

33. 33.

Hu, S., Yan, D., Azar, E. & Guo, F. A systematic review of occupant behavior in building energy policy. Building and Environment 175, 106807 (2020).

34. 34.

Priesmann, J., Nolting, L., Kockel, C. & Praktiknjo, A. JERICHO-E-usage data package. figshare https://doi.org/10.6084/m9.figshare.14045645.v1 (2021).

35. 35.

Bundesverband der Energie-und Wasserwirtschaft e.V (BDEW). Stromverbrauch in Deutschland nach Verbrauchergruppen 2019 (Electricity consumption in Germany by consumer group 2019). (2020).

36. 36.

Zweifel, P., Praktiknjo, A. & Erdmann, G. Energy Economics - Theory and Applications. (Springer Science+Business Media, 2017).

37. 37.

Länderarbeitskreis Energiebilanzen (LAK). Energy Balance for the Federal State of North Rhine-Westphalia 2016. (2021).

38. 38.

Länderarbeitskreis Energiebilanzen (LAK). Energy Balance for the Federal State of Berlin 2017. (2021).

39. 39.

Länderarbeitskreis Energiebilanzen (LAK). Energy Balance for the Federal State of Mecklenburg-Western Pomerania 2016. (2021).

40. 40.

Länderarbeitskreis Energiebilanzen (LAK). Energy Balance for the Federal State of Saxony 2016. (2021).

41. 41.

AG Energiebilanzen e.V. (AGEB). Auswertungstabellen zur Energiebilanz Deutschland - Daten für die Jahre von 1990 bis 2019 (Evaluation tables for the energy balance Germany - data for the years from 1990 to 2019). 38 (2020).

## Funding

Open Access funding enabled and organized by Projekt DEAL.

## Author information

Authors

### Contributions

J.P., L.N. and C.K. designed the approach, collected the data, developed the scripts, created the dataset, and wrote the initial draft of the manuscript. A.P. conzeptualized and designed the approach, supervised the project, and reviewed and edited the manuscript.

### Corresponding author

Correspondence to Aaron Praktiknjo.

## Ethics declarations

### Competing interests

The authors declare no competing interests.

Publisher’s note Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

## Rights and permissions

The Creative Commons Public Domain Dedication waiver http://creativecommons.org/publicdomain/zero/1.0/ applies to the metadata files associated with this article.

Reprints and Permissions

Priesmann, J., Nolting, L., Kockel, C. et al. Time series of useful energy consumption patterns for energy system modeling. Sci Data 8, 148 (2021). https://doi.org/10.1038/s41597-021-00907-w