Name: Anime Database (July 2025)
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Anime Database (July 2025)

Context

This dataset represents a comprehensive snapshot of the MyAnimeList.net database as of July 16, 2025. It is designed to be a rich, clean, and accessible resource for data scientists, machine learning engineers, and anime enthusiasts. The data captures a wide array of information for over 28,000 unique anime titles, providing a deep look into the trends, metadata, and community ratings of the anime world.

Inspiration

The inspiration behind creating this dataset was to provide a robust foundation for a variety of data-driven projects. While other MyAnimeList datasets exist, they often become outdated. This project was inspired by the need for an up-to-date, meticulously documented dataset that could power:

Advanced Recommendation Systems: Moving beyond simple genre matching to include studios, themes, and popularity metrics.
In-depth Industry Analysis: Answering questions about how the anime industry has evolved over time.
Natural Language Processing (NLP) on Synopses: Exploring narrative structures and themes within anime plot summaries.
Engaging Data Visualizations: Creating interactive dashboards to help users explore the vast world of anime.

Tables

Anime

@kaggle.sazzadsiddiquelikhon_myanimelist_anime_database_july_2025.anime

13.03 MB
28858 rows
58 columns


CREATE TABLE anime (
  "mal_id" BIGINT,
  "url" VARCHAR,
  "approved" BOOLEAN,
  "title" VARCHAR,
  "title_english" VARCHAR,
  "title_japanese" VARCHAR,
  "title_synonyms" VARCHAR,
  "image_jpg_url" VARCHAR,
  "image_jpg_small_url" VARCHAR,
  "image_jpg_large_url" VARCHAR,
  "image_webp_url" VARCHAR,
  "image_webp_small_url" VARCHAR,
  "image_webp_large_url" VARCHAR,
  "trailer_youtube_id" VARCHAR,
  "trailer_url" VARCHAR,
  "trailer_embed_url" VARCHAR,
  "trailer_image_url" VARCHAR,
  "trailer_small_image_url" VARCHAR,
  "trailer_medium_image_url" VARCHAR,
  "trailer_large_image_url" VARCHAR,
  "trailer_maximum_image_url" VARCHAR,
  "type" VARCHAR,
  "source" VARCHAR,
  "episodes" DOUBLE,
  "status" VARCHAR,
  "airing" BOOLEAN,
  "duration" VARCHAR,
  "rating" VARCHAR,
  "score" DOUBLE,
  "scored_by" DOUBLE,
  "rank" DOUBLE,
  "popularity" BIGINT,
  "members" BIGINT,
  "favorites" BIGINT,
  "synopsis" VARCHAR,
  "background" VARCHAR,
  "aired_from" TIMESTAMP,
  "aired_to" TIMESTAMP,
  "aired_prop_from_day" DOUBLE,
  "aired_prop_from_month" DOUBLE,
  "aired_prop_from_year" DOUBLE,
  "aired_prop_to_day" DOUBLE,
  "aired_prop_to_month" DOUBLE,
  "aired_prop_to_year" DOUBLE,
  "aired_string" VARCHAR,
  "season" VARCHAR,
  "year" DOUBLE,
  "broadcast_day" VARCHAR,
  "broadcast_time" VARCHAR,
  "broadcast_timezone" VARCHAR,
  "broadcast_string" VARCHAR,
  "producers" VARCHAR,
  "licensors" VARCHAR,
  "studios" VARCHAR,
  "genres" VARCHAR,
  "explicit_genres" VARCHAR,
  "themes" VARCHAR,
  "demographics" VARCHAR
);