How do I find data to determine records like the youngest person to obtain a certain title?

Question

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

2. 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

Answer 1

I am the Reddit user, 'AnujDahiya24' mentioned by the user, Mobeus Zoom, in his/her answer above. I wanted to add onto it a bit.

1. Emailing FIDE is indeed useless since they will not respond back: they didn't respond back to me when I sent them a couple of emails years ago.

2. FIDE/Chessbase aren't data savvy surprisingly when it comes to metadata statistics about playerbase demographics, records, achievements, etc. Much of the milestones & information you're looking for has be to done by random people who take on the challenge. Hopefully the data & research is made open sourced.

3. I will eventually republish the deleted GitHub repository containing all of the data & scripts prior to 2020(?). There isn't timetable on this as I have to adjust a few things before republishing it. Please check back in a month or two as this is something in my backlog, but I just don't have the time to do it currently. When I republish the repository though, feel free to ask the OP on the GitHub Issue tab and I will answer it there.

My apologies about the inconvenience here.

Edit: I have made the repository public here: https://github.com/anujdahiya24/FIDE-Data

Answer 2

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.

Answer 3

Titles are pretty tough but rating is less tough. Just go here

https://www.chessgraphs.com/

You can see the month and year a certain player got a certain rating. Then subtract from their date of birth to see the age at which the rating was obtained. (A possible problem here is the if the month they obtain a certain rating is the same as their month of birth. But...the ratings come out every 1st of the month?)

For instance you can verify records for youngest to reach 2800+ (kasparov, kramnik, carlsen, firouzja) or youngest female to reach 2600+ (polgar, hou).