COUNT(*) AS num_posts,
AVG(score) AS avg_score,
(AVG(score) + 2*perc_75) * LOG(COUNT(*)) AS calc_score
REGEXP_REPLACE(NET.HOST(url), 'www.', '') AS domain,
0.75) OVER (PARTITION BY REGEXP_REPLACE(NET.HOST(url), 'www.', '')) AS perc_75
type = 'story'
AND url IS NOT NULL )
(it's apparently not a perfect match since there appears to be a minimum # of posts requirement for domains [e.g. without that requirement, https://news.ycombinator.com/from?site=pardonsnowden.org is #3], which should be added to the description of the leaderboard)
I think it could really increase the usefulness of HN Domain Leaderboard if you added some additional filtering capabilities. Filtering based on the category would probably be pretty easy because you have that information there already, but perhaps also consider some measure of how broadly promoted each domain is. The time range option is already pretty cool, and I'll bet that a few more options would make it even more fun to play around with.
 - https://intoli.com/blog/pareto-optimal-blogs/
I'd been planning to add filtering on categories from the start, but it was meant to be a weekend project so my motivation had started to drop after that, so I just wanted to put it out there. Will add extra filters in the next few days!
This matches what I've been sensing (rightly or wrongly) in that the mix of stories has shifted from computer science and engineering to have a more business and general interest mix since I first started reading HN regularly. This goes for the sources as well as the stories themselves.
edit: nevermind, it's only showing categories for top 106 domains, but if you set the period to 1 year, you can tell that there are more tagged domains. And it's not always 106 domains.
I suspect that the score a link gets is highly variable and doesn't follow a known distribution, therefore, taking a straight mean may not be a valid thing to do, or at the very least, very very skewed.
That being said, cool idea, well executed.
One thing, if I may add, is that you need a link from the "about" page back to the main page.
Thanks again for sharing!
There's even the "Show HN" section specifically for self-promotion.
But I wasn’t actually disparaging any of them, or suggesting anything inappropriate has happened. I guess I’m just surprised that HN as a community, with such a high degree of anti-commercialism on the site, has given these sites this much exposure.
EDIT: never mind - on the three year view he's in the top 10