Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 153 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

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.
share|improve this question
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. – StackExchange User May 2 '13 at 2:24
@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
That last image is amazing :D – Doorknob May 2 '13 at 15:44
"temporarily" suspended until 2026, hah – PreferenceBean May 8 '13 at 10:07

You must log in to answer this question.

Browse other questions tagged .