ATP Matches From 2001 To 2020

ATP Matches from 2001 to 2020

@kaggle.afafathar3007_dataset

Atp Matches 2015

@kaggle.afafathar3007_dataset.atp_matches_2015

197.5 KB
2943 rows
49 columns

tourney_id Tourney Id	tourney_name Tourney Name	surface Surface	draw_size Draw Size	tourney_level Tourney Level	tourney_date Tourney Date	match_num Match Num	winner_id Winner Id	winner_seed Winner Seed	winner_entry Winner Entry	winner_name Winner Name	winner_hand Winner Hand	winner_ht Winner Ht	winner_ioc Winner Ioc	winner_age Winner Age	loser_id Loser Id	loser_seed Loser Seed	loser_entry Loser Entry	loser_name Loser Name	loser_hand Loser Hand	loser_ht Loser Ht	loser_ioc Loser Ioc	loser_age Loser Age	score Score	best_of Best Of	round Round	minutes Minutes	w_ace W Ace	w_df W Df	w_svpt W Svpt	w_1stin W 1stIn	w_1stwon W 1stWon	w_2ndwon W 2ndWon	w_svgms W SvGms	w_bpsaved W BpSaved	w_bpfaced W BpFaced	l_ace L Ace	l_df L Df	l_svpt L Svpt	l_1stin L 1stIn	l_1stwon L 1stWon	l_2ndwon L 2ndWon	l_svgms L SvGms	l_bpsaved L BpSaved	l_bpfaced L BpFaced	winner_rank Winner Rank	winner_rank_points Winner Rank Points	loser_rank Loser Rank	loser_rank_points Loser Rank Points
2015-339	Brisbane	Hard	28	A	20150104	1	105357		WC	John Millman	R	183	AUS	25.5605749487	105733		Q	Rhyne Williams	R		USA	23.7919233402	6-3 6-1	3	R32	65	6	2	44	24	19	14	8	1	1	3	4	50	31	20	5	8	1	5	153	328	220	221
2015-339	Brisbane	Hard	28	A	20150104	2	103813		nan	Jarkko Nieminen	L	185	FIN	33.453798768	106045		Q	Denis Kudla	R	180	USA	22.3846680356	4-6 6-1 6-4	3	R32	104	4		92	59	39	17	14	4	7	6	1	83	50	26	19	13	3	8	73	689	123	440
2015-339	Brisbane	Hard	28	A	20150104	3	105902		WC	James Duckworth	R	183	AUS	22.9568788501	104468	6	nan	Gilles Simon	R	183	FRA	30.0232717317	6-2 6-2	3	R32	68	4		45	27	20	11	8	2	3	2	1	56	37	22	5	8	10	15	125	430	21	1730
2015-339	Brisbane	Hard	28	A	20150104	4	104871		nan	Jeremy Chardy	R	188	FRA	27.8959616701	104979		nan	Andrey Golubev	R	185	KAZ	27.4579055441	6-4 6-4	3	R32	69	7	1	53	39	31	11	10			9	2	57	38	30	8	10	1	3	31	1195	72	691
2015-339	Brisbane	Hard	28	A	20150104	5	105373		nan	Martin Klizan	L	190	SVK	25.4866529774	103781		nan	Jurgen Melzer	L	183	AUT	33.6235455168	6-7(5) 7-6(6) 6-1	3	R32	144	9	4	130	79	55	27	16	6	8	4	4	95	62	40	19	15	4	8	34	1094	110	505
2015-339	Brisbane	Hard	28	A	20150104	6	105238	7	nan	Alexandr Dolgopolov	R	180	UKR	26.160164271	104122		nan	Carlos Berlocq	R	183	ARG	31.9206023272	6-2 6-3	3	R32	78	6	1	49	31	24	12	9	3	4	3	2	78	53	32	8	8	11	15	23	1455	71	700
2015-339	Brisbane	Hard	28	A	20150104	7	103997		Q	Lukasz Kubot	R	190	POL	32.6406570842	104731	5	nan	Kevin Anderson	R	203	RSA	28.6351813826	7-6(3) 6-4	3	R32	110	6	5	78	51	35	14	11	3	5	12	3	76	43	30	17	11	4	7	177	282	16	2080
2015-339	Brisbane	Hard	28	A	20150104	8	105032		nan	Sam Groth	R	193	AUS	27.2142368241	103720		nan	Lleyton Hewitt	R	180	AUS	33.8617385352	6-3 6-2	3	R32	59	14		47	34	30	8	9	2	2	1	2	45	22	13	14	8	1	4	85	586	84	595
2015-339	Brisbane	Hard	28	A	20150104	9	105062		nan	Mikhail Kukushkin	R	183	KAZ	27.0280629706	105657		Q	Marius Copil	R	193	ROU	24.219028063	6-4 4-6 6-4	3	R32	113	3	1	84	56	42	16	15	1	3	17	2	89	56	46	15	15	3	6	69	705	201	242
2015-339	Brisbane	Hard	28	A	20150104	10	106423		WC	Thanasi Kokkinakis	R	196	AUS	18.7378507871	103898	8	nan	Julien Benneteau	R	185	FRA	33.0431211499	6-4 6-3	3	R32	75	9	1	52	30	25	14	10	1	2	5	3	52	33	23	7	9	1	4	149	341	25	1365


CREATE TABLE atp_matches_2015 (
  "tourney_id" VARCHAR,
  "tourney_name" VARCHAR,
  "surface" VARCHAR,
  "draw_size" BIGINT,
  "tourney_level" VARCHAR,
  "tourney_date" BIGINT,
  "match_num" BIGINT,
  "winner_id" BIGINT,
  "winner_seed" DOUBLE,
  "winner_entry" VARCHAR,
  "winner_name" VARCHAR,
  "winner_hand" VARCHAR,
  "winner_ht" DOUBLE,
  "winner_ioc" VARCHAR,
  "winner_age" DOUBLE,
  "loser_id" BIGINT,
  "loser_seed" DOUBLE,
  "loser_entry" VARCHAR,
  "loser_name" VARCHAR,
  "loser_hand" VARCHAR,
  "loser_ht" DOUBLE,
  "loser_ioc" VARCHAR,
  "loser_age" DOUBLE,
  "score" VARCHAR,
  "best_of" BIGINT,
  "round" VARCHAR,
  "minutes" DOUBLE,
  "w_ace" DOUBLE,
  "w_df" DOUBLE,
  "w_svpt" DOUBLE,
  "w_1stin" DOUBLE,
  "w_1stwon" DOUBLE,
  "w_2ndwon" DOUBLE,
  "w_svgms" DOUBLE,
  "w_bpsaved" DOUBLE,
  "w_bpfaced" DOUBLE,
  "l_ace" DOUBLE,
  "l_df" DOUBLE,
  "l_svpt" DOUBLE,
  "l_1stin" DOUBLE,
  "l_1stwon" DOUBLE,
  "l_2ndwon" DOUBLE,
  "l_svgms" DOUBLE,
  "l_bpsaved" DOUBLE,
  "l_bpfaced" DOUBLE,
  "winner_rank" DOUBLE,
  "winner_rank_points" DOUBLE,
  "loser_rank" DOUBLE,
  "loser_rank_points" DOUBLE
);

Table List

tourney_id

tourney_name

surface

draw_size

tourney_level

tourney_date

match_num

winner_id

winner_seed

winner_entry

winner_name

winner_hand

winner_ht

winner_ioc

winner_age

loser_id

loser_seed

loser_entry

loser_name

loser_hand

loser_ht

loser_ioc

loser_age

score

best_of

round

minutes

w_ace

w_df

w_svpt

w_1stin

w_1stwon

w_2ndwon

w_svgms

w_bpsaved

w_bpfaced

l_ace

l_df

l_svpt

l_1stin

l_1stwon

l_2ndwon

l_svgms

l_bpsaved

l_bpfaced

winner_rank

winner_rank_points

loser_rank

loser_rank_points