Windsor brings all your Strava data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Strava Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| activities__achievement_count | NUMERIC | activities.achievement_count | activities.achievement_count | activities |
| activities__athlete | OBJECT | activities.athlete | activities.athlete | activities |
| activities__athlete_count | NUMERIC | activities.athlete_count | activities.athlete_count | activities |
| activities__average_speed | NUMERIC | activities.average_speed | activities.average_speed | activities |
| activities__average_temp | NUMERIC | activities.average_temp | activities.average_temp | activities |
| activities__average_watts | NUMERIC | activities.average_watts | activities.average_watts | activities |
| activities__comment_count | NUMERIC | activities.comment_count | activities.comment_count | activities |
| activities__commute | BOOLEAN | activities.commute | activities.commute | activities |
| activities__device_watts | BOOLEAN | activities.device_watts | activities.device_watts | activities |
| activities__display_hide_heartrate_option | BOOLEAN | activities.display_hide_heartrate_option | activities.display_hide_heartrate_option | activities |
| activities__distance | NUMERIC | activities.distance | activities.distance | activities |
| activities__elapsed_time | NUMERIC | activities.elapsed_time | activities.elapsed_time | activities |
| activities__elev_high | NUMERIC | activities.elev_high | activities.elev_high | activities |
| activities__elev_low | NUMERIC | activities.elev_low | activities.elev_low | activities |
| activities__end_latlng | OBJECT | activities.end_latlng | activities.end_latlng | activities |
| activities__external_id | TEXT | activities.external_id | activities.external_id | activities |
| activities__flagged | BOOLEAN | activities.flagged | activities.flagged | activities |
| activities__from_accepted_tag | BOOLEAN | activities.from_accepted_tag | activities.from_accepted_tag | activities |
| activities__gear_id | TEXT | activities.gear_id | activities.gear_id | activities |
| activities__has_heartrate | BOOLEAN | activities.has_heartrate | activities.has_heartrate | activities |
| activities__has_kudoed | BOOLEAN | activities.has_kudoed | activities.has_kudoed | activities |
| activities__heartrate_opt_out | BOOLEAN | activities.heartrate_opt_out | activities.heartrate_opt_out | activities |
| activities__id | NUMERIC | activities.id | activities.id | activities |
| activities__kilojoules | NUMERIC | activities.kilojoules | activities.kilojoules | activities |
| activities__kudos_count | NUMERIC | activities.kudos_count | activities.kudos_count | activities |
| activities__location_city | TEXT | activities.location_city | activities.location_city | activities |
| activities__location_country | TEXT | activities.location_country | activities.location_country | activities |
| activities__location_state | TEXT | activities.location_state | activities.location_state | activities |
| activities__manual | BOOLEAN | activities.manual | activities.manual | activities |
| activities__map | OBJECT | activities.map | activities.map | activities |
| activities__max_speed | NUMERIC | activities.max_speed | activities.max_speed | activities |
| activities__max_watts | NUMERIC | activities.max_watts | activities.max_watts | activities |
| activities__moving_time | NUMERIC | activities.moving_time | activities.moving_time | activities |
| activities__name | TEXT | activities.name | activities.name | activities |
| activities__photo_count | NUMERIC | activities.photo_count | activities.photo_count | activities |
| activities__pr_count | NUMERIC | activities.pr_count | activities.pr_count | activities |
| activities__private | BOOLEAN | activities.private | activities.private | activities |
| activities__resource_state | NUMERIC | activities.resource_state | activities.resource_state | activities |
| activities__start_date | TEXT | activities.start_date | activities.start_date | activities |
| activities__start_date_local | TEXT | activities.start_date_local | activities.start_date_local | activities |
| activities__start_latitude | NUMERIC | activities.start_latitude | activities.start_latitude | activities |
| activities__start_latlng | OBJECT | activities.start_latlng | activities.start_latlng | activities |
| activities__start_longitude | NUMERIC | activities.start_longitude | activities.start_longitude | activities |
| activities__timezone | TEXT | activities.timezone | activities.timezone | activities |
| activities__total_elevation_gain | NUMERIC | activities.total_elevation_gain | activities.total_elevation_gain | activities |
| activities__total_photo_count | NUMERIC | activities.total_photo_count | activities.total_photo_count | activities |
| activities__trainer | BOOLEAN | activities.trainer | activities.trainer | activities |
| activities__type | TEXT | activities.type | activities.type | activities |
| activities__upload_id | NUMERIC | activities.upload_id | activities.upload_id | activities |
| activities__upload_id_str | TEXT | activities.upload_id_str | activities.upload_id_str | activities |
| activities__utc_offset | NUMERIC | activities.utc_offset | activities.utc_offset | activities |
| activities__visibility | TEXT | activities.visibility | activities.visibility | activities |
| activities__weighted_average_watts | NUMERIC | activities.weighted_average_watts | activities.weighted_average_watts | activities |
| activities__workout_type | NUMERIC | activities.workout_type | activities.workout_type | activities |
| athlete_stats__all_ride_totals | OBJECT | athlete_stats.all_ride_totals | athlete_stats.all_ride_totals | athlete_stats |
| athlete_stats__all_run_totals | OBJECT | athlete_stats.all_run_totals | athlete_stats.all_run_totals | athlete_stats |
| athlete_stats__all_swim_totals | OBJECT | athlete_stats.all_swim_totals | athlete_stats.all_swim_totals | athlete_stats |
| athlete_stats__biggest_climb_elevation_gain | NUMERIC | athlete_stats.biggest_climb_elevation_gain | athlete_stats.biggest_climb_elevation_gain | athlete_stats |
| athlete_stats__biggest_ride_distance | NUMERIC | athlete_stats.biggest_ride_distance | athlete_stats.biggest_ride_distance | athlete_stats |
| athlete_stats__recent_ride_totals | OBJECT | athlete_stats.recent_ride_totals | athlete_stats.recent_ride_totals | athlete_stats |
| athlete_stats__recent_run_totals | OBJECT | athlete_stats.recent_run_totals | athlete_stats.recent_run_totals | athlete_stats |
| athlete_stats__recent_swim_totals | OBJECT | athlete_stats.recent_swim_totals | athlete_stats.recent_swim_totals | athlete_stats |
| athlete_stats__ytd_ride_totals | OBJECT | athlete_stats.ytd_ride_totals | athlete_stats.ytd_ride_totals | athlete_stats |
| athlete_stats__ytd_run_totals | OBJECT | athlete_stats.ytd_run_totals | athlete_stats.ytd_run_totals | athlete_stats |
| athlete_stats__ytd_swim_totals | OBJECT | athlete_stats.ytd_swim_totals | athlete_stats.ytd_swim_totals | athlete_stats |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |