Dataset: MTG - All Cards

About this Dataset

MTG - All Cards

This dataset was created to help learn more about the popular trading card game, Magic: The Gathering, from a data analytics perspective. All the MTG cards ever printed are available here (with some duplication - data cleaning is always necessary to get data in a working state!), with extensive metadata and context available, like official rulings, legalities, sets, reprints, timeshifts, etc. - as well as the regular card information that is available on each card by default.

From this data, we can look to answer some questions about the MTG trading card game that are not easily approachable without data analytics - for example, how many cards does each color have? What creature subtypes are most common for each color? Who are the most prolific artists in MTG? What are the most common words used in card names? In card rules text? In flavor text? Which cards have caused the most headaches in tournaments - measured by the cards with the most rulings to define their function in the game more precisely?

These questions (and more) are all answered in my starter notebook, so look there to get started!
https://www.kaggle.com/code/patrickgendotti/mtg-all-cards-eda

Tables

All Mtg Cards

@kaggle.patrickgendotti_mtg_all_cards.all_mtg_cards

109.18 MB
93643 rows
39 columns


CREATE TABLE all_mtg_cards (
  "name" VARCHAR,
  "multiverse_id" DOUBLE,
  "layout" VARCHAR,
  "names" VARCHAR,
  "mana_cost" VARCHAR,
  "cmc" DOUBLE,
  "colors" VARCHAR,
  "color_identity" VARCHAR,
  "type" VARCHAR,
  "supertypes" VARCHAR,
  "subtypes" VARCHAR,
  "rarity" VARCHAR,
  "text" VARCHAR,
  "flavor" VARCHAR,
  "artist" VARCHAR,
  "number" VARCHAR,
  "power" VARCHAR,
  "toughness" VARCHAR,
  "loyalty" VARCHAR,
  "variations" VARCHAR,
  "watermark" VARCHAR,
  "border" VARCHAR,
  "timeshifted" VARCHAR,
  "hand" DOUBLE,
  "life" DOUBLE,
  "reserved" VARCHAR,
  "release_date" VARCHAR,
  "starter" VARCHAR,
  "rulings" VARCHAR,
  "foreign_names" VARCHAR,
  "printings" VARCHAR,
  "original_text" VARCHAR,
  "original_type" VARCHAR,
  "legalities" VARCHAR,
  "source" VARCHAR,
  "image_url" VARCHAR,
  "set" VARCHAR,
  "set_name" VARCHAR,
  "id" VARCHAR
);