Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Missing dates of birth #24

Open
JeffSackmann opened this issue Jan 17, 2021 · 10 comments
Open

Missing dates of birth #24

JeffSackmann opened this issue Jan 17, 2021 · 10 comments

Comments

@JeffSackmann
Copy link
Owner

JeffSackmann commented Jan 17, 2021

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.)
  1. 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.
  1. 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
Copy link

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
Copy link
Owner Author

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

JeffSackmann added a commit that referenced this issue Feb 3, 2021
thanks to @argentenista in issue #24 and @GarlickWitch in the tennis_atp issue thread!
@JeffSackmann
Copy link
Owner Author

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

@sbwrege2z
Copy link
Contributor

sbwrege2z commented Feb 8, 2021

Women with rankings since 2000:

220259,Daria,Nazarkina,U,19990728,RUS
223120,Briana,Szabo,U,20051126,ROU

@sbwrege2z
Copy link
Contributor

sbwrege2z commented Feb 8, 2021

Women with rankings in the 1990's:

200287,Miki,Yokobori,U,19750513,JPN
203824,Tonia,Bayley,U,19740923,AUS

JeffSackmann added a commit that referenced this issue Feb 9, 2021
thanks @sbwrege2z for birthdates added per isssue #24
@JeffSackmann
Copy link
Owner Author

thanks! these are now added.

@GarlickWitch
Copy link

GarlickWitch commented Jun 23, 2021

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 added a commit that referenced this issue Jun 25, 2021
per latest @GarlickWitch comment in #24 ... also more trailing space and country code corrections.
@JeffSackmann
Copy link
Owner Author

thanks @GarlickWitch !

JeffSackmann added a commit that referenced this issue Oct 10, 2021
via wikidata, per #24
@andreakropp
Copy link

andreakropp commented Jan 20, 2022

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

JeffSackmann added a commit that referenced this issue Jan 20, 2022
@gregakabibi
Copy link

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,,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

6 participants