Crunchyroll Animes Database

anime votes and ratings displayed on crunchyroll

@kaggle.filipefilardi_crunchyroll_anime_ratings

Table List

1 table(155.16 KB)

Animes

@kaggle.filipefilardi_crunchyroll_anime_ratings.animes

155.16 KB
1255 rows
41 columns

anime Anime	anime_url Anime Url	anime_img Anime Img	episodes Episodes	votes Votes	weight Weight	rate Rate	rate_1 Rate 1	rate_2 Rate 2	rate_3 Rate 3	rate_4 Rate 4	rate_5 Rate 5	genre_action Genre Action	genre_comedy Genre Comedy	genre_drama Genre Drama	genre_harem Genre Harem	genre_music Genre Music	genre_romance Genre Romance	genre_sports Genre Sports
Naruto Shippuuden	https://www.crunchyroll.com/naruto-shippuden	https://img1.ak.crunchyroll.com/i/spire4/1c1df98707aa0f22aa54342af725e48a1491245343_full.jpg	500	48518	233346	4.81	1111	275	817	2341	43974
Shugo Chara	https://www.crunchyroll.com/shugo-chara	https://img1.ak.crunchyroll.com/i/spire1/7c0c0cd3958894b2dafc740ba847e4f11279141777_full.jpg	51	33688	163641	4.86	503	104	438	1599	31044
BLEACH	https://www.crunchyroll.com/bleach	https://img1.ak.crunchyroll.com/i/spire2/52edb7a843abacb4ff0f642c8eda14401325114125_full.jpg	366	23900	115445	4.83	391	98	370	1457	21584
Naruto	https://www.crunchyroll.com/naruto	https://img1.ak.crunchyroll.com/i/spire2/0145388e3ecfdb5a63ce1e9feaeef44a1279141923_full.jpg	220	16613	79667	4.8	456	64	282	818	14993
Skip Beat!	https://www.crunchyroll.com/skip-beat	https://img1.ak.crunchyroll.com/i/spire3/4bbe3a679c7365d16dd49c9d78ae992e1279142023_full.jpg		15011	73683	4.91	98	20	112	696	14085		1	1			1
REBORN!	https://www.crunchyroll.com/reborn	https://img1.ak.crunchyroll.com/i/spire1/445d2fd74c924440b1ca61600789e2861383180162_full.jpg		12542	61262	4.88	114	47	132	587	11662
Gintama	https://www.crunchyroll.com/gintama	https://img1.ak.crunchyroll.com/i/spire2/54c15675670ba44c1f98c3e11ba0cddf1515030877_full.jpg	379	11435	55745	4.87	133	47	124	509	10622
La Corda d'Oro ~primo passo~ and ~secondo passo~	https://www.crunchyroll.com/la-corda-doro-primo-passo-and-secondo-passo	https://img1.ak.crunchyroll.com/i/spire2/383071a2c629ff64fb33669a793eac311293594874_full.png		9555	46479	4.86	71	26	148	638	8672				1	1	1
Eyeshield 21	https://www.crunchyroll.com/eyeshield-21	https://img1.ak.crunchyroll.com/i/spire3/f7adee8b50d73664021c3e4e3042e8101279142732_full.jpg		8466	41028	4.85	99	43	115	547	7662	1	1					1
Hayate the Combat Butler! (S1 e S2)	https://www.crunchyroll.com/hayate-the-combat-butler-season-1-2	https://img1.ak.crunchyroll.com/i/spire4/8ad9366eab2ceca1a872a26c5b96574f1446849740_full.jpg	77	5689	27576	4.85	47	12	92	461	5077


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