Dataset: Crunchyroll Animes Database

About this Dataset

Crunchyroll Animes Database

Crunchyroll animes database

This dataset represents all animes crawled from Crunchyroll in this repository, containing its rating, number of votes and genre.

Content

anime - English name of the anime
anime_url - anime URL on Crunchyroll
anime_img - anime image URL hosted by Crunchyroll
episodes - number of episodes hosted by Crunchyroll of the anime
votes - number of votes of the anime
votes_weight - the sum of rated stars received of the anime
rate_1_stars - the quantity of 1 stars votes of the anime
rate_2_stars - the quantity of 2 stars votes of the anime
rate_3_stars - the quantity of 3 stars votes of the anime
rate_4_stars - the quantity of 4 stars votes of the anime
rate_5_stars - the quantity of 5 stars votes of the anime
rate - an average rating out of 5 stars of the anime
genres - 29 different genres of the anime, one column for each genre with 1 and 0

Acknowledgements

Special thanks to Crunchyroll for providing the sitemap in robots.txt to get all information.

Tables

Animes

@kaggle.filipefilardi_crunchyroll_anime_ratings.animes

155.16 KB
1255 rows
41 columns


CREATE TABLE animes (
  "anime" VARCHAR,
  "anime_url" VARCHAR,
  "anime_img" VARCHAR,
  "episodes" BIGINT,
  "votes" BIGINT,
  "weight" BIGINT,
  "rate" DOUBLE,
  "rate_1" BIGINT,
  "rate_2" BIGINT,
  "rate_3" BIGINT,
  "rate_4" BIGINT,
  "rate_5" BIGINT,
  "genre_action" DOUBLE,
  "genre_adventure" DOUBLE,
  "genre_comedy" DOUBLE,
  "genre_drama" DOUBLE,
  "genre_family" DOUBLE,
  "genre_fantasy" DOUBLE,
  "genre_food" DOUBLE,
  "genre_harem" DOUBLE,
  "genre_historical" DOUBLE,
  "genre_horror" DOUBLE,
  "genre_idols" DOUBLE,
  "genre_isekai" DOUBLE,
  "genre_jdrama" DOUBLE,
  "genre_magical_girls" DOUBLE,
  "genre_martial_arts" DOUBLE,
  "genre_mecha" DOUBLE,
  "genre_music" DOUBLE,
  "genre_mystery" DOUBLE,
  "genre_post_apocalyptic" DOUBLE,
  "genre_romance" DOUBLE,
  "genre_sci_fi" DOUBLE,
  "genre_seinen" DOUBLE,
  "genre_sgdrama" DOUBLE,
  "genre_shojo" DOUBLE,
  "genre_shonen" DOUBLE,
  "genre_slice_of_life" DOUBLE,
  "genre_sports" DOUBLE,
  "genre_supernatural" DOUBLE,
  "genre_thriller" DOUBLE
);