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
2007-1536	Madrid Masters	Hard	48	M	20071015	1	104068	Q	Robby Ginepri	R	183	USA	25.0212183436	103781	nan	Jurgen Melzer	L	183	AUT	26.3983572895	2-6 7-6(2) 6-4	3	R64	117	4	3	99	64	40	23	15	4	7	4	2	89	61	43	16	15	4	6	72	535	56	625
2007-1536	Madrid Masters	Hard	48	M	20071015	2	102860	Q	Agustin Calleri	R	183	ARG	31.0828199863	104098	nan	Dmitry Tursunov	R	185	RUS	24.8405201916	3-6 7-6(4) 6-4	3	R64	108	9	2	83	44	35	28	15		1	6	2	91	53	43	23	16		1	50	660	28	950
2007-1536	Madrid Masters	Hard	48	M	20071015	3	102905	Q	Stefan Koubek	L	175	AUT	30.7816563997	103813	nan	Jarkko Nieminen	L	185	FIN	26.2286105407	6-3 3-6 6-4	3	R64	98	5	3	78	42	32	18	14	3	7	3	4	94	63	37	16	14	8	13	68	565	29	935
2007-1536	Madrid Masters	Hard	48	M	20071015	4	103852	WC	Feliciano Lopez	L	188	ESP	26.0670773443	103835	nan	Filippo Volandri	R	183	ITA	26.1081451061	6-3 6-2	3	R64	79	5	2	57	37	30	7	9	3	4		3	42	18	12	10	8	1	5	42	741	43	731
2007-1536	Madrid Masters	Hard	48	M	20071015	5	103333	nan	Ivo Karlovic	R	208	CRO	28.6269678303	103498	nan	Marat Safin	R	193	RUS	27.7152635181	6-3 6-4	3	R64	58	17	2	53	38	34	7	10	2	2	3	2	47	26	21	12	9	2	4	24	1258	36	855
2007-1536	Madrid Masters	Hard	48	M	20071015	6	103017	nan	Nicolas Kiefer	R	183	GER	30.2778918549	104527	nan	Stan Wawrinka	R	183	SUI	22.5489390828	7-5 6-3	3	R64	98	3	2	68	40	28	19	11	4	5	1	1	67	45	25	13	10	2	5	112	370	35	860
2007-1536	Madrid Masters	Hard	48	M	20071015	7	104338	nan	Juan Monaco	R	185	ARG	23.5455167693	104214	nan	Igor Andreev	R	185	RUS	24.2546201232	6-7(5) 6-0 6-4	3	R64	240	3	1	104	77	53	16	14	10	11	5	3	100	70	44	13	14	6	11	20	1350	33	895
2007-1536	Madrid Masters	Hard	48	M	20071015	8	104597	nan	Nicolas Almagro	R	183	ESP	22.1492128679	102148	nan	Fabrice Santoro	R	178	FRA	34.8473648186	6-4 6-4	3	R64	79	7	1	56	38	29	11	10	1	2	4	2	59	30	19	16	10	3	6	26	1015	46	719
2007-1536	Madrid Masters	Hard	48	M	20071015	9	104339	nan	Mario Ancic	R	196	CRO	23.5427789185	102967	Q	Marc Gicquel	R	188	FRA	30.5434633812	6-4 6-2	3	R64	71	11		43	27	26	10	9			6	3	47	25	19	10	9	3	6	49	675	77	520
2007-1536	Madrid Masters	Hard	48	M	20071015	10	103908	nan	Paul Henri Mathieu	R	185	FRA	25.7549623546	103888	nan	Mardy Fish	R	188	USA	25.8480492813	6-3 2-6 7-5	3	R64	130	12	4	85	49	38	18	14	2	4	19	2	95	52	42	15	15	5	8	21	1335	38	775


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