The standings tables track championship points and positions throughout each Formula 1 season.
Driver Standings
The driver_standings.csv table contains driver championship standings after each race.
Schema
| Field | Type | Description |
|---|
driverStandingsId | integer | Unique identifier for each standing entry |
raceId | integer | Foreign key to races.csv |
driverId | integer | Foreign key to drivers.csv |
points | float | Total championship points after this race |
position | integer | Position in the championship |
positionText | string | Text representation of position |
wins | integer | Number of wins in the season up to this race |
Sample Data
| driverStandingsId | raceId | driverId | points | position | wins |
|---|
| 1 | 18 | 1 | 10 | 1 | 1 |
| 2 | 18 | 2 | 8 | 2 | 0 |
| 3 | 18 | 3 | 6 | 3 | 0 |
| 4 | 18 | 4 | 5 | 4 | 0 |
Dataset Statistics
- Total Records: 35,383 driver standing entries
- Coverage: Every race since 1950
Constructor Standings
The constructor_standings.csv table contains constructor championship standings after each race.
Schema
| Field | Type | Description |
|---|
constructorStandingsId | integer | Unique identifier for each standing entry |
raceId | integer | Foreign key to races.csv |
constructorId | integer | Foreign key to constructors.csv |
points | float | Total championship points after this race |
position | integer | Position in the championship |
positionText | string | Text representation of position |
wins | integer | Number of wins in the season up to this race |
Sample Data
| constructorStandingsId | raceId | constructorId | points | position | wins |
|---|
| 1 | 18 | 1 | 14 | 1 | 1 |
| 2 | 18 | 2 | 8 | 3 | 0 |
| 3 | 18 | 3 | 9 | 2 | 0 |
| 4 | 18 | 4 | 5 | 4 | 0 |
Dataset Statistics
- Total Records: 13,642 constructor standing entries
- Coverage: Constructor championship has existed since 1958
Relationships
Driver Standings References:
driver_standings.raceId → races.raceIddriver_standings.driverId → drivers.driverId
Constructor Standings References:
constructor_standings.raceId → races.raceIdconstructor_standings.constructorId → constructors.constructorId
Example Queries
Get championship standings after a specific race
import pandas as pd
driver_standings = pd.read_csv('driver_standings.csv')
standings = driver_standings[driver_standings['raceId'] == 1100]
standings_sorted = standings.sort_values('position')
print(standings_sorted[['position', 'driverId', 'points', 'wins']].head(10))
Track championship leader throughout a season
races = pd.read_csv('races.csv')
season_races = races[races['year'] == 2023]['raceId']
leaders = driver_standings[
(driver_standings['raceId'].isin(season_races)) &
(driver_standings['position'] == 1)
]
print(leaders[['raceId', 'driverId', 'points']])
Find closest championship battles
# Get final race of each season
final_races = races.groupby('year')['raceId'].max()
for race_id in final_races:
final_standings = driver_standings[
(driver_standings['raceId'] == race_id)
].nsmallest(2, 'position')
if len(final_standings) >= 2:
gap = final_standings.iloc[1]['points'] - final_standings.iloc[0]['points']
year = races[races['raceId'] == race_id]['year'].iloc[0]
print(f"{year}: Championship gap = {gap} points")
Analyze constructor dominance
constructor_standings = pd.read_csv('constructor_standings.csv')
season_races = races[races['year'] == 2023]['raceId']
season_standings = constructor_standings[
constructor_standings['raceId'].isin(season_races)
]
# Count how many times each constructor led
leadership_counts = season_standings[
season_standings['position'] == 1
]['constructorId'].value_counts()
print(leadership_counts)
Calculate points progression
driver_id = 1 # Lewis Hamilton
season_races = races[races['year'] == 2023]['raceId'].tolist()
driver_progression = driver_standings[
(driver_standings['driverId'] == driver_id) &
(driver_standings['raceId'].isin(season_races))
].sort_values('raceId')
import matplotlib.pyplot as plt
plt.plot(range(len(driver_progression)), driver_progression['points'])
plt.xlabel('Race Number')
plt.ylabel('Total Points')
plt.title('Points Progression Through Season')
plt.show()
Find season champions
# Get final race of each season
final_races = races.groupby('year')['raceId'].max().reset_index()
champions = driver_standings.merge(final_races, on='raceId')
champions = champions[champions['position'] == 1]
print(champions[['year', 'driverId', 'points', 'wins']])
Compare driver vs constructor points
drivers = pd.read_csv('drivers.csv')
results = pd.read_csv('results.csv')
# For a specific race
race_id = 1100
driver_pts = driver_standings[driver_standings['raceId'] == race_id]
constructor_pts = constructor_standings[constructor_standings['raceId'] == race_id]
print("Top 3 Drivers:")
print(driver_pts.nsmallest(3, 'position')[['driverId', 'points']])
print("\nTop 3 Constructors:")
print(constructor_pts.nsmallest(3, 'position')[['constructorId', 'points']])
Championship Points Systems
Points systems have evolved throughout F1 history:
- Current (2010-present): 25-18-15-12-10-8-6-4-2-1 for top 10
- 2003-2009: 10-8-6-5-4-3-2-1 for top 8
- 1991-2002: 10-6-4-3-2-1 for top 6
- Earlier eras: Various systems
Since 2019, an additional point is awarded for fastest lap if the driver finishes in the top 10.
Notes
- Standings are cumulative throughout each season
- Each race generates a standings snapshot for all competitors
- Constructor points are the sum of both drivers’ points (historically, varied)
- Ties in points are broken by number of wins, then second places, etc.
- The
positionText field may contain “E” for equal/tied positions
- Championship structure has remained relatively consistent, but points systems have changed
- These tables allow tracking position changes throughout the season
