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
2019-M020	Brisbane	Hard	32	A	20181231	300	105453	2	nan	Kei Nishikori	R	178	JPN	29.0047912389	106421	4	nan	Daniil Medvedev	R	198	RUS	22.8856947296	6-4 3-6 6-2	3	F	124	3	3	77	44	31	17	13	3	6	8	6	100	54	34	20	14	10	15	9	3590	16	1977
2019-M020	Brisbane	Hard	32	A	20181231	299	106421	4	nan	Daniil Medvedev	R	198	RUS	22.8856947296	104542		PR	Jo-Wilfried Tsonga	R	188	FRA	33.7056810404	7-6(6) 6-2	3	SF	82	10	1	52	33	28	14	10		1	17	2	77	52	36	7	10	10	13	16	1977	239	200
2019-M020	Brisbane	Hard	32	A	20181231	298	105453	2	nan	Kei Nishikori	R	178	JPN	29.0047912389	104871		nan	Jeremy Chardy	R	188	FRA	31.8822724162	6-2 6-2	3	SF	66	2	2	47	33	26	9	8	2	2	10	3	46	27	15	6	8	1	5	9	3590	40	1050
2019-M020	Brisbane	Hard	32	A	20181231	297	104542		PR	Jo-Wilfried Tsonga	R	188	FRA	33.7056810404	200282	7	nan	Alex De Minaur	R	183	AUS	19.8685831622	6-4 7-6(2)	3	QF	106	12	2	68	43	34	15	11	4	5	1	2	81	60	38	9	11	4	6	239	200	31	1298
2019-M020	Brisbane	Hard	32	A	20181231	296	106421	4	nan	Daniil Medvedev	R	198	RUS	22.8856947296	105683	5	nan	Milos Raonic	R	196	CAN	28.0109514031	6-7(2) 6-3 6-4	3	QF	129	12	3	105	68	48	25	16	8	8	29	5	94	56	46	19	15	2	4	16	1977	18	1855
2019-M020	Brisbane	Hard	32	A	20181231	295	104871		nan	Jeremy Chardy	R	188	FRA	31.8822724162	106034		Q	Yasutaka Uchiyama	R	183	JPN	26.4038329911	6-4 3-6 7-6(4)	3	QF	127	10	8	94	58	44	18	16	4	8	12	6	90	54	40	18	15	6	9	40	1050	185	275
2019-M020	Brisbane	Hard	32	A	20181231	294	105453	2	nan	Kei Nishikori	R	178	JPN	29.0047912389	105777	6	nan	Grigor Dimitrov	R	188	BUL	27.627652293	7-5 7-5	3	QF	100	5	2	59	47	37	9	12		1	8	5	80	53	37	13	12	6	9	9	3590	19	1835
2019-M020	Brisbane	Hard	32	A	20181231	293	104542		PR	Jo-Wilfried Tsonga	R	188	FRA	33.7056810404	106121		LL	Taro Daniel	R	191	JPN	25.9247091034	7-6(5) 6-3	3	R16	100	11	3	64	37	30	11	10	4	7	3	7	85	51	34	11	11	6	11	239	200	77	691
2019-M020	Brisbane	Hard	32	A	20181231	292	200282	7	nan	Alex De Minaur	R	183	AUS	19.8685831622	111442		nan	Jordan Thompson	R	183	AUS	24.6981519507	6-4 6-2	3	R16	80	1	1	49	38	29	8	9			5		56	39	30	3	9	3	6	31	1298	72	715
2019-M020	Brisbane	Hard	32	A	20181231	291	106421	4	nan	Daniil Medvedev	R	198	RUS	22.8856947296	104918		PR	Andy Murray	R	190	GBR	31.6303901437	7-5 6-2	3	R16	81	16	2	54	34	27	13	10		1	6	1	60	39	27	7	10	2	6	16	1977	240	200


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