🎾🎾Atp Tennis Data With Betting Odds 🎾🎾

Atp tennis Data from the ATP tour with betting odds from different bookmakers

@kaggle.edoardoba_atp_tennis_data

Table List

1 table(1.23 MB)

Tennis Data

@kaggle.edoardoba_atp_tennis_data.tennis_data

1.23 MB
36120 rows
54 columns

atp ATP	location Location	tournament Tournament	date Date	series Series	court Court	surface Surface	round Round	best_of Best Of	winner Winner	loser Loser	wrank WRank	lrank LRank	wpts WPts	lpts LPts	w1 W1	l1 L1	w2 W2	l2 L2	w3 W3	l3 L3	wsets Wsets	lsets Lsets	comment Comment	b365w B365W	b365l B365L	psw PSW	psl PSL	maxw MaxW	maxl MaxL	avgw AvgW	avgl AvgL	pl1_flag Pl1 Flag	pl1_year_pro Pl1 Year Pro	pl1_weight Pl1 Weight	pl1_height Pl1 Height	pl1_hand Pl1 Hand	pl2_flag Pl2 Flag	pl2_year_pro Pl2 Year Pro	pl2_weight Pl2 Weight	pl2_height Pl2 Height	pl2_hand Pl2 Hand
1	Adelaide	Adelaide International 1	Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Kwon S.W.	Nishioka Y.	53	81	1115	823	6	1	6	2			2		Completed	1.61	2.3	1.7	2.26	1.76	2.5	1.64	2.22	KOR	2015	72	180	Right-Handed	JPN	2014	64	170	Left-Handed
1	Adelaide	Adelaide International 1	Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Monteiro T.	Altmaier D.	89	84	805	813	6	2	3	6	7	6	2	1	Completed	2.3	1.61	2.49	1.6	2.6	1.62	2.38	1.57	BRA	2011	78	183	Left-Handed	GER	2014	80	188	Right-Handed
1	Adelaide	Adelaide International 1	Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Djere L.	Carballes Baena R.	52	79	1131	837	7	5	7	6			2		Completed	1.66	2.2	1.81	2.1	1.83	2.26	1.7	2.12	SRB	2013	80	185	Right-Handed	ESP	2011	76	180	Right-Handed
1	Adelaide	Adelaide International 1	Mon Jan 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Johnson S.	Vukic A.	85	156	812	440	6	4	2	6	6	4	2	1	Completed	2	1.8	2.21	1.74	2.3	1.8	2.1	1.72	USA	2012	86	188	Right-Handed	AUS	2018	85	188	Right-Handed
1	Adelaide	Adelaide International 1	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Moutet C.	Rune H.	92	103	797	740	7	6	6	4			2		Completed	2.75	1.44	2.66	1.53	2.81	1.54	2.64	1.47	FRA	2016	71	175	Left-Handed	DEN	2020	77	188	Right-Handed
1	Adelaide	Adelaide International 1	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Daniel T.	Musetti L.	125	59	584	1004	6	4	6	7	6	3	2	1	Completed	2	1.8	2.19	1.75	2.25	1.8	2.09	1.73	JPN	2010	76	191	Right-Handed	ITA	2019	78	185	Right-Handed
1	Adelaide	Adelaide International 1	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Gerasimov E.	Fucsovics M.	113	40	665	1459	6	3	6	4			2		Completed	2.37	1.57	2.91	1.46	2.91	1.57	2.62	1.48	BLR	2010	84	183	Right-Handed	HUN	2010	82	188	Right-Handed
1	Adelaide	Adelaide International 1	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Ymer M.	Bonzi B.	94	64	782	969	7	5	7	5			2		Completed	2	1.8	2.15	1.78	2.15	1.82	2.04	1.77	SWE	2015	75	183	Right-Handed	FRA	2015	82	183	Right-Handed
1	Adelaide	Adelaide International 1	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Cerundolo J.M.	Bolt A.	90	137	803	506	6	2	6	4			2		Completed	2.75	1.44	2.87	1.47	3.32	1.47	2.89	1.41	ARG	2018	71	183	Left-Handed	AUS	2011	84	183	Left-Handed
1	Adelaide	Adelaide International 1	Tue Jan 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Paul T.	Vesely J.	43	83	1349	822	6	4	4	6	6	4	2	1	Completed	1.33	3.4	1.35	3.45	1.35	3.6	1.32	3.35	USA	2015	78	185	Right-Handed	CZE	2009	92	198	Left-Handed


CREATE TABLE tennis_data (
  "atp" BIGINT,
  "location" VARCHAR,
  "tournament" VARCHAR,
  "date" TIMESTAMP,
  "series" VARCHAR,
  "court" VARCHAR,
  "surface" VARCHAR,
  "round" VARCHAR,
  "best_of" BIGINT,
  "winner" VARCHAR,
  "loser" VARCHAR,
  "wrank" DOUBLE,
  "lrank" DOUBLE,
  "wpts" DOUBLE,
  "lpts" DOUBLE,
  "w1" DOUBLE,
  "l1" DOUBLE,
  "w2" DOUBLE,
  "l2" DOUBLE,
  "w3" DOUBLE,
  "l3" DOUBLE,
  "w4" DOUBLE,
  "l4" DOUBLE,
  "w5" DOUBLE,
  "l5" DOUBLE,
  "wsets" DOUBLE,
  "lsets" DOUBLE,
  "comment" VARCHAR,
  "b365w" DOUBLE,
  "b365l" DOUBLE,
  "psw" DOUBLE,
  "psl" DOUBLE,
  "maxw" DOUBLE,
  "maxl" DOUBLE,
  "avgw" DOUBLE,
  "avgl" DOUBLE,
  "exw" DOUBLE,
  "exl" DOUBLE,
  "lbw" DOUBLE,
  "lbl" DOUBLE,
  "sjw" DOUBLE,
  "sjl" DOUBLE,
  "ubw" DOUBLE,
  "ubl" DOUBLE,
  "pl1_flag" VARCHAR,
  "pl1_year_pro" DOUBLE,
  "pl1_weight" DOUBLE,
  "pl1_height" DOUBLE,
  "pl1_hand" VARCHAR,
  "pl2_flag" VARCHAR,
  "pl2_year_pro" DOUBLE,
  "pl2_weight" DOUBLE,
  "pl2_height" DOUBLE,
  "pl2_hand" VARCHAR
);