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_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
2013-339	Brisbane	Hard	28	A	20121230	1	105357		Q	John Millman	R	183	AUS	23.5482546201	105147		nan	Tatsuma Ito	R	180	JPN	24.6214921287	6-4 6-1	3	R32	86	7	6	69	44	33	11	9	3	4	2	5	53	26	19	8	8	3	7	199	239	79	655
2013-339	Brisbane	Hard	28	A	20121230	2	103720		WC	Lleyton Hewitt	R	180	AUS	31.8494182067	103857		LL	Igor Kunitsyn	R	180	RUS	31.2525667351	6-3 4-6 6-2	3	R32	124	8	2	69	34	29	21	13	1	2	7	5	99	53	37	19	14	6	10	83	625	162	339
2013-339	Brisbane	Hard	28	A	20121230	3	104797		nan	Denis Istomin	R	188	UZB	26.3162217659	105373	8	nan	Martin Klizan	L	190	SVK	23.4743326489	6-1 6-2	3	R32	70	6	2	53	33	28	8	8	2	2	3	3	57	31	19	9	7	9	13	43	897	30	1175
2013-339	Brisbane	Hard	28	A	20121230	4	103813		nan	Jarkko Nieminen	L	185	FIN	31.4414784394	103898		nan	Julien Benneteau	R	185	FRA	31.0308008214	6-3 2-6 6-1	3	R32	104	4	1	94	63	40	15	12	8	11	6	6	70	48	29	7	12	1	6	41	927	35	1075
2013-339	Brisbane	Hard	28	A	20121230	5	103990		nan	Tommy Robredo	R	180	ESP	30.6694045175	105992		Q	Ryan Harrison	R	183	USA	20.6516084873	6-4 7-6(4)	3	R32	96	6		64	50	43	8	11	1	1	4	1	68	39	26	20	11		1	114	495	69	710
2013-339	Brisbane	Hard	28	A	20121230	6	105453	5	nan	Kei Nishikori	R	178	JPN	23.0061601643	104594		nan	Marinko Matosevic	R	194	AUS	27.3976728268	7-5 6-2	3	R32	102	2		72	45	29	17	10	4	5	3	1	70	37	25	13	10	3	7	19	1830	49	845
2013-339	Brisbane	Hard	28	A	20121230	7	104252	6	nan	Florian Mayer	R	190	GER	29.2402464066	105053		nan	Santiago Giraldo	R	188	COL	25.0951403149	6-4 6-4	3	R32	65	6	1	50	33	27	14	10			3		54	40	30	7	10		2	28	1215	57	778
2013-339	Brisbane	Hard	28	A	20121230	8	104571		nan	Marcos Baghdatis	R	183	CYP	27.5400410678	106093		WC	Benjamin Mitchell	R		AUS	20.0848733744	6-4 6-4	3	R32	77	5	1	60	35	30	14	10	4	4	5	1	57	35	28	10	10		2	36	1070	327	137
2013-339	Brisbane	Hard	28	A	20121230	9	104268		nan	Alejandro Falla	L	185	COL	29.1307323751	105028		Q	Jesse Levine	L	175	CAN	25.2128678987	6-1 7-6(8)	3	R32	78	11	1	59	46	40	8	10			5	2	74	45	29	16	9	8	10	54	809	104	530
2013-339	Brisbane	Hard	28	A	20121230	10	103781	7	nan	Jurgen Melzer	L	183	AUT	31.6112251882	106045		Q	Denis Kudla	R	180	USA	20.372347707	2-6 6-4 6-4	3	R32	107	5	1	78	55	40	12	14	3	6	3	3	91	48	37	20	14	4	7	29	1177	137	402


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