What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 131 Stack Exchange communities.

I like how Area51 shows users by their total reputation across all sites, as an indication of the user's general familiarity with the StackExchange format. Is it possible to get a list of all (or a subset) of users' total reputation? For example, if I wanted to know my ranking in this list (e.g. something like this list), how could I query for this data?

area51 reputation

share|improve this question
    

5 Answers 5

You could use the API to query associated ids by first querying for your association_id:

http://api.stackoverflow.com/0.8/users/{userId}

And get the association ID from there:

accept_rate: 100
association_id: "56541460-95df-4570-8911-e180125974ce"
user_questions_url: "/users/16587/questions"
user_answers_url: "/users/16587/answers"

Use that association_id to query the api for your data across the sites:

http://api.stackoverflow.com/0.8/users/{id}/associated

This returns the following information:

* associated_users: [
      o {
            + user_id: 16587
            + user_type: "registered"
            + display_name: "George Stocker"
            + reputation: 14929
            + on_site: {
                  # name: "Stack Overflow"
                  # logo_url: http://sstatic.net/so/img/logo.png
                  # api_endpoint: http://api.stackoverflow.com
                  # site_url: http://stackoverflow.com
                  # description: "Member of the StackExchange Network"
                  # icon_url: http://sstatic.net/so/apple-touch-icon.png
              }
            + email_hash: "9ed3482ccbb461fbf8796b251caf8f4d"
        }
      o {
            + user_id: 394
            + user_type: "registered"
            + display_name: "George Stocker"
            + reputation: 118
            + on_site: {
                  # name: "Server Fault"
                  # logo_url: http://sstatic.net/sf/img/logo.png
                  # api_endpoint: http://api.serverfault.com
                  # site_url: http://serverfault.com
                  # description: "Member of the StackExchange Network"
                  # icon_url: http://sstatic.net/sf/apple-touch-icon.png
              }
            + email_hash: "9ed3482ccbb461fbf8796b251caf8f4d"
        }
      o {
            + user_id: 1174
            + user_type: "registered"
            + display_name: "George Stocker"
            + reputation: 981
            + on_site: {
                  # name: "Super User"
                  # logo_url: http://sstatic.net/su/img/logo.png
                  # api_endpoint: http://api.superuser.com
                  # site_url: http://superuser.com
                  # description: "Member of the StackExchange Network"
                  # icon_url: http://sstatic.net/su/apple-touch-icon.png
              }
            + email_hash: "9ed3482ccbb461fbf8796b251caf8f4d"
        }
      o {
            + user_id: 16587
            + user_type: "registered"
            + display_name: "George Stocker"
            + reputation: 11852
            + on_site: {
                  # name: "Stack Overflow Meta"
                  # logo_url: http://sstatic.net/mso/img/logo.png
                  # api_endpoint: http://api.meta.stackoverflow.com
                  # site_url: http://meta.stackoverflow.com
                  # description: "Member of the StackExchange Network"
                  # icon_url: http://sstatic.net/mso/apple-touch-icon.png
              }
            + email_hash: "9ed3482ccbb461fbf8796b251caf8f4d"
        }
      o {
            + user_id: 707
            + user_type: "registered"
            + display_name: "George Stocker"
            + reputation: 101
            + on_site: {
                  # name: "Stack Apps"
                  # logo_url: http://sstatic.net/sa/img/logo.png
                  # api_endpoint: http://api.stackapps.com
                  # site_url: http://stackapps.com
                  # description: "Member of the StackExchange Network"
                  # icon_url: http://sstatic.net/sa/apple-touch-icon.png
              }
            + email_hash: "9ed3482ccbb461fbf8796b251caf8f4d"
        }
  ]
share|improve this answer
    
Where did you find that URL? –  jjnguy Jun 15 '10 at 18:08
    
I'm anxiously awaiting the release of this site! –  Ether Jun 15 '10 at 18:09
    
@jjnguy At the bottom of this page: api.stackoverflow.com/0.8/help –  George Stocker Jun 15 '10 at 18:34
2  
@Ether I finished the underpinnings last weekend (took a little longer than expected) and am constructing the UI tonight (it's already been sketched out and spec'd). I'm hoping to have it done by this weekend so I can make the contest. –  George Stocker Jun 15 '10 at 18:37
    
@george no, it does what is on the tin -- that site is about network authentication and network enumeration. There is no "global" API other than those two functions. –  Jeff Atwood Jun 15 '10 at 21:52
    
@Jeff Atwood Thanks! –  George Stocker Jun 15 '10 at 22:01
    
@George - any update on the UI? If you already have a wheel, I'd prefer not to reinvent it for myself :) –  Damovisa Jul 14 '10 at 2:28
    
@Damovisa sidetracked by Niece and little brother visiting last two weeks (leaving this weekend); looking to push it out middle of next week. –  George Stocker Jul 14 '10 at 10:44

This is not exactly what you were asking for, but I just did a few queries on the data-explorer to find the total aggregate reputation for all users on the trilogy sites including breakdowns for specific user groups. Here is the report for StackOverflow:

Category        Users   Total Rep  Avg Rep    % Users % Rep  
--------------- ------- ---------- ---------- ------- ------ 
All             251,679 44,636,799 177.36     100.0%  100.0% 
Rep>1           127,415 44,512,535 349.35     50.6%   99.7%  
Rep>10          101,548 44,362,682 436.86     40.3%   99.4%  
Rep>100         35,296  42,212,853 1,195.97   14.0%   94.6%  
Rep>1,000       8,290   33,253,355 4,011.26   3.3%    74.5%  
Rep>10,000      600     13,041,613 21,736.02  0.2%    29.2%  
Rep>100,000     5       656,471    131,294.20 0.0%    1.5%   
Rep<10          149,315 265,957    1.78       59.3%   0.6%   
Rep<100         216,255 2,411,146  11.15      85.9%   5.4%   
Rep<1,000       243,379 11,373,444 46.73      96.7%   25.5%  
Rep<10,000      251,079 31,595,186 125.84     99.8%   70.8%  
[10..100]       67,068  2,157,989  32.18      26.6%   4.8%   
[100..1,000]    27,134  8,972,298  330.67     10.8%   20.1%  
[1,000..10,000] 7,700   20,221,742 2,626.20   3.1%    45.3%

If you want to find where you sit in the percentile of users on a given site this is a good start. Here are the links for each site:

  1. User count and total reputation for various reputation levels on Meta
  2. User count and total reputation for various reputation levels on SF
  3. User count and total reputation for various reputation levels on SU
  4. User count and total reputation for various reputation levels on SO
share|improve this answer
    
Getting rankings for an individual site (for just one user) is fairly easy, with a calculation involving position and page number vs. total pages, but getting the rankings across all sites at once is a lot more difficult. Perhaps it would be possible to produce a merged Users table on data-explorer? –  Ether Jun 17 '10 at 22:32
    
wait... so... 3.1% of the users have 45.3% of the reputation together, while 26.6% of the users have only 4.8% of the reputation together. –  alexanderpas Jun 18 '10 at 3:06
    
@alexanderpas yep... and the 0.2% of users with more than 10k have another 29.2% of the total reputation. A more interesting query would be the number of questions and answers each type of user contributed, as this might show how much real value low rep users contribute to the site. I'll probably try writing that one next, but it is a bit more difficult as you need to separate good and bad responses. –  Greg Bray Jun 18 '10 at 20:24
    
WHAT? the top 0.2% of users have 29.2% of the total wealth? this is HORRIBLE, something is wrong with our system, we must immediately rebalance reputation equally across everyone. (Sarcasm, in case it wasn't clear.) ;) –  Ether Jun 20 '10 at 16:07

I have a couple apps that might help with this.

The first is StackImage:

It creates an image from all of your associated accounts and displays the reputation from them.

The second is StackCenter:

It displays your reputation and comments from all associated sites.

share|improve this answer

This is why I wrote StackFlair!

StackFlair

About

There have been several requests on MSO for a way to get a combined flair similar to what is shown on Area51. I took a "I want it, I'll make it" approach. Thus became StackFlair.

StackFlair generates a combined flair representing all of your associated StackExchange accounts. StackFlair includes:

  • Your gravatar from your top site (by rep score)
  • Your display name from your top site
  • Your total reputation
  • The number of sites you are a mod on
  • The total number of gold badges
  • The total number of silver badges
  • The total number of bronze badges
  • Favicons for your top 6 sites

Area51 is currently excluded as the site is not included in the api.

The default output is html to support linking and titles for the elements contained in the flair. You can also get image output. Themes are a planned feature.

I provide a very simplistic UI for selecting a StackExchange site and inputting a user id. The generated content can also be linked to directly.

Your StackFlair data is stored for 12 hours.

Issues and feature requests can be submitted here

share|improve this answer

The easiest way to do this manually is to look at their account tab on their user page.

http://meta.stackoverflow.com/users/132636?tab=accounts#tab-top
http://meta.stackoverflow.com/users/16587?tab=accounts#tab-top
http://meta.stackoverflow.com/users/2915?tab=accounts#tab-top

share|improve this answer
    
Painfully manually... –  Adam Davis Jun 15 '10 at 18:27
    
hahahaha... lol –  Stefan Sep 12 '10 at 13:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .