Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Show HN: I made Google Trends for Hacker News by indexing 18 years of comments. Parent comment
I do want to point out that the data in that ClickHouse playground only seems to go as far back as April 6, 2024 according to the query below:
SELECT * FROM hackernews_history ORDER BY update_time ASC LIMIT 10
There are no comments on this comment yet.
I do want to point out that the data in that ClickHouse playground only seems to go as far back as April 6, 2024 according to the query below:
This is of course still extremely useful, and generous! It just wasn't obvious from the comment that this isn't querying against all Hacker News data.