MyAnimeList Comment Dataset V2 (MALCoDv2)

220K commnets with ratings from MyAnimeList.net as 2023.

@kaggle.natlee_myanimelist_comment_dataset_v2

Table List

2 tables(344.29 MB)

Reviews

@kaggle.natlee_myanimelist_comment_dataset_v2.reviews

340.96 MB
224641 rows
18 columns

id Id	workid WorkId	url Url	workname WorkName	posttime PostTime	episodesseen EpisodesSeen	overallrating OverallRating	author Author	reviewid ReviewId	review Review	recommendationstatus RecommendationStatus	nice Nice	confusing Confusing
155870	196	https://myanimelist.net/anime/196/Onegai%E2%98%86Twins/reviews?sort=newest&filter_check=&filter_hide=&preliminary=on&spoiler=on&p=2	Onegai%E2%98%86Twins	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	7	CapitalJ	3533	The plot is pretty interesting at first but I must say that it wasn't that special. It's pretty much your "short anime". No "twist" until the final two episodes really. But the story is rather nice, although I must say you could watch the first two episodes and the final two and …	Recommended	6
245390	934	https://myanimelist.net/anime/934/Higurashi_no_Naku_Koro_ni/reviews?sort=newest&filter_check=&filter_hide=&preliminary=on&spoiler=on&p=17	Higurashi_no_Naku_Koro_ni	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	10	merQree	3538	I haven't watched many anime's yet but so far this one beats everything i've ever watched. It is kinda similar with Elfen Lied as they say but i believe it's unique. I watched both seasons in 2 days so this gotta be something right? Plus the whole atmosphere just makes you stunned and you cannot tu…	Recommended	9
269080	3229	https://myanimelist.net/anime/3229/Kimi_ga_Aruji_de_Shitsuji_ga_Ore_de/reviews?sort=newest&filter_check=&filter_hide=&preliminary=on&spoiler=on	Kimi_ga_Aruji_de_Shitsuji_ga_Ore_de	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	8	Master10K	3525	They Are My Noble Masters is a Harem, Ecchi, Romance, Comedy that pays more attention to its extremely ecchi fanservice rather than the actual romance or comedy. The series is about a brother and sister (Ren and Mihato) who ran away from home in order to start a new life together and after a turn…	Recommended	65
280755	1682	https://myanimelist.net/anime/1682/Baldr_Force_Exe_Resolution/reviews?sort=newest&filter_check=&filter_hide=&preliminary=on&spoiler=on	Baldr_Force_Exe_Resolution	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	9	Spades-Deuce	3528	BALDR FORCE EXE Resolution is one of the those fantastic OVA series that is severely overlooked by the vast amount of people who watch anime. It has wonderful art, a decent storyline, and good characters. STORY: The series is about a man, Tooru, who has lost everything (won't spoil ;p) and joins…	Recommended	52
291553	1751	https://myanimelist.net/anime/1751/Jikuu_Bouken_Nuumamonjaa/reviews?sort=newest&filter_check=&filter_hide=&preliminary=on&spoiler=on	Jikuu_Bouken_Nuumamonjaa	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	8	Virgil	3526	This is actually one of my favorite comedy-based OVA's. There are parts within, such as Gato screaming the same thing over and over, or Johnny's inside humor. If you're looking for the original characters of the SNES video game, you won't find them until the very end. Actually, you will only see the…	Recommended	17
416575	1637	https://myanimelist.net/anime/1637/Kaze_to_Ki_no_Uta_Sanctus__Sei_Naru_Kana/reviews?sort=newest&filter_check=&filter_hide=&preliminary=on&spoiler=on	Kaze_to_Ki_no_Uta_Sanctus__Sei_Naru_Kana	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	9	Ryosei_Hime	3536	I thought this to be a beautiful yaoi in my own personal opinion. I was completely engrossed with the character Gilbert and I would love to read the manga if I could find it. The story was very interesting - hence my wanting to read the manga - and I love the time period it's set in. I've read plent…	Recommended	37
435955	264	https://myanimelist.net/anime/264/Hajime_no_Ippo__Champion_Road/reviews?sort=newest&filter_check=&filter_hide=&preliminary=on&spoiler=on	Hajime_no_Ippo__Champion_Road	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	9	jknaruto	3531	This movie was great!!!! It was almost as great as when he won the title, in this movie you see the reason why he loves boxing and what it means to be strong, i personally liked this a lot, he defends his title and and also fights for his love, so please watch and comment on it.Now i wanna see the f…	Recommended	26	1
539106	177	https://myanimelist.net/anime/177/Tsubasa_Chronicle/reviews?sort=newest&filter_check=&filter_hide=&preliminary=on&spoiler=on&p=2	Tsubasa_Chronicle	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	7	Shakesgrl20	3530	I watched the OVA first before seeing this so thought to give this a chance on what its albout. Most fans are negative about it which is true but i happened to enjoyed it a bit. Not a masterpiece anime work but good watch with your whole family. Plan to have my future kids watch this show whenever …	Recommended	4
626086	2581	https://myanimelist.net/anime/2581/Kidou_Senshi_Gundam_00/reviews?sort=newest&filter_check=&filter_hide=&preliminary=on&spoiler=on&p=4	Kidou_Senshi_Gundam_00	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	8	OtakuFreak	3540	Well, it's truely been a while since I wrote a Gundam review. Yes, I've basically written a review for nearly every Gundam series for those who don't keep tabs on my Reviews. But lets get to the point shall we? Over the past few years the Gundam series has gone through a lot of riticule by many …	Recommended	13
642945	1594	https://myanimelist.net/anime/1594/Jigoku_Shoujo_Futakomori/reviews?sort=newest&filter_check=&filter_hide=&preliminary=on&spoiler=on&p=1	Jigoku_Shoujo_Futakomori	Tue Apr 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	8	fr0z3nshad3	3532	Story (7.7) - Well, this aspect is like the first season of this anime. Each episode has an own story, and theres almost no sequence till the last episodes. However, in this season the episodes are much less formulatic, i mean, in this one they give us new situations and the end is not always the sa…	Recommended	7


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
);