Running And Heart Rate Data

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

@kaggle.mcandocia_running_heart_rate_recovery

Table List

6 tables(17.07 MB)

S1 Stop To Start

@kaggle.mcandocia_running_heart_rate_recovery.s1_stop_to_start

1.12 MB
3719 rows
70 columns

event_id Event Id	rest_time Rest Time	timestamp_stop Timestamp Stop	timestamp_start Timestamp Start	heart_rate_stop Heart Rate Stop	heart_rate_start Heart Rate Start	time_elapsed Time Elapsed	total_running_time Total Running Time	time_since_last_start Time Since Last Start	altitude_start Altitude Start	distance_start Distance Start	speed_start Speed Start	cadence_start Cadence Start	datetime_ts Datetime Ts	altitude_stop Altitude Stop	distance_stop Distance Stop	speed_stop Speed Stop	cadence_stop Cadence Stop	altitude_change_past_60_seconds Altitude Change Past 60 Seconds	altitude_change_past_180_seconds Altitude Change Past 180 Seconds	altitude_change_past_300_seconds Altitude Change Past 300 Seconds	altitude_change_past_600_seconds Altitude Change Past 600 Seconds	altitude_change_past_900_seconds Altitude Change Past 900 Seconds	altitude_change_past_1800_seconds Altitude Change Past 1800 Seconds	altitude_change_past_3600_seconds Altitude Change Past 3600 Seconds	altitude_change_past_7200_seconds Altitude Change Past 7200 Seconds	altitude_change_past_10800_seconds Altitude Change Past 10800 Seconds	altitude_change_past_14400_seconds Altitude Change Past 14400 Seconds	speed_past_60_seconds Speed Past 60 Seconds	speed_past_180_seconds Speed Past 180 Seconds	speed_past_300_seconds Speed Past 300 Seconds	speed_past_600_seconds Speed Past 600 Seconds	speed_past_900_seconds Speed Past 900 Seconds	speed_past_1800_seconds Speed Past 1800 Seconds	speed_past_3600_seconds Speed Past 3600 Seconds	speed_past_7200_seconds Speed Past 7200 Seconds	speed_past_10800_seconds Speed Past 10800 Seconds	speed_past_14400_seconds Speed Past 14400 Seconds	heart_rate_past_60_seconds Heart Rate Past 60 Seconds	heart_rate_past_180_seconds Heart Rate Past 180 Seconds	heart_rate_past_300_seconds Heart Rate Past 300 Seconds	heart_rate_past_600_seconds Heart Rate Past 600 Seconds	heart_rate_past_900_seconds Heart Rate Past 900 Seconds	heart_rate_past_1800_seconds Heart Rate Past 1800 Seconds	heart_rate_past_3600_seconds Heart Rate Past 3600 Seconds	heart_rate_past_7200_seconds Heart Rate Past 7200 Seconds	heart_rate_past_10800_seconds Heart Rate Past 10800 Seconds	heart_rate_past_14400_seconds Heart Rate Past 14400 Seconds	total_time_spent_running_past_60_seconds Total Time Spent Running Past 60 Seconds	total_time_spent_running_past_180_seconds Total Time Spent Running Past 180 Seconds	total_time_spent_running_past_300_seconds Total Time Spent Running Past 300 Seconds	total_time_spent_running_past_600_seconds Total Time Spent Running Past 600 Seconds	total_time_spent_running_past_900_seconds Total Time Spent Running Past 900 Seconds	total_time_spent_running_past_1800_seconds Total Time Spent Running Past 1800 Seconds	total_time_spent_running_past_3600_seconds Total Time Spent Running Past 3600 Seconds	total_time_spent_running_past_7200_seconds Total Time Spent Running Past 7200 Seconds	total_time_spent_running_past_10800_seconds Total Time Spent Running Past 10800 Seconds	total_time_spent_running_past_14400_seconds Total Time Spent Running Past 14400 Seconds	avg_lat Avg Lat	avg_long Avg Long	avg_alt Avg Alt	avg_hr Avg Hr	avg_speed Avg Speed	total_dist Total Dist
1	50	Thu Sep 21 2017 16:20:05 GMT+0000 (Coordinated Universal Time)	Thu Sep 21 2017 16:20:55 GMT+0000 (Coordinated Universal Time)	132	82	153	153	153	178.6	0.55216			2017-09-21_21-17-32	184	0.55201	10.5156	76	13.8	-9.39999999999998	-9.39999999999998	-9.39999999999998	-9.39999999999998	-9.39999999999998	-9.39999999999998	-9.39999999999998	-9.39999999999998	-9.39999999999998	12.77172	13.0545584415584	13.0545584415584	13.0545584415584	13.0545584415584	13.0545584415584	13.0545584415584	13.0545584415584	13.0545584415584	13.0545584415584	139.2	129.571428571429	129.571428571429	129.571428571429	129.571428571429	129.571428571429	129.571428571429	129.571428571429	129.571428571429	129.571428571429	60	153	153	153	153	153	153	153	153	153	41.9660274870694	-87.6469390187413	178.671811023622	145.828346456693	13.5630113385827	4.83519
2	12	Fri Sep 22 2017 12:31:59 GMT+0000 (Coordinated Universal Time)	Fri Sep 22 2017 12:32:11 GMT+0000 (Coordinated Universal Time)	156	116	152	152	152	209.8	0.50847	0.1692		2017-09-22_17-29-27	204.4	0.5082	11.7216	82	14.8	22.8	22.8	22.8	22.8	22.8	22.8	22.8	22.8	22.8	11.88342	11.4174823529412	11.4174823529412	11.4174823529412	11.4174823529412	11.4174823529412	11.4174823529412	11.4174823529412	11.4174823529412	11.4174823529412	156.15	156.313725490196	156.313725490196	156.313725490196	156.313725490196	156.313725490196	156.313725490196	156.313725490196	156.313725490196	156.313725490196	60	152	152	152	152	152	152	152	152	152	41.975176166743	-87.6502564921975	192.049601959584	155.442131047152	13.0402471524801	5.98351
3	117	Sat Sep 23 2017 09:04:50 GMT+0000 (Coordinated Universal Time)	Sat Sep 23 2017 09:06:47 GMT+0000 (Coordinated Universal Time)	138	75	425	425	425	181.8	1.44891	0.1332		2017-09-23_13-57-45	173	1.44891	13.302	83	2.20000000000005	-2.60000000000002	-25.6	-56.4	-56.4	-56.4	-56.4	-56.4	-56.4	-56.4	12.91926	12.73248	12.412152	11.8629126760563	11.8629126760563	11.8629126760563	11.8629126760563	11.8629126760563	11.8629126760563	11.8629126760563	135.2	134.3	132.866666666667	131.227699530516	131.227699530516	131.227699530516	131.227699530516	131.227699530516	131.227699530516	131.227699530516	60	180	300	425	425	425	425	425	425	425	41.9644287228584	-87.6429421920329	178.924318658281	156.49213836478	13.4287113207547	14.54317
3	2	Sat Sep 23 2017 09:11:42 GMT+0000 (Coordinated Universal Time)	Sat Sep 23 2017 09:11:44 GMT+0000 (Coordinated Universal Time)	154	154	837	720	295	175.8	2.69909	14.544	81	2017-09-23_13-57-45	176.4	2.69909	14.6808	82	-5.60000000000002	-4.39999999999998	-5.39999999999998	-0.399999999999977	-53	-53	-53	-53	-53	-53	15.28428	14.92772	15.1072662162162	14.1788231404959	13.1930077562327	13.1930077562327	13.1930077562327	13.1930077562327	13.1930077562327	13.1930077562327	156.466666666667	154.077777777778	148.243243243243	142.789256198347	138.203601108033	138.203601108033	138.203601108033	138.203601108033	138.203601108033	138.203601108033	60	180	295	483	720	720	720	720	720	720	41.9644287228584	-87.6429421920329	178.924318658281	156.49213836478	13.4287113207547	14.54317
3	712	Sat Sep 23 2017 09:32:48 GMT+0000 (Coordinated Universal Time)	Sat Sep 23 2017 09:44:40 GMT+0000 (Coordinated Universal Time)	165	94	2103	1984	1264	170.4	7.73612			2017-09-23_13-57-45	179.8	7.73612	15.2496	82	3.79999999999995	9.59999999999991	0.199999999999932	-7.40000000000009	-2.20000000000005	4.39999999999998	-49.6	-49.6	-49.6	-49.6	14.0230372881356	14.1779061452514	14.227802006689	14.3635011686144	14.3666949944383	14.4173579072533	13.9602906344411	13.9602906344411	13.9602906344411	13.9602906344411	166.440677966102	166.553072625698	166.317725752508	165.677796327212	164.352614015573	158.224137931034	153.881671701913	153.881671701913	153.881671701913	153.881671701913	60	180	300	600	900	1681	1984	1984	1984	1984	41.9644287228584	-87.6429421920329	178.924318658281	156.49213836478	13.4287113207547	14.54317
3	2	Sat Sep 23 2017 10:07:35 GMT+0000 (Coordinated Universal Time)	Sat Sep 23 2017 10:07:37 GMT+0000 (Coordinated Universal Time)	177	177	4190	3359	1375	182.6	13.02	17.8704	85	2017-09-23_13-57-45	181.4	13.02	18.0036	84	-3	2.60000000000002	1.60000000000002	0.799999999999955	7.60000000000002	11	-3.20000000000005	-48	-48	-48	17.48604	15.66138	14.806872	14.099364	13.763976	13.5236093023256	14.053197921718	13.7815656157049	13.7815656157049	13.7815656157049	177.583333333333	173.977777777778	172.163333333333	169.771666666667	167.933333333333	163.622093023256	162.375129892622	157.868233194527	157.868233194527	157.868233194527	60	180	300	600	900	1375	2886	3359	3359	3359	41.9644287228584	-87.6429421920329	178.924318658281	156.49213836478	13.4287113207547	14.54317
3	483	Sat Sep 23 2017 10:07:38 GMT+0000 (Coordinated Universal Time)	Sat Sep 23 2017 10:15:41 GMT+0000 (Coordinated Universal Time)	177	102	4193	3360	1	185.2	13.02274			2017-09-23_13-57-45	182.6	13.02274	9.9756	85	-0.799999999999955	3.20000000000005	2.60000000000002	1.20000000000005	9.39999999999998	12.2	-3	-46.8	-46.8	-46.8	17.4328474576271	15.6826458100559	14.8190809364548	14.1024260434057	13.7750616240267	13.524188969521	14.0506291060291	13.7816497027348	13.7816497027348	13.7816497027348	177.593220338983	174.111731843575	172.257525083612	169.81469115192	167.967741935484	163.641509433962	162.404365904366	157.879607609988	157.879607609988	157.879607609988	58	178	298	598	898	1376	2884	3360	3360	3360	41.9644287228584	-87.6429421920329	178.924318658281	156.49213836478	13.4287113207547	14.54317
3	12	Sat Sep 23 2017 10:19:48 GMT+0000 (Coordinated Universal Time)	Sat Sep 23 2017 10:20:00 GMT+0000 (Coordinated Universal Time)	149	142	4923	3607	247	181.6	13.81742	0.0324		2017-09-23_13-57-45	179.8	13.81687	11.6208	82	-1.60000000000002	-0.200000000000045	-5.40000000000009	-5.40000000000009	0.199999999999932	-6.20000000000005	-0.400000000000091	-49.6	-49.6	-49.6	11.667	11.66904	11.3906758064516	11.3906758064516	13.1827683453237	13.199759453303	13.5691963409563	13.6174853820598	13.6174853820598	13.6174853820598	149.016666666667	146.944444444444	142.290322580645	142.290322580645	155.323741007194	162.27562642369	161.822453222453	156.809246954596	156.809246954596	156.809246954596	60	180	247	247	415	1315	2403	3607	3607	3607	41.9644287228584	-87.6429421920329	178.924318658281	156.49213836478	13.4287113207547	14.54317
3	6	Sat Sep 23 2017 10:22:48 GMT+0000 (Coordinated Universal Time)	Sat Sep 23 2017 10:22:54 GMT+0000 (Coordinated Universal Time)	154	149	5103	3775	168	197	14.40717	0.1692		2017-09-23_13-57-45	198.2	14.40717	11.7216	82	13.2	16.6	21.4000000000001	13	13	21.8000000000001	11	-31.1999999999999	-31.1999999999999	-31.1999999999999	12.26352	9.98286390532544	10.6173591695502	10.8201237410072	10.8201237410072	12.8377626339969	13.2631834586466	13.4550280878075	13.4550280878075	13.4550280878075	153.65	150.828402366864	149.61937716263	145.750599520384	145.750599520384	160.906584992343	161.034670008354	156.541920126951	156.541920126951	156.541920126951	60	168	288	415	415	1303	2391	3775	3775	3775	41.9644287228584	-87.6429421920329	178.924318658281	156.49213836478	13.4287113207547	14.54317
4	8	Sun Sep 24 2017 10:37:19 GMT+0000 (Coordinated Universal Time)	Sun Sep 24 2017 10:37:27 GMT+0000 (Coordinated Universal Time)	155	125	150	150	150	184.6	0.51188		59	2017-09-24_15-34-49	186.2	0.51188	11.4192	82	5	-49.4	-49.4	-49.4	-49.4	-49.4	-49.4	-49.4	-49.4	-49.4	12.13008	12.4530675496689	12.4530675496689	12.4530675496689	12.4530675496689	12.4530675496689	12.4530675496689	12.4530675496689	12.4530675496689	12.4530675496689	163.483333333333	160.847682119205	160.847682119205	160.847682119205	160.847682119205	160.847682119205	160.847682119205	160.847682119205	160.847682119205	160.847682119205	60	150	150	150	150	150	150	150	150	150	41.9404181744903	-87.6376825477928	186.046068612828	149.410611549116	12.5191814191349	16.39248


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
);