Exporting data out of the Hub (CSV)

What you can export today

The Hub has three CSV export endpoints:

• Athlete metrics: the full MetricHistory for an athlete, all metric types, with dates and values.
• Calculator results: every CalculatorResult for an athlete, including all saved outputs.
• Race plan: the saved wizard outputs for a specific race.

All three are gated to the coach who has access to the athlete (per the access control model).

Athlete metrics CSV

URL: GET /api/athlete/<public_id>/metrics.csv.

Each row is one MetricHistory entry:

• Metric type (e.g. css_pace, critical_power, weight).
• Value (numeric).
• Value display (formatted string).
• Date the metric was recorded.
• Source (assessment, calculator, manual, activity, modeled).
• Source detail (assessment ID, activity ID if applicable).
• Needs review flag.

Use this for:

• Audit of all threshold tests over time.
• Backing up the athlete's data periodically.
• Cross-platform analysis in a spreadsheet.

Calculator results CSV

URL: GET /api/athlete/<public_id>/calculator_results.csv.

Each row is one CalculatorResult. Columns include the calculator type, race (if attached), date created, and the saved outputs.

Use this for:

• Auditing wizard runs over time.
• Comparing planned vs actual race outcomes.
• Tracking how zone estimates evolved.

Race plan CSV

URL: GET /api/race/<race_id>/plan.csv.

A single race's saved CalculatorResult outputs in a flattened CSV form:

• Race identity (name, date, distance, athlete).
• Target swim pace, CSS.
• Target bike power, projected bike time, CdA.
• Projected total time, leg splits.
• Calories per leg.
• Fueling plan summary.

Use this for:

• Printing a one-page race plan for the support crew.
• Sharing the plan with the athlete in a portable format.
• Archiving the race plan for future reference.

What you cannot export today

• All-athlete bulk export as a single file: not yet. Export per athlete.
• Wellness logs: not directly exported; visible in the admin and via the API.
• Activity FIT files: stored on disk by the upload flow, downloadable from admin but not via a single bulk CSV.
• Coach notes: per-note view in admin; no bulk export.

How to download

• From the coach dashboard, athlete detail page, or the race detail page, click Export.
• The Hub serves a CSV file with a UTF-8 BOM so Excel opens it cleanly.

Privacy reminder

CSV exports contain athlete data. Treat them with the same care as any private health information:

• Encrypt files at rest if you store them.
• Do not share via insecure channels (public links, social media).
• Delete local copies when no longer needed.

See also: Roles in the Hub, Privacy: what data we collect, Activity FIT parser metrics.