JeffSackmann / tennis_wta

WTA Tennis Rankings, Results, and Stats
216 stars 144 forks source link

Missing dates of birth #24

Open JeffSackmann opened 3 years ago

JeffSackmann commented 3 years ago

Several of you have asked how you can help -- here's one idea.

A year or so ago, the ITF website stopped publishing exact player birthdates (DOBs). The ATP and WTA sites still do, but their data is incomplete, and many thousands of players in the ITF database do not appear in the ATP or WTA database at all. Usually new players appear in the ITF data first. Thus, many up and coming players do not have DOBs in this dataset.

Many of the missing DOBs are publicly available, on the ATP or WTA site, or Wikipedia, or any number of other sources.

  1. Finding players with missing DOBs:

    • Sort Tennis Abstract's complete list of ranked players by "birthdate" (click on the "birthdate" header), and missing DOBs will be at the top of the list: http://tennisabstract.com/reports/wtaRankings.html
    • or, open up one of the 'matches' files and look for players without age listed
    • (if you want to look for pre-Open Era players, great! however, be aware that I've done at least a cursory search for the DOB of every pre-1968 player. There is surely a lot more info out there, and I hope to include it all someday, but it will take some digging.)
  2. Finding DOBs:

    • just google their names.
    • do a quick 'sanity check' -- does the result you found make sense, given when the player played?
    • beware YYYY-01-01 (January 1st) birthdates -- there is at least one database site that publishes many missing dobs as YYYY-01-01. That doesn't mean that hundreds of players were born on the first of year. Double-check any January 1st DOBs from multiple sources.
  3. Submitting them to me:

    • preferably as text (in the body of a response to this issue) or as a CSV file (attached to a response in this thread) one player per row, including their player ID, e.g. 100001,Gardnar,Mulloy,R,19131122,USA (this is the format of the rows in the wta_players.csv file in this repo)

Two more things:

  1. If you find the handedness (lefty/righty) for players currently listed as 'U', I'd love to have that too.

  2. If you are looking for a player's DOB and discover that he/she has a wikipedia page, please include their wiki URL as well! I retain those as well (though they are not [yet] part of this repo) and show them on the Tennis Abstract site. For instance, 100001,Gardnar,Mulloy,R,19131122,USA,Gardnar_Mulloy or 100001,Gardnar,Mulloy,R,19131122,USA,https://en.wikipedia.org/wiki/Gardnar_Mulloy

Thanks in advance! If you have questions, please ask in this thread.

argentenista commented 3 years ago

222601,Jessica,Bouzas Maneiro,R,20020924,ESP 215840,Haley,Giavara,R,20001015,USA 222980,Lucie,Havlickova,R,20050313,CZE 222458,Pia,Lovric,R,20020423,SLO 222965,Erika,Andreeva,R,20040624,RUS 223333,Noma,Noha Akugue,R,20031202,GER 222016,Marta,Custic,R,20020209,ESP 222390,Ya Yi,Yang,L,20040530,TPE,https://en.wikipedia.org/wiki/Yang_Ya-yi 222299,Adriana,Reami,R,19971113,USA 222032,Gabriella,Price,R,20030611,USA 223164,Maria,Bondarenko,R,20030409,RUS 221996,Isabella,Kruger,R,20050330,RSA 222198,Emma,Davis,R,19970316,USA 222396,Matilde,Paoletti,R,20030304,ITA 220014,Safiya,Carrington,R,20010623,USA 222305,Romina,Ccuno,R,20020901,PER,https://en.wikipedia.org/wiki/Romina_Ccuno 222155,Ekaterina,Nikiforova,R,20020124,RUS 222989,Matilda,Mutavdzic,R,20040617,GBR 222919,Julia,Avdeeva,R,20020706,RUS 222045,Antonia,Ruzic,R,20030120,CRO 220258,Viktoriya,Petrenko,R,20010509,UKR 222156,Silvia,Ambrosio,R,19970124,GER 221985,Darja,Semenistaja,R,20020916,LAT 228909,Amelie,Van Impe,R,20040718,BEL 222223,Karina,Miller,R,20020315,USA 222037,Rachel,Gailis,R,20040830,USA 222393,Celia Belle,Mohr,R,20020427,FRA 222289,Sarah Maude,Fortin,R,20020519,CAN 221988,Bianca Jolie,Fernandez,R,20040224,CAN 222034,Reese,Brantmeier,R,20041005,USA 222705,Michaela,Kadleckova,R,20010411,SVK 222403,Jwany,Sherif,R,19960109,USA 222803,Ozlem,Uslu,R,20040311,TUR 222081,Eleana,Yu,R,20041108,USA 221376,Olivia,Gram,R,20001123,DEN 228910,Tilwith,Di Girolami,R,20030929,BEL 219995,Katsiaryna,Skachkova,R,19980419,BLR 222159,Katya,Townsend,R,20000528,USA 222599,Angelika,Shapovalova,R,19980612,RUS 222369,Arianna,Zucchini,R,20030710,ITA 222402,Madison,Appel,R,19970531,USA 222036,Zoe,Howard,R,20010619,USA 221950,Ines,Oliveira,R,20030606,POR 222703,Ioana,Zvonaru,R,20040106,ROU 222000,Maria Camila,Torres Murcia,L,20021110,COL

Thanks for this great database. Here is all the information you requested. Happy to help! The following information is duplicated but complete the DOB

223317,Barbora,Palicova,R,20040311,CZE 223323,Barbora,Palicova ,U,,CZE

JeffSackmann commented 3 years ago

wow, thanks @argentenista! I will get these updated in the next few days.

JeffSackmann commented 3 years ago

thanks again, @argentenista -- these are all now added to the database.

sbwrege2z commented 3 years ago

Women with rankings since 2000:

220259,Daria,Nazarkina,U,19990728,RUS
223120,Briana,Szabo,U,20051126,ROU
sbwrege2z commented 3 years ago

Women with rankings in the 1990's:

200287,Miki,Yokobori,U,19750513,JPN
203824,Tonia,Bayley,U,19740923,AUS
JeffSackmann commented 3 years ago

thanks! these are now added.

GarlickWitch commented 3 years ago

A few more that have turned up over the spring

214741,Anastasia,Kulikova,U,20000215,RUS changed nation to FIN, source billiejeankingcup dot com /en/players/player.aspx?id=800367920

214741,Anastasia,Kulikova,L,20000215,FIN,Anastasia_Kulikova

221012,Qinwen,Zheng,R,20021008,CHN,Zheng_Qinwen
222669,Patricija,Spaka,L,20020829,LAT,Patrīcija_Špaka
222276,Jasmijn,Gimbrere,R,20010306,NED
222171,Nahia,Berecoechea,R,20040423,FRA
JeffSackmann commented 3 years ago

thanks @GarlickWitch !

andreakropp commented 2 years ago

Looked up the height for these 74 recently active WTA players. Also changed two of them from U to R for handedness.

player_id,name_first,name_last,hand,dob,ioc,height,wikidata_id 201516,Evgeniya,Rodina,R,19890204,RUS,170,Q258950 201529,Kristie,Ahn,R,19920615,USA,165,Q3104444 201534,Asia,Muhammed,R,19910404,USA,178,Q4806395 201582,Jing Jing,Lu,R,19890505,CHN,170,Q3487333 201604,Irina,Falconi,R,19900504,USA,163,Q53418 201618,Fatma,Al Nabhani,R,19910520,OMA,170,Q5437905 201631,Nicha,Lertpitaksinchai,R,19910814,THA,174,Q13512783 201652,Ksenia,Palkina,R,19891213,KGZ,174,Q946098 201667,Ling,Zhang,R,19891028,HKG,178,Q8070270 201679,Varatchaya,Wongteanchai,R,19890907,THA,169,Q4124897 201683,Bianca,Botto,L,19910606,PER,178,Q3948619 201697,Kristyna,Pliskova,L,19920321,CZE,184,Q289295 201699,Martina,Caregaro,R,19920519,ITA,165,Q20007827 201703,Yi Fan,Xu,L,19880808,CHN,165,Q4845400 202379,Chieh Yu,Hsu,L,19920114,USA,170,Q15055721 202410,Sofia,Shapatava,R,19890112,GEO,170,Q1753608 202424,Conny,Perrin,R,19901225,SUI,174,Q5162081 202425,Samantha,Murray,R,19871009,GBR,178,Q12193601 202426,Julia,Boserup,R,19910909,USA,181,Q4992442 202430,Alize,Lim,R,19900713,FRA,173,Q1942172 202436,Reka Luca,Jani,R,19910731,HUN,161,Q772600 202443,Valeria,Savinykh,R,19910220,RUS,167,Q440162 202467,Elitsa,Kostova,R,19900410,BUL,172,Q3657210 202479,Grace,Min,R,19940506,USA,163,Q54542 202484,Nicole,Gibbs,R,19930303,USA,168,Q53548 202488,Valentyna,Ivakhnenko,R,19930627,UKR,163,Q7911074 202489,Carina,Witthoeft,R,19950216,GER,176,Q6757157 202491,Varvara,Flink,R,19961213,RUS,175,Q13512756 202496,Samantha,Crawford,R,19950218,USA,188,Q53398 202497,Victoria,Duval,R,19951130,USA,178,Q53414 202502,So Ra,Lee,L,19940722,KOR,172,Q16224631 202504,Ying Ying,Duan,R,19890603,CHN,186,Q4706382 202508,Yuxuan,Zhang,R,19940819,CHN,179,Q2908103 202536,Ana,Bogdan,R,19921125,ROU,171,Q3614850 202539,Alison,Bai,R,19900118,AUS,170,Q4727012 202578,Laura Ioana,Andrei,R,19880531,ROU,173,Q12052895 202579,Giulia,Gatto Monticone,R,19871118,ITA,177,Q3769266 202600,Viktoriya,Tomova,R,19950225,BUL,170,Q10996110 202604,Despina,Papamichail,R,19930209,GRE,178,Q13512708 202614,Jacqueline,Cako,R,19910830,USA,178,Q6453895 202622,Lyudmyla,Kichenok,R,19920720,UKR,175,Q4222570 202628,Maryna,Zanevska,R,19930824,UKR,175,Q2626886 202672,Ekaterina,Yashina,R,19930806,RUS,173,Q5350350 202684,Lin,Zhu,R,19940128,CHN,173,Q17319111 202685,Misa,Eguchi,R,19920418,JPN,173,Q15700787 202693,Ya Hsuan,Lee,R,19950720,TPE,165,Q18637630 202695,Aleksandrina,Naydenova,R,19920229,BUL,170,Q4715613 202707,Myrtille,Georges,R,19901221,FRA,174,Q6948568 202900,Maria Fernanda,Alvarez Teran,R,19890228,BOL,174,Q3292179 202916,Georgina,Garcia Perez,U,19920513,ESP,187,Q21402261 202919,Chang,Liu,R,19900801,CHN,160,Q16219267 202921,Shiho,Akita,R,19900118,JPN,155,Q23661790 203281,Amandine,Hesse,R,19930116,FRA,164,Q1394777 203288,Jia Jing,Lu,R,19891118,CHN,173,Q17281094 203297,Nadiya,Kichenok,R,19920720,UKR,172,Q4222571 203315,Alexa,Guarachi,R,19901117,USA,173,Q21045631 203325,Martina,Di Giuseppe,R,19910210,ITA,,Q53855558 203379,Marina,Melnikova,R,19890205,RUS,173,Q6452511 203398,Danielle,Lao,R,19910528,USA,160,Q18044538 203435,Dalila,Jakupovic,R,19910324,SLO,178,Q15830617 203500,Sachia,Vickery,R,19950511,USA,162,Q14646554 203504,Miyu,Kato,R,19941121,JPN,156,Q20982979 203513,Robin,Anderson,R,19930412,USA,160,Q23059598 203521,Andrea,Gamiz,R,19921031,VEN,162,Q4755117 203552,Risa,Ozaki,R,19940410,JPN,163,Q14616346 203553,Riko,Sawayanagi,R,19941025,JPN,163,Q7334091 203562,Erin,Routliffe,R,19950411,CAN,188,Q20895299 203564,Chloe,Paquet,R,19940701,FRA,179,Q16956915 203576,Kai Lin,Zhang,R,19900128,CHN,173,Q16742868 203578,Fangzhou,Liu,R,19951212,CHN,180,Q15491968 203584,Adriana,Perez,R,19921120,VEN,163,Q4685520 203591,Katy,Dunne,R,19950216,GBR,167,Q17157004 204223,Peangtarn,Plipuech,U,19921115,THA,169,Q7157914

gregakabibi commented 2 years ago

Here are the missing DOB for all the missing currently ranked players, see specific comments for two of them

(sources are mostly national federation ranking pages and espn)

259799,Mirra,Andreeva,U,20070429,RUS,, 259967,Sayaka,Ishii,U,20050831,JPN,, 222290,Lanlana,Tararudee,U,20040707,THA,, 222866,Katherine,Hui,U,20050129,USA,, 222967,Kristyna,Tomajkova,U,20050328,CZE,, 222886,Sabina,Zeynalova,U,20040217,UKR,, 260091,Heerae,Im,U,20040207,KOR,, 222351,Gala,Arangio,U,20050603,MEX,, 222893,Melisa,Senli,U,20041202,TUR,, 222161,Prathyusha,Rachapudi,R,20010217,IND,, 222908,Jordina,Cegarra Ramirez,U,20040503,ESP,,

259845,Ecaterina,Visnevscaia,U,19991127,MDA,, => Is a duplicate of 216299,Ekaterina,Vishnevskaya,R,19991127,RUS,, (recently changed nationality and therefore spelling of her name due to different alphabets)

260090,Han,Hyeongju,U,20030217,KOR,, However ITF has her name wrong for the pro (they have it correct for her junior page), korean name can never be spelled that way, Han should be the family name,- her name is correct on the Korean tennis federation page rankings here : http://kortennis.co.kr/data_download/2014/kta_ws.pdf - Line 80) => Correct should be 260090,Hyeongju,Han,U,20030217,KOR,,