Harry Potter characters (Harry Potter Wiki)
A lookup table of 140 characters from the Harry Potter series, compiled from the fan-written Harry Potter Wiki. Good for practising grouping, text matching and working with free-text and multi-value fields.
VISUAL EXPLORATION
Table preview is the curated default for this dataset.
TABLE PREVIEW
Loading preview…
METADATA
DATA DICTIONARY
Row number assigned by the compiler of the source file (1-140). Not a wiki identifier.
Full character name as given on the wiki.
Gender as stated on the wiki.
Occupation or role. Free text; may hold several roles.
Hogwarts house. For a few characters this holds another school (Beauxbatons Academy of Magic, Durmstrang Institute).
Wand description as free text, usually length in inches, wood and core. 'Unknown' is the source's own value.
Patronus form. 'None', 'Unknown' and 'Non-corporeal' are the source's own values.
Species, with any qualifier the source gives in brackets.
Blood status as stated; uncertain cases read 'Pure-blood or half-blood'. Capitalisation varies.
Hair colour as free text.
Eye colour as free text.
Groups, people or institutions the character is loyal to.
Notable skills as free text.
Birth date as written in the source. Often a range or bound such as 'Pre 1964' or '1 September 1979- 31 August 1980'.
Birth year, filled only where the birth text is a single date, month-year or year. Ranges, bounds and approximations are null.
Death date as written in the source; null usually means no death is recorded.
Death year, filled only where the death text is a single date, month-year or year.
PROVENANCE & LIMITATIONS
Kept every row and column of Characters.csv. Added birth_year and death_year, filled only where the birth or death text is a single date, month-year or year. Input: Characters.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 f4533121f7e0d84044d4f952360bd8c709d188eb66b67dea0fe045465ed74504, 26945 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. 140 source rows, 140 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.
- The selection of 140 characters is the compiler's and is not documented, so counts describe this table rather than the whole series.
- Most characters have wand and patronus recorded as 'Unknown'; eye colour, loyalty and house are blank for a large share of rows.
- Many fields are free text with inconsistent wording and capitalisation (for example 'Blonde' and 'Blond').
- birth_year and death_year cover only exact dates; most students have a birth range and therefore no birth_year.