← ALL DATASETS
DATASET / harry_potter_wiki_spells / V20210514

Harry Potter spells (Harry Potter Wiki)

A list of 301 spells compiled from the fan-written Harry Potter Wiki. Each row gives the spell name, its incantation where known, its type, a short effect and the colour of light it produces.

OPEN IN QUERY ↗Harry Potter / fiction / spells / pop culture / Fandom
SOURCEHarry Potter Wiki (Fandom community) ↗
GEOGRAPHYNot applicable (fictional universe)
TIMENot time-based; wiki content as compiled around May 2021
UPDATED2026-11-12

VISUAL EXPLORATION

Table preview is the curated default for this dataset.

TABLE PREVIEW

Loading preview…

METADATA

DATA DICTIONARY

nameName · string · identifier

Spell name; unique in this table.

incantationIncantation · string · dimension

Spoken incantation. 'Unknown' (about a third of rows) and 'None' are the source's own values.

typeType · string · dimension

Spell type such as Charm, Jinx, Curse, Hex or Transfiguration. Some spells list several types.

effectEffect · string · dimension

Short description of what the spell does.

lightLight · string · dimension

Colour or appearance of the light the spell gives off. 'None' is the source's own value; null means not recorded.

PROVENANCE & LIMITATIONS

Kept every row and column of Spells.csv. Input: Spells.csv, extracted unchanged from archive.zip, which the human downloaded from https://www.kaggle.com/datasets/gulsahdemiryurek/harry-potter-dataset on 2026-11-12 (zip SHA-256 676a2c37ee2f6e48407d66769675c77a9eadc25944c7be69e9ee38dd60e6f741; CSV SHA-256 61ee70090fa533320901f4f21161071931e3eed3751724cc1d29828331a10651, 20645 bytes; the file in the archive is dated 2021-05-14, which gives the version folder). The Kaggle page does not name its source; the human identified it as the Harry Potter Wiki, whose page footer reads 'Community content is available under CC-BY-SA unless otherwise noted'. Rows were not re-checked against the live wiki. 301 source rows, 301 published rows, 0 removed. Cleaning: semicolon-delimited CSV with BOM parsed; non-breaking spaces and line breaks inside cells replaced by a space; wiki footnote markers ('[6]', a dangling '[') removed; blank kept as null; values otherwise unchanged, including source typos. The archive's film dialogue files and shortversioncharacters.csv are not published. License CC BY-SA 3.0 (https://www.fandom.com/licensing). This dataset uses material from the Harry Potter Wiki at Fandom (https://harrypotter.fandom.com) and is licensed under the Creative Commons Attribution-Share Alike License 3.0 (Unported). Share-alike: redistribute this dataset and anything derived from it under the same license.

Processing code: pipeline/sources/harry_potter_wiki/process-wiki-tables.py

  • Fan-written wiki content about a fictional work; it is not an official or authoritative source, and the wiki pages may have changed since this file was compiled.
  • Compiled by a third party (Kaggle user gulsahdemiryurek) around May 2021 and not re-checked against the live wiki. Source wording and typos are kept.
  • 'Unknown' or 'None' (source values) and null (not recorded) are different; filter for both when counting missing values.
  • Type and light are free text; a few types are compounds written without a comma (for example 'Transfiguration Jinx').
  • Three incantations (Flipendo, Incendio, Verdimillious) are shared by two spell names each.