Database Images

Complete images of the Ergast database are published shortly after each race under the Attribution-NonCommercial-ShareAlike 3.0 Unported Licence.

Creative Commons Licence

The structure of the database is shown in an Entity Relation Diagram and explained in the Database User Guide. The tables were created using: f1db_tables.sql

The database images were last updated on: 25/07/2021

MySQL Database Images

These are MySQL (5.7) data dumps. The ANSI version may be easier to import into other database formats. The character encoding is “utf8” in both versions.

f1db.sql.gz  MySQL 5.7 database dump

f1db_ansi.sql.gz  "ANSI compatible" MySQL database dump

CSV Database Tables

The database can also be downloaded as a set of CSV files which can be imported into spreadsheets and other types of software:

f1db_csv.zip

Each CSV file contains a single database table. The text encoding is UTF-8 and the first line of each file contains the column headers. The tables are described in the User Guide.

Disclaimer

The author disclaims all responsibility for any loss or damage arising from the use of these database images and cannot guarantee the accuracy of the data.

Attribution

Attribution is optional but appreciated when addressing a technical audience. A reference to “Ergast” with a link back to this site is sufficient.