Entities

The core table — every entity in the database, spanning gods, angels, demons, aeons, prophets, saints, heroes, spirits, monsters, personified abstractions, cosmological realms, and ritual categories. Use category to filter by functional type (146 values: Underworld Deity, Hero, Adversarial Being, Revealer Figure, etc.). Use tradition to filter by tradition. The short_note column contains a scholarly description with source citations.

Data license: MIT · Data source: jebboone/deitydb

entity_id
{'description': 'Stable identifier (e.g. ENT_GRK_ZEUS, ENT_EGY_OSIRIS, ENT_ISL_MUSA)'}
canonical_name
{'description': 'Primary English name used in the database'}
greek_name
{'description': 'Greek-script name, where applicable'}
tradition
{'description': 'Religious or cultural tradition of origin'}
entity_class
{'description': 'Controlled top-level kind (19 values: deity, angel, demon, aeon, sefirah, spirit, monster, hero, ruler, prophet, sage, saint, scriptural-figure, abstraction, collective, realm, ritual, title, object) — recommended for filtering by kind'}
entity_type
{'description': 'Granular free-text type descriptor (894 distinct values; see entity_class for the controlled grouping)'}
category
{'description': 'Broader functional category (146 values — recommended for filtering)'}
primary_domains
{'description': 'Primary divine domains, comma-separated'}
evidence_confidence
{'description': 'Sourcing quality: A = direct primary-text attestation; B = strong secondary; C = inference; D = speculative'}
chthonic_flag
{'description': 'True if this entity has underworld or chthonic associations'}
serpent_flag
{'description': 'True if this entity has serpent or dragon associations'}
short_note
{'description': 'Scholarly description with source citations'}

5 rows where entity_class = "collective" and tradition = "Celtic/Irish"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: entity_type, category, cult_scope, evidence_confidence, inclusion_basis, earth_association_score, chthonic_flag

tradition 1

  • Celtic/Irish · 5 ✖

entity_class 1

  • collective · 5 ✖
entity_id ▼ canonical_name greek_name tradition entity_type category primary_domains tags cult_scope primary_period evidence_confidence review_status inclusion_basis earth_association_score chthonic_flag serpent_flag short_note entity_class
ENT_CEL_FOMORIANS Fomorians   Celtic/Irish Mythic adversarial collective Adversarial Being chaos; sea; giants; opposition; monstrous powers   Irish   A candidate_verified_name Celtic adversarial collective 4 1 0 Mythic adversarial beings opposed to the Tuatha Dé Danann. collective
ENT_CEL_TUATHA Tuatha Dé Danann   Celtic/Irish Divine collective Divine Collective divine race; otherworld; magic; sovereignty   Irish   A candidate_verified_name Celtic divine collective 3 0 0 Irish divine/mythic collective. collective
ENT_IRH_AOS_SI The Aos Sí (the síde / fairy folk)   Celtic/Irish collective collective otherworld folk; the síde mounds; the diminished gods   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 The fairy folk of the síde, understood as the diminished Tuatha Dé Danann; the encompassing class of Irish supernatural beings (Ó hÓgáin). collective
ENT_IRH_FOLKLORE Irish Folklore Beings   Celtic/Irish collective collective fairy-belief; otherworld beings; the síde   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Hub grouping for post-medieval Irish folk supernatural beings collected in the folklore record (Ó hÓgáin). collective
ENT_IRH_MILESIANS The Milesians (Sons of Míl / Meic Míled)   Celtic/Irish collective collective final invasion; Gaelic ancestors of the Irish   devotional   C candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 The Gaels, sons of Míl Easpáine, who take Ireland from the Tuatha Dé in the Lebor Gabála Érenn. collective

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "entities" (
   [entity_id] TEXT PRIMARY KEY,
   [canonical_name] TEXT,
   [greek_name] TEXT,
   [tradition] TEXT,
   [entity_type] TEXT,
   [category] TEXT,
   [primary_domains] TEXT,
   [tags] TEXT,
   [cult_scope] TEXT,
   [primary_period] TEXT,
   [evidence_confidence] TEXT,
   [review_status] TEXT,
   [inclusion_basis] TEXT,
   [earth_association_score] INTEGER,
   [chthonic_flag] INTEGER,
   [serpent_flag] INTEGER,
   [short_note] TEXT,
   [entity_class] TEXT REFERENCES [entity_class]([class_id])
);
CREATE INDEX [idx_entities_entity_class]
    ON [entities] ([entity_class]);