GoldenCheetah OpenData explorer

GoldenCheetah logo
This Datasette application allows you to explore metadata from GoldenCheetah OpenData.

Please note that the raw ride data is not available in this application and should be downloaded separately.
Links to the raw data for each athlete are available in the athletes table. See the docs for more information.

Click here to start querying right away. Or take a look at the example queries below first.
The database with metadata was last updated on 2021-04-10.
There are 2 tables in this database: athletes and rides.

Athletes table

This table contains metadata for each athlete.
The columns data_url contains links to a zip with all the ride csv's for each athlete. The column metadata_url contains links to a zip with the full metadata for each athlete.

Rides table

This table contains a subset of the metadata for each ride.
The data column contains a string with a letter for each data type that is present in the csv for the ride.
Translation (source):

Example queries

Hosted by:

Data license: CC0 1.0 Universal · Data source: GoldenCheetah OpenData


2,595,513 rows in 2 tables

rides, athletes