dungeon-craft-data

cd 1d20-1e/csv
sqlite3 my_dc.db
sqlite> .mode csv
sqlite> .import monsters_actions_special.csv monsters_actions_special
sqlite> .import monsters_attacks.csv monsters_attacks
sqlite> .import monsters_items.csv monsters_items
sqlite> .import monsters_traits_base.csv monsters_traits_base
sqlite> .import monsters_traits_special.csv monsters_traits_special
sqlite> .mode list
SELECT name, magic_resistance, race, experience_point_value
FROM monsters_traits_base
WHERE magic_resistance = 0 AND race = 'Daemon';
SELECT mtb.name, mtb.magic_resistance, mtb.race, mtb.experience_point_value, mts.special_ability
FROM monsters_traits_base mtb
LEFT JOIN monsters_traits_special mts
ON mtb.name = mts.name
WHERE mtb.magic_resistance = 0 AND mtb.race = 'Daemon';
SELECT special_ability
FROM monsters_traits_special
WHERE name = 'Guardian Daemon';

These comma separated value files (csv) were derived from Dungeon Craft written by manikus.

https://uaf.sourceforge.net/