Driver Table Multiple Rows For Driver, Meeting & Session

br-g / openf1

OpenF1 API - Real-time and historical Formula 1 data

Other

399 stars 22 forks source link

Driver Table Multiple Rows For Driver, Meeting & Session #43

Closed rich-howell closed 7 months ago

rich-howell commented 8 months ago

In the drivers table there seems to be two rows for the same driver_key,meeting_key & session_key with some of the information like team_name and headshot_url missing from one row but not the other.

Example

driver_key = 77
meeting_key = 1229
session_key = 9466

This can be seen in the CSV file

Aswell as the returned JSON from the endpoint https://api.openf1.org/v1/drivers?driver_number=77&meeting_key=1229&session_key=9466

PrestonHager commented 7 months ago

Data is being duplicated during the ingestor phase. Each driver has two database entries, one with correct data and one with data missing. This could be a possible duplicate of #42 or maybe an extension of that issue. Best fix for the client would be to filter or merge any duplicate data to throw away nulls.

br-g commented 7 months ago

Fixed! Thanks for reporting the issue 👍