flights_3m
U.S. flight delays and routes (3 million flights)
Flight delay statistics (3 million rows) from U.S. Bureau of Transportation Statistics.
Collected under regulatory reporting requirements (14 CFR Part 234), which mandate
that qualifying airlines report on-time performance data to BTS. Transformed using
/scripts/flights.py
Parquet 3,000,000 rows 5 fields 13 MB
Fields
| Field | Type | Distribution | Summary | Missing |
|---|---|---|---|---|
dateAdd a description for date | datetime%Y/%m/%d %H:%M | Jan 1, 2001, 12:01 AM – Jul 1, 2001 | Missing 0 | |
delayAdd a description for delay | integer | -1,116 – 1,688 · mean 6.67 | Missing 0 | |
distanceAdd a description for distance | integer | 21 – 4,962 · mean 731.6 | Missing 0 | |
originAdd a description for origin | string | 229 distinct | ORD 166,341 · DFW 157,162 · ATL 124,711 | Missing 0 |
destinationAdd a description for destination | string | 228 distinct | ORD 165,573 · DFW 156,515 · ATL 124,232 | Missing 0 |
Profiled across all 3,000,000 rows. No field descriptions yet. Add them
Preview
| date | delay | distance | origin | destination |
|---|---|---|---|---|
| 2001-01-01T00:01:00 | 33 | 2176 | LAS | PHL |
| 2001-01-01T00:01:00 | 19 | 215 | ATL | SAV |
| 2001-01-01T00:01:00 | 14 | 405 | MCI | MDW |
| 2001-01-01T00:01:00 | -13 | 2345 | ANC | LAX |
| 2001-01-01T00:01:00 | 1 | 75 | RIC | ORF |
Scroll sideways for all 5 fields.
Examples
Not yet seen in any gallery.
This dataset is published and documented but no Vega, Vega-Lite or Altair example uses it. A new example would be a welcome contribution.
Provenance
- Source
- License
- File
data/flights-3m.parquet· 13,493,022 bytes · View on GitHub