World Tour Badminton Tournaments (2018 To Present)

Informations about World Tour tournaments (location, cashprize, winners, ...)

@kaggle.valentindefour_international_badminton_tournaments_2014_to_2020

Table List

1 table(76.68 KB)

Data

@kaggle.valentindefour_international_badminton_tournaments_2014_to_2020.data

76.68 KB
80 rows
74 columns

week WEEK	country COUNTRY	dates DATES	tournament TOURNAMENT	prize PRIZE	category CATEGORY	city CITY	link LINK	year YEAR	ms_entries MS ENTRIES	ms_winner MS WINNER	ms_winner_rank MS WINNER RANK	ms_winner_cp MS WINNER CP	ms_finalist MS FINALIST	ms_finalist_rank MS FINALIST RANK	ms_finalist_cp MS FINALIST CP	ms_3_4_1 MS 3/4–1	ms_3_4_1_rank MS 3/4–1 RANK	ms_3_4_1_cp MS 3/4–1 CP	ms_3_4_2 MS 3/4–2	ms_3_4_2_rank MS 3/4–2 RANK	ms_3_4_2_cp MS 3/4–2 CP	ws_entries WS ENTRIES	ws_winner WS WINNER	ws_winner_rank WS WINNER RANK	ws_winner_cp WS WINNER CP	ws_finalist WS FINALIST	ws_finalist_rank WS FINALIST RANK	ws_finalist_cp WS FINALIST CP	ws_3_4_1 WS 3/4–1	ws_3_4_1_rank WS 3/4–1 RANK	ws_3_4_1_cp WS 3/4–1 CP	ws_3_4_2 WS 3/4–2	ws_3_4_2_rank WS 3/4–2 RANK	ws_3_4_2_cp WS 3/4–2 CP	md_entries MD ENTRIES	md_winner MD WINNER	md_winner_rank MD WINNER RANK	md_winner_cp MD WINNER CP	md_finalist MD FINALIST	md_finalist_rank MD FINALIST RANK	md_finalist_cp MD FINALIST CP	md_3_4_1 MD 3/4–1	md_3_4_1_rank MD 3/4–1 RANK	md_3_4_1_cp MD 3/4–1 CP	md_3_4_2 MD 3/4–2	md_3_4_2_rank MD 3/4–2 RANK	md_3_4_2_cp MD 3/4–2 CP	wd_entries WD ENTRIES	wd_winner WD WINNER	wd_winner_rank WD WINNER RANK	wd_winner_cp WD WINNER CP	wd_finalist WD FINALIST	wd_finalist_rank WD FINALIST RANK	wd_finalist_cp WD FINALIST CP	wd_3_4_1 WD 3/4–1	wd_3_4_1_rank WD 3/4–1 RANK	wd_3_4_1_cp WD 3/4–1 CP	wd_3_4_2 WD 3/4–2	wd_3_4_2_rank WD 3/4–2 RANK	wd_3_4_2_cp WD 3/4–2 CP	xd_entries XD ENTRIES	xd_winner XD WINNER	xd_winner_rank XD WINNER RANK	xd_winner_cp XD WINNER CP	xd_finalist XD FINALIST	xd_finalist_rank XD FINALIST RANK	xd_finalist_cp XD FINALIST CP	xd_3_4_1 XD 3/4–1	xd_3_4_1_rank XD 3/4–1 RANK	xd_3_4_1_cp XD 3/4–1 CP	xd_3_4_2 XD 3/4–2	xd_3_4_2_rank XD 3/4–2 RANK	xd_3_4_2_cp XD 3/4–2 CP
2	THA	09-14	PRINCESS SIRIVANNAVARI Thailand Masters 2018	150000	HSBC BWF World Tour Super 300	Bangkok	https://bwfworldtour.bwfbadminton.com/tournament/3139/princess-sirivannavari-thailand-masters-2018/results/podium/	2018	127 ENTRIES FROM 18 COUNTRIES	TommySUGIARTO	25	11250	LEONGJun Hao	209	5700	LIEWDaren	90	2175	KantaphonWANGCHAROEN	59	2175	65 ENTRIES FROM 12 COUNTRIES	NitchaonJINDAPOL	13	11250	PornpaweeCHOCHUWONG	23	5700	SoniiaCHEAH	29	2175	KISONASelvaduray	97	2175	67 ENTRIES FROM 14 COUNTRIES	TinnISRIYANET / KittisakNAMDASH	54	11850	Wahyu NayakaARYA PANGKARYAN / Ade YusufSANTOSO	37	5700	BerryANGRIAWAN / HardiantoHARDIANTO	16	2100	GOHV Shem / TANWee Kiong	18	2100	45 ENTRIES FROM 13 COUNTRIES	JongkolphanKITITHARAKUL / RawindaPRAJONGJAI	9	11850	Anggia ShittaAWANDA / Ni Ketut MahadeISTARANI	19	5700	SavitreeAMITRAPAI / PacharapunCHOCHUWONG	70	2100	CHOWMei Kuan / LEEMeng Yean	20	2100	59 ENTRIES FROM 12 COUNTRIES	CHANPeng Soon / GOHLiu Ying	57	11850	DechapolPUAVARANUKROH / PuttitaSUPAJIRAKUL	91	5700	CHENTang Jie / PECKYen Wei		2100	NipitphonPHUANGPHUAPET / JongkolphanKITITHARAKUL	45	2100
3	MAS	16-21	PERODUA Malaysia Masters 2018	350000	HSBC BWF World Tour Super 500	Bukit Jalil	https://bwfworldtour.bwfbadminton.com/tournament/3143/perodua-malaysia-masters-2018/results/podium/	2018	91 ENTRIES FROM 21 COUNTRIES	ViktorAXELSEN	1	26250	KentaNISHIMOTO	29	13300	LIEWDaren	90	5075	Hans-KristiVITTINGHUS	20	5075	68 ENTRIES FROM 17 COUNTRIES	RatchanokINTANON	6	26250	TAITzu Ying	1	13300	CarolinaMARIN	4	5075	AkaneYAMAGUCHI	2	5075	61 ENTRIES FROM 20 COUNTRIES	FajarALFIAN / Muhammad RianARDIANTO	17	27650	GOHV Shem / TANWee Kiong	18	13300	CHENHung Ling / WANGChi-Lin	9	4900	MadsCONRAD-PETERSEN / Mads PielerKOLDING	6	4900	46 ENTRIES FROM 16 COUNTRIES	Kamilla RytterJUHL / ChristinnaPEDERSEN	3	27650	CHENQing Chen / JIAYi Fan	1	13300	YukiFUKUSHIMA / SayakaHIROTA	5	4900	LEESo Hee / SHINSeung Chan	28	4900	52 ENTRIES FROM 17 COUNTRIES	TANGChun Man / TSEYing Suet	10	27650	ZHENGSi Wei / HUANGYa Qiong	44	13300	HafizFAIZAL / Gloria EmanuellWIDJAJA	83	4900	GOHSoon Huat / LAIShevon Jemie	14	4900
4	INA	23-28	DAIHATSU Indonesia Masters 2018	350000	HSBC BWF World Tour Super 500	Jakarta	https://bwfworldtour.bwfbadminton.com/tournament/3140/daihatsu-indonesia-masters-2018/results/podium/	2018	107 ENTRIES FROM 17 COUNTRIES	Anthony SinGINTING	13	26250	KazumasaSAKAI	22	13300	CHOUTien Chen	7	5075	SONWan Ho	5	5075	75 ENTRIES FROM 18 COUNTRIES	TAITzu Ying	1	26250	SainaNEHWAL	10	13300	HEBing Jiao	9	5075	RatchanokINTANON	6	5075	77 ENTRIES FROM 17 COUNTRIES	Marcus FernaldiGIDEON / Kevin SanjayaSUKAMULJO	1	27650	LIJun Hui / LIUYu Chen	3	13300	LIUCheng / ZHANGNan	4	4900	SatwiksairajRANKIREDDY / ChiragSHETTY	31	4900	45 ENTRIES FROM 11 COUNTRIES	MisakiMATSUTOMO / AyakaTAKAHASHI	2	27650	GreysiaPOLII / ApriyaniRAHAYU	10	13300	LEESo Hee / SHINSeung Chan	27	4900	Kamilla RytterJUHL / ChristinnaPEDERSEN	3	4900	70 ENTRIES FROM 15 COUNTRIES	ZHENGSi Wei / HUANGYa Qiong	44	27650	TontowiAHMAD / LiliyanaNATSIR	3	13300	GOHSoon Huat / LAIShevon Jemie	14	4900	PraveenJORDAN / Melati DaevaOKTAVIANTI		4900
5	IND	30-04	YONEX-SUNRISE DR. AKHILESH DAS GUPTA India Open 2018	350000	HSBC BWF World Tour Super 500	New Delhi	https://bwfworldtour.bwfbadminton.com/tournament/3170/yonex-sunrise-dr-akhilesh-das-gupta-india-open-2018/results/podium/	2018	98 ENTRIES FROM 13 COUNTRIES	SHIYu Qi	8	26250	CHOUTien Chen	7	13300	QIAOBin	34	5075	IskandarZULKARNAIN	97	5075	66 ENTRIES FROM 11 COUNTRIES	BeiwenZHANG	11	26250	PUSARLAV. Sindhu	3	13300	CHEUNGNgan Yi	25	5075	RatchanokINTANON	5	5075	58 ENTRIES FROM 10 COUNTRIES	Marcus FernaldiGIDEON / Kevin SanjayaSUKAMULJO	1	27650	KimASTRUP / Anders SkaarupRASMUSSEN	13	13300	HANCheng Kai / ZHOUHao Dong	67	4900	MohammadAHSAN / HendraSETIAWAN		4900	42 ENTRIES FROM 9 COUNTRIES	GreysiaPOLII / ApriyaniRAHAYU	11	27650	JongkolphanKITITHARAKUL / RawindaPRAJONGJAI	10	13300	DUYue / LIYin Hui	116	4900	Kamilla RytterJUHL / ChristinnaPEDERSEN	3	4900	60 ENTRIES FROM 10 COUNTRIES	MathiasCHRISTIANSEN / ChristinnaPEDERSEN	47	27650	PraveenJORDAN / Melati DaevaOKTAVIANTI		13300	HEJi Ting / DUYue	31	4900	Pranaav JerryCHOPRA / REDDYN. Sikki	18	4900
8	SUI	20-25	YONEX Swiss Open 2018	150000	HSBC BWF World Tour Super 300	Basel	https://bwfworldtour.bwfbadminton.com/tournament/3144/yonex-swiss-open-2018/results/podium/	2018	71 ENTRIES FROM 21 COUNTRIES	SameerVERMA	30	11250	Jan OJORGENSEN	11	5700	LucasCORVEE	58	2175	KantaphonWANGCHAROEN	61	2175	47 ENTRIES FROM 18 COUNTRIES	SayakaTAKAHASHI	22	11250	NatsukiNIDAIRA	62	5700	EvgeniyaKOSETSKAYA	35	2175	MinatsuMITANI	29	2175	41 ENTRIES FROM 15 COUNTRIES	MathiasBOE / CarstenMOGENSEN	2	11850	TinnISRIYANET / KittisakNAMDASH	46	5700	ManeepongJONGJIT / NanthakarnYORDPHAISONG	163	2100	MarcusELLIS / ChrisLANGRIDGE	25	2100	34 ENTRIES FROM 16 COUNTRIES	AyakoSAKURAMOTO / YukikoTAKAHATA	53	11850	GabrielaSTOEVA / StefaniSTOEVA	12	5700	EmilieLEFEL / AnneTRAN	44	2100	NamiMATSUYAMA / ChiharuSHIDA	62	2100	43 ENTRIES FROM 16 COUNTRIES	MarkLAMSFUSS / IsabelHERTTRICH	22	11850	MarcusELLIS / LaurenSMITH	34	5700	Jones RalfyJANSEN / CarlaNYENHUIS		2100	BenLANE / JessicaPUGH	28	2100
10	GER	06-11	YONEX German Open 2018	150000	HSBC BWF World Tour Super 300	Mülheim an der Ruhr	https://bwfworldtour.bwfbadminton.com/tournament/3146/yonex-german-open-2018/results/podium/	2018	96 ENTRIES FROM 26 COUNTRIES	CHOUTien Chen	7	11250	NGKa Long Ang	9	5700	KentaNISHIMOTO	21	2175	SHIYu Qi	8	2175	70 ENTRIES FROM 24 COUNTRIES	AkaneYAMAGUCHI	2	11250	CHENYu Fei	8	5700	NitchaonJINDAPOL	12	2175	NozomiOKUHARA	7	2175	59 ENTRIES FROM 21 COUNTRIES	TakutoINOUE / YukiKANEKO	10	11850	FajarALFIAN / Muhammad RianARDIANTO	11	5700	MohammadAHSAN / HendraSETIAWAN		2100	GOHV Shem / TANWee Kiong	13	2100	51 ENTRIES FROM 21 COUNTRIES	YukiFUKUSHIMA / SayakaHIROTA	4	11850	HUANGDong Ping / ZHENGYu		5700	CHANGYe Na / KIMHye Rin		2100	GabrielaSTOEVA / StefaniSTOEVA	13	2100	71 ENTRIES FROM 21 COUNTRIES	GOHSoon Huat / LAIShevon Jemie	12	11850	NiclasNOHR / SaraTHYGESEN	69	5700	CHOISolGyu / CHAEYuJung	14	2100	HEJi Ting / DUYue	34	2100
11	ENG	14-18	YONEX All England Open 2018	1000000	HSBC BWF World Tour Super 1000	Birmingham	https://bwfworldtour.bwfbadminton.com/tournament/3141/yonex-all-england-open-2018/results/podium/	2018	53 ENTRIES FROM 18 COUNTRIES	SHIYu Qi	8	70000	LINDan	6	34000	HUANGYu Xiang	30	14000	SONWan Ho	4	14000	50 ENTRIES FROM 21 COUNTRIES	TAITzu Ying	1	70000	AkaneYAMAGUCHI	2	34000	CHENYu Fei	8	14000	PUSARLAV. Sindhu	4	14000	50 ENTRIES FROM 17 COUNTRIES	Marcus FernaldiGIDEON / Kevin SanjayaSUKAMULJO	1	74000	MathiasBOE / CarstenMOGENSEN	2	35000	MadsCONRAD-PETERSEN / Mads PielerKOLDING	6	14000	HiroyukiENDO / YutaWATANABE	31	14000	41 ENTRIES FROM 18 COUNTRIES	Kamilla RytterJUHL / ChristinnaPEDERSEN	3	74000	YukiFUKUSHIMA / SayakaHIROTA	4	35000	MayuMATSUMOTO / WakanaNAGAHARA	15	14000	ShihoTANAKA / KoharuYONEMOTO	6	14000	50 ENTRIES FROM 18 COUNTRIES	YutaWATANABE / ArisaHIGASHINO	31	74000	ZHENGSi Wei / HUANGYa Qiong	16	35000	MathiasCHRISTIANSEN / ChristinnaPEDERSEN	28	14000	ZHANGNan / LIYin Hui	8	14000
18	NZL	01-06	BARFOOT & THOMPSON New Zealand Open 2018	150000	HSBC BWF World Tour Super 300	Auckland	https://bwfworldtour.bwfbadminton.com/tournament/3147/barfoot-thompson-new-zealand-open-2018/results/podium/	2018	93 ENTRIES FROM 21 COUNTRIES	LINDan	7	11250	JonatanCHRISTIE	11	5700	HEOKwang Hee	127	2175	SAI PRANEETB.	15	2175	61 ENTRIES FROM 17 COUNTRIES	SayakaTAKAHASHI	19	11250	ZHANGYi Man	108	5700	HANYue	105	2175	MinatsuMITANI	38	2175	49 ENTRIES FROM 14 COUNTRIES	CHENHung Ling / WANGChi-Lin	7	11850	BerryANGRIAWAN / HardiantoHARDIANTO	19	5700	HEJi Ting / TANQiang	36	2100	BodinISARA / NipitphonPHUANGPHUAPET	23	2100	34 ENTRIES FROM 10 COUNTRIES	AyakoSAKURAMOTO / YukikoTAKAHATA	37	11850	CAOTong Wei / ZHENGYu	262	5700	KIMHye Rin / KONGHee Yong	520	2100	ArisaHIGASHINO / KieNAKANISHI	141	2100	52 ENTRIES FROM 13 COUNTRIES	WANGChi-Lin / LEEChia Hsin	19	11850	SEOSeung Jae / CHAEYuJung		5700	HEJi Ting / DUYue	17	2100	DechapolPUAVARANUKROH / SapsireeTAERATTANACHAI	13	2100
19	AUS	08-13	CROWN GROUP Australian Open 2018	150000	HSBC BWF World Tour Super 300	Sydney	https://bwfworldtour.bwfbadminton.com/tournament/3148/crown-group-australian-open-2018/results/podium/	2018	91 ENTRIES FROM 22 COUNTRIES	LUGuang Zu	203	11250	ZHOUZe Qi	158	5700	LEECheuk Yiu	42	2175	ZHAOJun Peng	82	2175	56 ENTRIES FROM 16 COUNTRIES	CAIYan Yan	96	11250	AyumiMINE	239	5700	CHEUNGNgan Yi	31	2175	MinatsuMITANI	38	2175	46 ENTRIES FROM 15 COUNTRIES	BerryANGRIAWAN / HardiantoHARDIANTO	19	11850	Wahyu NayakaARYA PANGKARYAN / Ade YusufSANTOSO	35	5700	ATTRIManu / REDDYB. Sumeeth	34	2100	KeiichiroMATSUI / YoshinoriTAKEUCHI	76	2100	30 ENTRIES FROM 10 COUNTRIES	AyakoSAKURAMOTO / YukikoTAKAHATA	48	11850	BAEKHa Na / LEEYu Lim	55	5700	MisatoARATAMA / AkaneWATANABE	27	2100	CHAEYuJung / KIMHye Jeong		2100	44 ENTRIES FROM 15 COUNTRIES	SEOSeung Jae / CHAEYuJung		11850	CHANPeng Soon / GOHLiu Ying	56	5700	CHOISolGyu / KIMHa Na		2100	WANGZe Kang / LIYin Hui		2100
24	USA	12-17	2018 YONEX US Open	150000	HSBC BWF World Tour Super 300	Fullerton	https://bwfworldtour.bwfbadminton.com/tournament/3216/2018-yonex-us-open/results/podium/	2018	102 ENTRIES FROM 28 COUNTRIES	LEEDong Keun	37	11250	MarkCALJOUW	32	5700	AjayJAYARAM	90	2175	KhositPHETPRADAB	26	2175	56 ENTRIES FROM 19 COUNTRIES	LIXue Rui	232	11250	BeiwenZHANG	12	5700	MichelleLI	14	2175	AyaOHORI	16	2175	55 ENTRIES FROM 19 COUNTRIES	OUXuan Yi / RENXiang Yu	208	11850	KANGMin Hyuk / KIMWon Ho	166	5700	Jason AnthonyHO-SHUE / NylYAKURA	39	2100	JUNGJae Wook / KIMJae Hwan	215	2100	36 ENTRIES FROM 19 COUNTRIES	TANGJin Hua / YUXiao Han	73	11850	KIMHye Jeong / KIMSo Yeong		5700	NaokoFUKUMAN / KurumiYONAO	14	2100	CHOWMei Kuan / VivianHOO	270	2100	54 ENTRIES FROM 18 COUNTRIES	CHANPeng Soon / GOHLiu Ying	46	11850	MarvinSEIDEL / LindaEFLER	19	5700	MarkLAMSFUSS / IsabelHERTTRICH	17	2100	BenLANE / JessicaPUGH	27	2100


CREATE TABLE data (
  "week" BIGINT,
  "country" VARCHAR,
  "dates" VARCHAR,
  "tournament" VARCHAR,
  "prize" BIGINT,
  "category" VARCHAR,
  "city" VARCHAR,
  "link" VARCHAR,
  "year" BIGINT,
  "ms_entries" VARCHAR,
  "ms_winner" VARCHAR,
  "ms_winner_rank" BIGINT,
  "ms_winner_cp" BIGINT,
  "ms_finalist" VARCHAR,
  "ms_finalist_rank" BIGINT,
  "ms_finalist_cp" BIGINT,
  "ms_3_4_1" VARCHAR,
  "ms_3_4_1_rank" BIGINT,
  "ms_3_4_1_cp" BIGINT,
  "ms_3_4_2" VARCHAR,
  "ms_3_4_2_rank" BIGINT,
  "ms_3_4_2_cp" BIGINT,
  "ws_entries" VARCHAR,
  "ws_winner" VARCHAR,
  "ws_winner_rank" BIGINT,
  "ws_winner_cp" BIGINT,
  "ws_finalist" VARCHAR,
  "ws_finalist_rank" BIGINT,
  "ws_finalist_cp" BIGINT,
  "ws_3_4_1" VARCHAR,
  "ws_3_4_1_rank" BIGINT,
  "ws_3_4_1_cp" BIGINT,
  "ws_3_4_2" VARCHAR,
  "ws_3_4_2_rank" DOUBLE,
  "ws_3_4_2_cp" BIGINT,
  "md_entries" VARCHAR,
  "md_winner" VARCHAR,
  "md_winner_rank" DOUBLE,
  "md_winner_cp" BIGINT,
  "md_finalist" VARCHAR,
  "md_finalist_rank" DOUBLE,
  "md_finalist_cp" BIGINT,
  "md_3_4_1" VARCHAR,
  "md_3_4_1_rank" DOUBLE,
  "md_3_4_1_cp" BIGINT,
  "md_3_4_2" VARCHAR,
  "md_3_4_2_rank" DOUBLE,
  "md_3_4_2_cp" BIGINT,
  "wd_entries" VARCHAR,
  "wd_winner" VARCHAR,
  "wd_winner_rank" BIGINT,
  "wd_winner_cp" BIGINT,
  "wd_finalist" VARCHAR,
  "wd_finalist_rank" DOUBLE,
  "wd_finalist_cp" BIGINT,
  "wd_3_4_1" VARCHAR,
  "wd_3_4_1_rank" DOUBLE,
  "wd_3_4_1_cp" BIGINT,
  "wd_3_4_2" VARCHAR,
  "wd_3_4_2_rank" DOUBLE,
  "wd_3_4_2_cp" BIGINT,
  "xd_entries" VARCHAR,
  "xd_winner" VARCHAR,
  "xd_winner_rank" DOUBLE,
  "xd_winner_cp" BIGINT,
  "xd_finalist" VARCHAR,
  "xd_finalist_rank" DOUBLE,
  "xd_finalist_cp" BIGINT,
  "xd_3_4_1" VARCHAR,
  "xd_3_4_1_rank" DOUBLE,
  "xd_3_4_1_cp" BIGINT,
  "xd_3_4_2" VARCHAR,
  "xd_3_4_2_rank" DOUBLE,
  "xd_3_4_2_cp" BIGINT
);