📱 Know what's blowing up on TikTok before anyone else — free, one paste

Tutorials & Methods
, ,
1

The TikTok Data Skyline — one bar per monthly parquet file|2760|1552
The TikTok Data Skyline — one bar per monthly parquet file|2760|15522760×1552 112 KB

Know what’s blowing up on TikTok — before anyone else

Someone quietly uploaded 5.6 billion TikTok videos’ worth of numbers — every caption, hashtag, sound and view count since 2014 — free for anyone to question. Not watch. Question. Ask it which hashtags won the month, which country is drowning in AI videos, what’s peaking right now.

You don’t need to know SQL. The three lines below are ready — paste one, get an answer in under a minute.

:desktop_computer: The 30-second play

:one: Open the free SQL Console (no account needed)

:two: Paste one of these lines:

:trophy: “What’s winning right now?” — top hashtags by total views, last month:

SELECT list_element(hashtags,1) tag, count(*) n, sum(views) v FROM 'hf://datasets/datasocial/tiktok-5.6B-videos/data/2026-09.parquet' WHERE len(hashtags)>0 AND is_ad=0 GROUP BY 1 ORDER BY v DESC LIMIT 10

:robot: “The AI meter” — how many videos got TikTok’s own AI label:

SELECT count(*) FILTER (WHERE is_ai_generated=1) ai, count(*) total FROM 'hf://datasets/datasocial/tiktok-5.6B-videos/data/2026-09.parquet'

:globe_showing_europe_africa: “Where does AI slop flood?” — AI-labeled videos per country:

SELECT country, count(*) n FROM 'hf://datasets/datasocial/tiktok-5.6B-videos/data/2026-09.parquet' WHERE is_ai_generated=1 GROUP BY 1 ORDER BY n DESC LIMIT 10

:three: Read the answer. Teaser: September alone = 3.4 million AI-labeled videos (3.4% of everything posted) — and nobody published that number anywhere. You just made it up yourself.

:musical_note: The edge worth knowing

Sounds break days before songs do — the count of videos using a sound is the earliest signal on the platform. The dataset’s creator wrote it up: Tracking a Billion TikTok Sounds. Best free read this month.

For a hashtag’s full life story — rise, peak, death, revival — the same console goes back to 2014. No marketing agency sells this depth. Nobody has published on this dump yet: every number you pull is first-mover territory.

:round_pushpin: Source: huggingface.co/datasets/datasocial/tiktok-5.6B-videos · 460 GB if you want it all · free for research & tinkering (CC BY-NC)

:warning: Fine print: metadata only — no video files · old rows have gaps · counts are snapshots, not live.

Paste a line. Be the one who knew. :shovel:

:label: all 3 queries verified live 14 Nov 2026 · links checked · CC BY-NC honored