Just want to report that Vettel has 38 fastest laps and not 37. Did some investigating and you attributed the fastest lap on round 17 of 2017 season (American GP) to Kimi Raikkonnen.
If you could give that fastest lap to Vettel would be great 🙂
Also, i know you don’t have much old info, but since raikkonen is stil driving could you update the database with those missing years? 2001 onwards?
Hi punter42,
The raceId is a primary key used internally by the database – unfortunately it doesn’t relate to anything in the real world. If corrections are made to the race schedule the key may not follow a simple, incremental sequence. This is true for the primary keys of all the database tables. The only reliable identifier of a race is year + round, or the date.
Cheers,
Chris
Hi Tiago,
Thanks for the warning – now corrected.
Unfortunately, adding earlier lap times would be a significant amount of work but I’ll bear it in mind.
Chris
I’m not sure if this is a bug or me misunderstanding something (I’ve read the FAQ/Docs), but shouldn’t https://ergast.com/api/f1/current/last/results return the final round of the previous season if there haven’t been any races yet? I understand that the context of ‘current’ is ‘2021’ so maybe it’s not possible, but I’m trying it with https://ergast.com/api/f1/2020/last/results and it still doesn’t work. Is it because the context of ‘last’ always relates to the current season?
Hi Luke,
Apologies for the confusion. This was a bug I didn’t anticipate, caused by all the recent race cancellations. It should be ok now.
Thanks for the warning.
Chris
I’m requesting https://ergast.com/api/f1/2021/driverStandings.json
The “Constructors” field for all the drivers are empty. However they are not when I request it for previous years (e.g 2020, 2019). Do you plan to add it in future?
Hi suf264,
The link between drivers and constructors is established via the race results table – and is established after the first race of the season. This makes sense in some ways because you con’t be sure who will actually turn up to race on the day (remember USF1?). But yeah, it’s not ideal. Unfortunately, there’s no easy fix.
Chris
Hi Nicolas,
It’s difficult to think of Alfa as anything other than Italian! Unfortunately, the database doesn’t support time-dependent properties for constructors. I’ll update it anyway though so this year’s line-up is correct. Thanks.
Chris
I have noticed that at least from my csv download of the database, in the qualifying sheet there are no entries for raceId = 260 or the 1994 Monaco GP.
Hi Lucy,
On documentation page for the Qualifying results you’ll see a note explaining that they are only fully supported from the 2003 season onwards. If someone can supply the missing data in a machine-readable form I would be happy to add it.
Cheers,
Chris
I think I noticed what may be an error in the data, but wanted to confirm.
If you run a query on the 2011 Canadian GP lap times for Heidfeld (result here: http://ergast.com/api/f1/2011/7/drivers/heidfeld/laps) it appears as if one of the recorded lap times is over 2 hours. There are similar results for a lot of other drivers and races as well (e.g. lap times for round 9 of 2014 season).
I’m not too familiar with how timing works, but this seems erroneous and wanted to confirm.
Hi Nick,
You sometimes see these anomalous lap times in the official FIA data when a race has been Red-flagged. For 2011 Canadian Grand Prix the Wikipedia report states that “Torrential rain prevented the resumption of the Grand Prix for over two hours”. This is probably the source of the issue you found.
Cheers,
Chris
This will not be a problem with any normal usage of the API since no id field has special characters from what I understand, but I am posting this observation in case there is some other issue that can be caused due to this.
The current race schedule has the wrong start time for the Portuguese Grand Prix. It starts at 14:00:00 UTC, not the 13:00:00 UTC in the API (according to Formula1.com website).
Just noticed that the results in JSON for the season 2021 does not include the latest race (Portimao). I noticed that /results contains it, but not when specifying JSON.
Has it just been missed or am I doing something wrong?
Hi Chris,
Your raceId is often matching that on formula1.com but also often not.
E.g. the last race in 2020 on f1.com has raceId 1061: https://www.formula1.com/en/results.html/2020/races/1061/abu-dhabi/race-result.html
But in your db it has id 1047. You also have a race with id 1061 but that one is currently in the future.
Is this an error or should I just not use these raceId to find the same races?
Kind regards,
punter42
Hi,
Just want to report that Vettel has 38 fastest laps and not 37. Did some investigating and you attributed the fastest lap on round 17 of 2017 season (American GP) to Kimi Raikkonnen.
If you could give that fastest lap to Vettel would be great 🙂
Also, i know you don’t have much old info, but since raikkonen is stil driving could you update the database with those missing years? 2001 onwards?
Much appreciated and incredible work
Best regards
Hi punter42,
The raceId is a primary key used internally by the database – unfortunately it doesn’t relate to anything in the real world. If corrections are made to the race schedule the key may not follow a simple, incremental sequence. This is true for the primary keys of all the database tables. The only reliable identifier of a race is year + round, or the date.
Cheers,
Chris
Hi Tiago,
Thanks for the warning – now corrected.
Unfortunately, adding earlier lap times would be a significant amount of work but I’ll bear it in mind.
Chris
I’m not sure if this is a bug or me misunderstanding something (I’ve read the FAQ/Docs), but shouldn’t https://ergast.com/api/f1/current/last/results return the final round of the previous season if there haven’t been any races yet? I understand that the context of ‘current’ is ‘2021’ so maybe it’s not possible, but I’m trying it with https://ergast.com/api/f1/2020/last/results and it still doesn’t work. Is it because the context of ‘last’ always relates to the current season?
Hi Luke,
Apologies for the confusion. This was a bug I didn’t anticipate, caused by all the recent race cancellations. It should be ok now.
Thanks for the warning.
Chris
Hi!
When will the https://ergast.com/api/f1/current be linked to https://ergast.com/api/f1/2021 ?
And can you please update the 3rd race of 2021 to https://en.wikipedia.org/wiki/Portuguese_Grand_Prix ?
I would have submitted a pull-request if i knew where to post it 😉
Fin
Hi Finwe,
> When will the https://ergast.com/api/f1/current be linked to…
It’s explained here: http://ergast.com/mrd/faq/#shortcuts
> And can you please update the 3rd race of 2021
Done. Thanks for flagging the update.
Chris
Hi,
I’m requesting https://ergast.com/api/f1/2021/driverStandings.json
The “Constructors” field for all the drivers are empty. However they are not when I request it for previous years (e.g 2020, 2019). Do you plan to add it in future?
Thanks
Hi suf264,
The link between drivers and constructors is established via the race results table – and is established after the first race of the season. This makes sense in some ways because you con’t be sure who will actually turn up to race on the day (remember USF1?). But yeah, it’s not ideal. Unfortunately, there’s no easy fix.
Chris
Hi,
thanks for this great API!
I just saw a small mistake in the data: From 2018 until 2020, the nationality for the “Alfa Romeo” team is set to “Italian”, while it should actually be “Swiss”, because the team is run by Sauber Motorsport AG from Switzerland (according to the official 2021 F1 entr y list: https://www.fia.com/events/fia-formula-one-world-championship/season-2021/2021-fia-formula-one-world-championship-entry).
Cheers,
Nicolas
Hi Nicolas,
It’s difficult to think of Alfa as anything other than Italian! Unfortunately, the database doesn’t support time-dependent properties for constructors. I’ll update it anyway though so this year’s line-up is correct. Thanks.
Chris
Hello,
I have noticed that at least from my csv download of the database, in the qualifying sheet there are no entries for raceId = 260 or the 1994 Monaco GP.
Best regards.
Hi Lucy,
On documentation page for the Qualifying results you’ll see a note explaining that they are only fully supported from the 2003 season onwards. If someone can supply the missing data in a machine-readable form I would be happy to add it.
Cheers,
Chris
Hey,
Awesome database and great work.
I think I noticed what may be an error in the data, but wanted to confirm.
If you run a query on the 2011 Canadian GP lap times for Heidfeld (result here: http://ergast.com/api/f1/2011/7/drivers/heidfeld/laps) it appears as if one of the recorded lap times is over 2 hours. There are similar results for a lot of other drivers and races as well (e.g. lap times for round 9 of 2014 season).
I’m not too familiar with how timing works, but this seems erroneous and wanted to confirm.
Hi Nick,
You sometimes see these anomalous lap times in the official FIA data when a race has been Red-flagged. For 2011 Canadian Grand Prix the Wikipedia report states that “Torrential rain prevented the resumption of the Grand Prix for over two hours”. This is probably the source of the issue you found.
Cheers,
Chris
Hi,
The API returns a reponse but with invalid xml or json if you query for a non existent id with special characters. For example:
http://ergast.com/api/f1/drivers/al%22onso/constructors/alpine/seasons
http://ergast.com/api/f1/drivers/al%22onso/constructors/alpine/seasons.json
This will not be a problem with any normal usage of the API since no id field has special characters from what I understand, but I am posting this observation in case there is some other issue that can be caused due to this.
The current race schedule has the wrong start time for the Portuguese Grand Prix. It starts at 14:00:00 UTC, not the 13:00:00 UTC in the API (according to Formula1.com website).
http://ergast.com/api/f1/2021/3 or http://ergast.com/api/f1/current/next
Hey,
Plus one’ing John’s post above, Portuguese start time seems to be off.
Thanks for providing the API and all the work.
HI Kaustubh,
Thanks for the warning – that should be an error condition.
Cheers,
Chris
Hi John,
Thanks for the warning – now fixed.
Chris
Hi,
Just noticed that the results in JSON for the season 2021 does not include the latest race (Portimao). I noticed that /results contains it, but not when specifying JSON.
Has it just been missed or am I doing something wrong?
http://ergast.com/api/f1/2021/results.json
Thanks
Hi Anders,
The responses are limited by default to 30 results. You need to add an offset parameter to see the later results as described in the documentation on Response paging.
For example: http://ergast.com/api/f1/2021/results.json?offset=30
Alternatively, you can specify the round:
http://ergast.com/api/f1/2021/3/results.json
Cheers,
Chris
Hello,
When can we expect the pitstops for the 2021 Spanish Grand Prix?
http://ergast.com/api/f1/2021/4/pitstops/1.json
Thanks!
Hi Michel,
I’ve been unable to obtain it – but still trying.
Chris
Hi Chris,
Thanks! Hope you will get it!
There’s a typo in the URL of a race:
SELECT * FROM races WHERE url LIKE “%ii%”;
Thanks NSAC – now corrected
Chris
F1 seventh GP isn’t the French GP, but canadian gp
Hi Simone,
I can’t find the Canadian Grand Prix in the FIA Race Calendar. I think it was cancelled unfortunately.
Chris