entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_JM_YESOD"
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_YESOD_KABBAL | Yesod ENT_JM_YESOD | Zohar SRC_ZOHAR | The Kabbalah Unveiled (Zohar: Idras & Siphra Dtzenioutha) | The Kabbalah Unveiled (Zohar: Idras & Siphra Dtzenioutha) | These two produced ISVD, Yesod, the Foundation or Basis, represented by AL ChI, El Chai, the Mighty Living One, and ShDI, Shadddi; and among the angels by AShIM, Aishim, the Flames (Ps. civ. 4), yielding the third Trinity of the Sephiroth. 51. The number 10. From this ninth Sephira came the tenth and last, thus completing the decad of the numbers. | S. L. MacGregor Mathers | 1887 | https://sacred-texts.com/jud/tku/ | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | OCR scan of Mathers Zohar selections, located by name; 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]);