I was playing with the Data Explorer... And I was trying to write a query to show users who got the most % of their reputation from accepts.

So for each user: [% from Accepts] = [Rep from Accepts] / [Reputation]

The problem is that suspended users have a rep of 1. So they would have gained an "enormous" percent of their "1 rep" from accepts.

The result was that all the high-rep suspended users were at the top of the list.

Of course, curiosity sets in. I forked the query and tweaked it to single out these users. And before long, I had a working query that listed suspended users in decreasing order of their normal reputation.

I took a look at some of these users and found some things that I, as a normal user, (not a moderator), probably should NOT be seeing. At least not that easily...


Note that some of these are on high-reputation accounts. So I'll keep them anonymous.

enter image description here enter image description here enter image description here

enter image description here

In effect, I found many of the users who were involved in the iOS voting-ring that was recently busted up.

Feature Request:

Show suspended users in the Data Explorer with their normal reputation. Don't show it as 1.

The current system of showing suspended users with a reputation of 1:

  1. Skews the Data Explorer queries.
  2. Makes it possible for non-moderators to obtain a list of suspended users that have reputation > 1.
  • 9
    Definitely agree from the perspective of not skewing metrics. Can't say I care much about the privacy of someone with 9500 points of voting fraud who is banned until 2019. Of course, there may be implications to the innocent to be considered, and there are far less grievous offenses for which a user might be suspended.
    – Tim Medora
    May 2 '13 at 2:03
  • @TimMedora Those 3 examples are from 3 different users. The one with the 9.5k of vote-fraud will get off suspension 10 days from now.
    – Mysticial
    May 2 '13 at 2:19
  • I see. So the concern is that you can easily view every suspended user with a single query? or were you able to extrapolate more than that (just curious, I already +1 your suggestion on the basis of accurate results).
    – Tim Medora
    May 2 '13 at 2:22
  • I think this should be classified as a feature request and a bug. May 2 '13 at 2:24
  • 1
    @TimMedora Yeah. I was able to find a large number of suspended users with a single query. (at least 100 of them) Not only that, but I did it accidentally. To make matters worse, I was able to find users who probably had a -100 red flag slapped on them.
    – Mysticial
    May 2 '13 at 2:24
  • 6
    That last image is amazing :D
    – Doorknob
    May 2 '13 at 15:44
  • 2
    "temporarily" suspended until 2026, hah May 8 '13 at 10:07

You must log in to answer this question.

Browse other questions tagged .