Sports Supplements

Elixir or Snake Oil?

@kaggle.joebeachcapital_sports_supplements

Table List

1 table(59.67 KB)

Sports Supplements

@kaggle.joebeachcapital_sports_supplements.sports_supplements

59.67 KB
96 rows
46 columns

supplement Supplement	alt_name Alt Name	evidence_level_score_0_no_evidence_1_2_slight_3_confli_7748239f Evidence Level - Score. 0 \u003d No Evidence, 1,2 \u003d Slight, 3 \u003d Conflicting , 4 \u003d Promising, 5 \u003d Good, 6 \u003d Strong	claimed_improved_aspect_of_fitness Claimed Improved Aspect Of Fitness	fitness_category Fitness Category	sport_or_exercise_type_tested Sport Or Exercise Type Tested	otw OTW	popularity Popularity	number_of_studies_examined Number Of Studies Examined	number_of_citations Number Of Citations	notes Notes	year_s_of_metastudy Year(s) Of Metastudy	no_of_individual_studies_reviews No. Of Individual Studies / Reviews	n_positive_studies_trials N Positive Studies / Trials	n__positive_studies_trials % Positive Studies/ Trials	main_study_source Main Study Source	link_to_main_individual_study Link To Main Individual Study	link_to_individual_study Link To Individual Study	link_to_individual_study_1 Link To Individual Study.1	link_to_individual_study_2 Link To Individual Study.2	link_to_individual_study_3 Link To Individual Study.3	link_to_individual_study_4 Link To Individual Study.4	link_to_individual_study_5 Link To Individual Study.5	link_to_individual_study_6 Link To Individual Study.6	link_to_individual_study_7 Link To Individual Study.7	link_to_individual_study_8 Link To Individual Study.8	link_to_individual_study_9 Link To Individual Study.9	link_to_individual_study_10 Link To Individual Study.10	link_to_individual_study_11 Link To Individual Study.11	link_to_individual_study_12 Link To Individual Study.12	link_to_individual_study_13 Link To Individual Study.13	link_to_individual_study_14 Link To Individual Study.14	link_to_individual_study_15 Link To Individual Study.15	link_to_individual_study_16 Link To Individual Study.16	link_to_individual_study_17 Link To Individual Study.17	link_to_individual_study_18 Link To Individual Study.18	link_to_individual_study_19 Link To Individual Study.19
AAKG	L-arginine alpha-ketoglutarate	1	peak power output	strength–power	weight training	OTW	242	1	20	A 2006 study found AAKG supplementation improved maximum effort 1-repetition bench press and Wingate peak power performance.	-	1	1	100.00%	Campbell et al (2006)	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/549/CN-00668549/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/549/CN-00668549/frame.html	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
AAKG	L-arginine alpha-ketoglutarate		body composition, aerobic capacity, muscle endurance	fat burning–muscle building, aerobic–endurance	weight training	nan	242	1	20	nan	-	1	0	0.00%	Campbell et al (2006)	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/549/CN-00668549/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/549/CN-00668549/frame.html	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Baking soda	Bicarbonate of soda, sodium bicarbonate, NaHCO3	5	high-intensity performance	anaerobic–high-intensity	rowing, cycling, swimming, running, other	nan	947	14	140	Gulping down baking soda (sodium bicarbonate) makes the blood more alkaline, improving performance in lactic-acid-fueled events like the 800m sprint. Downside: a badly upset stomach.	-	14	9	64.29%	Siegler et al (2010)	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/219/CN-00770219/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/778/CN-00759778/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/004/CN-00749004/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/229/CN-00760229/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/219/CN-00770219/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/656/CN-00733656/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/708/CN-00772708/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/130/CN-00762130/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/160/CN-00701160/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/159/CN-00701159/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/622/CN-00572622/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/402/CN-00564402/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/818/CN-00559818/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/017/CN-00559017/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/648/CN-00408648/frame.html	nan	nan	nan	nan	nan	nan
BCAAs	branched-chain amino acids, leucine, isoleucine, valine	4	fatigue resistance	aerobic–endurance	cycling, circuit training	nan	5490	3	660	Branched-chain amino acids	-	3	3	100.00%	Greer et al (2011)	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/959/CN-00781959/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/959/CN-00781959/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/239/CN-00787239/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/438/CN-00554438/frame.html	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
BCAAs	branched-chain amino acids, leucine, isoleucine, valine	3	aerobic performance, endurance, power	aerobic–endurance, strength–power	cycling, other	nan	5490	4	660	Branched-chain amino acids	-	4	2	50.00%	Matsumoto et al (2009)	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/665/CN-00705665/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/959/CN-00781959/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/665/CN-00705665/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/412/CN-00561412/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/174/CN-00560174/frame.html	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
BCAAs	branched-chain amino acids, leucine, isoleucine, valine	1	immune defences in athletes	general fitness	running, other	OTW	5490	2	660	Branched-chain amino acids	-	2	2	100.00%	Bassit et al (2002)	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/021/CN-00389021/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/021/CN-00389021/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/262/CN-00372262/frame.html	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
BCAAs	branched-chain amino acids, leucine, isoleucine, valine		body composition	fat burning–muscle building	swimming, rowing	nan	5490	1	660	Branched-chain amino acids	-	1	0	0.00%	Tang (2003)	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/245/CN-00474245/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/245/CN-00474245/frame.html	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
BCAAs	branched-chain amino acids, leucine, isoleucine, valine	6	muscle damage + soreness	recovery–injury prevention	weight training, circuit training, cycling, swimming	nan	5490	7	660	Taking branched-chain amino acids before exercise can reduce damage to muscle tissue and soreness caused by training (and overtraining).	-	7	7	100.00%	Shimomura et al (2010)	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/776/CN-00759776/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/773/CN-00751773/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/776/CN-00759776/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/009/CN-00629009/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/808/CN-00565808/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/438/CN-00554438/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/613/CN-00442613/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/649/CN-00441649/frame.html	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Beetroot juice	nan	4	aerobic efficiency	aerobic–endurance	running, cycling	nan	267	4	5	The nitrates in beetroot juice improve time to exhaustion and various measures of oxygen consumption during aerobic exercise, also reducing resting blood pressure. Downsides: purple pee.	-	4	4	100.00%	Lansley et al (2011)	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/843/CN-00800843/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/843/CN-00800843/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/096/CN-00787096/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/367/CN-00760367/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/472/CN-00733472/frame.html	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
Beta alanine	nan	1	high-intensity performance	aerobic–endurance, anaerobic–high-intensity	rowing, cycling, running	nan	920	4	284	nan	-	4	1	25.00%	Walter et al (2010)	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/456/CN-00750456/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/549/CN-00781549/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/456/CN-00750456/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/381/CN-00697381/frame.html	http://onlinelibrary.wiley.com/o/cochrane/clcentral/articles/957/CN-00626957/frame.html	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan


CREATE TABLE sports_supplements (
  "supplement" VARCHAR,
  "alt_name" VARCHAR,
  "evidence_level_score_0_no_evidence_1_2_slight_3_confli_7748239f" DOUBLE,
  "claimed_improved_aspect_of_fitness" VARCHAR,
  "fitness_category" VARCHAR,
  "sport_or_exercise_type_tested" VARCHAR,
  "otw" VARCHAR,
  "popularity" BIGINT,
  "number_of_studies_examined" BIGINT,
  "number_of_citations" BIGINT,
  "efficacy" VARCHAR,
  "notes" VARCHAR,
  "exclude" VARCHAR,
  "unnamed_13" VARCHAR,
  "cochrane_systematic_review" BIGINT,
  "other_international_review_board_or_metastudy" BIGINT,
  "no_of_studies_in_cochrane_metastudy" BIGINT,
  "no_of_studies_in_metastudy" VARCHAR,
  "year_s_of_metastudy" VARCHAR,
  "no_of_individual_studies_reviews" BIGINT,
  "n_positive_studies_trials" VARCHAR,
  "n__positive_studies_trials" VARCHAR,
  "main_study_source" VARCHAR,
  "link_to_main_individual_study" VARCHAR,
  "unnamed_24" VARCHAR,
  "link_to_individual_study" VARCHAR,
  "link_to_individual_study_1" VARCHAR,
  "link_to_individual_study_2" VARCHAR,
  "link_to_individual_study_3" VARCHAR,
  "link_to_individual_study_4" VARCHAR,
  "link_to_individual_study_5" VARCHAR,
  "link_to_individual_study_6" VARCHAR,
  "link_to_individual_study_7" VARCHAR,
  "link_to_individual_study_8" VARCHAR,
  "link_to_individual_study_9" VARCHAR,
  "link_to_individual_study_10" VARCHAR,
  "link_to_individual_study_11" VARCHAR,
  "link_to_individual_study_12" VARCHAR,
  "link_to_individual_study_13" VARCHAR,
  "link_to_individual_study_14" VARCHAR,
  "link_to_individual_study_15" VARCHAR,
  "link_to_individual_study_16" VARCHAR,
  "link_to_individual_study_17" VARCHAR,
  "link_to_individual_study_18" VARCHAR,
  "link_to_individual_study_19" VARCHAR,
  "link_to_individual_study_20" VARCHAR
);