Answers.Body: <p>A rather half-fledged answer but here goes:</p>
  <p>Check out <a href="https://ratings.fide.com/download.phtml" rel="nofollow noreferrer">https://ratings.fide.com/download.phtml</a>.
  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 , &lt;player_ID&gt;, &lt;D.o.b.&gt;, , . It should be clear that  refers to the player's highest title achieved by <strong>that month</strong>. 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').</p>
  <p>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.</p>
  <p>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).</p>
  <p>Edits:</p>
  <p>Further data sources I found:</p>
  <p><a href="https://www.mark-weeks.com/chess/ratings/" rel="nofollow noreferrer">https://www.mark-weeks.com/chess/ratings/</a> - the annual FIDE ratings lists 1975 to 2000 including titles</p>
  <p>Try reaching out to:</p>
  <p><a href="https://www.reddit.com/r/chess/comments/em03o4/fide_chess_data/" rel="nofollow noreferrer">https://www.reddit.com/r/chess/comments/em03o4/fide_chess_data/</a> Reddit user 'AnujDahiya24' seemed to compile all available data 2 years ago but his Github repository seems to be deleted</p>
  <p><a href="https://core.ac.uk/download/pdf/205518195.pdf" rel="nofollow noreferrer">https://core.ac.uk/download/pdf/205518195.pdf</a> the writer of this paper prepared a Microsoft Access database with the available FIDE data to 2000, but the database is no longer available</p>
  <p>2700chess - the maintainer of this website presumably has compiled all historical FIDE data into his database.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-09-18T17:35:38.260Z
Answers.LastActivityDate: 2021-10-10T18:27:31.283Z
Answers.LastEditDate: 2021-10-10T18:27:31.283Z
Answers.UserDisplayName: Mobeus Zoom
Answers.Body: <p>Titles are pretty tough but rating is less tough. Just go here</p>
  <p><a href="https://www.chessgraphs.com/" rel="nofollow noreferrer">https://www.chessgraphs.com/</a></p>
  <p>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?)</p>
  <p>For instance you can verify records for youngest to reach 2800+ (kasparov, kramnik, carlsen, firouzja) or youngest female to reach 2600+ (polgar, hou).</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-12-12T07:16:34.403Z
Answers.LastActivityDate: 2021-12-12T07:25:00.233Z
Answers.LastEditDate: 2021-12-12T07:25:00.233Z
Answers.UserDisplayName: BCLC
Answers.Body: <p>I am the Reddit user, '<strong>AnujDahiya24</strong>' mentioned by the user, Mobeus Zoom, in his/her answer above. I wanted to add onto it a bit.</p>
  <ol>
  <li><p>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.</p>
  </li>
  <li><p>FIDE/Chessbase aren't data savvy surprisingly when it comes to metadata statistics about playerbase demographics, records, achievements, etc. Much of the milestones &amp; information you're looking for has be to done by random people who take on the challenge. Hopefully the data &amp; research is made open sourced.</p>
  </li>
  <li><p>I will eventually republish the deleted GitHub repository containing all of the data &amp; 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 <em>Issue</em> tab and I will answer it there.</p>
  </li>
  </ol>
  <p>My apologies about the inconvenience here.</p>
  <p><strong>Edit: I have made the repository public here: <a href="https://github.com/anujdahiya24/FIDE-Data" rel="nofollow noreferrer">https://github.com/anujdahiya24/FIDE-Data</a></strong></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-10-29T00:15:03.523Z
Answers.Text: Welcome to Chess.SE, and looking forward to it!
Answers.UserDisplayName: Mobeus Zoom
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-01-29T04:17:30.377Z
Answers.Text: @BCLC
  
  https://github.com/anujdahiya24/FIDE-Data
Answers.UserDisplayName: Anuj Dahiya
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-01-29T04:31:45.237Z
Answers.Text: @MobeusZoom see link above too
Answers.UserDisplayName: Anuj Dahiya
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-01-29T19:08:57.817Z
Answers.Text: @AnujDahiya Great work!
Answers.UserDisplayName: Mobeus Zoom
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-01-23T10:49:38.770Z
Answers.Text: '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.' :)
Answers.UserDisplayName: BCLC
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-10-27T05:45:11.380Z
Answers.LastActivityDate: 2022-01-29T04:18:20.783Z
Answers.LastEditDate: 2022-01-29T04:18:20.783Z
Answers.UserDisplayName: Anuj Dahiya
Body: <p><strong>A. Background:</strong></p>
  <p>Under Mobeus Zoom's suggestion here: <a href="https://chess.stackexchange.com/questions/36890/list-of-records-for-youngest-supergms-since-1950-or-1970-or-whenever-fide-star">List of records for youngest superGMs since 1950? (or 1970 or whenever FIDE started rating people. or basically after 2700s after Fischer)</a> (this is about reaching specific ratings though rather than attaining a specific title) re variations for <a href="https://en.wikipedia.org/wiki/Chess_prodigy#List_of_youngest_grandmasters" rel="nofollow noreferrer">List of youngest grandmasters since 1950</a>, I am now asking how to go about answering these types of questions:</p>
  <p><a href="https://chess.stackexchange.com/questions/36884/list-of-records-for-youngest-international-masters-since-1950">List of records for youngest international masters since 1950?</a></p>
  <p><a href="https://chess.stackexchange.com/questions/36909/list-of-records-for-youngest-female-international-masters-since-1950">List of records for youngest female international masters since 1950?</a></p>
  <p><a href="https://chess.stackexchange.com/questions/36910/list-of-records-for-youngest-wims-woman-international-masters-since-1950">List of records for youngest WIMs (woman international masters) since 1950?</a></p>
  <hr />
  <p><strong>B. Questions</strong>:</p>
  <ol>
  <li>From what site can I download some kind of spreadsheet with this kind of data?</li>
  </ol>
  <p>player X - date of birth - date IM title obtained (if any) - (among other such data)</p>
  <ul>
  <li><p><strong>Update 1</strong>: Given so far: <a href="https://ratings.fide.com/download_lists.phtml" rel="nofollow noreferrer">https://ratings.fide.com/download_lists.phtml</a></p>
  </li>
  <li><p>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</p>
  </li>
  <li><p>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.</p>
  </li>
  <li><p><strong>Update 2</strong>: Damn it Mobeus Zoom <a href="https://ratings.fide.com/download_lists.phtml" rel="nofollow noreferrer">https://ratings.fide.com/download_lists.phtml</a> is different from <a href="https://ratings.fide.com/download.phtml" rel="nofollow noreferrer">https://ratings.fide.com/download.phtml</a> ! lol</p>
  </li>
  </ul>
  <ol start="2">
  <li>Then is the ff the right procedure/algorithm assuming I obtain such data?</li>
  </ol>
  <p>A - Let column 4 be the subtraction of column 2 from column 3.</p>
  <p>B - Sort by column 3.</p>
  <p>C - Let column 5 check if corresponding entry in column 4 is minimum among all the column 4 entries up to it</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-09-19T17:05:09.497Z
Comments.Text: Comments are not for extended discussion; this conversation has been [moved to chat](https://chat.stackexchange.com/rooms/129778/discussion-on-question-by-bclc-ok-fine-how-do-i-answer-questions-like-records-f).
Comments.UserDisplayName: Brian Towers
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-10-16T06:33:20.660Z
Comments.Text: I'm in favour of keeping this post open (it's a [teach a man to fish](https://en.wiktionary.org/wiki/give_a_man_a_fish_and_you_feed_him_for_a_day;_teach_a_man_to_fish_and_you_feed_him_for_a_lifetime) post); it's best to leave the other ones for [Roomba](/help/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 [meta].
Comments.UserDisplayName: Glorfindel
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-10-16T08:28:40.573Z
Comments.Text: ok fine Roomba it is. thank you for both your honesty and empathy @Glorfindel
Comments.UserDisplayName: BCLC
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-10-16T08:30:23.420Z
Comments.Text: @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?
Comments.UserDisplayName: BCLC
Tags: <history><programming><statistics><database><records>
Title: How do I find data to determine records like the youngest person to obtain a certain title?
ThreadText: # How do I find data to determine records like the youngest person to obtain a certain title?
  
  (Asked by: username_0 on 2021-09-14)
  
  **A. Background:**
  
  Under username_3'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)](https://chess.stackexchange.com/questions/36890/list-of-records-for-youngest-supergms-since-1950-or-1970-or-whenever-fide-star) (this is about reaching specific ratings though rather than attaining a specific title) re variations for [List of youngest grandmasters since 1950](https://en.wikipedia.org/wiki/Chess_prodigy#List_of_youngest_grandmasters), I am now asking how to go about answering these types of questions:
  
  [List of records for youngest international masters since 1950?](https://chess.stackexchange.com/questions/36884/list-of-records-for-youngest-international-masters-since-1950)
  
  [List of records for youngest female international masters since 1950?](https://chess.stackexchange.com/questions/36909/list-of-records-for-youngest-female-international-masters-since-1950)
  
  [List of records for youngest WIMs (woman international masters) since 1950?](https://chess.stackexchange.com/questions/36910/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 username_3 <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
  
  **Tags:** history, programming, statistics, database, records
  
  > **Comments:**
  > **username_1**: Comments are not for extended discussion; this conversation has been [moved to chat](https://chat.stackexchange.com/rooms/129778/discussion-on-question-by-bclc-ok-fine-how-do-i-answer-questions-like-records-f).  
  > **username_2**: I'm in favour of keeping this post open (it's a [teach a man to fish](https://en.wiktionary.org/wiki/give_a_man_a_fish_and_you_feed_him_for_a_day;_teach_a_man_to_fish_and_you_feed_him_for_a_lifetime) post); it's best to leave the other ones for [Roomba](/help/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 [meta].  
  > **username_0**: ok fine Roomba it is. thank you for both your honesty and empathy @username_2  
  > **username_0**: @username_2 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?  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_4 on 2021-10-27. Score: 5 | Accepted answer
  
  I am the Reddit user, '**AnujDahiya24**' mentioned by the user, username_3, 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>**
  
  > **Comments:**
  > **username_3**: Welcome to Chess.SE, and looking forward to it!  
  > **username_0**: '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.' :)  
  > **username_4**: @username_0  https://github.com/anujdahiya24/FIDE-Data  
  > **username_4**: @MobeusZoom see link above too  
  > **username_3**: @AnujDahiya Great work!  
  
  ---
  
  ### Answer by username_3 on 2021-09-18. Score: 1
  
  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 , , , , . 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 by username_0 on 2021-12-12. Score: 0
  
  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).
  
  
  ---
  
  