10 ms·

Would actually like to see a list of largest karma-wise HN members who left. By leaving I would say over 180 days inactive. Dang can you post the result please

Would actually like to see a list of largest karma-wise HN members who left. By leaving I would say over 180 days inactive. Dang can you post the result please: 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

the_lonely_road 6y ago
Be the change that you want to see in the universe. HN has a super easy to use API and I have downloaded the entire history of the site before for a past project. If you don't want to do the leg work yourself I am positive that the data set is out there for download somewhere if you google around.
- minimaxir 6y ago
  Data analysis note: the public datasets only have submissions and comments, and just because a HN user has stopped submitting/commenting doesn't mean they quit HN. Lurking is fun.
  - DoreenMichele 6y ago
    Some people have simply changed their handle and that likely wouldn't be obvious from the public data set either. My old handle has 25k. It has been inactive since I moved to this one.
    - frosted-flakes 6y ago
      Curious, why did you create a new account?
      - DoreenMichele 6y ago
        My old handle unfortunately and innocently looks like (or can be interpreted as) "I'm just here to start shit!" It did not occur to me it might be misinterpreted a certain way until six weeks after I started it and I didn't think it important at that point. As I gained more karma, I did a blog post at some point explaining the completely innocent origin story for it (typo and all). After I hit the leaderboard, I decided, basically, "Oh, brother. This is so not worth the hassle involved. Yeesh." And changed to my actual first and middle names.
  - brewdad 6y ago
    And now, by commenting, you've reset your activity clock. Time to lurk for the next 6 months so you look inactive.
robocat 6y ago
That would give no information about the reason someone left: there are a lot of reasons to stop interacting with hn that have nothing to do with the “best people leave in short order” theory.
- type0 6y ago
  I know some people just switched to a different account and you would think they left.
  - fortran77 6y ago
    Exactly! I change my HN username every now and then.
krapp 6y ago
>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-data&d=hacker_news&page=dataset https://console.cloud.google.com/bigquery?p=bigquery-public-... [1]https://news.ycombinator.com/item?id=10440502 https://news.ycombinator.com/item?id=10440502
downandout 6y ago
I used to be incredibly active on here, and then I started getting downvoted on virtually every comment, likely for political reasons. I have all but stopped commenting compared to my previous activity. It just stopped being fun. Even posts I make that have nothing to do with politics, that only point out provable, factual information, get downvoted. I have over 13K karma, even after losing a few thousand points over the last 18 months or so. So the things that I have to say weren't always unpopular. I didn't change - the community did. It became a hostile, vindictive place. I still visit daily because HN does a good job of surfacing interesting articles, but I used to find the comments more interesting than the stories themselves. That has changed in the last few years, as identity politics have taken hold. I can now accurately predict the content of many of the comments on a given story by simply reading its title. It's sad to see.
- 0x737368 6y ago
  It's hilarious how your comment got immediately downvoted for sharing a personal anecdote about the very same thing. Must really be rubbing the people who downvote for political difference reasons the wrong way.
- 0xEFF 6y ago
  Down voted you because of your about me.
  - downandout 6y ago
    I believe it's an honest assessment of the current state of HN.
    - ascar 6y ago
      I remember you because of the about me. I was reading a somewhat controversial comment from you and then visited your account page probably to check for sibling comments in the same post. Your about me definitely changed how I feel about your comments and probably the source of your recent experience.
deleted 6y ago
[deleted]

the_lonely_road 6y ago

Be the change that you want to see in the universe. HN has a super easy to use API and I have downloaded the entire history of the site before for a past project. If you don't want to do the leg work yourself I am positive that the data set is out there for download somewhere if you google around.

minimaxir 6y ago
Data analysis note: the public datasets only have submissions and comments, and just because a HN user has stopped submitting/commenting doesn't mean they quit HN. Lurking is fun.
- DoreenMichele 6y ago
  Some people have simply changed their handle and that likely wouldn't be obvious from the public data set either. My old handle has 25k. It has been inactive since I moved to this one.
  - frosted-flakes 6y ago
    Curious, why did you create a new account?
    - DoreenMichele 6y ago
      My old handle unfortunately and innocently looks like (or can be interpreted as) "I'm just here to start shit!" It did not occur to me it might be misinterpreted a certain way until six weeks after I started it and I didn't think it important at that point. As I gained more karma, I did a blog post at some point explaining the completely innocent origin story for it (typo and all). After I hit the leaderboard, I decided, basically, "Oh, brother. This is so not worth the hassle involved. Yeesh." And changed to my actual first and middle names.
- brewdad 6y ago
  And now, by commenting, you've reset your activity clock. Time to lurk for the next 6 months so you look inactive.

robocat 6y ago

That would give no information about the reason someone left: there are a lot of reasons to stop interacting with hn that have nothing to do with the “best people leave in short order” theory.

type0 6y ago
I know some people just switched to a different account and you would think they left.
- fortran77 6y ago
  Exactly! I change my HN username every now and then.

krapp 6y ago

>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-data&d=hacker_news&page=dataset https://console.cloud.google.com/bigquery?p=bigquery-public-... [1]https://news.ycombinator.com/item?id=10440502 https://news.ycombinator.com/item?id=10440502

downandout 6y ago

I used to be incredibly active on here, and then I started getting downvoted on virtually every comment, likely for political reasons. I have all but stopped commenting compared to my previous activity. It just stopped being fun. Even posts I make that have nothing to do with politics, that only point out provable, factual information, get downvoted. I have over 13K karma, even after losing a few thousand points over the last 18 months or so. So the things that I have to say weren't always unpopular. I didn't change - the community did. It became a hostile, vindictive place. I still visit daily because HN does a good job of surfacing interesting articles, but I used to find the comments more interesting than the stories themselves. That has changed in the last few years, as identity politics have taken hold. I can now accurately predict the content of many of the comments on a given story by simply reading its title. It's sad to see.

0x737368 6y ago
It's hilarious how your comment got immediately downvoted for sharing a personal anecdote about the very same thing. Must really be rubbing the people who downvote for political difference reasons the wrong way.
0xEFF 6y ago
Down voted you because of your about me.
- downandout 6y ago
  I believe it's an honest assessment of the current state of HN.
  - ascar 6y ago
    I remember you because of the about me. I was reading a somewhat controversial comment from you and then visited your account page probably to check for sibling comments in the same post. Your about me definitely changed how I feel about your comments and probably the source of your recent experience.

deleted 6y ago

[deleted]