ATP Matches From 2001 To 2020

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_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
2011-339	Brisbane	Hard	32	A	20110102	1	104417	1	nan	Robin Soderling	R	193	SWE	26.3874058864	105992	Q	Ryan Harrison	R	183	USA	18.6584531143	6-2 6-4	3	R32	66	8	3	52	32	26	13	9	1	1	4	1	50	27	16	12	9	1	4	5	5580	173	309
2011-339	Brisbane	Hard	32	A	20110102	2	103582		nan	Michael Berrer	L	193	GER	30.507871321	104534	nan	Dudi Sela	R	175	ISR	25.749486653	1-6 7-6(3) 6-2	3	R32	152	9	3	99	54	34	28	13	8	10	16	4	103	59	42	20	14	3	5	58	835	75	643
2011-339	Brisbane	Hard	32	A	20110102	3	105051		Q	Matthew Ebden	R	188	AUS	23.1047227926	105357	WC	John Millman	R	183	AUS	21.5550992471	4-6 6-2 6-4	3	R32	104	12	1	85	63	46	9	14	1	3	4	3	76	58	42	6	14	4	8	196	263	204	243
2011-339	Brisbane	Hard	32	A	20110102	4	104797	8	nan	Denis Istomin	R	188	UZB	24.3230663929	105217	nan	Thiemo De Bakker	R	193	NED	22.288843258	7-6(5) 6-4	3	R32	93	6	1	63	43	33	16	11	2	2	10	1	72	43	31	17	11	2	3	40	1031	43	975
2011-339	Brisbane	Hard	32	A	20110102	5	103888	4	nan	Mardy Fish	R	188	USA	29.067761807	105173	Q	Adrian Mannarino	L	183	FRA	22.5133470226	6-1 6-4	3	R32	79	11		51	28	23	16	9	1	1	1	6	68	37	24	11	8	3	6	16	1991	83	600
2011-339	Brisbane	Hard	32	A	20110102	6	103285		nan	Radek Stepanek	R	185	CZE	32.1013004791	104735	nan	Tobias Kamke	R	180	GER	24.6214921287	5-7 6-1 6-4	3	R32	124	7	3	80	47	37	16	15	2	5	4	7	87	50	33	19	14	5	10	62	795	67	724
2011-339	Brisbane	Hard	32	A	20110102	7	105575		Q	Ricardas Berankis	R	175	LTU	20.5366187543	103096	nan	Arnaud Clement	R	173	FRA	33.0458590007	6-4 6-3	3	R32	86	8	2	55	30	24	13	9	1	2	6	3	64	37	26	11	10	5	9	87	587	78	627
2011-339	Brisbane	Hard	32	A	20110102	8	104252	7	nan	Florian Mayer	R	190	GER	27.2470910335	106071	WC	Bernard Tomic	R	193	AUS	18.2012320329	6-2 6-2	3	R32	55	12		35	25	23	9	8			5		58	34	22	6	8	1	5	37	1128	208	239
2011-339	Brisbane	Hard	32	A	20110102	9	103852	6	nan	Feliciano Lopez	L	188	ESP	29.28678987	104332	nan	Philipp Petzschner	R	185	GER	26.7789185489	6-4 7-6(11)	3	R32	100	11	7	77	39	33	21	11	4	5	9	5	68	30	25	22	11		2	32	1300	57	839
2011-339	Brisbane	Hard	32	A	20110102	10	104731		nan	Kevin Anderson	R	203	RSA	24.629705681	103429	LL	Peter Luczak	R	183	AUS	31.3429158111	6-4 6-4	3	R32	72	18		44	33	31	9	10			4	2	58	41	28	10	10	1	3	61	813	137	400


CREATE TABLE atp_matches_2011 (
  "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
);