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
2014-339	Brisbane	Hard	28	A	20131229	1	103813		nan	Jarkko Nieminen	L	185	FIN	32.4380561259	105902		WC	James Duckworth	R	183	AUS	21.9411362081	6-2 6-3	3	R32	72	5	3	71	54	36	9	9	5	5	9	7	51	29	23	6	8	2	5	39	1090	136	425
2014-339	Brisbane	Hard	28	A	20131229	2	104594		nan	Marinko Matosevic	R	194	AUS	28.3942505133	103898		nan	Julien Benneteau	R	185	FRA	32.0273785079	5-7 6-4 7-6(4)	3	R32	161	11	3	112	68	43	26	17	5	9	14	1	117	76	51	18	17	7	11	61	774	35	1160
2014-339	Brisbane	Hard	28	A	20131229	3	105023		nan	Sam Querrey	R	198	USA	26.2313483915	104098	7	nan	Dmitry Tursunov	R	185	RUS	31.0499657769	7-5 6-4	3	R32	77	18	1	58	40	36	7	11	2	3	4		63	40	26	12	11	6	9	46	960	29	1244
2014-339	Brisbane	Hard	28	A	20131229	4	105032		WC	Sam Groth	R	193	AUS	26.1984941821	105992		Q	Ryan Harrison	R	183	USA	21.6481861739	7-6(3) 7-6(2)	3	R32	95	23	2	70	51	46	10	12	1	1	5	4	86	59	43	15	12	4	4	172	307	100	549
2014-339	Brisbane	Hard	28	A	20131229	5	103917		nan	Nicolas Mahut	R	190	FRA	31.9397672827	104997		nan	Igor Sijsling	R	190	NED	26.3682409309	3-6 6-4 6-4	3	R32	107	15	4	100	59	46	18	15	4	6	13	2	78	50	43	12	14	2	4	50	918	70	697
2014-339	Brisbane	Hard	28	A	20131229	6	104871	8	nan	Jeremy Chardy	R	188	FRA	26.8802190281	105173		nan	Adrian Mannarino	L	183	FRA	25.5030800821	7-6(4) 7-5	3	R32	109	10	2	76	50	34	15	12	4	7	4	3	88	54	31	17	12	5	9	34	1175	59	784
2014-339	Brisbane	Hard	28	A	20131229	7	103852	6	nan	Feliciano Lopez	L	188	ESP	32.2765229295	105062		nan	Mikhail Kukushkin	R	183	KAZ	26.0123203285	6-4 6-4	3	R32	75	13	3	55	30	24	14	10	1	3	4	2	58	28	12	19	10	2	6	28	1310	67	721
2014-339	Brisbane	Hard	28	A	20131229	8	103720		nan	Lleyton Hewitt	R	180	AUS	32.8459958932	106423		Q	Thanasi Kokkinakis	R	196	AUS	17.7221081451	6-3 7-5	3	R32	101	4	1	62	32	27	16	10	3	4	8	5	76	45	29	15	11	11	15	60	780	628	41
2014-339	Brisbane	Hard	28	A	20131229	9	105657		Q	Marius Copil	R	193	ROU	23.2032854209	105216		Q	Yuichi Sugita	R	173	JPN	25.2813141684	7-6(5) 6-7(2) 7-6(7)	3	R32	174	31	2	128	75	66	27	18	2	2	4	1	126	90	71	22	18	8	8	147	369	170	310
2014-339	Brisbane	Hard	28	A	20131229	10	105777	5	nan	Grigor Dimitrov	R	188	BUL	22.6255989049	104898		nan	Robin Haase	R	190	NED	26.7351129363	6-2 6-3	3	R32	58	6	1	43	23	21	15	9			2	1	56	39	24	8	8	5	8	23	1520	43	977


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