Skip to main content

Dataset: a social accounting matrix for Germany

Abstract

Objectives

The Social Accounting Matrix (SAM) is an extension of Input-Output tables that records macro and meso-economic accounts of a socio-economic system. Its main objective is to provide a comprehensive understanding of the interrelationships among different economic sectors and agents. The SAM can be used for various purposes, including economic analysis, policy evaluation, and economic modelling. It allows policymakers to make more informed decisions, understand potential consequences of different policy options and serve as the foundation for constructing Computable General Equilibrium (CGE) models.

Data description

The SAM for Germany is a comprehensive source of data that reveals the incomes and expenditures of 163 different production sectors, along with data on factors of production, households, corporations, government, and external accounts with the rest of the world. Additionally, it provides information on gross fixed capital formation, changes in inventories, and natural capital accounts. This SAM was compiled by extending the EXIOBASE Input-Output (IO) accounts with data from the Federal Statistical Office of Germany. Balancing items were also used to ensure that the Total Income and Total Expenditure of the main transactors are in balance.

Peer Review reports

Objective

The SAM is an extension of IO tables that records macro and meso-economic accounts of a socio-economic system [1]. Unlike IO tables, the SAM records flows from producing sectors to factors of production, institutional accounts, and then back to the demand for goods, and so it can improve upon the Type II IO multiplier [2]. Additionally, the SAM contains complete information on institutional accounts such as households, government, and corporations, while IO tables only trace income and expenditure flows associated with the production of commodities [3].

The SAM offers added value by serving various purposes, including economic analysis, policy evaluation, and economic modelling [1, 3, 4]. Specifically, it provides a comprehensive overview of the structure of the German economy and highlights the relationships among different sectors and economic agents, allowing for a more complete understanding of the economy. The SAM can also be used to assess the potential impacts of various economic policies related to income distribution, employment, and economic growth, assisting policymakers in making more informed decisions and understanding the potential consequences of different policy options. Moreover, the SAM serves as foundational data for constructing computable general equilibrium (CGE) models, which assist in understanding how the economy might respond to different policy changes or external shocks.

In other words, the SAM provides a comprehensive framework that allows policymakers and researchers to better identify interrelationships among different economic sectors and agents. The significance of this kind of data is demonstrated in recent studies, where it has been employed to evaluate the socio-economic consequences of climate change-induced water scarcity [5], and to identify the system-wide impacts of labour-augmenting technological change [6], for example.

Data description

Table 1 gives an overview of data files. The file DE_SAM_2020_IXI.xlsx gives the SAM for Germany, whilst the file DE_SAM_OVERVIEW.xlsx outlines the structure and dimensions of the SAM. The SAM includes information on the incomes and expenditures that take place within the German economy. It includes data on 163 production sectors (activities), factors of production (LAB and CAP), indirect business taxes (IBT), households (HH), corporations (FIRMS), and government (GOV). Additionally, it provides details on gross fixed capital formation (KFOR), changes in inventories (STOCK), as well as the external accounts with the rest of the world (ROW). The capital accounts are divided into subcategories based on water and land resources to create the natural capital accounts. The data are presented in a 173 × 173 square matrix format and are provided in a single worksheet. All figures are reported in billions of euros for the year 2020, although the data were compiled for other years, but these are not included in this listing.

The compilation of the SAM follows the approach outlined in Emonts-Holley, et al. [7], where it was first applied for Scotland and then later for the UK. This approach allows for complete incorporation of national/regional IO accounts. That is, the Activities accounts include all the relevant parts of the EXIOBASE Input-Output [8] accounts, without any modifications made during the balancing or compilation process. In other words, these data are presented exactly as they are in the original source.

The SAM is formed by extending the EXIOBASE IO [8] accounts with data from DESTATIS [9]. Remaining entries are balancing items (or the sum of entries). As outlined in Emonts-Holley, et al. [7], balancing items are used to ensure that the Total Income and Total Expenditure of the main transactors are in balance. For example, the Household and Government accounts have control totals (from DESTATIS), which require manual balancing to ensure that total income is equal to total expenditure. Generally, balancing items are imposed on cells with the least robust data availability or quality. Via this data entry and balancing, a square SAM is produced where in each account the incomes are equal to the expenditures.

Table 1 Overview of data files/data sets

The structure of the SAM presented in Table 2outlines its dimensions and data sources, as denoted by superscripts. Specifically, the superscripts B, D, and E signify the sources and data processing methods used in the SAM. The SAM incorporates data from multiple secondary sources, such as DESTATIS [9] (superscript D), EXIOBASE [8] (superscript E), and balancing items (superscript B). This tabulated structure aids researchers in gaining clearer insights into the foundational data and its compilation process.

Table 2 Structure of the social accounting matrix for Germany

Limitations

One of the main advantages of the method proposed by Emonts-Holley, et al. [7], which was employed in the creation of the SAM for Germany, is that is that it keeps the underlying IO table unchanged. This allows for the inclusion of official and published data without modifications. In cases where data are unavailable, balancing items are used to ensure that total income aligns with total expenditure. Nevertheless, a disadvantage of this approach is that the balancing item entries may lack precision. This issue can be mitigated by integrating more accurate data whenever they become available. Therefore, data are updated whenever possible, while ensuring that the fundamental structure of the SAM, as outlined in Table 2, remains intact.

Data availability

The data described in this Data note can be freely and openly accessed on Zenodo under https://doi.org/10.5281/zenodo.7804529. Please see Table 1 and [10] for details and links to the data.

Abbreviations

CGE:

Computable General Equilibrium

EXIOBASE:

Multi-Regional Environmentally Extended Input-Output Table

IO:

Input-Output

SAM:

Social Accounting Matrix

References

  1. Pyatt G, Round JI. Social accounting matrices for development planning. Rev Income Wealth. 1977;23(4):339–64. https://doi.org/10.1111/j.1475-4991.1977.tb00022.x.

    Article  Google Scholar 

  2. Emonts-Holley T, Ross A, Swales K. Estimating induced effects in IO impact analysis: variation in the methods for calculating the type II leontief multipliers. Econ Syst Res. 2021;33(4):429–45. https://doi.org/10.1080/09535314.2020.1837741.

    Article  Google Scholar 

  3. Pyatt G. Fundamentals of Social Accounting. Econ Syst Res. 1991;3(3):315–41. https://doi.org/10.1080/09535319100000024.

    Article  Google Scholar 

  4. Miller RE, Blair PD. Input-output analysis: foundations and extensions. 2 ed. Cambridge: Cambridge University Press; 2009. https://doi.org/10.1017/CBO9780511626982.

    Book  Google Scholar 

  5. Ross AG, Connolly K, Vögele S, Kuckshinrichs W. A macro-level analysis of the socio-economic impacts of climate change driven water scarcity: incorporating behavioural and resilience aspects. Water Res X. 2024;23:100223. https://doi.org/10.1016/j.wroa.2024.100223.

    Article  CAS  Google Scholar 

  6. Ross AG, McGregor PG, Swales JK. Labour market dynamics in the era of technological advancements: the system-wide impacts of labour augmenting technological change. Technol Soc. 2024;77:102539. https://doi.org/10.1016/j.techsoc.2024.102539.

    Article  Google Scholar 

  7. Emonts-Holley T, Ross A, Swales J. A social accounting matrix for Scotland. Fraser Allander Economic Commentary. 2014;38(1):84–93. https://strathprints.strath.ac.uk/id/eprint/48626.

    Google Scholar 

  8. Stadler K, Wood R, Bulavskaya T, Södersten C-J, Simas M, Schmidt S, Usubiaga A, Acosta-Fernández J, Kuenen J, Bruckner M, Giljum S, Lutter S, Merciai S, Schmidt JH, Theurl MC, Plutzar C, Kastner T, Eisenmenger N, Erb K-H, de Koning A, Tukker A. EXIOBASE 3: developing a Time Series of detailed environmentally extended multi-regional input-output tables. J Ind Ecol. 2018;22(3):502–15. https://doi.org/10.1111/jiec.12715.

    Article  Google Scholar 

  9. DESTATIS, German Federal Statistical Office National Accounts. (2022) https://www.destatis.de/EN/Themes/Economy/National-Accounts-Domestic-Product/_node.html. (Accessed 28.03.2023).

  10. Connolly K, Ross A, Vögele S. Dataset: a Social Accounting Matrix for Germany, 2023. https://doi.org/10.5281/zenodo.7804529

Download references

Acknowledgements

This research draws on work from Ross’ PhD thesis, which was jointly funded by the Economic and Social Research Council and the Scottish Government [ES/J500136/1]. During the preparation of this work the authors used OpenAI solely to improve readability. After using this tool, the authors reviewed and edited the content as needed and take full responsibility for the content of the publication. We would like to thank the anonymous reviewer for their helpful comments.

Funding

This work was supported in part by the Helmholtz Association under the program “Energy System Design”.

Open Access funding enabled and organized by Projekt DEAL.

Author information

Authors and Affiliations

Authors

Contributions

KC & AR: Conceptualization, Methodology, Data curation, Writing- Reviewing and Editing. SV: Writing- Reviewing and Editing.

Corresponding author

Correspondence to Andrew Ross.

Ethics declarations

Ethics approval and consent to participate

Not applicable.

Consent for publication

Not applicable.

Competing interests

The authors declare no competing interests.

Additional information

Publisher’s note

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

Rights and permissions

Open Access This article is licensed under a Creative Commons Attribution 4.0 International License, which permits use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons licence, and indicate if changes were made. The images or other third party material in this article are included in the article’s Creative Commons licence, unless indicated otherwise in a credit line to the material. If material is not included in the article’s Creative Commons licence and your intended use is not permitted by statutory regulation or exceeds the permitted use, you will need to obtain permission directly from the copyright holder. To view a copy of this licence, visit http://creativecommons.org/licenses/by/4.0/.

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Connolly, K., Ross, A. & Vögele, S. Dataset: a social accounting matrix for Germany. BMC Res Notes 17, 262 (2024). https://doi.org/10.1186/s13104-024-06925-2

Download citation

  • Received:

  • Accepted:

  • Published:

  • DOI: https://doi.org/10.1186/s13104-024-06925-2

Keywords