Dataset: Airline Fight Routes In The US [1993-2024]

About this Dataset

Airline Fight Routes In The US [1993-2024]

This dataset provides a comprehensive overview of domestic airline routes within the United States. It includes valuable information for analyzing passenger travel patterns, market trends, and airline pricing strategies.

Data Features:

Year
Quarter
City Market IDs
Departure City
Arrival City:
Miles: The distance between the origin and arrival cities in miles.
Average Daily Passengers: The average number of passengers flying this route per day.
Average Fare: The average fare paid by passengers for this route (consider including currency information).

Potential Uses:

Travel Demand Analysis: Identify popular routes, and understand seasonal variations in passenger traffic.
Market Research: Analyze airline competition on specific routes and assess pricing strategies.
Route Optimization: Airlines can use this data to evaluate existing routes and identify potential new routes with high passenger demand.
Business Intelligence: Businesses can use this data to understand travel patterns relevant to their industry and make informed decisions.

Data Cleaning and Transformation Considerations:

Ensure consistency in city names (consider using the city market ID to group nearby airports).
Handle missing values appropriately.
Consider converting categorical features to numerical representations for analysis.

Tables

Consumer Airfare Report Table 1a All U S Airport Pair, Eb0cb99e

@kaggle.oleksiimartusiuk_all_airline_fight_routes_in_the_us.consumer_airfare_report_table_1a_all_u_s_airport_pair__eb0cb99e

9.29 MB
245955 rows
23 columns


CREATE TABLE consumer_airfare_report_table_1a_all_u_s_airport_pair__eb0cb99e (
  "tbl" VARCHAR,
  "year" BIGINT,
  "quarter" BIGINT,
  "citymarketid_1" BIGINT,
  "citymarketid_2" BIGINT,
  "city1" VARCHAR,
  "city2" VARCHAR,
  "airportid_1" BIGINT,
  "airportid_2" BIGINT,
  "airport_1" VARCHAR,
  "airport_2" VARCHAR,
  "nsmiles" BIGINT,
  "passengers" BIGINT,
  "fare" DOUBLE,
  "carrier_lg" VARCHAR,
  "large_ms" DOUBLE,
  "fare_lg" DOUBLE,
  "carrier_low" VARCHAR,
  "lf_ms" DOUBLE,
  "fare_low" DOUBLE,
  "geocoded_city1" VARCHAR,
  "geocoded_city2" VARCHAR,
  "tbl1apk" VARCHAR
);