European Flights Dataset
European Commercial Flights Dataset from 2016 to 2022
@kaggle.umerhaddii_european_flights_dataset
Loading...
Loading...
Loading...
Loading...
About this Dataset
European Flights Dataset
Context
The European Flights Dataset from 2016 to 2022 provides an extensive record of air traffic activities across various European airports. The data includes essential metrics related to IFR (Instrument Flight Rules) movements, covering both departures and arrivals as reported by the Network Manager and Airport Operator. The dataset is comprehensive, with 688,099 entries and 14 columns, detailing flights over a span of seven years.
Content
Geography: Europe
Time period: Jan 2016- May 2022
Unit of analysis: European Flights Dataset
Variables
| Column Name | Description | Example |
|---|---|---|
| YEAR | Reference year | 2014 |
| MONTH_NUM | Month (numeric) | 1 |
| MONTH_MON | Month (3-letter code) | JAN |
| FLT_DATE | Date of flight | 01-Jan-2014 |
| APT_ICAO | ICAO 4-letter airport designator | EDDM |
| APT_NAME | Airport name | Munich |
| STATE_NAME | Name of the country in which the airport is located | Germany |
| FLT_DEP_1 | Number of IFR departures | 278 |
| FLT_ARR_1 | Number of IFR arrivals | 241 |
| FLT_TOT_1 | Number total IFR movements | 519 |
| FLT_DEP_IFR_2 | Number of IFR departures | 278 |
| FLT_ARR_IFR_2 | Number of IFR arrivals | 241 |
| FLT_TOT_IFR_2 | Number total IFR movements | 519 |
Acknowledgements
Datasource: Aviation Intelligence Unit Portal
Inspiration: Commercial air transport in August 2021: in recovery
Tables
Flights
@kaggle.umerhaddii_european_flights_dataset.flights
- 4.48 MB
- 688,099 rows
- 14 columns
Loading...
Loading...
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
);