Indy500 Car Racing Dataset

Rank Position Forecasting in Car Racing

@kaggle.arashnic_car_racing_dataset

Table List

11 tables(1.62 MB)

N 2017 All Completed Laps Diff

N 2017 Completed Laps Diff

N 2018 All Completed Laps Diff

N 2018 Completed Laps Diff

All Completed Laps Diff

Completed Laps

Completed Laps Diff

Indy500–2018 All Completed Laps Diff

Indy500–2018 Completed Laps Diff

Texas 2018 All Completed Laps Diff

Texas 2018 Completed Laps Diff

Completed Laps

@kaggle.arashnic_car_racing_dataset.completed_laps

520.08 KB
19426 rows
25 columns

command Command	type Type	sequence_number Sequence Number	preamble Preamble	rank Rank	car_number Car Number	unique_id Unique Id	completed_laps Completed Laps	elapsed_time Elapsed Time	last_laptime Last Laptime	lap_status Lap Status	best_laptime Best Laptime	best_lap Best Lap	overall_rank Overall Rank	overall_best_laptime Overall Best Laptime	current_status Current Status	track_status Track Status	pit_stop_count Pit Stop Count	last_pitted_lap Last Pitted Lap	start_position Start Position
$C	U		S10	1	9					T			1		Active	G			1
$C	R		S10	1	9					T			1		Active	G			1
$C	U		S10	1	9			3.3695833333333334		T			1		Active	G			1
$C	R		S10	1	9			3.3695833333333334		T			1		Active	G			1
$C	U	1	S10	1	9		1	6.752793333333333	3.38321	T	3.38321	1	1	3.38321	Active	G			1
$C	U	2	S10	1	9		2	10.208211666666667	3.4554183333333333	P	3.38321	1	1	3.38321	Active	G	1	2	1
$C	U		R.I	1	20					T			1		Active	U			1
$C	U	65536	R.I	2	22	1				T			2		Active	U			2
$C	U	131072	R.I	3	12	2				T			3		Active	U			3
$C	U	196608	R.I	4	1	3				T			4		Active	U			4


CREATE TABLE completed_laps (
  "command" VARCHAR,
  "type" VARCHAR,
  "sequence_number" BIGINT,
  "preamble" VARCHAR,
  "rank" BIGINT,
  "car_number" BIGINT,
  "unique_id" BIGINT,
  "completed_laps" BIGINT,
  "elapsed_time" DOUBLE,
  "last_laptime" DOUBLE,
  "lap_status" VARCHAR,
  "best_laptime" DOUBLE,
  "best_lap" BIGINT,
  "time_behind_leader" DOUBLE,
  "laps_behind_leader" BIGINT,
  "time_behind_prec" DOUBLE,
  "laps_behind_prec" BIGINT,
  "overall_rank" BIGINT,
  "overall_best_laptime" DOUBLE,
  "current_status" VARCHAR,
  "track_status" VARCHAR,
  "pit_stop_count" BIGINT,
  "last_pitted_lap" BIGINT,
  "start_position" BIGINT,
  "laps_led" BIGINT
);