Baselight

MyAnimeList Dataset

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

@kaggle.azathoth42_myanimelist

Animelists Cleaned
@kaggle.azathoth42_myanimelist.animelists_cleaned

  • 435.94 MB
  • 31284030 rows
  • 11 columns
username

Username

anime_id

Anime Id

my_watched_episodes

My Watched Episodes

my_start_date

My Start Date

my_finish_date

My Finish Date

my_score

My Score

my_status

My Status

my_rewatching

My Rewatching

my_rewatching_ep

My Rewatching Ep

my_last_updated

My Last Updated

my_tags

My Tags

karthiga215860000-00-000000-00-0091Sun Mar 03 2013 10:52:53 GMT+0000 (Coordinated Universal Time)nan
karthiga59260000-00-000000-00-0072Sun Mar 10 2013 13:54:51 GMT+0000 (Coordinated Universal Time)nan
karthiga74260000-00-000000-00-0072Sat Apr 27 2013 16:43:35 GMT+0000 (Coordinated Universal Time)nan
karthiga120260000-00-000000-00-0072Sun Mar 03 2013 10:53:57 GMT+0000 (Coordinated Universal Time)nan
karthiga178260000-00-000000-00-0072Wed Mar 27 2013 15:59:13 GMT+0000 (Coordinated Universal Time)nan
karthiga2101610000-00-000000-00-0072Sun Mar 10 2013 13:57:06 GMT+0000 (Coordinated Universal Time)nan
karthiga232700000-00-000000-00-0062Sat Mar 09 2013 17:24:42 GMT+0000 (Coordinated Universal Time)nan
karthiga233780000-00-000000-00-0062Sun Mar 10 2013 05:29:44 GMT+0000 (Coordinated Universal Time)nan
karthiga2491670000-00-000000-00-0082Tue Mar 19 2013 16:04:46 GMT+0000 (Coordinated Universal Time)nan
karthiga2693660000-00-000000-00-00102Sun Mar 03 2013 09:39:23 GMT+0000 (Coordinated Universal Time)nan

CREATE TABLE animelists_cleaned (
  "username" VARCHAR,
  "anime_id" BIGINT,
  "my_watched_episodes" BIGINT,
  "my_start_date" VARCHAR,
  "my_finish_date" VARCHAR,
  "my_score" BIGINT,
  "my_status" BIGINT,
  "my_rewatching" DOUBLE,
  "my_rewatching_ep" BIGINT,
  "my_last_updated" TIMESTAMP,
  "my_tags" VARCHAR
);

Share link

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