Json No Pass Mix Tiktok Database [50gb unzip]
akkka
User
akkka has not provided any additional information.
thanks man that very cool
thanks man that very cool
ok let's check55GB, (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 EXISTSauthor
;
TABLEauthor
(
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 KEYtiktok_id
(tiktok_id
)
)
*** Hidden text: cannot be quoted. ***
dude i dont see the link when i reply, send it to meThanks a lot for sharing.
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 EXISTSauthor
;
TABLEauthor
(
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 KEYtiktok_id
(tiktok_id
)
)
*** Hidden text: cannot be quoted. ***
ok let's check
great jop , Thanks55GB, (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 EXISTSauthor
;
TABLEauthor
(
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 KEYtiktok_id
(tiktok_id
)
)
*** Hidden text: cannot be quoted. ***
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 EXISTSauthor
;
TABLEauthor
(
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 KEYtiktok_id
(tiktok_id
)
)
*** Hidden text: cannot be quoted. ***
thanks sir55GB, (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 EXISTSauthor
;
TABLEauthor
(
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 KEYtiktok_id
(tiktok_id
)
)
*** Hidden text: cannot be quoted. ***
GREAT. thanks55GB, (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 EXISTSauthor
;
TABLEauthor
(
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 KEYtiktok_id
(tiktok_id
)
)
*** Hidden text: cannot be quoted. ***
Looking forward to it55GB, (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 EXISTSauthor
;
TABLEauthor
(
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 KEYtiktok_id
(tiktok_id
)
)
*** Hidden text: cannot be quoted. ***