entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_JM_ATIKA_KADISHA"

✎ 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_ATIKA_KADISHA_ZOHAR2 Atika Kadisha ENT_JM_ATIKA_KADISHA Zohar SRC_ZOHAR The Zohar (Soncino edition) The Zohar (Soncino edition) For so we have learnt, that when the Holy One, blessed be He, looks upon the works of men and sees that they are good, then the Ancient Holy One is revealed in the Small of Countenance, and all the countenance of the latter beholds the hidden countenance and is wholly blessed, since they look at one another directly without turning to the right or left, Soncino Zohar, Vayikra, Section 3, Page 15b and they water one another until all worlds are blessed and 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]);