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 entity_class to filter by kind (19 controlled values: deity, angel, demon, aeon, sefirah, spirit, monster, hero, etc.). category is free text (1,148 values) and is not a reliable filter. 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 (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'}

7 rows where entity_class = "deity" and tradition = "Sabian/Harranian"

✎ View and edit SQL

This data as json, CSV (advanced)

tradition 1

  • Sabian/Harranian · 7 ✖

entity_class 1

  • deity · 7 ✖
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_HRN_APHRODITE_VENUS Aphrodite (Venus / Ishtar) of Harran   Sabian/Harranian deity planetary deity Venus, love, fortune   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Venus-deity of the heptad, the planet al-Zuhra, identified with Greek Aphrodite and Mesopotamian Ishtar; lesser benefic per the Fihrist and Green. deity
ENT_HRN_ARES_MARS Ares (Mars / Nergal) of Harran   Sabian/Harranian deity planetary deity Mars, war, ill-fortune   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Mars-deity of the heptad, identified with Greek Ares and Mesopotamian Nergal; malefic planet with red-tinged blood rites described in the Fihrist and Green. deity
ENT_HRN_HERMES_MERCURY Hermes-Nabu (Mercury) of Harran   Sabian/Harranian deity planetary deity Mercury, scribal wisdom   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Mercury-deity of the heptad, identified with Greek Hermes and Mesopotamian Nabu; in Harranian thought the planetary Mercury blurs into the prophet-sage Hermes Trismegistus. Distinct entity from the prophet-sage ENT_HRN_HERMES_TRISMEGISTUS below. deity
ENT_HRN_KRONOS_SATURN Kronos (Saturn) of Harran   Sabian/Harranian deity planetary deity Saturn, time, ill-fortune   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Saturn-deity of the heptad, identified with Greek Kronos and Mesopotamian Ninurta/Ninib; black-clad rites attested in the Fihrist and Green. deity
ENT_HRN_SHAMASH_SUN Shamash (the Sun) of Harran   Sabian/Harranian deity planetary deity sun, sovereignty   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 The Sun-deity of the Harranian heptad, continuing Mesopotamian Shamash and identified with Helios; attested via Ibn al-Nadim and analyzed in Green. deity
ENT_HRN_SIN_MOON Sin (the Moon) of Harran [Sabian cult-phase]   Sabian/Harranian deity planetary deity moon, chief deity   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 The Moon-god, supreme deity of Harran whose great temple (E-hulhul) defined the city's identity; the Sabian planetary continuation of the older Aramean/Mesopotamian Sin. Wired to the existing ENT_ARA_SIN_HARRAN and ENT_MES_NANNA_SIN rather than duplicating them. deity
ENT_HRN_ZEUS_JUPITER Zeus (Jupiter / Bel) of Harran   Sabian/Harranian deity planetary deity Jupiter, kingship of heaven   devotional   B candidate_verified_name Roster build via gen_roster.py (see CHANGELOG/git for release) 0 0 0 Jupiter-deity, identified with Zeus/Bel-Marduk; benefic planet of the heptad per Ibn al-Nadim and Green. deity

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