Predict Commercial Flight Delays [50+ Features]
Data on Every Commercial Flight US - January 2024 (including delays and reasons)
@kaggle.oleksiimartusiuk_bts_january_2024_commercial_flights_data
Data on Every Commercial Flight US - January 2024 (including delays and reasons)
@kaggle.oleksiimartusiuk_bts_january_2024_commercial_flights_data
CREATE TABLE t_ontime_marketing (
"fl_date" VARCHAR,
"mkt_unique_carrier" VARCHAR,
"op_unique_carrier" VARCHAR,
"tail_num" VARCHAR,
"op_carrier_fl_num" BIGINT,
"origin_city_market_id" BIGINT,
"origin_city_name" VARCHAR,
"origin_state_abr" VARCHAR,
"dest_city_market_id" BIGINT,
"dest_city_name" VARCHAR,
"dest_state_abr" VARCHAR,
"crs_dep_time" BIGINT,
"dep_time" DOUBLE,
"dep_delay" DOUBLE,
"taxi_out" DOUBLE,
"wheels_off" DOUBLE,
"wheels_on" DOUBLE,
"taxi_in" DOUBLE,
"arr_time" DOUBLE,
"arr_delay" DOUBLE,
"arr_delay_new" DOUBLE,
"cancelled" DOUBLE,
"cancellation_code" VARCHAR,
"diverted" DOUBLE,
"dup" VARCHAR,
"distance" DOUBLE,
"carrier_delay" DOUBLE,
"weather_delay" DOUBLE,
"nas_delay" DOUBLE,
"security_delay" DOUBLE,
"late_aircraft_delay" DOUBLE,
"first_dep_time" DOUBLE,
"total_add_gtime" DOUBLE,
"div_airport_landings" BIGINT,
"div_actual_elapsed_time" DOUBLE,
"div1_airport" VARCHAR,
"div1_wheels_on" DOUBLE,
"div1_total_gtime" DOUBLE,
"div1_wheels_off" DOUBLE,
"div1_tail_num" VARCHAR,
"div2_airport" VARCHAR,
"div2_wheels_on" DOUBLE,
"div2_total_gtime" DOUBLE,
"div2_wheels_off" DOUBLE,
"div2_tail_num" VARCHAR,
"div3_airport" VARCHAR,
"div3_wheels_on" DOUBLE,
"div3_total_gtime" DOUBLE,
"div3_wheels_off" DOUBLE,
"div3_tail_num" VARCHAR,
"div4_airport" VARCHAR,
"div4_wheels_on" VARCHAR,
"div4_total_gtime" VARCHAR,
"div4_wheels_off" VARCHAR,
"div4_tail_num" VARCHAR,
"div5_airport" VARCHAR,
"div5_wheels_on" VARCHAR,
"div5_wheels_off" VARCHAR,
"div5_tail_num" VARCHAR
);
CREATE TABLE consumer_airfare_report_table_2_top_1_000_city_pair_ma_7b32a5be (
"tbl" VARCHAR,
"year" BIGINT,
"quarter" BIGINT,
"citymarketid" BIGINT,
"city" VARCHAR,
"markets" BIGINT,
"cur_passengers" BIGINT,
"cur_fare" DOUBLE,
"cur_yield" DOUBLE,
"distance" DOUBLE,
"ly_passengers" DOUBLE,
"ly_fare" DOUBLE,
"ly_yield" DOUBLE,
"ly_distance" DOUBLE,
"geocoded_city" VARCHAR,
"tbl2pk" BIGINT
);
Anyone who has the link will be able to view this.