Baselight
Sign In

MyAnimeList Dataset

contains 300k users, 14k anime metadata, and 80mil. ratings from MyAnimeList.net

@kaggle.azathoth42_myanimelist

Anime Cleaned
@kaggle.azathoth42_myanimelist.anime_cleaned

  • 2.41 MB
  • 6668 rows
  • 33 columns
anime_id

Anime Id

title

Title

title_english

Title English

title_japanese

Title Japanese

title_synonyms

Title Synonyms

image_url

Image Url

type

Type

source

Source

episodes

Episodes

status

Status

airing

Airing

aired_string

Aired String

aired

Aired

duration

Duration

rating

Rating

score

Score

scored_by

Scored By

rank

Rank

popularity

Popularity

members

Members

favorites

Favorites

background

Background

premiered

Premiered

broadcast

Broadcast

related

Related

producer

Producer

licensor

Licensor

studio

Studio

genre

Genre

opening_theme

Opening Theme

ending_theme

Ending Theme

duration_min

Duration Min

aired_from_year

Aired From Year

11013Inu x Boku SSInu X Boku Secret Service妖狐×僕SSYouko x Boku SShttps://myanimelist.cdn-dena.com/images/anime/12/35893.jpgTVManga12Finished AiringJan 13, 2012 to Mar 30, 2012{'from': '2012-01-13', 'to': '2012-03-30'}24 min. per ep.PG-13 - Teens 13 or older7.6313925012742312838822809Inu x Boku SS was licensed by Sentai Filmworks for North America, while MVM Films licensed it for the United Kingdom. During April 2013, Hanabee Entertainment released the series on DVD and Blu-ray for Australia and New Zealand.Winter 2012Fridays at Unknown{'Adaptation': [{'mal_id': 17207, 'type': 'manga', 'url': 'https://myanimelist.net/manga/17207/Inu_x_Boku_SS', 'title': 'Inu x Boku SS'}], 'Sequel': [{'mal_id': 13403, 'type': 'anime', 'url': 'https://myanimelist.net/anime/13403/Inu_x_Boku_SS_Special', 'title': 'Inu x Boku SS Special'}]}Aniplex, Square Enix, Mainichi Broadcasting System, Movic, Inu x Boku SS Production PartnersSentai FilmworksDavid ProductionComedy, Supernatural, Romance, Shounen['"Nirvana" by MUCC']['#1: "Nirvana" by MUCC (eps 1, 11-12)', '#2: "Rakuen no Photograph (楽園のPhotograph)" by Soushi Miketsukami (Yuichi Nakamura) (eps 2, 9)', '#3: "Kimi wa (君は)" by Ririchiyo Shirakiin (Rina Hidaka) (eps 3, 8)', '#4: "one way" by Banri Watanuki (Takuya Eguchi) & Zange Natsume (Mamoru Miyano) (ep 4)', '#…242012
2104Seto no HanayomeMy Bride is a Mermaid瀬戸の花嫁The Inland Sea Bridehttps://myanimelist.cdn-dena.com/images/anime/13/58383.jpgTVManga26Finished AiringApr 2, 2007 to Oct 1, 2007{'from': '2007-04-02', 'to': '2007-10-01'}24 min. per ep.PG-13 - Teens 13 or older7.89912067273662040032579nanSpring 2007Unknown{'Adaptation': [{'mal_id': 759, 'type': 'manga', 'url': 'https://myanimelist.net/manga/759/Seto_no_Hanayome', 'title': 'Seto no Hanayome'}], 'Sequel': [{'mal_id': 4163, 'type': 'anime', 'url': 'https://myanimelist.net/anime/4163/Seto_no_Hanayome_OVA', 'title': 'Seto no Hanayome OVA'}], 'Side story':…TV Tokyo, AIC, Square Enix, SotsuFunimationGonzoComedy, Parody, Romance, School, Shounen['"Romantic summer" by SUN&LUNAR']['#1: "Ashita e no Hikari (明日への光)" by Asuka Hinoi (1-13, 26)', '#2: "Dan Dan Dan" by SUN&LUNAR (eps 14-25)']242007
5262Shugo Chara!! DokiShugo Chara!! Dokiしゅごキャラ！！どきっShugo Chara Ninenme, Shugo Chara! Second Yearhttps://myanimelist.cdn-dena.com/images/anime/11/10645.jpgTVManga51Finished AiringOct 4, 2008 to Sep 25, 2009{'from': '2008-10-04', 'to': '2009-09-25'}24 min. per ep.PG - Children7.55371291508117370127802nanFall 2008Unknown{'Adaptation': [{'mal_id': 101, 'type': 'manga', 'url': 'https://myanimelist.net/manga/101/Shugo_Chara', 'title': 'Shugo Chara!'}], 'Prequel': [{'mal_id': 2923, 'type': 'anime', 'url': 'https://myanimelist.net/anime/2923/Shugo_Chara', 'title': 'Shugo Chara!'}], 'Sequel': [{'mal_id': 7082, 'type': 'a…TV Tokyo, SotsunanSatelightComedy, Magic, School, Shoujo['#1: "Minna no Tamago (みんなのたまご)" by Shugo Chara Egg (eps 1-13)', '#2: "Shugo Shugo! (しゅごしゅご!)" by Shugo Chara Egg (eps 14-25)', '#3: "Omakase♪Guardian (おまかせ♪ガーディアン)" by Guardians 4 (eps 26-38)', '#4: "School Days" by Guardians 4 (eps 39-51)']['#1: "Rottara Rottara (ロッタラ ロッタラ)" by Buono! (eps 1-17)', '#2: "co.no.mi.chi" Buono! (eps 18-25)', '#3: "MY BOY" by Buono! (eps 26-38)', '#4: "Take it Easy!" by Buono! (eps. 39-50)', '#5: "Honto no Jibun (ホントのじぶん)" by Buono! (ep 51)']242008
721Princess TutuPrincess Tutuプリンセスチュチュnanhttps://myanimelist.cdn-dena.com/images/anime/13/32209.jpgTVOriginal38Finished AiringAug 16, 2002 to May 23, 2003{'from': '2002-08-16', 'to': '2003-05-23'}16 min. per ep.PG-13 - Teens 13 or older8.2136501307916933123344Princess Tutu aired in two parts. The first part included 13 25-minute-long episodes, while the second part consisted of 24 12-minute-long episodes with a 25-minute-long final episode for a total of 25 episodes.Summer 2002Fridays at Unknown{'Adaptation': [{'mal_id': 1581, 'type': 'manga', 'url': 'https://myanimelist.net/manga/1581/Princess_Tutu', 'title': 'Princess Tutu'}], 'Summary': [{'mal_id': 3265, 'type': 'anime', 'url': 'https://myanimelist.net/anime/3265/Princess_Tutu_Recaps', 'title': 'Princess Tutu Recaps'}]}Memory-Tech, GANSIS, Marvelous AQLADV FilmsHal Film MakerComedy, Drama, Magic, Romance, Fantasy['"Morning Grace" by Ritsuko Okazaki']['"Watashi No Ai Wa Chiisaikeredo" by Ritsuko Okazaki']162002
12365Bakuman. 3rd SeasonBakuman.バクマン。Bakuman Season 3https://myanimelist.cdn-dena.com/images/anime/6/41845.jpgTVManga25Finished AiringOct 6, 2012 to Mar 30, 2013{'from': '2012-10-06', 'to': '2013-03-30'}24 min. per ep.PG-13 - Teens 13 or older8.67107767504261827652082nanFall 2012Unknown{'Adaptation': [{'mal_id': 9711, 'type': 'manga', 'url': 'https://myanimelist.net/manga/9711/Bakuman', 'title': 'Bakuman.'}], 'Prequel': [{'mal_id': 10030, 'type': 'anime', 'url': 'https://myanimelist.net/anime/10030/Bakuman_2nd_Season', 'title': 'Bakuman. 2nd Season'}, {'mal_id': 15711, 'type': 'an…NHK, ShueishananJ.C.StaffComedy, Drama, Romance, Shounen['#1: "Moshimo no Hanashi (もしもの話)" by nano.RIPE (eps 1-13)', '#2: "23:40 (23時40分) feat. Base Ball Bear" by Hyadain (eps 14-25)']['#1: "Pride on Everyday" by Sphere (eps 1-13)', '#2: "Yume Sketch (夢スケッチ)" by JAM Project (eps 14-24)', '#3: "Moshimo no Hanashi (もしもの話)" by nano.RIPE (ep 25)']242012
6586Yume-iro Pâtissièrenan夢色パティシエールYumeiro Patissiere, YumePati, Dream-Colored Pastry Chef, Yumeiro Pâtissièrehttps://myanimelist.cdn-dena.com/images/anime/12/21674.jpgTVManga50Finished AiringOct 4, 2009 to Sep 26, 2010{'from': '2009-10-04', 'to': '2010-09-26'}24 min. per ep.G - All Ages8.0321618526163045625826nanFall 2009Unknown{'Adaptation': [{'mal_id': 10386, 'type': 'manga', 'url': 'https://myanimelist.net/manga/10386/Yume-iro_Pâtissière', 'title': 'Yume-iro Pâtissière'}], 'Side story': [{'mal_id': 8894, 'type': 'anime', 'url': 'https://myanimelist.net/anime/8894/Yume-iro_Pâtissière__Mune_Kyun_Tropical_Island', 'title':…Yomiuri Telecasting, DAX Production, ShueishananStudio Pierrot, Studio HibariKids, School, Shoujo['"Yume ni Yell! Patissiere♪ (夢にエール！パティシエール♪)" by Mayumi Gojou']['"Ichigo no Miracle (いちごのミラクルール)" by Yukina Sugihara']242009
178Ultra ManiacUltramaniac - Magical Girlウルトラマニアックnanhttps://myanimelist.cdn-dena.com/images/anime/8/53571.jpgTVManga26Finished AiringMay 20, 2003 to Nov 11, 2003{'from': '2003-05-20', 'to': '2003-11-11'}24 min. per ep.G - All Ages7.2696632594249022778122nanSpring 2003Tuesdays at 22:00 (JST){'Adaptation': [{'mal_id': 956, 'type': 'manga', 'url': 'https://myanimelist.net/manga/956/Ultra_Maniac', 'title': 'Ultra Maniac'}], 'Alternative version': [{'mal_id': 179, 'type': 'anime', 'url': 'https://myanimelist.net/anime/179/Ultra_Maniac_OVA', 'title': 'Ultra Maniac OVA'}]}WAO World, Studio JackDiscotek Media, Geneon Entertainment USAProduction ReedMagic, Comedy, Romance, School, Shoujo['"Kagami no Naka" by can/goo']['"Hitotsu=Unmei Kyoudoutai" by can/goo']242003
2787Shakugan no Shana II (Second)Shakugan no Shana: Season II灼眼のシャナII –Second–Shakugan no Shana 2https://myanimelist.cdn-dena.com/images/anime/10/18669.jpgTVLight novel24Finished AiringOct 5, 2007 to Mar 28, 2008{'from': '2007-10-05', 'to': '2008-03-28'}24 min. per ep.PG-13 - Teens 13 or older7.7212608510663322205911075nanFall 2007Fridays at 01:25 (JST){'Adaptation': [{'mal_id': 3074, 'type': 'manga', 'url': 'https://myanimelist.net/manga/3074/Shakugan_no_Shana', 'title': 'Shakugan no Shana'}], 'Prequel': [{'mal_id': 355, 'type': 'anime', 'url': 'https://myanimelist.net/anime/355/Shakugan_no_Shana', 'title': 'Shakugan no Shana'}], 'Spin-off': [{'m…Geneon Universal Entertainment, ASCII Media WorksFunimationJ.C.StaffAction, Drama, Fantasy, Romance, School, Supernatural['#1: "JOINT" by Mami Kawada (eps 1-15)', '#2: "BLAZE" by KOTOKO (16-24)']['#1: "Triangle" by Kawada Mami (eps 1-15)', '#2: "Sociometry" by KOTOKO (eps 16-23)', '#3: "Sense" by Kawada Mami (ep 24)']242007
4477Nodame Cantabile: Paris-hennanのだめカンタービレ 巴里編Nodame Cantabile Paris Chapter, Nodame Cantabile Pari-henhttps://myanimelist.cdn-dena.com/images/anime/4/11918.jpgTVManga11Finished AiringOct 10, 2008 to Dec 19, 2008{'from': '2008-10-10', 'to': '2008-12-19'}23 min. per ep.PG-13 - Teens 13 or older8.245390828198885660282nanFall 2008Fridays at 00:45 (JST){'Adaptation': [{'mal_id': 419, 'type': 'manga', 'url': 'https://myanimelist.net/manga/419/Nodame_Cantabile', 'title': 'Nodame Cantabile'}], 'Prequel': [{'mal_id': 1698, 'type': 'anime', 'url': 'https://myanimelist.net/anime/1698/Nodame_Cantabile', 'title': 'Nodame Cantabile'}], 'Other': [{'mal_id':…Fuji TV, Asmik Ace Entertainment, Sony Music EntertainmentnanJ.C.StaffMusic, Slice of Life, Comedy, Romance, Josei['"Sky High!" by The Gospellers']['"東京 et 巴里 (Tokyo and Paris)" by Emiri Miyamoto x Solita']232008
853Ouran Koukou Host ClubOuran High School Host Club桜蘭高校ホスト部Ohran Koko Host Club, Ouran Koukou Hosutobu, Ouran Koukou Host Bu, OHSHChttps://myanimelist.cdn-dena.com/images/anime/2/71992.jpgTVManga26Finished AiringApr 5, 2006 to Sep 27, 2006{'from': '2006-04-05', 'to': '2006-09-27'}23 min. per ep.PG-13 - Teens 13 or older8.343351372056953884324072nanSpring 2006Wednesdays at 00:50 (JST){'Adaptation': [{'mal_id': 30, 'type': 'manga', 'url': 'https://myanimelist.net/manga/30/Ouran_Koukou_Host_Club', 'title': 'Ouran Koukou Host Club'}]}VAP, Hakusensha, Nippon Television NetworkFunimationBonesComedy, Harem, Romance, School, Shoujo['"Sakura Kiss" by Chieko Kawabe']['"Shissou" by Last Alliance']232006

CREATE TABLE anime_cleaned (
  "anime_id" BIGINT,
  "title" VARCHAR,
  "title_english" VARCHAR,
  "title_japanese" VARCHAR,
  "title_synonyms" VARCHAR,
  "image_url" VARCHAR,
  "type" VARCHAR,
  "source" VARCHAR,
  "episodes" BIGINT,
  "status" VARCHAR,
  "airing" BOOLEAN,
  "aired_string" VARCHAR,
  "aired" VARCHAR,
  "duration" VARCHAR,
  "rating" VARCHAR,
  "score" DOUBLE,
  "scored_by" BIGINT,
  "rank" DOUBLE,
  "popularity" BIGINT,
  "members" BIGINT,
  "favorites" BIGINT,
  "background" VARCHAR,
  "premiered" VARCHAR,
  "broadcast" VARCHAR,
  "related" VARCHAR,
  "producer" VARCHAR,
  "licensor" VARCHAR,
  "studio" VARCHAR,
  "genre" VARCHAR,
  "opening_theme" VARCHAR,
  "ending_theme" VARCHAR,
  "duration_min" DOUBLE,
  "aired_from_year" DOUBLE
);

Share link

Anyone who has the link will be able to view this.