Read one story based on this data with a regional focus on Africa here.
Read one story based on this data with a regional focus on Asia here.
This table holds the information on visa applications decided in German embassy offices around the world between 2014 and 2017.
The original source for the data is the German Federal Foreign Office who published the data in pdfs following a request from the opposition party "The Left" in the German national parliament.
In our analysis we focused on applications for visa in Germany (for study, work or family reunion for example), thus the below figures do not include visa for short term stays in the Schengen area.
The German Federal Foreign Office calculates the rejection rate based on the number of "processed" applications which includes granted, rejected and withdrawn requests. For our own analysis, we calculated the rejection rate differently: We introduced a new variable "decided applications" that equals the sum of all granted and all rejected applications that were filed in a specific local branch. The listed "share negative (%)" is calculated by dividing the number of rejected applications by the number of total decisions multiplied by 100.
Please note that the data refers to applications filed in a specific location/country and do not necessarily translate to the applicant's nationality. We assume that this is the case for the majority of applications, however not all countries have German embassies where visa applications can be made, so that applicants will have to file in another country.
Please note that country names and local branch names are in German, since the original document language is German.
For further information on sourcing, cleaning and analysing the data, please refer to this github repository for reference.
In case you have questions or find errors, we'd highly appreciate if you get in touch: design.data[at]dw[dot]com