tes3db

the Morrowind npc database

How to use this site.
  • Run Query
    • Select how you want the data to be aggregated:
      • AVG - Results will by sorted by the averages value for the group
      • SUM - Results sorted by the sum total for the group
      • MIN - Results sorted by the smallest/minimum value found in the group
      • MAX - Results sorted by the largest/maximum value gound in the group
      • COUNT - Results sorted by the total number of NPCs in the group
    • Choose which data point you want the aggregation applied to (Level, Health, Intelligence, Long Blade, etc)
    • Select how you want the NPCs to be grouped (Class, Faction, Race, Gender, Expansion)
    • Adjust the minimum number of NPCs you want to include to prevent small groups from skewing the results
    • Expand the filters and un-check anything you want to exclude from the results
    • Click the Run Query button
    • Examples:
      • To find the Average level of NPCs in each Expansion choose: Expansion - AVG - Level
      • To find out which faction has the most bartering gold choose: Faction - SUM - Gold
      • To find out where the luckiest NPC lives choose (spoiler, there's a tie): Location - MAX - Luck
  • Find NPCs
    • Select How many NPC's you want to include in the results
    • Choose which data point you want the NPC's sorted by
    • Expand the filters and un-check anything you want to exclude from the results
    • Click the Find NPCs button
Search the database:
searchable items:
npcs
books
show past updates
Notes about the data:

  • 13,690 NPCs Currently Included in the database from the following game files:
    • Morrowind.esm, Tribunal.esm, and Bloodmoon.esm - GOTY Edition
    • TR_Mainland.esm - 2025-08-12 release Grasping Fortune
    • Cyr_Main.esm - 2025-05-14 release Abecean Shores
    • Sky_Main.esm - 2025-05-05 release Dragonstar
  • Classes are combined with their service offering equivalent by removing the word serivce from the end of class names (eg. Wise Woman Service becomes just Wise Woman, Smith Service -> Smith etc)
  • Class, Race, & Faction names from Project Tamriel mods were altered to be more human readable and match the names from the base game (T_Cyr_MagesGuild -> Mages Guild, TR_Fact_SyvvitTong -> Syvvit Tong)
  • All Khajiit racial variations were converted to Khajiit for now, at some point I will update the data to bring those back in
  • All alterations to the raw data can be found in the SQL file here.
  • tes3conv was used to convert the game files to json so that NPC's could be extracted

See something wrong? Missing data or a bug? Please let me know! [email protected]

Have a popular landmass mod that doesn't conflict with the base game? Let me know and I will include it.

This project is open source https://github.com/anthonylosapio/tes3db

The database has been queried 1400 times