entity_citations

Data license: MIT · Data source: jebboone/deitydb

2 rows where entity_id = "ENT_ZOR_AMERETAT"

✎ 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_ZOR_AMERETAT_BUND Ameretat ENT_ZOR_AMERETAT Bundahishn SRC_BUNDAHISHN Bundahishn (Indian recension), trans. E. W. West, Sacred Books of the East vol. 5: Pahlavi Texts Part 1 (Oxford, 1897); ed. J. H. Peterson, avesta.org (CC-BY 4.0), with modernized name spellings ch. 9 Amerodad the archangel, as the vegetation was his own, pounded the plants small, and mixed them up with the water which Tishtar seized, and Tishtar made that water rain down upon the whole earth. E. W. West 1897 https://www.avesta.org/mp/bundahis.html primary-verbatim Amerodad/Amurdad is the Pahlavi form of Ameretat. 2026-09-18 full-text extraction (pdftotext) of the avesta.org edition of West's 1897 translation (public domain); name form in this edition differs from Avestan (alias recorded); chapter fixed from the chapter heading preceding the passage; contiguous-substring gate passed 2 1 primary verbatim (West 1897 via avesta.org); confirm the Pahlavi name = this Avestan entity and the chapter/section  
CIT_ZOR_AMERETAT_SEC Ameretat ENT_ZOR_AMERETAT Bundahishn SRC_BUNDAHISHN Bundahishn Bundahishn 3:         primary-uncited     Track-2 formalization of the entity's existing source attestation (no verbatim quote — pointer + grade + flag) 2 1 Primary source identified but not yet quoted verbatim; the on-page summary is an editorial paraphrase pending verification against this text.  

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