# antontarasenko/smq

A collection of SQL queries to social media datasets.

Repository: https://github.com/antontarasenko/smq
Canonical: https://ross.abutalabs.com/products/smq
Language: TSQL
License: Apache-2.0
License Family: permissive
Last push: 2019-12-05T15:52:07+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 3810, "days_push": 2463, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1538, forks 64 (observed 2026-08-28T04:05:00.226962+00:00)

## What it is
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
- artifact type: dataset
- maturity: maintenance
- function: analytics, data-science, search-engine
- domain: social-media, analytics, big-data, data-science
- platform: cloud
- tags: bigquery, sql-queries, hacker-news, reddit, social-media-analysis, public-datasets, sql, web-server

## Member repositories
- antontarasenko/smq (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:00.226962+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T04:30:56.550463+00:00, confidence not recorded.
  - readme: https://github.com/antontarasenko/smq (fetched 2026-08-28T04:05:00.226962+00:00, sha 5d5bb14a8951)
- Data as of 2026-08-30T08:39:29.467469+00:00.