It was too much work to not post it but @Glorfindel beat me by a few minutes.
Here is the query:
(do note this looks at both regular sites AND site meta's. The latter might feel strange because site meta's don't show rep but you still earn the reputation related badges)
-- result table, don't rename and keep the site column
create table #results ( site ...
According to this SEDE query, no user on Stack Exchange has more than two legendary badges. That is surprisingly low, but obtaining the badge requires a lot of dedication.
Those users are (at the moment of writing this):
Stack Overflow & Meta Stack Exchange
Nick Craver (1 and 2)
Bill the Lizard (1 and 2)
Oded (1 and 2)
Pekka supports GoFundMonica (1 ...
According to this SEDE query, the Illuminator badge is (much) rarer than Legendary on most sites; of course, there are exceptions, but there's just a handful of them. You can edit the query parameters to compare other badges.
It is not the rarest badge on every site.
Over on Arqade, it has been awarded once, whereas Tenacious and Unsung Hero have never been awarded. There are similar situations with those badges, or Reversal, on other sites as well. Electrical Engineering was mentioned in the comments, and I also spotted it on ELU.
The badge is awarded only once per user, not multiple times. All badges that aren't explicitly stated as being awarded multiple times are only awarded once.
As rene said, you already earned the badge on January 11. As such, you can't earn it again even if you meet the criteria again.
The moment you've earned at least 200 reputation from anything (excluding the association bonus) then that day counts towards the badge - the reputation cap has absolutely nothing to do with the badge. Downvotes do not count against you for a day; the badge script ignores all negative events for the day when determining your eligibility. The badge progress ...
As time goes by, the above answer is no longer 100% correct. Specifically,
Reputation earned from these activities (accepting/accepted/bounty) before reaching the cap does still count towards the cap.
Has been changed. What's in effect now is
Reputation earned from these activities before reaching the cap no longer counts towards the cap.
Here's Jeff ...
The progress bar for the Mortarboard badge counts to 1 because that is consistent with how the progress bar counts for its relatives: Epic and Legendary. Those require you to hit 200 reputation on 50 and 150 days, respectively. It doesn't make much sense to have the bronze badge do something different from the silver and gold badges.
As an aside, you can ...
Although reputation on meta is taken from the main site, the badge mechanics, including the badges based on reputation, still works, giving you badges based on reputation you weren't aware off.
The following query shows the number of days a certain member of Meta Stack Overflow has hit the rep cap making you eligible for the Mortarboard badge. If this query ...
As indicated by the FAQ, only unupvotes and unaccepts affect the day they occurred. Because downvotes are not considered in any way for those badges, undownvotes are also ignored for it.
Calculating all the events for that day minus the downvote and undownvoted events, that day calculates out to 199 for you.
As per Oded's answer: (emphasis mine)
status-bydesign - These are sorted by the combined
completion %ages of both bars (I don't think there is a reasonable
secondary sort to this), given that both parts are required in order
for the badge to be earned. In that respect the three highlighted
badges are all 5% completed (2/20 == 10% - the other bar ...
The badge award is something you see, and since it's the first time you have crossed that reputation threshold, it's also likely that it's the first time you'll see votes without any value (since you hit the cap). The link serves to educate people about the reputation cap that they are seeing kick in for the first time.
I've modified this SEDE query to show the sites where users obtained their badges.
Rand al'Thor earned his badges on Science Fiction & Fantasy and Puzzling Stack Exchange. I think he qualifies.
Another candidate (depending on if you consider TeX to be programming or just 'markup') would be egreg who is legendary on Mathematics and TeX - LaTeX.
Yes, the progress bar only counts to one due to its other neighbors, Epic and Legendary. animuson is correct on why it is 0/1 rather than x amount of rep/200. But I believe that these two proposals could be combined into one.
Of course, we will need to keep the original way we see how close you are to getting Mortarboard, Epic, or Legendary (0/1, 0/50, 0/...
SEDE doesn't record historical reputation (or votes), just the state at the time the data is exported. You could get an approximation by digging through the data dumps (published a few times a year) and/or specific users' reputation-history pages, but that sounds labor-intensive.
You could capture new cases of Legendary each week when SEDE is updated and ...
As animuson explains here:
it's also important to realize that simply hitting the mark for the day is not permanent. You can still lose the day if votes for the day get retracted later on... The number of days you've hit the cap is recalculated every time the badge script checks...
When a user is removed, the votes they cast are also removed. So yes, ...
According to the epic badge page here on MSE (where bounties are plentiful among high rep users), the last user to be awarded the badge (as of today, obviously) was Shadow Wizard on December 30, 2013.
Since I don't have access to his /reputation page, I looked at his reputation graph. Manually counting all the days he reached at least 200, by December 30, ...
I received the Epic badge recently and my /reputation page showed I reached 200 rep only 46 times.
What was interesting is: even though the badges page records all the Epic badges as received at midnight, I received mine in the middle of the day, a few minutes after I reached 200 points on that day.
That made me think that the way the badge is calculated ...
Downvotes (either giving or receiving) no longer affect Epic/Legendary badge progress (this changed in 2013, well after the question was asked and the other answers were posted), so this isn't really a problem any more.
There are still some residual issues, mostly related to the user interface. For example, the badge tracker appears to display downvotes ...
Originally only rep from upvotes, downvotes and suggested edits counted towards the Mortarboard, Epic and Legendary badges. So reaching 200 rep under this rule was really the maximum. However this was changed.
I guess that they forgot to change the working of the bar as well. This is happening to me too.
The reputation change is calculated in the order the events happen.
So you get 20 up votes for 200 reputation.
The next upvote is "lost" as you've hit the cap.
If you get a down-vote that takes you to 198.
If you get another up-vote you'll get +2 from it to take you back to 200.
If you get an up-vote that's a -10 so the "realtime" reputation indicator ...
Here is a SEDE query which attempts to list reputation on 'Legendary Day' for all users who have the badge. It runs faster than I expected on this site, but we only have 15 Legendary users here:
# User Legendary Day Rep
1 Jeff Atwood 2010-03-23 13:17:...