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	winner_rank Winner Rank	winner_rank_points Winner Rank Points	loser_rank Loser Rank	loser_rank_points Loser Rank Points
2003-1536	Madrid Masters	Hard	48	M	20031013	1	101965	nan	Wayne Ferreira	R	185	RSA	32.076659822	103344	nan	Ivan Ljubicic	R	193	CRO	24.5694729637	7-6(7) 7-6(5)	3	R64	28	1090	42	865
2003-1536	Madrid Masters	Hard	48	M	20031013	2	102358	Q	Thomas Enqvist	R	190	SWE	29.5852156057	102338	nan	Yevgeny Kafelnikov	R	190	RUS	29.6481861739	6-3 RET	3	R64	146	258	40	950
2003-1536	Madrid Masters	Hard	48	M	20031013	3	102998	Q	Jan Michael Gambill	R	190	USA	26.3600273785	103786	nan	Nikolay Davydenko	R	178	RUS	22.3627652293	6-3 6-3	3	R64	57	660	43	855
2003-1536	Madrid Masters	Hard	48	M	20031013	4	102610	nan	Albert Costa	R	180	ESP	28.3011635866	103602	nan	Fernando Gonzalez	R	183	CHI	23.2060232717	6-3 7-6(3)	3	R64	23	1170	22	1190
2003-1536	Madrid Masters	Hard	48	M	20031013	5	102374	WC	Alex Corretja	R	180	ESP	29.5058179329	104745	WC	Rafael Nadal	L	185	ESP	17.3607118412	6-2 3-6 6-4	3	R64	127	290	49	788
2003-1536	Madrid Masters	Hard	48	M	20031013	6	103888	nan	Mardy Fish	R	188	USA	21.8425735797	102450	nan	Tim Henman	R	185	GBR	29.1006160164	7-6(4) 6-3	3	R64	25	1145	30	1055
2003-1536	Madrid Masters	Hard	48	M	20031013	7	103852	nan	Feliciano Lopez	L	188	ESP	22.0616016427	103151	nan	Mariano Zabaleta	R	183	ARG	25.620807666	6-2 3-6 6-3	3	R64	35	1025	27	1133
2003-1536	Madrid Masters	Hard	48	M	20031013	8	103292	nan	Gaston Gaudio	R	175	ARG	24.8432580424	103813	nan	Jarkko Nieminen	L	185	FIN	22.2231348392	3-6 7-5 6-2	3	R64	37	1000	31	1050
2003-1536	Madrid Masters	Hard	48	M	20031013	9	103970	Q	David Ferrer	R	175	ESP	21.53045859	104022	nan	Mikhail Youzhny	R	183	RUS	21.3004791239	1-6 6-4 6-4	3	R64	72	480	29	1060
2003-1536	Madrid Masters	Hard	48	M	20031013	10	102434	nan	Vincent Spadea	R	183	USA	29.234770705	103294	Q	Christophe Rochus	R	170	BEL	24.8268309377	6-4 7-5	3	R64	33	1040	87	421


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