Recently searched:

Tiktok Database [50gb unzip]Json No Pass Mix 

can u send again please
 
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. ***
ok let's check
 
Thanks a lot for sharing.
 
Thz dor.share
 
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. ***
ok let's check
 
Thanks for the post keep
Post automatically merged:

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. ***
great jop , Thanks
 
its great thanks 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 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. ***
 
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 sir
 
Thanks for this!
 
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. ***
GREAT. thanks
 
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. ***
Looking forward to it
 
thanks very much
 
Home Register
Top Bottom