antontarasenko/smq resource
A collection of SQL queries to social media datasets. observed · 2026-08-28
Health v2 · maintenance only
32/100
- Activity 0
- Release rhythm 35
- Longevity 100
Flags: no_releases
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-02. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 3810
- days_rel: n/a
- days_push: 2463
- n_releases_24m: 0
Adoption not part of the score
1538 stars · 64 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
A curated collection of SQL queries (TSQL) for analyzing public social media datasets hosted on Google BigQuery, covering sources like Hacker News and Reddit. It includes example reports such as top submissions by year and most cited books, with data snapshots ending around 2015.
Use cases
- find the most mentioned books on Hacker News
- analyze top Reddit submissions by year
- build a social network graph of HN commenters
- find popular apps cited on Hacker News
- rank Hacker News authors by median post score
- run analytics on public social media datasets in BigQuery
When to choose
- you want ready-made SQL queries for BigQuery's free public social media datasets
- you need example reports or inspiration for social media data analysis
- you're exploring historical Hacker News or Reddit data up to 2015
When to avoid
- you need up-to-date data (snapshots end around 2015)
- you want a runnable application or API rather than SQL files
- you use a database other than Google BigQuery without adaptation
Facets
dataset · maturity maintenance
analytics data-science search-engine social-media analytics big-data data-science cloud bigquery sql-queries hacker-news reddit social-media-analysis public-datasets sql web-server
1 source
- readme: https://github.com/antontarasenko/smq · fetched 2026-08-28 · 5d5bb14a8951
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| antontarasenko/smq | main | 32 |
For agents
markdown · JSON · MCP: product_card(name="antontarasenko/smq")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem