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
2016-M020	Brisbane	Hard	32	A	20160104	271	105062		nan	Mikhail Kukushkin	R	183	KAZ	28.0246406571	104797		nan	Denis Istomin	R	188	UZB	29.325119781	6-2 7-5	3	R32	84	1	3	67	36	27	20	10	3	3	6		53	32	22	12	10	4	7	65	762	61	781
2016-M020	Brisbane	Hard	32	A	20160104	272	103285		PR	Radek Stepanek	R	185	CZE	37.1033538672	105583		nan	Dusan Lajovic	R	180	SRB	25.5140314853	6-0 6-3	3	R32	67	3	2	48	25	18	16	8	2	2		2	46	25	15	8	7	4	8	197	252	76	678
2016-M020	Brisbane	Hard	32	A	20160104	273	106071	7	nan	Bernard Tomic	R	193	AUS	23.2032854209	103917		nan	Nicolas Mahut	R	190	FRA	33.9520876112	6-4 6-3	3	R32	69	8		59	34	28	14	10	4	5	4	1	50	29	21	10	9	3	6	18	1675	71	710
2016-M020	Brisbane	Hard	32	A	20160104	275	104471		Q	Ivan Dodig	R	183	CRO	31.0034223135	117352		Q	Oliver Anderson	U		AUS	17.6810403833	6-3 6-2	3	R32	67	11	2	49	30	24	13	9			3	1	52	30	22	9	8	3	6	87	636	813	25
2016-M020	Brisbane	Hard	32	A	20160104	276	106298		nan	Lucas Pouille	R	185	FRA	21.8617385352	106415		Q	Yoshihito Nishioka	L	170	JPN	20.2710472279	4-6 6-3 7-5	3	R32	143	17	2	95	64	53	15	16	2	4	4	3	120	64	42	30	15	12	15	78	672	117	495
2016-M020	Brisbane	Hard	32	A	20160104	277	105676	6	nan	David Goffin	R	180	BEL	25.0759753593	105064		nan	Thomaz Bellucci	L	188	BRA	28.0136892539	6-4 6-4	3	R32	82	3	4	57	30	23	16	10	1	2	7	2	66	40	25	15	10	7	10	16	1880	37	1105
2016-M020	Brisbane	Hard	32	A	20160104	278	106233	8	nan	Dominic Thiem	R	185	AUT	22.3353867214	105902		WC	James Duckworth	R	183	AUS	23.9534565366	3-6 6-4 6-3	3	R32	113	4	2	80	48	35	21	14	2	4	14	1	93	42	32	26	14	6	9	20	1600	120	485
2016-M020	Brisbane	Hard	32	A	20160104	279	106045		nan	Denis Kudla	R	180	USA	23.3812457221	105441		WC	John Patrick Smith	L		AUS	26.083504449	4-6 6-3 6-2	3	R32	103	2	3	73	44	36	19	14	4	5	8	3	85	40	25	25	13	5	8	69	719	129	459
2016-M020	Brisbane	Hard	32	A	20160104	280	111202		nan	Hyeon Chung	R	188	KOR	19.627652293	105032		nan	Sam Groth	R	193	AUS	28.2108145106	7-6(8) 6-4	3	R32	102	2	3	73	48	35	14	11	2	4	11	3	84	52	39	10	11	8	11	51	817	60	782
2016-M020	Brisbane	Hard	32	A	20160104	282	105777		nan	Grigor Dimitrov	R	188	BUL	24.6379192334	104468	5	nan	Gilles Simon	R	183	FRA	31.0198494182	6-3 7-6(10)	3	R32	125	8	6	81	46	36	18	11	6	7	2	3	91	55	36	16	10	3	5	28	1360	15	2145


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