CHchistev·Apr 24, 2026Submission
Most mentioned links in Hacker News comments, 2006–2015
3 points · Open discussionantontarasenko
smq
TSQL2016–2026
antontarasenko / smq
smq
A collection of SQL queries to social media datasets.
8Distinct people
20Mentions
0Explicit recommenders
1.5KGitHub stars
What to know before exploring
What it is
A collection of SQL queries to social media datasets.
GitHub
Where it is used
No documented product use has been verified yet.
What people are saying
No recommendation phrase was found in the indexed comments.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
No other repository is repeatedly linked in the same discussions.
This week on Hacker News
Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 3:56:07 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by year20 dated mentions
Observed mentions: 2016-03-28 17:09:18 UTC to 2026-04-24 07:31:53 UTC.
* An incomplete calendar period is marked with an outlined bar. Its count is not directly comparable with a full period.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| 2016 | 2016-01-01 00:00:00 UTC | 2017-01-01 00:00:00 UTC | 14 | 10 | 4 |
| 2017 | 2017-01-01 00:00:00 UTC | 2018-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2018 | 2018-01-01 00:00:00 UTC | 2019-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2019 | 2019-01-01 00:00:00 UTC | 2020-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2020 | 2020-01-01 00:00:00 UTC | 2021-01-01 00:00:00 UTC | 3 | 2 | 1 |
| 2021 | 2021-01-01 00:00:00 UTC | 2022-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2022 | 2022-01-01 00:00:00 UTC | 2023-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2023 | 2023-01-01 00:00:00 UTC | 2024-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2024 | 2024-01-01 00:00:00 UTC | 2025-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2025 | 2025-01-01 00:00:00 UTC | 2026-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2026 (partial) | 2026-01-01 00:00:00 UTC | 2027-01-01 00:00:00 UTC | 1 | 1 | 0 |
What Hacker News says
20 sources> How he’s ended up with so much karma
He has 65728 karma because of his many posts since December 12, 2010, but his h-index (community impact) is very low compared to others: https://github.com/antontarasenko/smq/blob/master/reports/ha...
This is one of the, leave a small comment on everything type of users.
In Command Line Shell for SQLiteVery cool! It's already useful, but you could make it even more so by enabling to sort by smaller time ranges (e.g. 1 year).
It would also be interesting to see a version of this list weighted by karma scores of users who posted the links.
Edit: even better, use your own h-index ranking https://github.com/antontarasenko/smq/blob/master/reports/ha...
In Most-mentioned links in Hacker News comments, 2006–2015Most-mentioned links in Hacker News comments, 2006–2015
254 points · Open discussionHN navel-gazing, BQ style:
Top 100 Users on Hacker News by H-Index | https://news.ycombinator.com/item?id=11512455 (Apr 2016, 81 comments)
and other social media: https://github.com/antontarasenko/smq
In Analysing C# code on GitHub with BigQueryTop Hacker News Submissions by Category: 2006–2015
1 points · Open discussionMost popular links in Hacker News comments, 2006–2015
210 points · Open discussionAll the special pages of Hacker News
2 points · Open discussionThe median score by user is a good choice.
An example: https://github.com/antontarasenko/smq/blob/master/reports/ha...
Its discussion: https://news.ycombinator.com/item?id=11499120
An explanation: https://news.ycombinator.com/item?id=11499158
In Top 100 Users on Hacker News by H-IndexTop 100 Users on Hacker News by H-Index
154 points · Open discussionClarification: I collected HTTP response codes from top 10,000 "Show HN" projects published since 2006. Half of them returned 200. The others returned timeouts and redirects, which indicates that they perhaps get closed.
So, what's happened to them? It's interesting to hear your Show HN project's story.
And, yes, supporting links:
Top 100 "Show HN" Projects in 2006–2015: https://github.com/antontarasenko/smq/blob/master/reports/ha...
Top 100 "Show HN" Projects plotted: https://plot.ly/~AntonTarasenko/20/top-100-show-hn-submissio...
Top 5,000 "Show HN" Projects plotted (this submission's link): https://plot.ly/~AntonTarasenko/23/top-5000-show-hn-submissi...
Top 10,000 "Show HN" Projects CSV: https://drive.google.com/open?id=0B-fi5DaWfQWbdlVKMU84czFrNk...
The data from: https://github.com/antontarasenko/smq
In Top 10,000 “Show HN”s 2006-2015: Where are they now? Please, share your storyThe link is updated to reflect the following
After SeanDav's question and minimaxir's comment, I summed up reposts' scores before computing the mean and the median:
HN news sources by mean score: https://docs.google.com/spreadsheets/d/1tTDDG2xg7OVKdUy4WCZ_...
HN news sources by median score: https://docs.google.com/spreadsheets/d/1P20sKg-fI6msZVZtJFe0...
HN news sources by number of submissions: https://docs.google.com/spreadsheets/d/1mmfbNWaX0Nr1P65VmwZp...
SQL code: https://github.com/antontarasenko/smq/blob/master/hackernews...
How-to: https://github.com/antontarasenko/smq
In Websites That Feed Hacker News: Top Sources of Submissions by Median ScoreWebsites That Feed Hacker News: Top Sources of Submissions by Median Score
134 points · Open discussionShowing the 15 most recent of 20 sources. Enable JavaScript to search and browse every indexed mention.