Let's try to have an updated thread with the state of all EQ2 data currently available in Census, including known bugs and oversights. Items marked in red are bugged or on our wishlist. Constants (link) Adventure Class List -- provides complete map of archetypes, classes, and subclasses by ID with Alternate Advancement Tree numbers for each. Alignments Equipment Slot List -- internal and human-readable names (and slot ids in two different numbering schemes) for equipment slots. General Spell Property List -- Human-readable names for nearly 100 spell effects. Language List -- Master language list with IDs. Petkey List -- Beastlord pet types with pet IDs and Beastlord AA IDs. Race List -- Master list of races with IDs. Reforging Constants List -- Conversion ratios for stats which are either the source or destination of Reforging. Skill List -- Distinct list of required skills. Most are not visible in-game, however some are crucial to properly displaying weapon wield type and handedness: Adorning, Axe, Bow, Buckler, Crushing, Dagger, Fists, Focus, Greataxe, Greathammer, Greatspear, Greatsword, Hammer, Kiteshield, Mace, Piercing, Ranged, Rapier, Roundshield, Slashing, Staff, Sword, Thrownweapon, Tinkering, Towershield, Tradeskill Class -- Breakdown of tradeskill classes and subclasses. Tradeskill Property List -- Decoder for Tradeskill skills. Character Character data is incredibly mature. It includes Alternate Advancements (current and saved profiles), Prestige Points, Equipment Slot Items with Reforging, Refining, Infusing, Experimentation, and Adornments all reflected. Ascension Class List & XP, Resists, Quest and Collection counts, Achievements, Primary and secondary Tradeskills, Mounts, Combat Stats, PvP and PvE Stats, Race, Gender, House List, Skills, Factions, and known Languages. Character Misc Active Quest Journal, Completed Quests, Collection Progress, and Known Recipes are stored in a separate collection to keep each /character/ export from growing any bigger. Mercenary Hired mercenaries, including their Stats, Equipment Slots, Name, and Class are now available. Headshot & Paperdoll Paperdoll images (updated on camp/zone) and Headshot images (updated every hour) are available in Census for all exported characters.Items Item data is the most mature collection in EQ2 Census. Adventure & Apperance Sets Swappable Gear Sets are fully supported in Census. Spells Spell data is largely complete, although some values such as Range, Accuracy, and Target are still missing. Spell data includes Character Spells, AAs, and Ascension spells. It does not include Class Focus or Racial Traits. Character Spell data is exported off a level 100 character with almost no equipment, stats, or buffs. AA spell data seems to be exported off a level 0 character, so the numbers are next to useless. Factions Faction data is complete and contains Faction ID, Name, Category, and Min/Max amounts. Alternate Advancements Alternate Advancement data is complete, including Prestige abilities. WISH: The spell data should be the base data, not slightly altered from the export process. This makes any calculations off. BUG: The AA spell data typically gives a range of 1-1 instead of the expected minumum to maximum amounts. Marketplace Items Marketplace data is complete. Quests Quest data is complete. BUG: Quest data is missing complex item rewards, conditional item rewards (predicates on itemtables), mysterycrates, etc. BUG: Quest data is missing minimum level, quest starter, and starting zone information. Collections Collection data is complete. Recipes Recipe data is complete. WISH: Recipes should include Byproducts, and the Progress required to complete the craft. NOTE: Recipe components are given as an Item Name. Recipes accept ingredients based on classifications rather than a specific item, which is how several different kinds of water, plus canine saliva, can all be used for a recipe requiring "liquid".