Popular TikTok Videos, Authors, And Musics
A Comprehensive Dataset for performing Trending Analysis
@kaggle.thedevastator_popular_tiktok_videos_authors_and_musics
A Comprehensive Dataset for performing Trending Analysis
@kaggle.thedevastator_popular_tiktok_videos_authors_and_musics
CREATE TABLE tiktok_collected_liked_videos (
"user_name" VARCHAR,
"user_id" BIGINT,
"video_id" BIGINT,
"video_desc" VARCHAR,
"video_time" BIGINT,
"video_length" BIGINT,
"video_link" VARCHAR,
"n_likes" BIGINT,
"n_shares" BIGINT,
"n_comments" BIGINT,
"n_plays" BIGINT
);
CREATE TABLE tiktok_collected_videos (
"user_name" VARCHAR,
"user_id" BIGINT,
"video_id" BIGINT,
"video_desc" VARCHAR,
"video_time" BIGINT,
"video_length" BIGINT,
"video_link" VARCHAR,
"n_likes" BIGINT,
"n_shares" BIGINT,
"n_comments" BIGINT,
"n_plays" BIGINT
);
CREATE TABLE tiktok_funny_hashtag_videos (
"author_id" BIGINT,
"author_uniqueid" VARCHAR,
"author_nickname" VARCHAR,
"author_avatarthumb" VARCHAR,
"author_signature" VARCHAR,
"author_verification" BOOLEAN,
"author_privateaccount" BOOLEAN,
"author_followingcount" BIGINT,
"author_followercount" BIGINT,
"author_heartcount" BIGINT,
"author_videocount" BIGINT,
"author_diggcount" BIGINT,
"author_heart" BIGINT,
"video_id" BIGINT,
"video_desc" VARCHAR,
"video_duration" BIGINT,
"video_cover" VARCHAR,
"video_link" VARCHAR,
"video_format" VARCHAR,
"video_quality" VARCHAR,
"video_definition" VARCHAR,
"video_stats" BIGINT,
"video_sharecount" BIGINT,
"video_commentcount" BIGINT,
"video_playcount" BIGINT,
"video_originalitem" BOOLEAN,
"video_officialitem" BOOLEAN,
"video_secret" BOOLEAN,
"video_forfriend" BOOLEAN,
"video_stitchenabled" BOOLEAN,
"video_shareenabled" BOOLEAN,
"video_isad" BOOLEAN,
"music_id" BIGINT,
"music_title" VARCHAR,
"music_playurl" VARCHAR,
"music_coverthumb" VARCHAR,
"music_authorname" VARCHAR,
"music_originality" BOOLEAN,
"music_duration" BIGINT
);
CREATE TABLE trending_authors (
"unnamed_0" BIGINT,
"author_unique_id" VARCHAR,
"author_nickname" VARCHAR,
"avatar_thumbnail" VARCHAR,
"signature" VARCHAR,
"verified" BOOLEAN,
"private_account" BOOLEAN
);
CREATE TABLE trending_videos (
"user_name" VARCHAR,
"user_id" BIGINT,
"video_id" BIGINT,
"video_desc" VARCHAR,
"video_time" BIGINT,
"video_length" BIGINT,
"video_link" VARCHAR,
"n_likes" BIGINT,
"n_shares" BIGINT,
"n_comments" BIGINT,
"n_plays" BIGINT
);
Anyone who has the link will be able to view this.