ATP Tennis 2013 - 2023

All ATP matches 2013 - 2023

@kaggle.dissfya_atp_tennis_2013_2023

Table List

1 table(447.69 KB)

Atp Tennis

@kaggle.dissfya_atp_tennis_2013_2023.atp_tennis

447.69 KB
25362 rows
17 columns

tournament Tournament	date Date	series Series	court Court	surface Surface	round Round	best_of Best Of	player_1 Player 1	player_2 Player 2	winner Winner	rank_1 Rank 1	rank_2 Rank 2	pts_1 Pts 1	pts_2 Pts 2	odd_1 Odd 1	odd_2 Odd 2	score Score
Brisbane International	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Mayer F.	Giraldo S.	Mayer F.	28	57	1215	778	1.36	3	6-4 6-4
Brisbane International	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Benneteau J.	Nieminen J.	Nieminen J.	35	41	1075	927	2.2	1.61	3-6 6-2 1-6
Brisbane International	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Nishikori K.	Matosevic M.	Nishikori K.	19	49	1830	845	1.25	3.75	7-5 6-2
Brisbane International	Mon Dec 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Mitchell B.	Baghdatis M.	Baghdatis M.	326	36	137	1070	9	1.07	4-6 4-6
Brisbane International	Tue Jan 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Istomin D.	Klizan M.	Istomin D.	43	30	897	1175	1.9	1.8	6-1 6-2
Brisbane International	Tue Jan 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Ito T.	Millman J.	Millman J.	79	199	655	239	2.2	1.61	4-6 1-6
Brisbane International	Tue Jan 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Falla A.	Levine J.	Falla A.	54	104	809	530	2.2	1.61	6-1 7-6
Brisbane International	Tue Jan 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Kudla D.	Melzer J.	Melzer J.	137	29	402	1177	2.62	1.44	6-2 4-6 4-6
Brisbane International	Tue Jan 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Robredo T.	Harrison R.	Robredo T.	114	69	495	710	3	1.36	6-4 7-6
Brisbane International	Tue Jan 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	ATP250	Outdoor	Hard	1st Round	3	Baker B.	Dimitrov G.	Dimitrov G.	61	48	756	866	3	1.36	3-6 6-7


CREATE TABLE atp_tennis (
  "tournament" VARCHAR,
  "date" TIMESTAMP,
  "series" VARCHAR,
  "court" VARCHAR,
  "surface" VARCHAR,
  "round" VARCHAR,
  "best_of" BIGINT,
  "player_1" VARCHAR,
  "player_2" VARCHAR,
  "winner" VARCHAR,
  "rank_1" BIGINT,
  "rank_2" BIGINT,
  "pts_1" BIGINT,
  "pts_2" BIGINT,
  "odd_1" DOUBLE,
  "odd_2" DOUBLE,
  "score" VARCHAR
);