Static F1 database table

races

The races table contains 1,171 Formula 1 records across 47 columns. Column types include BIGINT, BOOLEAN, DOUBLE, VARCHAR.

Download Parquet

Rows: 1,171
Columns: 47
Parquet size: 36.7 KB
Updated: 2026-07-31

Schema for races

Column	Type	Nullable	Description
id	BIGINT	no	The unique identifier of the race.
year	BIGINT	no	The year of the season.
round	BIGINT	no	The round number of the race in the season.
date	VARCHAR	no	The date of the race in UTC.
time	VARCHAR	yes	The start time of the race in UTC.
grandPrixId	VARCHAR	no	The identifier of the Grand Prix associated with the race.
officialName	VARCHAR	no	The official name of the race.
qualifyingFormat	VARCHAR	no	The qualifying format of the race.
sprintQualifyingFormat	VARCHAR	no	The sprint qualifying format of the race.
circuitId	VARCHAR	no	The identifier of the circuit where the race takes place.
circuitLayoutId	VARCHAR	no	The identifier of the circuit layout.
circuitType	VARCHAR	no	The type of the circuit.
direction	VARCHAR	no	The direction of the circuit.
courseLength	DOUBLE	no	The length of the circuit (race course) in kilometers.
turns	BIGINT	no	The number of turns (corners) in the configuration of the circuit.
laps	BIGINT	no	The total number of laps of the race.
distance	DOUBLE	no	The total distance of the race in kilometers.
scheduledLaps	BIGINT	yes	The scheduled number of laps of the race.
scheduledDistance	DOUBLE	yes	The scheduled distance of the race in kilometers.
driversChampionshipDecider	BOOLEAN	no	Whether the race was the decider of the World Drivers' Championship.
constructorsChampionshipDecider	BOOLEAN	no	Whether the race was the decider of the World Constructors' Championship.
preQualifyingDate	VARCHAR	yes	The date of the pre-qualifying session in UTC.
preQualifyingTime	VARCHAR	yes	The start time of the pre-qualifying session in UTC.
freePractice1Date	VARCHAR	yes	The date of the 1st free practice session in UTC.
freePractice1Time	VARCHAR	yes	The start time of the 1st free practice session in UTC.
freePractice2Date	VARCHAR	yes	The date of the 2nd free practice session in UTC.
freePractice2Time	VARCHAR	yes	The start time of the 2nd free practice session in UTC.
freePractice3Date	VARCHAR	yes	The date of the 3rd free practice session in UTC.
freePractice3Time	VARCHAR	yes	The start time of the 3rd free practice session in UTC.
freePractice4Date	VARCHAR	yes	The date of the 4th free practice session UTC.
freePractice4Time	VARCHAR	yes	The start time of the 4th free practice session in UTC.
qualifying1Date	VARCHAR	yes	The date of the 1st qualifying session in UTC.
qualifying1Time	VARCHAR	yes	The start time of the 1st qualifying session in UTC.
qualifying2Date	VARCHAR	yes	The date of the 2nd qualifying session UTC.
qualifying2Time	VARCHAR	yes	The start time of the 2nd qualifying session UTC.
qualifyingDate	VARCHAR	yes	The date of the qualifying session UTC.
qualifyingTime	VARCHAR	yes	The start time of the qualifying session UTC.
sprintQualifyingDate	VARCHAR	yes	The date of the sprint qualifying session in UTC.
sprintQualifyingTime	VARCHAR	yes	The start time of the sprint qualifying session in UTC.
sprintRaceDate	VARCHAR	yes	The date of the sprint race in UTC.
sprintRaceTime	VARCHAR	yes	The start time of the sprint race in UTC.
sprintRaceLaps	BIGINT	yes	The total number of laps of the sprint race.
sprintRaceDistance	DOUBLE	yes	The total distance of the sprint race in kilometers.
sprintRaceScheduledLaps	BIGINT	yes	The scheduled number of laps of the sprint race.
sprintRaceScheduledDistance	DOUBLE	yes	The scheduled distance of the sprint race in kilometers.
warmingUpDate	VARCHAR	yes	The date of the warming-up session in UTC.
warmingUpTime	VARCHAR	yes	The start time of the warming-up session in UTC.

57 tables

57 tables · 8.6 MB total

races · 47 columns · 1,171 rows loaded


1	1950	1	1950-05-13	great-britain	1950 RAC British Grand Prix	TWO_SESSION	silverstone	silverstone-1	RACE	CLOCKWISE	4.649	8	70	325.43			false	false
2	1950	2	1950-05-21	monaco	Grand Prix de Monaco 1950	TWO_SESSION	monaco	monaco-1	STREET	CLOCKWISE	3.18	14	100	318			false	false
3	1950	3	1950-05-30	indianapolis	1950 Indianapolis 500	FOUR_LAPS	indianapolis	indianapolis-1	RACE	CLOCKWISE	4.023	4	138	555.224	200	804.672	false	false
4	1950	4	1950-06-04	switzerland	Grosser Preis der Schweiz 1950	TWO_SESSION	bremgarten	bremgarten-1	ROAD	CLOCKWISE	7.28	13	42	305.76			false	false
5	1950	5	1950-06-18	belgium	1950 Belgian Grand Prix	TWO_SESSION	spa-francorchamps	spa-francorchamps-1	ROAD	CLOCKWISE	14.12	21	35	494.2			false	false
6	1950	6	1950-07-02	france	Grand Prix de France 1950	TWO_SESSION	reims	reims-1	ROAD	CLOCKWISE	7.815	5	64	500.16			false	false
7	1950	7	1950-09-03	italy	Gran Premio d'Italia 1950	TWO_SESSION	monza	monza-1	RACE	CLOCKWISE	6.3	5	80	504			true	false
8	1951	1	1951-05-27	switzerland	Grosser Preis der Schweiz 1951	TWO_SESSION	bremgarten	bremgarten-1	ROAD	CLOCKWISE	7.28	13	42	305.76			false	false
9	1951	2	1951-05-30	indianapolis	1951 Indianapolis 500	FOUR_LAPS	indianapolis	indianapolis-1	RACE	CLOCKWISE	4.023	4	200	804.672			false	false
10	1951	3	1951-06-17	belgium	1951 Belgian Grand Prix	TWO_SESSION	spa-francorchamps	spa-francorchamps-1	ROAD	CLOCKWISE	14.12	21	36	508.32			false	false
11	1951	4	1951-07-01	france	Grand Prix de France 1951	TWO_SESSION	reims	reims-1	ROAD	CLOCKWISE	7.815	5	77	601.755			false	false
12	1951	5	1951-07-14	great-britain	1951 RAC British Grand Prix	TWO_SESSION	silverstone	silverstone-1	RACE	CLOCKWISE	4.649	8	90	418.41			false	false
13	1951	6	1951-07-29	germany	Grosser Preis von Deutschland 1951	TWO_SESSION	nurburgring	nurburgring-1	ROAD	CLOCKWISE	22.81	160	20	456.2			false	false
14	1951	7	1951-09-16	italy	Gran Premio d'Italia 1951	TWO_SESSION	monza	monza-1	RACE	CLOCKWISE	6.3	5	80	504			false	false
15	1951	8	1951-10-28	spain	Gran Premio de España 1951	TWO_SESSION	pedralbes	pedralbes-1	STREET	CLOCKWISE	6.316	6	70	442.12			true	false
16	1952	1	1952-05-18	switzerland	Grosser Preis der Schweiz 1952	TWO_SESSION	bremgarten	bremgarten-1	ROAD	CLOCKWISE	7.28	13	62	451.36			false	false
17	1952	2	1952-05-30	indianapolis	1952 Indianapolis 500	FOUR_LAPS	indianapolis	indianapolis-1	RACE	CLOCKWISE	4.023	4	200	804.672			false	false
18	1952	3	1952-06-22	belgium	1952 Belgian Grand Prix	TWO_SESSION	spa-francorchamps	spa-francorchamps-1	ROAD	CLOCKWISE	14.12	21	36	508.32			false	false
19	1952	4	1952-07-06	france	Grand Prix de France 1952	TWO_SESSION	rouen	rouen-1	ROAD	CLOCKWISE	5.1	10	77	392.7			false	false
20	1952	5	1952-07-19	great-britain	1952 RAC British Grand Prix	TWO_SESSION	silverstone	silverstone-1	RACE	CLOCKWISE	4.711	8	85	400.435			false	false
21	1952	6	1952-08-03	germany	Grosser Preis von Deutschland 1952	TWO_SESSION	nurburgring	nurburgring-1	ROAD	CLOCKWISE	22.81	160	18	410.58			true	false
22	1952	7	1952-08-17	netherlands	Grote Prijs van Nederland 1952	TWO_SESSION	zandvoort	zandvoort-1	RACE	CLOCKWISE	4.193	19	90	377.37			false	false
23	1952	8	1952-09-07	italy	Gran Premio d'Italia 1952	TWO_SESSION	monza	monza-1	RACE	CLOCKWISE	6.3	5	80	504			false	false
24	1953	1	1953-01-18	argentina	Gran Premio de Argentina 1953	TWO_SESSION	buenos-aires	buenos-aires-1	RACE	CLOCKWISE	3.912	13	97	379.464			false	false
25	1953	2	1953-05-30	indianapolis	1953 Indianapolis 500	FOUR_LAPS	indianapolis	indianapolis-1	RACE	CLOCKWISE	4.023	4	200	804.672			false	false
26	1953	3	1953-06-07	netherlands	Grote Prijs van Nederland 1953	TWO_SESSION	zandvoort	zandvoort-1	RACE	CLOCKWISE	4.193	19	90	377.37			false	false
27	1953	4	1953-06-21	belgium	1953 Belgian Grand Prix	TWO_SESSION	spa-francorchamps	spa-francorchamps-1	ROAD	CLOCKWISE	14.12	21	36	508.32			false	false

47 cols · 0ms