Hacker GitHub

← All repos

antontarasenko/smq

View on GitHub ↗ ★ 1,538 TSQL

A collection of SQL queries to social media datasets.

20 mentions on Hacker News by 8 people: 13 stories, 7 comments · first 2016-03-28 · latest 2026-04-24

Mentions per year 20 mentions · busiest year 2016 (14)
20082026
AllStoriesComments NewestTopOldest
  1. …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.
    comment by tutfbhuf · 2021-02-17 · in Command Line Shell for SQLite
  2. …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...
    comment by macieklaskus · 2020-11-12 · in Most-mentioned links in Hacker News comments, 2006–2015
  3. …| https://news.ycombinator.com/item?id=11512455 (Apr 2016, 81 comments) and other social media: https://github.com/antontarasenko/smq
    comment by j_s · 2017-10-13 · in Analysing C# code on GitHub with BigQuery
  4. The 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=114991…
    comment by anton_tarasenko · 2016-04-17 · in Top 100 Users on Hacker News by H-Index
  5. …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-10…
    comment by anton_tarasenko · 2016-04-15 · in Top 10,000 “Show HN”s 2006-2015: Where are they now? Please, share your story
  6. …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
    comment by anton_tarasenko · 2016-04-14 · in Websites That Feed Hacker News: Top Sources of Submissions by Median Score
  7. …added submissions from 2006-2008. Now it includes the entire HN history. Also, ranking by category: https://github.com/antontarasenko/smq/blob/master/reports/ha...
    comment by anton_tarasenko · 2016-04-11 · in Top Hacker News Submissions by Year: 2009–2015