Baselight

Running And Heart Rate Data

Running and Heart rate summary, stop, start and lap event data

@kaggle.mcandocia_running_heart_rate_recovery

Loading...
Loading...

About this Dataset

Running And Heart Rate Data

Context

I have been collecting GPS, heart rate, and temperature data from my runs over the past year. This data corresponds to the stopwatch stop & start events.

Content

Each row contains data from when I stopped my watch and started it again, as well as some summarized data over various time windows before the stop, as well as a few variables describing the overall run (e.g., average temperature, average longitude/latitude).

Inspiration

I wanted to see how my heart rate dropped based on various variables. I've used nonlinear regression to get a decent model in terms of heart rate, rest time, and temperature, but it seems to overestimate heart rate recovery for higher temperatures in more intense runs.

Tables

Ph Scores

@kaggle.mcandocia_running_heart_rate_recovery.ph_scores
  • 20.07 KB
  • 834 rows
  • 3 columns
Loading...

CREATE TABLE ph_scores (
  "full_path" VARCHAR,
  "score" DOUBLE,
  "event_id" BIGINT
);

S1 Laps Summary

@kaggle.mcandocia_running_heart_rate_recovery.s1_laps_summary
  • 5.02 MB
  • 5623 rows
  • 214 columns
Loading...

CREATE TABLE s1_laps_summary (
  "event_id" BIGINT,
  "timestamp" VARCHAR,
  "heart_rate" DOUBLE,
  "time_elapsed" DOUBLE,
  "total_running_time" DOUBLE,
  "altitude" DOUBLE,
  "distance" DOUBLE,
  "speed" DOUBLE,
  "cadence" DOUBLE,
  "start_time" TIMESTAMP,
  "start_position_lat" DOUBLE,
  "start_position_long" DOUBLE,
  "end_position_lat" DOUBLE,
  "end_position_long" DOUBLE,
  "total_elapsed_time" DOUBLE,
  "total_timer_time" DOUBLE,
  "total_distance" DOUBLE,
  "total_strides" DOUBLE,
  "total_calories" DOUBLE,
  "enhanced_avg_speed" DOUBLE,
  "avg_speed" DOUBLE,
  "enhanced_max_speed" DOUBLE,
  "max_speed" DOUBLE,
  "total_ascent" DOUBLE,
  "total_descent" DOUBLE,
  "event" VARCHAR,
  "event_type" VARCHAR,
  "avg_heart_rate" DOUBLE,
  "max_heart_rate" DOUBLE,
  "avg_running_cadence" DOUBLE,
  "max_running_cadence" DOUBLE,
  "lap_trigger" VARCHAR,
  "sub_sport" VARCHAR,
  "avg_fractional_cadence" DOUBLE,
  "max_fractional_cadence" DOUBLE,
  "total_fractional_cycles" VARCHAR,
  "avg_vertical_oscillation" VARCHAR,
  "avg_temperature" VARCHAR,
  "max_temperature" VARCHAR,
  "timestamp_utc" TIMESTAMP,
  "timezone" VARCHAR,
  "timestamp_previous" VARCHAR,
  "lap_id" DOUBLE,
  "rest_time" DOUBLE,
  "n_rests" DOUBLE,
  "altitude_change_past_60_seconds" DOUBLE,
  "altitude_change_past_120_seconds" DOUBLE,
  "altitude_change_past_180_seconds" DOUBLE,
  "altitude_change_past_240_seconds" DOUBLE,
  "altitude_change_past_300_seconds" DOUBLE,
  "altitude_change_past_360_seconds" DOUBLE,
  "altitude_change_past_420_seconds" DOUBLE,
  "altitude_change_past_480_seconds" DOUBLE,
  "altitude_change_past_540_seconds" DOUBLE,
  "altitude_change_past_600_seconds" DOUBLE,
  "altitude_change_past_660_seconds" DOUBLE,
  "altitude_change_past_720_seconds" DOUBLE,
  "altitude_change_past_780_seconds" DOUBLE,
  "altitude_change_past_840_seconds" DOUBLE,
  "altitude_change_past_900_seconds" DOUBLE,
  "altitude_change_past_1800_seconds" DOUBLE,
  "altitude_change_past_3600_seconds" DOUBLE,
  "altitude_change_past_7200_seconds" DOUBLE,
  "altitude_change_past_10800_seconds" DOUBLE,
  "altitude_change_past_14400_seconds" DOUBLE,
  "speed_past_60_seconds" DOUBLE,
  "speed_past_120_seconds" DOUBLE,
  "speed_past_180_seconds" DOUBLE,
  "speed_past_240_seconds" DOUBLE,
  "speed_past_300_seconds" DOUBLE,
  "speed_past_360_seconds" DOUBLE,
  "speed_past_420_seconds" DOUBLE,
  "speed_past_480_seconds" DOUBLE,
  "speed_past_540_seconds" DOUBLE,
  "speed_past_600_seconds" DOUBLE,
  "speed_past_660_seconds" DOUBLE,
  "speed_past_720_seconds" DOUBLE,
  "speed_past_780_seconds" DOUBLE,
  "speed_past_840_seconds" DOUBLE,
  "speed_past_900_seconds" DOUBLE,
  "speed_past_1800_seconds" DOUBLE,
  "speed_past_3600_seconds" DOUBLE,
  "speed_past_7200_seconds" DOUBLE,
  "speed_past_10800_seconds" DOUBLE,
  "speed_past_14400_seconds" DOUBLE,
  "heart_rate_past_60_seconds" DOUBLE,
  "heart_rate_past_120_seconds" DOUBLE,
  "heart_rate_past_180_seconds" DOUBLE,
  "heart_rate_past_240_seconds" DOUBLE,
  "heart_rate_past_300_seconds" DOUBLE,
  "heart_rate_past_360_seconds" DOUBLE,
  "heart_rate_past_420_seconds" DOUBLE,
  "heart_rate_past_480_seconds" DOUBLE,
  "heart_rate_past_540_seconds" DOUBLE,
  "heart_rate_past_600_seconds" DOUBLE,
  "heart_rate_past_660_seconds" DOUBLE,
  "heart_rate_past_720_seconds" DOUBLE,
  "heart_rate_past_780_seconds" DOUBLE,
  "heart_rate_past_840_seconds" DOUBLE,
  "heart_rate_past_900_seconds" DOUBLE
);

S1 Start To Stop

@kaggle.mcandocia_running_heart_rate_recovery.s1_start_to_stop
  • 3.99 MB
  • 4549 rows
  • 189 columns
Loading...

CREATE TABLE s1_start_to_stop (
  "event_id" BIGINT,
  "rest_time" DOUBLE,
  "timestamp_stop" VARCHAR,
  "timestamp_start" VARCHAR,
  "heart_rate_stop" DOUBLE,
  "heart_rate_start" DOUBLE,
  "time_elapsed" DOUBLE,
  "total_running_time" DOUBLE,
  "time_since_last_stop" DOUBLE,
  "time_from_start_to_stop" DOUBLE,
  "altitude_start" DOUBLE,
  "distance_start" DOUBLE,
  "speed_start" DOUBLE,
  "cadence_start" DOUBLE,
  "datetime_ts" VARCHAR,
  "altitude_stop" DOUBLE,
  "distance_stop" DOUBLE,
  "speed_stop" DOUBLE,
  "cadence_stop" DOUBLE,
  "altitude_change_past_60_seconds" DOUBLE,
  "altitude_change_past_120_seconds" DOUBLE,
  "altitude_change_past_180_seconds" DOUBLE,
  "altitude_change_past_240_seconds" DOUBLE,
  "altitude_change_past_300_seconds" DOUBLE,
  "altitude_change_past_360_seconds" DOUBLE,
  "altitude_change_past_420_seconds" DOUBLE,
  "altitude_change_past_480_seconds" DOUBLE,
  "altitude_change_past_540_seconds" DOUBLE,
  "altitude_change_past_600_seconds" DOUBLE,
  "altitude_change_past_660_seconds" DOUBLE,
  "altitude_change_past_720_seconds" DOUBLE,
  "altitude_change_past_780_seconds" DOUBLE,
  "altitude_change_past_840_seconds" DOUBLE,
  "altitude_change_past_900_seconds" DOUBLE,
  "altitude_change_past_1800_seconds" DOUBLE,
  "altitude_change_past_3600_seconds" DOUBLE,
  "altitude_change_past_7200_seconds" DOUBLE,
  "altitude_change_past_10800_seconds" DOUBLE,
  "altitude_change_past_14400_seconds" DOUBLE,
  "speed_past_60_seconds" DOUBLE,
  "speed_past_120_seconds" DOUBLE,
  "speed_past_180_seconds" DOUBLE,
  "speed_past_240_seconds" DOUBLE,
  "speed_past_300_seconds" DOUBLE,
  "speed_past_360_seconds" DOUBLE,
  "speed_past_420_seconds" DOUBLE,
  "speed_past_480_seconds" DOUBLE,
  "speed_past_540_seconds" DOUBLE,
  "speed_past_600_seconds" DOUBLE,
  "speed_past_660_seconds" DOUBLE,
  "speed_past_720_seconds" DOUBLE,
  "speed_past_780_seconds" DOUBLE,
  "speed_past_840_seconds" DOUBLE,
  "speed_past_900_seconds" DOUBLE,
  "speed_past_1800_seconds" DOUBLE,
  "speed_past_3600_seconds" DOUBLE,
  "speed_past_7200_seconds" DOUBLE,
  "speed_past_10800_seconds" DOUBLE,
  "speed_past_14400_seconds" DOUBLE,
  "heart_rate_past_60_seconds" DOUBLE,
  "heart_rate_past_120_seconds" DOUBLE,
  "heart_rate_past_180_seconds" DOUBLE,
  "heart_rate_past_240_seconds" DOUBLE,
  "heart_rate_past_300_seconds" DOUBLE,
  "heart_rate_past_360_seconds" DOUBLE,
  "heart_rate_past_420_seconds" DOUBLE,
  "heart_rate_past_480_seconds" DOUBLE,
  "heart_rate_past_540_seconds" DOUBLE,
  "heart_rate_past_600_seconds" DOUBLE,
  "heart_rate_past_660_seconds" DOUBLE,
  "heart_rate_past_720_seconds" DOUBLE,
  "heart_rate_past_780_seconds" DOUBLE,
  "heart_rate_past_840_seconds" DOUBLE,
  "heart_rate_past_900_seconds" DOUBLE,
  "heart_rate_past_1800_seconds" DOUBLE,
  "heart_rate_past_3600_seconds" DOUBLE,
  "heart_rate_past_7200_seconds" DOUBLE,
  "heart_rate_past_10800_seconds" DOUBLE,
  "heart_rate_past_14400_seconds" DOUBLE,
  "total_time_spent_running_past_60_seconds" DOUBLE,
  "total_time_spent_running_past_120_seconds" DOUBLE,
  "total_time_spent_running_past_180_seconds" DOUBLE,
  "total_time_spent_running_past_240_seconds" DOUBLE,
  "total_time_spent_running_past_300_seconds" DOUBLE,
  "total_time_spent_running_past_360_seconds" DOUBLE,
  "total_time_spent_running_past_420_seconds" DOUBLE,
  "total_time_spent_running_past_480_seconds" DOUBLE,
  "total_time_spent_running_past_540_seconds" DOUBLE,
  "total_time_spent_running_past_600_seconds" DOUBLE,
  "total_time_spent_running_past_660_seconds" DOUBLE,
  "total_time_spent_running_past_720_seconds" DOUBLE,
  "total_time_spent_running_past_780_seconds" DOUBLE,
  "total_time_spent_running_past_840_seconds" DOUBLE,
  "total_time_spent_running_past_900_seconds" DOUBLE,
  "total_time_spent_running_past_1800_seconds" DOUBLE,
  "total_time_spent_running_past_3600_seconds" DOUBLE,
  "total_time_spent_running_past_7200_seconds" DOUBLE,
  "total_time_spent_running_past_10800_seconds" DOUBLE,
  "total_time_spent_running_past_14400_seconds" DOUBLE,
  "altitude_change_past_0_to_60_seconds" DOUBLE
);

S1 Stop To Start

@kaggle.mcandocia_running_heart_rate_recovery.s1_stop_to_start
  • 1.12 MB
  • 3719 rows
  • 70 columns
Loading...

CREATE TABLE s1_stop_to_start (
  "event_id" BIGINT,
  "rest_time" DOUBLE,
  "timestamp_stop" TIMESTAMP,
  "timestamp_start" TIMESTAMP,
  "heart_rate_stop" DOUBLE,
  "heart_rate_start" DOUBLE,
  "time_elapsed" DOUBLE,
  "total_running_time" DOUBLE,
  "time_since_last_start" DOUBLE,
  "altitude_start" DOUBLE,
  "distance_start" DOUBLE,
  "speed_start" DOUBLE,
  "cadence_start" DOUBLE,
  "temp_at_start" DOUBLE,
  "datetime_ts" VARCHAR,
  "altitude_stop" DOUBLE,
  "distance_stop" DOUBLE,
  "speed_stop" DOUBLE,
  "cadence_stop" DOUBLE,
  "temp_at_stop" DOUBLE,
  "altitude_change_past_60_seconds" DOUBLE,
  "altitude_change_past_180_seconds" DOUBLE,
  "altitude_change_past_300_seconds" DOUBLE,
  "altitude_change_past_600_seconds" DOUBLE,
  "altitude_change_past_900_seconds" DOUBLE,
  "altitude_change_past_1800_seconds" DOUBLE,
  "altitude_change_past_3600_seconds" DOUBLE,
  "altitude_change_past_7200_seconds" DOUBLE,
  "altitude_change_past_10800_seconds" DOUBLE,
  "altitude_change_past_14400_seconds" DOUBLE,
  "speed_past_60_seconds" DOUBLE,
  "speed_past_180_seconds" DOUBLE,
  "speed_past_300_seconds" DOUBLE,
  "speed_past_600_seconds" DOUBLE,
  "speed_past_900_seconds" DOUBLE,
  "speed_past_1800_seconds" DOUBLE,
  "speed_past_3600_seconds" DOUBLE,
  "speed_past_7200_seconds" DOUBLE,
  "speed_past_10800_seconds" DOUBLE,
  "speed_past_14400_seconds" DOUBLE,
  "heart_rate_past_60_seconds" DOUBLE,
  "heart_rate_past_180_seconds" DOUBLE,
  "heart_rate_past_300_seconds" DOUBLE,
  "heart_rate_past_600_seconds" DOUBLE,
  "heart_rate_past_900_seconds" DOUBLE,
  "heart_rate_past_1800_seconds" DOUBLE,
  "heart_rate_past_3600_seconds" DOUBLE,
  "heart_rate_past_7200_seconds" DOUBLE,
  "heart_rate_past_10800_seconds" DOUBLE,
  "heart_rate_past_14400_seconds" DOUBLE,
  "total_time_spent_running_past_60_seconds" DOUBLE,
  "total_time_spent_running_past_180_seconds" DOUBLE,
  "total_time_spent_running_past_300_seconds" DOUBLE,
  "total_time_spent_running_past_600_seconds" DOUBLE,
  "total_time_spent_running_past_900_seconds" DOUBLE,
  "total_time_spent_running_past_1800_seconds" DOUBLE,
  "total_time_spent_running_past_3600_seconds" DOUBLE,
  "total_time_spent_running_past_7200_seconds" DOUBLE,
  "total_time_spent_running_past_10800_seconds" DOUBLE,
  "total_time_spent_running_past_14400_seconds" DOUBLE,
  "avg_temp" DOUBLE,
  "avg_temp2" DOUBLE,
  "avg_temp_mean" DOUBLE,
  "avg_lat" DOUBLE,
  "avg_long" DOUBLE,
  "avg_alt" DOUBLE,
  "avg_hr" DOUBLE,
  "avg_speed" DOUBLE,
  "total_dist" DOUBLE,
  "avg_temp_mode" DOUBLE
);

S1 Summaries

@kaggle.mcandocia_running_heart_rate_recovery.s1_summaries
  • 715.11 KB
  • 835 rows
  • 145 columns
Loading...

CREATE TABLE s1_summaries (
  "event_id" BIGINT,
  "lat_median" DOUBLE,
  "long_median" DOUBLE,
  "timezone" VARCHAR,
  "heart_rate_median" DOUBLE,
  "heart_rate_50w" DOUBLE,
  "heart_rate_10" DOUBLE,
  "heart_rate_25" DOUBLE,
  "heart_rate_75" DOUBLE,
  "heart_rate_90" DOUBLE,
  "heart_rate_10w" DOUBLE,
  "heart_rate_25w" DOUBLE,
  "heart_rate_75w" DOUBLE,
  "heart_rate_90w" DOUBLE,
  "heart_rate_sdw" DOUBLE,
  "heart_rate_min" DOUBLE,
  "heart_rate_max" DOUBLE,
  "cadence_median" DOUBLE,
  "heart_rate_mean" DOUBLE,
  "heart_rate_mean_na" DOUBLE,
  "temperature_median" DOUBLE,
  "temperature_median_v2" DOUBLE,
  "temperature_mean_na" DOUBLE,
  "median_cadence" DOUBLE,
  "cadence_mean" DOUBLE,
  "cadence_10" DOUBLE,
  "cadence_25" DOUBLE,
  "cadence_75" DOUBLE,
  "cadence_90" DOUBLE,
  "cadence_10w" DOUBLE,
  "cadence_25w" DOUBLE,
  "cadence_75w" DOUBLE,
  "cadence_90w" DOUBLE,
  "altitude_min" DOUBLE,
  "altitude_amean" DOUBLE,
  "altitude_max" DOUBLE,
  "altitude_ascended" DOUBLE,
  "altitude_descended" DOUBLE,
  "total_distance" DOUBLE,
  "speed_average" DOUBLE,
  "speed_median" DOUBLE,
  "speed_10" DOUBLE,
  "speed_25" DOUBLE,
  "speed_75" DOUBLE,
  "speed_90" DOUBLE,
  "speed_50w" DOUBLE,
  "speed_10w" DOUBLE,
  "speed_25w" DOUBLE,
  "speed_75w" DOUBLE,
  "speed_90w" DOUBLE,
  "speed_max" DOUBLE,
  "speed_sd" DOUBLE,
  "speed_sdw" DOUBLE,
  "timestamp_start_run" BIGINT,
  "timestamp_end_run" BIGINT,
  "datetime_ts" VARCHAR,
  "heart_rate_speed_cor" DOUBLE,
  "heart_rate_speed_cor_2" DOUBLE,
  "heart_rate_temp_cor" DOUBLE,
  "heart_rate_temp_cor_2" DOUBLE,
  "speed_distance_cor" DOUBLE,
  "speed_distance_cor_spearman" DOUBLE,
  "speed_cadence_cor" DOUBLE,
  "heart_rate_cadence_cor" DOUBLE,
  "sub_sport" VARCHAR,
  "direction_n_avg" DOUBLE,
  "direction_ne_avg" DOUBLE,
  "direction_e_avg" DOUBLE,
  "direction_se_avg" DOUBLE,
  "direction_s_avg" DOUBLE,
  "direction_sw_avg" DOUBLE,
  "direction_w_avg" DOUBLE,
  "direction_nw_avg" DOUBLE,
  "mean_rotation_velocity" DOUBLE,
  "mean_abs_rotation_velocity" DOUBLE,
  "total_angle_delta" DOUBLE,
  "total_abs_angle_delta" DOUBLE,
  "griddiness" DOUBLE,
  "griddiness_v2" DOUBLE,
  "griddiness_v3" DOUBLE,
  "orientation_center" DOUBLE,
  "orientation_sd" DOUBLE,
  "n_laps" BIGINT,
  "rest_time_total" BIGINT,
  "n_rests" BIGINT,
  "rest_time_average" DOUBLE,
  "rest_time_min" DOUBLE,
  "rest_time_max" DOUBLE,
  "rest_time_median" DOUBLE,
  "rest_time_sd" DOUBLE,
  "n_laps_over_15" BIGINT,
  "lap_trigger_distance" BIGINT,
  "lap_trigger_session_end" BIGINT,
  "lap_trigger_manual" BIGINT,
  "lap_trigger_other" BIGINT,
  "strides_total" DOUBLE,
  "lap_speed_sd" DOUBLE,
  "n_laps_00_to_05" DOUBLE,
  "n_laps_05_to_06" DOUBLE,
  "n_laps_06_to_07" DOUBLE
);

Similarities

@kaggle.mcandocia_running_heart_rate_recovery.similarities
  • 6.22 MB
  • 348195 rows
  • 6 columns
Loading...

CREATE TABLE similarities (
  "fn1" VARCHAR,
  "fn2" VARCHAR,
  "similarity" DOUBLE,
  "directional_similarity" DOUBLE,
  "id1" BIGINT,
  "id2" BIGINT
);

Share link

Anyone who has the link will be able to view this.