World Of Warcraft Avatar History

Track the players of this popular online game

@kaggle.mylesoneill_warcraft_avatar_history

Table List

3 tables(59.59 MB)

Locations

Wowah Data

Zones

Zones

@kaggle.mylesoneill_warcraft_avatar_history.zones

15.38 KB
160 rows
13 columns

zone_name Zone Name	continent Continent	area Area	zone Zone	subzone Subzone	type Type	controlled Controlled	min_req_level Min Req Level	min_rec_level Min Rec Level	max_rec_level Max Rec Level	min_bot_level Min Bot Level	max_bot_level Max Bot Level
Durotar	Kalimdor	Central Kalimdor	Durotar	nan	Zone	Horde	1	1	10	1	10
The Barrens	Kalimdor	Central Kalimdor	The Barrens	nan	Zone	Contested	1	10	35	10	35
Silverpine Forest	Eastern Kingdoms	Lordaeron	Silverpine Forest	nan	Zone	Horde	1	10	20	10	20
Stonetalon Mountains	Kalimdor	Central Kalimdor	Stonetalon Mountains	nan	Zone	Contested	1	25	30	25	30
Thunder Bluff	Kalimdor	Central Kalimdor	Thunder Bluff	nan	City	Horde	1	1	100	1	100
Dustwallow Marsh	Kalimdor	Central Kalimdor	Dustwallow Marsh	nan	Zone	Contested	1	35	40	35	40
Orgrimmar	Kalimdor	Central Kalimdor	Durotar	Orgrimmar	City	Horde	1	1	100	1	100
Undercity	Eastern Kingdoms	Lordaeron	Tirisfal Glades	Undercity	City	Horde	1	1	100	1	100
Ashenvale	Kalimdor	Northern Kalimdor	Ashenvale	nan	Zone	Contested	1	20	25	20	25
Stranglethorn Vale	Eastern Kingdoms	Azeroth	Stranglethorn Vale	nan	Zone	Contested	1	30	50	30	50


CREATE TABLE zones (
  "zone_name" VARCHAR,
  "continent" VARCHAR,
  "area" VARCHAR,
  "zone" VARCHAR,
  "subzone" VARCHAR,
  "type" VARCHAR,
  "size" DOUBLE,
  "controlled" VARCHAR,
  "min_req_level" BIGINT,
  "min_rec_level" DOUBLE,
  "max_rec_level" DOUBLE,
  "min_bot_level" DOUBLE,
  "max_bot_level" DOUBLE
);