librown/us-dot-flight-delays-2015
US DOT Flight Delays — 2015 (Parquet Version) This dataset contains 5,819,079 records of commercial flights in the United States during 2015.It has been converted to Parquet for efficient analytics in Python, DuckDB, Ibis, Spark, and Polars. Files included flights.parquet (main fact table) airlines.parquet (carrier info) airports.parquet (airport geolocation & metadata) cancellation_codes.parquet (mapping table) Source U.S. Department of… See the full description on the dataset page: https://huggingface.co/datasets/librown/us-dot-flight-delays-2015.
US DOT Flight Delays — 2015 (Parquet Version)
This dataset contains 5,819,079 records of commercial flights in the United States during 2015. It has been converted to Parquet for efficient analytics in Python, DuckDB, Ibis, Spark, and Polars.
Files included
- flights.parquet (main fact table)
- airlines.parquet (carrier info)
- airports.parquet (airport geolocation & metadata)
- cancellation_codes.parquet (mapping table)
Source
U.S. Department of Transportation — Bureau of Transportation Statistics Public Domain (U.S. Government Work)
Original dataset: https://www.transtats.bts.gov/
Notes
- Original data downloaded from the U.S. DOT (via Maven Analytics frontend).
- This version is provided as a Parquet file for efficient loading in Python, DuckDB, Polars, and Ibis.
Schema
- 39 fields in flights.parquet
- Includes departure/arrival times, delays, distance, carrier, and airport identifiers
Recommended Usage
Python (Polars)
import polars as pl
flights = pl.read_parquet("flights.parquet")
airlines = pl.read_parquet("airlines.parquet")
airports = pl.read_parquet("airports.parquet")
