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 Summaries

@kaggle.mcandocia_running_heart_rate_recovery.s1_summaries

715.11 KB
835 rows
145 columns
Only the first 100 columns are shown

event_id Event Id	lat_median Lat Median	long_median Long Median	timezone Timezone	heart_rate_median Heart Rate Median	heart_rate_50w Heart Rate 50w	heart_rate_10 Heart Rate 10	heart_rate_25 Heart Rate 25	heart_rate_75 Heart Rate 75	heart_rate_90 Heart Rate 90	heart_rate_10w Heart Rate 10w	heart_rate_25w Heart Rate 25w	heart_rate_75w Heart Rate 75w	heart_rate_90w Heart Rate 90w	heart_rate_sdw Heart Rate Sdw	heart_rate_min Heart Rate Min	heart_rate_max Heart Rate Max	cadence_median Cadence Median	heart_rate_mean Heart Rate Mean	heart_rate_mean_na Heart Rate Mean Na	temperature_median Temperature Median	temperature_median_v2 Temperature Median V2	temperature_mean_na Temperature Mean Na	median_cadence Median Cadence	cadence_mean Cadence Mean	cadence_10 Cadence 10	cadence_25 Cadence 25	cadence_75 Cadence 75	cadence_90 Cadence 90	cadence_10w Cadence 10w	cadence_25w Cadence 25w	cadence_75w Cadence 75w	cadence_90w Cadence 90w	altitude_min Altitude Min	altitude_amean Altitude Amean	altitude_max Altitude Max	altitude_ascended Altitude Ascended	altitude_descended Altitude Descended	total_distance Total Distance	speed_average Speed Average	speed_median Speed Median	speed_10 Speed 10	speed_25 Speed 25	speed_75 Speed 75	speed_90 Speed 90	speed_50w Speed 50w	speed_10w Speed 10w	speed_25w Speed 25w	speed_75w Speed 75w	speed_90w Speed 90w	speed_max Speed Max	speed_sd Speed Sd	speed_sdw Speed Sdw	timestamp_start_run Timestamp Start Run	timestamp_end_run Timestamp End Run	datetime_ts Datetime Ts	heart_rate_speed_cor Heart Rate Speed Cor	heart_rate_speed_cor_2 Heart Rate Speed Cor 2	heart_rate_temp_cor Heart Rate Temp Cor	heart_rate_temp_cor_2 Heart Rate Temp Cor 2	speed_distance_cor Speed Distance Cor	speed_distance_cor_spearman Speed Distance Cor Spearman	speed_cadence_cor Speed Cadence Cor	heart_rate_cadence_cor Heart Rate Cadence Cor	sub_sport Sub Sport	direction_n_avg Direction N Avg	direction_ne_avg Direction Ne Avg	direction_e_avg Direction E Avg	direction_w_avg Direction W Avg	direction_nw_avg Direction Nw Avg	mean_rotation_velocity Mean Rotation Velocity	mean_abs_rotation_velocity Mean Abs Rotation Velocity	total_angle_delta Total Angle Delta	total_abs_angle_delta Total Abs Angle Delta	griddiness Griddiness	griddiness_v2 Griddiness V2	griddiness_v3 Griddiness V3	orientation_center Orientation Center	orientation_sd Orientation Sd	n_laps N Laps	rest_time_total Rest Time Total	n_rests N Rests	rest_time_average Rest Time Average	rest_time_min Rest Time Min	rest_time_max Rest Time Max	rest_time_median Rest Time Median	rest_time_sd Rest Time Sd	n_laps_over_15 N Laps Over 15	lap_trigger_distance Lap Trigger Distance	lap_trigger_session_end Lap Trigger Session End	lap_trigger_manual Lap Trigger Manual	strides_total Strides Total	lap_speed_sd Lap Speed Sd	n_laps_00_to_05 N Laps 00 To 05
1	41.96602748706937	-87.64693901874125	America/Chicago	151	150.3524732270001	137	144	153	155	137.32081032515313	143.40168034189963	152.14338294088978	154.26825116880156	12.078368564606212	69	159	81	145.8283464566929				1	81	80.36338582677165	80	80	81	82	79.57471101875537	79.77614309883094	80.91670547725887	81.91182226351927	160.79999999999995	178.67181102362204	206	14.38279592256933	14.030770311247096	4.83519	13.563011338582678	13.4874	12.8988	13.1004	14.3424	14.7816	13.55022148541114	12.889603288226148	13.138221299695385	14.341677340981573	14.814605143064984	15.4836	1.5745578238736837	0.8847988549048121	1506028652	1506029970	2017-09-21_21-17-32	0.4954030211941062	0.2254514282034153			0.0471864941151802	-0.2406636606025931	0.643039077294676	0.3523912924764223	generic	0.1478260869565217	0.0561264822134387	0.5786561264822134	0.1035573122529644	0.1138339920948616	0.0931088387047926	6.603285971573257	118.24822515508664	8386.173183898036	0.3721796165989353	0.6574803149606299	0.3828823599508302	120.68019980455904	64.28852737044556									3	3	1		1702	0.7172256548674207
2	41.97517616674304	-87.65025649219751	America/Chicago	158	157.63189233979557	144	152	161	162	143.37148032811788	151.59326622253303	160.14591443157718	161.92306948137232	7.194344952977674	64	168	81	155.4421310471525				1	81	81.14421310471525	80	81	82	82.5	60.56355098257751	80.61866522861153	81.84531653177292	82.28405793676663	169.60000000000002	192.0496019595836	228.79999999999995	14.167548487633326	33.02215897814693	5.98351	13.0402471524801	13.1328	12.4272	12.9312	13.435200000000002	13.7736	13.143549215455709	12.462469355601073	12.929127727266556	13.4500413866248	13.777553792698829	14.9472	1.176834482602498	0.7344740403611358	1506101367	1506103010	2017-09-22_17-29-27	0.3057690292114757	-0.410956173180176			0.1960494870543463	0.0955684580197244	0.5949461255854109	0.5211005962871471	generic	0.2315724815724815	0.0233415233415233	0.5872235872235873	0.035012285012285	0.1228501228501228	0.0903129153225527	5.837023796005959	147.48099072172866	9531.859858877731	0.4853301995903962	0.7054500918554807	0.4937597709908715	158.92364730115546	40.7358349911249									4	3	1		2210	0.3064937193483748
3	41.96442872285843	-87.64294219203293	America/Chicago	161	160.62417724635768	133.5	151	166	169	134.79666858316222	152.54801286469103	165.2374218141825	168.47365956266057	12.535871872696571	72	179	82	156.49213836477986				1	82.5	82.312106918239	81	82	83.5	85.5	80.70027101557297	81.63638774330865	83.45819425017169	85.23783219804048	155.20000000000005	178.92431865828092	229.4	8.588020972143454	5.357641623890345	14.54317	13.428711320754717	13.536	11.8224	12.7296	14.5116	15.1812	13.81163007284079	12.060647356951474	12.818943870523416	14.60724197208817	15.285800987074031	22.9104	2.1486462380501203	1.5441318571711602	1506175065	1506180208	2017-09-23_13-57-45	0.5047827421878912	0.4274058329327775			-0.1903329210412161	-0.2790128676423386	0.5358643666217675	0.2877204612535446	generic	0.1516662293361322	0.0327997900813434	0.6184728417738127	0.0511676725268958	0.1458934662818158	0.0053707991754965	7.557685600606175	20.49496965369497	28840.128251913164	0.2915617742499164	0.6417714884696016	0.3043310241030424	119.06290893825393	54.54663495082144	5	1334	7	190.57142857142856	2	712	117	316.3363716046576	24		1	23	5226	2.54566336105662
4	41.94041817449033	-87.63768254779279	America/Chicago	148	148.03002892728216	143	146	156	159	142.84763459043933	145.49228736235264	155.166701073493	158.600825302569	7.62411470209295	76	170	82	149.4106115491157				1	82	81.62028553164288	80	81	82.5	83.5	79.7654315287884	80.58693623787815	82.2958686594772	83.2827691664078	170.79999999999995	186.0460686128276	240.4	32.368679200728025	13.578150883380204	16.39248	12.51918141913488	12.528	11.6892	12.1608	13.068	13.4712	12.540027068219228	11.720539051750617	12.164461381753764	13.084586818556549	13.46821654556748	14.7816	1.0171533650880271	0.7505360970073097	1506267289	1506272227	2017-09-24_15-34-49	0.4254928016173267	0.354794181775461			-0.4027375248820012	-0.6952949514550288	0.4396412218205067	0.1814787010154026	generic	0.2888225255972696	0.0234641638225255	0.5157849829351536	0.0168515358361774	0.1550767918088737	-0.0268405063074283	3.7135780889146366	-125.962496100761	17427.82197127639	0.4318952170050932	0.6422331131472406	0.439586632648639	163.79534837496269	27.043744551566316	3	203	3	67.66666666666667	2	130	71	64.06507108661734	11	10	1		6365	0.4878227636419531
5	41.96528744883835	-87.64816017821431	America/Chicago	161	160.43888402221972	148	155	165	166	147.9262007921108	154.97806251852828	164.14687788232357	165.57379109423945	7.152617392099082	56	170	83	158.41606792945788	0.0026058631921824			1	83.5	83.30879478827362	82	83	84.5	85.5	81.87628587279498	82.73207544475176	84.2672951710985	85.28207359878724	167	189.5937459283388	274.4	42.430079772194375	29.17911859801293	5.64658	13.098887296416938	13.435200000000002	11.9592	12.7656	13.9752	14.1768	13.472238879329147	12.235736230182033	12.88870834496232	13.988909497441648	14.17149312810095	14.7816	1.6035410621724493	1.0243394793921765	1506382756	1506384318	2017-09-25_23-39-16	0.5230531120459861	0.251813088388758			0.4013971276297896	0.3779075684001894	0.7109504795710535	0.5085639650123426	generic	0.0372549019607843	0.0405228758169934	0.6633986928104575	0.1026143790849673	0.1562091503267973	0.0696582685580154	3.3716051373346425	106.92544223655372	5175.413885808676	0.3975540140679748	0.6045602605863192	0.4063167846599067	102.42916780273528	38.50504588457366									4	3	1		2128	0.6499337812423654
6	41.96517601143569	-87.64576856978238	America/Chicago	148	159.3671404778787	119	125	166	170	120.14152838642966	131.1342771820798	166.64318259120378	169.73626836106067	20.538641907059034	73	178	83	144.88767812238055		18	18		83	81.80280804694048	80	81	84.5	86	80.56748239617822	81.82954155563853	84.42212798178154	86.19636288278107	155.60000000000002	170.83595976529756	220.20000000000005	14.859254133719446	28.48922129015196	10.05552	14.83615976529757	16.4268	9.6084	11.1168	18.5436	19.4832	17.499534457930466	10.366588751300728	13.10206890419408	18.842494555873927	19.61489668331224	21.2292	4.1981812088595465	3.584751054543442	1506556103	1506561103	2017-09-27_23-48-23	0.8384591309221138	0.8646488502710137	-0.1965539303477845	0.0073187081802658	-0.0861355583724861	-0.164346903166769	0.5101558174250895	0.3907436670097691	generic	0.1478370432591348	0.1612767744645107	0.5611087778244435	0.0550188996220075	0.0747585048299034	0.0232748510784492	6.667671953291182	55.533794673179976	15909.06528055276	0.1987055837788052	0.5268231349538977	0.210414161759344	24.196770613555188	49.34214553037637	8	2600	9	288.8888888888889	19	781	183.5	272.0603924551627	12		1	11	3260	8.627760444265729	1
7	41.96718368679285	-87.6468593487516	America/Chicago	148	148.25174373393773	136	146	150	153	143.44104516977507	146.05375242933556	149.9954574630919	153.2248525639091	9.8288589598431	64	163	81	144.5255319148936		17	17		81	78.78794326241135	80	81	82	83	79.73972548484765	80.56921893104521	81.96615641942302	82.84804098331915	162.60000000000002	175.5381560283688	272.4	6.107465368126782	21.05395646321864	5.419689999999999	13.44711829787234	13.8744	12.05316	13.068	14.7816	15.4188	14.003720621552697	12.610087337514251	13.247677862181224	14.844483383299533	15.59273085964508	18.6084	2.781896056328917	1.5611527802969845	1506727762	1506729171	2017-09-29_23-29-22	0.8425200777261905	0.2513040552514111	-0.5749165674977805	0.1200968107295132	0.2591260051402428	-0.0572298727670566	0.6895468691986122	0.5465622060934107	generic	0.2028469750889679	0.100355871886121	0.5181494661921708	0.0590747330960854	0.1195729537366548	-0.0477897681408179	5.821110198562264	-67.38357307855337	8207.765379972792	0.2515227739794873	0.5581560283687943	0.2612293864611031	176.68229281617724	44.26721080051431									7	1	1	5	1839	0.8360832767818569
8	41.974614285863936	-87.64986007008702	America/Chicago	153	152.54153303117542	149	151	155	160	148.3891052106449	150.46206996487882	154.66303975119132	159.3162522048046	6.268627280393217	75	170	82	152.76558752997602		20	20	0.0179856115107913	82	82.06774580335731	81	82	83	83	80.69579271421242	81.54573003308049	82.4143810768971	82.99775116644098	164.20000000000005	179.0904076738609	213	4.326343687462469	24.18971528994072	6.50893	14.02158129496403	14.1768	13.302	13.8654	14.3784	14.7132	14.16779551005182	13.34991831987076	13.8925918398704	14.389095140839492	14.738840699573863	17.4996	1.1125433288833866	0.919751293083529	1506786763	1506788430	2017-09-30_15-52-43	0.7318682698037694	0.5724267758853904	0.0615492288588942	0.2166390117348773	0.1962564603712824	0.293463683914828	0.584254079485294	0.5983338630603051	generic	0.2898376428141912	0.0180396873120865	0.5357787131689717	0.0114251352976548	0.1449188214070956	-0.1219102707092565	4.836480795217108	-203.34633154303995	8067.249966422137	0.5051283452693811	0.6720623501199041	0.5092594703357894	162.38021532690396	31.102196699910465									5	4	1		2269	0.985271398143679
9	41.98251435533166	-87.65497282147408	America/Chicago	158	157.78975557823802	141	147	162	164	141.2736118922041	147.00716763657144	161.8411907886238	164.72090784044016	11.895271816379568	77	170	82	153.62598870056496		15	15	0.03954802259887	82	80.61638418079096	81	82	83.5	84.5	80.99124015030264	81.6820969608512	83.09626763921182	84.3801013077194	172	211.8958192090396	278.4	9.154816502532498	25.79230852125164	3.27387	12.05757559322034	12.4956	10.278	11.4552	13.1004	13.69224	12.673152950706791	10.578814726097312	11.73452847519902	13.174389228251975	13.847107161390763	20.9268	2.355751434949943	1.5760906588314152	1506863028	1506863988	2017-10-01_13-03-48	0.3151623456016874	0.3749964943630308	0.1426320234564718	0.1539551872579113	-0.0607760977587167	-0.045021810777538	0.6701183088751428	0.4020603187839013	generic	0.8715909090909091	0.05	0.0227272727272727	0.0136363636363636	0.0420454545454545	-0.1491388592960928	2.624341321358922	-131.98789047704213	2322.5420694026457	0.7068574949239336	0.8112994350282486	0.682571391550596	177.9743046191095	17.89765921477707	1	54	3	18	54	54	54		2	2	1		1221	0.0458205194208882
10	41.98655703105032	-87.653998718597	America/Chicago	166	165.3295987362405	162	163	169	172	161.10752448080257	162.84380974110604	168.40373371891664	171.22206573888351	6.071809382558548	121	175	83	165.4359464627151		15	15	0.0124282982791587	83	83.4187380497132	82	82	84.5	85.5	81.56543076285476	81.9714728541339	84.09719129351082	85.3921236387551	154.79999999999995	185.7806883365201	232.79999999999995	36.09842040880375	9.615373377990778	4.79054	16.410094072657746	16.1244	15.4188	15.685200000000002	17.0964	18.003600000000002	16.20859725506355	15.44139176141659	15.712427893411109	17.15645197147651	18.13778626711649	20.120400000000004	1.2566911722580874	1.138256405756461	1506864585	1506865631	2017-10-01_13-29-45	-0.0037461837936329	0.5621308982200679	-0.010917529971068	0.4659043126654389	-0.1069204415809831	-0.0677415517070508	0.7062419950232983	-0.1078332016144707	generic	0.3390970220941403	0.004803073967339	0.5196926032660903	0.0115273775216138	0.1248799231508165	-0.1495329043401001	8.847203720344694	-156.41141793974475	9254.17509148055	0.5580381178099473	0.737093690248566	0.5557196728192421	168.395073859851	20.91731621482848									4	2	1	1	1488	0.724082674837619


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