I found a few errors in the lap timing csv. I noticed these because of merge errors between the lap_times and results csv files.
For the 1999 Brazillian GP:
Laps are recorded for Badoer (driverId: 69) although he sat that race out for an injury. I believe these laps should belong to Stephane Sarrazin (driverId: 72).
For 1997 European GP:
I don’t believe Giannin Morbidelli (driverId: 81) participated in that race, although he has lap times attributed to him. I believe these laps should belong to Norberto Fontana (driverId: 82).
For the 1999 San Marino GP, Monaco GP, and Spanish GP:
Laps are attributed to Ricardo Zonta (driverId: 41), although he was out with at foot injury. Mika Salo (driverId: 63) raced these three races for BAR.
Thank you so much for maintaining all this data, lots of fun to play with on weekends without races =D
Hi Niclas,
Actually, the status is present in the JSON results – it’s the statusId which is missing. I’m not sure why I included the statusId in the XML – it may have been a mistake I corrected in the JSON!
Chris
Hello!
the team ranking seems to be wrong, the India force marks the fourth place, in fact, from the official site, after the change of company is at the seventh.
Regards
Marco
it’s pretty easy to get altitude for all circuits, btw: https://hastebin.com/ezenicikaf.makefile (In there is a prepared post request you can paste into your terminal.)
Possible the problem is at my end (unpacking the sql into pandas dataframes – although the process has always worked previously) but I am only seeing results to Russia from the disk image after Austin. Had no problem updating from the API though.
Hi Toby,
I can see Kimi’s U.S. Grand Prix time in the SQL dump (1:34:18.643) but I guess there could be an issue elsewhere.
I’ve re-run the dump script so it might be worth another try.
Chris
your database really helps a lot while learning to write proper SQL queries. Unfortunately, I am not really knowing a lot about the history of F1… The constructorResultIds 14985, 14986, 14805, and 14806 are the only rows before 1958 that have points. Is that a bug?
Hi Marcus,
Thanks – I’ll investigate. The constructorResults is an intermediate table, used in calculating the standings, and may not have been used when loading historical data from various sources.
Chris
Hi Andrea,
The problems with the qualifying is caused by the fact that qualifying information is only supported from 1994 onwards – after the start of Senna’s career unfortunately. Similarly Lap Time information is only supported from 1996 onwards. Unfortunately, it has been difficult to find earlier data.
Chris
Thanks for the warning Latsi – now updated.
Chris
Hello,
I found a few errors in the lap timing csv. I noticed these because of merge errors between the lap_times and results csv files.
For the 1999 Brazillian GP:
Laps are recorded for Badoer (driverId: 69) although he sat that race out for an injury. I believe these laps should belong to Stephane Sarrazin (driverId: 72).
For 1997 European GP:
I don’t believe Giannin Morbidelli (driverId: 81) participated in that race, although he has lap times attributed to him. I believe these laps should belong to Norberto Fontana (driverId: 82).
For the 1999 San Marino GP, Monaco GP, and Spanish GP:
Laps are attributed to Ricardo Zonta (driverId: 41), although he was out with at foot injury. Mika Salo (driverId: 63) raced these three races for BAR.
Thank you so much for maintaining all this data, lots of fun to play with on weekends without races =D
Regards,
Luke
Hi Luke,
Thanks for the corrections – now updated.
Chris
Hi
Thanks for the API, really nice to get F1 data and play around with.
I’m fetching data with
http://ergast.com/api/f1/current/last/results.json
Details: Under Result, there is Driver, Constructor, Status, Time and FastesLap in xml response.
But in the json response there is Driver, Constructor, Time and FastesLap…not Status.
Regards
Niclas
Hi Niclas,
Actually, the status is present in the JSON results – it’s the statusId which is missing. I’m not sure why I included the statusId in the XML – it may have been a mistake I corrected in the JSON!
Chris
Hello!
the team ranking seems to be wrong, the India force marks the fourth place, in fact, from the official site, after the change of company is at the seventh.
Regards
Marco
Hi Marco,
Thanks for the warning – I forgot to reset Force India’s points.
Chris
I have found 3 tiny ones.
In one row of qualifying.csv q2 is ‘1:48:552’ instead of ‘1:48.552’:
– 5665,891,3,131,9,4,”2:01.099″,”1:48:552″,”2:02.251″
And in constructor_results.csv are two duplicates:
– 612,75,7,11,\N
– 14128,75,7,11,\N
– 14845,903,3,6,\N
– 14852,903,3,6,\N
Hi,
it’s pretty easy to get altitude for all circuits, btw: https://hastebin.com/ezenicikaf.makefile (In there is a prepared post request you can paste into your terminal.)
Regards,
Marcus
Hi Chris
Possible the problem is at my end (unpacking the sql into pandas dataframes – although the process has always worked previously) but I am only seeing results to Russia from the disk image after Austin. Had no problem updating from the API though.
Cheers
Toby
Hi Toby,
I can see Kimi’s U.S. Grand Prix time in the SQL dump (1:34:18.643) but I guess there could be an issue elsewhere.
I’ve re-run the dump script so it might be worth another try.
Chris
Thanks Marcus! Now corrected.
Chris
Hi Chris,
your database really helps a lot while learning to write proper SQL queries. Unfortunately, I am not really knowing a lot about the history of F1… The constructorResultIds 14985, 14986, 14805, and 14806 are the only rows before 1958 that have points. Is that a bug?
Regards,
Marcus
https://imgur.com/a/eSEfCdh
Hi Marcus,
Thanks – I’ll investigate. The constructorResults is an intermediate table, used in calculating the standings, and may not have been used when loading historical data from various sources.
Chris
Hi Chris,
driverStandings and constructorStandings show wrong data.
Example.
Correct value: Vettel 320 points, Hamilton 408 points
Calling https://ergast.com/api/f1/current/drivers/vettel/results.json the sum of points is 320
Calling https://ergast.com/api/f1/current/driverStandings.json is 302
With Hamilton result do 408 and standings do 383
Regards,
Gianluca
Hi Gianluca,
Apologies, I forgot to check. Now updated.
Thanks for the warning.
Chris
Hi Chris,
I think that the qualifying result are wrong.
For example:
https://ergast.com/api/f1/drivers/senna/grid/1/qualifying
gives me 3 pole position while Senna made 65.
https://ergast.com/api/f1/drivers/michael_schumacher/grid/1/qualifying?limit=100
gives me 35 pole position while Schumacher made 68
For Fangio no pole position (the correct value is 29).
Theese problems also affect, for example, hat trick query.
Can you check?
Thanks in advance,
Regards.
Andrea
Hi Chris,
In addition to previous bug report, also fastest lap in race result is wrong.
For example
https://ergast.com/api/f1/drivers/senna/fastest/1/results?limit=100
gives me 0 fastest lap while Senna made 19.
I’ve done theese querys from your Uery Database Interface.
Thnaks again.
Andrea
Thanks Andrea – will correct.
Chris
Hi Andrea,
The problems with the qualifying is caused by the fact that qualifying information is only supported from 1994 onwards – after the start of Senna’s career unfortunately. Similarly Lap Time information is only supported from 1996 onwards. Unfortunately, it has been difficult to find earlier data.
Chris