entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_JM_TIFERET"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: verified_on (date)

citation_id ▼ entity_id source_id work_title locus quote translator translation_year source_url evidence_grade evidence_note verified_on verify_method display_order needs_review review_reason original_text_url
CIT_JM_TIFERET_ZOHAR2 Tiferet ENT_JM_TIFERET Zohar SRC_ZOHAR The Zohar (Soncino edition) The Zohar (Soncino edition) The Sefirah Tifereth. BODY. The Sefirah Tifereth. HUSBAND. The divine grade called.Hokmah (Wisdom). ISRAEL. grades. A name given to the highest of the divine CENTRAL PILLAR. A name for the Sef rah Tifereth, JUBILEE. The supernal world; Moses as distinguished from Jacob. which unites the Right and the Left. CHARIOT. That which God directly controls. KING. The highest of the divine grades. CHIEFTAINS. The celestial chiefs and guardians KLIFOTH (lit. Sperling & Simon 1934 None primary-verbatim   2026-06-18 name-anchored (note-keyword scored) + substring gate; locus per attestation 1 1 In-copyright translation — brief flagged excerpt; verify section.  

Advanced export

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

CSV options: 

CREATE TABLE "entity_citations" (
   [citation_id] TEXT PRIMARY KEY,
   [entity_id] TEXT REFERENCES [entities]([entity_id]),
   [source_id] TEXT REFERENCES [sources]([source_id]),
   [work_title] TEXT,
   [locus] TEXT,
   [quote] TEXT,
   [translator] TEXT,
   [translation_year] INTEGER,
   [source_url] TEXT,
   [evidence_grade] TEXT,
   [evidence_note] TEXT,
   [verified_on] TEXT,
   [verify_method] TEXT,
   [display_order] INTEGER,
   [needs_review] INTEGER,
   [review_reason] TEXT,
   [original_text_url] TEXT
);
CREATE INDEX [idx_entity_citations_source_id]
    ON [entity_citations] ([source_id]);
CREATE INDEX [idx_entity_citations_entity_id]
    ON [entity_citations] ([entity_id]);