Harry Potter's Second

This dataset provides information about key individuals involved in the Second W

@kaggle.willianoliveiragibin_harry_potters_second

Table List

1 table(7.77 KB)

Second Wizard War Deadoraliveupdated

@kaggle.willianoliveiragibin_harry_potters_second.second_wizard_war_deadoraliveupdated

7.77 KB
29 rows
10 columns

name NAME	blood_status BLOOD STATUS	species Species	gender GENDER	house HOUSE	hair_color HAIR COLOR	boggart BOGGART	patronus PATRONUS	nationality Nationality	alive ALIVE?
Harry Potter	Half-blood	Human	Male	Gryffindor	Jet-black	Dementor	Stag	English	Yes
Minerva McGonagall	Half-blood	Human	Female	Gryffindor	Black	Lord Voldemort	Cat	Scottish	Yes
Kingsley Shacklebolt	Pure-blood	Human	Male	nan	Bald	nan	Lynx	British or Irish	Yes
Aberforth Dumbledore	Half-blood	Human	Male	nan	Grey	nan	Goat	English	Yes
Remus Lupin	Half-blood	Werewolf	Male	Gryffindor	Light brown flecked with grey	Fullÿmoon	Wolf	British or Irish	No
Kreacher	nan	House-elf	Male	nan	White	nan	nan	British	Yes
Lord Voldemort	Half-blood	Human	Male	Slytherin	Bald	His ownÿcorpse	nan	English	No
Bellatrix Lestrange	Pure-blood	Human	Female	Slytherin	Black	nan	nan	British	No
Fenrir Greyback	nan	Werewolf	Male	nan	Grey	nan	nan	British	Unknown
Nymphadora Tonks	Half-blood	Human	Female	Hufflepuff	Mousy Brown	Losing her abilities	Wolf	British	No


CREATE TABLE second_wizard_war_deadoraliveupdated (
  "name" VARCHAR,
  "blood_status" VARCHAR,
  "species" VARCHAR,
  "gender" VARCHAR,
  "house" VARCHAR,
  "hair_color" VARCHAR,
  "boggart" VARCHAR,
  "patronus" VARCHAR,
  "nationality" VARCHAR,
  "alive" VARCHAR
);