Baselight

Crunchyroll Animes Database

anime votes and ratings displayed on crunchyroll

@kaggle.filipefilardi_crunchyroll_anime_ratings

Loading...
Loading...

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
Loading...

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

Share link

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