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_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
2020-8888	Atp Cup	Hard	24	A	20200106	300	104925	nan	Novak Djokovic	R	188	SRB	32.6269678303	104745	nan	Rafael Nadal	L	185	ESP	33.5934291581	6-2 7-6(4)	3	F	115	12	2	64	49	41	9	10	5	5	5	3	70	51	39	6	10	6	8	2	9055	1	9985
2020-8888	Atp Cup	Hard	24	A	20200106	299	105138	nan	Roberto Bautista Agut	R	183	ESP	31.7289527721	105583	nan	Dusan Lajovic	R	180	SRB	29.5195071869	7-5 6-1	3	F	97	2	1	59	44	29	10	10	3	5	2	1	57	35	21	6	9	5	10	10	2335	34	1251
2020-8888	Atp Cup	Hard	24	A	20200106	298	104925	nan	Novak Djokovic	R	188	SRB	32.6269678303	106421	nan	Daniil Medvedev	R	198	RUS	23.9014373717	6-1 5-7 6-4	3	SF	167	4	5	111	75	53	16	15	8	11	6	5	108	57	35	25	14	6	11	2	9055	5	5705
2020-8888	Atp Cup	Hard	24	A	20200106	297	105583	nan	Dusan Lajovic	R	180	SRB	29.5195071869	111575	nan	Karen Khachanov	R	198	RUS	23.627652293	7-5 7-6(1)	3	SF	108	1	1	67	48	38	14	12			9	3	79	54	39	14	12		1	34	1251	17	1840
2020-8888	Atp Cup	Hard	24	A	20200106	296	104745	nan	Rafael Nadal	L	185	ESP	33.5934291581	200282	nan	Alex De Minaur	R	183	AUS	20.8843258042	4-6 7-5 6-1	3	SF	133	5	3	84	61	48	10	15	1	3	6	1	75	55	37	10	14	1	5	1	9985	18	1775
2020-8888	Atp Cup	Hard	24	A	20200106	295	105138	nan	Roberto Bautista Agut	R	183	ESP	31.7289527721	106401	nan	Nick Kyrgios	R	193	AUS	24.6954140999	6-1 6-4	3	SF	81	4		57	44	35	7	9	1	1	13	1	55	38	22	8	8	4	7	10	2335	29	1375
2020-8888	Atp Cup	Hard	24	A	20200106	294	104925	nan	Novak Djokovic	R	188	SRB	32.6269678303	133430	nan	Denis Shapovalov	L	185	CAN	20.7282683094	4-6 6-1 7-6(4)	3	QF	160	4	8	106	64	46	24	15	5	7	15	7	85	44	36	19	14	2	5	2	9055	14	2050
2020-8888	Atp Cup	Hard	24	A	20200106	293	105583	nan	Dusan Lajovic	R	180	SRB	29.5195071869	200000	nan	Felix Auger Aliassime	R	193	CAN	19.4113620808	6-4 6-2	3	QF	99	3		62	47	35	8	9	2	2	10	5	68	45	31	7	9	8	11	34	1251	21	1636
2020-8888	Atp Cup	Hard	24	A	20200106	292	106421	nan	Daniil Medvedev	R	198	RUS	23.9014373717	106043	nan	Diego Schwartzman	R	170	ARG	27.3894592745	6-4 4-6 6-3	3	QF	142	14		103	68	53	13	15	8	10	1	3	82	56	36	16	14	2	5	5	5705	13	2125
2020-8888	Atp Cup	Hard	24	A	20200106	291	111575	nan	Karen Khachanov	R	198	RUS	23.627652293	105550	nan	Guido Pella	L	185	ARG	29.6399726215	6-2 7-6(4)	3	QF	98	7	1	63	46	39	7	10	5	6	3	4	65	36	24	14	10	2	5	17	1840	25	1530


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