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

Last updated: 01/11/2020

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 all versions.

f1db.sql.gz  MySQL 5.7 database dump

f1db_ansi.sql.gz  ANSI compatible 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 – see the schema below for a description of the tables. The text encoding is UTF-8 and the first line of each file contains the column headers.

Database Schema

The tables of the database are described in this schema:

f1db_schema.txt

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.