Tables

Everything lives in one database, tiktok. Each table answers a different kind of question. Open one to see example questions you can run, and every column.

Latest state

One row per creator, video or sound, as it is now.

creators

Who is big on TikTok, where they are, what they do, and whether they list a business email.

…

sounds

Which songs and original sounds exist, who made them, and how many videos use each one.

…

videos

What tracked creators post: captions, hashtags, the sound used, views, likes and ad or shop flags.

…

History

How numbers changed: one row per day or hour, never rewritten.

creator_history

How a tracked creator's followers, videos and likes change from one day to the next.

…

video_history

How a tracked creator's video gains views and likes, day by day for its first 30 days, then week by week to day 90.

…

sound_history

How many videos used a sound on each day, since January 2026 (with a gap from mid-May to September): which sounds are rising or fading.

…