1 Introduction

An important issue in the current German public and political discourse is the development of housing prices. Sharply increasing rent and purchasing prices, shortage of living space in urban areas and rural exodus are some of the discussed problems. Despite its topicality, few indices are available on the recent development of housing prices in Germany. To fill this gap, the RWI-GEO-REDX dataset quantifies regional differences in house purchase, apartment rent and purchase prices on the level of districts (Kreise, NUTS 3-level) and municipalities (Gemeindeverband, LAU 1-level) as well as labor market areas defined by RWI (2018).

The RWI-GEO-REDX combines a comprehensive up-to-date dataset and a hedonic price regression setup controlling for the property’s quality to capture various features of the sales and rent prices beyond the observation of average prices. We end up with regional price indices relative to the German mean capturing regional differences, the region-specific time trend as well as the national development over time.

The RWI-GEO-REDX covers indices for apartment purchase, house purchase and rental apartments. All three categories are available on labor market region, district and municipality level. All indices are published on a yearly basis. Additionally, the overall German trends are also available on a quarterly basis. The current version of the RWI-GEO-REDX is not only an update but also an extension to the first version as described in Klick and Schaffner (2019a). Apart from these additions, the applied original dataset RWI-GEO-RED was improved by imputations, so we gained more observations in all three property categories and regional units.

Section 2 gives a detailed decription of the data, in Section 3 the methodology of the real estate price indices is depicted. Thereafter, the analytic potential and some descriptive references are made in Section 4 and the data access is referred to in Section 5.

2 Data

We use the RWI-GEO-RED data (Boelmann et al. 2019a, 2019b, 2019c) of the Research Data Center Ruhr at RWI (FDZ Ruhr) to generate the price indices. It is based on real estate offers published on the largest German listing website ImmobilienScout24. It gives real estate owners and estate agents the opportunity to advertise their houses and apartments for a fee. All information is provided by the owner or the agent who sells or rents out the property, most also on a voluntarily basis. The original data ranges from January 2007 to March 2019 and entitles regional information below to the 1 km² grid level. Further, the data covers information on the size of the house or the apartment, on its facilities and features, additional costs as well as on energy consumption. For a more detailed description see Boelmann and Schaffner (2019).

Processed with the aim of coherence and comparability, the RWI-GEO-REDX dataset reflects differences between the properties that determine the monetary outcome in the selling and renting progression. To come as close as possible to the real market price of the property we include only the advertisements in their last month published. We restrict the price index to the years 2008 to February 2019 in the following, as there are only little observations in 2007 and to prevent a look ahead bias. Further information on excluded offers form the original dataset are described in the Appendix.

We compute the price indices for districts (Kreise; 402) and municipalities (Gemeindeverbände; 4,542) based on the regional definitions of 2015 (BKG 2016). As supplement we include labor market areas (Arbeitsmarktregionen) according to the delineation of version 1 in RWI (2018) as a third region type defining 182 areas. This delineation is beneficial to model real estate price indices as it follows the idea of accessibility of labor markets for commuters. The labor market borders are drawn from existing commuting interrelations and are, thus, a strong determinant for the residence decision. For a detailed description see RWI (2018).

3 Methodology

The regional price indices account for characteristics of the facility as well as for regional and time differences and is comparable to common hedonic price regressions (e. g. Sirmans et al. 2005) as applied for Germany in Bauer et al. (2013), for example.

To provide reasonable housing price developments three different models are estimated.

4 Descriptive evidence

The data contains a variety of indices that can be used in different types of analyses concerning regional price discrepancies. Figure 1 presents the development of the German real estate price indices δt, based on eq. (1). This figure displays the German wide quarterly price trend. Although the real estate price is the largest asset in the scheme of the consumer price index (19.6 %; Destatis 2019b), the prices for newly rented or sold apartments and houses outpaces the moderately increased consumer prices.

Figure 1:

Time development of the German price indices for house purchases, apartment rentals and apartment purchases change in percentage points to base quarter 2008q1, based on regression 1 on district level.

Figure 2 displays a depiction of regional house prices. Figure 2(a) shows especially high nominal increases in districts that are economically strong and densely populated. House prices among metropolitan regions seem to spread into adjacent districts and municipalities (Figure 2(b)). It becomes obvious which municipalities are part of the respective commuter belt of cities like Hamburg or Berlin since prices are almost as high as in the inner city.

Figure 2:

Regional price indices in 2018 on district level, municipality and labor market area level for house purchase as deviation in % from the German mean (a-c), Change in percentage points (d). Only regions with at least 50 observations in 2018, respectively in 2008 and 2018, are displayed. Indices in a, b, c base on cross-sectional regressions in eq. (2). Indices in d base on eq. (3).

However, the small regional level of municipalities comes at the cost of regional coverage. Particularly in Bavaria, municipalities (also unions of boroughs, Gemeindeverbände) are relatively small. It is only possible to derive price indices for these small municipalities at the cost of imprecision. Therefore, we display only price indices that rely on at least 50 advertisements per year. Although a large share of municipalities miss the threshold of 50 advertisements per year, these municipalities only cover about ten percent of the German population for house purchase, 35 % for apartment purchase (which is quite rare in rural areas) and 25 % for rental apartments between 2008 and 2018.

Figure 2(d) presents the development of housing prices between 2008 and 2018 on district level. It becomes apparent that most districts experienced no or only small nominal price increases that are below the consumer price development (light yellow and yellow) or increased only slightly above the consumer price index. The regional variation is quite in contrast to Figure 1 that implies a sharp price increase. However, this increase is mainly driven by some densely populated, high-priced regions e.g. Munich and its surroundings. These agglomerations influence immensely the German price trend due to the high share of population living there.

The RWI-GEO-REDX has its main potential for analyses in its regional components. Thus, it can be applied as control or identifying variable in a vast of potential analyses. Most other consumer goods do not vary regionally as much as housing costs. Furthermore, the latter is the main asset in the individual consumption, which makes them a good proxy for regional cost disparities. For example Bauer et al. (2019) use the RWI-GEO-REDX data for analyzing drivers of internal migration in Germany.

5 Data access

The data can be obtained as a Public Use File by the FDZ Ruhr. The FDZ Ruhr is the research data center at the RWI – Leibniz-Institute for Economic Research. The data is open for public use. To ensure that the indices are not driven by small sample size, the dataset only covers those indices that rely on at least 50 observations per year and region. Hence, the information is restricted for smaller municipalities. We also provide the indices that base on less than 50 observations per year and region as Scientific Use File upon request for scientific research only. Since the RWI-GEO-REDX subsumes aggregated information it does not contain information with restricted use due to data security. The presented indices can be obtained as an Excel (.xlsx) file.

Data access does not require a data use agreement, but users need to register for data access. Interested users should register via email to fdz@rwi.essen.de. The email needs to include information on the applying department or person as well as the desired data format. The users are requested to cite the source correctly and to inform the FDZ Ruhr about publications with the data.

When using the dataset RWI-GEO-REDX, please cite the data as Klick, Schaffner, RWI, and ImmobilienScout24 (2019): RWI-GEO-REDX: Regional Real Estate Price Index for Germany, 2008-02/2019. Version: 2. RWI – Leibniz Institute for Economic Research. Dataset. http://doi.org/10.7807/immo:redx:v3. Further, we recommend citing this data description.