Baselight
Sign In

MTG - All Cards

Comprehensive card catalog of all MTG cards ever printed!

@kaggle.patrickgendotti_mtg_all_cards

All Mtg Cards
@kaggle.patrickgendotti_mtg_all_cards.all_mtg_cards

  • 109.18 MB
  • 93643 rows
  • 39 columns
name

Name

multiverse_id

Multiverse Id

layout

Layout

names

Names

mana_cost

Mana Cost

cmc

Cmc

colors

Colors

color_identity

Color Identity

type

Type

supertypes

Supertypes

subtypes

Subtypes

rarity

Rarity

text

Text

flavor

Flavor

artist

Artist

number

Number

power

Power

toughness

Toughness

loyalty

Loyalty

variations

Variations

watermark

Watermark

border

Border

timeshifted

Timeshifted

hand

Hand

life

Life

reserved

Reserved

release_date

Release Date

starter

Starter

rulings

Rulings

foreign_names

Foreign Names

printings

Printings

original_text

Original Text

original_type

Original Type

legalities

Legalities

source

Source

image_url

Image Url

set

Set

set_name

Set Name

id

Id

Ancestor's Chosen130550normal{5}{W}{W}7['W']['W']Creature — Human Clericnan['Human', 'Cleric']UncommonFirst strike (This creature deals combat damage before creatures without first strike.) When Ancestor's Chosen enters the battlefield, you gain 1 life for each card in your graveyard.nanPete Venters144nan['b7c19924-b4bf-56fc-aa73-f586e940bd42']nannan[{'name': 'Ausgewählter der Ahnfrau', 'text': 'Erstschlag (Diese Kreatur fügt Kampfschaden vor Kreaturen ohne Erstschlag zu.)\nWenn der Ausgewählte der Ahnfrau ins Spiel kommt, erhältst du 1 Lebenspunkt für jede Karte in deinem Friedhof dazu.', 'type': 'Kreatur — Mensch, Kleriker', 'flavor': '„Es is…['10E', 'JUD', 'UMA']First strike When Ancestor's Chosen comes into play, you gain 1 life for each card in your graveyard.Creature - Human Cleric[{'format': 'Commander', 'legality': 'Legal'}, {'format': 'Duel', 'legality': 'Legal'}, {'format': 'Legacy', 'legality': 'Legal'}, {'format': 'Modern', 'legality': 'Legal'}, {'format': 'Oathbreaker', 'legality': 'Legal'}, {'format': 'Paupercommander', 'legality': 'Restricted'}, {'format': 'Penny', '…http://gatherer.wizards.com/Handlers/Image.ashx?multiverseid=130550&type=card10ETenth Edition5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c
Ancestor's Chosennormal{5}{W}{W}7['W']['W']Creature — Human Clericnan['Human', 'Cleric']UncommonFirst strike (This creature deals combat damage before creatures without first strike.) When Ancestor's Chosen enters the battlefield, you gain 1 life for each card in your graveyard."The will of all, by my hand done."Pete Venters1★44nan['5f8287b1-5bb6-5f4c-ad17-316a40d5bb0c']nannannan['10E', 'JUD', 'UMA']nannan[{'format': 'Commander', 'legality': 'Legal'}, {'format': 'Duel', 'legality': 'Legal'}, {'format': 'Legacy', 'legality': 'Legal'}, {'format': 'Modern', 'legality': 'Legal'}, {'format': 'Oathbreaker', 'legality': 'Legal'}, {'format': 'Paupercommander', 'legality': 'Restricted'}, {'format': 'Penny', '…nan10ETenth Editionb7c19924-b4bf-56fc-aa73-f586e940bd42
Angel of Mercy129465normal{4}{W}5['W']['W']Creature — Angelnan['Angel']UncommonFlying When Angel of Mercy enters the battlefield, you gain 3 life.Every tear shed is a drop of immortality.Volkan Baǵa233nan['8fd4e2eb-3eb4-50ea-856b-ef638fa47f8a']nannan[{'name': 'Engel der Gnade', 'text': 'Fliegend (Diese Kreatur kann außer von fliegenden Kreaturen und Kreaturen mit Reichweite nicht geblockt werden.)\nWenn der Engel der Gnade ins Spiel kommt, erhältst du 3 Lebenspunkte dazu.', 'type': 'Kreatur — Engel', 'flavor': 'Jede ihrer Tränen ist ein Tropfen…['10E', '8ED', '9ED', 'DDC', 'DVD', 'IMA', 'INV', 'JMP', 'P02', 'PLST', 'PS11', 'PSAL', 'S99']Flying When Angel of Mercy comes into play, you gain 3 life.Creature - Angel[{'format': 'Brawl', 'legality': 'Legal'}, {'format': 'Commander', 'legality': 'Legal'}, {'format': 'Duel', 'legality': 'Legal'}, {'format': 'Gladiator', 'legality': 'Legal'}, {'format': 'Historic', 'legality': 'Legal'}, {'format': 'Legacy', 'legality': 'Legal'}, {'format': 'Modern', 'legality': 'Le…http://gatherer.wizards.com/Handlers/Image.ashx?multiverseid=129465&type=card10ETenth Edition57aaebc1-850c-503d-9f6e-bb8d00d8bf7c
Angel of Mercynormal{4}{W}5['W']['W']Creature — Angelnan['Angel']UncommonFlying When Angel of Mercy enters the battlefield, you gain 3 life.Every tear shed is a drop of immortality.Volkan Baǵa2★33nan['57aaebc1-850c-503d-9f6e-bb8d00d8bf7c']nannannan['10E', '8ED', '9ED', 'DDC', 'DVD', 'IMA', 'INV', 'JMP', 'P02', 'PLST', 'PS11', 'PSAL', 'S99']nannan[{'format': 'Brawl', 'legality': 'Legal'}, {'format': 'Commander', 'legality': 'Legal'}, {'format': 'Duel', 'legality': 'Legal'}, {'format': 'Gladiator', 'legality': 'Legal'}, {'format': 'Historic', 'legality': 'Legal'}, {'format': 'Legacy', 'legality': 'Legal'}, {'format': 'Modern', 'legality': 'Le…nan10ETenth Edition8fd4e2eb-3eb4-50ea-856b-ef638fa47f8a
Angelic Blessing129711normal{2}{W}3['W']['W']SorcerynannanCommonTarget creature gets +3/+3 and gains flying until end of turn. (It can't be blocked except by creatures with flying or reach.)Only the warrior who can admit mortal weakness will be bolstered by immortal strength.Mark Zug3nannannan['c5655330-5131-5f40-9d3e-0549d88c6e9e']nannan[{'name': 'Himmlischer Segen', 'text': 'Eine Kreatur deiner Wahl erhält +3/+3 und Flugfähigkeit bis zum Ende des Zuges. (Sie kann außer von fliegenden Kreaturen und Kreaturen mit Reichweite nicht geblockt werden.)', 'type': 'Hexerei', 'flavor': 'Nur demjenigen Krieger, der sterbliche Schwäche zugebe…['10E', '9ED', 'EXO', 'P02', 'POR', 'PS11', 'S00', 'S99', 'TPR']Target creature gets +3/+3 and gains flying until end of turn.Sorcery[{'format': 'Commander', 'legality': 'Legal'}, {'format': 'Duel', 'legality': 'Legal'}, {'format': 'Legacy', 'legality': 'Legal'}, {'format': 'Modern', 'legality': 'Legal'}, {'format': 'Oathbreaker', 'legality': 'Legal'}, {'format': 'Pauper', 'legality': 'Legal'}, {'format': 'Paupercommander', 'lega…http://gatherer.wizards.com/Handlers/Image.ashx?multiverseid=129711&type=card10ETenth Edition55bd38ca-dc73-5c06-8f80-a6ddd2f44382
Angelic Blessingnormal{2}{W}3['W']['W']SorcerynannanCommonTarget creature gets +3/+3 and gains flying until end of turn. (It can't be blocked except by creatures with flying or reach.)Only the warrior who can admit mortal weakness will be bolstered by immortal strength.Mark Zug3★nannannan['55bd38ca-dc73-5c06-8f80-a6ddd2f44382']nannannan['10E', '9ED', 'EXO', 'P02', 'POR', 'PS11', 'S00', 'S99', 'TPR']nannan[{'format': 'Commander', 'legality': 'Legal'}, {'format': 'Duel', 'legality': 'Legal'}, {'format': 'Legacy', 'legality': 'Legal'}, {'format': 'Modern', 'legality': 'Legal'}, {'format': 'Oathbreaker', 'legality': 'Legal'}, {'format': 'Pauper', 'legality': 'Legal'}, {'format': 'Paupercommander', 'lega…nan10ETenth Editionc5655330-5131-5f40-9d3e-0549d88c6e9e
Angelic Chorus129710normal{3}{W}{W}5['W']['W']EnchantmentnannanRareWhenever a creature enters the battlefield under your control, you gain life equal to its toughness.The harmony of the glorious is a dirge to the wicked.Jim Murray4nannannannannan[{'date': '2004-10-04', 'text': 'Angelic Chorus does not trigger when creatures phase in or change controllers.'}, {'date': '2004-10-04', 'text': 'This does not trigger on a permanent being turned into a creature. That is just a permanent changing type, not something entering the battlefield.'}][{'name': 'Choral der Engel', 'text': 'Immer wenn ein Kreatur unter deiner Kontrolle ins Spiel kommt, erhältst du soviele Lebenspunkte dazu, wie ihre Widerstandskraft beträgt.', 'type': 'Verzauberung', 'flavor': 'Dieser Einklang in Herrlichkeit ist ein Trauergesang für das Böse.', 'imageUrl': 'http:…['10E', 'BBD', 'USG']Whenever a creature comes into play under your control, you gain life equal to its toughness.Enchantment[{'format': 'Commander', 'legality': 'Legal'}, {'format': 'Duel', 'legality': 'Legal'}, {'format': 'Legacy', 'legality': 'Legal'}, {'format': 'Modern', 'legality': 'Legal'}, {'format': 'Oathbreaker', 'legality': 'Legal'}, {'format': 'Penny', 'legality': 'Legal'}, {'format': 'Predh', 'legality': 'Leg…http://gatherer.wizards.com/Handlers/Image.ashx?multiverseid=129710&type=card10ETenth Edition3b77bb52-4181-57f5-b3cd-f3a15b95aa29
Angelic Wall129671normal{1}{W}2['W']['W']Creature — Wallnan['Wall']CommonDefender (This creature can't attack.) Flying"The Ancestor protects us in ways we can't begin to comprehend." —Mystic elderJohn Avon504nan['60b93108-8790-591b-844e-c3d311698767']nannan[{'name': 'Mauer der Engel', 'text': 'Verteidiger, Fliegend (Diese Kreatur kann nicht angreifen und kann fliegende Kreaturen blocken.)', 'type': 'Kreatur — Mauer', 'flavor': '„Die Ahnfrau beschützt uns in einer Weise, die wir kaum erfassen können. —Älterer Mystiker', 'imageUrl': 'http://gatherer.wiz…['10E', 'AVR', 'M14', 'ODY', 'P02']Defender, flyingCreature - Wall[{'format': 'Commander', 'legality': 'Legal'}, {'format': 'Duel', 'legality': 'Legal'}, {'format': 'Legacy', 'legality': 'Legal'}, {'format': 'Modern', 'legality': 'Legal'}, {'format': 'Oathbreaker', 'legality': 'Legal'}, {'format': 'Pauper', 'legality': 'Legal'}, {'format': 'Paupercommander', 'lega…http://gatherer.wizards.com/Handlers/Image.ashx?multiverseid=129671&type=card10ETenth Editionfadda48c-6226-5ac5-a2b9-e9170d2017cd
Angelic Wallnormal{1}{W}2['W']['W']Creature — Wallnan['Wall']CommonDefender (This creature can't attack.) Flying"The Ancestor protects us in ways we can't begin to comprehend." —Mystic elderJohn Avon5★04nan['fadda48c-6226-5ac5-a2b9-e9170d2017cd']nannannan['10E', 'AVR', 'M14', 'ODY', 'P02']nannan[{'format': 'Commander', 'legality': 'Legal'}, {'format': 'Duel', 'legality': 'Legal'}, {'format': 'Legacy', 'legality': 'Legal'}, {'format': 'Modern', 'legality': 'Legal'}, {'format': 'Oathbreaker', 'legality': 'Legal'}, {'format': 'Pauper', 'legality': 'Legal'}, {'format': 'Paupercommander', 'lega…nan10ETenth Edition60b93108-8790-591b-844e-c3d311698767
Aura of Silence132127normal{1}{W}{W}3['W']['W']EnchantmentnannanUncommonArtifact and enchantment spells your opponents cast cost {2} more to cast. Sacrifice Aura of Silence: Destroy target artifact or enchantment.Not all silences are easily broken.D. Alexander Gregory6nannannannannan[{'date': '2004-10-04', 'text': 'Aura of Silence affects all opponents in a multiplayer game.'}][{'name': 'Aura des Schweigens', 'text': 'Artefakt- und Verzauberungszaubersprüche, die deine Gegner spielen, kosten beim Ausspielen {2} mehr.\nOpfere die Aura des Schweigens: Zerstöre ein Artefakt oder eine Verzauberung deiner Wahl.', 'type': 'Verzauberung', 'flavor': 'Nicht jede Stille kann man le…['10E', 'C15', 'F02', 'PLST', 'PRM', 'TD0', 'WC98', 'WTH']Artifact and enchantment spells your opponents play cost {2} more to play. Sacrifice Aura of Silence: Destroy target artifact or enchantment.Enchantment[{'format': 'Commander', 'legality': 'Legal'}, {'format': 'Duel', 'legality': 'Legal'}, {'format': 'Legacy', 'legality': 'Legal'}, {'format': 'Modern', 'legality': 'Legal'}, {'format': 'Oathbreaker', 'legality': 'Legal'}, {'format': 'Predh', 'legality': 'Legal'}, {'format': 'Premodern', 'legality': …http://gatherer.wizards.com/Handlers/Image.ashx?multiverseid=132127&type=card10ETenth Editionfac6ad26-f8c2-51bd-9f6a-a1b0940b4cef

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
);

Share link

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