Flight Take Off Data - JFK Airport

This data contains flight details taking off from JFK airport.

@kaggle.deepankurk_flight_take_off_data_jfk_airport

Table List

1 table(371.92 KB)

M1 Final

@kaggle.deepankurk_flight_take_off_data_jfk_airport.m1_final

371.92 KB
28820 rows
23 columns

month MONTH	day_of_month DAY OF MONTH	day_of_week DAY OF WEEK	op_unique_carrier OP UNIQUE CARRIER	tail_num TAIL NUM	dest DEST	dep_delay DEP DELAY	crs_elapsed_time CRS ELAPSED TIME	distance DISTANCE	crs_dep_m CRS DEP M	dep_time_m DEP TIME M	crs_arr_m CRS ARR M	temperature Temperature	dew_point Dew Point	humidity Humidity	wind Wind	wind_speed Wind Speed	wind_gust Wind Gust	pressure Pressure	condition Condition	sch_dep Sch Dep	sch_arr Sch Arr	taxi_out TAXI OUT
11	1	5	B6	N828JB	CHS	-1	124	636	324	323	448	48	34	58	W	25	38	29.86	Fair / Windy	9	17	14
11	1	5	B6	N992JB	LAX	-7	371	2475	340	333	531	48	34	58	W	25	38	29.86	Fair / Windy	9	17	15
11	1	5	B6	N959JB	FLL	40	181	1069	301	341	482	48	34	58	W	25	38	29.86	Fair / Windy	9	17	22
11	1	5	B6	N999JQ	MCO	-2	168	944	345	343	513	48	34	58	W	25	38	29.86	Fair / Windy	9	17	12
11	1	5	DL	N880DN	ATL	-4	139	760	360	356	499	46	32	58	W	24	35	29.91	Fair / Windy	9	17	13
11	1	5	AA	N983NN	ORD	-1	161	740	359	358	460	46	32	58	W	24	35	29.91	Fair / Windy	9	17	21
11	1	5	AA	N107NN	LAX	-1	373	2475	360	359	553	46	32	58	W	24	35	29.91	Fair / Windy	9	17	26
11	1	5	B6	N274JB	BUF	-5	80	301	365	360	445	46	32	58	W	24	35	29.91	Fair / Windy	17	21	11
11	1	5	B6	N663JB	LGB		368	2465	365	365	553	46	32	58	W	24	35	29.91	Fair / Windy	17	21	25
11	1	5	B6	N283JB	FLL	3	184	1069	370	373	554	46	32	58	W	24	35	29.91	Fair / Windy	17	21	29


CREATE TABLE m1_final (
  "month" BIGINT,
  "day_of_month" BIGINT,
  "day_of_week" BIGINT,
  "op_unique_carrier" VARCHAR,
  "tail_num" VARCHAR,
  "dest" VARCHAR,
  "dep_delay" BIGINT,
  "crs_elapsed_time" BIGINT,
  "distance" BIGINT,
  "crs_dep_m" BIGINT,
  "dep_time_m" BIGINT,
  "crs_arr_m" BIGINT,
  "temperature" BIGINT,
  "dew_point" VARCHAR,
  "humidity" BIGINT,
  "wind" VARCHAR,
  "wind_speed" BIGINT,
  "wind_gust" BIGINT,
  "pressure" DOUBLE,
  "condition" VARCHAR,
  "sch_dep" BIGINT,
  "sch_arr" BIGINT,
  "taxi_out" BIGINT
);