MyAnimeList Dataset

contains 300k users, 14k anime metadata, and 80mil. ratings from MyAnimeList.net

@kaggle.azathoth42_myanimelist

Table List

9 tables(1.86 GB)

Userlist

@kaggle.azathoth42_myanimelist.userlist

13.77 MB
302675 rows
17 columns

username Username	user_id User Id	user_watching User Watching	user_completed User Completed	user_onhold User Onhold	user_dropped User Dropped	user_plantowatch User Plantowatch	user_days_spent_watching User Days Spent Watching	gender Gender	location Location	birth_date Birth Date	join_date Join Date	last_online Last Online	stats_mean_score Stats Mean Score	stats_rewatched Stats Rewatched	stats_episodes Stats Episodes
karthiga	2255153	3	49	1			55.31	Female	Chennai, India	1990-04-29	Sun Mar 03 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Feb 04 2014 01:32:00 GMT+0000 (Coordinated Universal Time)	7.43		3391
RedvelvetDaisuki	1897606	61	396	39		206	118.07	Female	Manila	1995-01-01	Thu Dec 13 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun May 13 1900 02:47:00 GMT+0000 (Coordinated Universal Time)	6.78	80	7094
Damonashu	37326	45	195	27	25	59	83.7	Male	Detroit,Michigan	1991-08-01	Wed Feb 13 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Mar 24 1900 12:48:00 GMT+0000 (Coordinated Universal Time)	6.15	6	4936
bskai	228342	25	414	2	5	11	167.16	Male	Nayarit, Mexico	1990-12-14	Mon Aug 31 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 12 2014 16:35:00 GMT+0000 (Coordinated Universal Time)	8.27	1	10081
shuzzable	2347781	36	72	16	2	25	35.48	nan	nan	nan	Mon Mar 25 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Sep 09 2015 21:54:00 GMT+0000 (Coordinated Universal Time)	9.06	7	2154
terune_uzumaki	327311	5	5				15.2	Female	Malaysia, Kuantan	1998-08-24	Mon May 10 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Oct 18 2012 19:06:00 GMT+0000 (Coordinated Universal Time)	9.7	6	920
Bas_G	5015094	35	114	6	20	175	30.81	Male	Nijmegen, Nederland	1999-10-24	Thu Nov 26 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu May 10 1900 13:53:00 GMT+0000 (Coordinated Universal Time)	7.86		1847
punane	39250	1					2.97	nan	nan	nan	Sun Feb 24 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Feb 13 2011 02:42:00 GMT+0000 (Coordinated Universal Time)	8		178
-otaku-sama-	4583478		4			1	6.42	nan	nan	nan	Mon Apr 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 04 2015 19:05:00 GMT+0000 (Coordinated Universal Time)	8.6		371
sprite1989	102436	2583	102			22	30.86	Male	nan	1989-07-29	Mon Oct 06 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 30 2017 05:26:00 GMT+0000 (Coordinated Universal Time)	8.49		1829


CREATE TABLE userlist (
  "username" VARCHAR,
  "user_id" BIGINT,
  "user_watching" BIGINT,
  "user_completed" BIGINT,
  "user_onhold" BIGINT,
  "user_dropped" BIGINT,
  "user_plantowatch" BIGINT,
  "user_days_spent_watching" DOUBLE,
  "gender" VARCHAR,
  "location" VARCHAR,
  "birth_date" VARCHAR,
  "access_rank" VARCHAR,
  "join_date" TIMESTAMP,
  "last_online" TIMESTAMP,
  "stats_mean_score" DOUBLE,
  "stats_rewatched" DOUBLE,
  "stats_episodes" DOUBLE
);