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/12/2019

1950 – 2019 MySQL Database Images

MySQL, PostgreSQL and ANSI compatible data dumps. The ANSI version is intended for conversion and import into other database formats such as SQLite. The character encoding is “utf8” in all versions.

f1db.sql.gz  MySQL 5.1 database dump

f1db_postgres.sql.gz  PostgreSQL compatible MySQL 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 analysis software:

The text encoding is UTF-8.

Database Schema

The tables of the database are described in this schema:



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


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