ATP Tennis 2000 - 2024 Daily Update

All ATP matches 2000 - 2024

@kaggle.dissfya_atp_tennis_2000_2023daily_pull

Table List

1 table(1.07 MB)

Atp Tennis

@kaggle.dissfya_atp_tennis_2000_2023daily_pull.atp_tennis

1.07 MB
64166 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
Australian Hardcourt Championships	Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	International	Outdoor	Hard	1st Round	3	Dosedel S.	Ljubicic I.	Dosedel S.	63	77	-1	-1	-1	-1	6-4 6-2
Australian Hardcourt Championships	Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	International	Outdoor	Hard	1st Round	3	Clement A.	Enqvist T.	Enqvist T.	56	5	-1	-1	-1	-1	3-6 3-6
Australian Hardcourt Championships	Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	International	Outdoor	Hard	1st Round	3	Escude N.	Baccanello P.	Escude N.	40	655	-1	-1	-1	-1	6-7 7-5 6-3
Australian Hardcourt Championships	Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	International	Outdoor	Hard	1st Round	3	Knippschild J.	Federer R.	Federer R.	87	65	-1	-1	-1	-1	1-6 4-6
Australian Hardcourt Championships	Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	International	Outdoor	Hard	1st Round	3	Fromberg R.	Woodbridge T.	Fromberg R.	81	198	-1	-1	-1	-1	7-6 5-7 6-4
Australian Hardcourt Championships	Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	International	Outdoor	Hard	1st Round	3	Arthurs W.	Gambill J.M.	Gambill J.M.	105	58	-1	-1	-1	-1	6-3 6-7 4-6
Australian Hardcourt Championships	Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	International	Outdoor	Hard	1st Round	3	Grosjean S.	Ilie A.	Grosjean S.	26	51	-1	-1	-1	-1	6-2 6-1
Australian Hardcourt Championships	Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	International	Outdoor	Hard	1st Round	3	Balcells J.	Henman T.	Henman T.	218	11	-1	-1	-1	-1	4-6 6-7
Australian Hardcourt Championships	Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	International	Outdoor	Hard	1st Round	3	Hewitt L.	Woodforde M.	Hewitt L.	24	129	-1	-1	-1	-1	6-3 2-6 6-1
Australian Hardcourt Championships	Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	International	Outdoor	Hard	1st Round	3	Tebbutt M.	Lisnard J.	Lisnard J.	351	134	-1	-1	-1	-1	6-7 7-6 4-6


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