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
2018-M020	Brisbane	Hard	32	A	20180101	271	105992		nan	Ryan Harrison	R	183	USA	25.6536618754	104919		nan	Leonardo Mayer	R	188	ARG	30.6338124572	6-4 3-6 6-2	3	R32	123	9	2	82	49	39	20	13	8	9	10	3	80	47	33	19	14	1	4	47	1010	52	909
2018-M020	Brisbane	Hard	32	A	20180101	272	111577		nan	Jared Donaldson	R		USA	21.2292950034	111442		WC	Jordan Thompson	R	183	AUS	23.7015742642	6-2 6-4	3	R32	90	5	3	58	32	25	14	9	4	5	3	5	62	41	25	7	9	7	11	54	890	94	593
2018-M020	Brisbane	Hard	32	A	20180101	273	104797		nan	Denis Istomin	R	188	UZB	31.318275154	106000	7	nan	Damir Dzumhur	R	172	BIH	25.6180698152	6-7(4) 6-3 6-2	3	R32	145	7		94	66	48	12	14	9	11	8	6	120	53	37	29	15	10	16	63	809	30	1391
2018-M020	Brisbane	Hard	32	A	20180101	275	200282		WC	Alex De Minaur	R	183	AUS	18.8720054757	105449		nan	Steve Johnson	R	188	USA	28.0219028063	7-6(7) 6-4	3	R32	104	9	3	66	37	32	17	11	2	3	6	2	80	43	33	17	11	4	6	208	245	44	1055
2018-M020	Brisbane	Hard	32	A	20180101	276	111581		Q	Michael Mmoh	R		USA	19.9753593429	105643		nan	Federico Delbonis	L	190	ARG	27.241615332	6-3 6-4	3	R32	69	5	4	55	38	32	11	10	3	3	4		45	35	28	5	9		2	175	299	68	755
2018-M020	Brisbane	Hard	32	A	20180101	277	104999	8	nan	Mischa Zverev	L	190	GER	30.3627652293	105441		Q	John Patrick Smith	L		AUS	28.076659822	6-4 7-5	3	R32	88	4	1	66	51	35	6	11	3	6	4		69	51	27	8	11	1	6	33	1302	218	235
2018-M020	Brisbane	Hard	32	A	20180101	278	105238		nan	Alexandr Dolgopolov	R	180	UKR	29.1498973306	106043	6	nan	Diego Schwartzman	R	170	ARG	25.3771389459	6-4 7-6(3)	3	R32	93	6	4	69	40	32	16	11	3	4	1	2	70	34	22	20	11	1	3	38	1231	26	1675
2018-M020	Brisbane	Hard	32	A	20180101	279	104547		nan	Horacio Zeballos	L	188	ARG	32.681724846	124014		Q	Ernesto Escobedo	R		USA	21.4948665298	6-3 6-4	3	R32	72	12	3	57	37	31	11	10	1	1	9		51	32	25	10	9	4	6	66	768	120	498
2018-M020	Brisbane	Hard	32	A	20180101	280	105051		nan	Matthew Ebden	R	188	AUS	30.0999315537	126207		nan	Frances Tiafoe	R	188	USA	19.947980835	6-3 6-2	3	R32	59	7	1	48	32	23	11	9	2	3	4	4	46	25	18	6	8	1	5	76	670	79	662
2018-M020	Brisbane	Hard	32	A	20180101	282	111202		nan	Hyeon Chung	R	188	KOR	21.620807666	104180	5	nan	Gilles Muller	L	193	LUX	34.6502395619	6-3 7-6(1)	3	R32	99	7	4	64	35	29	17	10	2	2	19	5	68	40	33	10	11	3	5	58	844	25	1695


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