Ultimate F1–2023 Dataset

Contains all data from F1 2023 season

@kaggle.samyakb_ultimate_f1_2023_dataset

Table List

2 tables(2.07 MB)

Qatar

@kaggle.samyakb_ultimate_f1_2023_dataset.qatar

113.02 KB
1014 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	freshtyre FreshTyre	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:25.037000	VER	1	0 days 00:01:45.537000	1	1	0 days 00:17:25.640000	nan	nan	0 days 00:00:41.862000	0 days 00:00:34.041000	nan	0 days 01:03:51.122000	0 days 01:04:25.106000	194	176	199	297		MEDIUM	1	true	Red Bull Racing	0 days 01:02:39.217000	1	5	nan		29.9	42	994	40.8	103	2.9
0 days 01:06:08.046000	VER	1	0 days 00:01:43.009000	2	1	nan	nan	0 days 00:00:28.137000	0 days 00:00:41.118000	0 days 00:00:33.754000	0 days 01:04:53.173000	0 days 01:05:34.291000	0 days 01:06:08.045000	205	174	198	286	true	MEDIUM	2	true	Red Bull Racing	0 days 01:04:25.037000	1	5	nan	true	29.8	42	993.9	40.8	109	3
0 days 01:07:50.746000	VER	1	0 days 00:01:42.700000	3	1	nan	nan	0 days 00:00:28.030000	0 days 00:00:40.871000	0 days 00:00:33.799000	0 days 01:06:36.075000	0 days 01:07:16.946000	0 days 01:07:50.745000	206	170	198	287	true	MEDIUM	3	true	Red Bull Racing	0 days 01:06:08.046000	1	5	nan	true	29.9	41	994	40.7	95	2.9
0 days 01:09:33.369000	VER	1	0 days 00:01:42.623000	4	1	nan	nan	0 days 00:00:27.874000	0 days 00:00:41.035000	0 days 00:00:33.714000	0 days 01:08:18.619000	0 days 01:08:59.654000	0 days 01:09:33.368000	203	172	198	293	true	MEDIUM	4	true	Red Bull Racing	0 days 01:07:50.746000	1	5	nan	true	29.9	41	994	40.7	96	4
0 days 01:11:15.520000	VER	1	0 days 00:01:42.151000	5	1	nan	nan	0 days 00:00:27.760000	0 days 00:00:40.607000	0 days 00:00:33.784000	0 days 01:10:01.128000	0 days 01:10:41.735000	0 days 01:11:15.519000	204	169	197	324	true	MEDIUM	5	true	Red Bull Racing	0 days 01:09:33.369000	1	4	nan	true	29.9	42	993.9	40.6	107	4
0 days 01:12:58.377000	VER	1	0 days 00:01:42.857000	6	1	nan	nan	0 days 00:00:27.833000	0 days 00:00:41.230000	0 days 00:00:33.794000	0 days 01:11:43.352000	0 days 01:12:24.582000	0 days 01:12:58.376000	210	169	197	288		MEDIUM	6	true	Red Bull Racing	0 days 01:11:15.520000	1	4	nan	true	30	43	994	40.6	100	3.9
0 days 01:14:41.194000	VER	1	0 days 00:01:42.817000	7	1	nan	nan	0 days 00:00:27.578000	0 days 00:00:41.194000	0 days 00:00:34.045000	0 days 01:13:25.954000	0 days 01:14:07.148000	0 days 01:14:41.193000		176	197	290		MEDIUM	7	true	Red Bull Racing	0 days 01:12:58.377000	1	4	nan	true	30	41	993.9	41	102	3.2
0 days 01:16:23.792000	VER	1	0 days 00:01:42.598000	8	1	nan	nan	0 days 00:00:27.671000	0 days 00:00:40.660000	0 days 00:00:34.267000	0 days 01:15:08.864000	0 days 01:15:49.524000	0 days 01:16:23.791000	208	174	199	309		MEDIUM	8	true	Red Bull Racing	0 days 01:14:41.194000	1	4	nan	true	30	40	993.9	40.5	123	4.1
0 days 01:18:06.761000	VER	1	0 days 00:01:42.969000	9	1	nan	nan	0 days 00:00:27.713000	0 days 00:00:41.147000	0 days 00:00:34.109000	0 days 01:16:51.504000	0 days 01:17:32.651000	0 days 01:18:06.760000	202	174	198	312		MEDIUM	9	true	Red Bull Racing	0 days 01:16:23.792000	1	4	nan	true	30	41	993.7	41.1	102	2.4
0 days 01:19:49.502000	VER	1	0 days 00:01:42.741000	10	1	nan	nan	0 days 00:00:27.577000	0 days 00:00:41.127000	0 days 00:00:34.037000	0 days 01:18:34.337000	0 days 01:19:15.464000	0 days 01:19:49.501000	207	174	199	309		MEDIUM	10	true	Red Bull Racing	0 days 01:18:06.761000	1	4	nan	true	30	41	993.9	40.4	107	3.2


CREATE TABLE qatar (
  "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" BOOLEAN,
  "compound" VARCHAR,
  "tyrelife" DOUBLE,
  "freshtyre" BOOLEAN,
  "team" VARCHAR,
  "lapstarttime" VARCHAR,
  "lapstartdate" VARCHAR,
  "trackstatus" BIGINT,
  "position" DOUBLE,
  "deleted" BOOLEAN,
  "deletedreason" VARCHAR,
  "fastf1generated" BOOLEAN,
  "isaccurate" BOOLEAN,
  "airtemp" DOUBLE,
  "humidity" DOUBLE,
  "pressure" DOUBLE,
  "rainfall" BOOLEAN,
  "tracktemp" DOUBLE,
  "winddirection" BIGINT,
  "windspeed" DOUBLE
);