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:
455.5 MB
Count of tables:
19
Count of rows:
448,156
Count of columns:
119
Missing values:
Yes
Compound keys:
No
Loops:
Yes
Type:
Real
Instance count:
413,046
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 MariaDB database.

  1. Open your favourite MariaDB client (MySQL Workbench works, but see FAQ)
  2. Use following credentials:
    • hostname: db.relational-data.org
    • 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).