News for hackers. Stuff that matters.
Re:The value of downvoting, or, how Hacker News gets it wron... by krapp on Wednesday April 14, 2021 @05:37PM (#26813442)
>SELECT hn_name, hn_karma, hn_last_active FROM comments WHERE TIMESTAMPDIFF(DAY, hn_last_active, NOW()) > 180 ORDER BY hn_karma DESC LIMIT 100

Ah, Hacker News is too cool to use something as pedestrian as a database ;)

But there is a Google BigQuery dataset[0,1]. I don't know how up to date it is.

[0]https://console.cloud.google.com/bigquery?p=bigquery-public-...

[1]https://news.ycombinator.com/item?id=10440502

There are no comments on this comment yet.