Caution
The Federal Statistical Office of Germany (DESTATIS) will discontinue the old API endpoint currently used by this R package, which means the package will stop working for genesis.destatis.de in mid-2025. The old API endpoints for the other databases—regionalstatistik.de, bildungsmonitoring.de, and landesdatenbank.nrw.de—will also be shut down in the near future. There are no plans to update this package to support the new API endpoints, so users are encouraged to switch to the R package restatis which provides similar functionality compared to wiesbaden and uses the modern API endpoints.
Since 2016 the R package wiesbaden provides functions to directly retrieve data from databases maintained by the Federal Statistical Office of Germany (DESTATIS) in Wiesbaden. The package uses the SOAP XML web service from DESTATIS (PDF Documentation).
Access to the following databases is implemented:
- regionalstatistik.de
- genesis.destatis.de
- bildungsmonitoring.de
- landesdatenbank.nrw.de
statistikdaten.bayern.de(data retrieval API disabled)genesis.sachsen-anhalt.de(data retrieval API disabled)statistik.sachsen.de(API disabled)ergebnisse.zensus2022.de(not implemented)
Note, to access any of the databases using this package, you need to register on the respective website to get a personal login name and password. The registration is free.
You can install the package directly from CRAN:
install.packages("wiesbaden")Or install the latest version from Github using:
remotes::install_github("sumtxt/wiesbaden", force=TRUE)The package helps with retrieving the data cubes which are used to construct the data tables available as csv files via the web application of each database. The data cubes are long format data tables that are much easier to process as compared to the csv files. For details on how to use the package: Getting Started
with wiesbaden.
The package also helps with importing the German municipality register files via the function read_gv100(). For more information see the help file of this function.
Users that wish to work with the csv files might find the download_csv() and read_header_genesis() in this package helpful. The former can be used to automate downloads and the latter facilitates importing downloaded files. Users might also wish to check the R package destatiscleanr github.com/cutterkom/destatiscleanr.
-
Does this package work with a proxy? Yes. Set the proxy globally before calling any package command, e.g.:
httr::set_config(httr::use_proxy( "your.proxy", port = 1234, auth = "basic")) data <- retrieve_data(tablename="14111KJ002", genesis=c(db="regio"))
-
The R package
destatiscleanrgithub.com/cutterkom/destatiscleanr provides functions to help importingcsvfiles downloaded via the web application. -
The R package
restatiscorrelaid.github.io/restatis/ provides similar functions to access genesis.destatis.de, regionalstatistik.de and the Zensus 2022. -
The R package
bonngithub.com/sumtxt/bonn provides functions to retrieve data from the INKAR database maintained by the Federal Office for Building and Regional Planning (BBSR) in Bonn. -
The R package
AGSgithub.com/sumtxt/ags provides functions to work with the Amtlicher Gemeindeschlüssel (AGS), e.g. construct time series of statistics for Germany's municipalities and districts. -
The Python packages github.com/WZBSocialScienceCenter/gemeindeverzeichnis and rohablog.wordpress.com/2011/11/22/gv100-parser-python/ provide functions to read the GV100 format.
-
The node.js package https://github.com/yetzt/node-gv100json provides functions to read the GV100 format.
-
The Python package github.com/pudo/regenesis provides a function to bulk download data from regionalstatistik.de.