55GB, (10GB compressed) Tiktok user sql users dump
This dataset is metadata for 32,489,068 TikTok videos, scraped between 2020-07-22 and 2020-10-13
The data is available as flat JSON, and as a MySQL database. There are probably minor inconsistancies between the two formats, but they should be 99% similar.
Everything in the JSON file is unaltered response from TikTok, the MySQL database is a bit more trimmed down
## Other Stats
In addition to the videos, there is metadata on:
- 12,382,540 sounds
- 2,533,869 challenges (hashtags)
- 218,479 authors (video creators)
DROP TABLE IF EXISTS
author;
TABLE
author (
id int(11) NOT NULL AUTO_INCREMENT,
tiktok_id bigint(20) unsigned NOT NULL,
uniqueId varchar(1024) NOT NULL,
nickname varchar(1024) NOT NULL,
avatarLarger varchar(2048) NOT NULL,
signature varchar(2048) NOT NULL,
verified varchar(8) NOT NULL,
secUid varchar(2048) NOT NULL,
relation int(11) NOT NULL,
grabTime timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
searchBase varchar(64) NOT NULL,
PRIMARY KEY (
id),
UNIQUE KEY
tiktok_id (
tiktok_id)
)
*** Hidden text: cannot be quoted. ***
