Anime-Planet Recommendation Database 2020

Recommendation data from 74.000 users and 16.000 animes at Anime-Planet

@kaggle.hernan4444_animeplanet_recommendation_database_2020

Table List

5 tables(81.46 MB)

Anime

Animelist

Anime Recommendations

Rating Complete

Watching Status

Anime

@kaggle.hernan4444_animeplanet_recommendation_database_2020.anime

3.84 MB
16621 rows
17 columns

anime_planetid Anime-PlanetID	name Name	alternative_name Alternative Name	rating_score Rating Score	number_votes Number Votes	tags Tags	content_warning Content Warning	type Type	episodes Episodes	finished Finished	duration Duration	startyear StartYear	endyear EndYear	season Season	studios Studios	synopsis Synopsis	url Url
10	The Prince of Tennis	Tennis no Ouji-sama	4.037	10889	Comedy, Drama, Shounen, Sports, Tennis, Based on a Manga	Unknown	TV	178	true	Unknown	2001	2005	Fall 2001	Production I.G, Trans Arts	Meet Ryoma Echizen, the cocky prince of tennis. He comes to Japan from America where he is known as the Prince of Tennis – but that is no surprise considering he is the son of the former tennis pro, Nanjiroh Echizen, otherwise known as the Samurai! Upon transferring to the school Seishun Gakuen, he …	https://www.anime-planet.com/anime/the-prince-of-tennis
100	Neon Genesis Evangelion	Shinseiki Evangelion	4.248	54463	Drama, Mecha, Sci Fi, Conspiracy, Kaijuu, Loneliness, Melancholy, Military, Monsters, Post-apocalyptic, Psychological, Super Robot, Original Work	Emotional Abuse, Explicit Violence, Mature Themes, Suicide	TV	26	true	Unknown	1995	1996	Fall 1995	GAINAX, Tatsunoko Production	In the future, a devastating event known as Second Impact has destroyed Tokyo as we know it, giving rise to Tokyo III - a city under siege by mysterious lifeforms known only as Angels. Mankind's only line of defense are the Evangelions, a set man-made machines piloted by a trio of fourteen year-old …	https://www.anime-planet.com/anime/neon-genesis-evangelion
1000	Full Metal Panic! The Second Raid	Unknown	4.35	23948	Action, Comedy, Mecha, Sci Fi, Shounen, Military, Real Robot, Tsundere, Based on a Light Novel	Explicit Violence, Nudity	TV	13	true	Unknown	2005	2005	Summer 2005	Kyoto Animation	Half a year has passed since Sousuke Sagara took up the job of protecting Kaname Chidori and has started living like a normal teenager for the first time. A former child soldier, his view on the perils of everyday life is highly unconventional and in frequent need of violent adjustment; Kaname can o…	https://www.anime-planet.com/anime/full-metal-panic-the-second-raid
10000	22/7: Shampoo no Nioi ga Shita	Unknown	2.8	131	Idols, School Life, CG Animation	Unknown	Music	1	true	5	2018	2018	Unknown	Unknown	The idol group 22/7 perform the song Shampoo no Nioi ga Shita while showing the joys of being girls in high school.	https://www.anime-planet.com/anime/22-7-shampoo-no-nioi-ga-shita
10001	Oshiri Tantei: Puputto Fumutto Kaiketsu Dance	Unknown	1.271	21	Family Friendly	Unknown	Web	1	true	2	2017	2017	Unknown	Toei Animation	No synopsis yet - check back soon!	https://www.anime-planet.com/anime/oshiri-tantei-puputto-fumutto-kaiketsu-dance
10002	BACK DROP BOMB: Sigh	Unknown	1.044	26	Unknown	Unknown	Music	1	true	5	2014	2014	Unknown	Unknown	No synopsis yet - check back soon!	https://www.anime-planet.com/anime/back-drop-bomb-sigh
10003	MIRChee: Kyak Kyak Kyak Flamenco	Unknown	1.571	27	Dancing	Unknown	Music	1	true	3	2017	2017	Unknown	Unknown	No synopsis yet - check back soon!	https://www.anime-planet.com/anime/mirchee-kyak-kyak-kyak-flamenco
10004	Mang Huang Ji	The Legend of Jade Sword	2.459	95	Action, Adventure, Fantasy, Chinese Animation, Martial Arts, Short Episodes, Xianxia, Based on a Novel	Unknown	Web	19	true	12	2015	2015	Spring 2015	Unknown	Fate had never been kind to Ji Ning. Wracked by illnesses and infirm his entire life on Earth, Ning knew early on that he would die as a teenager. What he didn’t know was that there really was such a thing as life after death, and that the multiverse was a far larger place than he thought. A lucky t…	https://www.anime-planet.com/anime/mang-huang-ji
10006	sora tob sakana: Ribbon	Unknown	1.907	35	Animal Protagonists, Anthropomorphic, Non-Human Protagonists, Rabbits	Unknown	Music	1	true	5	2017	2017	Unknown	Unknown	No synopsis yet - check back soon!	https://www.anime-planet.com/anime/sora-tob-sakana-ribbon
10007	Kindan no Tasuketsu: Nosferatu	Unknown	1.522	30	Unknown	Unknown	Music	1	true	2	2012	2012	Unknown	Unknown	No synopsis yet - check back soon!	https://www.anime-planet.com/anime/kindan-no-tasuketsu-nosferatu


CREATE TABLE anime (
  "anime_planetid" BIGINT,
  "name" VARCHAR,
  "alternative_name" VARCHAR,
  "rating_score" VARCHAR,
  "number_votes" VARCHAR,
  "tags" VARCHAR,
  "content_warning" VARCHAR,
  "type" VARCHAR,
  "episodes" VARCHAR,
  "finished" BOOLEAN,
  "duration" VARCHAR,
  "startyear" VARCHAR,
  "endyear" VARCHAR,
  "season" VARCHAR,
  "studios" VARCHAR,
  "synopsis" VARCHAR,
  "url" VARCHAR
);