Static F1 database table

races_free_practice_1_results

The races_free_practice_1_results table contains 16,076 Formula 1 records across 18 columns. Column types include BIGINT, VARCHAR.

Download Parquet

Rows: 16,076
Columns: 18
Parquet size: 288.1 KB
Updated: 2026-07-31

Schema for races_free_practice_1_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_1_results · 18 columns · 2,000 rows loaded Partial


435	1986	15	1	1	1	6	nelson-piquet	williams	honda	goodyear	1:18.601	78601
435	1986	15	2	2	2	12	ayrton-senna	lotus	renault	goodyear	1:18.779	78779	+0.178	178	+0.178	178
435	1986	15	3	3	3	20	gerhard-berger	benetton	bmw	pirelli	1:19.004	79004	+0.403	403	+0.225	225
435	1986	15	4	4	4	2	keke-rosberg	mclaren	tag	goodyear	1:19.099	79099	+0.498	498	+0.095	95
435	1986	15	5	5	5	5	nigel-mansell	williams	honda	goodyear	1:19.588	79588	+0.987	987	+0.489	489
435	1986	15	6	6	6	1	alain-prost	mclaren	tag	goodyear	1:19.851	79851	+1.250	1250	+0.263	263
435	1986	15	7	7	7	15	alan-jones	lola	ford	goodyear	1:20.471	80471	+1.870	1870	+0.620	620
435	1986	15	8	8	8	27	michele-alboreto	ferrari	ferrari	goodyear	1:20.737	80737	+2.136	2136	+0.266	266
435	1986	15	9	9	9	7	riccardo-patrese	brabham	bmw	pirelli	1:20.746	80746	+2.145	2145	+0.009	9
435	1986	15	10	10	10	16	patrick-tambay	lola	ford	goodyear	1:20.950	80950	+2.349	2349	+0.204	204
435	1986	15	11	11	11	28	stefan-johansson	ferrari	ferrari	goodyear	1:20.978	80978	+2.377	2377	+0.028	28
435	1986	15	12	12	12	19	teo-fabi	benetton	bmw	pirelli	1:21.205	81205	+2.604	2604	+0.227	227
435	1986	15	13	13	13	26	philippe-alliot	ligier	renault	pirelli	1:21.359	81359	+2.758	2758	+0.154	154
435	1986	15	14	14	14	4	philippe-streiff	tyrrell	renault	goodyear	1:21.460	81460	+2.859	2859	+0.101	101
435	1986	15	15	15	15	14	jonathan-palmer	zakspeed	zakspeed	goodyear	1:21.484	81484	+2.883	2883	+0.024	24
435	1986	15	16	16	16	25	rene-arnoux	ligier	renault	pirelli	1:21.747	81747	+3.146	3146	+0.263	263
435	1986	15	17	17	17	8	derek-warwick	brabham	bmw	pirelli	1:21.768	81768	+3.167	3167	+0.021	21
435	1986	15	18	18	18	11	johnny-dumfries	lotus	renault	goodyear	1:22.011	82011	+3.410	3410	+0.243	243
435	1986	15	19	19	19	18	thierry-boutsen	arrows	bmw	goodyear	1:22.050	82050	+3.449	3449	+0.039	39
435	1986	15	20	20	20	17	christian-danner	arrows	bmw	goodyear	1:22.597	82597	+3.996	3996	+0.547	547
435	1986	15	21	21	21	3	martin-brundle	tyrrell	renault	goodyear	1:22.812	82812	+4.211	4211	+0.215	215
435	1986	15	22	22	22	29	huub-rothengatter	zakspeed	zakspeed	goodyear	1:22.947	82947	+4.346	4346	+0.135	135
435	1986	15	23	23	23	23	andrea-de-cesaris	minardi	motori-moderni	pirelli	1:23.986	83986	+5.385	5385	+1.039	1039
435	1986	15	24	24	24	24	alessandro-nannini	minardi	motori-moderni	pirelli	1:25.920	85920	+7.319	7319	+1.934	1934
435	1986	15	25	25	25	21	piercarlo-ghinzani	osella	alfa-romeo	pirelli	1:27.024	87024	+8.423	8423	+1.104	1104
435	1986	15	26	26	26	22	allen-berg	osella	alfa-romeo	pirelli	1:28.977	88977	+10.376	10376	+1.953	1953
436	1986	16	1	1	1	5	nigel-mansell	williams	honda	goodyear	1:23.440	83440

Showing first 2,000 of 16,076 rows (static browse cap 2,000)

Full Parquet

18 cols · 0ms