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
2009-1536	Madrid Masters	Clay	56	M	20090510	1	103781		nan	Jurgen Melzer	L	183	AUT	27.9698836413	103656		nan	Albert Montanes	R	175	ESP	28.4544832307	4-6 7-5 6-3	3	R64	120	10	4	82	46	38	20	16	1	3	3	3	91	51	35	26	15	3	6	27	1735	28	1724
2009-1536	Madrid Masters	Clay	56	M	20090510	2	104259		nan	Philipp Kohlschreiber	R	178	GER	25.568788501	104597		nan	Nicolas Almagro	R	183	ESP	23.7207392197	6-3 6-4	3	R64	92	2	1	63	44	33	12	10	3	3	7		69	36	29	13	9	7	9	35	1510	34	1515
2009-1536	Madrid Masters	Clay	56	M	20090510	3	105227	13	nan	Marin Cilic	R	198	CRO	20.6160164271	104719		nan	Marcel Granollers	R	190	ESP	23.0800821355	6-2 6-7(4) 6-1	3	R64	149	3	3	108	57	38	31	14	8	9		4	79	45	26	21	13	5	10	14	2635	90	835
2009-1536	Madrid Masters	Clay	56	M	20090510	4	103970	12	nan	David Ferrer	R	175	ESP	27.1074606434	103084		Q	Guillermo Canas	R	185	ARG	31.4579055441	6-2 6-2	3	R64	84		1	41	23	18	13	8	1	2	2	2	66	26	14	18	8	7	12	13	2645	108	734
2009-1536	Madrid Masters	Clay	56	M	20090510	5	104338		WC	Juan Monaco	R	185	ARG	25.1170431211	103852		nan	Feliciano Lopez	L	188	ESP	27.6386036961	6-4 7-5	3	R64	130		1	74	52	35	15	11	6	6	5	1	93	44	31	25	11	12	14	47	1240	32	1620
2009-1536	Madrid Masters	Clay	56	M	20090510	6	103507		WC	Juan Carlos Ferrero	R	183	ESP	29.2429842574	103857		nan	Igor Kunitsyn	R	180	RUS	27.6112251882	6-3 4-6 6-4	3	R64	131	1	3	98	63	37	21	15	4	8	1	1	85	61	36	11	14	5	10	115	724	39	1468
2009-1536	Madrid Masters	Clay	56	M	20090510	7	103169		WC	Oscar Hernandez	R	180	ESP	31.0855578371	103506		nan	Martin Vassallo Arguello	R	183	ARG	29.2484599589	6-3 6-3	3	R64	91	2	1	51	38	30	8	9	1	1	1		75	49	31	8	9	7	10	65	1023	49	1209
2009-1536	Madrid Masters	Clay	56	M	20090510	8	104312		nan	Andreas Seppi	R	190	ITA	25.2183436003	104724		Q	Eduardo Schwank	R	183	ARG	23.0499657769	7-5 6-4	3	R64	107	2		80	54	33	16	11	9	11	1	4	59	34	21	15	11		4	36	1490	68	997
2009-1536	Madrid Masters	Clay	56	M	20090510	9	105023		nan	Sam Querrey	R	198	USA	21.5934291581	103285	15	nan	Radek Stepanek	R	185	CZE	30.4531143053	7-6(2) 5-2 RET	3	R64	78	10		56	33	29	13	9	1	1	4	4	64	37	24	16	10	4	6	60	1085	19	2090
2009-1536	Madrid Masters	Clay	56	M	20090510	10	104542	9	nan	Jo-Wilfried Tsonga	R	188	FRA	24.0657084189	103498		nan	Marat Safin	R	193	RUS	29.28678987	6-4 7-5	3	R64	90	2	2	60	36	30	15	11	1	1	9		68	30	25	19	11	4	6	9	3455	20	2015


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