Some actual achievement data

[CQCumbers]

I was very curious how people might have actually earned some of the achievements mentioned, and eventually found that Clickhouse has a playground containing an archive of public github events from the past decade. It has stuff like issue opens and closes, but doesn't include things like commit information, or the current state of a repository, so it's limited and difficult to use in some ways. There are also limits on query execution time and memory for their demo. Nevertheless, I think I was able to get a list of users for some achievements, which I made a little website for over the weekend.

"Vital Contributor" seems less common than I would have thought - only 379 users appear to qualify by my accounting, and none of them are bots. Meanwhile there appears to include a lot of automatic issue creation going on for "This is Fine". Most large projects seem to be pretty good at deleting merged branches now, but I think some of them didn't do so earlier on, and ended up with some bulk-delete of branches that doesn't show up in the event archive (that, or there's a gap in the events, or a bug in my query - anyone know how many branches cockroackdb really had in early 2018?). Also, it's unrelated, but I found it surprising that people have made almost 5 times more pull requests than issues on public repos.

You can see the queries I used, and play with them yourself if you're interested. If you find a way to query for another achievement, I would love to know!