entity_citations
Data license: MIT · Data source: jebboone/deitydb
1 row where entity_id = "ENT_ZOR_SRAOSHA"
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_SRAOSHA_BUNDAH | Sraosha ENT_ZOR_SRAOSHA | Bundahishn SRC_BUNDAHISHN | Bundahishn | Bundahishn 30 | Sraosha, the angel who is said specially to protect the world from demons at night; he is usually styled ' the righteous/ and is the special opponent of the demon Aeshm, ' Wrath ' (see Chap. XXX, 29). 3 These are the Avesta names of those two kinds of dog (see Chap. XIV, 19). 74 BUNDAHIST. ness, among those which are in the nature (altih) of man and of animals. 35. | E. W. West (Sacred Books of the East 5) | 1880 | https://archive.org/details/pahlavitexts01westuoft | primary-verbatim | 2026-06-18 | name-anchored (note-keyword scored) + substring gate; locus per attestation | 1 | 1 | OCR scan, located by name; verify wording and exact chapter against a clean edition. |
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]);