entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_JM_MALKHUT"
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
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]);