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: 29/07/2018

1950 – 2018 MySQL Database Images

MySQL, PostgreSQL and ANSI compatible data dumps. The ANSI version is intended for import and conversion 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:

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.