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
2001-301	Auckland	Hard	32	A	20010108	1	102905		nan	Stefan Koubek	L	175	AUT	24.0164271047	102644	1	nan	Franco Squillari	L	183	ARG	25.3826146475	7-6(4) 6-2	3	R32	84	5	2	93	58	38	17	10	14	16	5	5	66	31	19	15	10	4	8	52	755	14	1598
2001-301	Auckland	Hard	32	A	20010108	2	102231		nan	Alex Calatrava	R	190	ESP	27.5701574264	102860		nan	Agustin Calleri	R	183	ARG	24.3175906913	6-3 1-6 6-3	3	R32	78	6	2	74	47	36	14	13		2	14	3	63	37	33	11	12	1	3	53	751	64	633
2001-301	Auckland	Hard	32	A	20010108	3	102257		WC	Greg Rusedski	L	193	GBR	27.3401779603	103066		WC	Mark Nielsen	R	185	NZL	23.2525667351	6-4 6-4	3	R32	87	15	5	64	36	29	17	10	4	4	1	5	72	45	31	12	10	4	6	73	575	260	129
2001-301	Auckland	Hard	32	A	20010108	4	101647	5	nan	Byron Black	R	175	ZIM	31.2580424367	102287		nan	Albert Portas	R	188	ESP	27.1485284052	2-6 6-2 6-4	3	R32	81	1	1	72	52	34	11	13	2	5	15		69	35	31	11	13	3	7	35	965	49	760
2001-301	Auckland	Hard	32	A	20010108	5	102998	3	nan	Jan Michael Gambill	R	190	USA	23.6002737851	103454		nan	Nicolas Massu	R	183	CHI	21.2484599589	7-6(4) 6-4	3	R32	103	15	5	67	33	27	14	11	1	4	8	6	81	40	27	15	11	5	9	33	1030	67	601
2001-301	Auckland	Hard	32	A	20010108	6	103714		nan	Andreas Vinciguerra	L	180	SWE	19.8850102669	103248		nan	Harel Levy	R	185	ISR	22.4284736482	6-3 6-4	3	R32	68	3	2	57	37	31	12	10			3	1	66	42	30	9	9	5	7	50	760	59	677
2001-301	Auckland	Hard	32	A	20010108	7	101532		nan	Francisco Clavet	L	183	ESP	32.2080766598	103428		nan	Juan Ignacio Chela	R	190	ARG	21.3607118412	6-3 4-6 6-3	3	R32	99	1	1	87	53	36	23	14	1	2	2	3	82	41	30	24	14	4	7	47	795	65	632
2001-301	Auckland	Hard	32	A	20010108	8	103188		Q	Michael Russell	R	173	USA	22.6913073238	102950	8	nan	Fernando Vicente	R	180	ESP	23.8384668036	6-2 6-2	3	R32	58	5	1	40	34	28	4	8			3	1	50	28	19	6	8	1	5	154	250	42	860
2001-301	Auckland	Hard	32	A	20010108	9	103324		nan	Arnaud Di Pasquale	R	185	FRA	21.9082819986	102701	6	nan	Marcelo Rios	L	175	CHI	25.0376454483	3-6 6-1 7-6(2)	3	R32	108	5	10	87	52	34	12	14	3	10	2	6	90	56	30	12	14	3	11	61	670	23	1160
2001-301	Auckland	Hard	32	A	20010108	10	102785		Q	Glenn Weiner	R	188	USA	24.7008898015	103694		nan	Olivier Rochus	R	168	BEL	19.9726214921	4-6 6-3 6-3	3	R32	95	18	5	82	53	44	13	14	1	2	1	3	83	44	32	23	14	7	10	277	118	71	582


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