Tiktok Database [50gb unzip] Json No Pass Mix

[domefavor108]

Goooood source

 

[fdhtythtyhj]

thx cool

 

[brembo]

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. ***

Thanks for the post keep it up I wish you luck

 

[bahlol]

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. ***

 

[Angelu]

I would like to know more about this, thank you!

 

[searcher1122]

thanks man

 

[mefixs]

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. ***

thank you for share

 

[theattack]

amazing , keep it up

 

[nps999]

amazing , keep it up

 

[su007]

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. ***

Thanks for the share mate.....

 

[0xmeth]

well done

 

[pyrosophy]

Very nice, thanks !

 

[darkontop1]

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. ***

 

[joshy]

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. ***

hai
have a nice day

 

[w4lk3r2]

thanks goood

 

[fr3on]

thank you for sharing let's look that

 

[tasleaksto]

let me see is it ok

 

[kdndgm]

thank you for share