Entities

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 (934 distinct values; see entity_class for the controlled grouping)'}

category

{'description': 'Free-text functional category (1,148 distinct values, not normalised — filter on entity_class instead)'}

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'}

158 rows where entity_class = "saint" and tradition = "Christian"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Next page

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]);