← ALL DATASETS
DATASET / harry_potter_wiki_characters / V20210514

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.

OPEN IN QUERY ↗Harry Potter / fiction / characters / pop culture / Fandom
SOURCEHarry Potter Wiki (Fandom community) ↗
GEOGRAPHYNot applicable (fictional universe)
TIMEIn-universe dates; 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

character_idCharacter ID · integer · identifier

Row number assigned by the compiler of the source file (1-140). Not a wiki identifier.

nameName · string · dimension

Full character name as given on the wiki.

genderGender · string · dimension

Gender as stated on the wiki.

jobJob · string · dimension

Occupation or role. Free text; may hold several roles.

houseHouse · string · dimension

Hogwarts house. For a few characters this holds another school (Beauxbatons Academy of Magic, Durmstrang Institute).

wandWand · string · dimension

Wand description as free text, usually length in inches, wood and core. 'Unknown' is the source's own value.

patronusPatronus · string · dimension

Patronus form. 'None', 'Unknown' and 'Non-corporeal' are the source's own values.

speciesSpecies · string · dimension

Species, with any qualifier the source gives in brackets.

blood_statusBlood status · string · dimension

Blood status as stated; uncertain cases read 'Pure-blood or half-blood'. Capitalisation varies.

hair_colourHair colour · string · dimension

Hair colour as free text.

eye_colourEye colour · string · dimension

Eye colour as free text.

loyaltyLoyalty · string · dimension

Groups, people or institutions the character is loyal to.

skillsSkills · string · dimension

Notable skills as free text.

birthBirth · string · dimension

Birth date as written in the source. Often a range or bound such as 'Pre 1964' or '1 September 1979- 31 August 1980'.

birth_yearBirth year · integer · dimension

Birth year, filled only where the birth text is a single date, month-year or year. Ranges, bounds and approximations are null.

deathDeath · string · dimension

Death date as written in the source; null usually means no death is recorded.

death_yearDeath year · integer · dimension

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.