European Flights Dataset

European Commercial Flights Dataset from 2016 to 2022

@kaggle.umerhaddii_european_flights_dataset

Table List

1 table(4.27 MB)

Flights

@kaggle.umerhaddii_european_flights_dataset.flights

4.27 MB
688099 rows
14 columns

year YEAR	month_num MONTH NUM	month_mon MONTH MON	flt_date FLT DATE	apt_icao APT ICAO	apt_name APT NAME	state_name STATE NAME	flt_dep_1 FLT DEP 1	flt_arr_1 FLT ARR 1	flt_tot_1 FLT TOT 1	flt_dep_ifr_2 FLT DEP IFR 2	flt_arr_ifr_2 FLT ARR IFR 2	flt_tot_ifr_2 FLT TOT IFR 2	pivot_label Pivot Label
2016	1	JAN	2016-01-01T00:00:00Z	EBAW	Antwerp	Belgium	4	3	7				Antwerp (EBAW)
2016	1	JAN	2016-01-01T00:00:00Z	EBBR	Brussels	Belgium	174	171	345	174	161	335	Brussels (EBBR)
2016	1	JAN	2016-01-01T00:00:00Z	EBCI	Charleroi	Belgium	45	47	92	45	45	90	Charleroi (EBCI)
2016	1	JAN	2016-01-01T00:00:00Z	EBLG	Liège	Belgium	6	7	13				Liège (EBLG)
2016	1	JAN	2016-01-01T00:00:00Z	EBOS	Ostend-Bruges	Belgium	7	7	14				Ostend-Bruges (EBOS)
2016	1	JAN	2016-01-01T00:00:00Z	EDDB	Berlin - Brandenburg	Germany	98	99	197				Berlin - Brandenburg (EDDB)
2016	1	JAN	2016-01-01T00:00:00Z	EDDC	Dresden	Germany	18	21	39				Dresden (EDDC)
2016	1	JAN	2016-01-01T00:00:00Z	EDDE	Erfurt	Germany	1	1	2				Erfurt (EDDE)
2016	1	JAN	2016-01-01T00:00:00Z	EDDF	Frankfurt	Germany	401	341	742	401	306	707	Frankfurt (EDDF)
2016	1	JAN	2016-01-01T00:00:00Z	EDDG	Muenster-Osnabrueck	Germany	3	4	7				Muenster-Osnabrueck (EDDG)


CREATE TABLE flights (
  "year" BIGINT,
  "month_num" BIGINT,
  "month_mon" VARCHAR,
  "flt_date" VARCHAR,
  "apt_icao" VARCHAR,
  "apt_name" VARCHAR,
  "state_name" VARCHAR,
  "flt_dep_1" BIGINT,
  "flt_arr_1" BIGINT,
  "flt_tot_1" BIGINT,
  "flt_dep_ifr_2" DOUBLE,
  "flt_arr_ifr_2" DOUBLE,
  "flt_tot_ifr_2" DOUBLE,
  "pivot_label" VARCHAR
);