Schengen Visa Statistics

analyze data to get insights into travel and migration

@kaggle.marinazmieva_schengen_visa_data

Table List

1 table(808.39 KB)

Schengen Data

@kaggle.marinazmieva_schengen_visa_data.schengen_data

808.39 KB
18306 rows
20 columns

schengen_state Schengen State	country_where_consulate_is_located Country Where Consulate Is Located	consulate Consulate	airport_transit_visas_atvs_applied_for Airport Transit Visas (ATVs) Applied For	n__atvs_issued_including_multiple ATVs Issued (including Multiple)	multiple_atvs_issued Multiple ATVs Issued	uniform_visas_applied_for Uniform Visas Applied For	total_uniform_visas_issued_including_mev Total Uniform Visas Issued (including MEV)	multiple_entry_uniform_visas_mevs_issued Multiple Entry Uniform Visas (MEVs) Issued	share_of_mevs_on_total_number_of_uniform_visas_issued Share Of MEVs On Total Number Of Uniform Visas Issued	total_ltvs_issued Total LTVs Issued	uniform_visas_not_issued Uniform Visas Not Issued	not_issued_rate_for_uniform_visas Not Issued Rate For Uniform Visas	total_atvs_and_uniform_visas_applied_for Total ATVs And Uniform Visas Applied For	total_atvs_and_uniform_visas_issued_including_multiple_aefa2845 Total ATVs And Uniform Visas Issued (including Multiple ATVs, MEVs And LTVs)	total_atvs_and_uniform_visas_not_issued Total ATVs And Uniform Visas Not Issued	not_issued_rate_for_atvs_and_uniform_visas Not Issued Rate For ATVs And Uniform Visas	year Year
Austria	ALBANIA	TIRANA				73	64	57	0.890625	2	7	0.0958904109589041	73	66	7	0.0958904109589041	2023
Austria	ALGERIA	ALGIERS				1953	1009	684	0.6778989098116948	7	937	0.4797747055811572	1953	1016	937	0.4797747055811572	2023
Austria	ARGENTINA	BUENOS AIRES				13	13	12	0.9230769230769232				13	13			2023
Austria	AUSTRALIA	CANBERRA	2	2	2	3638	3583	3579	0.9988836170806586		55	0.0151181968114348	3640	3585	55	0.0151098901098901	2023
Austria	AZERBAIJAN	BAKU				2676	2610	2467	0.9452107279693488	4	62	0.023168908819133	2676	2614	62	0.023168908819133	2023
Austria	BOSNIA AND HERZEGOVINA	SARAJEVO				1735	1368	1357	0.9919590643274854	345	22	0.0126801152737752	1735	1713	22	0.0126801152737752	2023
Austria	BRAZIL	BRASILIA				36	13	7	0.5384615384615384	23			36	36			2023
Austria	BULGARIA	SOFIA				533	509	495	0.9724950884086444	10	14	0.0262664165103189	533	519	14	0.0262664165103189	2023
Austria	CANADA	OTTAWA				1018	989	106	0.1071789686552072	10	19	0.018664047151277	1018	999	19	0.018664047151277	2023
Austria	CHILE	SANTIAGO DE CHILE				23	21	15	0.7142857142857143	1	1	0.0434782608695652	23	22	1	0.0434782608695652	2023


CREATE TABLE schengen_data (
  "schengen_state" VARCHAR,
  "country_where_consulate_is_located" VARCHAR,
  "consulate" VARCHAR,
  "airport_transit_visas_atvs_applied_for" DOUBLE,
  "n__atvs_issued_including_multiple" DOUBLE,
  "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,
  "multiple_entry_uniform_visas_mevs_issued" DOUBLE,
  "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_not_issued" DOUBLE,
  "not_issued_rate_for_atvs_and_uniform_visas" DOUBLE,
  "year" BIGINT
);