6

Can you please tell me how to find the user or developer that has the highest number of profile views?

Improve this question
10
  • 13
    Didn't look, but I can pretty much guarantee that on Stack Overflow that is Jon Skeet.
    – Oded StaffMod
    Commented May 23, 2013 at 13:23
  • @Oded Yeah, that i know but may be he is base on reputation but i want to check out base on profile view :)
    – Chintan Khetiya
    Commented May 23, 2013 at 13:25
  • 1
    Um. Yes. Also that.
    – Oded StaffMod
    Commented May 23, 2013 at 13:25
  • 2
    @chintankhetiya There's a pretty strong correlation between reputation and profile views, I imagine.
    – Anthony Grist
    Commented May 23, 2013 at 13:26
  • 8
    Jon Skeet is answer to "who is the user with the most/highest/maximum X" questions, for great many X values.
    – Shadow Wizard
    Commented May 23, 2013 at 13:28
  • Don't you think that my question is also deserve for up votes.
    – Chintan Khetiya
    Commented May 23, 2013 at 13:31
  • 4
    Not... really... I don't see the significance in having the most profile views out of any user.
    – BoltClock's a Unicorn Mod
    Commented May 23, 2013 at 13:41
  • Last time I looked, Jon Skeet had as many profile views as reputation points.
    – Linuxios
    Commented May 23, 2013 at 13:45
  • @ShaWizDowArd - Not in every highest X. E.g. downvotes, review etc.. :)
    – Himanshu
    Commented Oct 10, 2013 at 10:39
  • 2
    @hims056 yeah, though if he'll focus his attention on reviews he'll reach the top before we can say "Jon Skeet". :D
    – Shadow Wizard
    Commented Oct 10, 2013 at 10:41

3 Answers 3

Reset to default
15

Here you go with Data Explorer query

SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Views DESC) AS Rank
              , ID AS [User Link]
              , Views, Reputation, Location 
FROM USERS

Output:

╔═══════╦═════════════════╦═══════════╦══════════════╦═════════════════════════╗
║ Rank  ║      User       ║    Views  ║  Reputation  ║        Location         ║
╠═══════╬═════════════════╬═══════════╬══════════════╬═════════════════════════╣
║     1 ║ Jon Skeet       ║    639947 ║       610427 ║ Reading, United Kingdom ║
║     2 ║ Eric Lippert    ║    176837 ║       249482 ║ Seattle, WA             ║
║     3 ║ Marc Gravell    ║    133054 ║       423970 ║ Forest of Dean, UK      ║
║     4 ║ Jeff Atwood     ║    122506 ║        27684 ║ El Cerrito, CA          ║
║     5 ║ BalusC          ║    115142 ║       425228 ║ Willemstad, Curaçao     ║
║     6 ║ Darin Dimitrov  ║    106748 ║       466354 ║ Sofia, Bulgaria         ║
║     7 ║ Bill the Lizard ║     82214 ║       124132 ║ Charlotte, NC           ║
║     8 ║ Hans Passant    ║     80089 ║       389208 ║ Madison, WI             ║
║     9 ║ CommonsWare     ║     75888 ║       322395 ║ Where You Least Expect  ║
║    10 ║ casperOne       ║     62554 ║        45832 ║ Brooklyn, NY            ║
║   ... ║                 ║           ║              ║                         ║
╚═══════╩═════════════════╩═══════════╩══════════════╩═════════════════════════╝
Improve this answer
4
  • 14
    Amazing how outdated the data is, 559,060 views live vs. "only" 195,496 in the data explorer. Oh, there is open bug report.
    – Shadow Wizard
    Commented May 23, 2013 at 13:26
  • @ShaWizDowArd - Yeah thanks for adding a bounty
    – Himanshu
    Commented May 23, 2013 at 13:33
  • 2
    That was back when Rich B was one of the most well-known users. He's 17th according to the Data Explorer and he might have had the most profile views of anyone (save possibly Jeff Atwood) at one point.
    – mmyers Mod
    Commented May 24, 2013 at 4:58
  • 1
    It must however be highlighted that there are users who have very likely gamed the system to obtain their profile views according to the analysis that I have carried out at: stats.stackexchange.com/questions/376361/…
    – Ciro Santilli OurBigBook.com
    Commented Oct 14, 2019 at 12:16
11

You can use the Data Explorer for this. At the time of writing, here's the top 10:

Id    Reputation DisplayName            Views  

----- ---------- ---------------------- ------ 

22656 566017     Jon Skeet              195496 
23354 392057     Marc Gravell           49421  
1     25815      Jeff Atwood            41072  
88656 224983     Eric Lippert           36676  
4     19569      Joel Spolsky           32408  
95810 260640     Alex Martelli          26717  
18393 218278     cletus                 23156  
34509 202424     Johannes Schaub - litb 19393  
33708 162443     Mehrdad Afshari        19160  
1288  112464     Bill the Lizard        18229
Improve this answer
3
  • 3
    These counts are awfully low, actually. I'd be in 8th place according to my profile counter..
    – Martijn Pieters
    Commented May 23, 2013 at 13:28
  • Did not realize how far behind that is.
    – user7116
    Commented May 23, 2013 at 13:28
  • 2
    @MartijnPieters yep. :/
    – Shadow Wizard
    Commented May 23, 2013 at 13:33
6

I believe the property you're looking for is static readonly.

Improve this answer
2
  • 6
    There is an interesting competiting between his reputation and profile views.
    – fedorqui 'SO stop harming'
    Commented May 23, 2013 at 13:24
  • yeah ,that was the reason behind to ask :)
    – Chintan Khetiya
    Commented May 23, 2013 at 13:26

You must log in to answer this question.

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