As part of our research with HALO SE, we investigated how achievements were awarded in the popular MMORPG, World of Warcraft. We published our findings in our paper, A Large-Scale, Longitudinal Study of User Profiles in World of Warcraft. The data was gathered between September 29, 2011 and October 14, 2011 and contains “complete” records for approximately 6 million characters, and basic information for another 6 million. For the “complete” characters, we have populated each of the below tables for those characters. For the “partial” characters, we have populated only the “Toon” table.
Our institution, Columbia University has now decided to make this data publicly available under the following license.
Note: “World of Warcraft” ©2004 Blizzard Entertainment, Inc. All rights reserved. World of Warcraft, Warcraft and Blizzard Entertainment are trademarks or registered trademarks of Blizzard Entertainment, Inc. in the U.S. and/or other countries.
If you use this dataset in a publication, we ask that you cite our WiC publication:
@inproceedings{Bell:2013:LLS:2487788.2488146,
author = {Bell, Jonathan and Sheth, Swapneel and Kaiser, Gail},
title = {A large-scale, longitudinal study of user profiles in world of warcraft},
booktitle = {Proceedings of the 22nd international conference on World Wide Web companion},
series = {WWW '13 Companion},
year = {2013},
isbn = {978-1-4503-2038-2},
location = {Rio de Janeiro, Brazil},
pages = {1175--1184},
numpages = {10},
url = {http://dl.acm.org/citation.cfm?id=2487788.2488146},
acmid = {2488146},
publisher = {International World Wide Web Conferences Steering Committee},
address = {Republic and Canton of Geneva, Switzerland},
keywords = {user profiles, video games, virtual worlds, web information mining, world of warcraft},
}
Dataset Description
This dataset is organized in a set of MySQL tables. A description of each of the tables follows:
Table: Achievement
Metadata about each achievement
Fields:
- Id
- Category
- Description
- Points
- Title
- Rewarditem_id
Table: Achievement_category
Metadata about achievement categories
Fields:
- Id
- Parent_id
- Name
Table: Achievementprogress
Records for each achievement completed by each character
Fields:
- Created (timestamp of when the achievement was earned; second granularity)
- Achievement_id
- Toon_id
Table: Guild
Basic information for each guild.
Fields:
- Id
- Server
- Name
Table: Pclass
Metadata for player classes
Fields:
- Id
- Name
Table: Prace
Metadata for player races
Fields:
- Id
- Name
- Side (e.g. alliance or horde)
Table: Profession
Metadata for each profession
Fields:
- Id
- Name
Table: Quest
Metadata for each quest
Fields:
- Bnet_id
- Havedata
- Id
- Title
- Reqlevel
- Suggestedpartymembers
- Category
- Level
Table: Quest_category
Categories for quests
Fields:
- Id
- Name
- Type
Table: Raid
Metadata for each raid
Fields:
- Id
- Name
Table: Raidboss
Metadata for each raid boss
Fields:
- Id
- Name
- Raid_id
Table: Raidbossprogress
For each raid boss killed by each character, the number of times that character has killed that boss
Fields:
- Heroic
- Normal
- Toon_id
- Raidboss_id
Table: Raidprogress
For each raid completed by each character, the number of times that character has completed that raid
Fields:
- Heroic
- Normal
- Raid_id
- Toon_id
Table: Reputationsink
For each group that a character may have a reputation with, the metadata for that reputation group
Fields:
- Id
- Name
Table: Reputationstanding
For each character, their reputation standing with each group
Fields:
- Max
- Standing
- Value
- Toon_id
- Sink_id
Table: Server
Metadata about servers
Fields:
- Id
- Fullname
- Name
- Region
- Slug
- Population
- Type
Table: Spell
Metadata about spells
Fields:
- Bnet_id
- Companion
- Mount
- Name
- Id
Table: Title
Metadata about titles
Fields:
- Id
- Name
Table: Toon
Information about each character crawled. Does not include character names
Fields:
- Id
- Archaelogylevel
- Achievementpoints
- Cookinglevel
- Explored
- Firstaidlevel
- Fishinglevel
- Grank
- Pclass
- Pgender
- Plevel
- Prace
- Guild_id
- Prof1_id
- Prof2_id
- Prof1level
- Prof2level
- Selectedtitle_id
- Server_id
Table: Toon_quest
Contains a record for every tuple of (character, completed quest)
Fields:
- Toon_id
- Questsdone_id
Table: Toon_spell
Contains a record for every tuple of (character, spell that is known by that character)
Fields:
- Toon_id
- Spell_id
Table: Toon_title
Contains a record for each tuple of (character, title that is available to that character)
Fields:
- Toon_id
- Titles_id
Download links
For each of the above documented tables, please find a link to download it below. Each GZIP archive consists of a SQL script that generates the table and loads the data. It is up to you to setup a capable MySQL server. We provide no warranty or support.
Achievement (<5MB)
Achievement_category (<5MB)
Achievementprogress (12GB download; 19GB uncompressed)
Guild (<5MB)
Pclass (<5MB)
Prace (<5MB)
Profession (<5MB)
Quest (<5MB)
Quest_category (<5MB)
Raid (<5MB)
Raidboss (<5MB)
Raidbossprogress (2GB download; 7GB uncompressed)
Raidprogress (511MB download; 2.1GB uncompressed)
Reputationsink (<5MB)
Reputationstanding (2GB download; 6GB uncompressed)
Server (<5MB)
Spell (<5MB)
Title (<5MB)
Toon (170MB download; 1.2GB uncompressed)
Toon_quest (17GB download; 56GB uncompressed)
Toon_spell (450MB download; 1.2GB uncompressed)
Toon_title (50MB download; 160MB uncompressed)