JeffSackmann / tennis_atp

ATP Tennis Rankings, Results, and Stats
1.01k stars 608 forks source link

Missing matches #195

Open Mick1303 opened 2 years ago

Mick1303 commented 2 years ago

Up to this point I was looking for missing records in my database in comparison with yours. Or to put it another way - extra records in your database. But decided to vary activity a little bit, because it is getting repetitive and I'm losing focus. Made a query that looks the other way - extra records in my database, i.e missing in yours:

In Atlanta 2019 you are missing R32 match between Ugo Humbert and Colton Gromley. Check https://www.atptour.com/en/scores/archive/atlanta/6116/2019/results.

In Kitzbuehel 1996 you're missing 3 matches of Nicolas Kiefer: R64, R32 and QF, while Marcelo Rios - Markus Hipfl match is duplicated. https://www.atptour.com/en/scores/archive/kitzbuhel/319/1996/results

More to follow...

Mick1303 commented 2 years ago

In Indian Wells 1996 you're missing R64 match Sjeng Schalken ,NED,Nicolas Lapentti ,ECU,R64,7-6(4) 6-3

Mick1303 commented 2 years ago

In 1985 Tel Aviv (tid 1985-330) you have one R32 match missing: Year,Winner,wid,Loser,lid,Round,Score 1985,Florin Segarceanu,100730,Juan Antonio Rodriguez,100826,R32,7-6 1-6 6-4

Mick1303 commented 2 years ago

Albany (1972-424). 3rd place match between Pattison and Hewitt is missing

Mick1303 commented 2 years ago

You may want to re-import Manila 73. They updated the draw and have names rather than Unknowns in R32 - all 8 matches that are not byes. https://www.atptour.com/en/scores/archive/manila/362/1973/results

Mick1303 commented 2 years ago

Davis Cup G2 PO: GHA vs GEO (2005-D063). One match is missing Irakli Labadze,Henry Adjei-Darko, 6-4 6-3 6-1

JeffSackmann commented 2 years ago

thanks! all added up to this point.

Mick1303 commented 2 years ago

You may want to re-import Kitzbuehel 1970 - https://www.atptour.com/en/scores/archive/kitzbuhel/319/1970/results. Many Unknowns are fixed there.

While importing the results do not repeat ATP error with Peter/Petar Popovic. Latter born in 1982.

Mick1303 commented 2 years ago

You may want to re-import Bastad 71 (tid 1971-316). All Unknowns have names in ATP draw - https://www.atptour.com/en/scores/archive/bastad/316/1971/results

JeffSackmann commented 2 years ago

thank you -- both now added.

Mick1303 commented 2 years ago

In Munich 70 (1970-308): U Unknown, who lost to Bob Hewitt in R16 by w/o, is Terry Ryan https://www.atptour.com/en/scores/archive/munich/308/1970/results There are also 4 other R32 matches missing.

Manchester 70 (1970-8025) you have only through QF. ATP has 64-men draw (https://www.atptour.com/en/scores/archive/manchester/8025/1970/results). Also they have John Paish losing QF to Gorman rather than Geoffrey.

For Washington 1970 (1970-418) tennisarchives has slightly more complete draw (https://www.tennisarchives.com/edition/?v=17472) than ATP. They have few R128 macthes.

St Petersburg (Fl) - tid 1970-6818 needs to be re-imported from https://www.atptour.com/en/scores/archive/st-petersburg/6818/1970/results. They have many earlier round results.

JeffSackmann commented 2 years ago

all added, thanks

Mick1303 commented 2 years ago

Couple of R64 matches are missing in Salisbury 70 (tid 1970-355): Winner,Loser,Round,Score Gerald Battrick ,Jaime Fillol-sr ,R64,6-3 6-1 Ilie Nastase,Hans-Joachim Ploetz,R64,6-1 4-6 7-5 https://www.atptour.com/en/scores/archive/salisbury/355/1970/results

Mick1303 commented 2 years ago

Paris 71 (1971-2010) is missing 4 R32 matches (3 walkovers and one win by Orantes). See https://www.atptour.com/en/scores/archive/paris/2010/1971/results

Mick1303 commented 2 years ago

In Hobart 69 (tid 1969-713) you have Roche beating Brendan O'Shea in R32. But both ATP (https://www.atptour.com/en/scores/archive/hobart/713/1969/results) and TA (https://www.tennisarchives.com/edition/?v=4242) have Ray Ruffels beating Brendan O'Shea and Roche beating Kevin Keele. Overall you want to re-import this draw - you have many matches missing.

Mick1303 commented 2 years ago

Kitzbuehel 68 has updated draw on ATP site - https://www.atptour.com/en/scores/archive/kitzbuhel/319/1968/results. Many Unknowns are clarified.

Mick1303 commented 1 year ago

For some reason Cleveland 1983 tournament (won by Marty Davis) is removed from the links of 1983 tournaments on ATP 1983 page. And you don't have it listed. But ATP site still has these results (https://www.atptour.com/en/scores/archive/cleveland/320/1983/results?matchType=singles)

JeffSackmann commented 1 year ago

thanks! up to date on this thread again.

Mick1303 commented 1 year ago

Recent Manama Challenger (tid 2023-9635) misses R32 match Daniel Michalski-Yusuf Qaed 6-1,6-3

Mick1303 commented 1 year ago

Recent RomeG Challenger (tid 2023-2781) misses R32 match Seong-chan Hong-Gabriele Brancatelli 6-1,6-3

Mick1303 commented 1 year ago

According to wiki, Kitzbuehel 1971 Final ended w/o conclusion rather than Graebner retiring. ATP is contradicting itself putting Graebner as a winner. They did not list final result at all. But they do list 3rd place match that both you and me were missing.

Mick1303 commented 1 year ago

Davis Cup SAM SF: CHI vs URU (tid 1977-D015) has Fillol-Hugo Roverano and Fillol-Jose Luis Damiani matches missing. See https://www.daviscup.com/en/draws-results/tie.aspx?id=M-DC-1978-SAM-M-CHI-URU-01

Mick1303 commented 1 year ago

Davis Cup EUR PR: NED vs ISR (tid 1976-D040) has Hemmes-Shlomo Glickstein and Hemmes-Meir Wertheimer matches missing. See https://www.daviscup.com/en/draws-results/tie.aspx?id=M-DC-1977-EUR-B-PR-NED-ISR-01

Mick1303 commented 1 year ago

Davis Cup EUR PR: BEL vs NED (tid 1975-D010) has Hombergen-Hemmes match missing. See https://www.daviscup.com/en/draws-results/tie.aspx?id=M-DC-1976-EUR-A-PR-BEL-NED-01

Mick1303 commented 1 year ago

Davis Cup G1 QF: JPN vs INA (tid 1973-D039): 2 matches are missing Kato-Sangitan 6-3,8-6,6-3 and Hirai-Hadiman 6-4,6-4,7-5

Mick1303 commented 1 year ago

ATP is missing R32 match in 1981 Wembley between Birner and Gunthardt. ITF has Birner winning 7-6,6-2