MyAnimeList Comment Dataset V2 (MALCoDv2)
220K commnets with ratings from MyAnimeList.net as 2023.
@kaggle.natlee_myanimelist_comment_dataset_v2
220K commnets with ratings from MyAnimeList.net as 2023.
@kaggle.natlee_myanimelist_comment_dataset_v2
CREATE TABLE reviews (
"id" BIGINT,
"workid" BIGINT,
"url" VARCHAR,
"workname" VARCHAR,
"posttime" TIMESTAMP,
"episodesseen" VARCHAR,
"overallrating" BIGINT,
"author" VARCHAR,
"reviewid" BIGINT,
"review" VARCHAR,
"recommendationstatus" VARCHAR,
"nice" BIGINT,
"loveit" BIGINT,
"funny" BIGINT,
"confusing" BIGINT,
"informative" BIGINT,
"wellwritten" BIGINT,
"creative" BIGINT
);
CREATE TABLE anime_list (
"id" BIGINT,
"workid" BIGINT,
"url" VARCHAR,
"jpname" VARCHAR,
"engname" VARCHAR,
"synonymsname" VARCHAR,
"worktype" VARCHAR,
"episodes" VARCHAR,
"status" VARCHAR,
"aired" VARCHAR,
"premiered" VARCHAR,
"producer" VARCHAR,
"broadcast" VARCHAR,
"licensors" VARCHAR,
"studios" VARCHAR,
"genres" VARCHAR,
"themes" VARCHAR,
"demographic" VARCHAR,
"source" VARCHAR,
"duration" VARCHAR,
"rating" VARCHAR,
"score" DOUBLE,
"allrank" VARCHAR,
"popularityrank" VARCHAR,
"members" BIGINT,
"favorites" BIGINT,
"scoredbyuser" DOUBLE,
"lastupdate" TIMESTAMP
);
Anyone who has the link will be able to view this.