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
2012-339	Brisbane	Hard	32	A	20120101	1	104918	1	nan	Andy Murray	R	190	GBR	24.6351813826	105062		nan	Mikhail Kukushkin	R	183	KAZ	24.0191649555	5-7 6-3 6-2	3	R32	130	10		92	57	41	17	15	4	7	4	3	77	41	29	15	14	4	9	4	7380	91	598
2012-339	Brisbane	Hard	32	A	20120101	2	104180		nan	Gilles Muller	L	193	LUX	28.6516084873	103672		nan	Ricardo Mello	L	175	BRA	31.0308008214	6-7(3) 7-6(4) 6-3	3	R32	136	23	1	104	55	47	31	17	3	3	3	5	103	67	54	20	16	1	2	54	893	85	630
2012-339	Brisbane	Hard	32	A	20120101	3	104571		nan	Marcos Baghdatis	R	183	CYP	26.5434633812	105992		nan	Ryan Harrison	R	183	USA	19.6550308008	7-6(7) 6-4	3	R32	101	8	3	71	31	26	26	11	5	6	14	1	79	48	36	17	11	2	4	44	940	79	658
2012-339	Brisbane	Hard	32	A	20120101	4	105453	5	nan	Kei Nishikori	R	178	JPN	22.0095824778	105649		nan	Cedrik Marcel Stebe	L	183	GER	21.2320328542	3-6 6-1 6-4	3	R32	130	1	2	75	49	31	16	13	3	6	4	2	90	49	27	23	13	9	14	25	1430	81	652
2012-339	Brisbane	Hard	32	A	20120101	5	104797		nan	Denis Istomin	R	188	UZB	25.3196440794	104252	4	nan	Florian Mayer	R	190	GER	28.2436687201	7-6(5) 2-3 RET	3	R32	69	10	1	56	28	23	18	8	2	2	2	1	55	38	28	11	9			73	685	23	1630
2012-339	Brisbane	Hard	32	A	20120101	6	103163		nan	Tommy Haas	R	188	GER	33.749486653	104594		WC	Marinko Matosevic	R	194	AUS	26.4010951403	6-3 7-5	3	R32	99	4	2	66	40	32	14	11	6	7	4	2	77	45	28	15	10	10	13	205	237	203	240
2012-339	Brisbane	Hard	32	A	20120101	7	105147		Q	Tatsuma Ito	R	180	JPN	23.6249144422	106093		WC	Benjamin Mitchell	R		AUS	19.0882956879	6-4 6-2	3	R32	70	6		52	30	24	15	9	2	2	11	6	68	44	30	7	9	8	11	122	474	227	214
2012-339	Brisbane	Hard	32	A	20120101	8	106071	8	nan	Bernard Tomic	R	193	AUS	19.1978097194	103898		nan	Julien Benneteau	R	185	FRA	30.0342231348	6-2 4-6 7-5	3	R32	147	7	2	92	53	36	23	15	4	7	14	12	121	71	48	19	15	16	21	42	970	52	900
2012-339	Brisbane	Hard	32	A	20120101	9	103285	6	nan	Radek Stepanek	R	185	CZE	33.0978781656	105051		nan	Matthew Ebden	R	188	AUS	24.1013004791	6-4 3-6 6-3	3	R32	132	8	4	91	51	38	22	14	3	4	5	3	99	64	43	19	14	10	12	28	1275	86	627
2012-339	Brisbane	Hard	32	A	20120101	10	103813		nan	Jarkko Nieminen	L	185	FIN	30.4449007529	105028		Q	Jesse Levine	L	175	CAN	24.2162902122	7-6(4) 6-2	3	R32	101	3		71	53	32	10	10	6	9	3	6	90	63	36	10	10	9	14	77	666	164	308


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