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
This dataset is collected from the Xiaohongshu (Little Red Book) platform, focusing on user-generated content about Artificial Intelligence-Generated Content (AIGC). It covers various categories, including advertisement, automotive, fashion, food, literature, printing, sports, and technology. The dataset contains user comments and posts, with information such as user IDs, content, timestamps, likes, and sentiment analysis, which can be used to analyze public perceptions and attitudes toward AIGC.
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
);CREATE TABLE post_literature (
"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" 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_sport (
"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" BIGINT,
"ip_location" VARCHAR,
"image_list" VARCHAR,
"tag_list" VARCHAR,
"last_modify_ts" BIGINT,
"note_url" VARCHAR,
"source_keyword" VARCHAR
);CREATE TABLE post_sport_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" BIGINT,
"collected_count" BIGINT,
"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_technological_development (
"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" 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_technology_outlook (
"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.