Ask HN: Total karmic wealth of all HN?
If you add up the karma of all user accounts what value do you get? 32553783 and counting. This means that the top 100 contributors (https://news.ycombinator.com/leaders) plus PG (https://news.ycombinator.com/user?id=pg) account for only about 10% of the total karma (3222034 points as of the moment). I expected their part to be greater. I should say "sorry" to the average HN user for underestimating his impact. :-) Right and there's about 9 million items, so average is 4 points per item. I don't feel the average is very meaningful in this case. I'd also want to know, range, median and mode and a frequency histogram for the 100 largest, 100 frequent, and 100 rarest item scores. I converted that to USD and it came out to $0.00. There may be an error in my math. Karma isn't worth anything directly but on HN it is a fair proxy for comment quality -- and quality HN comments have a monetary impact. For one thing, quality comments take time and effort to write. Suppose a comment takes 5 minutes per to write per karma point earned. Then 32553783 karma points are worth 32553783*5/60/24/30 ≈ 3767.8 man-months or approximately 314 man-years not spent doing something else. This isn't to say that HN comments just lose the authors (or their employers) money due to opportunity cost. I would not be surprised if for a number of HN users their commenting led to new clients and business partners, not to mention exposure for their open source projects or simply memorable discussions the impact of which is harder to estimate in monetary terms. (For example, the recurrent discussions about Stoicism have made converts.) Then some comments may not make the author money -- at least not as directly as getting a new client -- but may be worth a lot in terms of the money they make others; patio11's long comment history comes to mind. How did you discount karma's future value? Does it obey "power law" distribution? :) Yep. Does that include down votes ? It does. Downvotes lower the same karma score that upvotes add to. Not an admin, so I can't speak to what they have available. But as a hacker... Since the usernames are not queryable via an integer (e.g. user?id=1235654321) it's not exactly the most trivial of things. You'd have to go through an endless amount of posts, get every possible username from the comments, go through all stories submitted, grab their usernames, and then loop through the HN API and grab karma info. Flat files and Lisp macros, with everything stored as closures in RAM, AFAIK. HN doesn't use a relational database at all[0], unless they added one recently. I just noticed my profile had a section explaining average karma. But I don't see where my average karma is shown. (Or is my main karma number actually the average it's talking about?) Do you use an extension or something with HN? I think I had such a description from an extension I used, and the description persisted after HN decided to stop showing average karma. Yeah totes! Thanks for pointing that out. It's hnes. I guess its doing something there. Also I'm now wondering what's the total karmic wealth of reddit, stackexchange and Facebook each?
If the HN server uses an SQL database and has a table users containing the user names and their karma - and they must have something like that since the karmas are displayed on the profiles. select sum(karma) from user_data;