Static F1 database table

races_free_practice_2_results

The races_free_practice_2_results table contains 15,509 Formula 1 records across 18 columns. Column types include BIGINT, VARCHAR.

Download Parquet

Rows: 15,509
Columns: 18
Parquet size: 274.9 KB
Updated: 2026-07-31

Schema for races_free_practice_2_results

Column	Type	Nullable	Description
raceId	BIGINT	no	The identifier of the race.
year	BIGINT	no	The year of the season.
round	BIGINT	no	The round number of the race in the season.
positionDisplayOrder	BIGINT	no	The display order of the driver's position in the practice session.
positionNumber	BIGINT	yes	The numerical position of the driver in the practice session.
positionText	VARCHAR	no	The textual representation of the driver's position in the practice session, including special statuses.
driverNumber	VARCHAR	no	The car number of the driver.
driverId	VARCHAR	no	The identifier of the driver.
constructorId	VARCHAR	no	The identifier of the constructor.
engineManufacturerId	VARCHAR	no	The identifier of the engine manufacturer.
tyreManufacturerId	VARCHAR	no	The identifier of the tyre manufacturer.
time	VARCHAR	yes	The lap time recorded for the driver during the practice session.
timeMillis	BIGINT	yes	The lap time in milliseconds.
gap	VARCHAR	yes	The gap between the driver and the leader.
gapMillis	BIGINT	yes	The gap in milliseconds.
interval	VARCHAR	yes	The interval between the driver and the car ahead.
intervalMillis	BIGINT	yes	The interval in milliseconds.
laps	BIGINT	yes	The number of laps completed by the driver during the practice session.

57 tables

57 tables · 8.6 MB total

races_free_practice_2_results · 18 columns · 2,000 rows loaded Partial


435	1986	15	1	1	1	12	ayrton-senna	lotus	renault	goodyear	1:17.977	77977
435	1986	15	2	2	2	20	gerhard-berger	benetton	bmw	pirelli	1:18.088	78088	+0.111	111	+0.111	111
435	1986	15	3	3	3	19	teo-fabi	benetton	bmw	pirelli	1:18.154	78154	+0.177	177	+0.066	66
435	1986	15	4	4	4	6	nelson-piquet	williams	honda	goodyear	1:18.353	78353	+0.376	376	+0.199	199
435	1986	15	5	5	5	5	nigel-mansell	williams	honda	goodyear	1:18.785	78785	+0.808	808	+0.432	432
435	1986	15	6	6	6	2	keke-rosberg	mclaren	tag	goodyear	1:19.160	79160	+1.183	1183	+0.375	375
435	1986	15	7	7	7	15	alan-jones	lola	ford	goodyear	1:19.244	79244	+1.267	1267	+0.084	84
435	1986	15	8	8	8	1	alain-prost	mclaren	tag	goodyear	1:19.282	79282	+1.305	1305	+0.038	38
435	1986	15	9	9	9	7	riccardo-patrese	brabham	bmw	pirelli	1:19.520	79520	+1.543	1543	+0.238	238
435	1986	15	10	10	10	28	stefan-johansson	ferrari	ferrari	goodyear	1:19.634	79634	+1.657	1657	+0.114	114
435	1986	15	11	11	11	14	jonathan-palmer	zakspeed	zakspeed	goodyear	1:20.392	80392	+2.415	2415	+0.758	758
435	1986	15	12	12	12	25	rene-arnoux	ligier	renault	pirelli	1:20.459	80459	+2.482	2482	+0.067	67
435	1986	15	13	13	13	26	philippe-alliot	ligier	renault	pirelli	1:20.541	80541	+2.564	2564	+0.082	82
435	1986	15	14	14	14	11	johnny-dumfries	lotus	renault	goodyear	1:20.701	80701	+2.724	2724	+0.160	160
435	1986	15	15	15	15	27	michele-alboreto	ferrari	ferrari	goodyear	1:20.702	80702	+2.725	2725	+0.001	1
435	1986	15	16	16	16	8	derek-warwick	brabham	bmw	pirelli	1:20.879	80879	+2.902	2902	+0.177	177
435	1986	15	17	17	17	4	philippe-streiff	tyrrell	renault	goodyear	1:21.065	81065	+3.088	3088	+0.186	186
435	1986	15	18	18	18	16	patrick-tambay	lola	ford	goodyear	1:21.084	81084	+3.107	3107	+0.019	19
435	1986	15	19	19	19	3	martin-brundle	tyrrell	renault	goodyear	1:21.447	81447	+3.470	3470	+0.363	363
435	1986	15	20	20	20	17	christian-danner	arrows	bmw	goodyear	1:21.879	81879	+3.902	3902	+0.432	432
435	1986	15	21	21	21	29	huub-rothengatter	zakspeed	zakspeed	goodyear	1:22.230	82230	+4.253	4253	+0.351	351
435	1986	15	22	22	22	24	alessandro-nannini	minardi	motori-moderni	pirelli	1:22.997	82997	+5.020	5020	+0.767	767
435	1986	15	23	23	23	18	thierry-boutsen	arrows	bmw	goodyear	1:23.515	83515	+5.538	5538	+0.518	518
435	1986	15	24	24	24	23	andrea-de-cesaris	minardi	motori-moderni	pirelli	1:23.638	83638	+5.661	5661	+0.123	123
435	1986	15	25	25	25	21	piercarlo-ghinzani	osella	alfa-romeo	pirelli	1:24.728	84728	+6.751	6751	+1.090	1090
435	1986	15	26	26	26	22	allen-berg	osella	alfa-romeo	pirelli	4:02.670	242670	+2:44.693	164693	+2:37.942	157942
436	1986	16	1	1	1	1	alain-prost	mclaren	tag	goodyear	1:19.121	79121

Showing first 2,000 of 15,509 rows (static browse cap 2,000)

Full Parquet

18 cols · 0ms