how many users in this scrape?

is it useful?

great share

no sample ?

link is down. Reupload?

(May 6, 2022, 06:48 PM)mitoman101 Wrote: 55GB, (10GB compressed) Tiktok user sql users dump

Good luck



DROP TABLE IF EXISTS `author`;
/*!40101 SET @saved_cs_client    = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE 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`)
) ENGINE=InnoDB AUTO_INCREMENT=32065358 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

in mega.nz after inter this password: get this message
The file you are trying to download is no longer available

please check and upload in another upload center

thank you

(May 7, 2022, 09:08 AM)jacka113 Wrote: how many users in this scrape?

I think this is the same that is freely available (almost) everywhere.

# Tiktok Dataset

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)

The one above is I guess a part of this.

And Mr. Jack, you were to upload oriflame country wise but the main post is now gone :D

(May 10, 2022, 05:37 AM)nobody2390 Wrote: link is down. Reupload?

mega account was banned, i uploaded it with another account.

Please don't state on thread's title this is "Tiktok Users SQL Dump". This ain't shit, nigga. This is just a simple worthless *scrape* done by a monkey.