entity_citations

Data license: MIT · Data source: jebboone/deitydb

1 row where entity_id = "ENT_ZOR_VANANT"

✎ 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_VANANT_AV Vanant ENT_ZOR_VANANT Avesta SRC_AVESTA The Zend-Avesta (Darmesteter, SBE) Avesta (Yasht) We sacrifice unto Vanant, the star made by Mazda; for the well-shapen strength, for the Victory, made by Ahura, for the crushing Ascendant, for the destruction of what distresses us, for the destruction of what persecutes us. 'We sacrifice unto Tishtrya, whose eye-sight is sound. James Darmesteter 1883 https://www.avesta.org/ka/yt13sbe.htm primary-verbatim   2026-06-26 name + substring gate against Darmesteter Avesta (avesta.org) 1 1 Located by name in the Yasht (Darmesteter SBE); verify the exact Yasht and stanza.  

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]);