Spells in Dungeons and Dragons fit within several categories and their effects are well-documented. This table summarizes all of that information into a long format dataframe for easy navigation. Unless otherwise noted, all spell querying functions in `dndR` use this table as their starting point.
Format
Dataframe with 12 columns and 513 rows
- spell_name
Name of the spell
- spell_source
Source book(s) for that spell with page numbers
- pc_class
Player Character (PC) class(es) that have access to this spell. If multiple classes, each is separated by commas. If a class has a colon and another word next to it (e.g., "cleric: grave") that indicates that only a specific sub-class of that class has access to the spell
- spell_level
Either "cantrip" or the level of spell slot required to cast the spell
- spell_school
School of the spell (e.g., "necromancy", "divination", etc.)
- ritual_cast
Whether the spell can be cast as a ritual expressed as a logical
- casting_time
Time required to cast the spell. Expressed as either the phase of a turn in which the spell can be cast (e.g., "1 action", "bonus action", etc.) or the actual in-game time required
- range
Range at which the spell can be cast
- components
Whether the spell has verbal ("V"), somatic ("S"), and/or material ("M") components required for casting. If material components are required they are described parenthetically
- duration
How long the spell lasts once cast
- description
Full description of the spell. Spells that require the player or Dungeon Master (DM) to roll on a table for an effect have those tables excluded for brevity. Similarly, spells that summon creatures have those creatures' statistics excluded.
- higher_levels
Some spells can be cast using a higher level spell slot for an increased effect. Similarly, damage-dealing cantrips tend to deal more damage as PCs gain levels. This text describes how a spell's effects change with higher spell slot levels or PC levels or is NA for spells that remain constant
Source
Mearls, M. and Crawford, J. Dungeons & Dragons Player's Handbook (Fifth Edition). Wizards of the Coast 2014
System Reference Document (Fifth Edition). Wizards of the Coast 2014
Elemental Evil. Wizards of the Coast 2015
Sword Coast Adventurer’s Guide. Wizards of the Coast 2015
Xanathar’s Guide to Everything. Wizards of the Coast 2017
Guildmasters’ Guide to Ravnica. Wizards of the Coast 2018
Lost Laboratory of Kwalish. Wizards of the Coast 2018
Explorer's Guide to Wildemount. Wizards of the Coast 2020
Icewind Dale: Rime of the Frostmaiden. Wizards of the Coast 2020
Tasha’s Cauldron of Everything. Wizards of the Coast 2020
Fizban's Treasury of Dragons. Wizards of the Coast 2021
From Cyan Depths. Wizards of the Coast 2021
Strixhaven: A Curriculum of Chaos. Wizards of the Coast 2021
A Verdant Tomb. Wizards of the Coast 2021
Astral Adventurer's Guide. Wizards of the Coast 2022