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: 12/06/2018

1950 – 2018 MySQL Database Image

The ANSI version is better suited for import and conversion into other database formats. The character encoding is “utf8” in both versions.

f1db.sql.gz  MySQL 5.1 database dump

f1db_ansi.sql.gz  MySQL ANSI 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:

f1db_csv.zip

The text encoding is UTF-8.

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 this database image 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.