Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
141–150 of 169 posts
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#142Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#143Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#144It's funny how "trump" dwarfs just about any other term. Truly a hacker forum.
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#145Google Trends is about searches This is about published text . More like if Google Trends counted word occurrences on webpages. Or if Google Ngrams counted webpages instead of books People don't write much about non-newsworthy things whereas many people search "burger" anytime they want a burger delivery. The datasets aren't usable in the same way Edit: not to say it's not a cool product! Just keep this in mind and e…
I strongly disagree, especially since this tool aggregates both posts and comments. While they don't measure the exact same thing, HN posts and comments are quite similar to searches from the standpoint of "What are people interested in finding more about and discussing" - stories that get popular usually have a lot of comments, thus boosting relevant terms, while posts about topics that don't trend score low because they don't get any relevant discussion comments.
Heck, just try it yourself - I compared "blockchain" to "OpenAI" with this tool, and got a predictable result (blockchain had some spikes up until the late teens, then OpenAI took over with the launch of ChatGPT). Interestingly, the Google Trends plot for these two terms looks very similar.
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#146I host a publicly open database with Hacker News data at https://play.clickhouse.com/play?user=play#U0VMRUNUICogRlJPT... So you can create any sort of similar services in a single SQL query and an HTML page. I also hosted it as a publicly accessible data lake, which you can query from everywhere: https://github.com/ClickHouse/ClickHouse/issues/29693#issuec... It is also updated in real-time.
oh hey, per HN terms and conditions I license my HN data only to HN. Can you please remove my data from the set? Thank you!
Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#147Re: Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
#148Earlier quoted context omitted.
That is about the software, not the data.
While a literal reading of the MIT license refers to "software", many datasets have been released under it. In particular, if someone releases something that is only a dataset along with an MIT license file, the most reasonable interpretation is that the rights holder intended to release the data under the terms of that license. I looked for copyright cases involving this specific distinction, whether "data" versus "…