Anime Dataset 2023

A Comprehensive Collection of Anime Information

@kaggle.dbdmobile_myanimelist_dataset

Table List

6 tables(818.88 MB)

Users Details 2023

@kaggle.dbdmobile_myanimelist_dataset.users_details_2023

20.52 MB
731290 rows
16 columns

mal_id Mal ID	username Username	gender Gender	birthday Birthday	location Location	joined Joined	days_watched Days Watched	mean_score Mean Score	watching Watching	completed Completed	on_hold On Hold	dropped Dropped	plan_to_watch Plan To Watch	total_entries Total Entries	rewatched Rewatched	episodes_watched Episodes Watched
1	Xinil	Male	1985-03-04T00:00:00+00:00	California	Fri Nov 05 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	142.3	7.37	1	233	8	93	64	399	60	8458
3	Aokaado	Male	nan	Oslo, Norway	Thu Nov 11 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	68.6	7.34	23	137	99	44	40	343	15	4072
4	Crystal	Female	nan	Melbourne, Australia	Sat Nov 13 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	212.8	6.68	16	636	303		45	1000	10	12781
9	Arcane	nan	nan	nan	Sun Dec 05 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	30	7.71	5	54	4	3		66		1817
18	Mad	nan	nan	nan	Mon Jan 03 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	52	6.27	1	114	10	5	23	153	42	3038
20	vondur	Male	1988-01-25T00:00:00+00:00	Bergen, Norway	Wed Jan 05 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	73.1	8.06	11	94	11	2	20	138	7	4374
23	Amuro	nan	1988-02-22T00:00:00+00:00	Canada	Sun Jan 23 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	142.5	7.41	20	298	5	19	50	392		8565
36	Baman	Male	nan	Land of Rain and Fjords	Sat Feb 05 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	272.1	5.9	27	1144	11	55	338	1575	36	16309
44	beddan	Male	nan	nan	Mon Feb 21 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	18.6	7.6		37				37		1083
47	kei-clone	Male	nan	31f288172a11dea9f2781a6d87e0a200	Wed Mar 09 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	34.5	6.84	15	104	22	3	19	163	1	2054


CREATE TABLE users_details_2023 (
  "mal_id" BIGINT,
  "username" VARCHAR,
  "gender" VARCHAR,
  "birthday" VARCHAR,
  "location" VARCHAR,
  "joined" TIMESTAMP,
  "days_watched" DOUBLE,
  "mean_score" DOUBLE,
  "watching" DOUBLE,
  "completed" DOUBLE,
  "on_hold" DOUBLE,
  "dropped" DOUBLE,
  "plan_to_watch" DOUBLE,
  "total_entries" DOUBLE,
  "rewatched" DOUBLE,
  "episodes_watched" DOUBLE
);