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
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