SQL Playground

One airline.

• airline_codeTEXTPK

  Airline code

• airline_nameTEXT

  Airline name

• carrier_groupTEXT

  network, low-cost, ultra-low-cost, or regional

One airport that appears in this dataset.

• airport_codeTEXTPK

  Airport code (for example JFK)

• airport_nameTEXT

  Airport name

• cityTEXT

  City

• stateTEXT

  Two-letter state or territory code

• state_nameTEXT

  State or territory name

• latitudeREAL · nullable

  Latitude

• longitudeREAL · nullable

  Longitude

• elevation_ftINTEGER · nullable

  Elevation in feet

One flight path from an origin airport to a destination airport.

• route_idINTEGERPK

  Route key

• originTEXT→ airports

  Departure airport

• destinationTEXT→ airports

  Arrival airport

• distance_milesINTEGER

  Distance between the airports in miles

One calendar date in the first quarter of 2025.

• dateTEXTPK

  Calendar date (YYYY-MM-DD)

• yearINTEGER

  Year

• quarterINTEGER

  Quarter number

• monthINTEGER

  Month number

• month_nameTEXT

  Month name

• day_of_monthINTEGER

  Day of month

• day_of_weekINTEGER

  0 = Sunday … 6 = Saturday

• day_nameTEXT

  Day name

• is_weekendINTEGER

  1 on Saturday and Sunday

• holiday_nameTEXT · nullable

  U.S. federal holiday, NULL otherwise

One reason a flight can be cancelled (for example weather or carrier).

• codeTEXTPK

  A, B, C or D

• descriptionTEXT

  Reason description

One scheduled domestic flight, including cancelled and diverted flights.

• flight_idINTEGERPK

  Flight key

• flight_dateTEXT→ calendar

  Scheduled departure date

• airline_codeTEXT→ airlines

  Airline that operated the flight

• flight_numberINTEGER

  Flight number; repeats across days

• tail_numberTEXT · nullable

  Aircraft ID; NULL when not reported

• originTEXT→ airports

  Departure airport

• destinationTEXT→ airports

  Arrival airport

• route_idINTEGER→ routes

  Route for this origin and destination

• scheduled_departureTEXT

  Scheduled departure time at the origin

• actual_departureTEXT · nullable

  Actual departure time; NULL if cancelled

• departure_delayINTEGER · nullable

  Minutes late leaving (negative = early); NULL if cancelled

• taxi_out_minutesINTEGER · nullable

  Minutes from leaving the gate to takeoff

• scheduled_arrivalTEXT

  Scheduled arrival time at the destination

• actual_arrivalTEXT · nullable

  Actual arrival time; NULL if cancelled or diverted

• arrival_delayINTEGER · nullable

  Minutes late arriving (negative = early); NULL if cancelled or diverted

• air_time_minutesINTEGER · nullable

  Minutes in the air

• distance_milesINTEGER

  Route distance in miles

• cancelledINTEGER

  1 if the flight was cancelled

• cancellation_codeTEXT · nullable→ cancellation_reasons

  Why it was cancelled

• divertedINTEGER

  1 if the flight landed somewhere other than its destination

• carrier_delayINTEGER · nullable

  Minutes of delay blamed on the airline (only when arrival delay is 15+ minutes)

• weather_delayINTEGER · nullable

  Minutes of delay blamed on weather

• nas_delayINTEGER · nullable

  Minutes of delay blamed on air traffic control

• security_delayINTEGER · nullable

  Minutes of delay blamed on security

• late_aircraft_delayINTEGER · nullable

  Minutes of delay from a late incoming aircraft