entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_JM_MALKHUT"

✎ 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_MALKHUT_ZOHAR2 Malkhut ENT_JM_MALKHUT Zohar SRC_ZOHAR The Zohar (Soncino edition) The Zohar (Soncino edition) This is why Adam, who is Israel, is closely linked with the Torah, of which it is said, "It is a tree of life to those who take hold on it"; this tree is the Matron, the Sefirah Malkhuth (Kingship), through their connection with which Israel are called "sons of kings". On this account God said, "It is not good that the man should be alone; I will make him an help meet for him" (Gen. II, 18). 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]);