Xiaohongshu-AIGC-comments (including Posts)dataset
Xiaohongshu-AIGC-comments
@kaggle.yuanchunhong_xiaohongshu_aigc_comments_including_postsdataset
Xiaohongshu-AIGC-comments
@kaggle.yuanchunhong_xiaohongshu_aigc_comments_including_postsdataset
CREATE TABLE comments_additional (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" DOUBLE,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" DOUBLE,
"like_count" DOUBLE,
"sentiment" VARCHAR
);
CREATE TABLE comments_advertising_planning (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" DOUBLE,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" DOUBLE,
"like_count" DOUBLE,
"sentiment" VARCHAR
);
CREATE TABLE comments_brand_marketing (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" BIGINT,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" BIGINT,
"like_count" BIGINT,
"sentiment" VARCHAR
);
CREATE TABLE comments_car (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" BIGINT,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" BIGINT,
"like_count" BIGINT,
"sentiment" VARCHAR
);
CREATE TABLE comments_drawing (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" BIGINT,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" BIGINT,
"like_count" VARCHAR,
"sentiment" VARCHAR
);
CREATE TABLE comments_fashion (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" BIGINT,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" BIGINT,
"like_count" VARCHAR,
"sentiment" VARCHAR
);
CREATE TABLE comments_fiction (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" BIGINT,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" BIGINT,
"like_count" BIGINT,
"sentiment" VARCHAR
);
CREATE TABLE comments_food (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" BIGINT,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" BIGINT,
"like_count" BIGINT,
"sentiment" VARCHAR
);
CREATE TABLE comments_food_2 (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" DOUBLE,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" DOUBLE,
"like_count" VARCHAR,
"sentiment" VARCHAR
);
CREATE TABLE comments_food_additional (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" BIGINT,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" BIGINT,
"like_count" BIGINT,
"sentiment" VARCHAR
);
CREATE TABLE comments_literature (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" BIGINT,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" BIGINT,
"like_count" BIGINT,
"sentiment" VARCHAR
);
CREATE TABLE comments_sport (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" DOUBLE,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" DOUBLE,
"like_count" VARCHAR,
"sentiment" VARCHAR
);
CREATE TABLE comments_sport_additional (
"comment_id" VARCHAR,
"create_time" DOUBLE,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" DOUBLE,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" DOUBLE,
"like_count" DOUBLE,
"sentiment" VARCHAR
);
CREATE TABLE comments_technological_development (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" BIGINT,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" BIGINT,
"like_count" VARCHAR,
"sentiment" VARCHAR
);
CREATE TABLE comments_technology_outlook (
"comment_id" VARCHAR,
"create_time" BIGINT,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" BIGINT,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" BIGINT,
"like_count" BIGINT,
"sentiment" VARCHAR
);
CREATE TABLE post_additional (
"comment_id" VARCHAR,
"create_time" VARCHAR,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" DOUBLE,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" DOUBLE,
"like_count" DOUBLE
);
CREATE TABLE post_advertising_planning (
"comment_id" VARCHAR,
"create_time" VARCHAR,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" DOUBLE,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" DOUBLE,
"like_count" DOUBLE
);
CREATE TABLE post_brand_marketing (
"comment_id" VARCHAR,
"create_time" VARCHAR,
"ip_location" VARCHAR,
"note_id" VARCHAR,
"content" VARCHAR,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"sub_comment_count" VARCHAR,
"pictures" VARCHAR,
"parent_comment_id" VARCHAR,
"last_modify_ts" VARCHAR,
"like_count" VARCHAR
);
CREATE TABLE post_car (
"note_id" VARCHAR,
"type" VARCHAR,
"title" VARCHAR,
"desc" VARCHAR,
"video_url" VARCHAR,
"time" BIGINT,
"last_update_time" BIGINT,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"liked_count" VARCHAR,
"collected_count" VARCHAR,
"comment_count" BIGINT,
"share_count" VARCHAR,
"ip_location" VARCHAR,
"image_list" VARCHAR,
"tag_list" VARCHAR,
"last_modify_ts" BIGINT,
"note_url" VARCHAR,
"source_keyword" VARCHAR
);
CREATE TABLE post_drawing (
"note_id" VARCHAR,
"type" VARCHAR,
"title" VARCHAR,
"desc" VARCHAR,
"video_url" VARCHAR,
"time" BIGINT,
"last_update_time" BIGINT,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"liked_count" VARCHAR,
"collected_count" VARCHAR,
"comment_count" BIGINT,
"share_count" BIGINT,
"ip_location" VARCHAR,
"image_list" VARCHAR,
"tag_list" VARCHAR,
"last_modify_ts" BIGINT,
"note_url" VARCHAR,
"source_keyword" VARCHAR
);
CREATE TABLE post_fashion (
"note_id" VARCHAR,
"type" VARCHAR,
"title" VARCHAR,
"desc" VARCHAR,
"video_url" VARCHAR,
"time" BIGINT,
"last_update_time" BIGINT,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"liked_count" VARCHAR,
"collected_count" VARCHAR,
"comment_count" VARCHAR,
"share_count" VARCHAR,
"ip_location" VARCHAR,
"image_list" VARCHAR,
"tag_list" VARCHAR,
"last_modify_ts" BIGINT,
"note_url" VARCHAR,
"source_keyword" VARCHAR
);
CREATE TABLE post_fiction (
"note_id" VARCHAR,
"type" VARCHAR,
"title" VARCHAR,
"desc" VARCHAR,
"video_url" VARCHAR,
"time" BIGINT,
"last_update_time" BIGINT,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"liked_count" VARCHAR,
"collected_count" VARCHAR,
"comment_count" BIGINT,
"share_count" BIGINT,
"ip_location" VARCHAR,
"image_list" VARCHAR,
"tag_list" VARCHAR,
"last_modify_ts" BIGINT,
"note_url" VARCHAR,
"source_keyword" VARCHAR
);
CREATE TABLE post_food (
"note_id" VARCHAR,
"type" VARCHAR,
"title" VARCHAR,
"desc" VARCHAR,
"video_url" VARCHAR,
"time" BIGINT,
"last_update_time" BIGINT,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"liked_count" VARCHAR,
"collected_count" VARCHAR,
"comment_count" BIGINT,
"share_count" BIGINT,
"ip_location" VARCHAR,
"image_list" VARCHAR,
"tag_list" VARCHAR,
"last_modify_ts" BIGINT,
"note_url" VARCHAR,
"source_keyword" VARCHAR
);
CREATE TABLE post_food_2 (
"note_id" VARCHAR,
"type" VARCHAR,
"title" VARCHAR,
"desc" VARCHAR,
"video_url" VARCHAR,
"time" BIGINT,
"last_update_time" BIGINT,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"liked_count" BIGINT,
"collected_count" BIGINT,
"comment_count" BIGINT,
"share_count" BIGINT,
"ip_location" VARCHAR,
"image_list" VARCHAR,
"tag_list" VARCHAR,
"last_modify_ts" BIGINT,
"note_url" VARCHAR,
"source_keyword" VARCHAR
);
CREATE TABLE post_food_additional (
"note_id" VARCHAR,
"type" VARCHAR,
"title" VARCHAR,
"desc" VARCHAR,
"video_url" VARCHAR,
"time" BIGINT,
"last_update_time" BIGINT,
"user_id" VARCHAR,
"nickname" VARCHAR,
"avatar" VARCHAR,
"liked_count" VARCHAR,
"collected_count" VARCHAR,
"comment_count" BIGINT,
"share_count" BIGINT,
"ip_location" VARCHAR,
"image_list" VARCHAR,
"tag_list" VARCHAR,
"last_modify_ts" BIGINT,
"note_url" VARCHAR,
"source_keyword" VARCHAR
);
Anyone who has the link will be able to view this.