Ultimate F1–2023 Dataset

Contains all data from F1 2023 season

@kaggle.samyakb_ultimate_f1_2023_dataset

Table List

2 tables(2.07 MB)

Laptime Data All Sessions

@kaggle.samyakb_ultimate_f1_2023_dataset.laptime_data_all_sessions

1.96 MB
23485 rows
38 columns

time Time	driver Driver	drivernumber DriverNumber	laptime LapTime	lapnumber LapNumber	stint Stint	pitouttime PitOutTime	pitintime PitInTime	sector1time Sector1Time	sector2time Sector2Time	sector3time Sector3Time	sector1sessiontime Sector1SessionTime	sector2sessiontime Sector2SessionTime	sector3sessiontime Sector3SessionTime	speedi1 SpeedI1	speedi2 SpeedI2	speedfl SpeedFL	speedst SpeedST	ispersonalbest IsPersonalBest	compound Compound	tyrelife TyreLife	team Team	lapstarttime LapStartTime	trackstatus TrackStatus	position Position	deletedreason DeletedReason	isaccurate IsAccurate	airtemp AirTemp	humidity Humidity	pressure Pressure	tracktemp TrackTemp	winddirection WindDirection	windspeed WindSpeed
0 days 01:04:15.961000	VER	1	0 days 00:01:39.019000	1	1	0 days 00:21:57.509000	nan	nan	0 days 00:00:42.414000	0 days 00:00:23.842000	nan	0 days 01:03:52.119000	0 days 01:04:16.010000	232	231	278	252	False	SOFT	4	Red Bull Racing	0 days 01:02:36.652000	2	1	nan		27.3	22	1016.7	31.2	226	0.5
0 days 01:05:53.935000	VER	1	0 days 00:01:37.974000	2	1	nan	nan	0 days 00:00:31.342000	0 days 00:00:42.504000	0 days 00:00:24.128000	0 days 01:04:47.303000	0 days 01:05:29.807000	0 days 01:05:53.935000	227	238	278	288	True	SOFT	5	Red Bull Racing	0 days 01:04:15.961000	2	1	nan	true	27.3	22	1016.7	31.1	208
0 days 01:07:31.941000	VER	1	0 days 00:01:38.006000	3	1	nan	nan	0 days 00:00:31.388000	0 days 00:00:42.469000	0 days 00:00:24.149000	0 days 01:06:25.323000	0 days 01:07:07.792000	0 days 01:07:31.941000		238	278	287	False	SOFT	6	Red Bull Racing	0 days 01:05:53.935000	1	1	nan	true	27.3	22	1016.7	31.2	170	0.6
0 days 01:09:09.917000	VER	1	0 days 00:01:37.976000	4	1	nan	nan	0 days 00:00:31.271000	0 days 00:00:42.642000	0 days 00:00:24.063000	0 days 01:08:03.212000	0 days 01:08:45.854000	0 days 01:09:09.917000	228	238	278	289	False	SOFT	7	Red Bull Racing	0 days 01:07:31.941000	1	1	nan	true	27.3	22	1016.7	31.2	204	0.4
0 days 01:10:47.952000	VER	1	0 days 00:01:38.035000	5	1	nan	nan	0 days 00:00:31.244000	0 days 00:00:42.724000	0 days 00:00:24.067000	0 days 01:09:41.161000	0 days 01:10:23.885000	0 days 01:10:47.952000		239	278	290	False	SOFT	8	Red Bull Racing	0 days 01:09:09.917000	1	1	nan	true	27.2	22	1016.7	31	206	1
0 days 01:12:25.938000	VER	1	0 days 00:01:37.986000	6	1	nan	nan	0 days 00:00:31.341000	0 days 00:00:42.632000	0 days 00:00:24.013000	0 days 01:11:19.293000	0 days 01:12:01.925000	0 days 01:12:25.938000	229	239	279	291	False	SOFT	9	Red Bull Racing	0 days 01:10:47.952000	1	1	nan	true	27.1	22	1016.9	31	175	0.6
0 days 01:14:03.959000	VER	1	0 days 00:01:38.021000	7	1	nan	nan	0 days 00:00:31.290000	0 days 00:00:42.763000	0 days 00:00:23.968000	0 days 01:12:57.228000	0 days 01:13:39.991000	0 days 01:14:03.959000	230	239	279	293	False	SOFT	10	Red Bull Racing	0 days 01:12:25.938000	1	1	nan	true	27.1	22	1016.9	30.9	210	0.6
0 days 01:15:42.113000	VER	1	0 days 00:01:38.154000	8	1	nan	nan	0 days 00:00:31.291000	0 days 00:00:42.833000	0 days 00:00:24.030000	0 days 01:14:35.250000	0 days 01:15:18.083000	0 days 01:15:42.113000		240	279		False	SOFT	11	Red Bull Racing	0 days 01:14:03.959000	1	1	nan	true	27.1	21	1016.9	30.9	173	1
0 days 01:17:20.391000	VER	1	0 days 00:01:38.278000	9	1	nan	nan	0 days 00:00:31.336000	0 days 00:00:42.823000	0 days 00:00:24.119000	0 days 01:16:13.449000	0 days 01:16:56.272000	0 days 01:17:20.391000	229	242	279		False	SOFT	12	Red Bull Racing	0 days 01:15:42.113000	1	1	nan	true	27.1	21	1016.9	30.9	201	0.6
0 days 01:18:58.760000	VER	1	0 days 00:01:38.369000	10	1	nan	nan	0 days 00:00:31.361000	0 days 00:00:42.884000	0 days 00:00:24.124000	0 days 01:17:51.752000	0 days 01:18:34.636000	0 days 01:18:58.760000	230	242	279		False	SOFT	13	Red Bull Racing	0 days 01:17:20.391000	1	1	nan	true	27.1	21	1016.9	30.8	180	0.8


CREATE TABLE laptime_data_all_sessions (
  "time" VARCHAR,
  "driver" VARCHAR,
  "drivernumber" BIGINT,
  "laptime" VARCHAR,
  "lapnumber" DOUBLE,
  "stint" DOUBLE,
  "pitouttime" VARCHAR,
  "pitintime" VARCHAR,
  "sector1time" VARCHAR,
  "sector2time" VARCHAR,
  "sector3time" VARCHAR,
  "sector1sessiontime" VARCHAR,
  "sector2sessiontime" VARCHAR,
  "sector3sessiontime" VARCHAR,
  "speedi1" DOUBLE,
  "speedi2" DOUBLE,
  "speedfl" DOUBLE,
  "speedst" DOUBLE,
  "ispersonalbest" VARCHAR,
  "compound" VARCHAR,
  "tyrelife" DOUBLE,
  "freshtyre" BOOLEAN,
  "team" VARCHAR,
  "lapstarttime" VARCHAR,
  "lapstartdate" VARCHAR,
  "trackstatus" DOUBLE,
  "position" DOUBLE,
  "deleted" BOOLEAN,
  "deletedreason" VARCHAR,
  "fastf1generated" BOOLEAN,
  "isaccurate" BOOLEAN,
  "airtemp" DOUBLE,
  "humidity" DOUBLE,
  "pressure" DOUBLE,
  "rainfall" BOOLEAN,
  "tracktemp" DOUBLE,
  "winddirection" BIGINT,
  "windspeed" DOUBLE
);