-6

A. Background:

Under Mobeus Zoom's suggestion here: List of records for youngest superGMs since 1950? (or 1970 or whenever FIDE started rating people. or basically after 2700s after Fischer) (this is about reaching specific ratings though rather than attaining a specific title) re variations for List of youngest grandmasters since 1950, I am now asking how to go about answering these types of questions:

List of records for youngest international masters since 1950?

List of records for youngest female international masters since 1950?

List of records for youngest WIMs (woman international masters) since 1950?


B. Questions:

  1. From what site can I download some kind of spreadsheet with this kind of data?

player X - date of birth - date IM title obtained (if any) - (among other such data)

  • Update 1: Given so far: https://ratings.fide.com/download_lists.phtml

  • i'm able to extract all females, all WFM, female IM, WGM, female CM, etc but where is date title obtained please? so far i think all i can do is pick who is youngest currently but not youngest in records

  • i don't think it has everything i was looking for. for the title part i think it shows their highest title soooo a female/male GM could've had the record for youngest female/IM but i wouldn't even know that this female/GM got IM before GM and even if e did, i wouldn't necessarily know when the female/GM became an IM.

  • Update 2: Damn it Mobeus Zoom https://ratings.fide.com/download_lists.phtml is different from https://ratings.fide.com/download.phtml ! lol

  1. Then is the ff the right procedure/algorithm assuming I obtain such data?

A - Let column 4 be the subtraction of column 2 from column 3.

B - Sort by column 3.

C - Let column 5 check if corresponding entry in column 4 is minimum among all the column 4 entries up to it

5
  • 1
    Comments are not for extended discussion; this conversation has been moved to chat.
    – Brian Towers
    Sep 19 at 17:05
  • 1
    I'm in favour of keeping this post open (it's a teach a man to fish post); it's best to leave the other ones for Roomba and not try to 'improve' them anymore. The Community has made clear they don't like that kind of questions and reacts badly on superfluous bumps and meta-information in questions. If you disagree, it's best to take it to Chess Meta.
    – Glorfindel
    Oct 16 at 6:33
  • ok fine Roomba it is. thank you for both your honesty and empathy @Glorfindel
    – BCLC
    Oct 16 at 8:28
  • @Glorfindel i don't see why i have to learn to fish though. i'd think FIDE or someone else would be interested in these kind of statistics. i was actually thinking initially that all these statistics were already readily available. after all they were even saying about how alekhine nouri was youngest FM, Abhimanyu Mishra was youngest IM and then youngest GM, Wei Yi was youngest superGM, etc. so surely they must've known the youngest before them and so on. i of course expect to have to learn to fish if i wanted to be specific like youngest female Philippine-German WIM. am i wrong?
    – BCLC
    Oct 16 at 8:30
1
+50

A rather half-fledged answer but here goes:

Check out https://ratings.fide.com/download.phtml. Download the data files for each month from the archive and parse them into a single database or dataframe. If interested in Rapid and Blitz ratings, these have to be downloaded separately from Standard (= classical). Each month's data contains , <player_ID>, <D.o.b.>, , . It should be clear that refers to the player's highest title achieved by that month. e.g. in Jan 2003 Carlsen's is 'f' = FM because his highest title by Jan 2003 was FM; but check Jan 2005 and his is 'g' = GM because by Jan 2005 he had achieved GM title. Hence, if you parse each month from Jan 2003 to Jan 2005, you can easily query for the first month in which Carlsen was an IM ('the month he received IM title') and the first in which he was a GM ('the month he received GM title').

If you put in the work to parse the separate data files into a single dataframe/database, open-source it and if necessary you can then ask what queries to use for the results you want. Suggesting these queries would be unreasonable before the data source has been prepared.

Your results will be limited in precision of course by the frequency with which the data was published and in scope by the oldest ratings lists made available (2001+). There may be someone with a more complete database for this sort of thing (e.g., try asking at 2700chess.com).

Edits:

Further data sources I found:

https://www.mark-weeks.com/chess/ratings/ - the annual FIDE ratings lists 1975 to 2000 including titles

Try reaching out to:

https://www.reddit.com/r/chess/comments/em03o4/fide_chess_data/ Reddit user 'AnujDahiya24' seemed to compile all available data 2 years ago but his Github repository seems to be deleted

https://core.ac.uk/download/pdf/205518195.pdf the writer of this paper prepared a Microsoft Access database with the available FIDE data to 2000, but the database is no longer available

2700chess - the maintainer of this website presumably has compiled all historical FIDE data into his database.

7
  • Mobeus Zoom, (not so?) quick question: i don't see why i have to learn to fish though. i'd think FIDE or someone else would be interested in these kind of statistics. i was actually thinking initially that all these statistics were already readily available. after all they were even saying about how alekhine nouri was youngest FM, Abhimanyu Mishra was youngest IM and then youngest GM, Wei Yi was youngest superGM, etc. so surely they must've known the youngest before them and so on...
    – BCLC
    Oct 16 at 8:34
  • ... i of course expect to have to learn to fish if i wanted to be specific like youngest female Philippine-German WIM. am i wrong?
    – BCLC
    Oct 16 at 8:34
  • "i was actually thinking initially that all these statistics were already readily available." Clearly you were mistaken. ChessBase and other news sites likely have these databases and used them to establish records, but without making the whole lists available. I already told you to approach them directly. Oct 17 at 15:52
  • Mobeus Zoom: well i did e-mail fide, but they didn't reply yet. and i don't think the issue is about mistaken or not at least for my last comment. do you think it's unreasonable to expect like hey maybe since there's a list of youngest ever grandmasters, there's also a list of youngest ever for the other titles? ESP considering that there are various articles that claim stuff re alekhine nouri (FM), Wei Yi (superGM), Abhimanyu Mishra (for IM), etc?
    – BCLC
    Oct 17 at 15:57
  • 1
    I don't see that I recommended contacting FIDE. Doesn't seem much point in keeping this up with me if you don't follow my recommendations Oct 17 at 15:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.