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)

Anime List

@kaggle.natlee_myanimelist_comment_dataset_v2.anime_list

3.33 MB
24594 rows
28 columns

id Id	workid WorkId	url Url	jpname JpName	engname EngName	synonymsname SynonymsName	worktype WorkType	episodes Episodes	status Status	aired Aired	premiered Premiered	producer Producer	broadcast Broadcast	licensors Licensors	studios Studios	genres Genres	themes Themes	demographic Demographic	source Source	duration Duration	rating Rating	score Score	allrank AllRank	popularityrank PopularityRank	members Members	favorites Favorites	scoredbyuser ScoredByUser	lastupdate LastUpdate
1	47917	https://myanimelist.net/anime/47917/Bocchi_the_Rock	ぼっち・ざ・ろっく！	Bocchi the Rock!	nan	TV	12	Finished Airing	Oct 9, 2022 to Dec 25, 2022	Fall 2022	Aniplex, Houbunsha	Sundays at 00:00 (JST)	add some	CloverWorks	Comedy	CGDCT, Music	nan	4-koma manga	23 min. per ep.	PG-13 - Teens 13 or older	8.86	#27	#509	415475	20435	241578	Fri Jun 02 2023 00:11:01 GMT+0000 (Coordinated Universal Time)
2	19	https://myanimelist.net/anime/19/Monster	モンスター	Monster	nan	TV	74	Finished Airing	Apr 7, 2004 to Sep 28, 2005	Spring 2004	VAP, Shogakukan-Shueisha Productions, Nippon Television Network	Wednesdays at 00:40 (JST)	VIZ Media	Madhouse	Drama, Mystery, Suspense	Adult Cast, Psychological	Seinen	Manga	24 min. per ep.	R+ - Mild Nudity	8.87	#26	#142	1006450	46856	365316	Fri Jun 02 2023 00:11:10 GMT+0000 (Coordinated Universal Time)
3	35247	https://myanimelist.net/anime/35247/Owarimonogatari_2nd_Season	終物語	Owarimonogatari Second Season	End Story 2nd Season	TV	7	Finished Airing	Aug 12, 2017 to Aug 13, 2017	Summer 2017	Aniplex, Kodansha	Not scheduled once per week	Aniplex of America	Shaft	Comedy, Mystery, Supernatural	Vampire	nan	Light novel	22 min. per ep.	R - 17+ (violence & profanity)	8.88	#25	#567	379309	8444	182679	Fri Jun 02 2023 00:11:19 GMT+0000 (Coordinated Universal Time)
4	37491	https://myanimelist.net/anime/37491/Gintama__Shirogane_no_Tamashii-hen_-_Kouhan-sen	銀魂. 銀ノ魂篇後半戦	Gintama.: Silver Soul Arc - Second Half War	Gintama.: Silver Soul Arc 2	TV	14	Finished Airing	Jul 9, 2018 to Oct 8, 2018	Summer 2018	TV Tokyo, Aniplex, Dentsu, Shueisha	Mondays at 01:35 (JST)	add some	Bandai Namco Pictures	Action, Comedy, Sci-Fi	Gag Humor, Historical, Parody, Samurai	Shounen	Manga	24 min. per ep.	PG-13 - Teens 13 or older	8.88	#24	#1186	184986	1018	89095	Fri Jun 02 2023 00:11:30 GMT+0000 (Coordinated Universal Time)
5	52198	https://myanimelist.net/anime/52198/Kaguya-sama_wa_Kokurasetai__First_Kiss_wa_Owaranai	かぐや様は告らせたい -ファーストキッスは終わらない-	Kaguya-sama: Love is War - The First Kiss That Never Ends	nan	Movie	1	Finished Airing	Dec 17, 2022	nan	Aniplex, Mainichi Broadcasting System, Shueisha, JR East Marketing & Communications	nan	Aniplex of America	A-1 Pictures	Comedy, Drama, Romance	School	Seinen	Manga	1 hr. 36 min.	PG-13 - Teens 13 or older	8.89	#23	#1270	173642	1305	77107	Fri Jun 02 2023 00:11:35 GMT+0000 (Coordinated Universal Time)
6	37987	https://myanimelist.net/anime/37987/Violet_Evergarden_Movie	劇場版ヴァイオレット・エヴァーガーデン	Violet Evergarden: The Movie	Gekijouban Violet Evergarden	Movie	1	Finished Airing	Sep 18, 2020	nan	Shochiku, ABC Animation	nan	Funimation	Kyoto Animation	Award Winning, Drama, Fantasy	nan	nan	Light novel	2 hr. 20 min.	PG-13 - Teens 13 or older	8.9	#22	#369	543754	8122	236908	Fri Jun 02 2023 00:11:44 GMT+0000 (Coordinated Universal Time)
7	15335	https://myanimelist.net/anime/15335/Gintama_Movie_2__Kanketsu-hen_-_Yorozuya_yo_Eien_Nare	劇場版銀魂完結篇万事屋よ永遠なれ	Gintama: The Movie: The Final Chapter: Be Forever Yorozuya	Gintama: The Final Chapter - Be Forever Yorozuya, Gintama Movie 2	Movie	1	Finished Airing	Jul 6, 2013	nan	TV Tokyo, Aniplex, Dentsu, Bandai, Warner Bros. Japan, Shueisha	nan	add some	Sunrise	Action, Comedy, Sci-Fi	Gag Humor, Historical, Parody, Samurai, Time Travel	Shounen	Manga	1 hr. 50 min.	PG-13 - Teens 13 or older	8.91	#21	#975	228655	2086	129356	Fri Jun 02 2023 00:11:51 GMT+0000 (Coordinated Universal Time)
8	2904	https://myanimelist.net/anime/2904/Code_Geass__Hangyaku_no_Lelouch_R2	コードギアス反逆のルルーシュ続編	Code Geass: Lelouch of the Rebellion R2	Code Geass: Hangyaku no Lelouch 2nd Season, Code Geass: Hangyaku no Lelouch Second Season	TV	25	Finished Airing	Apr 6, 2008 to Sep 28, 2008	Spring 2008	Bandai Visual, Mainichi Broadcasting System, Bandai, Bandai Namco Entertainment, Hakuhodo DY Media Partners	Sundays at 17:00 (JST)	Funimation, Bandai Entertainment	Sunrise	Action, Award Winning, Drama, Sci-Fi	Mecha, Military, Super Power	nan	Original	24 min. per ep.	R - 17+ (violence & profanity)	8.91	#20	#47	1694846	74445	1142380	Fri Jun 02 2023 00:12:00 GMT+0000 (Coordinated Universal Time)
9	4181	https://myanimelist.net/anime/4181/Clannad__After_Story	CLANNAD〜AFTER STORY〜クラナドアフターストーリー	Clannad: After Story	nan	TV	24	Finished Airing	Oct 3, 2008 to Mar 27, 2009	Fall 2008	Pony Canyon, TBS, Rakuonsha, Animation Do	Fridays at 01:59 (JST)	Sentai Filmworks	Kyoto Animation	Drama, Romance, Supernatural	nan	nan	Visual novel	24 min. per ep.	PG-13 - Teens 13 or older	8.93	#19	#113	1147308	68857	638545	Fri Jun 02 2023 00:12:10 GMT+0000 (Coordinated Universal Time)
10	35180	https://myanimelist.net/anime/35180/3-gatsu_no_Lion_2nd_Season	3月のライオン第2シリーズ	March Comes In Like A Lion 2nd Season	Sangatsu no Lion Second Season	TV	22	Finished Airing	Oct 14, 2017 to Mar 31, 2018	Fall 2017	Aniplex, Dentsu, NHK, Hakusensha, Asmik Ace, Toy's Factory	Saturdays at 23:00 (JST)	Aniplex of America	Shaft	Drama	Childcare, Iyashikei, Strategy Game	Seinen	Manga	25 min. per ep.	PG-13 - Teens 13 or older	8.93	#18	#554	382623	14827	190360	Fri Jun 02 2023 00:12:21 GMT+0000 (Coordinated Universal Time)


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