Repository navigation
v2.21
Built from the sources at this tag, and published only after
verify.py passed.
| File | What it is |
|---|---|
f1.db |
The SQLite database. Open it with any SQLite client. |
f1-geometry.db |
Circuit centrelines, © OpenStreetMap contributors under ODbL 1.0. A separate file so its share-alike does not reach the rest — see below. circuit_geometry in f1.db is deliberately empty. |
f1_database.json.gz |
Full JSON export of every table. Not kept in git — it is 21 MB and regenerates in about a second with make export. |
f1_compat.json |
JSON in the original v1 key layout. |
f1-parquet.zip |
Every table as Parquet, one file each — including the two the JSON export omits for size. Columnar and compressed: pandas, polars and DuckDB read it directly. |
schema.sql |
The schema, commented. |
SHA256SUMS |
Digests. The build is reproducible, so you can check these by rebuilding. |
Data is CC BY-SA 4.0. Circuit geometry is © OpenStreetMap
contributors under ODbL 1.0, and ships as its own file rather
than inside f1.db or the JSON export: two databases distributed
alongside each other are a Collective Database under ODbL, so the
share-alike follows f1-geometry.db alone. Take one, take both,
and the obligation follows the file it belongs to.
See ATTRIBUTION.md.
Stable links. Every asset above is also reachable at a URL
that always points at the newest release, so a script does not
need updating each time:
https://github.com/Alex-Farley/formula-1-data/releases/latest/download/f1.db
https://github.com/Alex-Farley/formula-1-data/releases/latest/download/f1-parquet.zip
Swap latest for a tag (v2.19) to pin a version instead.
The Parquet bundle is also served from the site itself:
https://lapledger.org/f1-parquet.zip
That copy is rebuilt on every deploy from the database the site
is serving, so it is never older than the pages beside it. The
release asset above is pinned to this tag; use whichever suits —
the newest data, or a version you can cite.
What's Changed
- Finish the Lap Ledger rename, and name every table by @Alex-Farley in #24
- Serve the Parquet bundle from lapledger.org; let CI be the deploy gate by @Alex-Farley in #25
- Critics, the first critique, its first two fixes, and one backlog by @Alex-Farley in #26
- review: drop the manual trigger, which could only ever fail by @Alex-Farley in #27
- review: say which of the four outcomes a green check means by @Alex-Farley in #28
- critiques: content design and information architecture, and their 33 findings by @Alex-Farley in #29
- Backlog: rank Now by defect class, split PM-20, merge the CD and IA findings by @Alex-Farley in #30
- CD-01, IA-15 and IA-04: the three that were one sitting by @Alex-Farley in #31
- gitignore: Claude Code's local settings file by @Alex-Farley in #32
- Split pole position from grid 1, and restore two shared fastest laps by @Alex-Farley in #33
- v2.21: pole is its own column by @Alex-Farley in #34
Full Changelog: v2.20...v2.21