Live data from Hacker News

Show HN: Hacker News Year in Review: 2023

public.tableau.com

21–30 of 34 posts

Re: Show HN: Hacker News Year in Review: 2023

#21
post #5

8.2k ++ Sam goes. 3.9k ++ Sam stays. Read the room, Sam.

Yes, because people (especially the ones that are very successful in life) read the comment section and don't follow their minds/hearts/wallets :P

I honestly believe they do. Joe Rogan talks with his guests about the social media impact a lot. Last time I heard it was with Matthew McConaughey.

Re: Show HN: Hacker News Year in Review: 2023

#22
post #20
post #18

where can i download the data behind this?

You just need to make 38 million requests to the Firebase API document here https://github.com/HackerNews/API . :-) I actually made many more than that because I screwed up a few times. Might clean up the compiled data and put it on Kaggle (GitHub? Torrent?), or anywhere else if people have suggestions.

I'd definitely put it on Kaggle

Re: Show HN: Hacker News Year in Review: 2023

#24
post #20
post #18

where can i download the data behind this?

You just need to make 38 million requests to the Firebase API document here https://github.com/HackerNews/API . :-) I actually made many more than that because I screwed up a few times. Might clean up the compiled data and put it on Kaggle (GitHub? Torrent?), or anywhere else if people have suggestions.

I thought you were joking about the 38 million requests! wow! Have you heard about .parquet files? Save it as a parquet and share the link.

Re: Show HN: Hacker News Year in Review: 2023

#28
post #22
post #20

Earlier quoted context omitted.

You just need to make 38 million requests to the Firebase API document here https://github.com/HackerNews/API . :-) I actually made many more than that because I screwed up a few times. Might clean up the compiled data and put it on Kaggle (GitHub? Torrent?), or anywhere else if people have suggestions.

I'd definitely put it on Kaggle

Good idea. I put it here: https://www.kaggle.com/datasets/nickalt/hacker-news

Re: Show HN: Hacker News Year in Review: 2023

#29
post #24
post #20

Earlier quoted context omitted.

You just need to make 38 million requests to the Firebase API document here https://github.com/HackerNews/API . :-) I actually made many more than that because I screwed up a few times. Might clean up the compiled data and put it on Kaggle (GitHub? Torrent?), or anywhere else if people have suggestions.

I thought you were joking about the 38 million requests! wow! Have you heard about .parquet files? Save it as a parquet and share the link.

https://www.kaggle.com/datasets/nickalt/hacker-news

Re: Show HN: Hacker News Year in Review: 2023

#30
post #29
post #24

Earlier quoted context omitted.

I thought you were joking about the 38 million requests! wow! Have you heard about .parquet files? Save it as a parquet and share the link.

https://www.kaggle.com/datasets/nickalt/hacker-news

this is amazing -- thanks. side note: when you want to get more data you can just get the new data, and save it as hacker-news-part-2.parquet - then when you use duckdb / malloy you can read them as a glob (hacker-news*.parquet) - and it is if you were reading one file.
Post reply on HN