Anime Dataset 2023
A Comprehensive Collection of Anime Information
@kaggle.dbdmobile_myanimelist_dataset
A Comprehensive Collection of Anime Information
@kaggle.dbdmobile_myanimelist_dataset
anime_idAnime Id | nameName | english_nameEnglish Name | other_nameOther Name | scoreScore | genresGenres | synopsisSynopsis | typeType | episodesEpisodes | airedAired | premieredPremiered | statusStatus | producersProducers | licensorsLicensors | studiosStudios | sourceSource | durationDuration | ratingRating | rankRank | popularityPopularity | favoritesFavorites | scored_byScored By | membersMembers | image_urlImage URL |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Cowboy Bebop | Cowboy Bebop | カウボーイビバップ | 8.75 | Action, Award Winning, Sci-Fi | Crime is timeless. By the year 2071, humanity has expanded across the galaxy, filling the surface of other planets with settlements like those on Earth. These new societies are plagued by murder, drug use, and theft, and intergalactic outlaws are hunted by a growing number of tough bounty hunters. … | TV | 26.0 | Apr 3, 1998 to Apr 24, 1999 | spring 1998 | Finished Airing | Bandai Visual | Funimation, Bandai Entertainment | Sunrise | Original | 24 min per ep | R - 17+ (violence & profanity) | 41.0 | 43 | 78525 | 914193.0 | 1771505 | https://cdn.myanimelist.net/images/anime/4/19644.jpg |
5 | Cowboy Bebop: Tengoku no Tobira | Cowboy Bebop: The Movie | カウボーイビバップ 天国の扉 | 8.38 | Action, Sci-Fi | Another day, another bounty—such is the life of the often unlucky crew of the Bebop. However, this routine is interrupted when Faye, who is chasing a fairly worthless target on Mars, witnesses an oil tanker suddenly explode, causing mass hysteria. As casualties mount due to a strange disease spreadi… | Movie | 1.0 | Sep 1, 2001 | UNKNOWN | Finished Airing | Sunrise, Bandai Visual | Sony Pictures Entertainment | Bones | Original | 1 hr 55 min | R - 17+ (violence & profanity) | 189.0 | 602 | 1448 | 206248.0 | 360978 | https://cdn.myanimelist.net/images/anime/1439/93480.jpg |
6 | Trigun | Trigun | トライガン | 8.22 | Action, Adventure, Sci-Fi | Vash the Stampede is the man with a $$60,000,000,000 bounty on his head. The reason: he's a merciless villain who lays waste to all those that oppose him and flattens entire cities for fun, garnering him the title "The Humanoid Typhoon." He leaves a trail of death and destruction wherever he goes, a… | TV | 26.0 | Apr 1, 1998 to Sep 30, 1998 | spring 1998 | Finished Airing | Victor Entertainment | Funimation, Geneon Entertainment USA | Madhouse | Manga | 24 min per ep | PG-13 - Teens 13 or older | 328.0 | 246 | 15035 | 356739.0 | 727252 | https://cdn.myanimelist.net/images/anime/7/20310.jpg |
7 | Witch Hunter Robin | Witch Hunter Robin | Witch Hunter ROBIN (ウイッチハンターロビン) | 7.25 | Action, Drama, Mystery, Supernatural | Robin Sena is a powerful craft user drafted into the STNJ—a group of specialized hunters that fight deadly beings known as Witches. Though her fire power is great, she's got a lot to learn about her powers and working with her cool and aloof partner, Amon. But the truth about the Witches and herself… | TV | 26.0 | Jul 3, 2002 to Dec 25, 2002 | summer 2002 | Finished Airing | Bandai Visual, Dentsu, Victor Entertainment, TV Tokyo Music | Funimation, Bandai Entertainment | Sunrise | Original | 25 min per ep | PG-13 - Teens 13 or older | 2764.0 | 1795 | 613 | 42829.0 | 111931 | https://cdn.myanimelist.net/images/anime/10/19969.jpg |
8 | Bouken Ou Beet | Beet the Vandel Buster | 冒険王ビィト | 6.94 | Adventure, Fantasy, Supernatural | It is the dark century and the people are suffering under the rule of the devil, Vandel, who is able to manipulate monsters. The Vandel Busters are a group of people who hunt these devils, and among them, the Zenon Squad is known to be the strongest busters on the continent. A young boy, Beet, dream… | TV | 52.0 | Sep 30, 2004 to Sep 29, 2005 | fall 2004 | Finished Airing | TV Tokyo, Dentsu | Illumitoon Entertainment | Toei Animation | Manga | 23 min per ep | PG - Children | 4240.0 | 5126 | 14 | 6413.0 | 15001 | https://cdn.myanimelist.net/images/anime/7/21569.jpg |
15 | Eyeshield 21 | UNKNOWN | アイシールド21 | 7.92 | Sports | Shy, reserved, and small-statured, Deimon High School student Sena Kobayakawa is the perfect target for bullies. However, as a result of running errands throughout his life, Sena has become agile and developed a skill for avoiding crowds of people. After the cunning Youichi Hiruma—captain of the Dei… | TV | 145.0 | Apr 6, 2005 to Mar 19, 2008 | spring 2005 | Finished Airing | TV Tokyo, Nihon Ad Systems, TV Tokyo Music, Shueisha | VIZ Media, Sentai Filmworks | Gallop | Manga | 23 min per ep | PG-13 - Teens 13 or older | 688.0 | 1252 | 1997 | 86524.0 | 177688 | https://cdn.myanimelist.net/images/anime/1079/133529.jpg |
16 | Hachimitsu to Clover | Honey and Clover | ハチミツとクローバー | 8.0 | Comedy, Drama, Romance | Yuuta Takemoto, a sophomore at an arts college, shares a cheap apartment with two seniors—the eccentric Shinobu Morita, who keeps failing to graduate due to his absenteeism, and the sensible Takumi Mayama, who acts as a proper senior to Takemoto, often looking out for him. Takemoto had not given mu… | TV | 24.0 | Apr 15, 2005 to Sep 27, 2005 | spring 2005 | Finished Airing | Dentsu, Genco, Fuji TV, Asmik Ace, Shueisha | VIZ Media, Discotek Media | J.C.Staff | Manga | 23 min per ep | PG-13 - Teens 13 or older | 589.0 | 862 | 4136 | 81747.0 | 260166 | https://cdn.myanimelist.net/images/anime/1301/133577.jpg |
17 | Hungry Heart: Wild Striker | UNKNOWN | ハングリーハート Wild Striker | 7.55 | Comedy, Slice of Life, Sports | As the younger brother of Japanese soccer star Seisuke Kanou, Kyousuke was always expected to grow as a soccer player at the same pace his brother did—an expectation that proved too difficult to meet. Having fallen behind, he now lives in the shadow of his brother's success. Entering his freshman y… | TV | 52.0 | Sep 11, 2002 to Sep 10, 2003 | fall 2002 | Finished Airing | UNKNOWN | UNKNOWN | Nippon Animation | Manga | 23 min per ep | PG-13 - Teens 13 or older | 1551.0 | 4212 | 237 | 12960.0 | 24172 | https://cdn.myanimelist.net/images/anime/12/49655.jpg |
18 | Initial D Fourth Stage | UNKNOWN | 頭文字〈イニシャル〉D FOURTH STAGE | 8.16 | Action, Drama | Takumi Fujiwara finally joins Ryousuke and Keisuke Takahashi to create "Project D." Their goal is twofold: Ryousuke wants to develop his "High-Speed Street Racing Theory," while Keisuke and Takumi aim at improving their driving skills by facing powerful opponents on dangerous roads. The idea of Proj… | TV | 24.0 | Apr 17, 2004 to Feb 18, 2006 | spring 2004 | Finished Airing | OB Planning, Studio Jack | Funimation | A.C.G.T. | Manga | 27 min per ep | PG-13 - Teens 13 or older | 393.0 | 1273 | 1237 | 97878.0 | 173710 | https://cdn.myanimelist.net/images/anime/9/10521.jpg |
19 | Monster | Monster | モンスター | 8.87 | Drama, Mystery, Suspense | Dr. Kenzou Tenma, an elite neurosurgeon recently engaged to his hospital director's daughter, is well on his way to ascending the hospital hierarchy. That is until one night, a seemingly small event changes Dr. Tenma's life forever. While preparing to perform surgery on someone, he gets a call from … | TV | 74.0 | Apr 7, 2004 to Sep 28, 2005 | spring 2004 | Finished Airing | VAP, Shogakukan-Shueisha Productions, Nippon Television Network | VIZ Media | Madhouse | Manga | 24 min per ep | R+ - Mild Nudity | 26.0 | 142 | 47235 | 368569.0 | 1013100 | https://cdn.myanimelist.net/images/anime/10/18793.jpg |
CREATE TABLE anime_dataset_2023 (
"anime_id" BIGINT,
"name" VARCHAR,
"english_name" VARCHAR,
"other_name" VARCHAR,
"score" VARCHAR,
"genres" VARCHAR,
"synopsis" VARCHAR,
"type" VARCHAR,
"episodes" VARCHAR,
"aired" VARCHAR,
"premiered" VARCHAR,
"status" VARCHAR,
"producers" VARCHAR,
"licensors" VARCHAR,
"studios" VARCHAR,
"source" VARCHAR,
"duration" VARCHAR,
"rating" VARCHAR,
"rank" VARCHAR,
"popularity" BIGINT,
"favorites" BIGINT,
"scored_by" VARCHAR,
"members" BIGINT,
"image_url" VARCHAR
);
Anyone who has the link will be able to view this.