Australian Flight Dataset [2003-2022] by Kaggle | Transportation and Logistics

About this Dataset

Australian Flight Dataset [2003-2022]

International Airlines, Operated Flights and Seats to and from Australia. Monthly data showing city, airline, route, country and region data. Do not sum this data unless Stops are set to zero. When Stops are set to zero, you can sum for Airline, Route, Inbound, Outbound and Total Australia. The data may include diversions. For diverted flights where seats are not sold to/from the diversion port, this data will overstate the available capacity to/from the diversion port. * Data does not include operations between Australian airports.

Data Dictionary

Column || Description

Month ---> Date in month and day
In_Out ---> Status of flight [Incoming/Outgoing]
Australian_City ---> Australian city name
International_City ---> International city name
Airline ---> Airline owning the flight
Route ---> Route taken by the flight
Port_Country ---> Port country
Port_Region ---> Port region
Service_Country ---> Service country
Service_Region ---> Service region
Stops ---> Number of stops taken by the flight
All_Flights ---> Total number of flights
Max_Seats ---> Total capacity of seats in flight
Year ---> Date in year
Month_num ---> Date in month number

Tables

C308bb0a 98a9–4cbb Bd0b 206d338ca06c

@kaggle.pandeyg0811_australian_flight_dataset_2003_2022.c308bb0a_98a9_4cbb_bd0b_206d338ca06c

1.34 MB
110055 rows
16 columns


CREATE TABLE c308bb0a_98a9_4cbb_bd0b_206d338ca06c (
  "n__id" BIGINT,
  "month" VARCHAR,
  "in_out" VARCHAR,
  "australian_city" VARCHAR,
  "international_city" VARCHAR,
  "airline" VARCHAR,
  "route" VARCHAR,
  "port_country" VARCHAR,
  "port_region" VARCHAR,
  "service_country" VARCHAR,
  "service_region" VARCHAR,
  "stops" BIGINT,
  "all_flights" BIGINT,
  "max_seats" BIGINT,
  "year" BIGINT,
  "month_num" BIGINT
);