German Visa Appointment Dataset

1 German Visa Appointment Dataset V 1.0 Emanuel Deutschmann*,a,b, Lorenzo Gabriellic, Alexandra Orlovad, Niklas Harderd, Ettore Recchib,e * Corresponding author: [email protected] a Europa-Universität Flensburg, Germany b Migration Policy Centre, European University Institute, Italy c Istituto di Scienza e Tecnologie dell’Informazione, Consiglio Nazionale delle Ricerche, Pisa, Italy d German Centre for Integration and Migration Research (DeZIM), Germany e Centre for Research on Social Inequalities, Sciences Po Paris, France This dataset emerged from a collaboration between DeZIM and the Global Mobilities Project at the European University Institute. If you use this dataset, please cite our corresponding study: Deutschmann, E., L. Gabrielli, A. Orlova, N. Harder & E. Recchi. 2025. A Time Penalty for the Global South? Visa Appointment Wait Times at German Embassies and Consulates Worldwide. Political Geography. https://doi.org/10.1016/j.polgeo.2025.103440 2 The package consists of three different datasets: 1. The Individual-Request-Level Data Files: GermanVisaAppointmentDataset_IndividualRequestLevelData.dta GermanVisaAppointmentDataset_IndividualRequestLevelData.xlsx Table 1. Variable description for the individual-request-level dataset Variable name Description id Unique case ID embassy City where the diplomatic mission is based country Country where the diplomatic mission is based country_name_short Shorter country name iso3 ISO 3 country code visa_type Visa type visa_subtype Visa subtype long_short_term Simple categorization of the visa type into short-term, longterm, or mixed/unknown closest_available_date The date of the closest available visa appointment, missings are “Not available” date_of_date2 The date of the closest available visa appointment, alternative date format, missings are “.” (Stata) date_of_date3 The date of the closest available visa appointment, alternative date format, missings are “.” (Stata) date_of_request The date of the query/request date_of_request2 The date of the query/request, alternative date format date_of_request3 The date of the query/request, alternative date format dow_request The day of the week of the request dow_available_date The day of the week of the closest available appointment days The wait time in days, missings are “999” days_999missing The wait time in days, missings are “.” (Stata) days_999to120 The wait time in days, missings are “120” (only used to create Supplementary Figure S3, not suited for general usage) days_binary Binary variable that captures whether an appointment was available (1), or not (0). 3 2. The Country-Level Data Files: GermanVisaAppointmentDataset_CountryLevelData.dta GermanVisaAppointmentDataset_CountryLevelData.xlsx Table 2. Variable description for the country-level dataset Variable name Description country_name_short Country name iso3 ISO 3 country code share_with_available_date Share of requests that resulted in an available date for a visa appointment average_wait_time_in_days Average wait time (in days) between the date of the request and the date of the closest available visa appointment 3. The Replication Files Files: GermanVisaAppointmentDataset_ReplicationFile.dta PoliticalGeographyArticle_replication_dofile.do This version of the data contains additional macro-level variables from other sources. The do file can be used in combination with this dataset to replicate the tables, figures and analyses from the Political Geography article.