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
2008-1536	Madrid Masters	Hard	48	M	20081012	1	105208	nan	Ernests Gulbis	R	190	LAT	20.1204654346	103017	nan	Nicolas Kiefer	R	183	GER	31.2744695414	5-7 6-4 7-5	3	R64	143	10	4	99	63	48	21	17	3	4	5	4	95	51	42	26	17	3	5	54	719	27	1120
2008-1536	Madrid Masters	Hard	48	M	20081012	2	103888	nan	Mardy Fish	R	188	USA	26.8446269678	104327	Q	Steve Darcis	R	178	BEL	24.5859000684	6-1 6-4	3	R64	71	13	1	54	25	24	17	9	4	4		1	51	26	14	15	8	1	4	25	1145	59	694
2008-1536	Madrid Masters	Hard	48	M	20081012	3	104259	nan	Philipp Kohlschreiber	R	178	GER	24.9938398357	102845	nan	Carlos Moya	R	190	ESP	32.128678987	6-2 6-2	3	R64	66	3	1	47	28	22	12	8	1	1	3	3	58	36	19	8	8	5	9	31	1065	46	805
2008-1536	Madrid Masters	Hard	48	M	20081012	4	103852	nan	Feliciano Lopez	L	188	ESP	27.0636550308	103656	WC	Albert Montanes	R	175	ESP	27.8795345654	7-6(4) 6-3	3	R64	88	10	1	61	37	34	16	11			1	4	86	48	31	22	10	4	5	40	865	48	777
2008-1536	Madrid Masters	Hard	48	M	20081012	5	103812	Q	Victor Hanescu	R	198	ROU	27.2306639288	104098	nan	Dmitry Tursunov	R	185	RUS	25.8370978782	4-6 6-2 6-3	3	R64	98	12	2	84	57	48	9	14	2	4	5	2	87	62	36	14	13	4	8	73	579	26	1123
2008-1536	Madrid Masters	Hard	48	M	20081012	6	104417	nan	Robin Soderling	R	193	SWE	24.1642710472	103722	Q	Florent Serra	R	180	FRA	27.6221765914	6-3 6-4	3	R64	70	11	2	57	27	20	15	10	3	6	4	2	56	36	21	6	9	4	9	28	1080	64	658
2008-1536	Madrid Masters	Hard	48	M	20081012	7	104468	nan	Gilles Simon	R	183	FRA	23.794661191	104214	nan	Igor Andreev	R	185	RUS	25.2511978097	4-6 6-1 7-6(7)	3	R64	129	9	3	90	48	39	26	15	6	8	6	2	99	64	47	13	14	4	7	16	1390	20	1240
2008-1536	Madrid Masters	Hard	48	M	20081012	8	104068	Q	Robby Ginepri	R	183	USA	26.0177960301	103566	nan	Michael Llodra	L	190	FRA	28.4052019165	6-4 6-4	3	R64	77	6		68	47	34	11	10	1	2	3	3	59	34	23	13	10	3	6	63	660	38	885
2008-1536	Madrid Masters	Hard	48	M	20081012	9	103990	nan	Tommy Robredo	R	180	ESP	26.4531143053	104312	nan	Andreas Seppi	R	190	ITA	24.643394935	7-6(5) 3-6 6-3	3	R64	140	7	2	97	59	46	21	15	3	5	4		93	59	38	25	15		2	19	1255	36	975
2008-1536	Madrid Masters	Hard	48	M	20081012	10	104792	nan	Gael Monfils	R	193	FRA	22.1163586585	104926	WC	Fabio Fognini	R	178	ITA	21.3908281999	6-2 6-4	3	R64	69	5	1	57	33	21	16	9	1	2	1	7	58	30	17	14	9	7	11	18	1283	75	573


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