Running And Heart Rate Data
Running and Heart rate summary, stop, start and lap event data
@kaggle.mcandocia_running_heart_rate_recovery
Running and Heart rate summary, stop, start and lap event data
@kaggle.mcandocia_running_heart_rate_recovery
CREATE TABLE ph_scores (
"full_path" VARCHAR,
"score" DOUBLE,
"event_id" BIGINT
);
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
);
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
);
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
);
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
);
CREATE TABLE similarities (
"fn1" VARCHAR,
"fn2" VARCHAR,
"similarity" DOUBLE,
"directional_similarity" DOUBLE,
"id1" BIGINT,
"id2" BIGINT
);
Anyone who has the link will be able to view this.