Feedback

If you have any comments, suggestions or feature requests please add them here. Problems and errata can be reported on Bug Reports page.

Comments

466 responses to “Feedback”

  1. Admin Avatar
    Admin

    Hi Vivec,
    Apologies – now published.
    Thanks for the reminder.
    Chris

  2. Vivec Avatar

    Hi Chris,

    Want to thank you again for this amazing resource!
    I’ve recently put racing-statistics.com live. It’s mostly geared towards comparison of drivers, constructors and careers. More to come in the next few weeks and months.
    Could not have done this without your data!

    cheers!

    Marien
    The Netherlands

  3. James Murrell Avatar

    Hello, as always love the work you do for this site. just one question, do you know when you will be updating 2018 drivers. I only ask as my site relies on your data

  4. Admin Avatar
    Admin

    Hi James,
    I’ve added all the prospective drivers I’m aware of to the database. A list of drivers and constructors for the year is only available after the first race, due to the design of the database. The logic here is that you never really know who’s going to turn up at the first race (remembering the US F1 hype)
    Chris

  5. James Murrell Avatar

    wow thanks. forgot about that. great work as always….

  6. Rolandas Avatar
    Rolandas

    Hi,
    Thanks for great work You do. I’m using this data for challenge with colleagues about race standings. But we using for the challenge and Practice results.
    Do You have plans add Practice results?

  7. Toby Avatar

    Hi Chris
    I was wondering whether the issue with the import of the lap times is still likely to be an issue this season? When would you typically expect a full update to be completed after a race? And also the likely lag to the disc image? I understand this will vary and is on a best endeavors basis but just wanting to get an idea of how quickly after races we might be able to publish some analysis.
    Many thanks
    Toby

  8. Admin Avatar
    Admin

    Hi Rolandas,
    Unfortunately that would be a lot of extra work because of the number of sessions, so I haven’t attempted it.
    Chris

  9. Admin Avatar
    Admin

    Hi Toby,
    Hopefully I can keep to the original target of 3 – 6 hrs after the race. However, the first race of the season often throws up some surprises so I can’t guarantee this initially.
    Chris

  10. Jon Avatar
    Jon

    For the schedule – is it race only, or is it possible to retrieve times of practice/qualifying sessions?

    Also, is there somewhere you source this data from automatically, or do you enter it manually once a year?

    Thanks

  11. Toby Avatar

    Hi Chris

    Just a heads up in case you weren’t aware. It looks like the race data is updated for access via the API but the db image was last updated 18/3 so doesn’t yet include data for the Australian GP.

    Cheers
    Toby

  12. Admin Avatar
    Admin

    Hi Toby, Thanks for the reminder – now updated. I was pre-occupied fixing problems with the data import on race day.
    Chris

  13. Admin Avatar
    Admin

    Hi Jon,
    The schedule is currently race only. There are various sources but they’re not usually in a convenient format!
    Chris

  14. dakota Avatar
    dakota

    I downloaded the db image & opened in MySQL. Lap times from Australian GP aren’t in there, unless I’m doing something wrong.

  15. Admin Avatar
    Admin

    Hi Dakota, Apologies. Check the lastest image – they should be there.
    Chris

  16. dakota Avatar
    dakota

    Perfect! Thanks so much. This website is awesome.

  17. Toby Avatar

    Hi Chris

    Just looking at the pitstops table for the Chinese GP for 2017 (raceId==970). There seems to be 82 records? For example Massa and Perez have 6 pitstops recorded for China 2017. Something looks amiss.

    I am planning to write some validation code do a range of checks on the database sometime soon which should help to turn up anything that looks odd like this. Will let you know once when I make some progress.

    Cheers
    Toby

  18. Admin Avatar
    Admin

    Hi Toby, I think it was an unusual race with lots of changes between wet, intermediate and slick tyres. You can check here: https://www.fia.com/events/fia-formula-one-world-championship/season-2017/eventtiming-information-27
    Validation tests would be good though!
    Chris

  19. Toby Avatar

    Thanks Chris, I did do a spot check on lap times to try to make sense of the stops but clearly didn’t look closely enough! Will let you know when I make some progress on validation

    Cheers
    Toby

  20. Felipe Avatar
    Felipe

    This is a great resource, thank you!

    Are there plans to add tire data in the future?

    Cheers,
    Felipe

  21. Admin Avatar
    Admin

    Hi Felipe,
    Unfortunately, I haven’t been able to find a consistent and reliable source of tyre data. It would be great to include it
    Chris

  22. Tom H Avatar
    Tom H

    Hello

    Do you have any documentation detailing the names of the column headers in the CSVs that can be downloaded from this website?

    I’m trying to make sense of them but can’t.

    driver_standings.csv for example has a column A with values ranging from 1 to 68688.

    Many thanks for your help

    Tom

  23. Admin Avatar
    Admin

    Hi Tom,
    The database tables are described in the schema: http://ergast.com/schemas/f1db_schema.txt

    For example the Driver Standings table has seven fields in each row:

    driverStandingsId
    raceId
    driverId
    points
    position
    positionText
    wins

    The CSV file doesn’t include these column labels so your software it has probably used A, B, etc. The A column probably corresponds to the driverStandingsId which is simply a unique value to identify each entry in the table.

    Note the other Id fields reference entries in other tables e.g. the driverId above references the driverId field in the Driver table.

    Hope that helps,
    Chris

  24. Stergios Avatar

    Hi Chris,

    I know you discussed many times about the practice results. Can you lead me to any source/sources that have FP data? I may try some time to retrieve them.

  25. Admin Avatar
    Admin

    Hi Stergios,
    You can get the practice results in PDF documents from the FIA e.g. for Canada: https://www.fia.com/events/fia-formula-one-world-championship/season-2018/eventtiming-information-5
    Chris

  26. Andy Avatar
    Andy

    Hi Chris,
    great API, thanks for your work!

    I was wondering if you have any plans to include which laps were driven with a virtual or on-track safety-car.
    Best regards,
    Andreas.

  27. Admin Avatar
    Admin

    Hi Andy,
    I’m not sure where I could the data for that. I guess you could infer it from the atypical laptimes.
    Chris

  28. Umang Avatar
    Umang

    On which api i can find world champion lists from 2005 to 2015 name with Grand Prix?
    Currently i am referring (http://ergast.com/api/f1/driverStandings/1.json?callback=JSON_CALLBACK&limit=11&offset=55) this API but on that response i can’t able to find Grand Prix name.

  29. Admin Avatar
    Admin

    Hi Umang,
    A World Champion is associated with a season, rather than a single Grand Prix. What races are you trying to identify.
    Chris

  30. Umang Avatar
    Umang

    HI Chris, Thanks for your quick response. On first page i want to display World champion list and on second page i want to shows the list of the winners for every race for the selected year with highlight the row when the winner has been the world champion on grand prix of same season.

    Currently i am referring below webservices

    http://ergast.com/api/f1/driverStandings/1.json?callback=JSON_CALLBACK&limit=11&offset=55

    http://ergast.com/api/f1/2008/results/1.json?callback=JSON_CALLBACK

    Please let me know your view on same.

  31. Admin Avatar
    Admin

    Hi Umang,
    Yes, you will have to use these two queries. Unfortunately, it is not possible to use both results and standings parameters in a single Ergast API query.
    Chris

  32. Andy Avatar
    Andy

    Hi Chris,

    thanks for your quick reply.

    The only source for Safety-Car laps, I know of, is the FIA’s Lap Chart ( e.g., https://www.fia.com/events/fia-formula-one-world-championship/season-2018/lap-chart-27 ).
    But that does not have a “converter-friendly” format 😉

    Best regards

  33. Alim Avatar
    Alim

    Hi Chris,

    Is it possible to get upcoming GP info?

  34. Admin Avatar
    Admin

    Hi Alim,
    You can use this URL:
    http://ergast.com/api/f1/current/next.json
    Chris

  35. Bas Avatar
    Bas

    Hi Chris,
    First of all: thank you for providing this great API!

    Two questions:
    – Will the disqualification of Grosjean in Italy be updatet in the data?
    – And will the ‘new’ team Racing Point Force India be included in the data?

    Kind regards,
    Bas

  36. Admin Avatar
    Admin

    Hi Bas,
    Thanks for the warning – I’ve been away so I wasn’t aware. Grosjean has been updated. For Force India, I don’t propose to change the team name but I’ve reset the points to zero in the constructor standings.
    Chris

  37. Alexander Avatar
    Alexander

    Hi!
    I have the same question as Jon (commented on: 26 March 2018 at 23:20)
    Are there any updates?
    Maybe is there a way to get the schedule of practice and qualifying?

  38. Admin Avatar
    Admin

    Hi Alexander,
    I’ll look into this at the end of the season, for next year. However, I’ll need to find a reliable source of the data and work out how to represent it in the API.
    Chris

  39. Britta Avatar
    Britta

    Thanks for the API, it’s been really useful!

  40. Chris Avatar
    Chris

    Thanks for giving dumps of the database. Very helpful!

  41. Arjan Mantjes Avatar
    Arjan Mantjes

    I just downloaded all the data, but i cannot find the relation for drivers and the team they belong to in every year ??

  42. Admin Avatar
    Admin

    Hi Arjan,
    The relationship between drivers and constructors is established through entries in the results table. This is necessary, since historically, drivers may change teams mid-season.
    Chris

  43. juansanluq Avatar
    juansanluq

    Any way to get the team mates of specific driver?

  44. Admin Avatar
    Admin

    Hi Juan,
    There’s no specific API method for this but you could use the driver list for the year:

    http://ergast.com/api/f1/current/drivers.json

    or if you know the constructorId:

    http://ergast.com/api/f1/current/constructors/<constructorId>/drivers.json

    Chris

  45. Mark Avatar
    Mark

    Hi, why are you using nationalities (demonyms) instead of country codes in driver and constructor information? It’s pretty hard to generate emoji flags upon demonyms with existing js libraries (quite a pain to write my own one 🙂 ). Otherwise – super cool API!

  46. Admin Avatar
    Admin

    Hi Mark,
    I guess the nationalities were intended for presentation purposes. If you can send me a table of nationalities to country codes I could add a column to the driver and constructor tables.
    Cheers,
    Chris

  47. Mark Avatar
    Mark

    Hi Chris,

    Not sure what you meant by table here, but here’s a JSON with required data: https://github.com/meeDamian/country-emoji/pull/10/commits/502b9cbbd9ab864edfac041dbc0a4fe494494098. Let me know if it’s ok, otherwise I’ll find something else!

    Mark

  48. Admin Avatar
    Admin

    Thanks Mark – can’t promise when I’ll get around to it, but this mapping will be useful.
    Cheers,
    Chris

  49. Emile de Bruijn Avatar
    Emile de Bruijn

    Hi,

    The results for the latest GP are changed and still not reflected in the API.
    Gasly is now tenth…

  50. Miguel Bento Avatar
    Miguel Bento

    Hi Chris,

    I noticed that the resuts from 1996 to 2003 do not contain the fastest lap information. However, I have been playing a bit with a copy of the database and came up with two update statements that take this info from the LapTimes table and updates the relevant fields in the Results table.

    First update statement (it updates fastestLap and fastestLapTime and takes just some milliseconds to run):

    update results
    set (fastestLap,fastestLapTime) = (select lap, time from (select l.lap, l.time, min(l.milliseconds) from laptimes l where l.raceId=results.raceId and l.driverId=results.driverId))
    where raceId in (select raceId from races where year between 1996 and 2003);

    Second update statement (this one updates ‘rank’ and takes 8 seconds to run on my laptop):

    update results
    set rank=(select count(*)+1 from results r where r.raceId = results.raceId and r.fastestLapTime 0 and raceId in (select raceId from races where year between 1996 and 2003);

    Do you want to give it a try?

    Thanks, and keep up the great work.
    Miguel

Leave a Reply

Your email address will not be published. Required fields are marked *