Airline

Airline

Airline on-time data are reported each month to the U.S. Department of Transportation (DOT), Bureau of Transportation Statistics (BTS) by the 16 U.S. air carriers that have at least 1 percent of total domestic scheduled-service passenger revenues, plus two other carriers that report voluntarily. The data cover nonstop scheduled-service flights between points within the United States (including territories) as described in 14 CFR Part 234 of DOT's regulations. Data are available since January 1995.

Original source: www.transtats.bts.gov

Versions

  • Airline (by Jan Motl)

Dataset details

Associated task:
Classification
Domain:
Retail
Data types:
Size:
464.5 MB
Count of tables:
19
Count of rows:
469,657
Count of columns:
119
Missing values:
No
Compound keys:
No
Loops:
Yes
Type:
Real
Instance count:
434,496
Target table:
On_Time_On_Time_Performance_2016_1
Target column:
ArrDel15
Target ID:
?
Target timestamp:
FlightDate

How to download the dataset

The datasets are publicly available directly from MySQL database.

  1. Open your favourite MySQL client (for example MySQL Workbench)
  2. Use following credentials:
    • hostname: relational.fit.cvut.cz
    • port: 3306
    • username: guest
    • password: relational
  3. Export "Airline" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).