Name: Schengen Visa Statistics
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Schengen Visa Statistics

Dataset Overview

Context

While the general application process and fees for Schengen visas are standardized, the implementation of these rules varies by country. Obtaining a long-term multiple-entry visa is advantageous as it requires the same effort but can be used for multiple trips, saving both time and money. Visa-shopping, where applicants select specific consulates to increase their chances of obtaining a visa or a higher-tier visa, is a common practice. To evaluate the validity of this practice, an analysis of real data is essential. This dataset provides the necessary information.

Content

This dataset contains comprehensive visa statistics for all States fully applying the Schengen acquis and their consulates in third countries. Data is presented in bulk, but filters on the top row allow for refined searches. For instance, users can filter data by Member State/Associated country, specific third countries, or specific locations (cities) in third countries.

Types of Visas

Airport Transit Visas (ATVs): Allow transit through the international transit area of airports in Member States without entering the territory. These visas can be for single or multiple transits.
Short Stay Visas:
- Uniform Short Stay Visas: Valid for stays up to 90 days within a 180-day period across all Member States. These visas can be issued for single or multiple entries.
- Limited Territorial Validity Visas (LTV): Valid only in the territory of specific Member States.

Acknowledgements

This data was provided by the European Commission in accordance with the Visa Code, Article 46, and Annex XII. The data for Bulgaria, Croatia, and Romania pertains to national visas.

Inspired by Schengen Visa Stats 2017/2018 by ma7555

Inspiration for Analysis

Identify which consulates in each country are more generous.
Determine which Schengen States are generally more generous.
Find the strictest consulate.
Explore many other insights possible with this dataset.

This version aims to be more concise and clearer, making it easier to understand the context, content, and potential uses of the dataset.

Tables

Schengen Data

@kaggle.marinazmieva_schengen_visa_data.schengen_data

827.79 kB
18,306 rows
20 columns

CREATE TABLE schengen_data (
  "schengen_state" VARCHAR,
  "country_where_consulate_is_located" VARCHAR,
  "consulate" VARCHAR,
  "airport_transit_visas_atvs_applied_for" DOUBLE  -- Airport Transit Visas (ATVs) Applied For,
  "n__atvs_issued_including_multiple" DOUBLE  -- ATVs Issued (including Multiple),
  "multiple_atvs_issued" DOUBLE,
  "atvs_not_issued" DOUBLE,
  "not_issued_rate_for_atvs" DOUBLE,
  "uniform_visas_applied_for" DOUBLE,
  "total_uniform_visas_issued_including_mev" DOUBLE  -- Total Uniform Visas Issued (including MEV),
  "multiple_entry_uniform_visas_mevs_issued" DOUBLE  -- Multiple Entry Uniform Visas (MEVs) Issued,
  "share_of_mevs_on_total_number_of_uniform_visas_issued" DOUBLE,
  "total_ltvs_issued" DOUBLE,
  "uniform_visas_not_issued" DOUBLE,
  "not_issued_rate_for_uniform_visas" DOUBLE,
  "total_atvs_and_uniform_visas_applied_for" DOUBLE,
  "total_atvs_and_uniform_visas_issued_including_multiple_aefa2845" DOUBLE  -- Total ATVs And Uniform Visas Issued (including Multiple ATVs, MEVs And LTVs),
  "total_atvs_and_uniform_visas_not_issued" DOUBLE,
  "not_issued_rate_for_atvs_and_uniform_visas" DOUBLE,
  "year" BIGINT
);