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
2017-M020	Brisbane	Hard	32	A	20170102	271	104678		nan	Viktor Troicki	R	193	SRB	30.893908282	106415	Q	Yoshihito Nishioka	L	170	JPN	21.2676249144	6-4 7-5	3	R32	91	11	5	64	45	35	6	11	1	3		1	82	53	33	13	11	6	10	29	1385	100	604
2017-M020	Brisbane	Hard	32	A	20170102	272	106378		nan	Kyle Edmund	R	188	GBR	21.9849418207	124014	Q	Ernesto Escobedo	R		USA	20.4982888433	7-6(4) 7-6(6)	3	R32	130	11	2	83	48	37	19	12	2	3	11	3	113	67	39	27	12	9	10	45	1001	141	443
2017-M020	Brisbane	Hard	32	A	20170102	273	106298	6	nan	Lucas Pouille	R	185	FRA	22.8583162218	104468	nan	Gilles Simon	R	183	FRA	32.0164271047	7-6(6) 7-6(4)	3	R32	125	7	2	102	52	37	24	12	8	12	1	4	76	42	29	16	12		4	15	2156	25	1585
2017-M020	Brisbane	Hard	32	A	20170102	275	111577		Q	Jared Donaldson	R		USA	20.2327173169	104180	nan	Gilles Muller	L	193	LUX	33.6536618754	6-4 6-4	3	R32	75	12	2	55	33	27	13	10		1	10	2	58	37	27	7	10	2	5	105	570	34	1255
2017-M020	Brisbane	Hard	32	A	20170102	276	111442		WC	Jordan Thompson	R	183	AUS	22.7049965777	111200	WC	Elias Ymer	R	183	SWE	20.7310061602	6-3 6-2	3	R32	90	1		46	28	26	6	8	1	2	1	6	74	43	23	13	9	10	15	79	689	160	372
2017-M020	Brisbane	Hard	32	A	20170102	277	103970	8	nan	David Ferrer	R	175	ESP	34.7542778919	106071	nan	Bernard Tomic	R	193	AUS	24.1998631075	6-3 7-5	3	R32	83	3	5	52	30	25	12	10	2	3	5	8	74	44	29	12	11	5	9	21	1785	26	1465
2017-M020	Brisbane	Hard	32	A	20170102	278	105777	7	nan	Grigor Dimitrov	R	188	BUL	25.6344969199	105449	nan	Steve Johnson	R	188	USA	27.0253251198	6-2 6-3	3	R32	75	3		48	25	23	12	9		1	2	3	57	36	21	7	8	4	8	17	2035	33	1320
2017-M020	Brisbane	Hard	32	A	20170102	279	103917		nan	Nicolas Mahut	R	190	FRA	34.9486652977	103565	nan	Stephane Robert	R	185	FRA	36.629705681	4-6 6-3 6-4	3	R32	120	13	3	86	55	42	17	15	2	4	9	8	94	46	29	30	14	9	12	39	1102	54	854
2017-M020	Brisbane	Hard	32	A	20170102	280	105032		WC	Sam Groth	R	193	AUS	29.2073921971	105732	nan	Pierre Hugues Herbert	R	188	FRA	25.7960301164	6-3 5-7 7-5	3	R32	130	20	5	106	59	45	28	17	8	10	9	5	87	48	33	24	16	4	7	180	320	78	698
2017-M020	Brisbane	Hard	32	A	20170102	282	104745	5	nan	Rafael Nadal	L	185	ESP	30.5845311431	105238	nan	Alexandr Dolgopolov	R	180	UKR	28.1533196441	6-3 6-3	3	R32	74	2	1	52	36	26	10	9	2	3	2	2	53	28	20	7	9		4	9	3300	62	760


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