F1DB

F1DB is the most comprehensive free open source database with all-time Formula 1 racing data and statistics.

Whether you are building a custom website, mobile application or just using F1DB to query data, here is what we provide:

• All drivers
• All constructors (including chassis)
• All engine manufacturers (including engines)
• All tyre manufacturers
• All circuits and location data
• All seasons from 1950 to present; including:
  • entrants
  • standings
• All races; including:
  • free practice and warming-up results
  • qualifying and pre-qualifying results
  • sprint race results
  • starting grid positions
  • race results
  • fastest laps
  • pit stops
  • driver of the day results
  • standings

New releases will be available as soon as possible after every race. See also Versioning.

Release artifacts are available in the following formats:

• CSV
• JSON
• JSON splitted (multiple data files)
• Smile (binary variant of the JSON format)
• SQL (MySQL, PostgreSQL or SQLite .sql dump files to create and populate a custom database)
• SQL with single inserts (much smaller .sql dump files with single insert per table; better performance but not supported by all platforms)
• SQLite database

Notable changes in v2025.6.0

• Fixed type of turns property from numner to integer in Circuit and Race objects.

To accommodate this change the JSON Schema is bumped to version v6.1.1.

Notable changes in v2025.0.3

• Added polePosition property to RaceResult object.

To accommodate this change the JSON Schema is bumped to version v6.1.0.

Notable changes in v2025.0.2

• Added direction, length and turns properties to Circuit object.
• Added direction and turns properties to Race object (courseLength already exists).
• Added driversChampionshipDecider and constructorsChampionshipDecider properties to Race object.

To accommodate these changes the JSON Schema is bumped to version v6.0.0.

F1DB JSON Schema

The main f1db.schema.json schema file contains all F1DB object definitions and serves as the main documentation.

For the splitted distributions the splitted schema files must be used.

Both the JSON and Smile artifacts validate against the F1DB Json Schema.

Schema version compatibility / history

Version	Schema Version
>= v2025.6.0	f1db.schema.json v6.1.1, f1db-*.schema.json v6.1.1 splitted
>= v2025.0.3	f1db.schema.json v6.1.0, f1db-*.schema.json v6.1.0 splitted
>= v2025.0.2	f1db.schema.json v6.0.0, f1db-*.schema.json v6.0.0 splitted
>= v2024.19.0	f1db.schema.json v5.0.0, f1db-*.schema.json v5.0.0 splitted
>= v2024.0.0.beta2	f1db.schema.json v4.1.0, f1db-*.schema.json v4.1.0 splitted
>= v2024.0.0.beta1	f1db.schema.json v4.0.0, f1db-*.schema.json v4.0.0 splitted
>= v2023.22.0	onlyf1-db.schema.json v3.2.0, onlyf1-db-*.schema.json v3.2.0 splitted
>= v2023.8.0	onlyf1-db.schema.json v3.1.0, onlyf1-db-*.schema.json v3.1.0 splitted
>= v2023.4.0	onlyf1-db.schema.json v3.0.0, onlyf1-db-*.schema.json v3.0.0 splitted
>= v2023.0.0.beta1	onlyf1-db.schema.json v2.0.0, onlyf1-db-*.schema.json v2.0.0 splitted
>= v2022.1.1	f1db-json-schema-v1.4.0.json
>= v2022.0.0	f1db-json-schema-v1.3.0.json
>= v2022.0.0.beta4	f1db-json-schema-v1.3.0.json
>= v2022.0.0.beta3	f1db-json-schema-v1.2.0.json
>= v2022.0.0.beta2	f1db-json-schema-v1.1.0.json
>= v2022.0.0.alpha1	f1db-json-schema-v1.0.0.json

F1DB SQL / SQLite Database

The SQLite database artifact contains all data in a relational database format and can be used to directly query the data instead of processing the JSON format.

The database file could also serve students who want to learn SQL.

We suggest to use SQLiteStudio for querying the database file. Of course any SQLite compliant SQL client can be used as well.

Since v2024.3.0 SQL artifacts are available for MySQL, PostgreSQL and SQLite that provide .sql dump files to import the schema and data directly in these database systems.

If you want to populate another database system (e.g. H2) then most likely the PostgreSQL .sql dump file is your best option. If that doesn't work, and you want a .sql dump file for another database system to be added to the release artifacts, then please create a feature request.

Versioning

Releases are versioned using a "customized" CalVer versioning scheme:

YYYY.RR.MICRO(.MODIFIER)

which uses the following conventions:

• YYYY – Full year of the season – 2025, ..
• RR – Round number within the season – 0, 1, 2, .., 10, 11, ..
• MICRO – Patch version – 0, 1, 2, ..
• MODIFIER – An optional text tag like dev, alpha, beta, rc, ..

Note this is basically the YYYY.MINOR.MICRO(.MODIFIER) pattern where MINOR indicates the round number (RR).

Examples:

• 2025.0.0 – Pre-season release before the 1^st race round of the 2025 season.
• 2025.0.1 – Pre-season patch release before the 1^st race round of the 2025 season.
• 2025.0.1 – First pre-season patch release before the 1^st race round of the 2025 season.
• 2025.1.0 – Final release after the 1^st race round of the 2025 season.
• 2025.2.0 – Final release after the 2^nd race round of the 2025 season.
• 2025.2.1 – First patch release after the 2^nd race round of the 2025 season.
• 2025.2.2 – Second patch release after the 2^nd race round of the 2025 season.

As you can see we use a special RR 0 for pre-season releases.

Community

The F1DB community can be found on GitHub Discussions, where you can ask and answer questions, voice ideas, and share your projects.

Keep in touch with us by following us on X or Bluesky.

Reporting Data Issues

We use GitHub Issues to track data issues or related problems.

If you found a data issue which is not reported yet, please create a new issue.

Building from Source

To build the distribution zips simply run:

./gradlew clean build

or without running the tests (way faster):

./gradlew clean build -x test

The build requires Java 21, running the tests requires an environment with Docker.

Releasing

GitHub Actions is used to build and upload new releases by creating a new git tag.

Follow these steps:

1. Update the version number in gradle.properties
2. git commit -am "Release v<version>"
3. git push
4. git tag -a v<version> -m "Release v<version>"
5. git push origin v<version>

and the release action is automatically triggered by pushing the new tag.

License

F1DB is licensed under a Creative Commons Attribution 4.0 International License.