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
20082026
-
▲ 3
Most mentioned links in Hacker News comments, 2006–2015story by chistev · 2026-04-24 · 1 comment
-
…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 -
▲ 1
Social Media Queriesstory by oferzelig · 2020-11-13 · 0 comments
-
…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 -
▲ 254
Most-mentioned links in Hacker News comments, 2006–2015story by simonebrunozzi · 2020-11-12 · 68 comments
-
…| 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 -
▲ 1
Top Hacker News Submissions by Category: 2006–2015story by anton_tarasenko · 2016-05-08 · 1 comment
-
▲ 2
Your Hacker News Statsstory by anton_tarasenko · 2016-04-30 · 0 comments
-
▲ 210
Most popular links in Hacker News comments, 2006–2015story by anton_tarasenko · 2016-04-24 · 68 comments
-
▲ 2
All the special pages of Hacker Newsstory by anton_tarasenko · 2016-04-23 · 2 comments
-
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 -
▲ 154
Top 100 Users on Hacker News by H-Indexstory by anton_tarasenko · 2016-04-16 · 81 comments
-
…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 -
…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 -
▲ 134
Websites That Feed Hacker News: Top Sources of Submissions by Median Scorestory by anton_tarasenko · 2016-04-14 · 48 comments
-
…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 -
▲ 1
A collection of SQL queries to social media datasetsstory by FiloSottile · 2016-04-10 · 0 comments
-
▲ 264
Top Hacker News Submissions by Year: 2009–2015story by anton_tarasenko · 2016-04-10 · 52 comments
-
▲ 3
Top Hacker News Submissions by Category: 2006–2015story by anton_tarasenko · 2016-04-08 · 0 comments
-
▲ 2
Show HN: Repository of queries to Hacker Newsstory by anton_tarasenko · 2016-03-28 · 2 comments