OpenFlights Route Database 2014

67663 routes between 3321 airports on 548 airlines spanning the globe

@kaggle.divyanshrai_openflights_route_database_2014

Table List

1 table(476.43 KB)

Routes

@kaggle.divyanshrai_openflights_route_database_2014.routes

476.43 KB
67663 rows
9 columns

airline Airline	airline_id Airline ID	source_airport Source Airport	source_airport_id Source Airport ID	destination_airport Destination Airport	destination_airport_id Destination Airport ID	codeshare Codeshare	equipment Equipment
2B	410	AER	2965	KZN	2990	nan	CR2
2B	410	ASF	2966	KZN	2990	nan	CR2
2B	410	ASF	2966	MRV	2962	nan	CR2
2B	410	CEK	2968	KZN	2990	nan	CR2
2B	410	CEK	2968	OVB	4078	nan	CR2
2B	410	DME	4029	KZN	2990	nan	CR2
2B	410	DME	4029	NBC	6969	nan	CR2
2B	410	DME	4029	TGK	\N	nan	CR2
2B	410	DME	4029	UUA	6160	nan	CR2
2B	410	EGO	6156	KGD	2952	nan	CR2


CREATE TABLE routes (
  "airline" VARCHAR,
  "airline_id" VARCHAR,
  "source_airport" VARCHAR,
  "source_airport_id" VARCHAR,
  "destination_airport" VARCHAR,
  "destination_airport_id" VARCHAR,
  "codeshare" VARCHAR,
  "stops" BIGINT,
  "equipment" VARCHAR
);