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
2010-339	Brisbane	Hard	32	A	20100103	1	104053	1	nan	Andy Roddick	R	188	USA	27.3483915127	103429		nan	Peter Luczak	R	183	AUS	30.3463381246	7-6(5) 6-2	3	R32	84	15		63	42	36	14	10	3	3	4	2	56	34	29	11	10	3	5	7	4410	77	598
2010-339	Brisbane	Hard	32	A	20100103	2	104958		WC	Carsten Ball	L	198	AUS	22.5434633812	104999		nan	Mischa Zverev	L	190	GER	22.3709787817	7-5 6-1	3	R32	70	10	3	57	30	23	19	10			2	2	66	34	22	14	9	7	10	134	400	78	590
2010-339	Brisbane	Hard	32	A	20100103	3	104755		nan	Richard Gasquet	R	185	FRA	23.5482546201	103813		nan	Jarkko Nieminen	L	185	FIN	28.4517453799	6-3 4-6 6-4	3	R32	121	5	4	97	51	33	27	15	5	8	4		85	58	38	14	14	7	11	52	850	88	568
2010-339	Brisbane	Hard	32	A	20100103	4	105051		Q	Matthew Ebden	R	188	AUS	22.1081451061	103781	6	nan	Jurgen Melzer	L	183	AUT	28.6214921287	7-5 6-1	3	R32	64	12	1	50	35	30	12	10	3	3	2	1	53	29	16	15	9	2	5	285	151	28	1260
2010-339	Brisbane	Hard	32	A	20100103	5	104607	4	nan	Tomas Berdych	R	196	CZE	24.2984257358	105194		Q	Nick Lindahl	R	183	AUS	21.4291581109	6-2 6-4	3	R32	69	3	1	46	27	24	14	9	1	1	6	1	69	41	26	14	9	6	9	20	1655	251	179
2010-339	Brisbane	Hard	32	A	20100103	6	104571		nan	Marcos Baghdatis	R	183	CYP	24.5503080082	103888		nan	Mardy Fish	R	188	USA	28.0711841205	7-5 7-5	3	R32	101	7	5	62	32	27	17	12		1	7	3	77	36	28	20	12	3	6	42	945	55	790
2010-339	Brisbane	Hard	32	A	20100103	7	103248		nan	Harel Levy	R	185	ISR	31.4168377823	103566		nan	Michael Llodra	L	190	FRA	29.6317590691	6-2 6-0	3	R32	41	8		35	23	18	10	7					46	36	17	3	7	5	10	119	461	67	649
2010-339	Brisbane	Hard	32	A	20100103	8	105064	8	nan	Thomaz Bellucci	L	188	BRA	22.0150581793	103428		nan	Juan Ignacio Chela	R	190	ARG	30.3490759754	6-3 3-6 6-1	3	R32	105	12	4	87	58	37	14	13	6	10	1	1	71	38	20	17	12	2	8	36	1021	73	611
2010-339	Brisbane	Hard	32	A	20100103	9	103484		nan	James Blake	R	185	USA	30.0205338809	105023	5	nan	Sam Querrey	R	198	USA	22.2450376454	4-6 6-3 6-4	3	R32	88	10	3	86	47	40	24	15	2	3	9	3	85	52	41	16	14	3	5	44	935	25	1320
2010-339	Brisbane	Hard	32	A	20100103	10	102967		nan	Marc Gicquel	R	188	FRA	32.7665982204	104332		nan	Philipp Petzschner	R	185	GER	25.7823408624	6-3 6-1	3	R32	50	4	1	38	27	25	8	8			4	2	46	21	15	10	8	1	5	58	744	80	587


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