124.5 billion rows of TikTok data
4.1B creators · 5.5B videos · 604M sounds · 113.7B follows, with daily history
TutorialLearn how to scrape billions of TikTok records per day →Questions you can run now
Who are the biggest creators in the US?
Which countries have the most creators with 1M+ followers?
Which sounds added the most videos this week, with their 30-day history?
Which sounds are rising fastest this week?
Which US videos are going viral right now?
Which sounds are used in the most videos?
Tables
creatorsEvery TikTok creator we have seen: profile, counts, verification, links, business info for creators we have read in depth, and whether they list a contact email (the address itself is premium and not readable here). tracked = 1 means we read the creator every day.
soundsEvery sound seen on a video: title, artist, owner, originality, commercial rights, TikTok matching, Spotify/Apple ids, video count.
videosVideos with caption, hashtags, sound, ad / branded / shop / AI flags and engagement.
creator_historyDaily followers, following, videos and likes: totals on that day (growth = the change between two days, divided by the earlier day).
video_historyViews, likes, comments, shares, saves over a video's first 90 days: totals at that day's read (gained = the change between two days).
sound_historyEach sound's total video count on each day (a running total: new videos = the change between two days, never a sum).
followsWho one creator follows: every account on their following list, with its handle and follower count. Call it with a creator id: SELECT * FROM tiktok.follows(creator_id = 6596805238354558982). Find the id with SELECT creator_id FROM tiktok.creators WHERE username = 'kimberly.loaiza'.
tiktok.creators
tiktok.creators
tiktok.sound_history
tiktok.videos